IRC channel logs

2024-05-29.log

back to list of logs

<sneek>Yey! dsmith is back :D
<dsmith>sneek, botsnack
<sneek>:)
<gnucode>totally off the wall question...
<gnucode>It sounds like Kent oversteet based bcachefs on a database...I would if we could use postgresql to make a filesystem...? It's possible that's a really bad idea.
<gnucode>no idea
<nikolar>Try sqlite
<nikolar>Seems better suited for fs
<nikolar>Actually that's what I wanted to try :)
<gnucode>nikolar: really? My understanding of sqlite...it that is slower.
<nikolar>well you can't exactly turn postgress from a server oriented, bagillion file using, database into an fs
<nikolar>sqlite is a single file
<nikolar>so there's a massive difference alread
<gnucode>"sqlite is a single file" --> what does that mean?
<nikolar>it means that it stores all of it's data within a single file?
<nikolar>and there's an extension mechanism to add support for VFSs which you should be able to abuse to get it to store data onto a raw disk
<nikolar>and we're talking about using databases as filesystem, they ain't going to be fast
<gnucode>oh really? a filesystem baked by a database will have the tradeoff of being slow? I didn't actually know that...
<nikolar>well you don't control most of the stack
<nikolar>so yeah, i'd expect it to be slow
<nikolar>if i ever write a fuse driver for this, i'll let you know (unless i forget lol)
<gnucode>It seems like maybe a bad idea to store all date in one file?
<gnucode>sounds like a plan.
<nikolar>gnucode: it doesn't
<nikolar>it has its uses
<nikolar>and sqlite is perfectly capable of working with terrabytes of data without issues
<gnucode>hmmm. I had always thought that if you want to build a "large scale" web application (TB of data, thousands of connections)...then use postgresql
<gnucode>sqlite is just not robust enough.
<gnucode>I'm an enthusiast as well. Not an expert. :)
<nikolar>sqlite capable and robust until you get to the level of like google or something
<nikolar>where the maximum databases size becomes a limit
<gnucode>also Samuel merged Sergey's "serverboot v2" RFC into the wiki
<gnucode> https://darnassus.sceen.net/~hurd-web/open_issues/serverbootv2/
<nikolar>(about 250tb i think for sqlite)
<gnucode>250 TB is quite a large limit!
<nikolar>yeah exactly
<gnucode>sneek: later tell solid_black https://darnassus.sceen.net/~hurd-web/open_issues/serverbootv2/
<sneek>Okay.