Anybody know any other file based database technologies like sqlite besides sqlite? Struggled to find any if they exist, my google-fu sucks

a bunch of csv-files.

but the question is: why do you need it? IMHO sqlite perfectly covers the few use cases where an embedded file-based database is needed.

@tosensei I’m also looking for such thing. I have a bunch of data which is structured but with a lot of optional structured child data. Storing that data would require about 35 tables and joins. Storing it locally in a document database would be much better.

Doesn't exist from my research.

The closest thing I have found is redis configured with an append file.

Use SQLite. It's better than you think.

Even tried to roll my own for a couple weeks before I realized I was just recreating SQLite and just used it.

Yeah I mean if you like Json backed like databases essentially got Mondodb

So no.

@tosensei and it's open source
Any problem with the SQLite libraries is the only allow one at one user to have write access at a time

@tosensei ps every single time we agree on something it really does feel like a piece of my soul is dying

Lmdb

But aren't, like, all the databases file-based?

@lorentz relevant: https://news.ycombinator.com/item/...

@op: https://quora.com/What-is-SQLites-m...

Search for "embedded databases"

I don't know enough to recommend any but there seems to be a bunch

I prefer SQLite as an arbitrary file format. I have abused it to store raw data in the hundreds of megabytes. I also use it to store project specific config options.

@AvatarOfKaine well, if your use case requires multiple users to access it at the same time, you are using THE wrongest possible tool for the job. saying "single-user only" is a flaw of local-file based databases is like saying "you get wet" is a flaw of taking a shower.

@AvatarOfKaine also: don't worry. your soul already is dead.

@tosensei or it could be the same application is running different threads or processes trying to access the same portable database file

@tosensei also why are you people not doing anything new ?

@tosensei just be good already and skip credit card payments and bypass bills you feel are unfair until the system gets fixed Jesus

And maybe live life rough for a little bit

Defy these little pathetic chomo shits that prop.up this system and ride by smiling emptily like their.fucking braindead keeping up the outward appearance that everything is still reasonable and force things to be reasonable by forcing them to fucking work and suffer until they agree to a better way

@AvatarOfKaine "same application running different threads" - it's YOUR job as programmer to make your code threadsafe. that includes i/o.

really, it's only a problem if you suck.

also: why aren't _you_ doing anything new and start taking your meds?

@tosensei that is up to debate. I don't see why you couldn't start a small process that manages the open database and remains open until the last client exits..

Because in a sense you'd have to do that anyway for every application with multiple threads or processes anyway.

@tosensei also: the more we repeat these this the more it appears tosensei need the meds
I'm not perfect or free of emotional trauma but the things people such as yourself call me crazy for are overt lies