SQLite vs MySQL vs PostgreSQL

Re:SQLite vs MySQL vs PostgreSQL by twic on Thursday March 20, 2014 @08:30AM (#7435073)

> I love how easy it is to get started with MySQL and historically it's had a great user manual for beginners.

s/My/Postgre/

Seriously, on any platform you might reasonably use in the last five years, PostgreSQL is in the package manager, and installation is one command, just like anything else. Some packagings even create an initial database for you; for those which don't, it's just:

  sudo -i postgres
  initdb
  createuser wildutah
  createdb -O wildutah wildutah

I think the PostgreSQL manual is very good. The one weakness that i can see is that there isn't (that i know of) a single-page soup-to-nuts getting started guide for someone simply using PostgreSQL locally. There are blog posts which do the job, but it would be nice to have something official.

[ Parent | on HN ]

Re:SQLite vs MySQL vs PostgreSQL by nasalgoat on Thursday March 20, 2014 @05:30PM (#7438961)

I've converted from MySQL on previous project to MongoDB then to PostgreSQL with my current project, and I have to agree that the time it takes to get up and running with Postgres is still a bit behind MySQL.

The user permission system, the file-based authentication, the strange backslash command structure, the "no feedback" nature of the replication solution vs. the status report in MySQL all make Postgres a lot more "newbie unfriendly".

[ Parent | on HN ]

Re:SQLite vs MySQL vs PostgreSQL by collyw on Thursday March 20, 2014 @08:47AM (#7435158)

Postgres requires enough fiddling with the basic user, that it can be off putting. MySQL tends to be just installed almost everywhere, and usually doesn't need any configuration.

[ Parent | on HN ]