Start SQLiteStudio from the menu in the upper left corner. When SQLiteStudio has started, choose Add a database from Database Menu. Click the green circle with +-sign. SQL (Structured Query Language) is a programming language for interacting with data in a relational database. There are different implementations of SQL—one implementation is SQLite. SQLiteStudio is a SQLite database manager with the following features: single executable file no need to install or uninstall, intuitive interface, all SQLite3 and SQLite2 features wrapped within. SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views. SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.SQLite is the most used database engine in the world.

These are brief instructions how to use SQLiteStudio in Aalto IT Linux computers. For more detailed instructions, see http://wiki.sqlitestudio.pl/index.php/User_Manual. You can also download SQLiteStudioto your own computer from page http://sqlitestudio.pl/?act=download.

Sqlitestudio Tool

Creating the example database

• Download the file exampledatabase.sql (MyCourses/Exercises/Exercise Round 2)to your computer.
• Start SQLiteStudio from the menu in the upper left corner.

• When SQLiteStudio has started, choose Add a database from Database Menu.

• Click the green circle with +-sign.

• Choose the directory where you want to save your database and write thename of the database file in the Name field (you can decide the name yourself, but it is common to use the suffix .db for SQLite database files). Push theSave button.

• Push OK button.

• Open the SQL editor.

• Double-click the name of the database on the left and after that choosethe database from the drop down combo box up.

• Press the Load SQL from file icon and open the file exampledatabase.sql.

• The contents of the file should appear in the upper part of the window.

• Select all SQL statements in the upper part of the window with the mouseand press the green Execute query arrow. This executes the sql queries in the window. After that, theexample database is ready. (According to the SQLiteStudio user manual, it should be not necessary to select the statements before pressing the execute button. However,the lecturer has noticed that in practice not selecting all the statements may leadto the situation where only one of the statements is executed.)

• Either clear the query tab or open the SQL editor again. After that, you can start writing your own queries. You can also read queries which you have saved to a file using the Load SQL from file icon and save your queries to a file by using the Save SQL to file icon.

Using existing database

Sqlitestudio Csv

• If you have created the database in SQLiteStudio before, just openthe SQL editor and choosethe database you want to use from the drop down combo box. After that,you can write and execute your queries.

Sqlitestudio Download

Sqlitestudio

If something goes wrong

Sqlitestudio Ubuntu

• If something goes terribly wrong and your database is a total mess, theeasiest they to recover may be to delete your database and create it againfrom the beginning.
• You can delete the database by clicking the name of the databasein the list left and selecting Database->Remove the database (this does not delete the databasefile, but it removes the database from SQLiteStudio).
• You can also delete a single table by clicking its name and selectingStructure->Delete the table. Alternatively, you can writeDROP TABLE xxx (where xxx is the name of the table to bedeleted) in the SQL editor and push Execute query arrow.