Andrew Radev

If you edit an sqlite3 database as a file in Vim, you won't normally get anything useful out. If you save this file in your config as `plugin/sqlite3.vim`, you should get table counts and the schema: https://git.sr.ht/~andrewradev/vimfiles/tree/02d1563cbd1cb2819f42b49f066e679c4666260f/item/miniplugins/plugin/sqlite3.vim

Haven't really explored how useful this is, I'm also thinking I might throw the first 5 rows of each table after each `CREATE` block.

#vim #neovim

Jul 21, 2024 at 11:48amWeb
Show threadAndrew RadevJul 21, 2024
Side note: the database in the screenshot is not exactly great, I didn't come up with the schema it. No need to point out that using TEXT for everything is a bad idea and that I might want to have some primary keys...
Show threadVysogotaJul 21, 2024

@AndrewRadev

> If you edit an sqlite3 database as a file in Vim, you won't normally get anything useful out

Hey, wdym won't get anything useful... That's exacly how I edit my sqlite DBs... 

Show threadAndrew RadevJul 21, 2024

@petko

> you won't **normally** get anything useful out

I think you might be an outlier

Show threadEli the BeardedJul 23, 2024
@AndrewRadev
That RO at the bottom makes me think you are viewing things, not editing them.