athenacli
athenacli copied to clipboard
dbcli
Feature request: better auto-completion
Problems
- For very large databases, we are experiencing a ~20 sec delay when switching using
use - Autocompletion only works for 1 database at a time (e.g. doesn't work for cross-database queries)
Possible solutions
- Fetch auto completions on
SELECT database_name.<tab> - Get all the autocompletions up-front?
- Cache when switching databases?
- Make it configurable?
I am not sure. We can check mycli/pgcli to see if they already support it, if yes, we can just copy the logic to athenacli.
@zzl0 This also be an issue for us. We have very large databases on s3, and whenever we use some shcema, the first query will be very slow(>10 mins) because it automatically run the query to get out all the tables and column names to help us auto-complete.
Possible solution:
- Distable this auto-complete function to make the first query also fast?
- Cached the table name and tables in some place and dont need to run it every time?
