Shakedown Social

NiklasTurso 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.]<a href="https://github.com/tursodatabase/turso" rel="nofollow noopener" translate="no" target="_blank">https://github.com/tursodatabase/turso</a><a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a> <a href="https://mastodon.social/tags/Databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#Databases</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Hacker NewsSQLite async connection pool for high-performance<a href="https://github.com/slaily/aiosqlitepool" rel="nofollow noopener" translate="no" target="_blank">https://github.com/slaily/aiosqlitepool</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/async" class="mention hashtag" rel="nofollow noopener" target="_blank">#async</a> <a href="https://mastodon.social/tags/connection" class="mention hashtag" rel="nofollow noopener" target="_blank">#connection</a> <a href="https://mastodon.social/tags/pool" class="mention hashtag" rel="nofollow noopener" target="_blank">#pool</a> <a href="https://mastodon.social/tags/high" class="mention hashtag" rel="nofollow noopener" target="_blank">#high</a>-performance <a href="https://mastodon.social/tags/aiosqlitepool" class="mention hashtag" rel="nofollow noopener" target="_blank">#aiosqlitepool</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a>

((Jann Gobble)) 🏳️‍🌈<a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/vacuum" class="mention hashtag" rel="nofollow noopener" target="_blank">#vacuum</a> only works if you spell it right... 😂 <a href="https://mastodon.social/@siracusa" class="u-url mention" rel="nofollow noopener" target="_blank">@siracusa</a>

adamghillColophon for <a href="https://beesocial.dev" rel="nofollow noopener" translate="no" target="_blank">https://beesocial.dev</a> for anyone interested: <a href="https://beesocial.dev/colophon" rel="nofollow noopener" translate="no" target="_blank">https://beesocial.dev/colophon</a>.No vibe coding, just good vibes.<a href="https://indieweb.social/tags/Django" class="mention hashtag" rel="nofollow noopener" target="_blank">#Django</a> <a href="https://indieweb.social/tags/Tailwind" class="mention hashtag" rel="nofollow noopener" target="_blank">#Tailwind</a> <a href="https://indieweb.social/tags/TailwindCSS" class="mention hashtag" rel="nofollow noopener" target="_blank">#TailwindCSS</a> <a href="https://indieweb.social/tags/HTMX" class="mention hashtag" rel="nofollow noopener" target="_blank">#HTMX</a> <a href="https://indieweb.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://indieweb.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a>

obrhoffFor the DB gurus: Is it wise to model a playlist in a SQLite database as a linked list? I don’t want to have to mutate all entries when, for example, I just want to change the order of items.But I also feel that recursively fetching the items to follow the list could impact performance for playlists with a lot of items. <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/softwaredevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#softwaredevelopment</a> <a href="https://mastodon.social/tags/softwareengineering" class="mention hashtag" rel="nofollow noopener" target="_blank">#softwareengineering</a>

obrhoffThey 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. <a href="https://mastodon.social/tags/wwdc25" class="mention hashtag" rel="nofollow noopener" target="_blank">#wwdc25</a> <a href="https://mastodon.social/tags/iosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#iosdev</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>

Pragmatic Bookshelf 📚Thrilled to offer our newest distribution title: Northwind Elixir Traders by Isaak TsalicoglouNot your typical programming tutorial. This immersive, project-based adventure reimagines the classic Northwind database, guiding you through Ecto’s migrations, changesets, and queries to model data with real-world edge. <a href="https://pragprog.com/titles/d-itnet?utm_source=m" rel="nofollow noopener" translate="no" target="_blank">https://pragprog.com/titles/d-itnet?utm_source=m</a> <a href="https://techhub.social/tags/Ecto" class="mention hashtag" rel="nofollow noopener" target="_blank">#Ecto</a> <a href="https://techhub.social/tags/ElixirLang" class="mention hashtag" rel="nofollow noopener" target="_blank">#ElixirLang</a> <a href="https://techhub.social/tags/Elixir" class="mention hashtag" rel="nofollow noopener" target="_blank">#Elixir</a> <a href="https://techhub.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Chris TrottNew blog post: Caveats Using Read-only SQLite Databases from the App Bundle<a href="https://twocentstudios.com/2025/06/07/sql-databases-bundle/" rel="nofollow noopener" translate="no" target="_blank">https://twocentstudios.com/2025/06/07/sql-databases-bundle/</a>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;"`.<a href="https://hachyderm.io/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://hachyderm.io/tags/grdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#grdb</a>

nixCraft 🐧Test Postgres in Python Like SQLite : A <a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> 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.<a href="https://github.com/wey-gu/py-pglite" rel="nofollow noopener" translate="no" target="_blank">https://github.com/wey-gu/py-pglite</a><a href="https://mastodon.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>

WikiMusic ProjectThe WikiMusic project proudly announces the v0.5.2 release 🎵 <a href="https://codeberg.org/jjba23/wikimusic" rel="nofollow noopener" translate="no" target="_blank">https://codeberg.org/jjba23/wikimusic</a>the <a href="https://mastodon.social/tags/foss" class="mention hashtag" rel="nofollow noopener" target="_blank">#foss</a> <a href="https://mastodon.social/tags/music" class="mention hashtag" rel="nofollow noopener" target="_blank">#music</a> <a href="https://mastodon.social/tags/knowledge" class="mention hashtag" rel="nofollow noopener" target="_blank">#knowledge</a> <a href="https://mastodon.social/tags/encyclopaedia" class="mention hashtag" rel="nofollow noopener" target="_blank">#encyclopaedia</a> We now have auto <a href="https://mastodon.social/tags/scroll" class="mention hashtag" rel="nofollow noopener" target="_blank">#scroll</a> for music <a href="https://mastodon.social/tags/tabs" class="mention hashtag" rel="nofollow noopener" target="_blank">#tabs</a>, in an efficient and smooth way and many UI improvements (this will be great for <a href="https://mastodon.social/tags/musicians" class="mention hashtag" rel="nofollow noopener" target="_blank">#musicians</a> that want to perform live with the support of <a href="https://mastodon.social/tags/wikimusic" class="mention hashtag" rel="nofollow noopener" target="_blank">#wikimusic</a>)powered by <a href="https://mastodon.social/tags/guile" class="mention hashtag" rel="nofollow noopener" target="_blank">#guile</a> <a href="https://mastodon.social/tags/scheme" class="mention hashtag" rel="nofollow noopener" target="_blank">#scheme</a> <a href="https://mastodon.social/tags/artanis" class="mention hashtag" rel="nofollow noopener" target="_blank">#artanis</a> <a href="https://mastodon.social/tags/lisp" class="mention hashtag" rel="nofollow noopener" target="_blank">#lisp</a> <a href="https://mastodon.social/tags/tailwind" class="mention hashtag" rel="nofollow noopener" target="_blank">#tailwind</a> <a href="https://mastodon.social/tags/css" class="mention hashtag" rel="nofollow noopener" target="_blank">#css</a> <a href="https://mastodon.social/tags/hygguile" class="mention hashtag" rel="nofollow noopener" target="_blank">#hygguile</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/guix" class="mention hashtag" rel="nofollow noopener" target="_blank">#guix</a> <a href="https://mastodon.social/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#selfhosting</a> visit my instance at: <a href="https://wikimusic.jointhefreeworld.org/songs" rel="nofollow noopener" translate="no" target="_blank">https://wikimusic.jointhefreeworld.org/songs</a>

Ben BarnettI'm looking for people to try out a new version of Base, my SQLite editor for macOS.If you'd like to give it a go, send me a private message with your email address (only used for TestFlight, no junk). Boosts appreciated.<a href="https://mastodon.social/tags/macosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#macosdev</a> <a href="https://mastodon.social/tags/macos" class="mention hashtag" rel="nofollow noopener" target="_blank">#macos</a> <a href="https://mastodon.social/tags/TestFlight" class="mention hashtag" rel="nofollow noopener" target="_blank">#TestFlight</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>

