Slashdot Mirror


Slimmed Down MySQL Offshoot Drizzle is Built For the Web

Incon writes "Builder AU reports that Brian Aker, MySQL's director of architecture, has unveiled Drizzle, a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL. Drizzle will have a micro-kernel architecture with code being removed from the Drizzle core and moved through interfaces into modules. Aker has already selected particular functionality for removal: modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, access control lists and some data types."

12 of 370 comments (clear)

  1. Great, even more insecure web apps by Jimmy+King · · Score: 5, Insightful

    This is stupid. Removing prepared statements and access control lists? Don't we have enough trouble with people writing insecure web apps when we provide them with the tools easily make them secure?

    1. Re:Great, even more insecure web apps by bingo_cannon · · Score: 5, Interesting

      Umm..errrr! Drizzle will have a micro-kernel architecture with code being removed from the Drizzle core and moved through interfaces into modules. Akers has already selected particular functionality for removal: modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, access control lists and some data types."

  2. Drizzle? by CheeseTroll · · Score: 5, Funny

    Fo' shizzle!

    --
    A post a day keeps productivity at bay.
    1. Re:Drizzle? by krkhan · · Score: 5, Funny

      In other news, PostgreSQL releases sprinkle, SQLite releases Rivulet while Oracle defies all conventions and releases Hailstorm.

      Microsoft, of course, was busy "revolutionizing" the look-n-feel of MS Access.

  3. Re:Love the lack of Windows support ! by hostyle · · Score: 5, Funny

    Why would anyone in their right mind set up a Web/SQL platform using MS products?

    My name is Maximus Decimus^W^WBill Gates, ex-commander of the Armies of Redmond, General of the MS Legions, loyal servant to the true emperor, Steve Ballmer. Father of a murdered operating system. Husband of a bloated Office Productivity Suite. I shall have my vengeance, in this web or the next.

    --
    Caesar si viveret, ad remum dareris.
  4. So it's like SQLite... by Anonymous Coward · · Score: 5, Funny

    ...reinvented, but with security flaws. Awesome!

  5. Removing all the useful things... by nvivo · · Score: 5, Insightful

    a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL ... Akers has already selected particular functionality for removal: modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, access control lists and some data types."

    I have been developing for the web during the past years and that's why MySQL has been off my list for serious development for some time in favor of Postgresql. It took about a decade to implement basic features like views and foreign keys that even Access 2.0 had in 93. Even sqlite has views for god sake!

    Today, even for the most simple projects I cannot think about not using views, stored procedures, and triggers. Not because there is no way to do the job, but because they are important for organization, security, data integrity, etc.

    It is like they have no idea that web sites are getting more complicated, and more and more data is involved everyday. I can't think of someone creating a big website with massive concurrency using this. Sounds more like an alternative to Sqlite for very simple tasks.

  6. Re:Love the lack of Windows support ! by nvivo · · Score: 5, Insightful

    Why would anyone in their right mind set up a Web/SQL platform using MS products?

    Because it is reliable, easy to develop, implement and support?

  7. Re:Shnizzle by maxume · · Score: 5, Funny

    That's not how that English guy on House talks.

    --
    Nerd rage is the funniest rage.
  8. All for it by spinkham · · Score: 5, Interesting

    From my point of view, this is MySQL finally embracing their target market.
    These features are great and important, but if you're doing small scale web programming through a framework that uses an ORM, or just very simple SQL, why not slim the program down?
    If you want real database features, you probably shouldn't be using MySQL in the first place in my opinion.

    --
    Blessed are the pessimists, for they have made backups.
  9. Re:Love the lack of Windows support ! by tobiasly · · Score: 5, Insightful

    Traditionally MySQL was just the toy database for non-critical stuff that you wanted speed out of (and little else). If Drizzle accomplishes that, then I don't see a real place for the mainline MySQL anymore. Drizzle if you want speed, PostgreSQL if you want features/stability, and Oracle if you gots money to spend.

    The thing that people always seem to discount when comparing MySQL to PostgreSQL is community mindshare and comfort level. That's why it's called a LAMP stack. If products always won on technical merits, 90% of PCs would run OS/2 instead of Windows.

    I'll admit, even though I "know" that PG is supposed to be a better database, anytime I'm starting a new web app I go for MySQL. It's what most of the frameworks and toolkits support first and/or best. It's what more tech support guys at the web hosting companies are familiar with. Plus MySQL has *much* better GUI tools than PG.

    If both products were starting from scratch, then yeah maybe PG would have a good shot. But MySQL isn't bad enough, and PG isn't better enough, to make me or others like me feel like switching. I'm not comfortable with the PG toolset because I'm not familiar with it, and I have better things to do with my time than learn it, because for me the perceived potential benefit isn't worth it.

    Of course, none of this is to say that Sun won't f*ck up MySQL enough to make me change my mind...

  10. Re:Shnizzle by ruiner13 · · Score: 5, Funny

    Go have a fag while sitting on the bonnet of a Bobbie car, wanker.

    --

    today is spelling optional day.