Sqlite using command line

Question

Sqlite is kinda frustrating. Each time I run a command, I'm not able to use the up down left right arrows to retrieve my previously typed commands. Is there any way to enable this?

Another question: I have the following table

CREATE TABLE resource (
    resourceID INTEGER PRIMARY KEY AUTOINCREMENT,
    resourceType STRING,
    userID INTEGER DEFAULT -1
);

and I insert as follows:

insert into resource values(null, "razor");

but its not allowing me to do so because I have only inserted into 2 columns and not specified anything for the userID column. But I thought the point of DEFAULT was to default the values to -1 if nothing was inserted. Am I missing something here?

Answer 1

A quick solution is to launch SQLite with ReadLine support like following:

rlwrap sqlite3 database.db

If rlwrap is not installed, you can do so on Ubuntu using the command:

sudo apt-get install rlwrap

For other Linux versions, check here.

rlwrap is a ReadLine wrapper, a small utility that uses the GNU readline library to allow the editing of keyboard input for any other command.