Loading video...

Video Failed to Load

Go Home

instant-feedback SQL editing aka "query-as-you-type" uses DuckDB's AST, duckdb-wasm for local-first caching, and MotherDuck as the backend Still early, but should enable arbitrary scale and still retain a near real-time feel while writing ad hoc queries! Bye bye run button 👋

58,215 views • 2 years ago •via X (Twitter)

11 Comments

Hamilton Ulmer's profile picture
Hamilton Ulmer2 years ago

an interesting consequence of this instant-feedback SQL feature is when the LLM-powered inline codegen suggests an edit, you instantly see that edit's effect on the result set enabling you to instantly verify if it works as expected.

Taro L. Saito's profile picture
Taro L. Saito2 years ago

That's an exciting approach for interactive query editing. I'm exploring a similar direction based on DuckDB

Hamilton Ulmer's profile picture
Hamilton Ulmer2 years ago

wvlet is very cool! Thanks for sharing

William Wolf's profile picture
William Wolf2 years ago

So sexy

Hamilton Ulmer's profile picture
Hamilton Ulmer2 years ago

first time anyone has used that word for sql

jeff's profile picture
jeff2 years ago

very cool

Hamilton Ulmer's profile picture
Hamilton Ulmer2 years ago

Thanks Jeff!

harry_wood's profile picture
harry_wood2 years ago

Hope it doesn't run DELETE queries before you've finished typing 😆

Mats's profile picture
Mats2 years ago

@bantg This is guuud

archie 🦋's profile picture
archie 🦋2 years ago

ugh i need to start writing duckdb `from` first

Hamilton Ulmer's profile picture
Hamilton Ulmer2 years ago

you know, you actually don't have to in this case, but it'd obviously be much better for your QOL!

Related Videos

