What ORMs have taught me: just learn SQL (2014)
1–10 of 354 posts
Re: What ORMs have taught me: just learn SQL (2014)
#2Next step is go down one more level to ditch SQL and learn LMDB and/or RocksDB.
Re: What ORMs have taught me: just learn SQL (2014)
#32014: people respond with indignance that they should have to learn SQL now that there's a shortcut
2026: people respond with indignance that they should have to learn anything now that there's a shortcut
Re: What ORMs have taught me: just learn SQL (2014)
#4Just one quick note...
> ...(although things like Postgres’ hstore can help)...
Back when this blog post was written, this advice would have been reasonable. Today, I don't know anyone reaching for hstore since the more featureful json support was added.
Re: What ORMs have taught me: just learn SQL (2014)
#5Also, NoSQL taught me to love SQL.
Re: What ORMs have taught me: just learn SQL (2014)
#62014: people respond with indignance that they should have to learn SQL now that there's a shortcut 2026: people respond with indignance that they should have to learn anything now that there's a shortcut
I like SQL. I enjoy writing SQL. I find ORMs produce crap SQL.
But the current shortcut du jour is pretty damn good at writing SQL.
Re: What ORMs have taught me: just learn SQL (2014)
#7The big problem is that raw SQL has pretty bad type inference and linting support in most editors. A query builder can still give you a lot of type safety benefits.
Re: What ORMs have taught me: just learn SQL (2014)
#8As someone who started their programming journey with SQL, it just feels so odd hearing about learning SQL being presented as an useful option. I get it, it just feels odd. SQL was considered table stakes in the financial IT world - if you said you didn't know SQL, people would look at you funny.
Re: What ORMs have taught me: just learn SQL (2014)
#92014: people respond with indignance that they should have to learn SQL now that there's a shortcut 2026: people respond with indignance that they should have to learn anything now that there's a shortcut
At yet people (mostly) skip SQL and learn some ORM.
Re: What ORMs have taught me: just learn SQL (2014)
#10The big problem is that raw SQL has pretty bad type inference and linting support in most editors. A query builder can still give you a lot of type safety benefits.
[flagged]