FUDforum: comp.lang.php » ORMs comparisons/complaints.

Home » Imported messages » comp.lang.php » ORMs comparisons/complaints.

Show: Today's Messages :: Polls :: Message Navigator

Re: ORMs comparisons/complaints. [message #184319 is a reply to message #184311]

Sun, 22 December 2013 21:26

Marcel Müller
Messages: 1
Registered: December 2013

Karma:

Junior Member

On 22.12.13 20.05, Daniel Pitts wrote:
> This is cross-posted to cl.java.programmer and cl.php.

The topic is unlikely to fit to php. F'up to java only.

> I've been doing some thinking about my experiences with various ORMs,
> both positive and negative. I find that I often stretch systems to there
> limits, and end up doing a lot of meta-programming to solve problems
> that I've always felt should have been solved by the core libraries.
> Mostly to follow DRY and KISS principals in the core business code.

First of all you need to mention what ORMs are designed for. They are
intended to make SQL databases suitable for OO programming style and/or
non-relational data models. At the end OO expressions are turned into
SQL and then to an execution plan.
From that you can see that there is exactly one thing superfluous in
this scenario: SQL. It is the bottleneck where all expressions must fit
to. But it does not add any functionality, quite the contrary. It is
just a emulation level for compatibility, like a SATA adapter enables a
SATA drive to be used with an IDE port.

You see, I am not really a friend of ORM. If a relational data model
does not fit your needs, you first should consider to use a non
relational database, rather than to normalize the data model to fit into
a relational DB, and use an ORM to hide that from the application layer.

ORMs are known to slow things down. I don't think that this is true in
general. But the ORM layer makes some trivial looking expressions
amazingly complex. So it is not that easy for the programmer to estimate
the complexity of a code block, without knowledge about the entire ORM
layer and the base data model in SQL. In fact I have redesigned many
code parts because of this.

There is one advantage. Adding attributes to the data model is quite
simple with an ORM. No need to do redundant changes at many locations.
But any document DB will provide this as well without the need for SQL
and an ORM.

Of course, if you are stuck with an SQL DB for some reason and you need
to adapt to an OO application layer ORM might be a choice. But if the
data model in the DB is not intended for ORM usage, you won't get happy,
because there are almost always properties of the data model that are
not correctly modeled in SQL.

However, to get more detailed information you need to phrase your
questions more precisely. What are your topics of interest? Performance?
Maintainability? What kind of data model do you intend to use? Many
entities? Or many properties? What kind of relations? Polymorphism?

Marcel

Report message to a moderator

[Message index]

		ORMs comparisons/complaints. By: Daniel Pitts on Sun, 22 December 2013 19:05
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 19:46
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 20:17
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 20:38
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 20:47
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 21:04
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 21:09
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 21:20
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 21:34
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 01:54
		Re: ORMs comparisons/complaints. By: Michael Vilain on Mon, 23 December 2013 04:48
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 23 December 2013 12:58
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 03:46
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 03:54
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:06
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 04:21
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 13:04
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 17:32
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 17:47
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 21:23
		Re: ORMs comparisons/complaints. By: Doug Miller on Mon, 30 December 2013 19:45
		Re: ORMs comparisons/complaints. By: Ricardo Palomaes on Mon, 30 December 2013 18:20
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Mon, 30 December 2013 18:34
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 19:27
		Re: ORMs comparisons/complaints. By: Marcel Müller on Sun, 22 December 2013 21:26
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:17
		Re: ORMs comparisons/complaints. By: Kevin McMurtrie on Mon, 23 December 2013 00:11
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:08
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Mon, 30 December 2013 21:36
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Mon, 30 December 2013 22:13
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 02:09
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Tue, 31 December 2013 11:30
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Tue, 31 December 2013 13:11
		Re: ORMs comparisons/complaints. By: Chris Uppal on Wed, 01 January 2014 14:20
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:05
		Re: ORMs comparisons/complaints. By: Qu0ll on Thu, 02 January 2014 03:48
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:57
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 08:04
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:54
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 08:09
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:54
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Fri, 03 January 2014 13:18
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 21:45
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 06:38
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 23 December 2013 12:57
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 23:11
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Tue, 24 December 2013 00:59
		Re: ORMs comparisons/complaints. By: Qu0ll on Tue, 24 December 2013 01:14
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:02
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 04:40
		Re: ORMs comparisons/complaints. By: Silvio on Mon, 23 December 2013 12:25
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:27
		Re: ORMs comparisons/complaints. By: Silvio on Mon, 30 December 2013 13:38
		Re: ORMs comparisons/complaints. By: Daniel Pitts on Mon, 30 December 2013 17:36
		Re: ORMs comparisons/complaints. By: Silvio on Tue, 31 December 2013 00:26
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:23
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:19
		Re: ORMs comparisons/complaints. By: Silvio on Thu, 02 January 2014 11:36
		Re: ORMs comparisons/complaints. By: Daniel Pitts on Thu, 02 January 2014 17:36
		Re: ORMs comparisons/complaints. By: Silvio on Thu, 02 January 2014 20:06
		Re: ORMs comparisons/complaints. By: Chris Uppal on Fri, 03 January 2014 14:48
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:59
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 02:07
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 02:10
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 13:44
		Re: ORMs comparisons/complaints. By: leif.roar on Mon, 23 December 2013 13:22
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:20
		Re: ORMs comparisons/complaints. By: Wanja Gayk on Tue, 24 December 2013 11:28
		c By: Jerry Stuckle on Tue, 24 December 2013 13:49
		Re: c By: Qu0ll on Tue, 24 December 2013 22:35
		Re: c By: Graham Hobbs on Wed, 25 December 2013 00:35
		Re: c By: Jerry Stuckle on Wed, 25 December 2013 05:08
		Re: c By: Qu0ll on Wed, 25 December 2013 06:46
		Re: c By: Graham Hobbs on Wed, 25 December 2013 14:24
		Re: c By: Qu0ll on Wed, 25 December 2013 09:41
		[EOD] Re: c By: Wanja Gayk on Wed, 25 December 2013 10:15
		Re: [EOD] Re: c By: Qu0ll on Wed, 25 December 2013 12:29
		Re: [EOD] Re: c By: The Natural Philosoph on Wed, 25 December 2013 12:48
		Re: c By: Arne Vajhøj on Mon, 30 December 2013 03:51
		Re: c By: Jerry Stuckle on Mon, 30 December 2013 13:03
		Re: c By: Arne Vajhøj on Mon, 30 December 2013 17:40
		Re: c By: Jerry Stuckle on Mon, 30 December 2013 17:46
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Wed, 25 December 2013 17:56
		Re: ORMs comparisons/complaints. By: jebblue on Tue, 31 December 2013 16:52
		Re: ORMs comparisons/complaints. By: Evan Platt on Tue, 31 December 2013 19:50
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 21:54
		Re: ORMs comparisons/complaints. By: jebblue on Wed, 01 January 2014 01:33
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 21:37
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:46
		Re: ORMs comparisons/complaints. By: Gordon Levi on Thu, 02 January 2014 08:34
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:43
		Re: ORMs comparisons/complaints. By: Gordon Levi on Fri, 03 January 2014 09:19
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 20:43

Previous Topic:	tracking file usage
Next Topic:	Processing accented characters submitted from forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 02:16:56 GMT 2024

Total time taken to generate the page: 0.03616 seconds