Did you asked for copying the schema and queries... in SQL, TypeScript, Zod, Prisma Postgres, Drizzle ORM, kysely formats?show more

Do you use process.env in your TypeScript application, cast... values to String, and risk encountering undefined ones? 🤔 By using a Zod schema for your environment variables, you can have a properly-typed config object 😉 👉show more

"Can I pass a zod schema from a server... to a client component as a prop?" Nope, zod schema is not serializable. But you can re-import it in the client component.show more

made a component that renders forms based on a... zod schema - uses my own components - supports custom labels, placeholders, props, etc now I just create a zod schema, pass it to createForm() and get a fully functional form component. maybe worth making an npm package for thisshow more

Prisma Next is the version of Prisma ORM we... would’ve created if we started from scratch based on the tech landscape of the late 2020s. And after months of hard work, it’s finally in Early Access 🚀 Run "npm create prisma@next" and try it today with PostgreSQL or MongoDB.show more

This is how long it takes to load data... from your Prisma Postgres Postgres DB using Accelerate Stay tuned, video drops tomorrow!show more

What Postgres can’t do alone, it can tackle with... DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the appshow more

Lazy to write SQL queries? Chat with your DB ✨

I've been invited by the wonderful TANSTACK team to... help them build out framework-agnostic devtools not for only them, but for everyone! Here's a sneek peak of TanStack router, query, and Prisma Postgres embedded studio running in @tanstack/devtoolsshow more

So Lingling asked Orm what’s the answer and Orm... said YESshow more

The fastest ZK coprocessor in crypto just got 3x... faster. 🤯 Proof of SQL is a sub-second ZK coprocessor that allows smart contracts to run fast, verifiable SQL queries against indexed blockchain data and get back ZK-proven answers onchain. The team at MakeInfinite Labs just pushed some insane new performance upgrades to the repo ahead of Space and Time mainnet. Queries on mainnet will be faster than ever ⚡show more

¿Tu propósito de 2025 es Aprender Programación? Cursos de... Node, React, SQL, TypeScript, HTML y CSS ↓show more

It seems that we got Drizzle ORM Studio working... on NuxtHub 🚀 What you see is my D1 database.show more

Need a temporary production-grade Postgres DB to quickly test... something? 🚀 Run `npx create-db@latest` and get a connection string, no login needed! Bonus: You can keep the DB beyond 24 hours if you need it, just claim it 😉 👉show more

AT LAST, manage your Supabase database directly within Cline.... The official Supabase MCP server is available, allowing SQL execution, schema changes, and full database interaction. Yes, that means read AND write: 🧵show more

Big moment for Postgres! Search has always been Postgres'... weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.show more

ling: *darkens orm’s mole* orm: ling, what did you... do to orm!!! *does the same back to ling* orm: *kisses her head* they’re so silly 😭show more

TRUTH ENGINE ONLINE ✓ Space and Time Agent is... now available on Heurist Mesh! 🔍🔮 Transform natural language into ZK-verified SQL queries for trustless blockchain analytics across multiple chains. Every result cryptographically proven byshow more

Sidebar for AI application built with React and TypeScript... 🚀 Code in the comments and within Atheros Pass 🧑‍💻show more