Post AMnj2C9evIhPdFJuOO by alexandra@mk.nixnet.social
(DIR) More posts by alexandra@mk.nixnet.social
(DIR) Post #AMnj2Bj4W9QqImsfx2 by alexandra@mk.nixnet.social
2022-08-20T18:44:15.629Z
0 likes, 0 repeats
: dateFri Apr 24 21:00:00 EDT 2381: unameLinux: echo $SHELL/bin/qsh: sqlite3SQLite version 3.788.1 2381-02-24 14:16:38Enter ".help" for usage hints.Connected to a transient in-memory database.Use ".open FILENAME" to reopen on a persistent database.sqlite>
(DIR) Post #AMnj2C9evIhPdFJuOO by alexandra@mk.nixnet.social
2022-08-20T18:49:54.292Z
0 likes, 0 repeats
I would not be surprised if, after being thrown a few decades or centuries into the future (which to be clear would be surprising), I discovered SQLite still in active useI would only be moderately surprised to find it in a thousand years
(DIR) Post #AMnj2Cdn7Gnn8hPyMK by roadriverrail@signs.codes
2022-08-21T23:46:06Z
0 likes, 0 repeats
@alexandra I mean, it just fills a niche so well. You get SQL level semantics and the portability of files. And, sure it might not be ideal at institutional scale, but few things seek that.See also JSON.
(DIR) Post #AMnj2DJGd3ylDKp60W by alilly@solarpunk.moe
2022-08-22T00:23:50Z
0 likes, 1 repeats
@roadriverrail (replying on my new account) One of the biggest reasons is that SQLite puts a lot of effort deliberately into longevity. The code is carefully written for maintainability and the format is documented in exacting byte-for-byte detail, and the group that maintains it has specifically made it a goal to avoid potential risks to their continuing ability to maintain the code. As I see it, SQLite will probably be around at least as long as our operating systems run C code and have files.
(DIR) Post #AMnj2EkbGvR9gOcRFY by alilly@solarpunk.moe
2022-08-22T00:26:02Z
0 likes, 0 repeats
@roadriverrail Their stated LTS policy has SQLite 3 still actively supported in 2050.