I actually versioned my database file - I had a small metadata table with versio... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		efitz 11 months ago \| parent \| context \| favorite \| on: In Search of a Faster SQLite 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.

bob1029 11 months ago [–]

Have you looked at the user_version pragma? I've been able to avoid use of special metadata tables with this.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact