931
PostgreSQL Templates
What are PostgreSQL templates and what are they used for?
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
932
Announcing MongoDB 3.0
Official MongoDB Documentation. Learn to store data in flexible documents, create an Atlas deployment, and use our tools and integrations.
933
Spotify Optimized the Largest Dataflow Job Ever for Wrapped 2020
In this post we’ll discuss how Spotify optimized and sped up elements from our largest Dataflow job, , for using a technique called Sort Merge Bucket (SMB) join. We’ll present the design and implementation of SMB and how we incorporated it into our data pipelines.
934
The only scalable delete in Postgres is DROP TABLE
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
935
Historical weather data API for machine learning, free for non-commercial
Get weather data for the past days, weeks or months
936
937
938
939
You can't just assume UTF-8
How to infer character encodings with statistics
940
Debunking the Myth of "Anonymous" Data
Today, almost everything about our lives is digitally recorded and stored somewhere. Each credit card purchase, personal medical diagnosis, and preference about music and books is recorded and then used to predict what we like and dislike, and—ultimately—who we are. This often happens without our...
941
942
LlamaCloud and LlamaParse
LlamaIndex introduces LlamaParse and LlamaParse for production-grade RAG. Unlock complex PDF data to improve LLM response quality. Discover how today.
943
944
Beware the data science pin factory: The power of the data science generalist
This post discusses the benefits of full-stack data science generalists over narrow functional specialists. The later will help you execute and bring process...
945
RavenDB 6.0.2 (A Jepsen Report)
RavenDB is a distributed document database which repeatedly advertises its support for ACID transactions. 1 It’s intended for OLTP workloads, and offers a variety of ETL paths for exporting data to other systems. Its transactional API revolves around a session handle, which “represents a single business transaction on…
946
947
Jepsen: Redis-Raft 1b3fbf6
Redis is a fast single-threaded data structure server, commonly used as a cache, scratchpad, queue, or coordination mechanism between distributed applications. It offers operations over a broad array of datatypes , including binary blobs, lists, sets, sorted sets, maps, geohashes, counters, channels, streams, and…
948
PostgreSQL and the OOM killer: Why we use strict memory overcommit
In this blog post, we will explain how strict memory overcommit protects your database from catastrophic OOM (out of memory) kills. We will also share how a one character kernel bug forced us to temporarily disable this setting. Finally, we will explain our heuristic for determining the right memory overcommit limit…
949
950
951
Making PostgreSQL tick: New features in pg_cron
Since pg_cron 1.5, you can easily schedule jobs that run every 1-59 seconds. And pg_cron 1.6 added support for Postgres 16. This blog post walks you through the benefits of second granularity jobs with the pg_cron open source extension to Postgres.
952
Preview of Explore Logs, a new way to browse your logs without writing LogQL
Learn all about Explore Logs, a new way to browse your logs in Grafana 11 and Loki 3.0 without writing LogQL.
953
Manticore 6.0.0 – a faster alternative to Elasticsearch in C++
Today, the Manticore team is thrilled to announce the release of Manticore Search 6.
954
Jepsen: Redpanda 21.10.1
Redpanda is a Kafka -compatible distributed streaming system based around append-only logs. Compared to Kafka, Redpanda aims to offer users lower latencies and reduced operational complexity. It uses the Raft consensus algorithm internally, rather than depending on a separate installation of Zookeeper . Redpanda…
955
Move Fast and Migrate Things: How We Automated Migrations in Postgres
At Benchling, we’re building a platform to help scientists do research. Hundreds of thousands of scientists across academia and enterprise…
956
The growing pains of database architecture
How the Figma infrastructure team reduced potential instability by scaling to multiple databases
957
Making Google Data Studio Free for Everyone
Today, Google's mission to organize the world's information and make it universally accessible and useful is even more relevant and broad reaching.
958
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩
959
The Rise of SQL-Based Data Modeling
The resurgence of SQL-based data modeling is a something we should all be interested in. Here's why it's important.
960
A glitch in an online survey replaced the word 'yes' with 'forks'
Dating back to at least early 2023, a bizarre and alarming technical glitch started popping up in some organizations’ online surveys and forms.