Tony's Live Journal on livejournal - Advanced databases for beginners

2008-07-30

10:48:00 - Advanced databases for beginners

Previous Entry Add to Memories Tell a Friend Next Entry

I was reading a blog post decrying Drizzle suggesting it really was a good thing that MySQL now had all the things that a "proper" RDBMS should have like referential integrity, triggers, views and stored procedures. That lead to a presentation from where I got the title of this post. It is obviously slightly less easy to follow as you don't have the author filling in around the bullet points but it seams to me to be a good introduction to more advanced database concepts for the quick and dirty db generation (of which I often am, a more traditional member questioned my use of an implicit join recently, I didn't have time to tell my range safety proverb).

This then lead me on again, to find out more about the web presentation framework used. It is called S5 looks to be simple to work from and about a nanosecond's research has already found at least one conversion tool from another documentation format and it looks ideal for use with many of the current templating engines.

(Leave a comment)

Comments:

[User Picture]
From:[info]gwengothelf
Date:2008-07-30 10:59:10 (UTC)
(Link)
*puts on DBA black robe and convenes the inner circle*
(Reply) (Thread)
[User Picture]
From:[info]thegreatgonzo
Date:2008-07-30 13:09:03 (UTC)
(Link)
There were a number of things that were definitely opinion and it could have done with a few more YMMVs but on the whole a lot better than a lot of suff written on the subject.
There have been a lot of stuff recently where n00bs using stuff like views etc for the first time have written rants that effectively say "MySQL is shit, my unoptimised query that I haven't bothered looking at indexing for runs slowly as a view".
(Reply) (Parent) (Thread)
[User Picture]
From:[info]blue_jez
Date:2008-07-30 13:17:08 (UTC)
(Link)
At least they have some comprehension of the fact they are using database functionality, they could all be Ruby on Rails developers assuming the magic ActiveRecord pixies will do it for them.
(Reply) (Parent) (Thread)
[User Picture]
From:[info]thegreatgonzo
Date:2008-07-30 16:04:23 (UTC)
(Link)
It would be great if a certain someone read the last bullet point of that presentation...
(Reply) (Parent) (Thread)