ScottFirst post might as well be my pinned post! A link to my web projects and a blog, which is mostly about webdev and gaming.<a href="https://scott.itsasite.uk" rel="nofollow noopener" translate="no" target="_blank">https://scott.itsasite.uk</a>I discovered Mastodon though editing my profile on Itch.io lol. Now I can fill in that field, yay xD.<a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#WebDev</a> <a href="https://mastodon.social/tags/SoloDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#SoloDev</a> <a href="https://mastodon.social/tags/GameDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#GameDev</a> <a href="https://mastodon.social/tags/HobbyDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#HobbyDev</a> <a href="https://mastodon.social/tags/JavaScript" class="mention hashtag" rel="nofollow noopener" target="_blank">#JavaScript</a> <a href="https://mastodon.social/tags/Blogging" class="mention hashtag" rel="nofollow noopener" target="_blank">#Blogging</a> <a href="https://mastodon.social/tags/Blog" class="mention hashtag" rel="nofollow noopener" target="_blank">#Blog</a> <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Henrik SchönemannHeya lovely people 👋 For <a href="https://fedihum.org/tags/SciOp" class="mention hashtag" rel="nofollow noopener" target="_blank">#SciOp</a> we (<a href="https://fedihum.org/@SafeguardingResearch" class="u-url mention" rel="nofollow noopener" target="_blank">@SafeguardingResearch</a>) are looking for dev contributions. There are a couple of bite-/morsel-sized tasks, e.g.: - Make Publisher independent table <a href="https://codeberg.org/Safeguarding/sciop/issues/341" rel="nofollow noopener" translate="no" target="_blank">https://codeberg.org/Safeguarding/sciop/issues/341</a> - Improve SearchableMixin to support full text search on joined items <a href="https://codeberg.org/Safeguarding/sciop/issues/182" rel="nofollow noopener" translate="no" target="_blank">https://codeberg.org/Safeguarding/sciop/issues/182</a> - and more: <a href="https://codeberg.org/Safeguarding/sciop/projects/17078" rel="nofollow noopener" translate="no" target="_blank">https://codeberg.org/Safeguarding/sciop/projects/17078</a>The stack is <a href="https://fedihum.org/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> (fastapi) + htmx, <a href="https://fedihum.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> (sqlmodel), "low-fi, standards-compliant html and almost no js"Be a part of <a href="https://fedihum.org/tags/SafeguardingResearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#SafeguardingResearch</a>, join us!

WikiMusic Projectv0.3.7 release - <a href="https://mastodon.social/tags/wikimusic" class="mention hashtag" rel="nofollow noopener" target="_blank">#wikimusic</a><a href="https://codeberg.org/jjba23/wikimusic" rel="nofollow noopener" translate="no" target="_blank">https://codeberg.org/jjba23/wikimusic</a>the <a href="https://mastodon.social/tags/foss" class="mention hashtag" rel="nofollow noopener" target="_blank">#foss</a> <a href="https://mastodon.social/tags/music" class="mention hashtag" rel="nofollow noopener" target="_blank">#music</a> <a href="https://mastodon.social/tags/knowledge" class="mention hashtag" rel="nofollow noopener" target="_blank">#knowledge</a> <a href="https://mastodon.social/tags/encyclopaedia" class="mention hashtag" rel="nofollow noopener" target="_blank">#encyclopaedia</a>we now support connections between songs - artists - genres, also PDF music sheet support, dark mode, and much more (even more to come)powered by <a href="https://mastodon.social/tags/guile" class="mention hashtag" rel="nofollow noopener" target="_blank">#guile</a> <a href="https://mastodon.social/tags/scheme" class="mention hashtag" rel="nofollow noopener" target="_blank">#scheme</a> <a href="https://mastodon.social/tags/artanis" class="mention hashtag" rel="nofollow noopener" target="_blank">#artanis</a> <a href="https://mastodon.social/tags/lisp" class="mention hashtag" rel="nofollow noopener" target="_blank">#lisp</a> <a href="https://mastodon.social/tags/tailwind" class="mention hashtag" rel="nofollow noopener" target="_blank">#tailwind</a> <a href="https://mastodon.social/tags/css" class="mention hashtag" rel="nofollow noopener" target="_blank">#css</a> <a href="https://mastodon.social/tags/hygguile" class="mention hashtag" rel="nofollow noopener" target="_blank">#hygguile</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>visit my instance at : <a href="https://wikimusic.jointhefreeworld.org" rel="nofollow noopener" translate="no" target="_blank">https://wikimusic.jointhefreeworld.org</a>

