Thread

I’ll be really interested to hear from someone on the dev team like Jones or Pascal about this, as well as the community’s thoughts as a whole. Why is ExpressionEngine limited to using MySQL? It made sense for 1.x, but now EE is on CodeIgniter, switching it would be reasonably simple.

There are so many reasons for using a system such as Postgres over MySQL now it’s getting to the point where I can’t even justify using MySQL when I can’t help it. PostgreSQL is faster, better supported, scales better out of the box and has a nicer PHP interface. It contains a full-text search engine, which means no hacky Sphinx implementations.

It’s securer, and best of all, it’s not owned by Oracle.

I understand that MySQL is the more ubiquitous of the two, but there really is such a strong argument for using Postgres it’d be fantastic if it was possible to use EE on the better of the two. MySQL and Postgres use a very similar dialect of SQL so converting the hardcoded queries over would be easy too.

What does everybody think?

I’d also welcome a discussion about having the option of another db choice other than MySQL… PostGres would be a great option if possible.

Regards,

Carl

...but now EE is on CodeIgniter, switching it would be reasonably simple.

Not really. From a technical stand point the switch wouldn’t be a huge challenge, I imagine. But in terms of man-hours. Yeah, that would be a bit of work. So much of EE’s query building is still done outside of Active Record which would mean a lot of time spent changing that before even testing other DBs extensively.

I’d much rather see the dev team spend time on other aspects of the software before any database changes

If it isn’t broken, don’t fix it.

Let’s fix the broken stuff first.

...but now EE is on CodeIgniter, switching it would be reasonably simple.

Not really. From a technical stand point the switch wouldn’t be a huge challenge, I imagine. But in terms of man-hours. Yeah, that would be a bit of work. So much of EE’s query building is still done outside of Active Record which would mean a lot of time spent changing that before even testing other DBs extensively.

You’d be surprised how many MySQL queries will run on PostgreSQL without a single change.

You’d be surprised how many MySQL queries will run on PostgreSQL without a single change.

Ah, duly noted 😊

Let’s fix the broken stuff first.

Lots more job security in that ‘cause it’s a healthy list.

I ran into MySQL limitations recently with a heavily customised EE site. PostgreSQL would have been nice in that scenario. So yes, in an ideal world I’d love EE to run on it so would voice my support…. but I understand this isn’t an ideal world and web development tends to be one big compromise anyway 😉

I love the idea, myself. Postgres isn’t quite as ubiquitous on shared hosts as MySQL, but it’s getting a lot more common. And i would LOVE to be able to work in Postgres’ better dialect of SQL…

Count me in as well, specially than Mac Servers switched to it.

Someone wrote a wordpress plugin to use Postgres which I’m using on another site.

I also have same thoughts, by the way hy i am watson new here. I want to ask one thing is there any topic on this forum where i can see the list of sites which use expression engine?

...but now EE is on CodeIgniter, switching it would be reasonably simple.

Not really. From a technical stand point the switch wouldn’t be a huge challenge, I imagine. But in terms of man-hours. Yeah, that would be a bit of work. So much of EE’s query building is still done outside of Active Record which would mean a lot of time spent changing that before even testing other DBs extensively.

I’d much rather see the dev team spend time on other aspects of the software before any database changes

If it isn’t broken, don’t fix it.

Let’s fix the broken stuff first.

Welcome!

I want to ask one thing is there any topic on this forum where i can see the list of sites which use expression engine?

Try:

http://expressionengine.com/showcase

http://show-ee.com/

Thanks a lot Grad Student

Where can we post official feature requests for future versions?