Conversation

Notices

1. minute (mntmn@mastodon.social)'s status on Monday, 21-Oct-2024 19:50:23 JST minute

   sqlite3 expert question: when i copy a sqlite file out of a production web app and run a query, there are some rows there that i don't see when accessing the same file that is concurrently opened by the web app itself. does that make sense? is there additional information in other related files that sqlite can use to say, part of this data is uncommitted, for example? for example, does the WAL contain absolute paths and is used in this case?

   • minute (mntmn@mastodon.social)'s status on Monday, 21-Oct-2024 22:16:48 JST minute

     in reply to

     • Alex Holst

     @holsta rails/solidus

   • Alex Holst (holsta@helvede.net)'s status on Monday, 21-Oct-2024 22:16:49 JST Alex Holst

     in reply to

     @mntmn The WAL resides in the same directory as the database file, but with -wal appended. Did you copy the database file of a running app?

     Which app is it? Not all apps are created equal when it comes to using sqlite.