News for hackers. Stuff that matters.
Re:Inner-platform effect by fleitz on Monday January 09, 2012 @10:01AM (#3442715)
"In the database world, developers are sometimes tempted to bypass the RDBMS, for example by storing everything in one big table with two columns labelled key and value."
Re:Inner-platform effect by raganwald on Monday January 09, 2012 @10:20AM (#3442799)
Database Analysts will tell you that many ORMs are themselves inner platforms, re-implementing constraints, views, joins and so on that should be encoded directly in the database.
Re:Inner-platform effect by jerf on Monday January 09, 2012 @11:06AM (#3442991)
That has become my acid test for how good an ORM is.

Most fail horribly. I count myself lucky if I come across an ORM in some language that didn't visibly have joins bolted on the side in such a way that they just barely work, usually spending all the design value of the library in the project. (That is, merely by using one of these libraries you've often incurred technical debt on the spot.)

Re:Inner-platform effect by eli on Monday January 09, 2012 @12:04PM (#3443227)
Just out of curiosity, have any passed this test?
Re:Inner-platform effect by jerf on Monday January 09, 2012 @02:50PM (#3443959)
Based on reading the documentation, I think Hibernate for Java would qualify. I've never used it, though, so I can't be sure. SQLAlchemy for Python also looks good, but I've also never had the opportunity to use it.
Re:Inner-platform effect by nerd_in_rage on Monday January 09, 2012 @10:17PM (#3445481)
hibernate will make you throw up with all the verbosity and nonsense.

sqlalchemy, on the other hand, is good.

Re:Inner-platform effect by jquery on Monday January 09, 2012 @04:59PM (#3444489)
All sufficiently large CRUD apps either use an established ORM or re-invent them poorly.
Re:Inner-platform effect by fleitz on Monday January 09, 2012 @05:50PM (#3444697)
That's not true, work with some legacy perl apps from the 90s, it's raw SQL all the way down.
Re:Inner-platform effect by romaniv on Monday January 09, 2012 @01:25PM (#3443624)
ORMs aren't implemented in the database, so it's less of an "inner" and more of a "parallel" platform. I think this is an important distinction, since one of the reasons people use ORMs in the first place is better integration with the programming language of their choice. Moreover, there are often practical reason to re-implement those features you've mentioned.

Let's take constraints as an example. Can you use them to display a list of user-friendly validation messages when someone fills out a web form? Will they benefit from all the tools (version control, refactoring, static verification) your language of choice provides? How reusable will they be?

If there were databases with language-friendly APIs for these things, I bet developers would be less likely to re-implement them.

Re:Inner-platform effect by swalsh on Monday January 09, 2012 @11:19AM (#3443042)
I was quite alarmed the first time I used NHibernate with C#. I had some very non descriptive error, and the only solution I could find was removing a constraint I had created in the db.
Re:Inner-platform effect by ajross on Monday January 09, 2012 @12:49PM (#3443471)
The flip side to that argument is that the "M" part of the ORM can be understood an artifact of the poor storage technology, and that the ORM+database system should really be understoood as an object store with transactions, not an API layer.
Re:Inner-platform effect by ExpiredLink on Monday January 09, 2012 @01:11PM (#3443570)
No need to re-invent OODBMS. The had their chance - and failed.
Re:Inner-platform effect by Maro on Monday January 09, 2012 @10:43AM (#3442892)
It you're trying to make a statement about NoSQL databases, then you are missing the point of NoSQL databases.