Lists Home |
Date Index |
Daniela Florescu wrote:
>> I was quite surprised
>> to lean that some of my queries were significantly
>> easier to understand and write using xBase (index based
>> iterators, linked with other iterstors if necessary)
>> than using SQL.
> !? Com' on Karl.
> If you add/remove an index you have to rewrite your xBase
> application. If the volume of data or the frequency of queries
> changes you gave to rewrite your application. Etc. Etc. Etc.
That application's data access patterns haven't changed since
1998, and it is still in production! That is rather typical
for many corporate apps.
But for the sake fo the argument, let's say I have to spend
a day rewriting the query. Well, I have seen SQL problems
that took a week to get right. Sure, a simple SELECT is very
easy to do, and I would use SQL when appropriate.
But that is not what I was writing about.
> Do I have to say anything more !?
> We are 30 years after Ted Codd, and many, many billions dollars
> market later. I find it really strange that I need to argue in favor of the
> declarativity in 2004, almost 2005.
Well, my experience taught me that SQL isn't the best approach
all the time. I am not going to argue against my own experience...