wcphkust/ORMCollection

ORM Applications

ORMCollection

Demo applications of Python and Ruby. If you want to catch what the ORM is and its (dis)advantages, you can go to this site1 and site2.

Python

ORM: SQLAlchemy

The project refers to the blog.

SQLAlchemy provides a collection of Query APIs to support the manipulation on database

Performance Issues of SQLAlchemy

• Better SQLAlchemy
• SQLAlchemy Performance Anti-Patterns and Their Fixes
• Fast SQLAlchemy counting

Ruby

ORM: Ruby on Rails

According to the statistic published in the website of The Ruby Toolbox, Ruby on Rails is a prevelant ORM framework in Ruby web applications.

Data can be queried from database by ActiveRecord.

Built-in test module supports query time profiling by writing tests for rails applications.

Performance Issues of Rails

• Eliminating the N+1 query problems
• How not to structure your database-backed web applications

Bug Case in Real-World Project

• CTFd
  • first() vs fetchone() pattern fixed by Patch