Analyzing the Panama Papers with Neo4j — A look at how a graph database has major strengths to deep dive into large, interconnected collections of documents like the Panama Papers.
PostgreSQL Bloat: Origins, Monitoring and Managing — PostgreSQL's MVCC model supports running multiple transactions operating on the same data set, but questions have arisen around bloat. Here's a look at how it can affect performance and how to monitor and manage it.
PostgreSQL Query Optimization — For many, what happens when you join two tables is a mystery. Once you do build a deeper understanding, it becomes much easier to optimize joins - luckily it’s not rocket science to understand some of the logic under the covers, as seen here.
Jincheng Li
Jobs
Work on a Better Stack — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly.
Auto-generated APIs for any database — Powerful API automation for standardization, portability, and scale. Free dev environment for testing and rapid prototyping.
Data Modeling in Cassandra From A Postgres Perspective — Usually we highlight articles of people moving from other systems to Postgres, in a contrast here’s how to apply a Postgres perspective to a database that doesn’t lend quite the same flexibility–Cassandra.