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 104 — May 6, 2015
Materialized View Strategies Using PostgreSQL
Views are a way to represent the results of a query as a table, and materialized views actually create that data versus just running a query each time. They’re a great way to cache aggregate data when running an expensive query over time.
Jack Christensen
Compressing PostgreSQL JSONB data 12x using cstore_fdw
Citus Data’s cstore FDW offers a promising option for a columnar store in Postgres. Marco highlights some of the benefits, showing the storage space on disk of the powerful new JSONB datatype.
Marco Slot
Barman 1.4.1 Released
Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python.
Postgresql.​org
Are You Really Ready to Deploy?
The vast majority of questions arise during the deployment and maintenance phases of Postgres projects, not during development or POC. And with good reason - Postgres is an easy database to work with. But planning ahead for deployment and taking care of ongoing maintenance are the keys to success. Get prepared by reading Tales from The Trenches or improve performance with an Architectural Health Check.
EnterpriseDB    #sponsored 
Bottled Water: Real-time Integration of PostgreSQL and Kafka
Postgres is great as a reliable persistent store for data, but often in real-time/event focused systems people look to other options. But here’s a look at what integrating and blending those worlds together could look like through streaming Postgres WAL to Kafka.
Confluent
Simplify: Move Code Into Database Functions
A provoking and clearly thought out piece around the idea of moving much more code and logic directly into your database (something many DBAs will be nodding their heads about).
Derek Sivers
Postgres Never Ceases to Amaze Me
For many, Postgres is just the database behind their ORM, for others it becomes a powerful and unique tool, such as in this author’s situation when working with in the context of a GIS (geographic information system).
Peter Shaw
Postgres JSON Column Type in Rails 4
The JSON and JSONB datatypes are wonderful, but most people building apps aren’t writing raw SQL. Instead, you’re going through the ORM of whatever your chosen framework is, and if it hasn’t adapted yet you’re out of luck. Fortunately Rails 4 works great out of the box.
Chad Wilken
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.