Need some suggestions on which SQL engine to use for a Python Web Application

[astropheed Veteran]

I've been using, and fighting with, MongoDB for a long while now and have decided the process of normalising my schema is becoming too cumbersome in this denormalised world. Using references in a document store is just not conducive of a good time (or effective NoSQL usage) and not using them is giving me grey hair. My Schema will simply require normalisation.

 

It's time to make the switch back to an SQL engine. So I'd really appreciate suggestions on which engine you feel is a pleasant experience on Python, with minimal boilerplate code, and fast queries.

 

Some background on the App in case it changes which engine you'd potentially suggest:

• It's Python 3
• It's using the CherryPy web framework
• It's using Jinja2 templating engine

 

It may be asked so I'll preemptively state that I will not be willing to change to Python 2.

 

Any suggestions are appreciated, thanks!

 

 

[Delta47]

https://blogs.msdn.microsoft.com/cdndevs/2015/03/11/python-and-data-sql-server-as-a-data-source-for-python-applications/

 

[+Fahim S. MVC]

  On 12/10/2016 at 03:11, astropheed said:

I've been using, and fighting with, MongoDB for a long while now and have decided the process of normalising my schema is becoming too cumbersome in this denormalised world. Using references in a document store is just not conducive of a good time (or effective NoSQL usage) and not using them is giving me grey hair. My Schema will simply require normalisation.

 

It's time to make the switch back to an SQL engine. So I'd really appreciate suggestions on which engine you feel is a pleasant experience on Python, with minimal boilerplate code, and fast queries.

 

Some background on the App in case it changes which engine you'd potentially suggest:

• It's Python 3
• It's using the CherryPy web framework
• It's using Jinja2 templating engine

 

It may be asked so I'll preemptively state that I will not be willing to change to Python 2.

 

Any suggestions are appreciated, thanks!

 

 

Expand  

Document databases just do not suit referential data. A graph databases would make more sense giving schema flexibility but still allowing you to relate entities. Have you given something like Neo4j a go?