swdev:sqlite:start [Audina Documentation]

SQLite

Download

Create Database

Method 1: Create a database schema using a file:

$ sqlite3 mydatabase.db < db.schema

Method 2: Create schema manually (and then enter SQL commands at the prompt to create and populate the new tables):

$ sqlite3 mydatabase.db
sqlite> create table greetings(one varchar(10), two smallint);
sqlite> insert into greetings values('hello!',10);
sqlite> insert into greetings values('goodbye', 20);
sqlite> select * from greeting;

$ sqlite3 mydatabase.db
sqlite> CREATE TABLE product (
   ...>   id int(11) primary key autoincrement,
   ...>   name varchar,
   ....>  description text,
   ...>   price real
   ...> );
sqlite>

Method 3: Create table by importing CSV file:

$ sqlite3 mydatabase.db
sqlite> .mode csv
sqlite> .import C:/work/somedata.csv tab1

Alter Table

ALTER TABLE table_name
  ADD new_column_name column_definition;

SQLite Client

Custom client in C#

References