lil5 🚲 🇳🇱<p>Rescript Reasonably Typed<br><a href="https://rescript-reasonably-typed.netlify.app/reference/better-sqlite-3/readme/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">rescript-reasonably-typed.netl</span><span class="invisible">ify.app/reference/better-sqlite-3/readme/</span></a></p><p><a href="https://social.linux.pizza/tags/rescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rescript</span></a> ffi bindings to <a href="https://social.linux.pizza/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
Recent searches
No recent searches
Search options
Not available on mastodon.xyz.
mastodon.xyz is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance, open to everyone, but mainly English and French speaking.
Administered by:
Server stats:
739active users
mastodon.xyz: About · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.3.4
#sqlite
10 posts · 9 participants · 3 posts today
lil5 🚲 🇳🇱<p><span class="h-card" translate="no"><a href="https://indieweb.social/@jbz" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>jbz</span></a></span> Why use a different database than the one true database: <a href="https://social.linux.pizza/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
Kees N ✅<p><span class="h-card" translate="no"><a href="https://writing.exchange/@paulk" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>paulk</span></a></span> <br>These days, I see no reason at all to use anything else than <a href="https://toot.community/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> for personal projects. SQLite is good at eating their own dog food: SQLite uses the fossil-scm repository software, which is SQLite based too. Fossil also supports forum, chat and ticketing.</p><p><a href="https://sqlite.org/whentouse.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite.org/whentouse.html</span><span class="invisible"></span></a></p><p><a href="https://fossil-scm.org/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">fossil-scm.org/</span><span class="invisible"></span></a></p>
Paul Kater<p>And again I wonder when it's smart to use MySQL and when is SQLite better...<br>I'm not running anything huge on my own computer and moving stuff around over machines with SQLite is a lot easier...</p><p>🤔 </p><p><a href="https://writing.exchange/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://writing.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://writing.exchange/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a></p>
Lazy beardude<p>I actually like this form of code contribution. If I was the main dev of my project, I get to choose which part of code that somebody contributed and then I can either incorporate some or all parts of their code or modify it to my needs and/or wants without having to worry about contributors wanting some form of recognition, or I could just outright reject it if it doesn't fit.</p><p><a href="https://odysee.com/@BrodieRobertson:5/open-source-software-isn't-open-to:5" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">odysee.com/@BrodieRobertson:5/</span><span class="invisible">open-source-software-isn't-open-to:5</span></a></p><p><a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://mastodon.social/tags/nvidia" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nvidia</span></a> <a href="https://mastodon.social/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>linux</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a></p>
Alejandro Baez<p>Found out about <a href="https://fosstodon.org/tags/redka" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>redka</span></a> recently. A <a href="https://fosstodon.org/tags/redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>redis</span></a> implementation using <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> or <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a>. 😁 </p><p>I've adapted to using embedded cache libraries. Until redis is a must. 😅 This may make that embed cache less necessary when using <a href="https://fosstodon.org/tags/golang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>golang</span></a>. 😉</p><p><a href="https://github.com/nalgeon/redka" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/nalgeon/redka</span><span class="invisible"></span></a></p>
Samuel Chase<p><span class="h-card" translate="no"><a href="https://social.masto.host/@njoseph" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>njoseph</span></a></span> <a href="https://fantastic.earth/tags/perl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>perl</span></a>, <a href="https://fantastic.earth/tags/commonlisp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commonlisp</span></a>, <a href="https://fantastic.earth/tags/openbsd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openbsd</span></a>, <a href="https://fantastic.earth/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> fit the bill here.</p>
JP Mens<p>Redka aims to reimplement the core parts of <a href="https://mastodon.social/tags/Redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Redis</span></a> with SQL [<a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a>, <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a>], while remaining compatible with Redis API.</p><p><a href="https://github.com/nalgeon/redka" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/nalgeon/redka</span><span class="invisible"></span></a></p>
obrhoff<p>One of the things I would like to see in the future is getting this SQLite extension to work in combination with the new Foundation model. I’ve seen some people successfully build their own SQLite version that allows loading extensions (the Apple version does not allow this).</p><p>So, if you are able to get a working SQLite version, would it be possible to generate embeddings with the new Foundation models?<br><a href="https://mastodon.social/tags/iosdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>iosdev</span></a> <a href="https://mastodon.social/tags/genai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>genai</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://mastodon.social/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>llm</span></a> <a href="https://mastodon.social/tags/swift" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>swift</span></a> <a href="https://mastodon.social/tags/AppleIntelligence" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AppleIntelligence</span></a></p><p><a href="https://github.com/asg017/sqlite-vec" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/asg017/sqlite-vec</span><span class="invisible"></span></a></p>
JP Mens<p>TIL about the sqlean project, which brings <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> extensions together, neatly packaged into domain modules, documented, tested, and built for Linux, Windows and macOS. Something like a standard library in Python or Go, only for SQLite.</p><p><a href="https://antonz.org/sqlean/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">antonz.org/sqlean/</span><span class="invisible"></span></a></p><p>and a boatload of extensions browsable at <a href="https://sqlpkg.org/all/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlpkg.org/all/</span><span class="invisible"></span></a></p>
The BadgeFed Project<p>We are VERY excited about all the features landing in the next release! However, we’re also introducing one big breaking change—and that’s the purpose of this post. WE ENCOURAGE EVERYONE USING BADGEFED TO CREATE A DATABASE BACKUP BEFORE UPGRADING.</p>
<p>(GO, do it now, we will wait for you and then continue reading this post.)</p>
<p>Don’t worry: if you forget, chances are you won’t lose data, but recovery may be trickier. If you can, please back up first.</p>
<p><strong>Summary (read before upgrading)</strong></p>
<ul>
<li>Database filenames now match your domain, for example: <code>mydomain.db</code>. The previous single default filename is no longer used by default.</li>
<li>Back up your existing SQLite file NOW. You can also download a backup from the admin portal: Admin > Database > Download Backup.</li>
<li>After upgrading to 0.1.1, the app uses a per-domain database. Use the import utility to migrate from your backup—or copy your backup into the data directory and rename it to the domain-based filename.</li>
<li>Prefer one shared database? Set the environment variable <code>SQLITE_DB_PATH</code> to your desired (or current) filename (for example, <code>badgefed.db</code>).</li>
</ul>
<p><strong>If you already upgraded without preparing</strong></p>
<ul>
<li>Your previous database was not replaced or deleted. Locate your old <code>badgefed.db</code> (or backup), copy it to the data directory, and rename it to the new domain-based filename.</li>
</ul>
<p>The 0.1.1 release and full release notes are coming soon!</p>
<p>Badge up!</p>
<br> <p>You can read the article "BadgeFed 0.1.1 — Breaking change: per-domain database filenames" by <a href="https://hachyderm.io/users/mapache" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>mapache</span></a> <a href="https://badgefed.vocalcat.com/post/07-breaking-changes/" rel="nofollow noopener noreferrer" target="_blank">here</a> as well.</p> <a href="https://badgefed.vocalcat.com/tags/badgefed" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>badgefed</span></a> <a href="https://badgefed.vocalcat.com/tags/fediverse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fediverse</span></a> <a href="https://badgefed.vocalcat.com/tags/openbadges" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openbadges</span></a> <a href="https://badgefed.vocalcat.com/tags/update" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>update</span></a> <a href="https://badgefed.vocalcat.com/tags/activitypub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>activitypub</span></a> <a href="https://badgefed.vocalcat.com/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://badgefed.vocalcat.com/tags/federation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>federation</span></a>
Carlo Zottmann<p>Yesterday, I set up a personal <a href="https://norden.social/tags/forgejo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>forgejo</span></a> (<a href="https://forgejo.org" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">forgejo.org</span><span class="invisible"></span></a>) instance on my VPS. It was refreshingly simple.</p><p>I love that the default is <a href="https://norden.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> which is more than enough for a private instance. Forgejo looks good. I'm currently only using it as a backup/mirror of some of my GitHub repos. I sure wish my current ticketing & project planning tool <a href="https://norden.social/tags/Linear" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Linear</span></a> would support git sites other than GitHub/GitLab…</p>
PuercoPop<p>Dear <a href="https://mastodon.social/tags/lazyweb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>lazyweb</span></a>, I'm running into have flaky tests in the persistent extension <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> extension I'm writing. Unsure how to debug. The error is happening when loading the same dynamic library in an in-memory database as part of the test setup. Any ideas on how to pin point the difference between successful runs and unsuccessful runs?<br><a href="https://mastodon.social/tags/rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rust</span></a> <a href="https://mastodon.social/tags/rustlang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rustlang</span></a> <a href="https://mastodon.social/tags/rusqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rusqlite</span></a> </p><p><a href="https://paste.sr.ht/~puercopop/5c8626e7540f6bea750c1c3054f3ddd27228ca2b" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">paste.sr.ht/~puercopop/5c8626e</span><span class="invisible">7540f6bea750c1c3054f3ddd27228ca2b</span></a></p>
Helge Heß<p>The <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> Extension Hub, haven't seen that before: <a href="https://sqlpkg.org" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlpkg.org</span><span class="invisible"></span></a></p>
Menel :xmpp:So I always pronounced Sqlite like: Sq-Lite.<br>But just now I read it in my mind like SQL-ite, with a different pronunciation.<br><br>How do you pronounce it?<br><br><a href="https://snikket.de/social?t=sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://snikket.de/social?t=poll" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#POLL</a><br>
Guillaume Tronix :python: :emacs: :nix: :linux:<p>Immich update lets users reset PIN, improves OAuth migration and album sync</p><p>Immichv1.138.0 introduces new self-service security features, including the ability for users to reset their own PIN codes by entering their current password.</p><p><a href="https://alternativeto.net/news/2025/8/immich-update-lets-users-reset-pin-improves-oauth-migration-and-album-sync/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">alternativeto.net/news/2025/8/</span><span class="invisible">immich-update-lets-users-reset-pin-improves-oauth-migration-and-album-sync/</span></a></p><p><a href="https://infosec.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a></p>
The BadgeFed Project<p>Hey Fediverse! 👋</p>
<p>We’ve been quiet… but not idle. Forget waiting for long blog posts, time for micro updates.</p>
<p>Today’s news:</p>
<p>We’ve got a few BadgeFed instances live and federating! 🏅</p>
<p>To make it happen, we did a hardcore backend rewrite to support <strong>multiple domains on a single machine</strong>.
For most, it’s a niche cost-saving move, but it might be useful for others too. Under the hood: each domain runs its own SQLite DB, with backups in place.</p>
<p>But this isn’t just about the tech, the fun part is seeing multiple BadgeFed servers talking to each other (!!). Follow them, check the thread, boost it, and watch for more as they come online!</p>
<br> <p>You can read the article "BadgeFed Update: Multiple Instances Online!" by <a href="https://hachyderm.io/users/mapache" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>mapache</span></a> <a href="https://badgefed.vocalcat.com/post/06-instances-online/" rel="nofollow noopener noreferrer" target="_blank">here</a> as well.</p> <a href="https://badgefed.vocalcat.com/tags/badgefed" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>badgefed</span></a> <a href="https://badgefed.vocalcat.com/tags/fediverse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fediverse</span></a> <a href="https://badgefed.vocalcat.com/tags/openbadges" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openbadges</span></a> <a href="https://badgefed.vocalcat.com/tags/update" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>update</span></a> <a href="https://badgefed.vocalcat.com/tags/activitypub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>activitypub</span></a> <a href="https://badgefed.vocalcat.com/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://badgefed.vocalcat.com/tags/federation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>federation</span></a>
LinuxNews.de<p>Syncthing 2.0 veröffentlicht<br><a href="https://linuxnews.de/syncthing-2-0-veroeffentlicht/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxnews.de/syncthing-2-0-ver</span><span class="invisible">oeffentlicht/</span></a> <a href="https://social.anoxinon.de/tags/syncthing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>syncthing</span></a> <a href="https://social.anoxinon.de/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://social.anoxinon.de/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a></p>
Shikiryu<p>Using SQLite in production with Laravel - Samuel Štancl <a href="https://links.shikiryu.com/shaare/tD1waA" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">links.shikiryu.com/shaare/tD1w</span><span class="invisible">aA</span></a> De bons conseils si on utilise SQLite avec Laravel comme c'est souvent mon cas <br> <a href="https://oisaur.com/tags/laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>laravel</span></a> <a href="https://oisaur.com/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://oisaur.com/tags/tips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tips</span></a></p>
Anisse<p>Remember <a href="https://anisse.astier.eu/wikidata-communes-viewer.html" rel="nofollow noopener noreferrer" target="_blank">when I was nerd-sniped and built a viewer for french communes border data</a>?</p><p>Well, I <a href="https://github.com/anisse/border-explorer" rel="nofollow noopener noreferrer" target="_blank">rewrote all the data processing in Rust (and SQLite)</a> and made it generic, so now instead of just french communes, there are 400+ categories of places to view. A few examples:<br>1️⃣ <a href="https://anisse.github.io/border-explorer/#zoom=4.082681659099421&center=-55.99137037973918,-11.76130929267967&category=Q3184121" rel="nofollow noopener noreferrer" target="_blank">Brazil municipalities</a><br>2️⃣ <a href="https://anisse.github.io/border-explorer/#zoom=12.27178411534342&center=33.0258252170612,34.686495117248924&category=Q29463880&filter=" rel="nofollow noopener noreferrer" target="_blank">Quarters of Limassol</a><br>3️⃣ <a href="https://anisse.github.io/border-explorer/#zoom=5.18027201631608&center=101.75725966828543,13.632897406674488&category=Q50198&filter=" rel="nofollow noopener noreferrer" target="_blank">Provinces in Thailand</a><br>4️⃣ <a href="https://anisse.github.io/border-explorer/#zoom=5.920737614830325&center=25.85551980057471,45.795980020582306&category=Q1776764" rel="nofollow noopener noreferrer" target="_blank">Romanian counties (județ)</a></p><p><a href="https://social.treehouse.systems/tags/RustLang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RustLang</span></a> <a href="https://social.treehouse.systems/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://social.treehouse.systems/tags/Wikidata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Wikidata</span></a> <a href="https://social.treehouse.systems/tags/maplibre" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>maplibre</span></a> <a href="https://social.treehouse.systems/tags/RiiR" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RiiR</span></a></p>
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
LoginDrag & drop to upload