[Gllug] Drizzle - new SQL engine for the web from MySQL

[James Laver]

On 26/7/08 02:05, "Andrew Farnsworth" <farnsaw at stonedoor.com> wrote:

> Actually, it makes a lot of sense.  Most web databases, especially for
> simple applications, don't use stored procedures at all.  This is often
> due to the fact they they are usually written by someone who barely
> knows how to create a database and will place all of the business logic
> into their application code and not in the database.  This has the
> advantage of making your application database agnostic (i.e. will run on
> MySQL, PostgreSQL, Microsoft SQL Server, DB2, Oracle ...).  Many people
> won't admit it, but being able to say your application runs on Oracle
> can be a real selling point when it comes to the Enterprise (No, not
> NCC1701, big business).  To many people involved in FOSS big business is
> a dirty word, but once you get out in the real world, you realise that
> business is what makes the world go around, pays the bills, and lets you
> spend time on personal projects rather than working 24/7 to make ends
> meet.  Don't get the wrong idea, in the enterprise, FOSS is not a dirty
> word by any stretch of the imagination.  A lot of companies make a lot
> of money supporting and servicing FOSS which is why companies like IBM
> have tied themselves so tightly to FOSS, contributing time, money, and
> effort into project that they don't get paid (directly) for.
> 
> Ok, that ends MY rant :-)
> 
> Andy
> 

On the other hand, application code is the wrong place to do this. How are
you supposed to enforce foreign keys manually? What about transactions? As
far as enterprise goes, much as it might just about work in oracle, you're
not exactly making the best use of it. This is like suggesting that an
enterprise use PHPBB because it supports oracle, and ignoring the security
issues for a minute, it suffers from the exact same problem I've mentioned -
it does all of its data stuff in the code rather than in the database.

I can understand most PHPBB users will be using MySQL (and possibly soon
drizzle, but that doesn't mean that it isn't worth time doing it properly
for other database engines that can do more, and better. At the end of the
day, ticking a box saying 'supports oracle' is no better than writing a java
application then ticking the box saying 'supports linux' - of course it
supports Linux, it's just plain old java. *

</rant>

--James

* Okay, I know it's quite easy to write an application tied to a particular
OS, but I had a point to make.


-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug