Python RDBMS

Question

Which RDBMS dB is best to integrate with Python?

Answer 1

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.

Answer 2

Hi Sanjay,
can you specify what you want to archive?

Have a nice day!