Alice Averlong🏳️‍⚧️Mar 8

Is there something like mongodb/couchdb that does the sqlite philiosophy of an in-process database that's just saved out to a file?

I need to convert a python program to store some data in a database and I'd rather not deal with SQL.

Show threadAlice Averlong🏳️‍⚧️

I mean I could always build a small wrapper around an SQLite database I stuff JSON into

but I'd rather not have to

Mar 8 at 8:36pmWeb
Show threadAlice Averlong🏳️‍⚧️Mar 8
I just stared at my database schema and went "I don't really want to write another INSERT (...) INTO TABLE_BLAH VALUES(?,?,?); statement. I've done my time
Show threadSamael Mar 8

@foone

It could be worse, you could be working with mnesia and erlang. (Which I love, don't get me wrong, it's just a really weird db.)

Show threadOriel Jutty Mar 8
@foone That's why perl 3 gave us dbmopen()! https://perldoc.perl.org/functions/dbmopen
dbmopen - Perldoc Browser

Show threadHugo MillsMar 8
@foone This is the thinking that leads to the eldritch horrors of ORM frameworks.
Show threadAlice Averlong🏳️‍⚧️Mar 8
@darkling yeah I messed with those once in college and my reaction was "why would I do this, I can just write SQL?"
Show threadSolar GranulationMar 8

@foone I keep getting ads for some AI BS with a tagline like "write SQL you'll love" and just, what? No. Fuck off.

I write my own SQL tysvm. And it's good SQL that does the job as efficiently as the gods-awful database I work with allows.

I reduced overhead by 99.6% using SQL that I wrote.

I just detest this trend. It's mind numbing.

... got a bit ranty there, sorry.

Show threadLisPiMar 9

@darkling @foone I don't think so, in better languages it leads to things like these. The sheer instability of Python is probably why no one has bothered.

Persistent objects predate SQL as a concept.

"why would I do this, I can just write SQL?"

As for why? It can outperform SQL<->object conversion (including when you do it manually with optimizations an ORM couldn't safely do) by magnitudes when done well.

GitHub - CodyReichert/awesome-cl: A curated list of awesome Common Lisp frameworks, libraries and other shiny stuff.

A curated list of awesome Common Lisp frameworks, libraries and other shiny stuff. - CodyReichert/awesome-cl

GitHub
Show threadUnlikelyLassMar 8

@foone Would rocksDB work for what you want?

https://rocksdb.org/

RocksDB | A persistent key-value store

RocksDB is an embeddable persistent key-value store for fast storage.

RocksDB
Show thread⊥ᵒᵚ Cᵸᵎᶺᵋᶫ∸ᵒᵘ ☑️Mar 8
@foone just write JSON to disk and be done with it then? Hard to know what your constraints are.
Show threadDavid LeadbeaterMar 8
@foone https://github.com/Jwink3101/jsonlitedb is one example of roughly that wrapper, although I’ve not used it (I have my own based on some of the ideas in my post at https://dgl.cx/2020/06/sqlite-json-support). I actually mostly use key/value DBs where I can (often leveldb, as it’s simple and has cross language implementations, but the other ones people have pointed out are reasonable choices too).
GitHub - Jwink3101/jsonlitedb: SQLite3-backed JSON document database with support for indices and advanced queries

SQLite3-backed JSON document database with support for indices and advanced queries - Jwink3101/jsonlitedb

GitHub
Show threadAlice Averlong🏳️‍⚧️Mar 9
@dgl ooh I think this might be exactly what I need, thanks