GavinRayDev's profile picture. Work @PromptQL (@HasuraHQ)
OSS Contributor. I have a Postgres tattoo 🐘🎨

Interests: GraphQL, SQL, JVM, Query Engines, TypeScript, API's

Gavin Ray

@GavinRayDev

Work @PromptQL (@HasuraHQ) OSS Contributor. I have a Postgres tattoo 🐘🎨 Interests: GraphQL, SQL, JVM, Query Engines, TypeScript, API's

مثبتة

Pretty cool 👀

GavinRayDev's tweet image. Pretty cool 👀

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

GavinRayDev's tweet image. Neat test, results feel accurate for me:
treeform.github.io/devcompas/

Gavin Ray أعاد

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.


Gavin Ray أعاد

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 😎

rajoshighosh's tweet image. 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 😎

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

GavinRayDev's tweet image. Been holding on to these for a while now
Not sure what for, mostly as collectibles I guess lol

Gavin Ray أعاد

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

caydengineer's tweet image. 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

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... kimi.com/preview/19824d…

GavinRayDev's tweet image. 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...

kimi.com/preview/19824d…

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-…


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…


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()

GavinRayDev's tweet image. This is one of my biggest gripes about SQL

Let&apos;s say you want to return some default value when there are no rows.

The below doesn&apos;t work -- you need to refer to some specific column in the aliased subquery, you can&apos;t just do t.* for functions like COUNT()

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

GavinRayDev's tweet image. Yo @LogitechG 

Your GHub app has one of the nicest UI + UX of any desktop app I&apos;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&apos;t hit an API at localhost:9100

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

GavinRayDev's tweet image. I found a perfect domain for my wife but it appears someone recently bought it =(

Check out what showed up! Thanks a ton @tgcmn from @citusdata ♥️

GavinRayDev's tweet image. Check out what showed up!

Thanks a ton @tgcmn from @citusdata ♥️

Gavin Ray أعاد

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…

github.com

io_uring and networking in 2023

Library providing helpers for the Linux kernel io_uring support - axboe/liburing


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

GavinRayDev's tweet image. Do I know anyone who played the SNES game Uncharted Waters II: New Horizons?

It&apos;s one of the greatest games I&apos;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

Gavin Ray أعاد

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…

eatonphil's tweet image. 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&apos;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…

GavinRayDev's tweet image. Really looking forward to Dave Malcom from Redhat&apos;s &quot;GNU Tools Cauldron&quot; talk about GCC 14 Diagnostics improvements:

His work on the Static Analyzer is incredible, and if you haven&apos;t seen the new ASCII art diagnostics, check THIS out:

gcc.gnu.org/git/?p=gcc.git…

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…


Gavin Ray أعاد

Today's ML⇄DB Seminar Speaker: @danavanaken (@CSDatCMU PhD'21) will present @OtterTuneAI'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…


Gavin Ray أعاد

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


Loading...

Something went wrong.


Something went wrong.