正在加载视频...

视频加载失败

返回首页

🆕 Introducing PrismaGPT, a query helper built on GPT-4 🎉 * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query 👍

ryanchenkie's profile picture

Ryan Chenkie

10,899 subscribers

94,195 次观看 • 3 年前 •via X (Twitter)

科学技术新闻政治教育
LIVE

Anya Rossi• Live Now

Private livecam show

10 条评论

Matija Sosic 的头像
Matija Sosic3 年前

@prisma nice one! If you're looking for an OSS template to build sth similar, we just released one yesterday (React/Node/Prisma + GPT integration): It already got >100⭐️ on gh!

Tim Petri 的头像
Tim Petri3 年前

@prisma This would be awesome as a vs code extension instead of a website where I have to upload (and reupload) my schema.

Ryan Chenkie 的头像
Ryan Chenkie3 年前

@prisma VS Code extension would be cool. I'll look into that. I'll also add something to keep the schema in local storage.

Manish Dalal 的头像
Manish Dalal3 年前

@prisma Have a look at use gpt to create schema, build query and generate CRUD query code!

Alex Ruheni 的头像
Alex Ruheni3 年前

@prisma This looks really awesome @ryanchenkie! 🎉 Would you like to join us tomorrow on "What's New In Prisma" to showcase PrismaGPT?

Theral Moyo 的头像
Theral Moyo3 年前

@prisma This is so sick, will be featuring it in my AI newsletter tomorrow. Getting sent to 4000 people

Ryan Chenkie 的头像
Ryan Chenkie3 年前

@prisma Many thanks!

Jan Wilhelm 的头像
Jan Wilhelm3 年前

@prisma If you are using Metabase and want a similar SQL-generating feature, have a look at @AvantyApp

Mike @ HTML All The Things 🇨🇦 的头像
Mike @ HTML All The Things 🇨🇦3 年前

@prisma This is awesome! Love that it gives both Prisma client and SQL. Probably going to use that with planetscale's database.js lib.

Jens Neuse | Founder @ WunderGraph 的头像
Jens Neuse | Founder @ WunderGraph3 年前

@prisma The next step is to ask GPT to just generate code that does what you need, without an ORM. 😅

相关视频

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.
0:50

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.

Marc Brooker

47,031 次观看 • 8 个月前

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 次观看 • 1 年前

PEOPLE OF THE EARTH. Figured out how to ask natural language questions of current financial data and get back a natural language response...with correct/relevant numbers! 🤯💰✨ So. Freaking. Cool. 1. Send database schema along with the question and relevant scope/parameters to GPT. 2. GPT returns SQL query. 3. Run SQL query on your data. 4. Take returned data and pass it in along with the original question. 5. GPT returns natural language answer with relevant data! Original Question: What was the highest price of Apple's stock over the past decade and how does it compare to Tesla's highest stock price? And on what date were those highest prices? Final Answer: The highest price of Apple's stock over the past decade was $182.94 on January 4, 2022, while Tesla's highest stock price was $414.50 on November 4, 2021.
3:23

PEOPLE OF THE EARTH. Figured out how to ask natural language questions of current financial data and get back a natural language response...with correct/relevant numbers! 🤯💰✨ So. Freaking. Cool. 1. Send database schema along with the question and relevant scope/parameters to GPT. 2. GPT returns SQL query. 3. Run SQL query on your data. 4. Take returned data and pass it in along with the original question. 5. GPT returns natural language answer with relevant data! Original Question: What was the highest price of Apple's stock over the past decade and how does it compare to Tesla's highest stock price? And on what date were those highest prices? Final Answer: The highest price of Apple's stock over the past decade was $182.94 on January 4, 2022, while Tesla's highest stock price was $414.50 on November 4, 2021.

Josh Pigford

245,304 次观看 • 3 年前

There are 5 million oil and gas wells across the US - but you want to know what's going on in your area. AI helps you cut through the noise. Draw a shape on the map, query the wells - AI tells you who's operating, what they're drilling, how deep they're going.
1:17

There are 5 million oil and gas wells across the US - but you want to know what's going on in your area. AI helps you cut through the noise. Draw a shape on the map, query the wells - AI tells you who's operating, what they're drilling, how deep they're going.

Kyle Walker

23,174 次观看 • 6 个月前

When CBI gives a green light to charge sheet you in cash-for-query scam but you have already married a senior advocate for this day Then you at your wedding reception 😂:
2:10

When CBI gives a green light to charge sheet you in cash-for-query scam but you have already married a senior advocate for this day Then you at your wedding reception 😂:

Monica Verma

40,826 次观看 • 8 个月前

Have you ever been frustrated trying to find relevant web results for complex search queries? Introducing Deep Search, a new Bing feature which leverages GPT-4 to expand your query into many variations and multiple probable intents, so that you can find highly relevant results.
0:26

Have you ever been frustrated trying to find relevant web results for complex search queries? Introducing Deep Search, a new Bing feature which leverages GPT-4 to expand your query into many variations and multiple probable intents, so that you can find highly relevant results.

Jordi Ribas

23,613 次观看 • 2 年前

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: ↳ Your data stays in place. No ETL pipelines or data duplication ↳ Query Postgres, MongoDB, REST APIs, and more using consistent SQL ↳ JOIN across different sources in real-time with a unified interface ↳ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!
9:28

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: ↳ Your data stays in place. No ETL pipelines or data duplication ↳ Query Postgres, MongoDB, REST APIs, and more using consistent SQL ↳ JOIN across different sources in real-time with a unified interface ↳ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!

Akshay 🚀

65,672 次观看 • 9 个月前

"When you know exactly what you want and aren't afraid to ask for it. 💅✨ 🎬FoolsRushIn"
0:58

"When you know exactly what you want and aren't afraid to ask for it. 💅✨ 🎬FoolsRushIn"

HIL~LARY

130,006 次观看 • 2 个月前

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.
2:37

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.

Chris Long

13,185 次观看 • 2 年前

DeFi data just became model-ready. Introducing Query Builder for DefiLlama Sheets. Instead of writing complex formulas or stitching together multiple queries, you can now pull exactly the data you want into Sheets or Excel in a few clicks. > Build spreadsheet formulas visually > Query multiple projects in a single request > Analyze historical metrics side by side with clean, consistent data
0:52

DeFi data just became model-ready. Introducing Query Builder for DefiLlama Sheets. Instead of writing complex formulas or stitching together multiple queries, you can now pull exactly the data you want into Sheets or Excel in a few clicks. > Build spreadsheet formulas visually > Query multiple projects in a single request > Analyze historical metrics side by side with clean, consistent data

DefiLlama.com

21,665 次观看 • 6 个月前

💡 CSS Tip! A small tool to create a quantity query selector using has(). Adjust the setting and get your selector in no time! 😎 I am trying a new kind of "interactive CSS Tip". Let me know what you think. Link in the reply 👇
0:34

💡 CSS Tip! A small tool to create a quantity query selector using has(). Adjust the setting and get your selector in no time! 😎 I am trying a new kind of "interactive CSS Tip". Let me know what you think. Link in the reply 👇

CSS by T. Afif

19,823 次观看 • 1 年前

My website is almost complete. You enter any baseball savant search query and it will collect all the videos from that query and combine them into one video for you to download. Here's a test example. It was made in less than 1 minute with just 2 clicks of a button
6:40

My website is almost complete. You enter any baseball savant search query and it will collect all the videos from that query and combine them into one video for you to download. Here's a test example. It was made in less than 1 minute with just 2 clicks of a button

Vinnie

306,541 次观看 • 1 年前

"what time is the debate" query on google is a deep commentary on state of internet .. most obvious one box ever answer, but instead pages and pages of SEO optimized crap that hides the answer you obviously want
0:40

"what time is the debate" query on google is a deep commentary on state of internet .. most obvious one box ever answer, but instead pages and pages of SEO optimized crap that hides the answer you obviously want

sam lessin 🏴‍☠️

562,164 次观看 • 1 年前

Available to everyone: The new analytics lets you query your data directly from a report in real time using ShopifyQL, for more dynamic and customizable reporting. Everyone has a data warehouse now!
0:20

Available to everyone: The new analytics lets you query your data directly from a report in real time using ShopifyQL, for more dynamic and customizable reporting. Everyone has a data warehouse now!

tobi lutke

12,139 次观看 • 1 年前

Does your team rely on Snowflake or BigQuery as your data warehouse? We built the step that every other onchain data provider skips. Transform first, deliver only what you need. dbt Connector → Datashare is now live. Query against 130+ chains ➡️ Transform with dbt on DuneSQL ➡️ Deliver only what you need to your warehouse One contract. Any dataset. Any transformation.
1:08

Does your team rely on Snowflake or BigQuery as your data warehouse? We built the step that every other onchain data provider skips. Transform first, deliver only what you need. dbt Connector → Datashare is now live. Query against 130+ chains ➡️ Transform with dbt on DuneSQL ➡️ Deliver only what you need to your warehouse One contract. Any dataset. Any transformation.

Dune

31,177 次观看 • 4 个月前

Meet Waldo: Glean’s first agentic search model. Built on NVIDIA Nemotron 3 Nano and post-trained for search planning, Waldo figures out how to break down a query, which tools to call, what to read next, and when it has enough evidence to hand off.
0:50

Meet Waldo: Glean’s first agentic search model. Built on NVIDIA Nemotron 3 Nano and post-trained for search planning, Waldo figures out how to break down a query, which tools to call, what to read next, and when it has enough evidence to hand off.

Glean

98,637 次观看 • 3 个月前

Introducing DeadSubs - You can just take over a dead subreddit. Find Dead and Inactive subreddits eligible for takeover with DeadSubs. Here is how to use it. > Enter query/keywords you are looking for > AI will generate suggested keywords > Search for Dead Subreddits > Follow the Reddit official process to make it yours. > Boost your Reddit Marketing. Start for free!
0:48

Introducing DeadSubs - You can just take over a dead subreddit. Find Dead and Inactive subreddits eligible for takeover with DeadSubs. Here is how to use it. > Enter query/keywords you are looking for > AI will generate suggested keywords > Search for Dead Subreddits > Follow the Reddit official process to make it yours. > Boost your Reddit Marketing. Start for free!

Manoj Ahirwar

11,298 次观看 • 3 个月前

We can finally say it! is launching today! We spent a year building the data substrate for the agent economy, one MCP that allows your agents to query the world as a DB, so you can skip the data and focus on building what matters! Cala
1:36

We can finally say it! is launching today! We spent a year building the data substrate for the agent economy, one MCP that allows your agents to query the world as a DB, so you can skip the data and focus on building what matters! Cala

Elisenda Bou-Balust

18,688 次观看 • 3 个月前

Here's what happens when you query an Ethereum balance on the Internet Computer: "3 out of 4" consensus mode Responses must match or you get an error Pay in cycles (like gas) - no API keys, no credit cards Add Bitcoin to Ethereum and Solana, and you've got TRUE multi-chain DeFi.
1:30

Here's what happens when you query an Ethereum balance on the Internet Computer: "3 out of 4" consensus mode Responses must match or you get an error Pay in cycles (like gas) - no API keys, no credit cards Add Bitcoin to Ethereum and Solana, and you've got TRUE multi-chain DeFi.

DFINITY Foundation

19,290 次观看 • 9 个月前