WordPress.org

Ready to get started?Download WordPress

Forums

[closed] PostgreSQL (85 posts)

  1. randall
    Member
    Posted 10 years ago #

    I would estimate, we are talking of between 40-60% of the SQL queries being MySQL specific.

  2. Matt Mullenweg
    Troublemaker
    Posted 10 years ago #

    Because of the date functions? Postgres doesn't have an equivilent?

  3. Anonymous
    Unregistered
    Posted 10 years ago #

    "Database independence isn't a terribly high priority at the moment because there really isn't that demand for it. (You're the first to even mention it.)"
    While I realise I'm responding to a message posted 9 months or so ago, I wanted to point out something in regards to this comment.
    Speaking from personal experience, if I see a product that I'm interested in, and it states point blank that it only supports MySQL, I'm much more inclined to just close the site and go on to try and find something that is database independant/supports multiple databases. This might account for why not many people are requesting the feature as much, because they become disenfranchised at the mention of sole MySQL support and just leave.
    The odds are that there are probably quite a few people that would like to see this, and many other products, availible for more than just MySQL, and by ignoring them you're probably ignoring a lot of potential users.

  4. rook
    Member
    Posted 10 years ago #

    I'll follow the previous post to respond to the same comment: "Database independence isn't a terribly high priority at the moment because there really isn't that demand for it. (You're the first to even mention it.)"
    I'm using WP with MySQL, which is all that my current public hosting solution supports at the moment. But I personally prefer PostgreSQL which I use quite a bit at work. If given the choice, I'd definitely choose PostgreSQL over other database choices. So, because it appears you are counting mentioned resquests. +1 for more db independence/choices. :-)

  5. Anonymous
    Unregistered
    Posted 10 years ago #

    +1.
    I skipped over WordPress when looking for a Postgres-compatible php system for my website, and am only now looking a bit closer as I'm unhappy with what I've got. There's really very little that doesn't use MySQL; I'm sure you could broaden WP's user base by adding DB abstraction!

  6. Anonymous
    Unregistered
    Posted 10 years ago #

    I'm looking at WordPress because I think it fits my org's needs prefectly, except that it needs to run on SQL Server.
    Maybe I can make it work.

  7. Anonymous
    Unregistered
    Posted 10 years ago #

    I would be also very happy if PostgreSQL was supported.
    My server admin doesn't want to install MySQL, because he is already using Postgres to run other software in the server.

  8. Anonymous
    Unregistered
    Posted 10 years ago #

    I would really like to use WordPress, but I'm disinclined to support both MySQL and PostgreSQL on my database server. People interested in PostgreSQL support or database independence are definitely choosing other solutions right now. Having support for at least PostgreSQL would increase the reach of WordPress significantly.

  9. msqr
    Member
    Posted 10 years ago #

    Just want to add my vote of support for PostgreSQL, as I already use Postgres and would not like to install MySQL. I would also back up my support with a donation if there were even just a commitment (and target date) to Postgres support by the developers, of $25. I'd really love to use WordPress, but can not until it supports Postgres 100%.

  10. Root
    Member
    Posted 10 years ago #

    $25 ? As much as that ;)

  11. msqr
    Member
    Posted 10 years ago #

    I'm only a wee little person and, well, if the 30+ odd folks clamoring for PostgreSQL support on this list each offered the same, that's a good $750 right there -- not too bad I would say. I would also think there might be more than 30 people in the world interested in PostgreSQL support.

  12. Anonymous
    Unregistered
    Posted 10 years ago #

    Count me in as a wordpress adopter and donater of $25 if postgresql support and/or database abstraction is added.

  13. Anonymous
    Unregistered
    Posted 10 years ago #

    Here's another vote for Postgres and db independence

  14. Anonymous
    Unregistered
    Posted 10 years ago #

    Just another vote for PostgreSQL. The server where I'm hosting my site runs on PostgreSQL. It would be fantastic to get WordPress up and running on it, if support is available.

  15. Anonymous
    Unregistered
    Posted 10 years ago #

  16. Matt Mullenweg
    Troublemaker
    Posted 10 years ago #

    The votes mean a lot more if they're from registered users.

  17. denyerec
    Member
    Posted 10 years ago #

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

  18. aigeanta
    Member
    Posted 10 years ago #

    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.

  19. Anonymous
    Unregistered
    Posted 10 years ago #

    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

  20. lensmanseye
    Member
    Posted 10 years ago #

    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).

  21. lensmanseye
    Member
    Posted 10 years ago #

    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).

  22. eryanv
    Member
    Posted 10 years ago #

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

  23. fiasco
    Member
    Posted 10 years ago #

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

  24. jamuraa
    Member
    Posted 10 years ago #

    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.

  25. marksw
    Member
    Posted 10 years ago #

    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

  26. marksw
    Member
    Posted 10 years ago #

    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.

  27. error404
    Member
    Posted 10 years ago #

    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?

  28. Anonymous
    Unregistered
    Posted 9 years ago #

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

  29. error404
    Member
    Posted 9 years ago #

    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.

  30. Anonymous
    Unregistered
    Posted 9 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags