Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 14 in printed book and digital formats -- plus a one-year subscription so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 12.5 ('Yosemite')
Instant purchase and download via GumRoad!

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.