Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Ubuntu Looks Towards MySQL Alternatives

  1. #11
    Join Date
    Sep 2011
    Posts
    707

    Default

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

  2. #12
    Join Date
    Oct 2008
    Posts
    3,181

    Default

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

  3. #13
    Join Date
    Jun 2009
    Posts
    570

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •