SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 10 hours agomuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comimagemessage-square172fedilinkarrow-up1538
arrow-up1538imagemuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comSchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 10 hours agomessage-square172fedilink
minus-squareeasily3667@lemmus.orglinkfedilinkEnglisharrow-up112·6 hours ago60k is laughably, embarrassingly small. It’s still sqlite-sized.
minus-squaremorrowind@lemmy.mllinkfedilinkarrow-up31·4 hours agoSqlite can easily handle millions of rows. Don’t sell it short
minus-squareThe_Decryptor@aussie.zonelinkfedilinkEnglisharrow-up1·37 minutes agoHow about a 6.4TB sqlite database? https://boyter.org/posts/searchcode-bigger-sqlite-than-you/
minus-squareKorhaka@sopuli.xyzlinkfedilinkEnglisharrow-up1·2 hours agoI have an sqlite db that is a few GB in size, game saves using the format. Sadly almost all blob data, would love to play with it if it was a bit more readable
minus-squarenaught@sh.itjust.workslinkfedilinkarrow-up46·5 hours agoi mean its even excel sized depending on how many columns. This is seriously sad and alarming
60k is laughably, embarrassingly small. It’s still sqlite-sized.
60k is single json file
Sqlite can easily handle millions of rows. Don’t sell it short
How about a 6.4TB sqlite database?
https://boyter.org/posts/searchcode-bigger-sqlite-than-you/
I have an sqlite db that is a few GB in size, game saves using the format. Sadly almost all blob data, would love to play with it if it was a bit more readable
i mean its even excel sized depending on how many columns. This is seriously sad and alarming