Dear Friend, I wrote this book for you. For the past year, I have labored to create a product that will help you learn and master SQL. I have been there. I have felt the frustration of trying to learn SQL and not knowing where to begin. I have lived through the struggle of setting up a platform to run SQL queries. Most platforms require sign-ups and logins that create a headache for learners. I also know the challenge of finding proper SQL exercises that mirror the real-world experience of a data analyst. Yes, I have been in your shoes. That’s why I created SQL Essentials for Data Analysis: A 50-Day Hands-on Challenge Book (Go From Beginner to Pro). Yes, to give you a clear, practical path from beginner to confident SQL user. ✅Why SQL Still Matters You may be wondering if SQL still matters in 2025. The answer: it has never mattered more. SQL is the lingua franca of data. Data still lives in databases, and the only language it truly understands is SQL. Think about it, even in Python, SQL is there. You’ve probably heard about the powerful pandas library. Guess what? It also has some SQL. And don’t get me started on BigQuery, Tableau, Power BI, and Databricks; the answer is the same: they all rely on SQL. SQL is the big shadow that hovers over everything data. This is why learning SQL is a must for data analysts, engineers, scientists, and anyone working with data. SQL connects everything: exploration, extraction, transformation, modeling, validation, and reporting. ✅Why I Wrote This Book Dear friend, I wanted to create a resource that gives you everything you need to learn SQL for data analysis. Quite often, resources are scattered across different places. You might learn theory in one place, search for datasets in another, and hunt for questions somewhere else. More often than not, the only place you can tackle SQL challenges is online. But online platforms usually focus on syntax and don’t reflect the messiness of real-world data. I wrote this book to give you the best of both worlds: theory and practice. I don’t want you to be worrying about where to find resources. I want you to focus only on learning SQL. If you are new to SQL or need a refresher on the fundamentals, Part 1 of the book has you covered. If you are looking for practice, Part 2 is 49 days of hands-on SQL challenges designed to mirror real-world tasks. Each day in the book is designed to feel like a mini project, rather than isolated exercises. Take Day 15: Standardize Climbers Data, for example: On this day, you’re not just writing a single query; you’re working with a dataset from start to finish. By combining these tasks, you experience a full data preprocessing workflow, just like a real project. You get to practice loading, transforming, cleaning, and validating data, all in one challenge. This approach makes every day a hands-on project, not just an isolated query. You’re learning how SQL is used in real-world scenarios, not just memorizing syntax. By the end of each day, you’ve solved a problem that feels meaningful and practical: yes, something that mirrors data analysts’ and engineers’ work in real life. In this book I use SQLite. I chose SQLite because it’s simple, lightweight, and runs on any system without complicated setups or cloud accounts. You don’t need to worry about complex configurations. SQLite allows you to focus entirely on learning SQL concepts, queries, and logic without distractions. You will just have to import it. I also structured the book for use in Jupyter or Google Colab notebooks. These are playgrounds for data analysts, engineers, and scientists. These environments are interactive and flexible. They let you run queries, visualize results, and experiment in real time. Using notebooks ensures that you can practice SQL while documenting your work and learning at your own pace, all in one place. No need for sign-ups. ✅Why 50 Days? I chose 50 days intentionally. Learning SQL isn’t a sprint; it’s a habit. You can’t truly master a language by cramming a few queries in one sitting. 50 days creates a commitment. You attach yourself to a goal, a tangible outcome. Every day is a small win, a step forward, and by the end of the journey, you’ve transformed your understanding of SQL. By spreading the learning over 50 days, you build momentum, consistency, and confidence. Think of it like training for a marathon. You don’t run 26 miles on the first day. You run a little each day, gradually building strength, endurance, and skill. By the end of the 50 days, you’ll have tackled a wide range of SQL tasks: from simple filtering to window functions, date operations, joins, and performance tuning. You’ll have not just learned SQL but truly internalized it. The goal isn’t to overwhelm you. It’s to give you a structured, achievable path that fits into your daily routine, so learning SQL becomes natural, steady, and rewarding. Even if you don’t finish within 50 days, the 50-day structure gives you a rhythm, a habit, and a sense of accomplishment. The kind of outcome that sticks long after the book is finished. In summary, I wrote the book to address these pain points: 🔶Not knowing where to start: The book gives you a clear roadmap that guides you day by day. 🔶Too much theory, not enough practice: Reading about SQL is not the same as doing SQL. This book includes hands-on challenges that mirror real-world scenarios, so you’re not just memorizing commands; you’re learning to think like a data analyst. 🔶Complex setup: Many learners get stuck setting up databases or configuring environments. You will not worry about complex setups; everything runs in SQLite3 inside Jupyter Notebook, so you start immediately. 🔶Disconnected learning: The challenges mirror real-world analytics problems. Every day here is like a mini project, giving you the experience of exploring, cleaning, transforming, and analyzing data ✅What I ask of You I wrote this book for you because I want you to succeed, but books alone don’t create mastery; your effort does. I have provided the tools. All I ask is that you show up every day. Even if it’s just 20–30 minutes, take the challenge seriously. Tackle the problems, experiment with your queries, make mistakes, and fix them. That’s how real learning happens. I also ask that you trust the process. The book is designed to guide you from beginner to confident SQL user, step by step. Some days will feel "easy" and others "hard." Stay the course, and by the end, you’ll see how all the pieces fit together. Finally, I ask that you bring curiosity and persistence. SQL is a language of logic and structure, but it’s also a language of insight. The more you explore, the more patterns you’ll discover, and the more confident you’ll become in solving real-world problems. Don’t be scared to experiment. If you commit to this, I promise you’ll finish 50 days with more than just knowledge. You’ll have the skills, confidence, and habit of thinking like a data analyst. To make starting even easier, as a subscriber to this newsletter, I’m giving you an exclusive 35% launch discount. You can grab your copy today and start the 50-day journey at a reduced price. Grab SQL Essentials for Data Analysis here: I can’t wait to hear about your progress, the insights you uncover, and the confidence you gain along the way. If you have any questions, feel free to reach out to me or post them in the comments section. Let’s start this journey together: one challenge, one query, one day at a time. Warmly, Benjamin PS. Please repost.

Benjamin Bennett Alexander

18,584 views • 10 months ago

🚀 GeoLibre just passed 5,000 stars on GitHub, in only two months! GeoLibre went public on May 27, and the community has already pushed it past 5,100 stars and 500+ forks. Thank you to everyone who starred, forked, filed issues, opened pull requests, and shared the project. For those just discovering it: GeoLibre is a free and open-source, lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. It runs everywhere you do, in the web browser, on the desktop, on mobile, and inside Jupyter notebooks, all while keeping your data local and private. Key features of GeoLibre: - Runs anywhere: the same app ships as a native desktop app, a browser web app, a native Android app, and a Jupyter widget. - Local and private by default: load and analyze GeoJSON, GeoParquet, GeoPackage, Shapefile, COG, LiDAR, 3D Tiles, and more, right in the browser. - Powered by open source: built on MapLibre GL JS, DuckDB-WASM Spatial, Tauri, React, and TypeScript. - Spatial SQL in the browser: query your data with DuckDB Spatial, PostGIS via PGlite, and Apache Sedona. - Extensible: a growing plugin system for cloud data, federal web services, and custom tools. - Supports 12 planetary basemaps: Earth, Mars, the Moon, Mercury, Venus, and more. Two months in, we have already shipped 25 releases, the latest being v2.4.0. There is a lot more to come, and the best way to shape it is to jump in. Try it out - Launch GeoLibre Web: - GitHub: - Documentation: - Release notes: If GeoLibre is useful to you, a star on GitHub and a share here go a long way. Thank you for an incredible first two months. #geospatial #opensource #MapLibre #GeoLibre

Qiusheng Wu

94,705 views • 1 month ago