Mastouille

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 noreferrer" translate="no" target="_blank">https://twocentstudios.com/2025/06/07/sql-databases-bundle/</a>A quick debugging story where I learned 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 noreferrer" target="_blank">#sqlite</a> <a href="https://hachyderm.io/tags/grdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#grdb</a>

Howard Chu @ SymasAn overview of <a href="https://mastodon.social/tags/LumoSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LumoSQL</a> - the successor to SQLightning, which replaced <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>'s b+tree code with <a href="https://mastodon.social/tags/LMDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LMDB</a> <a href="https://www.xugj520.cn/en/archives/lumosql-sqlite-enhancement-database.html?amp=1" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.xugj520.cn/en/archives/lumosql-sqlite-enhancement-database.html?amp=1</a>

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

Neustradamus :xmpp: :linux:<a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Roundcube</a> 1.6.11 (stable) has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Webmail</a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Mail</a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IMAP</a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SMTP</a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LDAP</a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Managesieve</a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OracleDB</a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQL</a>) <a href="https://roundcube.net/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://roundcube.net/</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 noreferrer" target="_blank">#macosdev</a> <a href="https://mastodon.social/tags/macos" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#macos</a> <a href="https://mastodon.social/tags/TestFlight" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TestFlight</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

Alejandro BaezAnd <a href="https://fosstodon.org/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> continues to be my everything analytics thing. 😅 <a href="https://fosstodon.org/tags/ducklake" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ducklake</a> simply cements this. Basically use <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>, <a href="https://fosstodon.org/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a>, or <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a>. 😏If I need more, I have to think REAL hard what I can't accomplish with sharding. 😁<a href="https://duckdb.org/2025/05/27/ducklake.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/05/27/ducklake.html</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 noreferrer" 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 noreferrer" target="_blank">#WebDev</a> <a href="https://mastodon.social/tags/SoloDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SoloDev</a> <a href="https://mastodon.social/tags/GameDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GameDev</a> <a href="https://mastodon.social/tags/HobbyDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HobbyDev</a> <a href="https://mastodon.social/tags/JavaScript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#JavaScript</a> <a href="https://mastodon.social/tags/Blogging" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Blogging</a> <a href="https://mastodon.social/tags/Blog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Blog</a> <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>

TYPO3 CMSLearn how to build and manage micro sites with TYPO3! The first in a two-part blog series showcasing how TYPO3 can deliver value for personal websites and smaller projects. Learn more: <a href="https://typo3.com/blog/using-typo3-for-small-projects" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://typo3.com/blog/using-typo3-for-small-projects</a> <a href="https://typo3.social/tags/typo3" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#typo3</a> <a href="https://typo3.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://typo3.social/tags/contentmanagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#contentmanagement</a> <a href="https://typo3.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://typo3.social/tags/typo3cms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#typo3cms</a>

Markus 🤓✨Uuuh, news on the <a href="https://hachyderm.io/tags/litestream" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#litestream</a> front for <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>! <a href="https://fly.io/blog/litestream-revamped/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://fly.io/blog/litestream-revamped/</a>

Markus 🤓✨I just merged <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> support in my (originally only <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>) persistent message queue library for <a href="https://hachyderm.io/tags/GoLang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GoLang</a>! 🥳Gonna do a bit more manual testing before cutting a release, but the tests are all good.<a href="https://github.com/maragudk/goqite" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/maragudk/goqite</a>

Henrik SchönemannHeya lovely people 👋 For <a href="https://fedihum.org/tags/SciOp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SciOp</a> we (<a href="https://fedihum.org/@SafeguardingResearch" class="u-url mention" rel="nofollow noopener noreferrer" 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 noreferrer" 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 noreferrer" 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 noreferrer" 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 noreferrer" target="_blank">#python</a> (fastapi) + htmx, <a href="https://fedihum.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" 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 noreferrer" target="_blank">#SafeguardingResearch</a>, join us!

