refactor(*): use latest sqlite.lua api + general refactor

[kkharji]

Changes:

• Use sql.nvim new api to make data layer more readable.
• Move some files out telescope/_extentions/
• Create algo.lua: to be the place to store calculation or algorithms (idk feels wrong now)
• general refactoring

FIX:

• 30:

  There shouldn't be any database initialization before the first picker call or buffer write. @clason can you please give it a test. I think win enter autocmd might still initialize the db.

TODO:

• [x] fix picker results not showing right.
• [x] fix possible issue with some entries having id but not count.
• [ ] make validate run on setup and with db.update if auto_validate is enabled.
• [ ] do more testing with @sunjon.
• [ ] remove all todos and fixme with @sunjon

[kkharji]

db.db.uri = db.config.db_root and db.config.db_root or db.db.uri should be db.db.uri = db.config.db_root and db.config.db_root .. "default_name" or db.db.uri

[kkharji]

since @sunjon doesn't seem to have time or interest to review this, I'm closing it.

[clason]

@tami5 that's a pity, I was looking forward to it... Would you reconsider?

[kkharji]

Hey @clason, sorry about that, yes, let me restore for now and try to find time later to go into it. What's missing I believe is some testing to confirm everything works and the manual merge of new changes.

[delphinus]

@kkharji @Conni2461

I'm writing refactor-again branch (#93) to merge this into master. Can I take over this branch?

[kkharji]

@delphinus 😍 please do. I really was too occupied to attend this. Thank you.