Project

General

Profile

Postgres or MySQL?

Added by IW M about 10 years ago

I've used MySQL the most out of any database and have never really used Postgres. I see MySQL support is relatively new in Wt, but from a standpoint from those experienced; what is the better choice to build on long term in Wt or does it not matter?

Thanks!


Replies (2)

RE: Postgres or MySQL? - Added by Alan Jesser about 10 years ago

The MySQL support just extends the DBO interface. If you're using the DBO you won't really see a difference in the database back-end when coding. The database you use is really up to you. The debate between which one is better will never end. MySQL does have some nice features that people miss in other databases. I personally prefer Postgres because it isn't having the drama issues that MySQL and MariaDB are having. Postgres also has PostGIS which I've had to use lately.

RE: Postgres or MySQL? - Added by IW M about 10 years ago

Thanks Alan,

I didn't think about debate drama; sort of sorry I brought it up.

Maybe I'll play with both while I'm learning Wt. I have a MySQL database already thought out setup for my project, but at my skill level with Wt, it probably won't matter much by the time I come up with anything usable.

Thank you so much.

    (1-2/2)