search

dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.12k stars 68 forks source link

hot reload #76

Open zachvalenta opened 4 years ago

zachvalenta commented 4 years ago

I'm iterating on a schema design and frequently dropping all tables and then recreating, but to see my changes reflected I need to keep running .open <db_file>. Be cool if litecli could keep track of this.

amjith commented 4 years ago

I'm surprised that the changes aren't reflected immediately. We do refresh the completion on any of the DDL statements such as CREATE, DROP, ALTER etc.

I just tried creating a table and I was able to see the new table in the completion list in the very next statement. So I'm not sure what's going on.

Can you give me an example statement that you're using?

zachvalenta commented 4 years ago

I start w/ 2 records Screen Shot 2019-12-01 at 6 44 26 PM

I make a POST to create a few more, but litecli reads old data Screen Shot 2019-12-01 at 6 44 41 PM

until I reload w/ .open local.db Screen Shot 2019-12-01 at 6 45 05 PM