Mastodon

3 posts3 participants0 posts today

Wesley MooreAs a stress test I loaded 8M bookmarks into a little SQLite backed bookmark saving/sharing web app I'm building. The slowest part turned out to be the `SELECT count(1) FROM bookmarks` query that's used as part of the pagination UI. Not what I was expecting but known/expected behaviour from what I've read. It takes 400ms on Snapdragon X Elite CPU, which is fine in practice—I'd be surprised if anyone actually stored more than 100k items in it.<a href="https://mastodon.decentralised.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.decentralised.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Performance</a>

Markus EiseleRunning SQLite in Pure Java with Quarkus <a href="https://quarkus.io/blog/sqlite4j-pure-java-sqlite/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://quarkus.io/blog/sqlite4j-pure-java-sqlite/</a> <a href="https://mastodon.online/tags/Java" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Java</a> <a href="https://mastodon.online/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.online/tags/Quarkus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Quarkus</a>

Albert ARIBAUD ⓂTIL that <a href="https://piaille.fr/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> provides virtual columns (computed from othercolumns) and right now that's a lifesaver.

linkdropGitHub - splitbrain/meh: Meh... another comment system <a href="https://github.com/splitbrain/meh" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/splitbrain/meh</a> <a href="https://troet.cafe/tags/alternative" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#alternative</a> <a href="https://troet.cafe/tags/integration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#integration</a> <a href="https://troet.cafe/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://troet.cafe/tags/comments" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#comments</a> <a href="https://troet.cafe/tags/mastodon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mastodon</a> <a href="https://troet.cafe/tags/node" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#node</a>.js <a href="https://troet.cafe/tags/website" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#website</a> <a href="https://troet.cafe/tags/GitHub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GitHub</a> <a href="https://troet.cafe/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://troet.cafe/tags/static" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#static</a> <a href="https://troet.cafe/tags/blog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#blog</a> <a href="https://troet.cafe/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a>

Christiaan KrasAnyone know if it’s possible to migrate a <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://floss.social/@forgejo" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@forgejo</a> <a href="https://fosstodon.org/tags/forgejo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#forgejo</a> database to <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> or <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a>?

{{template.display_name}}I always knew <a href="https://indieweb.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> was kind of unhinged, but I had *no idea how much* until I read this list."14. SQLite is so fast, they compete with fopen. For some use cases, you can use SQLite instead of a filesystem, that can be 35% faster."<a href="https://avi.im/blag/2024/sqlite-facts/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://avi.im/blag/2024/sqlite-facts/</a>

Jamie TannaPerforming group_concat queries over distinct values, with a custom delimiter, with SQLite How to avoid SQLite's `DISTINCT aggregates must have exactly one argument` error when performing a `group_concat(distinct ...)` with a custom delimiter. <a href="https://fed.brid.gy/r/https://www.jvt.me/posts/2025/03/25/sqlite-distinct-group-concat/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://fed.brid.gy/r/https://www.jvt.me/posts/2025/03/25/sqlite-distinct-group-concat/</a>

