4 ms·

I love Postgres, but I'm building something for OSS use and most unzip-and-deploy devs don't know how to set up Postgres. Any additional information that you m

by debacle 15y ago

I love Postgres, but I'm building something for OSS use and most unzip-and-deploy devs don't know how to set up Postgres. Any additional information that you might be able to give me that might convince me?

getsat 15y ago
Ah. If your target is people who aren't going to be reading docs, I don't think any DB is really preferable. :) Any more details about the project, or is it under wraps?
- debacle 15y ago
  It's basically a simple blogging platform, going to be released OSS. Most devs know how to get MySQL running without too much thought, but many don't even know what Postgres is.
  - chris_wot 15y ago
    It might be worthwhile educating them. It shouldn't be that much harder to show them how to setup Postgres than MySQL :-) If it's only a simple blogging platform, it might well be that MySQL will do the job just fine though.
lucisferre 15y ago
I'd look into Postgres more first. They have some features that give you some of the convenience of a document DB. I'm not an expert but from what I've heard stuff like JSON/XML tables and customized column types that can store things like arrays and other structured data instead of just scalar data. It sounds pretty powerful and I've been told it is rock solid. That being said, don't buy into the anti-mongo hype so easily either. It's been overstated and for a large portion of the middle-ground on scalability and performance mongo is great.
amalag 15y ago
Well with Postgres you can include an installation in your distribution, with MySQL you cannot.
bsg75 15y ago
Its not difficult to setup - included in most package managers; EnterpriseDB produces installers for desktops / workstations; a straightforward build process from source. The perceived "ease" at which MySQL is available, thus a lack of actual understanding about how to work with an RDBMS, is why MySQL is so widespread yet such a maligned platform.

by debacle 15y ago

getsat 15y ago

Ah. If your target is people who aren't going to be reading docs, I don't think any DB is really preferable. :) Any more details about the project, or is it under wraps?

debacle 15y ago
It's basically a simple blogging platform, going to be released OSS. Most devs know how to get MySQL running without too much thought, but many don't even know what Postgres is.
- chris_wot 15y ago
  It might be worthwhile educating them. It shouldn't be that much harder to show them how to setup Postgres than MySQL :-) If it's only a simple blogging platform, it might well be that MySQL will do the job just fine though.

lucisferre 15y ago

I'd look into Postgres more first. They have some features that give you some of the convenience of a document DB. I'm not an expert but from what I've heard stuff like JSON/XML tables and customized column types that can store things like arrays and other structured data instead of just scalar data. It sounds pretty powerful and I've been told it is rock solid. That being said, don't buy into the anti-mongo hype so easily either. It's been overstated and for a large portion of the middle-ground on scalability and performance mongo is great.

amalag 15y ago

Well with Postgres you can include an installation in your distribution, with MySQL you cannot.

bsg75 15y ago

Its not difficult to setup - included in most package managers; EnterpriseDB produces installers for desktops / workstations; a straightforward build process from source. The perceived "ease" at which MySQL is available, thus a lack of actual understanding about how to work with an RDBMS, is why MySQL is so widespread yet such a maligned platform.