Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by benmccann on Friday October 29, 2010 @01:07PM
(#1847978)
PL/SQL is an awful language to work with. What's up with having to declare variables before using them? Does it not even have multi-pass compilation?! And it works only with Oracle, which causes lock-in I'd rather avoid.
I'd rather create a service layer on top of my DB and access it through that. Then I have more control over logging, managing access, pubsub, etc.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by gaius on Friday October 29, 2010 @01:57PM
(#1848233)
It makes me laugh, people who won't write a single keyword to specify the type of a variable, but will write a hundred lines of unit tests to make sure it's always what you want.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by nailer on Friday October 29, 2010 @07:47PM
(#1849535)
Dude. Stop it. He didn't mention unit tests. If you have a point, stop making stuff up about the posters you're responding to.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by gaius on Saturday October 30, 2010 @03:34AM
(#1850371)
Oh I'm sorry, didn't know we were playing word games. The above poster complained about having to declare the types of his variables as if that was a bad thing. I simply pointed why it was in fact a good thing - you don't now need to do tests to ensure that your function that expects an INT always gets an INT, the type system takes care of it for you.
Discussions at this level presuppose a certain amount of background knowledge. Do try to keep up.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by nailer on Saturday October 30, 2010 @04:07AM
(#1850418)
You mean as opposed to creating tests for storage failures when my strongly typed DB complains?
things need to be tested, strongly typed DB or not.
Please quit it with the Rude manner. It's against HN guidelines and makes your arguments weaker to boot. Or leave and go somewhere else.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by konad on Friday October 29, 2010 @01:34PM
(#1848118)
Declaring variables isn't hard.
However, in Postgresql one can use many languages to write stored procs. I prefer plpgsl but TCL, Python and Perl are also available in the stock distribution.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by jbooth on Friday October 29, 2010 @01:51PM
(#1848201)
"isn't hard"? Yeah, writing it in Algol isn't "hard" either, but why? If something's harder to use and less performant, why would it even be on my list of things to maybe consider?
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by konad on Monday November 01, 2010 @03:13PM
(#1857764)
C coders manage easily enough.
Re:NoSQL Took Away The Relational Model And Gave Nothing Back
by jbooth on Friday October 29, 2010 @12:42PM
(#1847882)
The maintenance issue is tractable, I'm just saying that PL/SQL doesn't make it easier and probably makes it worse by being hard to unit test, refactor, etc (although this is very subjective and depends on the strengths of your team).
The scalability problem? Good luck getting 90%+ of your processing out of the database. Rewrite from scratch?
In my experience, and perhaps with my bias as someone who's very comfortable with (relational) databases, I have seen plenty of nightmarish scenarios involving, say, Hibernate.