Dariusz RybickiExcited to share Linkmarks – a native <a href="https://mastodon.social/tags/iOS" class="mention hashtag" rel="nofollow noopener" target="_blank">#iOS</a> and <a href="https://mastodon.social/tags/macOS" class="mention hashtag" rel="nofollow noopener" target="_blank">#macOS</a> app I recently built with <a href="https://mastodon.social/tags/SwiftUI" class="mention hashtag" rel="nofollow noopener" target="_blank">#SwiftUI</a> and <a href="https://mastodon.social/tags/TCA" class="mention hashtag" rel="nofollow noopener" target="_blank">#TCA</a>! Effortlessly save and organize your web links, with <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> for local storage and seamless <a href="https://mastodon.social/tags/iCloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#iCloud</a> sync across devices. <a href="https://mastodon.social/tags/indiedev" class="mention hashtag" rel="nofollow noopener" target="_blank">#indiedev</a> <a href="https://mastodon.social/tags/BuildInPublic" class="mention hashtag" rel="nofollow noopener" target="_blank">#BuildInPublic</a> Try it out: <a href="https://linkmarks.darrarski.pl/" rel="nofollow noopener" translate="no" target="_blank">https://linkmarks.darrarski.pl/</a>

obrhoffGRDB seems the way to go. Anyone got experience with shipping a custom SQLite build to load extensions? <a href="https://github.com/groue/GRDB.swift/discussions/1591" rel="nofollow noopener" translate="no" target="_blank">https://github.com/groue/GRDB.swift/discussions/1591</a><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/swift" class="mention hashtag" rel="nofollow noopener" target="_blank">#swift</a> <a href="https://mastodon.social/tags/iosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#iosdev</a> <a href="https://mastodon.social/tags/macosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#macosdev</a>

obrhoffWhat I really liked about RealmDB is the ability to subscribe to DB change.Whats the best way to replicate this with Swift Concurrency? AsyncStream + SQLite Triggers? <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/swift" class="mention hashtag" rel="nofollow noopener" target="_blank">#swift</a> <a href="https://mastodon.social/tags/iosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#iosdev</a> <a href="https://mastodon.social/tags/macosdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#macosdev</a>

Amᵃᵖandaoh boy, `spatialite` doesn't use a geographic index? You need to do this complicated nested queries to use it?🤯🤯🤯Maybe I need to switch to <a href="https://en.osm.town/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgis</a> <a href="https://en.osm.town/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://en.osm.town/tags/gis" class="mention hashtag" rel="nofollow noopener" target="_blank">#gis</a> <a href="https://en.osm.town/tags/spatialite" class="mention hashtag" rel="nofollow noopener" target="_blank">#spatialite</a>

Preston Maness ☭Ok. Just culled ~20,000 of 25,000 <a href="https://tenforward.social/tags/tumblr" class="mention hashtag" rel="nofollow noopener" target="_blank">#tumblr</a> posts accumulated via <a href="https://tenforward.social/tags/RSS" class="mention hashtag" rel="nofollow noopener" target="_blank">#RSS</a> 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 <a href="https://tenforward.social/tags/thunderbird" class="mention hashtag" rel="nofollow noopener" target="_blank">#thunderbird</a> add-on, or try some other approach. I really, really want to be able to use <a href="https://tenforward.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> for this stuff. It's a natural fit. But <a href="https://tenforward.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> seems to be a no-go for <a href="https://tenforward.social/tags/WebExtensions" class="mention hashtag" rel="nofollow noopener" target="_blank">#WebExtensions</a>. There is only <a href="https://tenforward.social/tags/IndexedDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#IndexedDB</a>, which, in my limited experience with it, is absolute garbage to work with.

chipiguay - Pablo 😴Heavy lifting is done by <a href="https://hostux.social/tags/astropy" class="mention hashtag" rel="nofollow noopener" target="_blank">#astropy</a> and <a href="https://hostux.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>. Might work on a rust version of this in the future, which actually motivated the come up!

Recent searches

Search options

Administered by:

Server stats:

#sqlite