News for hackers. Stuff that matters.

A comment on In Search of a Faster SQLite. Parent comment

Re:In Search of a Faster SQLite by efitz on Monday December 16, 2024 @02:31PM (#42434438)
I actually versioned my database file - I had a small metadata table with version number and creation time.

Then in the output from each of my other functions, I included the database version number. So all my output could be subsequently normalized by re-running the same input versus an arbitrary version of the database file.

[ Parent | on HN ]
Re:In Search of a Faster SQLite by bob1029 on Monday December 16, 2024 @07:26PM (#42437071)
Have you looked at the user_version pragma? I've been able to avoid use of special metadata tables with this.
[ Parent | on HN ]