2371
Making 768 servers look like 1
How to make 768 distinct Postgres servers look like 1 to your applications.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
2372
2373
Redshift Spectrum – Exabyte-Scale In-Place Queries of S3 Data
Now that we can launch cloud-based compute and storage resources with a couple of clicks, the challenge is to use these resources to go from raw data to actionable results as quickly and efficiently as possible. Amazon Redshift allows AWS customers to build petabyte-scale data warehouses that unify data from a variety…
2374
2375
2376
Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB
All about when to use unstructured data types in Postgres, such as Hstore, JSON, and JSONB. The tl;dr is that the right data type depends on your use case. Here we dig deep into the benefits, and why JSONB became so popular since it first got real and proper support in Postgres 9.4. The B in JSONB stands for better.
2377
Apache Spark 1.0.0
Spark 1.0.0 is a major release marking the start of the 1.X line. This release brings both a variety of new features and strong API compatibility guarantees throughout the 1.X line. Spark 1.0 adds a new major component, Spark SQL , for loading and manipulating structured data in Spark. It includes major extensions to…
2378
Applying Textbook Data Structures for Real Life Wins
How we leveraged a textbook data structure in our core platform and achieved a 15x speed up for a key data processing step.
2379
2380
Pg_parquet: An extension to connect Postgres and parquet
Crunchy Data is excited to release a new extension so you can write Postgres data to Parquet and or pull data from Parquet to Postgres. Craig has the details and sample code.
2381
2382
Using machine learning to index text from billions of images
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
2383
Trying chDB, an embeddable ClickHouse engine
A lightweight in-process SQL OLAP engine, powered by ClickHouse.
2384
On Disk IO, Part 3: LSM Trees
If you like the series, check out my book on Database Internals!
2385
Mistakes Beginners Make When Working with Databases
When you start out as a developer there’s an overwhelming amount of things to grasp. First there’s the language itself, then all the quirks of the specific framework you’re using,and after that (or maybe before) we’ll throw front-end development into the mix, and somewhere along the line you have to decide to store…
2386
Bcachefs, an Introduction/Exploration
Introduction & background information NOTE: This content is from an internal talk I gave, thus the reason it may read like a presentation So what is …
2387
Index Investing Makes Markets and Economies More Efficient (2016)
U.S. equity index funds have grown dramatically in recent decades, from a negligible $500MM in assets in the early 1980s to a staggering $4T today. The consensus view in the investment community is that this growth is unsustainable. Indexing, after all, is a form of free-riding, and a market can only support so many…
2388
How can we know if paid search advertising works?
Addressing causal problems on major eBay and Facebook
2389
Uses and abuses of cloud data warehouses
Data Warehouses are great for many things but often misused for operational workloads.
2390
How JPEG XL compares to other image codecs
The JPEG XL is a powerful codec – find out how it compares to other codecs, including JPEG XL vs HEIC and JPEG XL vs JPEG.
2391
What's the big deal about embedded key-value databases?
What's the big deal about key-value databases like FoundationDB and RocksDB?
2392
Improve developer habits by showing time cost of DB queries
This is the first in a series of posts where I share a quick, easy to implement tip that I’ve found useful in my development career
2393
2394
Postgresql 9.2 will have boat-loads of performance enhancements
This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity.
2395
2396
Gemini API File Search is now multimodal
Updates to the Gemini API File Search tool makes building efficient, multimodal file retrieval systems easier for developers.
2397
2398
Speeding up PostgreSQL dump/restore snapshots
How targeted improvements helped us speed up bulk data loads and complex schemas.
2399
Introducing pgzx: create PostgreSQL extensions using Zig
We are excited to introduce pgzx, a framework for creating Postgres extensions using the Zig programming language.
2400
