151
How the Native American population changed since the last census
The federal government has counted the Native American population in various ways throughout the years. Recent data shows how the demographic is growing.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 175 posts.
152
153
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
154
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
155
Backblaze Drive Stats for Q3 2022
Q3 2022 Drive Stats: Read the latest insights and check out the data.
156
Aggregating away the signal in your data
By aggregating our data in an effort to simplify it, we lose the signal and the context we need to make sense of what we’re seeing.
157
Migrating from SQLite to PostgreSQL
Product updates, comparisons, and deep dives on database change management, access control, and compliance from the Bytebase engineering team.
158
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
159
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.
160
AlloyDB for PostgreSQL under the hood: Columnar engine
In this technical deep dive, we take a look at the columnar engine that delivers industry leading query performance for AlloyDB for PostgreSQL.
161
Super-Structured Data: Rethinking the Schema
Dealing with real-world data is hard. You often end up stuck between the document model of JSON and the relational model of SQL databases. There's a better way. It's called super-structured data.
162
DBT Cloud increase Team plan price by 100% and limit features at the same time
We’re updating the dbt Cloud Developer and Team plans to better reflect product maturity after years of improvements.
163
New method identifies the root causes of statistical outliers
Amazon ICML paper proposes information-theoretic measurement of quantitative causal contribution.
164
Faster offset pagination for Rails apps
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries.
165
Semantic Search with SQLite
txtai is an all-in-one open-source AI framework for semantic search, LLM orchestration and language model workflows
166
ReadySet Core: next-generation SQL caching, freely available
Today we’re announcing ReadySet Core, a freely available version of ReadySet that you can run anywhere from your own laptop to any cloud provider, on as many nodes as you need.
167
The world of PostgreSQL wire compatibility
A wire protocol is the format for interactions between a database server and its clients. It encompasses authentication, sending queries, receiving responses, and so on. It is a description of the exact bytes sent and received by servers and clients. It does NOT encompass the actual query language itself, let alone…
168
Cloud Spanner now with a free trial
Create a 90-day Spanner free trial instance with 10GB storage at no cost. Try Spanner free.
169
SQLite 3.39.3
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
170
BERTopic: The Future of Topic Modeling
BERTopic takes advantage of the superior language capabilities of (not yet sentient) transformer models and uses some other ML magic like UMAP and HDBSCAN to produce what is one of the most advanced techniques in language topic modeling today.
171
U.S. universities, rich in data, struggle to capture its value, study finds
A UCLA–MIT Press paper highlights a lack of data infrastructure and data strategy in U.S. higher education.
172
173
Automated PDF Reports with Python Notebooks
Learn how to build automated PDF reports in Python with Jupyter and Mercury, including scheduling, charts, and email delivery workflows.
174
Emacs: Using SQLite as a Data Source
In this talk, Andrew Hyatt shows how to use SQLite to store and retrieve information using the triples package. Afterwards, he wil handle questions over BigBlueButton.
175
The top programming languages
Explore the top programming languages on GitHub—and what languages are growing the fastest.