Re:Getting the Most Out of Sqlite3 with Python
by coleifer on Sunday October 22, 2017 @09:39AM
(#15526770)
The docs cover all this and much more. Do yourself a favor and read them. Sqlite is a very capable library and this post is just the tip of the iceberg.
Re:Getting the Most Out of Sqlite3 with Python
by sago on Sunday October 22, 2017 @09:55AM
(#15526839)
Agreed. But in general avoid 2.x if you can. It will be EOL at some point, quite possible before the code you're writing now is EOL. Up to date docs are at:
https://docs.python.org/2/library/sqlite3.html