Загрузка видео...

Не удалось загрузить видео

На главную

🆕 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,928 subscribers

94,182 просмотров • 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. 😅

Похожие видео

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 просмотров • 5 месяцев назад

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 лет назад

"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

128,059 просмотров • 1 месяц назад

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 просмотров • 8 месяцев назад

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,516 просмотров • 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 просмотров • 3 месяцев назад

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 просмотров • 2 месяцев назад

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 месяцев назад

🆕 Introducing PDFGen - Dynamic PDF Generation for your app. With PDFGen, you can create an HTML template, send data to our API, and get a PDF back. Includes Tailwind out-of-the-box for styling Would you give it a try and let me know what you think? 🙏
4:17

🆕 Introducing PDFGen - Dynamic PDF Generation for your app. With PDFGen, you can create an HTML template, send data to our API, and get a PDF back. Includes Tailwind out-of-the-box for styling Would you give it a try and let me know what you think? 🙏

Ryan Chenkie

201,605 просмотров • 3 лет назад