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 19527 Jan 14, 2002, 1:17 PM
Thread Re: [Wil] Anyone fancy Ruby?
sponge 18929 Jan 14, 2002, 2:25 PM
Thread Re: [ThatPerson1024] Anyone fancy Ruby?
Paul 18849 Jan 14, 2002, 2:28 PM
Thread Re: [RedRum] Anyone fancy Ruby?
sponge 18792 Jan 14, 2002, 3:34 PM
Thread Re: [ThatPerson1024] Anyone fancy Ruby?
Andy 18776 Jan 15, 2002, 12:35 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Michael_Bray 18905 Jan 15, 2002, 5:04 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Wil 18678 Jan 15, 2002, 5:19 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
Paul 18681 Jan 15, 2002, 5:20 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Wil 18680 Jan 15, 2002, 5:21 AM
Thread Re: [Wil] Anyone fancy Ruby?
QooQ 18946 Jan 15, 2002, 5:27 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 18792 Jan 15, 2002, 5:29 AM
Thread Re: [RedRum] Anyone fancy Ruby?
QooQ 18698 Jan 15, 2002, 5:35 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 18629 Jan 15, 2002, 5:36 AM
Post Re: [RedRum] Anyone fancy Ruby?
Wil 18593 Jan 15, 2002, 5:54 AM
Post Re: [QooQ] Anyone fancy Ruby?
Paul 18511 Jan 15, 2002, 6:15 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 18601 Jan 15, 2002, 6:16 AM
Post Re: [RedRum] Anyone fancy Ruby?
Wil 18682 Jan 15, 2002, 6:21 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Andy 18661 Jan 15, 2002, 6:22 AM
Post Re: [AndyNewby] Anyone fancy Ruby?
QooQ 18507 Jan 15, 2002, 6:28 AM
Thread Re: [RedRum] Anyone fancy Ruby?
QooQ 18505 Jan 15, 2002, 6:22 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Andy 18660 Jan 15, 2002, 6:26 AM
Post Re: [AndyNewby] Anyone fancy Ruby?
QooQ 18432 Jan 15, 2002, 6:30 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Paul 13243 Jan 15, 2002, 6:33 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Andy 13271 Jan 15, 2002, 6:36 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Paul 13067 Jan 15, 2002, 6:37 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Wil 12984 Jan 15, 2002, 6:42 AM
Post Post deleted by Wil
Wil 12833 Jan 15, 2002, 6:43 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Jagerman 12941 Jan 15, 2002, 2:00 PM
Post Re: [jagerman] Anyone fancy Ruby?
Paul 12822 Jan 15, 2002, 2:09 PM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 18605 Jan 15, 2002, 6:29 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Michael_Bray 18706 Jan 15, 2002, 6:32 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
Paul 13084 Jan 15, 2002, 6:36 AM
Post Re: [RedRum] Anyone fancy Ruby?
QooQ 12753 Jan 15, 2002, 6:40 AM
Thread Re: [RedRum] Anyone fancy Ruby?
Michael_Bray 13455 Jan 15, 2002, 6:43 AM
Thread Re: [Michael_Bray] Anyone fancy Ruby?
QooQ 12936 Jan 15, 2002, 6:48 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Paul 12898 Jan 15, 2002, 7:05 AM
Thread Re: [RedRum] Anyone fancy Ruby?
sponge 12886 Jan 15, 2002, 1:28 PM
Post Re: [ThatPerson1024] Anyone fancy Ruby?
Paul 12851 Jan 15, 2002, 1:29 PM
Post Re: [RedRum] Anyone fancy Ruby?
QooQ 12726 Jan 15, 2002, 6:34 AM
Thread Re: [QooQ] Anyone fancy Ruby?
Michael_Bray 18698 Jan 15, 2002, 6:30 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
QooQ 12885 Jan 15, 2002, 6:32 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Paul 12829 Jan 15, 2002, 6:34 AM
Thread Re: [AndyNewby] Anyone fancy Ruby?
Jagerman 13002 Jan 15, 2002, 1:57 PM
Thread Re: [jagerman] Anyone fancy Ruby?
Michael_Bray 13042 Jan 16, 2002, 5:25 AM
Post Re: [Michael_Bray] Anyone fancy Ruby?
Paul 12788 Jan 16, 2002, 7:54 AM
Post Re: [RedRum] Anyone fancy Ruby?
Jagerman 12833 Jan 15, 2002, 1:55 PM