Skip to content

Instantly share code, notes, and snippets.

@zzl0
Last active September 14, 2018 23:37
Show Gist options
  • Save zzl0/cabb0d9aba453d10fa95eab77ec211d8 to your computer and use it in GitHub Desktop.
Save zzl0/cabb0d9aba453d10fa95eab77ec211d8 to your computer and use it in GitHub Desktop.
  • For instance, if you can run SELECT, UPDATE, CREATE statements that's a good MVP (minimum viable product).
  • Next, see if you get the completion working for the tables that you create during that session. This validates that the completion refresher is working.
  • Next, check if you can do alias completion. Eg: SELECT * FROM table_name AS t WHERE t. should list you all the columns in that table. This validates that you can penetrate through the aliasing and provide the completion.
  • Next, is to tackle the JOIN statements. See if you can alias both the tables in a JOIN statement and the completions can identify the right table and suggest the columns appropriately.
  • Then I'd tackle the special commands.We might not be able to support all of them, but getting a good chunk of it done will make it attractive to hardcore sqlite users.
  • If you've gone through them all, I'd recommend going through the config file and see if you can toggle the various config values and check if that works correctly.
  • Add docs, unit tests, ci, pypi
  • Make it public
    • hacker news
    • inside Amazon
    • hopefully, amazon technical writer can write a blog for it.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment