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 116 — July 29, 2015
Transaction ID Wraparound in Postgres
If you’ve got a system that has high throughput and churn of data, transaction IDs can start to write over themselves, writing over data. In most cases Postgres’ vacuum will keep up, but otherwise here’s how to handle it.
David Cramer
PGStrom: Postgres Extension That Offloads Work to GPU Devices
An extension of PostgreSQL (9.5devel only for now) that can offload several CPU intensive workloads to GPU devices to use their massive parallel execution capabilities.
postgresql.​org   #tools 
Want to work on new projects? Make more money? Try a new stack? Relocate?
On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US UK, you'll be sure to find what you're looking for. Join Hired today.
Hired.​com    #sponsored 
Documenting Your PostgreSQL Database
Everyone is used to documenting their code, but something that’s seldom done is documenting databases. It’s assumed that columns are clearly named, but even in the most clear database being explicit about what something is and how it works is valuable.
Craig Kerstiens
Real-Time Integration of PostgreSQL and Kafka
If you’ve already got your data in Postgres, but want to consume it as a stream to allow more systems to consume and process that data, here’s a tool to help. ‘Bottled Water’ takes Postgres data and streams it directly to Kafka.
Martin Kleppmann
Building Your Own User Analytics System In SQL
SQL is incredibly powerful, much more so than something like Google Analytics for the ways you can inspect data. If you want and need that flexibility here’s an awesome high level guide for rolling your own home grown analytics system.
Periscope
Unsafe UPSERT using WITH Clauses
Upsert is coming in Postgres 9.5, but many have been using other versions with CTEs for some time now as a work around. Unfortunately this can be unsafe for your data, so you should definitely swap to 9.5 when it’s available.
Database Soup
PipelineDB: Streaming Postgres
A look at how one company has extended Postgres and turned it into a streaming database. The big use case here is around large amounts of data where you’d need to do rollups.
Database Soup
pgMemento: Versioning and Transaction Management for Postgres
A versioning approach for PostgreSQL using triggers and server-side functions in PL/pgSQL.
github.​com   #code 
Database Engineer, Brentwood, TN (onsite, full time)
The Database Engineer role will be responsible for automation, instrumentation, and tooling to accelerate database development, change management, deployment, monitoring, and operational support.
Ramsey Solutions     #job 
Full Stack Engineer at Namely (New York, NY)
Namely is an agile startup dedicated to building an end-to-end HR platform for businesses of all sizes. We’re looking for a skilled developer to contribute ideas, innovation, solutions and code to our product.
Namely    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.