A lot of companies and products want to extend Postgres to do more than it can out of the box. There’s a variety of ways of doing this, one being Postgres’ foreign data wrappers - if you use them for what they’re intended they’re great, but sometimes it may not work out so well..
For a long time MongoDB and MySQL had a leg up on Postgres, one for user experience and the other for well… replication. Postgres has come a long way since those days and now is seen as a replacement for both as shown here.
4000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with expert training courses. The EDB certification program sets the global standard for Postgres professionals, and is definitive proof of your skills.
Envelope is a new approach to building RESTful applications. It provides an app server out of the box that sits in front of your database and provides a direct API for writing JS apps against it.
These days data is everywhere, and aggregating it can be as hard as keeping a database up and running. Postgres’ foreign data wrappers are incredibly powerful here in allowing you to query from a Postgres database to any other data source as highlighted here.
Postgres is ripe with exciting things lately: hstore, jsonb, extensions, foreign data wrappers. Foreign data wrappers particularly provide a lot of promise in connecting to other data sources. Here’s a rundown of how writing your own might go.
Postgres has a lot of powerful ability in the CLI, one such command is copy, making it easy to bulk load data in or out of Postgres. Here’s a great convenience wrapper to make this easier to dump a query directly to CSV locally.
Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers.
