DEV Community

Discussion on: Sell me your stack!

Collapse
 
cotcotcoder profile image
JeffD

Not really a stack, only database, I'll speak about Postgresql

The basics, PostgreSQL is free, open-source and community powered (not an enterprise selled or bought by another one). It works on a lot of systems, Mac-Linux-Windows and it's easy to start.

  • You love schema-less in Mongo, with Postgres you can define a column as JSON content - and you can extract some content directly in SQL;
  • Your tables become too heavy, you can user partiton-table to make a virtual table for each month (for exemple)
  • You import JSON or XML file, you can use Foreign Data Wrapper to select these data directly in SQL
  • You want to build map, you can use the geospatial extension PostGis
  • They'is community event and talks in major open-source events
  • It's available on major hosting or SAAS
  • You can use heritage in your tables.
  • SQL is too complex? You can write some procedure and trigger with perl or python.
  • A table can INHERITS from another (yes, like OOP classes)

You've awesome stuff like channel with LISTEN or rights for only one column in a table, fulltext-search or define your own indexes.