Article Preview

COLUMN

SQLite and the Command Line

Using the SQLite command shell

Issue: 12.5 (September/October 2014)
Author: Seth Verrinder
Author Bio: Seth is a software engineer who works on big data analytics. He worked with Xojo full-time for seven years as a consultant at BKeeney Software, Inc.
Article Description: No description available.
Article Length (in bytes): 7,816
Starting Page Number: 65
Article Number: 12510
Related Web Link(s):

http://sqlite.org

Excerpt of article text...

Today's column is about the SQLite command line program. I like a good graphical interface but sometimes a command line is the fastest way to get things done and, apart from speed, there's a big advantage if you want to invoke a program from a script. That's why having a command line option for Xojo (for doing builds) has been on my wish list for some time. Build automation helps but it would be nice to be able to just write a script that invoked Xojo to do the build and then signed the resulting executable and built installers. But I digress.

SQLite does come with a command line shell. It comes pre-installed on MacOS so you can just open a terminal and type sqlite3. On Windows, you need to download a copy (http://sqlite.org). There are pre-built binaries on the download page.

Basics

The first thing you need to do is start a terminal. On MacOS, you can use the Terminal application in Applications->Utilities. On Windows, you can use PowerShell (my preference) or the cmd.exe program (go to the start menu and type it in).

Once the window opens, type the following command and press enter:

...End of Excerpt. Please purchase the magazine to read the full article.