3 ms·
Not sure if this actually does more, but remember you can do: sqlite> select * from pragma_application_id(); 0 sqlite> select * from pragma_user_ve
by o11c 3y ago
Not sure if this actually does more, but remember you can do:
sqlite> select * from pragma_application_id();
0
sqlite> select * from pragma_user_version();
0
- JNRowe 3y agoYeah, you could use that as in "sqlite3 t.db 'SELECT format(…) FROM pragma_…' .dump" to create a file that sets application_id/$others and then dumps the tables, which would make restoration from the dump file work in more cases. It is just another thing to be aware of if you're trying to store your database in your git repository with a filter, and want it to roundtrip correctly.