• 0

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

Asked by astropheed,

 Share

Question

Grand Master

astropheed Veteran

Posted
  • Veteran
Posted

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!

 

 

2 answers to this question

Recommended Posts

  • 0
Grand Master

+Fahim S. MVC

Posted
  • MVC
Posted
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?

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • Politically funny images of the World

      By Michael Scrip · Posted

    • Microsoft finally admits its default Windows 11 25H2, 24H2 action broke key legacy component

      By hellowalkman · Posted

      Microsoft finally admits its default Windows 11 25H2, 24H2 action broke key legacy component by Sayan Sen Microsoft last week released Windows 11 KB5094126 and KB5093998 as the latest Patch Tuesday updates. Following that the company also published the accompanying dynamic updates under KB5094149, KB5095971, and KB5094156. So far the company has acknowledged two known issues that have popped up after the release which include bugged-out Office apps as well as the Recycle Bin; though there could be more at play too. Speaking of bugs and issues, Microsoft seems to have finally acknowledged a problem that probably has been around for close to a year. That's because back in July of 2025 the company made a default change to the latest Windows 11 versions, wherein it switched to JScript9Legacy on Windows 11 24H2 and later releases. Hence following the release of version 25H2 in October 2025, JScript9Legacy also remained default-enabled. As a result there has been a compatibility issue ever since then. For those wondering, by switching to JScript9Legacy Microsoft intended to improve the security of modern Windows PCs by reducing vulnerabilities tied to legacy scripting like cross-site scripting (XSS), among others. XSS exploits can allow cyber-attackers to attach malicious code onto legitimate websites and use them to execute the code when a potential victim loads such a website. Hence the new JScript9Legacy engine enforced stricter execution policies and improved object handling, which should help mitigate such attacks. Microsoft today has published a new support article detailing the problem. Neowin spotted it while browsing. The company says that JScript global definitions and execution context may fail to persist across scripts, potentially breaking older dependent apps and web-based components that relied on this legacy behavior. In the article Microsoft has confirmed that the issue stems from its move away from the older jscript9.dll engine in favor of jscript9legacy.dll. As mentioned above, while the newer engine was designed to address vulnerabilities and strengthen security it also changes how JScript handles execution context. As a result functions and definitions loaded by one script could no longer remain available to subsequent scripts once execution ended. The company notes that some applications worked correctly on earlier Windows versions because the older JScript engine automatically retained global definitions and execution state between scripts. Under the newer model though that behavior is disabled by default causing certain legacy workloads and polyfill-dependent scripts to fail. Microsoft says it addressed the problem via the KB5077241 update though the fix had not been enabled automatically in the following updates. As such admins must explicitly turn on persistent JScript execution context using a Registry setting that the tech giant shared today. The configuration can be applied to individual processes or system-wide through the FEATURE_ENABLE_PERSISTENCE registry key. The steps have been outlined below: Run the following command to create the feature control registry key: reg add "HKLM\Software\Policies\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_ENABLE_PERSISTENCE" Under this key, create a new DWORD (32-bit) value. Configure the value as follows: To enable persistence for specific processes only: Set the value to 1 for each target process name. To enable persistence for all processes: Add * as the key name and set its value to 1. You can find the official support article here on Microsoft's website.
    • The quantum search for Time's origin had an equally mind-boggling conclusion

      By cleverclogs · Posted

      The possibility that milk gathers back into a glass implies that gravity can be 'reversed'.
    • VidCoder 12.20

      By Copernic · Posted

      VidCoder 12.20 by Razvan Serea  VidCoder is a DVD/Blu-ray ripping and video transcoding application for Windows. It uses HandBrake as its encoding engine. Calling directly into the HandBrake library gives it a more rich UI than the official HandBrake Windows GUI. VidCoder can rip DVDs but does not defeat the CSS encryption found in most commercial DVDs. You’ll need the NET 8 Desktop Runtime. If you don’t have it, VidCoder will prompt you to download and install it. The Portable version is self-contained and does not require any .NET Runtime to be installed. You do not need to install HandBrake for VidCoder to work. Feature list: Multi-threaded MP4, MKV containers Completely integrated encoding pipeline: everything is in one process and no huge intermediate temporary files H.264, H.265, MPEG-4, MPEG-2, VP8, Theora video Hardware-accelerated encoding with AMD VCE, Nvidia NVENC and Intel QuickSync AAC, MP3, Vorbis, AC3, FLAC audio encoding and AAC/AC3/MP3/DTS/DTS-HD passthrough Target bitrate, size or quality for video 2-pass encoding Decomb, detelecine, deinterlace, rotate, reflect, chroma smooth, colorspace filters Powerful batch encoding with simultaneous encodes Customizable Pickers to automatically pick audio and subtitle tracks, destination, titles and more Instant source previews Creates small encoded preview clips Pause, resume encoding VidCoder 12.20 changes: Updated HandBrake core to 1.11.2. Download: VidCoder 12.20 | 47.0 MB (Open Source) Download: Portable VidCoder 12.19 | 89.3 MB Link: VidCoder Home Page | Github | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • This is how much iPhone 18 Pro could cost after Apple's price hike confirmed

      By +Nik Louch · Posted

      They will

  • Recent Achievements

    • Week One Done
      Jordan Smith earned a badge
      Week One Done
    • Reacting Well
      BizSAR earned a badge
      Reacting Well
    • First Post
      AndreaB earned a badge
      First Post
    • Week One Done
      Huge Trailer earned a badge
      Week One Done
    • Week One Done
      Classifyskilleducation earned a badge
      Week One Done

  • Popular Contributors

    1. 1
      +primortal
      590
    2. 2
      +Edouard
      185
    3. 3
      PsYcHoKiLLa
      76
    4. 4
      Michael Scrip
      73
    5. 5
      Steven P.
      66
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!