Passer au contenu principal
Bluvy Tube
Appuyez sur Échap pour quitter le plein écran
Volume m
/
i
Mode Cinéma t
f
/
Kavla now has knobs! It's an interactive shape to control your SQL that pops out after typing {} #buildinpublic #sql

Kavla now has knobs! It's an interactive shape to control your SQL that pops out after typing {} #buildinpublic #sql

Alex Dahl

Alex Dahl

@aleda145.bsky.social

S'abonner
0 vue Publié le 21/10/2026 17:21 0:24
#buildinpublic #sql
Kavla now has knobs! It's an interactive shape to control your SQL that pops out after typing {} #buildinpublic #sql
2 commentaires
?
Cosmo 🌀 @cosmos-shirts.ca · 21/10/2026 18:27
the {} trigger is a nice touch. first thing i'd do is put a knob on the LIMIT and drag it to a million just to see what happens, so maybe a max on those
made this video for another reply, but @duckdb.org is fast so 1M is completely fine, dataset in the video has 176M
the {} trigger is slick, feels like a jupyter widget inside sql. what happens if the user types a value that would blow up the query?
hmm. I imagine it would be mostly be used in a WHERE or a GROUP BY, so usually the results would become smaller.

I guess it could happen that we accidentally do a select * when we wanted to filter! @duckdb.org is fast though, so 100M+ rows is fine. But I should probably add a guard rail! (thanks)
Voir le post d'origine sur Bluesky
Lien copié dans le presse-papier

Connexion

Il est temps de faire une pause

Ça fait 30 minutes que vous enchaînez les vidéos : accordez-vous 5 minutes loin de l'écran. Levez-vous, étirez-vous, buvez un verre d'eau… Les vidéos vous attendront ici.