PostgreSQL

AdoDB supports everyone doesn’t it ? Would be nice to see WP support the “standard” DB abstraction system.

Allusion, I anonymously posted previously about donoting money for postgresql support but just so it’s fully on the record, I’m putting in my vote as a registered member. I think I’m going to try out WP on a host that has MySQL just to see how it works, and then transfer everything over to my real website in the future. I’m just so sick of MT and all the comment spam. WP was suggested as an alternative by my sysadmin friend who hosts my site and got me involved with MT in the first place, but they don’t want to run MySQL in parallel with PostgreSQL because of performance issues. Anyway, I’ll be checking in regularly and hopefully there’s enough interest generated on this issue of DB independence to inspire someone to answer the call.

Here’s another vote for PostgreSQL support! Sorry it’s anonymous, but what’s the point registering if I can’t use the software?!
In fact, real thought on DB abstraction would be great. I’ve not looked at the code (I’m sure it’s excellent), but it doesn’t do anything particularly clever does it (as far as the database is concerned I mean)?
One kind person has been working on a port to PostgreSQL already (see page 1), so it looks like you have a good start. Is the code OO-styled?
From what I hear the software is great, and I’m longing to use it on my site, so please please please increase the priority of this!
Mark

Hi,
I’ve come back to this site a number of times simply because it is such an attractive piece of software, but each time I have turned away because of lack of PostgreSQL support (I really can’t maintain both PostgreSQL and MySQL!). However, it would appear from this forum topic that more and more people are requesting, so it is that I am registering myself on this forum and putting in a vote for PostgreSQL support (in the hope that it carries more weight than an anonymouse one).

Hi,
I’ve come back to this site a number of times simply because it is such an attractive piece of software, but each time I have turned away because of lack of PostgreSQL support (I really can’t maintain both PostgreSQL and MySQL!). However, it would appear from this forum topic that more and more people are requesting, so it is that I am registering myself on this forum and putting in a vote for PostgreSQL support (in the hope that it carries more weight than an anonymouse one).

Even though I don’t use PostgreSQL, I’d be willing to throw $5 into the pot for WordPress PostgreSQL support.

If people are still counting, I too would donate ~US$15 if PostgreSQL support materialised. Running MySQL solely for WordPress is a pain.

I’d like to add another $15 to the bounty on this feature’s head. I find PostgreSQL much more standards-compliant and easier to run than MySQL anyway.

I think that the database level should be abstracted, so that support for other databases can easily built in. As I said above, I can’t believe that this would be such a tricky job. I love postgreSQL, but I don’t see why we should just focus on this database. If a job is worth doing, it’s worth doing properly!
OK, I’ve registered too now, if this helps at all ??
Mark

1) Don’t know about your first point tallal (as I’ve never used WordPress… yet).
2) Not sure about point 2 either – why is this needed?
3) Yes – move it all. This is the whole point of classes isn’t it? Abstraction and inheritance. Is the WordPress code OO in style? Cheers.

I started on a Postgres port of Mingus tonight. After a ton of work hacking the installation scripts (god, is that ever a mess; I’ve ignored all the legacy support as nobody should be upgrading ;)) and a bunch more work hacking the individual scripts, I’m at a point where the basic blogging functions seem to be working acceptably. If I manage to get everything (or at least most things) working perfectly, I of course plan to release it.
The working admin stuff is very minimal at this point, but I don’t expect it to take too long to get that going. Once that’s done, I’m going to go through the entire codebase quickly by hand looking for conditions that I know cause problems.
Does anyone know if WordPress has a testing suite or at least a good testing guide I might use to work with this?

There seems to be a Sourceforge project to do this port — I’m surprised I haven’t seen it mentioned here:
https://sourceforge.net/projects/wordpress-pg/
Anybody know if this port is affiliated with the main WordPress developers in any way?

That would be my port. I’m not a WordPress developer, but I am hoping to help out with database abstraction in the WordPress trunk.

Interesting thread. Well since nobody mentioned this… how about support for Firebird SQL? ??
icxn

Why not do it the ADODB way so that you can have a larger flexibility when using DB and even use ODBC.
I know that simplog has done this. WordPress should do that…that way making atleast major part of the main stream requests be answered. Also allowing people having the flexibilty to deal with their hosting providers or isp or sysadmins.