SQLite Studio

In order to have quick access to info of interest, it must be stored in a well organized database. Various specialized applications are used to create tables containing only specific field, connected with links so that data is constantly monitored and kept up to date. SQLite Studio is a lightweight utility that allows you to create and manage custom databases.

Upon opening the application, you can choose to import a SQL or CSV file to be edited and saved under the same format, or create new content from scratch. The main workspace is split into three tabs, two of which are dedicated to browsing throughout the database as well as the data itself.

Creating a table inevitably requires you to fill in several fields, excluding content. A name should be given, the type of data it stores, which can range from text to blob and null, as well as setting the default value or additional comments.

Records can easily be added from a different tab, clicking on a single button brings up an empty field which you can fill with precious data. Remember to save often though, because if you want to sort by a specific field, records are immediately deleted.

Another available function the application puts at your disposal is to create a new index. This can be done for every table in your database almost instantly. You simply need to select to which field it is applied, order and whether it allows duplicates or not.

When you finish storing your info, you can choose to export your work in one of the two types that might suit you best. The whole database can be exported as an SQL file or just a table as CSV.

To sum it up, SQLite Studio is a handy utility to quickly create and manage a database. The user friendly interface allows you to accommodate fast and everything is kept as simple as possible so you don't get lost in details. Either modify an existing database or create a new one, this application makes it look easy.