imperator

joined 1 year ago
[–] [email protected] 5 points 1 year ago

2 decades, this game is about 20 years old

[–] [email protected] 2 points 1 year ago (1 children)

Does logseq have tagging and an ability to query like data view in obsidian?

[–] [email protected] 6 points 1 year ago

Interesting. I find that Lemmy seems to have picked up a lot of the bad. Too many memes, very shallow discussions. Maybe I'm just not in the right communities.

[–] [email protected] 1 points 1 year ago

Looks like Kiss the Ground

[–] [email protected] 2 points 1 year ago (2 children)

There is a really interesting documentary on Netflix about this. Definitely worth a watch.

[–] [email protected] 2 points 1 year ago

Makes you wonder is they'll kill MCC to try and push players to infinite which has much more monetization.

[–] [email protected] 2 points 1 year ago

You'll want to look at z wave or ZigBee. Then control with home assistant.

Hue is I recall is ZigBee so you can control with home assistant.

[–] [email protected] 1 points 1 year ago

You can tie Google home into home assistant. It's pretty much the best way to control your home. It's super flexible as well. There is a learning curve. But it's a lot easier than it was a couple years ago.

[–] [email protected] 2 points 1 year ago

Lol. I'm also looking at hot. Here we go.

[–] [email protected] 1 points 1 year ago (1 children)

Can you run this not having a public facing page?

[–] [email protected] 4 points 1 year ago (3 children)

Yup. Started the Witcher 3 end of last year. Finished Kingdom Come Deliverance. Also play a lot of total war Time 2 and Attila.

[–] [email protected] 8 points 1 year ago

Yeah, I built a new PC at the beginning of the pandemic and went Linux. I don't even not windows and play all my games on there.

 

Wondering if anyone here has some advise or a good place to learn about dealing with databases with Python. I know SQL fairly well for pulling data and simple updates, but running into potential performance issues the way I've been doing it. Here are 2 examples.

  1. Dealing with Pandas dataframes. I'm doing some reconciliation between a couple of different datasources. I do not have a primary key to work with. I have some very specific matching criteria to determine a match. The matching process is all built within Python. Is there a good way to do the database commits with updates/inserts en masse vs. line by line? I've looked into upsert (or inserts with clause to update with existing data), but pretty much all examples I've seen rely on primary keys (which I don't have since the data has 4 columns I'm matching on).

  2. Dealing with JSON files which have multiple layers of related data. My database is built in such a way that I have a table for header information, line level detail, then third level with specific references assigned to the line level detail. As with a lot of transactional type databases there can be multiple references per line, multiple lines per header. I'm currently looping through the JSON file starting with the header information to create the primary key, then going to the line level detail to create a primary key for the line, but also include the foreign key for the header and also with the reference data. Before inserting I'm doing a lookup to see if the data already exists and then updating if it does or inserting a new record if it doesn't. This works fine, but is slow taking several seconds for maybe 100 inserts in total. While not a big deal since it's for a low volume of sales. I'd rather learn best practice and do this properly with commits/transactions vs inserting an updating each record individually within the ability to rollback should an error occur.

 

Just curious if anyone else here primarily games on Linux? Steam Deck counts!

view more: next ›