Menu
I've been using SQLite databases for development for a while now and I thought it would be useful to just view the contents of the generated db file. Are there any good tools out there for viewing SQLite db files and/or tools for running queries against them?
737
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
To show all databases in the current connection, you use the . databases command. The . databases command displays at least one database with the name: main .
Here are a few free tools:
I prefer SQLite Administrator, and occasionally use the Firefox version. There are other commercial options too.
124
SQLite Database Browser.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
