Re:Instant SQL for results as you type in DuckDB UI
by pests on Friday April 25, 2025 @02:22AM
(#43790701)
I don’t want to type any column names. When you start with FROM the only autocomplete suggestions available are the columns from the specific table, not the entire database. How many columns do I need to type before you can single down a single table? What if you have multiple tables with the same column names?
[ Parent
| on HN ]
Re:Instant SQL for results as you type in DuckDB UI
by ltbarcly3 on Friday April 25, 2025 @08:16AM
(#43792780)
This is extremely easy to check. It depends on the schema.
If your tables have very heterogeneous column names, like 1 column will identify any table on average. There will be some duplicates but the median columns will be one or two.
If your database has very homogenous column names you don't need to identify a single table for autocomplete to be very precise.