Gossamer Forum
Home : General : Chit Chat :

Re: [jagerman] Anyone fancy Ruby?

Quote Reply
Re: [jagerman] Anyone fancy Ruby? In reply to
Quote:
I've seen PHP's MySQL interface and I have to say I like GT::SQL much better. Something like GT::SQL (in fact, many of the GT:: modules) wouldn't even be feasible in PHP.


You have to consider the value of a DB abstraction layer though GT:SQL does get things working with many DB's, but this is not nessecarily a good thing! While I will admit useful for commerical scripts such as Links SQL, if you want to take advantage of a databases full capabilties they are not good. They only allow you to use the basic features of databases, rather then taking advantage of the extra features that some databases have.

I was forwarded a message, in which Rasmus Lerdof (the guy that started PHP) was talking about DB abstraction layers. His quote was

Quote:
I am sure everyone by now has heard my opinion on db abstraction layers
though. As far as I am concerned they are pointless. It is the wrong
place to do things. The right way to do database abstraction is at the
functional layer. ie. write a function that implements a certain
database
action your application needs. get_user_record(), for example. Then
write this function for each database your application needs to support.

Anything short of this and you end up with a nearly useless system that
is
only capable of using generic or lowest-common-denominator SQL
statements.
For really simple applications that is ok, I guess, but for anything
substantial you are going to have to use DB-specific SQL to take
advantage
of each database properly. See Oracle's DECODE() statement for a
blatant
example of this.


I have to admit I agree with this.
Cheers,
Michael Bray
Subject Author Views Date
Thread Anyone fancy Ruby? Wil 22821 Jan 14, 2002, 1:17 PM
Thread Re: [Wil] Anyone fancy Ruby?
sponge 22058 Jan 14, 2002, 2:25 PM
Thread Re: [ThatPerson1024] Anyone fancy Ruby?
Paul 21984 Jan 14, 2002, 2:28 PM
Thread Re: [RedRum] Anyone fancy Ruby?
sponge 21928 Jan 14, 2002, 3:34 PM
Thread Re: [ThatPerson1024] Anyone fancy Ruby?
Andy 21942 Jan 15, 2002, 12:35 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Michael_Bray 22073 Jan 15, 2002, 5:04 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Wil 21868 Jan 15, 2002, 5:19 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
Paul 21812 Jan 15, 2002, 5:20 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Wil 21810 Jan 15, 2002, 5:21 AM
Thread Re: [Wil] Anyone fancy Ruby?
QooQ 22075 Jan 15, 2002, 5:27 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 21918 Jan 15, 2002, 5:29 AM
Thread Re: [RedRum] Anyone fancy Ruby?
QooQ 21833 Jan 15, 2002, 5:35 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 21759 Jan 15, 2002, 5:36 AM
Post Re: [RedRum] Anyone fancy Ruby?
Wil 21716 Jan 15, 2002, 5:54 AM
Post Re: [QooQ] Anyone fancy Ruby?
Paul 21633 Jan 15, 2002, 6:15 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 21728 Jan 15, 2002, 6:16 AM
Post Re: [RedRum] Anyone fancy Ruby?
Wil 21808 Jan 15, 2002, 6:21 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Andy 21784 Jan 15, 2002, 6:22 AM
Post Re: [AndyNewby] Anyone fancy Ruby?
QooQ 21635 Jan 15, 2002, 6:28 AM
Thread Re: [RedRum] Anyone fancy Ruby?
QooQ 21632 Jan 15, 2002, 6:22 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Andy 21801 Jan 15, 2002, 6:26 AM
Post Re: [AndyNewby] Anyone fancy Ruby?
QooQ 21556 Jan 15, 2002, 6:30 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Paul 15984 Jan 15, 2002, 6:33 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Andy 15996 Jan 15, 2002, 6:36 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Paul 15814 Jan 15, 2002, 6:37 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Wil 15720 Jan 15, 2002, 6:42 AM
Post Post deleted by Wil
Wil 15561 Jan 15, 2002, 6:43 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Jagerman 15693 Jan 15, 2002, 2:00 PM
Post Re: [jagerman] Anyone fancy Ruby?
Paul 15553 Jan 15, 2002, 2:09 PM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 21736 Jan 15, 2002, 6:29 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Michael_Bray 21840 Jan 15, 2002, 6:32 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
Paul 15847 Jan 15, 2002, 6:36 AM
Post Re: [RedRum] Anyone fancy Ruby?
QooQ 15479 Jan 15, 2002, 6:40 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Michael_Bray 16202 Jan 15, 2002, 6:43 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
QooQ 15674 Jan 15, 2002, 6:48 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 15629 Jan 15, 2002, 7:05 AM
Thread Re: [RedRum] Anyone fancy Ruby?
sponge 15620 Jan 15, 2002, 1:28 PM
Post Re: [ThatPerson1024] Anyone fancy Ruby?
Paul 15601 Jan 15, 2002, 1:29 PM
Post Re: [RedRum] Anyone fancy Ruby?
QooQ 15471 Jan 15, 2002, 6:34 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Michael_Bray 21828 Jan 15, 2002, 6:30 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
QooQ 15617 Jan 15, 2002, 6:32 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Paul 15556 Jan 15, 2002, 6:34 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Jagerman 15753 Jan 15, 2002, 1:57 PM
Thread Re: [jagerman] Anyone fancy Ruby?
Michael_Bray 15794 Jan 16, 2002, 5:25 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Paul 15528 Jan 16, 2002, 7:54 AM
Post Re: [RedRum] Anyone fancy Ruby?
Jagerman 15565 Jan 15, 2002, 1:55 PM