Installing DB Browser

DB Browser has packages available for each operating system on the right panel of theDB Browser website. Follow along with this video for installation instructions:

After following the installation process, open up the software and you will presented with an interface for opening or creating a new database.

Using DB Browser to Create a New Table

Steps: Creating a new database with DB Browser will open aFiledialog box, where you can set where the SQLite database will live in your file structure. After creating a db, you will be presented with an interface for creating a table. Add a name for the table at the top, and then add and remove fields in theFieldswindow. Each field has a free-text name, a dropdown for its type, and four checkboxes for not-null, primary key, autoincrement, and unique attributes, as well as other parameters. You will see the SQL query that DB Browser executes to create this table update as you add information to this table. Update these and press “OK”. You will see the Database Structure tab of DB Browser refresh with the updated information. Note that no changes have been made to any database file yet, and queries are only executed by DB Browser when the “Write Changes” button is pressed. Press the “Write Changes” button and create your table.

Adding Data to a SQLite Table Using DB Browser

Steps: Switch from the Database Structure tab to the Browse Data tab. You can add a row to the table with the New Record button. Click it, and update the columns in the viewport as you would a spreadsheet. Remember that no data will be inserted into the SQLite database until the “Write Changes” button is pressed. Press that button and you will have successfully added a row to your table.

Conclusion

You’ve installed DB Browser and used it to perform SQL tasks visually. You can now use DB Browser to visualize whatSQL commandswill accomplish without worrying about affecting the state of your database. Verify these commands do what you want, and press “Write Changes” to commit to them. Congratulations! You’re ready to manage a database.

'The Codecademy Team, composed of experienced educators and tech experts, is dedicated to making tech skills accessible to all. We empower learners worldwide with expert-reviewed content that develops and enhances the technical skills needed to advance and succeed in their careers.'