Markus 🤓✨I'm a database extremist. I default to <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> for pretty much anything.As an independent software consultant, I need time tracking and CRM like anyone else. Guess what? It's just a single SQLite database file. :D Has worked wonderfully for years using just a database viewer app. (Tableplus, if you're wondering.)But now, with this wonderful tool from Rune Kaagaard, I can hook up my database to Anthropic's Claude, and get insights into my time spent as well as my connections, just by chatting with Claude Sonnet 3.7.Wild! :D<a href="https://github.com/runekaagaard/mcp-alchemy" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/runekaagaard/mcp-alchemy</a>

lmemsm<a href="https://fosstodon.org/@dff" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@dff</a> I noticed <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> seems to have functionality for dealing with and manipulating <a href="https://fosstodon.org/tags/CSV" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CSV</a> files as well.

BumbleAnyone using <a href="https://ibe.social/tags/litestream" rel="nofollow noopener noreferrer" target="_blank">#litestream</a> for an <a href="https://ibe.social/tags/sqlite" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> DB I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a <code>generations</code> folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space. My config includes <code>retention: 24h</code> and <code>retention-check-interval: 1h</code> with a <code>snapshot-interval: 4h</code>. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream <a href="https://ibe.social/tags/GoToSocial" rel="nofollow noopener noreferrer" target="_blank">#GoToSocial</a> <a href="https://ibe.social/tags/gts" rel="nofollow noopener noreferrer" target="_blank">#gts</a> <a href="https://thefedi.forum/category/8/gotosocial" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@gotosocial@thefedi.forum</a>

EinenlumTIL: you can insert and fetch strings that are way longer than 255 characters in a VARCHAR(255) column in <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> There is no constraint

Maho Pacheco 🦝🍻I did not expect my clumsy announcement of <a href="https://hachyderm.io/tags/BadgeFed" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#BadgeFed</a> to make waves, and now I have a few followers in the <a href="https://badges.vocalcat.com/actors/badges.vocalcat.com/fediverse" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@fediverse</a> It is only less than a dozen, but still I want to honor the follow LOL, and my database for the poc was a <a href="https://hachyderm.io/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>. Now I need to download and backup that db, otherwise I will lose the pub/priv keys.

Kuba Suder • @mackuba.eu on 🦋It's so nice to be able to do 3 things in the same database at the same time and not worry that one is blocking the other… 🫠 <a href="https://martianbase.net/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://martianbase.net/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

LisPiBrought to you by Mozilla <a class="hashtag" href="https://udongein.xyz/tag/firefox" rel="nofollow noopener noreferrer" target="_blank">#Firefox</a> using dozens of <a class="hashtag" href="https://udongein.xyz/tag/sqlite" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> databases and clearly not batching the transactions. Did no one stop to think for a second of the performance implications of dozens of close-together fsyncs|dsyncs on HDDs? Also, why in the world so many databases? It's completely unnecessary and even though they *could* be used as attached databases, that means one can only use them in non-WAL mode (yay, blocking readers) to maintain proper global transactionality (<a href="https://sqlite.org/lang_attach.html" rel="nofollow noopener noreferrer" target="_blank">https://sqlite.org/lang_attach.html</a> <a href="https://sqlite.org/wal.html" rel="nofollow noopener noreferrer" target="_blank">https://sqlite.org/wal.html</a>). Did they even read the docs before doing this nonsense?

Blain SmithOur product manager extraordinaire <a href="https://social.coop/@jluther" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@jluther</a> has been writing Go and <a href="https://templ.guide" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://templ.guide</a> content for <a href="https://apply.coop" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://apply.coop</a> which tells me we've made the right tech stack choice in order for everyone at <a href="https://social.coop/@limeleaf" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@limeleaf</a> to contribute code to it.He's even been getting his SQLite chops leveled up too."ONE OF US! ONE OF US!"<a href="https://fosstodon.org/tags/GoLang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GoLang</a> <a href="https://fosstodon.org/tags/templ" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#templ</a> <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>

aaron<a href="https://mastodon.social/tags/TIL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TIL</a> that multiple processes can access the same <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> database at the same time. Only writing is limited to one process.Just don’t do it on Win 9x, I guess:“Under Win95/98/ME which lacks support for reader/writer locks, a probabilistic simulation is used instead.”😆(<a href="https://www.sqlite.org/faq.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.sqlite.org/faq.html</a>)

Giacomo Tesio<a href="https://mastodon.xyz/users/gausby" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@gausby@mastodon.xyz</a> First, it's trivial to self-host on the cheapest shared hostings because it can run as a cgi. Second, backup is trivial, as the whole installation rely on a single <a href="https://snac.tesio.it?t=sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> file. Third it's fast and it's based on a simpler mental model then git (no rebase, for example). Forth, it's a complete solution, including wiki, issue management and even a forum. For high-skilled corporate teams, it's way better than git over (say) github, with less burocracy but still all acl that you might need. Finally you don't need custom UI, since it provides all you need through a simple web interface.

ResearchBuzz: FirehoseHow-To Geek: How I Track My Music Collection With an Easy SQLite Database. “If you’re a music fan, you probably have shelves of records or CDs. How do you keep track of them? You could use a database, but aren’t they complicated to set up? SQLite is a powerful tool that lets you set up SQL databases without a server. It’s surprisingly easy to set up. Here’s how I did it, despite having a […]<a href="https://rbfirehose.com/2025/03/17/how-to-geek-how-i-track-my-music-collection-with-an-easy-sqlite-database/" class="" rel="nofollow noopener noreferrer" target="_blank">https://rbfirehose.com/2025/03/17/how-to-geek-how-i-track-my-music-collection-with-an-easy-sqlite-database/</a>

David Cantrell 🏏I recently listened to an interview on the <a href="https://fosstodon.org/tags/ChangelogPodcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ChangelogPodcast</a> <a href="https://changelog.com/podcast/626" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://changelog.com/podcast/626</a> about a rewrite of <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> in <a href="https://fosstodon.org/tags/Rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Rust</a>. Very interesting, you should listen, but it also prompted me to listen to the two previous episodes they've done with <a href="https://fosstodon.org/tags/RichardHipp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RichardHipp</a>, the SQLite head honcho. Both of those are well worth listening to as well, and Richard comes across as a lovely person. <a href="https://changelog.com/person/drh" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://changelog.com/person/drh</a>. And yes, diversions like this are why it took years to catch up on my podcast backlog!

Wolfram Rösler<a href="https://hackers.town/@zwol" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@zwol</a> But before you invent a new binary file format, consider using an <a href="https://mastodontech.de/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> file instead.

Recent searches

Search options

Administered by:

Server stats:

#sqlite