Our First Table

Using SQLiteStudio, add a database called TheBooks (no space) and add a table called Clients. Configure the table like this: CREATE TABLE Clients ( ID INTEGER PRIMARY KEY, Name VARCHAR (32) NOT NULL, Address1 VARCHAR (32) NOT NULL, Address2 VARCHAR (32), Address3 VARCHAR (32), Address4 VARCHAR (32), Contact1 VARCHAR (32), Contact2 VARCHAR (32), Contact3 VARCHAR…

Continue reading Our First Table

Setting up SQLite

Setting up SQLite turned out to be a lot easier than I thought, though I first went through a lot of false starts. I downloaded Microsoft’s System.Data.SQLite, but I couldn’t create DataSets in Designer. I installed and uninstalled a lot of things, but finally, it seemed the only thing I needed was a driver, just…

Continue reading Setting up SQLite

Choosing Our Database

As you know, the database world is divided into SQL databases and other SQL databases. That’s only a slight exaggeration. Even Microsoft Access understands SQL. There are two broad kinds of SQL: server-based and client-based. Server-based SQL is software that runs on a server. You send the server an SQL query, and the server returns…

Continue reading Choosing Our Database