Topics /
The most popular blog posts about databases & data on Hacker News. 176 posts.
How do you balance query time and relevance with Postgres text search? Stephen Gutekanst, an engineer working on Sourcegraph's API docs feature, shares tips for stirring code analysis with search indexing.
Writing an ETL script is easy; making it production-ready and maintainable is much harder. Why to use an open-source EL(T) framework instead.
Memory allocator is an important part of the system, so choosing the right allocator for a workload can give huge benefits. Here is a story of how we decreased service memory usage by almost three times.
PostgreSQL subtransactions (nested transactions) may cause multiple performance and scalability issues: higher rates of XID growth and higher risks of transaction ID wraparound, performance degradation when more than PGPROC_MAX_CACHED_SUBXIDS (64) are used in a session, drastic performance slowdowns when…
Jialin Li, Ellis Michael, Naveen Kr. Sharma, Adriana Szekeres, and Dan R. K. Ports, University of Washington
Efficient SQL data transformations & real-time analytics with dbt + Materialize: a powerful operational data warehouse combo.
How we built an authorization system based on Google Zanzibar
An example of how you can encrypt Postgres data at rest using PGO, the open source Postgres Operator from Crunchy Data using AWS EBS gp2 volumes.
Skylar Advisor combines real-time observability data, rich operational context, and customer-owned knowledge to deliver explainable AI guidance for IT operations.
Struggling with IndexedDB performance? Discover hidden bottlenecks, advanced tuning techniques, and next-gen storage like the File System Access API.
A look at the quarterly and lifetime failure rates of 175,443 drives, including a comparison of failure rates of HDD and SSD boot drives.
Product quantization (PQ) is a popular method for dramatically compressing high-dimensional vectors to use 97% less memory, and for making nearest-neighbor search speeds 5.5x faster in our tests.
In this blog, we describe how we leverage the authentication and authorization support in Open Distro for Elasticsearch to make elasticsearch a...
A machine learning AI-esque robot challenges off on 156 trivia questions against tens of thousands of Water Cooler Trivia participants.
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
Using Postgres Hooks to protect functionality in your Postgres database.
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.
These vendor-customised Android variants transmit substantial amounts of information to the OS developer and to third parties such as Google, Microsoft, LinkedIn, and Facebook that have pre-installed system apps.
Collaboration on rich text is hard to model with plain-text approaches. We review the challenges and how to construct a CRDT for rich text.
The CPI chart on the home page reflects our estimate of inflation for today as if it were calculated the same way it was in 1990. The CPI on the Alternate Data Series tab here reflects the CPI as if it were calculated using the methodologies in place in 1980. In general terms, methodological shifts in government…
Money is marvelously nuanced. Because different assets can be used as money, we need several categories and definitions to keep track of it. M1 describes the most liquid and widely...
While the terms “money” and “wealth” often mean the same thing in everyday parlance, economists define money more narrowly as the component of wealth consisting of
KFF is collecting and analyzing data on COVID-19 vaccinations by race/ethnicity to gain increased insight who is receiving the vaccine and whether some groups are facing disparities in vaccination.
