Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to practice SQL commands on Ubuntu. I would just like to play with different commands and keywords. Where can I find something that helps?

I don't want to install any server. I need a small app; something less than 20MB.

share|improve this question
up vote 7 down vote accepted

If you want to play around with a lightweight SQL RDBMS, SQLite (Ubuntu package) is the standard choice. You have multiple options to use SQLite:


You can use the SQLite program directly from the command line by running

sqlite3 /some/database/file.sqlite

Type commands and press Enter (remember the trailing semicolon).


Alternatively, you can install sqliteman, which provides a nice GUI browser for SQLite databases; you can also enter SQL code and execute it (displaying the results in the GUI):

sqliteman screenshot

Install via terminal:

sudo apt-get install sqliteman



Be aware that SQLite takes some unusual design decisions for an RDBMS:

  • No client-server architecture
  • Dynamically typed; SQLite does not enforce many constraints that other RDBMSs insist on. If you want to simulate MySQL-like typing, you have to explicitly add CHECK constraints.
share|improve this answer
Doest it need any remote connection? I want to work offline. Only need to play with commands. – BigSack Sep 13 '12 at 9:25
THANKS! WORKED! – BigSack Sep 13 '12 at 9:30
Everything runs locally. – Mechanical snail Sep 13 '12 at 10:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.