dimanche 1 mars 2015

How to add my own PRAGMA statements in SQLite to store custom meta data

I want to store meta data like author name, copyright, source to my SQLite DB without creating a new table. I found out we can use PRAGMA statements to set some values.. I would like to store my own custom name and value ... How to create custom PRAGMA statement? http://ift.tt/1g4bkiN


Has anyone done this before? The doc says..


"The C-language API for SQLite provides the SQLITE_FCNTL_PRAGMA file control which gives VFS implementations the opportunity to add new PRAGMA statements or to override the meaning of built-in PRAGMA statements."


Please let me know how can I achieve this?


Aucun commentaire:

Enregistrer un commentaire