sqlite

Version:: 3.45.3
Category:: devel
Cluster:: Vali

Author / Distributor

https://www.sqlite.org/

Description

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.

The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems [1] [2] [3] and as a long-term archival format for data [4]. There are over 1 trillion (1e12) SQLite databases in active use [5].

Documentation

Usage: sqlite3 [OPTIONS] [FILENAME [SQL]]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist. Defaults to :memory:.
OPTIONS include:
  --                   treat no subsequent arguments as options
  -A ARGS...           run ".archive ARGS" and exit
  -append              append the database to the end of the file
  -ascii               set output mode to 'ascii'
  -bail                stop after hitting an error
  -batch               force batch I/O
  -box                 set output mode to 'box'
  -column              set output mode to 'column'
  -cmd COMMAND         run "COMMAND" before reading stdin
  -csv                 set output mode to 'csv'
  -deserialize         open the database using sqlite3_deserialize()
  -echo                print inputs before execution
  -init FILENAME       read/process named file
  -[no]header          turn headers on or off
  -help                show this message
  -html                set output mode to HTML
  -interactive         force interactive I/O
  -json                set output mode to 'json'
  -line                set output mode to 'line'
  -list                set output mode to 'list'
  -lookaside SIZE N    use N entries of SZ bytes for lookaside memory
  -markdown            set output mode to 'markdown'
  -maxsize N           maximum size for a --deserialize database
  -memtrace            trace all memory allocations and deallocations
  -mmap N              default mmap size set to N
  -newline SEP         set output row separator. Default: '\n'
  -nofollow            refuse to open symbolic links to database files
  -nonce STRING        set the safe-mode escape nonce
  -no-rowid-in-view    Disable rowid-in-view using sqlite3_config()
  -nullvalue TEXT      set text string for NULL values. Default ''
  -pagecache SIZE N    use N slots of SZ bytes each for page cache memory
  -pcachetrace         trace all page cache operations
  -quote               set output mode to 'quote'
  -readonly            open the database read-only
  -safe                enable safe-mode
  -separator SEP       set output column separator. Default: '|'
  -stats               print memory stats before each finalize
  -table               set output mode to 'table'
  -tabs                set output mode to 'tabs'
  -unsafe-testing      allow unsafe commands and modes for testing
  -version             show SQLite version
  -vfs NAME            use NAME as the default VFS
  -zip                 open the file as a ZIP Archive

Examples/Usage

List available modules:
```
$ module avail sqlite
```

Load the sqlite module:

$ module load devel/SQLite/3.45.3-GCCcore-13.3.0

Check the loaded modules:
```
$ module list
```

Unload the sqlite module:

$ module unload devel/SQLite/3.45.3-GCCcore-13.3.0

help:
```
$ sqlite3 --help
```

Installation

Source code is obtained from Sqlite