Web lists-archives.com

sqlite database




  As an alternative to client-server database managers,
  such as mysql, mariadb, postgresql, etc. ,
  the  sqlite  embedded database manager is very useful .... 

    https://en.wikipedia.org/wiki/SQLite
    sqlite - wikipedia

    https://sqlite.org
    sqlite - home page

    https://sqlite.org/cli.html
    sqlite - command line interface

    http://zetcode.com/db/sqlite/
    sqlite - zetcode tutorial


  sqlite is readily available from the debian repositories .... 

    $ apt show sqlite3

    $ sudo apt install sqlite3

    $ apt policy sqlite3


    # create a database and a database table

      $ sqlite3 /tmp/atest.sql3
        sqlite> create table lookup
        ...> (
        ...>   id    integer ,
        ...>   value text
        ...> ) ;
       sqlite>
       sqlite> -- insert some data --
       sqlite>
       sqlite> insert into lookup( id , value ) values( 1 , 'line 1' ) ; 
       sqlite> insert into lookup( id , value ) values( 2 , 'line 2' ) ; 
       sqlite> insert into lookup( id , value ) values( 3 , 'line 3' ) ; 
       sqlite>
       sqlite> -- turn on column mode and headers --
       sqlite>
       sqlite> .mode columns
       sqlite> .headers on
       sqlite>
       sqlite> -- query the database --
       sqlite>
       sqlite> select id , value from lookup ;
       id          value
       ----------  ----------
       1           line one
       2           line two
       3           line tre
  

-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona