Skip Navigation
Posts
2
Comments
12
Joined
2 yr. ago
  • Does logseq have tagging and an ability to query like data view in obsidian?

  • 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.

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

  • 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.

  • What function or class from that library would I use to do this? Or what key words can I use to search and learn more? I'm struggling wrapping my head around it.

  • Do you happen to have any examples? I'm just not sure how to convert the JSON example into a bulk query since I need to keep the reference and line detail associated to the header. There is no primary key across all 3 sections. It's generated when I insert into the database.

  • Python @sh.itjust.works
    imperator @sh.itjust.works

    Dealing with Databases - Inserting, Updating Etc.

    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
  • Definitely interesting, but until you can follow a thread or community it's definitely gimmicky.

  • I'll wait for a big sale. Buy it, play for an hour then probably forget about it.

  • My work is all windows too. I work in Finance so Linux unfortunately won't work. But at home I'm all Linux!

  • Games @sh.itjust.works
    imperator @sh.itjust.works

    Linux Gamers?

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

  • Run Arch on my main PC. Proxmox on my home server with Ubuntu server as VM and random containers.