[Tutor] Which DB use with standalone desktop app

[Alan Gauld]

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