sql_johnpruitt's profile picture.

John P

@sql_johnpruitt

John P 已轉發

Agents are the new developers, and they need databases built for how they work. Today we're open-sourcing Eon: a production Slack agent that turns institutional knowledge into instant answers. After 6 weeks, nearly 50% of our company uses it regularly. We learned three things…


John P 已轉發

It's Mat (@cevianNY) from @tigerdatabase again. This week I am announcing a new open-source tool for evaluating and improving LLM-based text-to-SQL systems for PostgreSQL. We built this because in developing the semantic catalog text-to-SQL tool I discussed last week, we thought…


John P 已轉發

LLMs are becoming new users of the database. But unlike human users, it’s not enough to ask “did the query run?” We need ways to evaluate how well they interact with our data. Over the past few months, our team built an internal library to better understand text-to-SQL…


John P 已轉發

Stop paying the OpenAI tax. The best AI devtools are actually open-source, free to use, and give you full control over your data and privacy. While proprietary AI dominated early headlines, the true revolution is happening in open source - where a flourishing ecosystem of…

avthars's tweet image. Stop paying the OpenAI tax. The best AI devtools are actually open-source, free to use, and give you full control over your data and privacy.

While proprietary AI dominated early headlines, the true revolution is happening in open source - where a flourishing ecosystem of…

John P 已轉發

Engineer: "Should we upgrade to the latest OpenAI model? It's cheaper and performs better on benchmarks." Tech lead: "We should explore it, but re-embedding all our data is too much work right now. Let's revisit next month." Engineer: "Hold my beer..." With pgai Vectorizer,…

avthars's tweet image. Engineer: "Should we upgrade to the latest OpenAI model? It's cheaper and performs better on benchmarks."

Tech lead: "We should explore it, but re-embedding all our data is too much work right now. Let's revisit next month."

Engineer: "Hold my beer..."

With pgai Vectorizer,…

John P 已轉發

One of the major challenges with building AI chat apps and agents powered by RAG is the complexity of creating, storing, and syncing embeddings with real-time source data. If this isn't managed effectively, your AI app will likely generate outdated, inaccurate information…

mayowaoshin's tweet image. One of the major challenges with building AI chat apps and agents powered by RAG is the complexity of creating, storing, and syncing embeddings with real-time source data. 

If this isn't managed effectively, your AI app will likely generate outdated, inaccurate information…

John P 已轉發

𝗧𝗵𝗲 𝗵𝗮𝗿𝗱 𝗽𝗮𝗿𝘁 𝗼𝗳 𝗲𝗺𝗯𝗲𝗱𝗱𝗶𝗻𝗴 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝗼𝗻 𝗶𝘀 𝗵𝗮𝗻𝗱𝗹𝗶𝗻𝗴 𝘁𝗵𝗲 𝗳𝗮𝗶𝗹𝘂𝗿𝗲 𝗰𝗮𝘀𝗲𝘀. Yesterday, we launched pgai Vectorizer, a tool that automates embedding generation directly from data stored in the database and keeps it synced as the…

cevianNY's tweet image. 𝗧𝗵𝗲 𝗵𝗮𝗿𝗱 𝗽𝗮𝗿𝘁 𝗼𝗳 𝗲𝗺𝗯𝗲𝗱𝗱𝗶𝗻𝗴 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝗼𝗻 𝗶𝘀 𝗵𝗮𝗻𝗱𝗹𝗶𝗻𝗴 𝘁𝗵𝗲 𝗳𝗮𝗶𝗹𝘂𝗿𝗲 𝗰𝗮𝘀𝗲𝘀.

Yesterday, we launched pgai Vectorizer, a tool that automates embedding generation directly from data stored in the database and keeps it synced as the…

John P 已轉發

Vector Databases should actually be Vector Indexes Imagine if every time you inserted or updated a row, you had to reach out to an external system to update the associated B-trees. Each call risks failure, rate-limits, and throws in queuing, tracking, staleness handling, and…

cevianNY's tweet image. Vector Databases should actually be Vector Indexes

Imagine if every time you inserted or updated a row, you had to reach out to an external system to update the associated B-trees. Each call risks failure, rate-limits, and throws in queuing, tracking, staleness handling, and…

John P 已轉發

🛑 Vector Databases Are the Wrong Abstraction. Here’s Why. They treat embeddings as standalone data, disconnected from their source, leading to outdated embeddings, constant sync issues, and endless maintenance. That’s why we built pgai Vectorizer for Postgres—so every engineer…

TimescaleDB's tweet image. 🛑 Vector Databases Are the Wrong Abstraction. Here’s Why.

They treat embeddings as standalone data, disconnected from their source, leading to outdated embeddings, constant sync issues, and endless maintenance.

That’s why we built pgai Vectorizer for Postgres—so every engineer…

John P 已轉發

The original SQL paper (1974) really stands the test of time CPUs were 20,000,000,000x more expensive per flop in 1974! SQL is 50 years old: older than the Internet, hard disks, Linux, x86, and CMOS RAM; yet SQL remains in service to people today, for the exact same use cases

ekzhang1's tweet image. The original SQL paper (1974) really stands the test of time

CPUs were 20,000,000,000x more expensive per flop in 1974!

SQL is 50 years old: older than the Internet, hard disks, Linux, x86, and CMOS RAM;
yet SQL remains in service to people today, for the exact same use cases

John P 已轉發

After my team built this we only had one question: why doesn’t everyone do embedding this way?

VECTOR DATABASES ARE THE WRONG ABSTRACTION. Here’s a better way: introducing pgai Vectorizer, a new open-source PostgreSQL tool that automatically creates and syncs embeddings with source data, just like a database index. ❌ Why vector databases fail Vector databases treat…

avthars's tweet image. VECTOR DATABASES ARE THE WRONG ABSTRACTION. Here’s a better way: introducing pgai Vectorizer, a new open-source PostgreSQL tool that automatically creates and syncs embeddings with source data, just like a database index.

❌ Why vector databases fail
Vector databases treat…


John P 已轉發

🔥 𝗘𝘃𝗲𝗿𝘆 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿 𝗶𝘀 𝗻𝗼𝘄 𝗮𝗻 𝗔𝗜 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿: 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝗽𝗴𝗮𝗶 𝗩𝗲𝗰𝘁𝗼𝗿𝗶𝘇𝗲𝗿 🔥 𝗽𝗴𝗮𝗶 𝗩𝗲𝗰𝘁𝗼𝗿𝗶𝘇𝗲𝗿 is a developer tool that automatically creates and syncs embeddings right in your PostgreSQL database. In other…

acoustik's tweet image. 🔥 𝗘𝘃𝗲𝗿𝘆 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿 𝗶𝘀 𝗻𝗼𝘄 𝗮𝗻 𝗔𝗜 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿: 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝗽𝗴𝗮𝗶 𝗩𝗲𝗰𝘁𝗼𝗿𝗶𝘇𝗲𝗿 🔥

𝗽𝗴𝗮𝗶 𝗩𝗲𝗰𝘁𝗼𝗿𝗶𝘇𝗲𝗿 is a developer tool that automatically creates and syncs embeddings right in your PostgreSQL database.

In other…

John P 已轉發

VECTOR DATABASES ARE THE WRONG ABSTRACTION. Here’s a better way: introducing pgai Vectorizer, a new open-source PostgreSQL tool that automatically creates and syncs embeddings with source data, just like a database index. ❌ Why vector databases fail Vector databases treat…

avthars's tweet image. VECTOR DATABASES ARE THE WRONG ABSTRACTION. Here’s a better way: introducing pgai Vectorizer, a new open-source PostgreSQL tool that automatically creates and syncs embeddings with source data, just like a database index.

❌ Why vector databases fail
Vector databases treat…

John P 已轉發

Timescale expands open source vector database capabilities for PostgreSQL venturebeat.com/data-infrastru…

VentureBeat's tweet image. Timescale expands open source vector database capabilities for PostgreSQL venturebeat.com/data-infrastru…

John P 已轉發

🚀 Every Developer is Now an AI Developer - Introducing pgai Vectorizer No need for specialized tools or vector databases—pgai Vectorizer lets you create, sync, and manage embeddings with just one SQL command. 🔹 Embeddings in Postgres: Build, store, and sync embeddings…

TimescaleDB's tweet image. 🚀 Every Developer is Now an AI Developer -  Introducing pgai Vectorizer

No need for specialized tools or vector databases—pgai Vectorizer lets you create, sync, and manage embeddings with just one SQL command.

🔹 Embeddings in Postgres: Build, store, and sync embeddings…

John P 已轉發

👀 launching something big tomorrow...

avthars's tweet image. 👀 launching something big tomorrow...

John P 已轉發

👀 What's this? Something new launching tomorrow? Hm.....

acoustik's tweet image. 👀 What's this? Something new launching tomorrow? Hm.....

John P 已轉發

Build a fully private RAG app with @ollama, Llama3 (@AIatMeta) and PostgreSQL Worried about AI models leaking confidential data? Our new tutorial shows you how to build a private RAG application with no risk of data leakage, by using local models and open-source tools, all…

avthars's tweet image. Build a fully private RAG app with @ollama, Llama3 (@AIatMeta) and PostgreSQL

Worried about AI models leaking confidential data? 
Our new tutorial shows you how to build a private RAG application with no risk of data leakage, by using local models and open-source tools, all…

Loading...

Something went wrong.


Something went wrong.