SQLite Database Installation Process and Features

Before you start overwhelming yourself with various database solutions and SQL command lines. you need to detemtine first your purpose why you are creating a database. This will further determine other database design considerations such as size, complexity, type of machine where the application will run, storage medium and more. When you start thinking of your database requirements, you need to know up to what level of detail should be considered in your design. Too much detail will result to a very complex design that further wastes time and effort and even your computer‘s storage space. Too little will lead to a poor performing conupt and worthless database. Once you are done with the design phase, then you can decide which database software you can download to start your SQL experience

SQLite Database

SQLite is a simple software library, will be used as a starter database engine to design, build and deploy applications. A free and stand-alone database software that is quick to download and easy to administer. SQLite was developed by Richard Hipp and his team of programmers. It is was designed so that it can be easily configured and implemented, which does not require any client-sen er setup at all. Thus, SQLite is considered as one of the most widely used database software applications in the world.

SQLite Database Features

Stated below are some of the major features of SQLite:

1. Transactions are atomic. consistent. isolated and durable


2. Compilation is simple and easy


3. System crashes and power failures are supported


4. Full SQL implementation with a stand-alone command-line interface client


5. Code footprint is significantly small


6. Adaptable and adjustable to larger projects


7. Self-contained with no external dependencies


8. Portable and supports other platforms like Windows. Android. iOS. Mac. Solaris and more

In using SQLite, you need to download SQLiteSIudio as your database manager and editor. With its intuitive interface, this software is very light yet fast and powerful. You don’t even need to install it, just download, unpack and run the application. Follow these simple steps in downloading SQLiteStudio on a Windows 10 computer:

1. Go to http://sglitestudio.pl/?act=about


2. Check the version of your computer’s operating system then click the appropriate link to start downloading the software.


3. After downloading the software, go to the folder where the application was saved (usually the Downloads Folder in Windows). Click on the Extract tab on top then choose the Extract all option.


4. You will get the Extract Compressed (Zipped) Folders dialog box. Change the destination folder to C:\SQL then click the Extract button. This will be the folder where all your SQLite files will be saved.


5. Once all the files have been extracted, you will have the SQLiteStudio subfolder.


6. Find the application program named SQLiteStudio inside the subfolder. To create a shortcut on your desktop (so you can quickly launch the application), right-click the filename, select Send to option then choose Desktop (create Shortcut).


7. Now Double click on SQLiteStudio and Enters to the SQLiteStudio Home screen.

The Database Navigator (left pane) shows all the logical units of the database such as tables and views. The gray pane at the right is the SQL Work Area where you will write your query statements. You will have a better understanding of this program’s graphical user interface in the succeeding chapters.
In this chapter you have learnt the fundamental features of the SQL database language, which includes program flow, syntax characteristic, reserved words list, schema, domain, constraint and more. The main categories of SQL commands were also introduced, that govern the various functions of the programming language. You were also given a guide on how to download and install SQLite and SQLiteStudio for your application software. In the next chapter you will learn the definition of data and its various types supported by the different SQL implementations.