• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

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

Question

astropheed    2,286

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!

 

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
+Fahim S.    1,087
On 12/10/2016 at 4:11 AM, 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!

 

 

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.