SQL database manager in Python - works!

Question

As today's (26/01/2017) course of the day is SQL, it inspired me to code a simple SQLite manager in Python. Unfortunately, it won't work under Sololearn, but I tested it on qpython3 for Android and it works alright.
I prepared a sample sqlite database file, too - the link to it is in the code's comments. Have fun! :)

It's just a little something for those who wonder what to do as their small projects ;)

EDIT on 03/03/2017:
A working demo of SQL in Python!
https://code.sololearn.com/csyhsIovmZJ3/?ref=app

Answer 1

A big update to this question - a demonstration of SQL in Python, now works under SoloLearn! You can check it here:
https://code.sololearn.com/csyhsIovmZJ3/?ref=app

Answer 2

BTW, could someone post an SQL manipulation code in some other language? Thanks in advance :)

Answer 3

Glad you like it :) I wrote a script which pulls down a list of Polish cities (parsing a wikipedia HTML page), writes them in an SQLite database AND adds geographic coordinates based on Google API (by inquiring for "city_name, Poland") - of course added as Longitude and Latitude columns ;)

Answer 4

nice!

Answer 5

I've been working on a few different scripts that boil down some useful libraries functions, check out my one on logging or multithreading!