Create Your Own SQLite Database

This article will teach you how to set up your own relational database using DbVisualizer and SQLite.

Article written by: Scott A. Adams
Reading: 2 mins. To read the full article please visit Medium and read Create Your Own SQLite Database With DbVisualizer

Scott is a data scientist, social scientist, and educator who cannot think of anything witty to put here.
Knowing Structured Query Language, or SQL, is foundational for various data professions, including data analysts, data engineers, and data scientists. In many organizations data is stored in relational databases and SQL is the standard language that is used to query and pull data from relational databases. However, I have encountered a number of individuals who are not sure how to learn SQL because they have not been exposed to a relational database. Fortunately, there is a relatively straightforward way to create and manage your own relational database that I will illustrate in this article. Let’s see how it can be done.

Tools Needed

SQLite First, we will need a SQL engine, which is a piece of software that interprets and executes SQL commands. There are numerous engines to choose from, but for educational purposes, I prefer using SQLite, which is a widely-used free and open-source SQL engine. An added benefit of SQLite is that databases can be stored locally as files on your computer (these files have a “.db” extension). SQLite can be downloaded here.

DbVisualizer DbVisualizer is a popular tool for connecting to multiple SQL engines and databases, including SQLite. Aside from its ability to easily connect to a SQLite database file, as well as other SQL engines, DbVisualizer is also used here because it contains a visually appealing and easy-to-use query editor with syntax highlighting. Download DbVisualizer here.

Creating an Empty SQLite Database

Once SQLite is installed on your machine, open a new SQLite session. On Mac or Linux a new SQLite session can be initiated by navigating to a terminal (e.g., Terminal on MacOS) and running sqlite3. Windows users can run the sqlite3.exe executable file, which will open a new shell running SQLite.

More information on starting a SQLite session can be found here.

To read the full article, 9 mins read, please visit Scott A. Adams article Create Your Own SQLite Database With DBVisualizer , on Medium

Related articles

How to join your tables using ERD

Why can't we just have a single table? Navigating relationships in relational databases.

Read more

High interest in DbVisualizer

The positive reception of our release translates into renewed trust with our customers.

Read more