Database

2 articles in this category

2011

Handling empty WHERE IN clauses in DBALs

January 10, 2011 • By Romain Dorgueil

Comparing how different ORMs (Doctrine, Propel, SQLAlchemy, Django, Rails) handle empty WHERE IN clauses in SQL, and why the simplest approach is often correct.

sql python php database django sqlalchemy propel1 doctrine1 ruby on rails

2008

Foreign key's onDelete for dummies

July 10, 2008 • By Romain Dorgueil

Understanding foreign key onDelete behaviors in relational databases: RESTRICT, CASCADE, and SET NULL modes with practical examples for Doctrine and Propel ORMs.

php database doctrine1 propel1 yaml xml relation