TODO

[Paxa]

Show loader for long running operations

• query in query runner
• export db
• import db
• add index
• add column

Features:

• able to cancel current running query
• reconnect if connection lost
• windows with query log
• add index for table with many columns (add scrolling)
• copy query output to clipboard
• save query output to csv

[jonpemby]

Hey! I was wondering if there's an updated todo list? Anything a first time contributor can help with?

[Paxa]

Yes, there are few relatively easy things to do:

1. support for temporary tables
   currently it will throw an error. I think it should be shown as a regular table (may be with different icon)
   exception:

Error: Unknown table type: LOCAL TEMPORARY
File "/Applications/Postbird.app/Contents/Resources/app/app/views/db_screen_view.js", line 151, in 
data.(anonymous function).forEach
  throw new Error(`Unknown table type: ${table.table_type}`);
File "/Applications/Postbird.app/Contents/Resources/app/app/views/db_screen_view.js", line 128, in Array.$u.each

2. Create/Rename/Delete schemas
   in table list "Show Schemas" checkbox at bottom

3. Detect default schema from user's search_path, currently it's use public all the time

4. Ability to Open, Edit, and Save a File in Query Editor (Add Ability to Open, Edit, and Save a File in Query Editor #25)

For big and complex staff:

• Add login by url, add initial sql query (such as default timezone, readyonly, etc), ssh tonneling
• Use native tabs (introduced in electron 1.8)
• Migrate more code to async/await
• Task manager for running queries: see queries, kill query
• Dock notification for long running query (if custom query finish when app is not focused then add notification in dock)

[jonpemby]

Awesome, thanks! 👍 😄