I need to process a bunch of rows from a MySQL database table. I will be using Python as the programming language.
Requirements:
- Python module
- reading the rows of an existing database/table
- data is numeric, datetime, str, etc
- reading the data returns Python objects/datatypes (i.e. int,float,str,etc,etc. not just a string or multiple strings.)
- supports MySQL
- RPM and/or DEB package available
- open-source
- the Python module must be actively developed[1]
- public code repo[2]
Given these requirements, what is a good Python module to access data in MySQL/MariaDB database?
Extra value go towards the following:
- a project that has positive growth[3]
- good example code, documentation, tutorials
- large user base
- supports MariaDB also (future work may transition from MySQL to MariaDB)
[1] frequent commits (at least one commit per month, preferably one or more commits per week), at least 3 active developers
[2] to allow me to pull down the code via some version control
[3] users/developers/unittests/features/etc of the Python module are growing
MySQLdb
(sourceforge) andsqlalchemy
. However I am not knowledgable about databases. – Trevor Boyd Smith Mar 8 '17 at 13:41MySQLdb
-->MySQLdb
appears to be abandoned as of 2014-01-02 – Trevor Boyd Smith Mar 9 '17 at 16:09