News for hackers. Stuff that matters.
Re:Instant SQL for results as you type in DuckDB UI by pixl97 on Thursday April 24, 2025 @12:22PM (#43784543)
It's probably different for duckdb, but from something like Microsoft SQL tossing off these random queries at a database of any size could have some weird performance impacts. For example statistics on columns you don't want them on, unindexed queries with slow performance, temp tables being dumped out to disk, etc.
Re:Instant SQL for results as you type in DuckDB UI by hamilton on Thursday April 24, 2025 @12:31PM (#43784646)
I agree; one thing that is neat about Instant SQL is for many reasons, you can't do this with in any other DBMS. You really need DuckDB's specific architecture and ergonomics.