Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 123 — September 16, 2015
Postgres, pg_shard, and What We Learned From Our Failures
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..
Citus Data
Bye Bye MySQL and MongoDB. Guten Tag PostgreSQL
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.
Userlike   #opinion 
Heroku Data Links with Postgres and Redis
Heroku has dramatically simplified the process of using Foreign Data Wrappers with PostgreSQL and Redis via its Data Links feature.
Barry Jones
Postgres Skills are in Demand - Add to your skill set and get certified
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.
EnterpriseDB    #sponsored 
Envelope: A Webapp Dev Platform on top of Postgres
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.
Workflow Products
Breaking Down Data Silos with Foreign Data Wrappers
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.
InfoQ
PostgreSQL Foreign Data Wrappers
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.
Ian Pye
Syncing Cache with Postgres
Gian Biondi   #tutorial 
psql2csv: Run A Query in psql and Output The Result As CSV
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.
Philipe Fatioavid Cramer   #tools 
Join The Top 3% of Freelance PostgreSQL Developers Worldwide
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.
Toptal    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.