2041
Making geo joins faster with H3 indexes
Using H3 indexes to greatly speed up geospatial SQL Queries. Orders of magnitude improvements can be gained with the right data structures
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2042
2043
Recreating Our Galaxy in a Supercomputer
A new simulation of our Milky Way galaxy has solved a decades-old mystery.
2044
AWS Data Exchange
We live in a data-intensive, data-driven world! Organizations of all types collect, store, process, analyze data and use it to inform and improve their decision-making processes. The AWS Cloud is well-suited to all of these activities; it offers vast amounts of storage, access to any conceivable amount of compute…
2045
2046
Sorting number strings numerically
The only enterprise AI data platform that cuts complexity, reduces costs, and gets you to production faster.
2047
Ultra efficient vector extension for SQLite
Making vector search fast, memory-efficient, and natural in SQLite.
2048
2049
2050
Building a recommendation engine inside Postgres with Python and Pandas (2020)
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
2051
2052
Sorry ARIMA, but I’m Going Bayesian
When people think of “data science” they probably think of algorithms that scan large datasets to predict a customer’s next move or interpret unstructured te...
2053
Data Science at the Command Line, 2nd Edition (2021)
This thoroughly revised guide demonstrates how the flexibility of the command line can help you become a more efficient and productive data scientist. You’ll learn how to combine small yet powerful command-line tools to quickly obtain, scrub, explore, and model your data. To get you started, author Jeroen Janssens…
2054
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
2055
Parallelism in PostgreSQL
Parallelism in PostgreSQL was implemented as part of multiple features which cover sequential scans, aggregates, and joins.
2056
What time-weighted averages are and why you should care
Learn how time-weighted averages are calculated and why they’re so powerful for data analysis. Read the full article on the Tiger Data blog.
2057
Fast drilldown dashboards from a single Parquet file
Range Requests Are All You Need
2058
Datamining Bandersnatch
You may have heard about Bandersnatch , an interactive film released on Netflix as part of the Black Mirror series. I’ve heard about it when it was released, but didn’t get around to watch it until recently, and I was surprised at how deep and thorough the implementation is. The film consists of:
2059
2060
Problems with CSVs (2016)
Much of my professional work for the last 10+ years has revolved around handling, importing and exporting CSV files. CSV files are frustratingly misunderstood, abused, and most of all underspecified. While RFC4180 exists, it is far from definitive and goes largely ignored.
2061
Surviving Django, if you care about databases
Django is currently the most commonly used full-stack web framework for Python. It has been around for a good 15 years, emerging as a winner from a period in which Python was already mature, but its web development tools were comparatively much more immature and fragmented.
2062
Rules of schema growth (2017)
The free database designed for immutable values and a time-aware information model.
2063
2064
A Relational Spreadsheet
I tried doing an INNER JOIN in Google Sheets and it was so awkward I was compelled to build my own lightweight relational spreadsheet / language / system.
2065
2066
2067
Matrix Multiplications on GPUs Run Faster When Given “Predictable” Data (2024)
Great minds discuss flops per watt.
2068
Poor man's bitemporal data system in SQLite and Clojure
On trying to mash up SQLite with ideas stolen from Accountants, Clojure, Datomic, XTDB, Rama, and Local-first-ers, to satisfy Henderson's Tenth Law. Viz., to make a sufficiently complicated data system containing an ad-hoc, informally-specified, bug-ridden, slow implementation of half of a bitemporal database…
2069
PostgreSQL 13 Beta 1 Released
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 13 is now [available for download](https://www.postgresql.org/download/). This …
2070