Skip to content

PostgreSQL

Open Source Relational Database (RDBMS), extending the SQL language. Started in 1986 at UC Berkeley.

I personally liked it because I used to do a lot of datascience/python programming. I enjoy using native datasources (rather than np) like dictionaries and arrays to store information. You can retain dictionaries when you export/import them into json files. And PostgreSQL supports JSON! This is not typical of SQL databases and more inline w/ NoSQL databases.

Benefits

  • Open Sourced
  • Free
  • Extensible
    • Define your own data types
    • Define your own functions
    • Use many languages
  • Conforms to SQL standard (as of 2025, conforms to 170/177 manditory standards)

Learn more here: https://www.postgresql.org/about/