Tuesday, February 3, 2015

SQLite3 Review – Great for Beginners and Those Learning SQL

Essentialsql.com SQLite3 is a compact free database you can use easily create and use a database.  Though SQLite3 is not a full-featured database, it supports a surprisingly large set of the SQL standard, and is ideal for those just starting to learn SQL as well for developers that need a simple database engine to plug into their applications.  As such, SQLite has become very popular with smart phone developers.

Learn SQL with SQLite
There are several reasons I feel that SQLite3 is suitable for beginners.

The first is that you don’t need to be an expert to install and configure it.  In fact, getting SQLite3 to run is as simple as downloading the program and then running a simple command.

sqlite3 EssentialSQL.db

This is all that is needed to start up the database engine and start using the essential SQL database.

Second, the software is a really simple command line interface.  Now you may think that is a fault, but it isn’t, as our goal is to learn SQL.  And to really learn SQL you need to understand its commands and instructions (syntax).  SQLite lets you work distraction free with the essence of SQL.

Also, SQLite runs many different computer systems such as Apple OS X, Linux, and Windows.  This was important to me, since I wanted to provide everyone with easy to follow SQL lessons, and didn’t’ want to leave anyone out.

The last reason I recommend SQLite to beginners is that it is free to use.