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.
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.