Creating an SQLite database on the fly in code

Hi all,

Please, can you help me with the following request?

For my bookkeeping application, I need to manually create an SQLite database, tables and queries in code.

I did the same in 2007 - 2008 with RealStudio. I had a PDF file which nicely explained the whole process. Regretfully, I cannot find it again.

Please, can you tell me where I can find text tutorials and/or video tutorials which explain manual coding of an SQLite database?

Thank you so much in advance. Your help will be greatly appreciated.


may be of some help (I hope).
db reference must be closed as soon as possible, after immediate use.

@Emile_Schwarz ,

Thank you so much, exactly what I was looking for.