Oops, I forgot the list! Blush...
On 06/07/17 18:30, Alan Gauld wrote: > On 06/07/17 09:57, Freedom Peacemaker wrote: > >> own but google cant help me. There are some with SQL in name (eg. sqlite3, >> MySql), but there are some other NoSql like MongoDB or Redis. > NoSQL databases are best for unstructured data(or flexibly structured) > and for large volumes. > For ~100 records where you know the columns you want then a SQL > database is fine and SQLite3 comes with Python. The big advantaghe > of SQLite is that everything is stored in a single file which > can be easily distributed, no server to install etc. The downside is > that there is no security login, just basic file permissions. For a > desktop app that's usually not an issue. > > To use: > > ################# > import sqlite3 > > db = sqlite3.connect("your/database/filename") > cursor = db.cursor() > cursor.execute(<your SQL query here>, > (<your variavble parameters here>)) > > results = cursor.fetchall() > ################## > > If you know SQL you should be able to figure it out from there... > (And the SQLite web site has a good reference for their SQL syntax.) > > If not you can try the database topic in my tutorial(see .sig) > which teaches basic SQL and how to use it from Python... Use > the python2 version of the tutorial, but its easy to convert > that topic to python3... > > -- Alan G Author of the Learn to Program web site http://www.alan-g.me.uk/ http://www.amazon.com/author/alan_gauld Follow my photo-blog on Flickr at: http://www.flickr.com/photos/alangauldphotos _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor