toad.social

AliveDevil<a href="https://tauri.earth/tags/AspNetCore" class="mention hashtag" rel="nofollow noopener" target="_blank">#AspNetCore</a>, for an <a href="https://tauri.earth/tags/Sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#Sqlite</a> database.- Vacuum on startup/shutdown, - offline by user running vacuum command through Sqlite CLI, - or on regular intervals during runtime?<a href="https://tauri.earth/tags/DotNet" class="mention hashtag" rel="nofollow noopener" target="_blank">#DotNet</a> <a href="https://tauri.earth/tags/CSharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#CSharp</a> <a href="https://tauri.earth/tags/EFCore" class="mention hashtag" rel="nofollow noopener" target="_blank">#EFCore</a> <a href="https://tauri.earth/tags/EntityFramework" class="mention hashtag" rel="nofollow noopener" target="_blank">#EntityFramework</a>

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>

Sverrir Valgeirsson 🇮🇸 🇸🇪Did a small writeup on my attempt to build a <a href="https://mastodon.nu/tags/multiplayer" class="mention hashtag" rel="nofollow noopener" target="_blank">#multiplayer</a> asynchronous game in serverside <a href="https://mastodon.nu/tags/Blazor" class="mention hashtag" rel="nofollow noopener" target="_blank">#Blazor</a> <a href="https://mastodon.nu/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#dotnet</a> using <a href="https://mastodon.nu/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.nu/tags/EntityFrameworkCore" class="mention hashtag" rel="nofollow noopener" target="_blank">#EntityFrameworkCore</a> and my new best friend <a href="https://mastodon.nu/tags/copilot" class="mention hashtag" rel="nofollow noopener" target="_blank">#copilot</a> <a href="https://nerdur.com/wordur-update-summer-2025.html" rel="nofollow noopener" translate="no" target="_blank">https://nerdur.com/wordur-update-summer-2025.html</a><a href="https://mastodon.nu/tags/gamedev" class="mention hashtag" rel="nofollow noopener" target="_blank">#gamedev</a> I have to say it works pretty good as <a href="https://mastodon.nu/tags/pwa" class="mention hashtag" rel="nofollow noopener" target="_blank">#pwa</a> as well and to play on mobile (except ios constantly forces you to login again. Its a bit agressive). The game is here: <a href="https://wordur.nerdur.com/" rel="nofollow noopener" translate="no" target="_blank">https://wordur.nerdur.com/</a> Try it out and give me feedback if you have any

Ivan Enderlin 🦀Patch of the dayperf: Improve throughput by +1140%, <a href="https://github.com/matrix-org/matrix-rust-sdk/pull/5411" rel="nofollow noopener" translate="no" target="_blank">https://github.com/matrix-org/matrix-rust-sdk/pull/5411</a>.It was fun to track it down.<a href="https://floss.social/tags/RustLang" class="mention hashtag" rel="nofollow noopener" target="_blank">#RustLang</a> <a href="https://floss.social/tags/matrix" class="mention hashtag" rel="nofollow noopener" target="_blank">#matrix</a> <a href="https://floss.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://floss.social/tags/performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#performance</a>

{:ok, "Joel Jucá"}I've used <a href="https://functional.cafe/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> before (last time was 2016, I think), but today I'm mostly onto <a href="https://functional.cafe/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> (and sometimes, <a href="https://functional.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)

Crazy-to-Bike<a href="https://mastodon.social/@alexantemachina" class="u-url mention" rel="nofollow noopener" target="_blank">@alexantemachina@mastodon.social</a> Warum meinst du? Datenbanken nehmen ja durch eine volle Platte nicht Schaden, im Sinne bereits gespeichertes ist auf einmal weg, sondern, dass neue Daten nicht oder nur korrupt gespeichert werden. Grundsätzlich verstehe ich auch nicht, warum bei <a href="https://fediworld.de/tags/HomeAssistant" rel="nofollow noopener" target="_blank">#HomeAssistant</a> als Standard auf <a href="https://fediworld.de/tags/SQlite" rel="nofollow noopener" target="_blank">#SQlite</a> gesetzt wird. Egal welches System mit Datenbank ich bisher installiert habe, wurde entweder direkt auf <a href="https://fediworld.de/tags/mySQL" rel="nofollow noopener" target="_blank">#mySQL</a>, <a href="https://fediworld.de/tags/MariaDB" rel="nofollow noopener" target="_blank">#MariaDB</a> oder <a href="https://fediworld.de/tags/Postgres" rel="nofollow noopener" target="_blank">#Postgres</a> gesetzt, oder zumindest empfohlen, nicht SQlite zu nehmen.

