specified data types. CREATE TABLE pets ( _id INTEGER, name TEXT, breed TEXT, gender INTEGER, weight INTEGER); INSERT data in a table INSERT INTO ( , corresponding column names. INSERT INTO pets ( _id, name, breed, gender, weight) VALUES ( 1, "Tommy", "Pomeranian", 1, 4); READ SELECT data WHERE ; Update information in an existing row in a table. UPDATE pets SET weight = 18 WHERE _id = 5; DELETE DELETE data from a table DELETE FROM WHERE ;

SQLite database is stored in a single cross-platform disk file.  SQLite is very small and light weight, less than 400KiB fully configured or less than 250KiB with optional features omitted.  SQLite