MySQL only!

Nao

  • Dadman with a boy
  • Posts: 16,079
MySQL only!
« on May 6th, 2011, 05:10 PM »
Feature: MySQL only!
Developer: Arantor
Target: modders, themers, admins
Status: 100% (complete.)
Comment:

PostgreSQL and SQlite are great database systems. But they just aren't used that much, and they add more complexity to database development in SMF. Wedge continues abstracting database queries, but doesn't attempt to convert them to another SQL language.
From our experience, users with PGSQL or SQlite installed on their server always have MySQL installed as well. If you really don't, Wedge just isn't for you, but we won't go back to applying patches for systems that no one really ever uses. It makes development tedious, longer, and probably insecure.

Re: MySQL only!
« Reply #16, on May 7th, 2011, 11:52 PM »
Just to be clear -- we are not going to offer support for anything else than MySQL, and we never will. At least I won't, and I think Pete won't...

Re: MySQL only!
« Reply #17, on May 8th, 2011, 01:01 AM »Last edited on May 8th, 2011, 01:12 AM by CJ Jackson
Quote from Arantor on May 7th, 2011, 10:27 PM
Except that you still have the issue of platform specific queries, because PDO doesn't rewrite queries.
I agree, it's does not rewrite queries, only a full blown database abstraction layer can do that, such as doctrine (it's built on top of PDO).  PDO is only a database access layer, not an abstraction layer.

My intention was only to post the main different between MySQL and MySQLi, as Nao and Arantor never used MySQLi.

Re: MySQL only!
« Reply #18, on May 8th, 2011, 01:13 PM »
mysqli can be used OOP which can be real nice ;)

well... I don't know that law, yet. looks like I have to ask google

Re: MySQL only!
« Reply #19, on June 22nd, 2011, 01:04 AM »
Arantor, you've seen my posts about prepared statements on SMF as well as many of my other SQL related posts. One of the big things with having a query name is that you can then do caching or break it down even more. You can use the name as a hook. There's a bunch of things you can do.

Re: MySQL only!
« Reply #20, on June 22nd, 2011, 01:16 AM »
Yes, I saw. I'm not entirely sure what the benefits would be of using prepared statements vs what we're already doing (and how that's only going to change going forward anyway), and looking at the documentation it seems that we'd have to use the SQL syntax rather than the more elegant method (or converting everything to use MySQLi) which really seems to eradicate any benefits we could get from it.

Most hosts still provide ext/mysql and that's fine for now. Changing to async queries and the OOP style doesn't really achieve all that much so we don't really stand to gain much from changing to MySQLi; in any case the biggest DB overhead is one that MySQLi can't optimise for and that schema changes need to come first.

Re: MySQL only!
« Reply #21, on June 22nd, 2011, 02:35 AM »
That's one of the benefits of the abstraction layer though: you can support MySQLi and MySQL and the title of this topic still holds true ;)

Re: MySQL only!
« Reply #22, on June 22nd, 2011, 10:36 AM »
Except that we removed half of the abstraction layer because it added complexity and a series of kludgy workarounds for things.

Re: MySQL only!
« Reply #23, on August 15th, 2011, 06:44 PM »
Quote from Nao/Gilles on May 7th, 2011, 11:52 PM
Just to be clear -- we are not going to offer support for anything else than MySQL, and we never will. At least I won't, and I think Pete won't...
Not to "poke the bear", but have you considered/played with Percona at all?

http://www.percona.com/software/percona-server/faq/

I haven't had a chance to dig into it too much personally yet, but the online export features could be interesting from a backup perspective...

Re: MySQL only!
« Reply #24, on August 15th, 2011, 06:47 PM »
Never heard of it personally.

Re: MySQL only!
« Reply #25, on August 15th, 2011, 07:10 PM »
Quote from Snape on August 15th, 2011, 06:44 PM
Not to "poke the bear", but have you considered/played with Percona at all?

http://www.percona.com/software/percona-server/faq/

I haven't had a chance to dig into it too much personally yet, but the online export features could be interesting from a backup perspective...
Since it is already compatible with standard MySQL syntax, it shouldn't take long to provide support for it.

Re: MySQL only!
« Reply #26, on August 15th, 2011, 07:21 PM »
I actually had an interview with them, and as for their MySQL knowledge, half of the Percona core team actually wrote the best (IMHO) book on High Performance MySQL.

It should be pretty much a drop in replacement for MySQL.

Re: MySQL only!
« Reply #27, on August 16th, 2011, 08:07 AM »
Percona is nice (its close enough to a drop in replacement for MySQL for most things) but I've never tried to use it in a production environment. In theory, its a performance optimised version of MySQL. However, I've never been close enough to maxing the capabilities of MySQL to decide to replace it. (e.g. My solution to bottlenecks has always been to modify the web application or acquiring more server resources for the application)


P.S.
I wish we could report posts (see the post above with airport parking services SEO linking. Probably a bot :P)

Re: MySQL only!
« Reply #28, on August 16th, 2011, 08:47 AM »
Sine changing from MySQL to Percona we recognize a huge performance benefit. Fully compatible to MySQL but much faster and really stable. 

Re: MySQL only!
« Reply #29, on August 16th, 2011, 09:05 AM »
Quote from Eros on August 16th, 2011, 08:07 AM
P.S.
I wish we could report posts (see the post above with airport parking services SEO linking. Probably a bot :P)
You can simply reply like you did ;)
I do read all of the posts on these boards so don't worry, I eventually see and delete these posts & accounts (I might miss posts if they're edited later though...)

Also, I'm a bit concerned that we're getting our first spammer since I enabled the Arantor Captcha and a custom question. Both of these together should have stopped them all...

Re: MySQL only!
« Reply #30, on August 16th, 2011, 09:16 AM »
Experience tells me that SEO services spam is actually human driven, and no amount of CAPTCHAs or questions can defeat that.