1171
How to Read MySQL EXPLAINs
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1172
Retool Database
Get a free Postgres DB with the speed + convenience of a spreadsheet. No setup required. Get started today.
1173
1174
AlloyDB Omni – run AlloyDB anywhere
Today, we’re excited to announce the technology preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run on premises, at the edge, across clouds, or even on developer laptops.
1175
1176
New health insurance “transparency data” looks suspiciously wrong
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
1177
Quicker serverless Postgres connections
Neon’s serverless driver redirects the PostgreSQL TCP wire protocol over WebSockets. This makes ordinary, fully-functional PostgreSQL connections accessible from new environments — including serverless platforms like Cloudflare Workers and Vercel Edge Functions. A key feature of these environments is that state is not…
1178
1179
Ban 1+N in Django
I always thought of 1+N as a thing that you just keep in your head, catch on code reviews or via performance regressions. This worked well for a long …
1180
Retrieval in LangChain
Build better AI apps with flexible retrieval methods in LangChain. Use any retriever—from semantic to hybrid—to create personalized ChatGPT for your data.
1181
Yandex open-sources its exabyte-scale big data platform
Hello, my name is Maxim Babenko, I’m the head of the distributed computing technologies department at Yandex. Today we’re pleased to…
1182
Pg_jsonschema – JSON Schema Support for Postgres
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
1183
Strong Consistency with Raft and SQLite
In the recent past, a typical client/server environment consisted of multiple clients connected to a central database server. A central database architecture is a system where all data is stored in a single centralized location. When client A from Si...
1184
Bank failures come in waves
Interactive post about the frequency of bank failures over time
1185
Building ClickHouse Cloud from scratch in a year
Have you ever wondered what it takes to build a serverless software as a service (SaaS) offering in under a year? In this blog post, we will describe how we built ClickHouse Cloud from the ground up
1186
PostgreSQL Logical Replication Explained
Vigneshwaran C explained the internals of PostgreSQL Logical Replication during PGConf India - if you were not able to attend, you can read all here.
1187
Pyroscope and Grafana Phlare join together
We’re happy to announce that Pyroscope, the company behind the open source continuous profiling project of the same name, is now part of Grafana Labs.
1188
PostgreSQL 14 Internals
I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova. The final part of the book considers each of the index types in great detail. It explains and demonstrates how access methods, operator classes, and data types work…
1189
What is Temperature in NLP?
Temperature is a parameter used in natural language processing models to increase or decrease the “confidence” a model has in its most likely response.
1190
There have been 562 bank failures since 2000
One way to measure the magnitude of a bank's failure is by the amount of assets the bank held. At the time it failed, SVB's collapse was the second largest American bank failure of all time, and the largest since 2008.
1191
ChatGPT is now finding bugs in databases
Engineering notes and product news from the PhoenixAI team — real-time analytics, AI agent workloads, lakehouse architecture, and what we're shipping.
1192
Stochastic gradient descent written in SQL
Edit – this post generated a few insightful comments on Hacker News. I’ve also put the code in a notebook for ease of use. Introduction Modern MLOps is complex because it involves too many components. …
1193
The Most Cited AI Papers in 2022
Who Is publishing the most Impactful AI research right now? With the breakneck pace of innovation in AI, it is crucial to pick up some signal as soon as possible. No one has the time to read everything, but these 100 papers are sure to bend the road as to where our AI technology is going. The real test of impact of…
1194
Finding Java Thread Leaks with JDK Flight Recorder and a Bit of SQL
The other day at work, we had a situation where we suspected a thread leak in one particular service, i.e. code which continuously starts new threads, without taking care of ever stopping them again. …
1195
DuckDB: Querying JSON files as if they were tables
We recently improved DuckDB's JSON extension so JSON files can be directly queried as if they were tables.
1196
Running Databases on Kubernetes
Things to consider when running a database on Kubernetes.
1197
You cannot have exactly-once delivery (2015)
I’m often surprised that people continually have fundamental misconceptions about how distributed systems behave. I myself shared many of these misconceptions, so I try not to demean or dismiss but rather educate and enlighten, hopefully while sounding less preachy than that just did. I continue to learn only by…
1198
1199
Pandas 2.0 and the Arrow revolution
about me
1200