From aoxoaWiki
Jump to navigationJump to search

SQLite is a lightweight file-based database.

The SQLite software is included in Mac OSX.


SQLite may already be installed. See if the command sqlite3 works....

To install SQLITE on a Mac:

SQLite Downloads page

To create a new SQLite database:

  cd <directory>
  sqlite3 <dbname>.db
  create table zyz ( column1 integer );

To list the structure of a table:

  .schema table_name
  .headers on
  PRAGMA table_info(table_name);

.schema show sql create statement; PRAGMA lists column details

Online Resources

Back to Main Page