News: Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0 postgresql.org/about/news/apa…

Today's ML⇄DB Seminar Speaker: Dana Van Aken (CMU Computer Science Department PhD'21) will present OtterTune's approach to using ML to automatically optimize PostgreSQL and MySQL databases. Zoom talk is open to public at 4:30pm ET. YouTube video available afterwards: db.cs.cmu.edu/events/ml-db-2…

What a time be alive: "This spray contains bio-nanoantennae, special molecules that can alter cells at the quantum level." interestingengineering.com/health/first-q…

I spent some time looking into how various databases execute expressions in their query language. Most of them have a tree-walking interpreter, some have a virtual machine, and some do just-in-time compilation. Let's dig into some database code to see! notes.eatonphil.com/2023-09-21-how…

Really looking forward to Dave Malcom from Redhat's "GNU Tools Cauldron" talk about GCC 14 Diagnostics improvements: His work on the Static Analyzer is incredible, and if you haven't seen the new ASCII art diagnostics, check THIS out: gcc.gnu.org/git/?p=gcc.git…

Do I know anyone who played the SNES game Uncharted Waters II: New Horizons? It's one of the greatest games I've ever played. It had a depth (e.g. dynamic economy) that for its time was unheard of. Highly recommend it if you like open-world RPGs

Finally got memcache and io_uring for network traffic sorted out, hope to write a post on it in the near future. Won’t spoil the results, but the wins are very nice, to put it mildly. If you’re wondering how, it’s all in this: github.com/axboe/liburing…

Check out what showed up! Thanks a ton Teresa Giacomini from Citus Data ♥️

I found a perfect domain for my wife but it appears someone recently bought it =(

Yo Logitech G Your GHub app has one of the nicest UI + UX of any desktop app I've used. But you might consider warning peeps that you take up some of the ports between 9000-9100 😅 I burned bunch of time + was losing my mind because couldn't hit an API at localhost:9100

This is one of my biggest gripes about SQL Let's say you want to return some default value when there are no rows. The below doesn't work -- you need to refer to some specific column in the aliased subquery, you can't just do t.* for functions like COUNT()

Saw the Google Cloud post "Getting AI to write good SQL" and similar comments on HN recently I felt compelled to share an approach for portable, dialect-agnostic SQL generation This is something I work on at <DAYJOB>, so it hit close to home for me. gavinray97.github.io/blog/overcomin…

Been a while, got the itch though: "Experimenting with SQL:2023 Property-Graph Queries in Postgres 18" Sneak-peek of SQL/PGL on a patched PG 18beta2 gavinray97.github.io/blog/postgres-…

I'd consider myself anti-hype. It's rare that I get excited about "the hot new stuff". I'm as big a daily LLM user as anybody, but these Research Reports by Kimi.ai blow everything from my paid ChatGPT, Grok, Gemini, and Claude accounts away... kimi.com/preview/19824d…

get free AI smart glasses: 1. Borrow $$$ 2. Buy glasses 2. Go to trivia with Merge app which automatically answers questions 3. Pay back the loan with winnings

Been holding on to these for a while now Not sure what for, mostly as collectibles I guess lol

So fun to spot the PromptQL neon randomly around SF! This one is right outside the Heavybit devguild event that I am speaking at in a bit 😎

AI is changing everything. Full stop. If you still don't get it, watch this. Look at the attached video. A company using this tool will execute 100x faster than everyone else. There's simply no match for how fast AI can transform what you do.

Neat test, results feel accurate for me: treeform.github.io/devcompas/