3 ms·
Since the file format specification is available, you can write your own code that directly reads/writes to SQLite files. You can't even have to use the logs an
by bane 7y ago
Since the file format specification is available, you can write your own code that directly reads/writes to SQLite files. You can't even have to use the logs and journaling options. You don't even have to use SQL.
- cma 7y agoThat’s the SQLite database file format. SQLite itself is a library that can deal with multiple files in different formats (transaction log and database file). It also reads .sqliterc and maybe others.
- bane 7y ago> That’s the SQLite database file format. You got it! SQLite is a file format. > SQLite itself is a library that can deal with multiple files in different formats (transaction log and database file). It also reads .sqliterc and maybe others. Yup you also got it! SQLite is not an RDBMS and shouldn't be approached that way. The more you try to ram RDBMS ideas into what SQLite is, the more it won't be that. The more you try to treat it like a file format, the more it will be what you want.