Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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

1 Answer 1

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:

Command-line

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).

GUI

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

Or:

Caveat

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
1  
THANKS! WORKED! –  BigSack Sep 13 '12 at 9:30
    
Everything runs locally. –  Mechanical snail Sep 13 '12 at 10:00

Your Answer

 
discard

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.