[Gllug] [VACANCY] SQL Developer

[Peter Childs]

On 07/06/07, Karanbir Singh <mail-lists at karan.org> wrote:
>
> Peter Childs wrote:
> >  Why MySql? Why not use a database which does not have Massive database
> > corruption problems no referential interrogatory.
>
> While I am sure these are issues that have caused you grief at some
> point or the other - I've never had such issues, and we do use mysql
> quite extensively. And, were unlikely to make a change at this stage.



Innodb - Has transactions slow and has scaling issues.
Myisam - No Transactions but fast.

Thats not to say the failure to through errors for invalid data and to just
blindly accept it and fail to do anything with it.
MySql may be fine for most peoples web app but don't try using it on any
really really large amounts of data (or speed) where the data actual
matters.

Peter.


> MySql may have come a
> > long way but it is nothing short of a quick and dirty solution. I can
> > find a list a mile long of reasons not to use MySql...
>
> While it may make for good social chatter around a few beers, I can
> assure you that we did trial a few other db's at various times, when we
> had the options, and we've not really come up with a viable other
> option. Well, a neteeza box wold be nice to have - however, millions of
> pounds is not what we are looking to spend here!
>
> > Unfortunately I'm yet to find a reason to use it. (except maybe "Because
> > everyone else does" which just does not work for me :).
>
> functional, working replication and a very low barrier to entry are two
> good reasons to start with mysql - and fairly respectable performance
> too. Lots of people start with mysql and then as their needs change and
> their own knowledge of the db ecosystem evolves they move to other
> solutions like firebird, pgsql - heck even sqlite is something often
> considered these days.
>
> --
> Karanbir Singh : http://www.karan.org/ : 2522219 at icq
> --
> Gllug mailing list  -  Gllug at gllug.org.uk
> http://lists.gllug.org.uk/mailman/listinfo/gllug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20070607/3fb32400/attachment.html>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug