4 ms·
I agree with the author's sentiment, in the context of relational databases. I can't get back the time and effort spent porting SQL to query builder and/or orm
by Dowwie 8y ago
I agree with the author's sentiment, in the context of relational databases. I can't get back the time and effort spent porting SQL to query builder and/or orm syntax. The best I can do is learn from my lapse of sound judgment and instead use parameter binding against raw SQL and never interpolate strings of SQL.
I regret not adopting this practice sooner.
Most of my substantial work resides in that raw SQL feature. So, I use a library that offers good support of that.
I have written hundreds of SQL using query builders and ORMs.
- threeseed 8y agoEvery ORM (and I mean every one) has the ability to let you either (a) use raw SQL, (b) use raw SQL interpolated with column names or (c) has a syntax which is very close to SQL. Porting should not have been some onerous or career destroying activity. As Job would say I think you've made a huge mistake.
- Dowwie 8y agoThose who don't learn from mistakes will repeat them. I've learned from my mistakes and share a lesson today. Most of my substantial work resides in that raw SQL feature. So, I use a library that offers good support of that. I have written hundreds of SQL using query builders and ORMs.
- thanatropism 8y agoIf you mean the character voiced by Bojack Horseman in "Arrested Development", it's spelled Gob. Amazing how they got Bojack into that human costume.