This article introduces DB Browser for SQLite, an SQLite file editor that can view and edit the contents of SQLite3 databases.
For SQLite viewers, DB Browser for SQLite is recommended.
- You can launch multiple instances, so you can view multiple SQLite files simultaneously
- You can easily copy and paste SQL create commands that create tables: database structures > tables > [table name] > right-click > copy create statements *1
- Useful for checking Rails database updates, etc.