Yanick WitschiHere's a challenge for you if you speak C and <a href="https://phpc.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> fluently. Somehow <a href="https://phpc.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> seems to keep materialized CTEs for as long as the process runs which seems like it could break <a href="https://phpc.social/tags/frankenphp" class="mention hashtag" rel="nofollow noopener" target="_blank">#frankenphp</a> and Co. I'm not sure if my conclusions are correct - I'm pretty confused and would appreciate some insights :) <a href="https://github.com/loupe-php/loupe/pull/209" rel="nofollow noopener" translate="no" target="_blank">https://github.com/loupe-php/loupe/pull/209</a> <a href="https://phpc.social/tags/help" class="mention hashtag" rel="nofollow noopener" target="_blank">#help</a> <a href="https://phpc.social/tags/BoostsAreAppreciated" class="mention hashtag" rel="nofollow noopener" target="_blank">#BoostsAreAppreciated</a>

ZashLooked at <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> full text search today, stuffing it full of markdown. Would like to have a minimalist search engine as companion to a static site generator. My search for one resulted in such relevant hits as "you can use google".

Curated Hacker NewsZeQLplus: Terminal SQLite Database Browser<a href="https://github.com/ZetloStudio/ZeQLplus" rel="nofollow noopener" translate="no" target="_blank">https://github.com/ZetloStudio/ZeQLplus</a><a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mastodon.social/tags/github" class="mention hashtag" rel="nofollow noopener" target="_blank">#github</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</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>

David Bisset"Introducing a new SQLite driver for <a href="https://phpc.social/tags/WordPress" class="mention hashtag" rel="nofollow noopener" target="_blank">#WordPress</a> "<a href="https://make.wordpress.org/playground/2025/06/13/introducing-a-new-sqlite-driver-for-wordpress/" rel="nofollow noopener" translate="no" target="_blank">https://make.wordpress.org/playground/2025/06/13/introducing-a-new-sqlite-driver-for-wordpress/</a>🤔<a href="https://phpc.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://phpc.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a>

Guillaume Tronix :nix: :emacs: :linux:Tuta introduces smarter email search and a new calendar widget on iOSThe search function now enables partial word searches, accompanied by a refreshed interface that highlights search terms for quicker identification. Tuta has rolled out a series of updates to its privacy-focusedemailandcalendarservices.<a href="https://alternativeto.net/news/2025/6/tuta-introduces-smarter-email-search-and-a-new-calendar-widget-on-ios/" rel="nofollow noopener" translate="no" target="_blank">https://alternativeto.net/news/2025/6/tuta-introduces-smarter-email-search-and-a-new-calendar-widget-on-ios/</a><a href="https://infosec.exchange/tags/Privacy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Privacy</a> <a href="https://infosec.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Ruby CentralAND Mike Dalessio, Maintainer of <a href="https://ruby.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> Ruby!

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>

Kerr Avonsen (she/her)Today I Learned that: 1. Debian's sqlite3 command is deliberately built with readline support turned off 2. You can work around this by using a utility called "rlwrap" - instead of doing "sqlite3 dbname" you do "rlwrap sqlite3 dbname"! And it Just Works!So now I can go back down in my command history of my sqlite3 interactive session instead of scratching my head as to why the arrow keys don't work any more. (I didn't realise that it was my switch from Ubuntu to Debian which was the cause.)<a href="https://mastodon.au/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> <a href="https://mastodon.au/tags/CommandLine" class="mention hashtag" rel="nofollow noopener" target="_blank">#CommandLine</a> <a href="https://mastodon.au/tags/Shell" class="mention hashtag" rel="nofollow noopener" target="_blank">#Shell</a> <a href="https://mastodon.au/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

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

Neustradamus :xmpp: :linux:<a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener" target="_blank">#Roundcube</a> 1.5.10 (<a href="https://mastodon.social/tags/LTS" class="mention hashtag" rel="nofollow noopener" target="_blank">#LTS</a>) has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Webmail</a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Mail</a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#IMAP</a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener" target="_blank">#SMTP</a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#LDAP</a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener" target="_blank">#Managesieve</a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OracleDB</a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MSSQL</a> / <a href="https://mastodon.social/tags/LongTermSupport" class="mention hashtag" rel="nofollow noopener" target="_blank">#LongTermSupport</a>) <a href="https://roundcube.net/" rel="nofollow noopener" translate="no" target="_blank">https://roundcube.net/</a>

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

Recent searches

Search options

Administered by:

Server stats:

#sqlite