I've been trying to use SQLite in my application. However I find it difficult to find any helpful resources on the subject. For instance I'd like to prevent creating multiples of the same table in the database, but I can't find anything that lists out the methods and defines them to see if you even can create duplicate tables and/or if writes over the existing one. Yes I know it has it's own little wiki on the GitHub page, but it doesn't seem to have anything helpful beyond basic syntax. Even that itself doesn't explain how it parses it's string parameter for Query.
I was wondering if any of you devs have any good references for this?