On 06/07/17 18:32, zhenghao li wrote: > 100 records are not a lot, so sqlite is sufficient. Its database engine > is included in python and it doesn't need to be run as a stand-alone > server so that saves you a lot of time for setting things up. If you > have a lots of tables and data say like more than 10k then you might > consider switching to a real database server.
Provided it's single-user then SQLite can easily scale up to a million+ records and still perform OK. I have one database with about 250k records over 8 tables and the file is only 10MB in size and query performance is effectively instant. Where a server becomes important is when you have multiple users and you care about security, locking, etc. or want to use advanced features like stored procedures etc. -- 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