Home / ubuntu / Questions / 187260
Accepted
BigSack
Asked: 2012-09-14 00:52:08 +0800 CST

Any good SQL shell programs?

  • 772

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.

software-recommendation

2 Answers

  1. Best Answer

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

  2. Give a try sqlline which is shell for issuing SQL to relational databases via JDBC.

    There is a project demos page with short demo videos

    • 1