181
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
182
183
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)
Boost PostgreSQL full-text search speed by 50x with simple optimizations. Use VectorChord-BM25 to accelerate and better BM25 ranking in postgres.
184
The New York Times course to teach its reporters data skills is now open-source
And how your reporters can learn to love spreadsheets, too
185
186
Prisma – ORM for Node.js and TypeScript
Learn about the motivation for Prisma ORM and how it compares to other Node.js and TypeScript database tools like ORMs and SQL query builders. Applies to Prisma ORM v6.
187
Best practices for writing SQL queries
SQL best practices: a brief guide to writing better SQL queries.
188
How Mailinator compresses its email stream by 90%
Given the title of this article, the first thing that should pop into your mind is probably - "well, use a compression algorithm - right?". ...
189
Red Hat Satellite to standardize on PostgreSQL backend
Red Hat Satellite is a complex offering and we wanted to spend some time talking about the underlying databases that make Satellite work as well as some upcoming changes to this underlying database structure that you should be aware of.
190
An Introduction to JQ
In this article, I'm going to go over the basics building blocks of jq in enough depth that you will be able to understand how jq works.
191
Redis adopts dual source-available licensing
Developers love Redis. Unlock the full potential of the Redis database with Redis Enterprise and start building blazing fast apps.
192
Ubiquiti: Enterprise NAS, Built on ZFS
Discover ENAS, the license-free enterprise storage platform featuring native ZFS, secure UniFi management, scalable petabyte-class capacity, multi-site backups, and shared iSCSI storage for modern business infrastructure.
193
Amazon Aurora Backtrack
We’ve all been there! You need to make a quick, seemingly simple fix to an important production database. You compose the query, give it a once-over, and let it run. Seconds later you realize that you forgot the WHERE clause, dropped the wrong table, or made another serious mistake, and interrupt the query, but the […]
194
195
PostgreSQL: No More Vacuum, No More Bloat
PostgreSQL, a powerful open-source object-relational database system, has been lauded for its robustness, functionality, and flexibility. However, it is not without its challenges – one of which is the notorious VACUUM process. However, the dawn of a new era is upon us with OrioleDB, a novel engine designed for…
196
Appropriate Uses for SQLite
SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.
197
OrioleDB Patent: now freely available to the Postgres community
Supabase is explicitly making available a non-exclusive license of the OrioleDB patent to all OrioleDB users in accordance with the OrioleDB license.
198
A popular self-driving car dataset is missing labels for hundreds of pedestrians
SUMMARY A hand-check of the 15,000 images in the widely used Udacity Dataset 2 found problems in 4,986 of them (33%), including thousands of unlabeled vehicles, hundreds of unlabeled pedestrians, dozens of unlabeled cyclists, and 217 completely unannotated images that contained real objects. Phantom annotations…
199
Hard Drive Reliability Review for 2015
In 2015 we ran 56,224 hard drives in our datacenter. In this post we review the reliability of the Seagate, HGST, Toshiba, and Western Digital drives.
200
What is a Vector Database? (2021)
Discover Vector Databases: How They Work, Examples, Use Cases, Pros & Cons, Selection and Implementation. They have combined capabilities of traditional databases and standalone vector indexes while specializing for vector embeddings.
201
202
Personal data storage is an idea whose time has come
Data Ownership as a conversation changes when data resides primarily with people-governed institutions rather than corporations.
203
RethinkDB 2.0 is now production ready
We’re proud to announce that after five years of development, RethinkDB is ready for production. Download RethinkDB 2.0 ( Yojimbo ) now!
204
DeepText: Facebook's text understanding engine
Visit the post for more.
205
ISO 8583: The language of credit cards
Discover the inner workings of ISO 8583, the global standard for credit card transaction messaging. Learn how it powers payment processing across networks and explore its structure, fields, and real-world applications.
206
207
Why SQL is beating NoSQL, and what this means for the future of data
After being left for dead, SQL is making a comeback and the NoSQL vs. SQL debate is stronger than ever. Why? And how will it impact the data community?
208
RIP, vector database
turbopuffer is pushing the frontier of search. To do that, we have to fundamentally redesign our storage architecture so the vector index is no longer primary.
209
Microsoft Releases 125M Building Footprints in the US as Open Data
Bing has made very significant investments in the area of deep learning, computer vision and artificial intelligence to support a number of different search scenarios. The Bing Maps team has…
210
How Meta trains large language models at scale
As we continue to focus our AI research and development on solving increasingly complex problems, one of the most significant and challenging shifts we’ve experienced is the sheer scale of co…