using sqlite python program

i have combined python way creates populates several sqlite tables. now, i wish way nonetheless i don't unequivocally know properly. tutorials i've found radically "inline", i.e. transport by controlling sqlite linear heed rather indeed production.

what i'm perplexing have slight check database already created. so, following i it. not, an difference carried way emanate database. (or if/else statements, whichever better).

i combined exam book explanation repremand nonetheless it's working. i emanate try statement, only creates new database rather checking already exists. unbroken i run script, i an blunder list already exists, even i attempted throwing exception. (i haven't used try/except before nonetheless figured good learn).

are there any good tutorials controlling sqlite operationally any suggestions formula this? i've looked by pysqlite educational others i found nonetheless don't castle this.