Gavin Ray
@GavinRayDev
Followers
1K
Following
5K
Media
412
Statuses
2K
Work @PromptQL (@HasuraHQ) OSS Contributor. I have a Postgres tattoo 🐘🎨 Interests: GraphQL, SQL, JVM, Query Engines, TypeScript, API's
Miami, FL
Joined June 2018
Been holding on to these for a while now.Not sure what for, mostly as collectibles I guess lol
0
0
1
RT @caydengineer: get free AI smart glasses:. 1. Borrow $$$.2. Buy glasses.2. Go to trivia with Merge app which automatically answers quest….
0
3
0
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_Moonshot blow everything from my paid ChatGPT, Grok, Gemini, and Claude accounts away.
0
0
0
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
Hands-on guide to the upcoming SQL/PGQ graph syntax using a patched Postgres 18 beta.
2
0
5
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
A discussion on techniques available to overcome semantic errors in syntax when generating dialect-specific SQL
0
1
1
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()
0
0
1
Yo @LogitechG . 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
0
0
2
I found a perfect domain for my wife but it appears someone recently bought it =(
1
0
0
RT @axboe: 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….
github.com
Library providing helpers for the Linux kernel io_uring support - axboe/liburing
0
62
0
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
1
0
1
RT @eatonphil: I spent some time looking into how various databases execute expressions in their query language. Most of them have a tree-….
0
82
0
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:.
0
0
2
What a time be alive:. "This spray contains bio-nanoantennae, special molecules that can alter cells at the quantum level.".
interestingengineering.com
Scientists propose a spray that will make the most aggressive brain cancer tumors commit suicide. This spray contains bio-nanoantennae, special molecules that can alter cells at the quantum level.
0
0
6
RT @CMUDB: Today's ML⇄DB Seminar Speaker: @danavanaken (@CSDatCMU PhD'21) will present @OtterTuneAI's approach to using ML to automaticall….
db.cs.cmu.edu
This talk is part of the ML⇄DB Seminar Series. Zoom Link: https://cmu.zoom.us/j/91461275681... Read More +
0
11
0
RT @PostgreSQL: News: Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0
postgresql.org
The Apache Arrow team is pleased to announce the 0.1.0 release of the Apache Arrow Flight SQL adapter for PostgreSQL. …
0
12
0
RT @gunnarmorling: "Building a Database From the Ground Up". Oh wow, this looks like an extremely cool workshop (by @ayende) at @QConSF lat….
0
7
0