+ 1

Python RDBMS

Which RDBMS dB is best to integrate with Python?

4th Oct 2020, 3:50 AM
Sanjay Kamath
Sanjay Kamath - avatar
2 Answers
+ 2
Python doesn't prefer any specific SQL vendor. MySQL is very popular regardless of using Python since it is mostly free and strikes a popular balance between simplicity and completeness of features. I would decide on an SQL vendor based on requirements from the project instead of the fact that Python is being used. For example PostgreSQL has some good GIS-related features that could be useful if your project heavily worked with geographical data. If you want to heavily use GUID's, Microsoft SQL Server has better support and optimization for them. Microsoft SQL Server has a special field type for GUID so it can be stored and managed like a big integer instead of a hex-string.
4th Oct 2020, 3:59 PM
Josh Greig
Josh Greig - avatar
+ 3
Hi Sanjay, can you specify what you want to archive? Have a nice day!
4th Oct 2020, 8:17 PM
Zen Coding
Zen Coding - avatar