511
Stop using zip codes for geospatial analysis (2019)
Uncover deeper insights beyond ZIP codes with geospatial analysis. Explore the limitations of ZIP codes and discover alternatives for spatial understanding.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
512
Announcing the data.gov archive
The Library Innovation Lab is growing knowledge and community by bringing library principles to technological frontiers.
513
Transformer – Spreadsheet
Make your own AI by hand ✍️ exercises
514
Why LLMs still have problems with OCR
LLMs excel at text generation but fail at precise document extraction due to nondeterminism. | Pulse AI
515
Ingesting PDFs and why Gemini 2.0 changes everything
Sergey Filimonov's blog
516
Are LLMs able to notice the “gorilla in the data”?
One paper that caught my attention a bit ago was Selective attention in hypothesis-driven data analysis by Itai Yanai and Martin Lercher. In their study, students who were given specific hypotheses to test were much less likely to notice an obvious “gorilla in the data” compared to students who explored the data…
517
Build your own SQLite, Part 4: reading tables metadata
As we saw in the opening post, SQLite stores metadata about tables in a special "schema table" starting on page 1. We've been reading records from this…
518
Julia and JuliaHub: Advancing Innovation and Growth
Explore Julia and JuliaHub's remarkable growth: 494% rise in Discourse views, +412% GitHub stars, and new products like Dyad.
519
Visualizing all books of the world in ISBN-Space
Libraries have been trying to collect humanity’s knowledge almost since the invention of writing. In the digital age, it might actually be possible to create a comprehensive collection of all human writing that meets certain criteria. That’s what shadow libraries do - collect and share as many
520
Sparrow, a modern C++ implementation of the Apache Arrow columnar format
A Modern C++ Implementation of the Apache Arrow Columnar Format
521
A major Postgres upgrade with zero downtime
Right before Christmas we discovered that our Aurora Postgres instance needed a major version upgrade. This covers how we made the upgrade with zero seconds of downtime.
522
523
Analysis of Product Hunt products from 2014 to 2021
An analysis of Product Hunt, 2014 - 2021
524
Composable SQL
Better SQL through typed, composable query fragments.
525
Turning the database inside-out (2015)
Databases are global, shared, mutable state. That’s the way it has been since the 1960s, and no amount of NoSQL has changed that. However, most self-respecting developers have got rid of mutable global variables in their code long ago. So why do we tolerate databases as they are?
526
Every System is a Log: Avoiding coordination in distributed applications
Distributed coordination makes application complex and brittle. Because all systems eventually build on logs, we can use a shared-log approach to eliminate most coordination. We discuss this conceptually and show how this is practically implemented in the open source project Restate.
527
Supercharge SQLite with Ruby Functions
An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in…
528
You probably don't need query builders
In a previous [0] post I’ve discussed why I ditched sea-query and why sql is almostalways the best way to not re-learn something new from the beginning...
529
530
Tracing Military Command Chains Through Time and Location
Case Study ⸺ Using novel technology to analyze groundbreaking chain of command research
531
How rqlite is tested
rqlite is a lightweight, open-source, distributed relational database written in Go, and built on SQLite and Raft. With its origins dating back to 2014, its design has always prioritized reliability, and quality. The robustness of rqlite is also a testament to its disciplined testing strategy: after more than 10 years…
532
Dbt Labs acquires SDF Labs
dbt Labs has acquired SDF Labs to enhance analytics engineering solutions. Learn how this partnership strengthens the modern data stack.
533
534
SQL nulls are weird
Yes, you read that right. SQL does treat all NULLs as distinct values. I learnt this a while back while working on Convoy and again on LiteQueue: a Golang a queueing library. Basically, any column wi
535
The Evaporative Cooling Effect in Social Networks (2010)
http://blog.bumblebeelabs.com/social-software-sundays-2-the-evaporative-cooling-effect/
536
B-Trees: More Than I Thought I'd Want to Know (2021)
B-Trees are not boring, after all
537
Using watermarks to coordinate change data capture in Postgres
Explore the challenges of building a change data capture (CDC) pipeline for Postgres. And see how Sequin used a watermark design inspired by Netflix's DBLog.
538
Advent of Code 2024 in pure SQL
A blog by and for database architects.
539
Postgres UUIDv7 and per-back end monotonicity
How Postgres’ v7 UUIDs are made monotonic, and why that’s a great feature.
540
Databases in 2024: A Year in Review
Andy rises from the ashes of his dead startup and discusses what happened in 2024 in the database game.