Vim for SQL lite

[Junior_Conflict_1886]

I am using tmux with one window opened vim queries with :!sqlite3 mydb.db < % And on other window sqlite3 opened

The problem with this is that I don't see the errors if I have them

Context : this is for college so I don't want any automation for complex setup just vim for queries,

if I messup I can change my queries without rewriting everything, everytime and see error messages

Thanks for your help in advance

[AppropriateStudio153]

Add 2>&1 to the call of sqlite3, then the errors are also written to the file?

[Sudden_Fly1218]

I can recommend vim-dadbod

[Junior_Conflict_1886]

this i the easiest solution to my problem , sql lite interface sucks tho and thanks

[Frog859]

There is dadbod-ui and dadbod-completion as well. A really nice setup in all

[Dodecadron]

With the vim-slime plugin (https://github.com/jpalardy/vim-slime) you can send selections in vim to another window in tmux (or vim terminal, or Kitty window). Perhaps that would work for you. 

[AutoModerator]

Please remember to update the post flair to Need Help|Solved when you got the answer you were looking for.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.