Posts tagged “sql”

ORM looks great early in a project but breaks down as complexity grows, forcing you to learn SQL anyway. Relations aren't objects. Either use NoSQL for object-like data or write a model layer with real SQL. ORM's abstraction is leaky, its efficiency poor, and the alternatives are better.

SQL is ugly but powerful, ORM is genuinely dumb, and "NoSQL" should really be called OMADS: Obviously More Appropriate Data Stores. Start every project with an RDBMS, add specialized stores where they fit, and stop apologizing for using SQL. Forty years on, nothing beats it for ad-hoc questions about your data.

A good day at work: cookies causing login loops, AND vs OR in SQL joins, and the correct terminology for Bosnian landmine incidents. Three questions, three answers. On a roll.

Good day so far: finished French homework, stayed awake through the lecture, and discovered that SQL Server developers may owe massive patent royalties to a company called Timeline because Microsoft botched their licensing deal. Time to switch to MySQL or PostgreSQL. Also, Libya chairing the UN Human Rights Commission? Totally nuts.