+ 10

SQL database manager in Python - works!

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

26th Jan 2017, 9:44 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
5 Antworten
+ 6
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
3rd Mar 2017, 10:24 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 6
BTW, could someone post an SQL manipulation code in some other language? Thanks in advance :)
5th Mar 2017, 10:26 AM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 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 ;)
5th Feb 2017, 8:12 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 1
nice!
28th Jan 2017, 10:34 AM
David Price
David Price - avatar
+ 1
I've been working on a few different scripts that boil down some useful libraries functions, check out my one on logging or multithreading!
5th Feb 2017, 9:28 PM
David Price
David Price - avatar