shakedown.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A community for live music fans with roots in the jam scene. Shakedown Social is run by a team of volunteers (led by @clifff and @sethadam1) and funded by donations.

Administered by:

Server stats:

266
active users

#sqlite

2 posts2 participants0 posts today

Turso is the second database project (that I know of) to come out of Finland. It's mission is to become a better drop-in replacement for SQLite. Seems fascinating, will definitely keep an eye on it.

[Aside: The name stands for either an octopus or a mythical sea beast from Finnish folklore.]

github.com/tursodatabase/turso

Turso Database is a project to build the next evolution of SQLite. - tursodatabase/turso
GitHubGitHub - tursodatabase/turso: Turso Database is a project to build the next evolution of SQLite.Turso Database is a project to build the next evolution of SQLite. - tursodatabase/turso

They mentioned in the WWDC that the new LLM Framework can support semantic search. So what is now the best approach to locally search through a SQLite database?

AFAIK SwiftData is not supporting Vector embeddings and compiling a SQLite version with extensions is not so straightforward.
#wwdc25 #iosdev #sqlite

New blog post: Caveats Using Read-only SQLite Databases from the App Bundle

twocentstudios.com/2025/06/07/

A quick debugging story where I learnan some new things about SQLite's journal mode while building an database export/import feature for Eki Live.

TLDR:

- Journal mode is embedded in the sqlite database file itself.
- The `backup` command changes the journal mode of the target database to match the source database.
- Check the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode;"`.
- Change the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode=DELETE;"`.

twocentstudios.comCaveats Using Read-only SQLite Databases from the App Bundle

Test Postgres in Python Like SQLite : A #Python testing library that provides seamless integration between PGlite and Python test suites. Get the full power of PostgreSQL in your tests without the overhead of a full PostgreSQL installation.

github.com/wey-gu/py-pglite

GitHubGitHub - wey-gu/py-pglite: PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite.PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite

The WikiMusic project proudly announces the v0.5.2 release 🎵

codeberg.org/jjba23/wikimusic

the #foss #music #knowledge #encyclopaedia

We now have auto #scroll for music #tabs, in an efficient and smooth way and many UI improvements (this will be great for #musicians that want to perform live with the support of #wikimusic)

powered by #guile #scheme #artanis #lisp #tailwind #css #hygguile #sqlite #guix #selfhosting

visit my instance at: wikimusic.jointhefreeworld.org

Ok. Just culled ~20,000 of 25,000 #tumblr posts accumulated via #RSS over a month. I've gotta get to work on my own project applying basic statistics to this stuff. Think "reverse chronological + $all_your_own_filtering_and_sorting_and_bucketing". Not sure if I should do that within the confines of a #thunderbird add-on, or try some other approach. I really, really want to be able to use #sql for this stuff. It's a natural fit. But #sqlite seems to be a no-go for #WebExtensions. There is only #IndexedDB, which, in my limited experience with it, is absolute garbage to work with.