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 #184402 is a reply to message #184400]

Mon, 30 December 2013 17:36

Daniel Pitts
Messages: 68
Registered: May 2012

Karma:

Member

On 12/30/13 5:38 AM, Silvio wrote:
[snip]
> To make things worse almost no system only needs single object
> instances. Almost any practical system needs counts, averages etc. which
> could be done with a query on an RDBMS or by traversing object instances
> IF THEY WHERE REAL INSTANCES. Since doing the latter with an ORM would
> require resurrecting enormous amounts of instances for practical reasons
> you have to pour water into the wine and do atypical stuff like joins
> and aggregate queries through the ORM. I know they CAN do this but that
> is no more than a wart on such systems since they contradict the primary
> goal of an ORM. This is also the area where ORMs failed in the projects
> I talked about. It's not that the ORM can not do it, it just can not do
> it sufficiently well even with help from the most experienced experts we
> could find.
This is a good point, and it was something niggling in subconscious.
This is where I've always struggled with ORMs, but I never consciously
acknowledged that the difficulty was in utilizing the power of the "R"
in The ORM.

>
> I still think the best approach for most systems is to design a separate
> and independent data store that covers the problem domain which is
> completely isolated from the systems that implement data extractions,
> processes and data storage. I do not manually write code to serialize
> object instances since I do not serialize them in the first place. Such
> a data store can be an RDBMS but if so desired a NoSQL thingy or even a
> file system could do well. Using an RDBMS gives the additional advantage
> that the data is readily accessible for standard reporting and ETL tools.
This is one approach. I think one of the major "features" of most ORM
implementations is that they attempt to abstract away the actual RDBMS
layer to the point where you feel "dirty" trying to access it in any
meaningful way. This does provide some value in portability, but many
applications rarely need this portability of RDBMS, and more often
benefit from special features of the particular RDBMS chosen.

I once actually had to "extend" (read hack) Hibernate to allow the
"group_concat" MySQL call in an HQL query.

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:28:33 GMT 2024

Total time taken to generate the page: 0.04143 seconds