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 201 — April 5, 2017
Building A Scalable Time-Series Database on Postgres
We linked TimescaleDB 2 weeks ago, but here’s some more background to the project.
Ajay Kulkarni
AgensGraph: A Transactional Graph Database based on Postgres
An open source, multi-model database which supports both relational and graph-based data models, even supporting both SQL and openCypher within the same query.
bitnine   #code 
The PostgreSQL Security Technical Implementation Guide
A look at the United States Defense Information Systems Agency’s (DISA) new Postgres security guide and whether it could be useful for you.
Joe Conway   #tutorial 
24/7 PostgreSQL support with guaranteed response & resolution times
When it's critical, you can count on us! A Platinum service plan with 2ndQuadrant is all the insurance you need for when things don't go according to plan. Giving you a quick database recovery, with as little downtime as possible.
2ndQuadrant PostgreSQL Services    #sponsored 
Distributed COUNT(DISTINCT) with HLL on Postgres
In a large distributed system, using COUNT(*) can prove tricky but probabilistic algorithms could help you more quickly get ‘close enough’. This post looks at HyperLoglog and how you can use it in a distributed fashion.
Citus Data
PgUS: The United States PostgreSQL Association
Little known to many, there’s a full non-profit organization behind Postgres. They’ve just gotten an updated website and it’s worth considering becoming a member.
PostgreSQL   #news 
How to Query JSONB in Postgres, A Beginner's Cheat Sheet
This handy cheat sheet gives you many of the key things you’ll want to know as you start using and querying with JSONB in Postgres.
hackernoon.​com   #tutorial 
PgConf US 2017 Concludes; Organizers Share Some Thoughts
It’s now the largest PostgreSQL conference globally.
Joshua Drake   #opinion 
Streaming Postgres to Kafka and Maintaining Consistency and Transaction Isolation
Alex Matchneer   #opinion 
Waiting for Postgres 10: Full Text Search Support for JSONB
Postgres 10 is starting to shape up and while there’s some excitement around parallelism and other improvements, JSONB is getting an improvement as well: full text search.
Hubert depesz Lubaczewski
JSON in Postgres: The Present and Future (PDF)
JSONB is awesome in Postgres, it’s a document store in a relational database that you can index. In Postgres 10 it gets full text search. This deck from PGConf NY highlights what there is today and what’s to come.
Oleg Bartunov
PostgresOpen Silicon Valley - Call For Papers Open
PostgresOpen has joined forces with PGConf SV this year for a bigger show right in downtown San Francisco this September.
United States PostgreSQL Association
Safe and Unsafe Operations for High Volume PostgreSQL
Postgres is generally a friendly database, but when dealing with larger datasets you should use caution with some operations.
Alexey Vasiliev
Using Row Level Security with A Django Application
Row level security (recently added to Postgres) offers some added security should you need it for compliance or other reasons. Here’s a guide on how you can get started using it with Django.
Pierre Ducroquet
Debezium: Stream Changes From Your Databases
An open source tool that captures row level changes in MySQL, MongoDB or Postgres databases so your apps can see and react to those changes.
Red Hat   #tools 
The Future of Enterprise Postgres and Open Source Data Management
Save $200 - use code PGWEEK by May 19 to explore Postgres innovation at Postgres Vision Boston June 26-28.
Postgres Vision 2017    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.