301
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.
New
The latest blog posts to take off on Hacker News. 371 posts.
302
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. …
303
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…
304
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. …
305
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.
306
Running Databases on Kubernetes
Things to consider when running a database on Kubernetes.
307
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…
308
309
Pandas 2.0 and the Arrow revolution
about me
310
311
Most data work seems fundamentally worthless
After going viral, there is one comment I'd like to address. One guy pointed out how comfortable this work seemed, how high the pay was, and said I am out-of-touch and privileged. To that I say, yes, obviously . I moved to the first-world to have first-world problems. Mission accomplished.
312
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.
313
Oops, You Wrote a Database
Those who fail to study databases are doomed to write them
314
Speedy transactions in multicore in-memory databases
This paper is from SOSP'13. The Polyjuice paper, which we studied last week, built on the Silo codebase and commit protocol, which led me ...
315
What's Postgres got to do with AI?
Chris is cooking up some examples for us on how to use AI inside Postgres. We have a simple demo of using pgvector and Open AI to grab relationships and query for other similar items.
316
Poor schemas, poor cataloguing: why music tagging sucks
One of the things that frustrates me with having a local music library is the tedium of tagging. While there are tools (like beets or MusicBrainz Picard) to make it easier, I feel there are fundamental issues with the design… Continue reading →
317
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
We talk about querying system wide I/O statistics in Postgres, show several use cases for pg_stat_io, and talk about the future of I/O observability in Postgres.
318
Type constraints in 65 lines of SQL
Creating validated data types in Postgres
319
Postgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_switch_wal.
320
Introduction to Datalog
A rule-based data query language that thinks differently
321
322
DuckDB 0.7.0
The DuckDB team is happy to announce the latest DuckDB version (0.7.0) has been released. This release of DuckDB is named “Labradorius” after the Labrador Duck (Camptorhynchus labradorius) that was native to North America. To install the new version, please visit the installation guide. The full release notes can be…
323
Clog: Making a homegrown ClickHouse log for $20 a month
There was recently a discussion on Hacker News around application logging on a budget. At work I've been trying to keep things lean, not to the point of absurdity, but also not using a $100 or $1000/month setup, when a $10 one will suffice for now . We settled on a homegrown Clickhouse + PHP solution that has…
324
Algorithmic Trading: A Practitioner’s Guide
I really enjoyed reading Algorithmic Trading: A Practitioner’s Guide by Jeffrey M. Bacidore. Before starting, I imagined it would cover various strategies for trading in the markets, along th…
325
326
Manticore 6.0.0 – a faster alternative to Elasticsearch in C++
Today, the Manticore team is thrilled to announce the release of Manticore Search 6.
327
328
329
Tips for a healthier Postgres database (2021)
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
330
Apache Kafka Beyond the Basics: Windowing
Learn what windowing is, the difference between the four types of windows (hopping and tumbling, or session and sliding), and how to create them.