Title: Introduction to Graphical User Interfaces Tools for SQLite
Duration: 16:50 min.
Summary: There are many tools that can be used to administer a SQLite database file. This video presents a brief introduction to two graphical user interfaces tools that can be used to administer a SQLite database file on the Ubuntu Linux: the SQLite Database Browser and the SQLite Manager. The first tool, SQLite Database, is an open source tool used to perform few tasks, such as create, alter and drop tables, triggers, views and indexes and send SQL commands through a GUI interface. Furthermore, the video show a tool called SQLite Manager, which is a free add-on for the Firefox Web Browser. The SQLite Manager contains all the options of the SQLite Database Browser and more, allowing the DBA to control better the database file. This tool have options to change the main settings of the database and also to manage the files by attaching, copying, compressing and other operations. Also, SQLite Manager have a interface that helps the user find the rows that are needed, avoiding the construction of complex SELECT statements. However, if the user wants he can execute any SQL commands that a SQLite database accepts directly on the SQLite Manager.
Technologies : SQLite, SSH, Linux
Examples: How to create a table in a SQLite datbase file, add records and export the database structure and data to a text file that contains SQL commands.
Keywords: SQL, SQLite, SSH, Linux.