Conversation

Notices

1. Embed this notice
   bert hubert 🇺🇦🇪🇺 (bert_hubert@fosstodon.org)'s status on Monday, 27-Jan-2025 05:13:24 JST bert hubert 🇺🇦🇪🇺

   "The second advantage of WAL-mode is that writers do not block readers and readers to do not block writers. This is mostly true" - coming to you live from the part where this is not true. #sqlite3 https://sqlite.org/wal.html

   • Embed this notice
     Howard Chu @ Symas (hyc@mastodon.social)'s status on Monday, 27-Jan-2025 05:13:24 JST Howard Chu @ Symas

     in reply to

     @bert_hubert if you actually need that non-blocking behavior you should use SQLite backed by LMDB. Sqlightning or lumosql.

     feld likes this.
   • Embed this notice
     feld (feld@friedcheese.us)'s status on Monday, 27-Jan-2025 05:14:07 JST feld

     in reply to

     • Howard Chu @ Symas
     @hyc @bert_hubert mmmm this makes me wonder if I can coerce Elixir/Ecto to use an LMDB-backed SQLite ...