Dariusz RybickiExcited to share Linkmarks – a native <a href="https://mastodon.social/tags/iOS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#iOS</a> and <a href="https://mastodon.social/tags/macOS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#macOS</a> app I recently built with <a href="https://mastodon.social/tags/SwiftUI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SwiftUI</a> and <a href="https://mastodon.social/tags/TCA" class="mention hashtag" rel="nofollow noopener noreferrer" 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 noreferrer" target="_blank">#SQLite</a> for local storage and seamless <a href="https://mastodon.social/tags/iCloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#iCloud</a> sync across devices. <a href="https://mastodon.social/tags/indiedev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#indiedev</a> <a href="https://mastodon.social/tags/BuildInPublic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#BuildInPublic</a> Try it out: <a href="https://linkmarks.darrarski.pl/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://linkmarks.darrarski.pl/</a>

AskUbuntuWhat is the proper setup for installing Drupal on Ubuntu 24.04 LTS? <a href="https://ubuntu.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://ubuntu.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://ubuntu.social/tags/drupal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#drupal</a><a href="https://askubuntu.com/q/1547669/612" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://askubuntu.com/q/1547669/612</a>

VZIt feels good to finally make a new <a href="https://fosstodon.org/tags/release" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#release</a> of another <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> C++ library whose maintenance I've inherited: SOCI provides API for accessing different kinds of databases in the same way, see <a href="https://soci.sourceforge.net/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://soci.sourceforge.net/</a> for more information and the announcement post (in which I've managed to make a typo, of course...) at <a href="https://sourceforge.net/p/soci/mailman/message/59183493/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://sourceforge.net/p/soci/mailman/message/59183493/</a> for the details about the changes in the latest version.<a href="https://fosstodon.org/tags/CPlusPlus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CPlusPlus</a> <a href="https://fosstodon.org/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a> <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/Firebird" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Firebird</a> <a href="https://fosstodon.org/tags/ODBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ODBC</a> <a href="https://fosstodon.org/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Oracle</a>

David BissetTwo neat <a href="https://phpc.social/tags/email" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#email</a> tools for email nerds:<a href="https://github.com/terhechte/postsack" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/terhechte/postsack</a> "Postsack" visually cluster your emails by sender, domain, etc.<a href="https://github.com/marcboeker/gmail-to-sqlite" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/marcboeker/gmail-to-sqlite</a> "Gmail to <a href="https://phpc.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>" download emails from <a href="https://phpc.social/tags/Gmail" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Gmail</a> and stores them in a SQLite database for further analysis.<a href="https://phpc.social/tags/Rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Rust</a> <a href="https://phpc.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://phpc.social/tags/Webtools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Webtools</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 noreferrer" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/swift" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#swift</a> <a href="https://mastodon.social/tags/iosdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#iosdev</a> <a href="https://mastodon.social/tags/macosdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#macosdev</a>

Amᵃᵖanda 🔜 CFCoh 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 noreferrer" target="_blank">#postgis</a> <a href="https://en.osm.town/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://en.osm.town/tags/gis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gis</a> <a href="https://en.osm.town/tags/spatialite" class="mention hashtag" rel="nofollow noopener noreferrer" 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 noreferrer" target="_blank">#tumblr</a> posts accumulated via <a href="https://tenforward.social/tags/RSS" class="mention hashtag" rel="nofollow noopener noreferrer" 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 noreferrer" 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 noreferrer" 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 noreferrer" target="_blank">#sqlite</a> seems to be a no-go for <a href="https://tenforward.social/tags/WebExtensions" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebExtensions</a>. There is only <a href="https://tenforward.social/tags/IndexedDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndexedDB</a>, which, in my limited experience with it, is absolute garbage to work with.

alexanderadam<a href="https://social.lansky.name/@hn50" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@hn50</a><a href="https://ruby.social/@fractaledmind" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@fractaledmind</a> you're everywhere now if <a href="https://ruby.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> is in the game, aren't you? 😅

blaixFull, working example of using sqlite with the pretty nice, full stack, gren web framework:<a href="https://github.com/blaix/prettynice/tree/main/examples/v3/database" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/blaix/prettynice/tree/main/examples/v3/database</a><a href="https://hachyderm.io/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://hachyderm.io/tags/gren" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gren</a> <a href="https://hachyderm.io/tags/FunctionalProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FunctionalProgramming</a>

Recherches récentes

Options de recherche

Administré par :

Statistiques du serveur :

#sqlite