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

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

На главную

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

googledevs's profile picture

Google for Developers

2,573,576 subscribers

11,376 просмотров • 8 месяцев назад •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 0

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

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

This SQL query looks completely reasonable. It filters out banned and inactive users. Yet the result might catch you off guard. What does it actually return?
0:31

This SQL query looks completely reasonable. It filters out banned and inactive users. Yet the result might catch you off guard. What does it actually return?

Google for Developers

10,023 просмотров • 8 месяцев назад

🤯🤯 That's insane! Hugging Face just shipped Data Studio on dataset pages... Ask a question about any dataset, the agent writes and runs a SQL query... then share the result or download as CSV... check it out! 👀 ⤵️ Wow GG Caleb 👏
0:25

🤯🤯 That's insane! Hugging Face just shipped Data Studio on dataset pages... Ask a question about any dataset, the agent writes and runs a SQL query... then share the result or download as CSV... check it out! 👀 ⤵️ Wow GG Caleb 👏

Jeff Boudier 🤗

19,703 просмотров • 1 год назад

This is a tool that used GPT that lets you connect to PostgresDB or MongoDB, lets users type in questions, and it generates the query code (even advanced table joins), runs the code and returns the answer instantly. Like a query co-pilot. Here are my thoughts 👇🏻
0:23

This is a tool that used GPT that lets you connect to PostgresDB or MongoDB, lets users type in questions, and it generates the query code (even advanced table joins), runs the code and returns the answer instantly. Like a query co-pilot. Here are my thoughts 👇🏻

Duy

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

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
5:48

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results

Alex Xu

23,200 просмотров • 2 месяцев назад

If this is wrong, why doesn’t it feel wrong?
1:00

If this is wrong, why doesn’t it feel wrong?

Doctor jii…

46,786 просмотров • 9 месяцев назад

Another insane Jev use case! Traditional database filters need precise, predefined conditions. But many questions are semantic: - Is this article mainly about software engineering? - Which topic best describes it? - How technically deep does it appear? These usually require moving rows into application code, invoking a model, parsing its output, and writing the result back. pg-jev is an open-source Postgres extension that exposes Jev through SQL functions. - jev() works inside WHERE - jev_prob() returns a probability - jev_choice() selects a label - jev_score() ranks rows across ordered levels. It needs no vector column or embedding index. Under the hood, pg-jev batches rows, sends them to Jev, and returns typed answers that SQL can filter, sort, group, and combine with exact predicates. The recording below runs it against real Hacker News stories stored in Postgres. It first shows the rows, then asks Jev to find software-engineering stories, classify them by topic, and rank them by technical depth. The final query reports requests, tokens, cost, and cache hits from the database session. GitHub repo: (don't forget to star it ⭐) Postgres keeps the data and controls the query, while Jev handles the part SQL cannot express as a deterministic condition. If you want to understand what Jev is doing under the hood, I also wrote a hands-on guide to building a Jev-style model with open models, entirely locally. Read it below.
0:28

Another insane Jev use case! Traditional database filters need precise, predefined conditions. But many questions are semantic: - Is this article mainly about software engineering? - Which topic best describes it? - How technically deep does it appear? These usually require moving rows into application code, invoking a model, parsing its output, and writing the result back. pg-jev is an open-source Postgres extension that exposes Jev through SQL functions. - jev() works inside WHERE - jev_prob() returns a probability - jev_choice() selects a label - jev_score() ranks rows across ordered levels. It needs no vector column or embedding index. Under the hood, pg-jev batches rows, sends them to Jev, and returns typed answers that SQL can filter, sort, group, and combine with exact predicates. The recording below runs it against real Hacker News stories stored in Postgres. It first shows the rows, then asks Jev to find software-engineering stories, classify them by topic, and rank them by technical depth. The final query reports requests, tokens, cost, and cache hits from the database session. GitHub repo: (don't forget to star it ⭐) Postgres keeps the data and controls the query, while Jev handles the part SQL cannot express as a deterministic condition. If you want to understand what Jev is doing under the hood, I also wrote a hands-on guide to building a Jev-style model with open models, entirely locally. Read it below.

Avi Chawla

299,377 просмотров • 20 дней назад

This is the most overvalued the stock market has been in modern history. And retail is still buying like nothing is wrong. We have seen this exact shape before: → Dot-com → Housing → AI Every one topped quietly while everyone was still bullish, then broke. The S&P is already tracing it, and SpaceX is the last liquidity event before it goes. When it breaks, the money does not vanish. It looks for the exit. Watch where it runs.
0:20

This is the most overvalued the stock market has been in modern history. And retail is still buying like nothing is wrong. We have seen this exact shape before: → Dot-com → Housing → AI Every one topped quietly while everyone was still bullish, then broke. The S&P is already tracing it, and SpaceX is the last liquidity event before it goes. When it breaks, the money does not vanish. It looks for the exit. Watch where it runs.

Mister Crypto

23,476 просмотров • 3 месяцев назад

If Kyle was mad about the lesbian comment, she should have said something at the moment instead of laughing it off. This is why she comes across as so fake and a victim. Why complain about it at the reunion when she could have called Garcelle out? #RHOBH
0:44

If Kyle was mad about the lesbian comment, she should have said something at the moment instead of laughing it off. This is why she comes across as so fake and a victim. Why complain about it at the reunion when she could have called Garcelle out? #RHOBH

Reality Roast

110,895 просмотров • 1 год назад

Looks like it runs in the family 😎
0:20

Looks like it runs in the family 😎

MLBDevelops

103,417 просмотров • 1 год назад

You can now access AI directly from your database! Here is a step-by-step demo that uses GPT-4 to classify customer reviews from a MySQL dataset. And I'm only writing SQL instructions! You have to see it! The model acts as another table in the database. I can query it and join it with other tables. It's awesome! This is all thanks to mindshub. Here is their GitHub repository: They are sponsoring this post. Watch the video.
6:49

You can now access AI directly from your database! Here is a step-by-step demo that uses GPT-4 to classify customer reviews from a MySQL dataset. And I'm only writing SQL instructions! You have to see it! The model acts as another table in the database. I can query it and join it with other tables. It's awesome! This is all thanks to mindshub. Here is their GitHub repository: They are sponsoring this post. Watch the video.

Santiago

209,454 просмотров • 2 лет назад

Why doesn’t anyone hide the alarm keypad like this?Cut the wall. Reinforce it. Mud. Paint. Stick the keypad inside.From the hallway it looks like… nothing. Clean wall. Hidden system.Would you do this in your house?
0:59

Why doesn’t anyone hide the alarm keypad like this?Cut the wall. Reinforce it. Mud. Paint. Stick the keypad inside.From the hallway it looks like… nothing. Clean wall. Hidden system.Would you do this in your house?

Amelia

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

A DEVELOPER FOUND SEVEN WAYS TO TAKE DOWN A PRODUCTION DATABASE THAT ALL LOOK EXACTLY LIKE NORMAL, INNOCENT CODE AND ALMOST EVERY TEAM IS SHIPPING AT LEAST ONE OF THEM RIGHT NOW 17 minutes from Josh Berkus, one of the people who actually maintains PostgreSQL, walking through the quiet mistakes that turn a healthy database into a 3am outage. -> The moment it lands, you realize none of these are exotic attacks. They're ordinary-looking decisions -- a query that locks a table, a connection that never closes, a setting no one ever questioned -- that work perfectly until the day they don't, and then they take everything down with them. The scary part isn't that the database breaks. It's how normal the code looks right up until it does. A query that runs in 5ms on your laptop and 5 minutes on prod. A migration that silently locks the whole table. A connection pool that runs dry the moment real traffic shows up. Every one of them passed review. Writing SQL that runs was never the hard part -> writing SQL that survives production is. And now that an AI agent is generating and firing queries at your real database faster than anyone can read them, every one of those seven landmines is one autocomplete away -- and the only person who can stop it is the one who already knows where they're buried. Your database doesn't go down because someone attacked it. It goes down because something that looked completely normal finally caught up with it. Save and Watch it today. You'll see the next outage coming before it lands ↓
16:51

A DEVELOPER FOUND SEVEN WAYS TO TAKE DOWN A PRODUCTION DATABASE THAT ALL LOOK EXACTLY LIKE NORMAL, INNOCENT CODE AND ALMOST EVERY TEAM IS SHIPPING AT LEAST ONE OF THEM RIGHT NOW 17 minutes from Josh Berkus, one of the people who actually maintains PostgreSQL, walking through the quiet mistakes that turn a healthy database into a 3am outage. -> The moment it lands, you realize none of these are exotic attacks. They're ordinary-looking decisions -- a query that locks a table, a connection that never closes, a setting no one ever questioned -- that work perfectly until the day they don't, and then they take everything down with them. The scary part isn't that the database breaks. It's how normal the code looks right up until it does. A query that runs in 5ms on your laptop and 5 minutes on prod. A migration that silently locks the whole table. A connection pool that runs dry the moment real traffic shows up. Every one of them passed review. Writing SQL that runs was never the hard part -> writing SQL that survives production is. And now that an AI agent is generating and firing queries at your real database faster than anyone can read them, every one of those seven landmines is one autocomplete away -- and the only person who can stop it is the one who already knows where they're buried. Your database doesn't go down because someone attacked it. It goes down because something that looked completely normal finally caught up with it. Save and Watch it today. You'll see the next outage coming before it lands ↓

slash1s

22,268 просмотров • 4 месяцев назад

This hook is SO good for promoting apps: “when did this come out?? 😭” Impressed / shocked reaction → Snapchat style text → “why did this come out??” → immediately showcase the app → show the result on screen It doesn’t feel like an ad. It feels like you just discovered something way too good and had to share it. Curiosity + reaction + proof = a very strong app creative.
0:28

This hook is SO good for promoting apps: “when did this come out?? 😭” Impressed / shocked reaction → Snapchat style text → “why did this come out??” → immediately showcase the app → show the result on screen It doesn’t feel like an ad. It feels like you just discovered something way too good and had to share it. Curiosity + reaction + proof = a very strong app creative.

Penelope Lopez

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

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -
0:27

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -

Bindu Reddy

50,569 просмотров • 2 лет назад

At first, it looks like Jinyoung is crying, but then it turns out that he changed into the wrong pants and wants to change back. Why is this man so funny?
0:33

At first, it looks like Jinyoung is crying, but then it turns out that he changed into the wrong pants and wants to change back. Why is this man so funny?

Lavina

57,577 просмотров • 1 год назад

The Global American Cultural Victory doesn’t look like people wearing blue jeans and listening to rock and roll. It looks like this:
0:30

The Global American Cultural Victory doesn’t look like people wearing blue jeans and listening to rock and roll. It looks like this:

RAY

390,880 просмотров • 4 месяцев назад

this whole video ❤️‍🩹 jimin was talking to armys and as soon as he noticed something was wrong he immediately stopped the concert 🐥 it looks like someone has fallen over there 🐥 something's wrong over there 🐥 please take care of it quickly
0:42

this whole video ❤️‍🩹 jimin was talking to armys and as soon as he noticed something was wrong he immediately stopped the concert 🐥 it looks like someone has fallen over there 🐥 something's wrong over there 🐥 please take care of it quickly

j.mt

1,125,616 просмотров • 3 месяцев назад

The way to cut bangs like this looks so easy and the result is really good, so I want to try it 😍
0:40

The way to cut bangs like this looks so easy and the result is really good, so I want to try it 😍

monic

800,571 просмотров • 3 месяцев назад