Announcement

Collapse
No announcement yet.

Ubuntu Looks Towards MySQL Alternatives

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #11
    Originally posted by spidernik84 View Post
    I'm not a DB expert by any means, but I don't see Postgres mentioned. Isn't it a valid alternative gaining a lot of credibility even in the enterprise markets? Is it much different?
    It's not a drop in replace ment. Databases would have to be converted and applications adjusted.

    Comment


    • #12
      Originally posted by spidernik84 View Post
      I'm not a DB expert by any means, but I don't see Postgres mentioned. Isn't it a valid alternative gaining a lot of credibility even in the enterprise markets? Is it much different?
      Yeah, i think it's a good option that is gaining momentum, but it's fairly different from MySQL and not just an easy swap out.

      Comment


      • #13
        postgres is not an option if you often muck around with the directory storing the databases.

        While the other DBMS usually store databases that relate to the name used in their creation (i.e.: if you do a 'CREATE DATABASE testdatabase;' in MySQL, MariaDB or even Mircrosoft SQL Server, the datadir will contain a file named 'testdatabase' or something along those lines), postgres uses a confusing numbering system (i.e.: performing a 'CREATE DATABASE testdatabase;' in postgres will result in a file named '00' or something else in the datadir). You can't just go into the datadir and start guessing whether file 00 or file 21 is the 'testdatabase' database that you are interested in.

        Comment

        Working...
        X