271
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.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 300 posts.
272
Do data-driven companies win?
Some gut-based judgements on the effectiveness of data.
273
Simple declarative schema migration for SQLite
At my company we use a small SQLite database. We define the schema in a single file with SQL CREATE TABLE statements. If we add tables, columns, or indexes, our application will create them automatically the next time it starts up.
274
Squeezing Performance from SQLite: EXPLAINing the Virtual Machine
The virtual machine? Yep, but not the Java Virtual Machine.
275
The Economics of Data Businesses
How data businesses start, and how they keep going, and growing, and growing.
276
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.
277
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.
278
279
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.
280
New method identifies the root causes of statistical outliers
Amazon ICML paper proposes information-theoretic measurement of quantitative causal contribution.
281
Faster offset pagination for Rails apps
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries.
282
The Plausibly Deniable DataBase (PDDB)
The problem with building a device that is good at keeping secrets is that it turns users into the weakest link.
283
Semantic Search with SQLite
txtai is an all-in-one open-source AI framework for semantic search, LLM orchestration and language model workflows
284
Surprises in the Bitcoin blockchain and how they are stored (2014)
Every Bitcoin transaction is stored in the distributed database known as the Bitcoin blockchain. However, people have found ways to hack ...
285
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.
286
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…
287
Cloud Spanner now with a free trial
Create a 90-day Spanner free trial instance with 10GB storage at no cost. Try Spanner free.
288
289
I used Benford’s law to analyze Covid-19 in 113 countries (2020)
Spoiler alert: I found some intriguing patterns…
290
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 .
291
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.
292
293
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.
294
295
Who Contributed to PostgreSQL Development in 2020 and 2021?
I have done a few previous blog posts on who has contributed to PostgreSQL , but I did not do one last year. A couple people mentioned to me...
296
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.
297
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.
298
Dabbling with Dagster vs. Airflow
Dissecting the Octopus
299
The many flavors of hashing
About the many types of hash functions, their use-cases, dos and don'ts, with suggestions for currently accepted algorithms.
300
The top programming languages
Explore the top programming languages on GitHub—and what languages are growing the fastest.