1081
A Hairy PostgreSQL Incident
It was 5:17pm today, just as I was wrapping up work for the day, and my manager pinged me with the following chat: <manager>: Hi Jeremy – we have a <other team> ticket – esc…
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
1082
Postgres as a Search Engine
Build a retrieval system with semantic, full-text, and fuzzy search in Postgres to be used as a backbone in RAG pipelines.
1083
1084
1085
FastSpark: A New Fast Native Implementation of Spark from Scratch
TLDR: Here is the code to explore.
1086
Data-Oriented Programming in Python
Many users of Python deprioritize performance in favor of soft benefits like ergonomics, business value, and simplicity. Users who prioritize performance typically end up on faster compiled languages like C++ or Java.
1087
1088
More on Postgres Performance
If you missed my previous post on Understanding Postgres Performance its a great starting point. On this particular post I’m going to dig in to some real life examples of optimizing queries and indexes. It all starts with stats I wrote about some of the great new features in Postgres 9.2 in the recent announcement on…
1089
Foursquare Open Source Places: A new foundational dataset
I did not expect this! [...] we are announcing today the general availability of a foundational open data set, Foursquare Open Source Places ("FSQ OS Places"). This base layer of …
1090
Improving Stack Overflow jobs search with machine learning and R
A journey into making Stack Overflow job search results relevant to you
1091
1092
1093
1094
England and Wales House Price Analysis
The last time I looked at house prices it went pretty well, and I ended up winning a data science competition. There I was only dealing with a million or so records, and a relatively small 120 MB dataset. Then I found out it was possible to download 3.7GB of property sale records for all of England and Wales since…
1095
1096
Antirez' tiny JSON selector library
Salvatore Sanfilippo, aka antirez released a telegram bot library in C recently. While I'm not at all interested in a telegram bot library, I always like to read Salvatore's code, which is uniformly superb.
1097
SQL, Homomorphisms and Constraint Satisfaction Problems
Database queries are a pretty surprisingly powerful tool that can solve seemingly intractable problems.
1098
1099
Lying with pictures: Smartphone manufacturer share by OS
As steer and drplokta pointed out yesterday , the Nielsen diagram was grossly out of proportion, so it looked like RIM and MS were better than they were. I passed the data to steer, who then played around with R (code is in the other post), and produced the second diagram. I've tried to line them…
1100
1101
1102
Data Still Dominates
I’m a huge proponent of designing your code around the data, rather than the other way around, and I think it’s one of the reasons git has been fairly successful… I will, in fact, claim that the difference between a bad programmer and a good one is whether he considers his code or his data structures more important…
1103
A Tale of Twenty-Two Million Citi Bikes: Analyzing the NYC Bike Share System
Analysis and visualization of the New York City bike share system
1104
1105
One Hash Bloom Filters
Jim Calabro
1106
Hachi: An Image Search Engine
For quite some time now, i have been working on and off on a fully self-hosted search engine , in hope to make it easier to search across Personal data in an end to end manner. Even as individuals, we are hoarding and generating more and more data with no end in sight. Such "personal" data is being stored from local…
1107
The Log: An Epic Software Engineering Article
There's some sort of inflection point where a "long read" becomes an "epic article." I'm not quite sure where that inflection point is, bu...
1108
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...
1109
1110
Why the KeePass format should be based on SQLite
Mohammed Ketab