News for hackers. Stuff that matters.

A comment on SQL is 43 years old – Here’s why we still use it today. Parent comment

Re:SQL is 43 years old – Here’s why we still use it today by cryptonector on Tuesday May 02, 2017 @12:34PM (#14247876)
One advantage: you get all the write concurrency your RDBMS can give you for your transactions. Too many ORMs I've seen just have a Big Lock, leaving you with just one writer at a time.

I can't think of disadvantages to putting your business logic in the RDBMS. Can you elaborate?

[ Parent | on HN ]
Re:SQL is 43 years old – Here’s why we still use it today by jrochkind1 on Tuesday May 02, 2017 @04:33PM (#14250302)
> Too many ORMs I've seen just have a Big Lock, leaving you with just one writer at a time.

Geez, I think you've seen some pretty terrible ORMs. I don't know of any mature and popular ORMs that do that. If they do, I have no idea why they are popular or what makes anyone consider them mature.

ORMs that don't do that include: ActiveRecord, Sequel, Hibernate, Core Data, SQLAlchemy, etc.

[ Parent | on HN ]