Ferhat Elmas — Passionate Developer

Why to choose PostgreSQL?

16 November ’14

Straight to the features:

  • Community support
  • Data integrity and durability
  • Data types, functions, operators, arrays and ranges
  • Planner and optimizer
  • Transactional DDL
  • INSERT INTO ...RETURNING
  • WITH queries
  • Window functions
  • PL/Python (SQL, C, Lua, JavaScript)
  • Specific indexing i.e GiST, GIN, etc.
  • Extensions i.e hstore, ltree, pg_trgm, ip4r, etc.
  • Foreign Data Wrappers
  • LISTEN/NOTIFY
  • COPY streaming protocol