SQLite

SQLite: A lightweight software solution that provides you with an uncomplicated way to work with SQL databases

SQLite is an application that allows you to create, query, and run various commands on SQL databases. Since the program is a command line tool, it doesn’t come with a graphical interface (so it’s definitely not for beginner users), but if you’re someone that familiar with syntax you should have no issues at all with navigation.

It comes equipped with a hefty set of commands as well as a variety of special functions that can not only help you get your work done more quickly, but can actually make your job more efficient and in turn, give you more free time to focus on other things.

Features:

- A hefty set of commands that are processed only by the application (which gives it an edge over other command line applications).
- Gives you the ability to present your query output in several modes (column, HTML, CSV, line, insert, list, tcl, and tabs).
- An interface that’s geared more toward advanced computer users (you’ll need to be familiar with the syntax).
- Executes all of your statements as soon as you press the enter key (as long as they end with a semicolon).
- A handy command line utility that provides you with access to the special list of commands.
- Lets you build SQL scripts quickly and easily.
- Gives you the opportunity to compact your databases as you need to.
- Verifies your database integrity.
- Unicode support.
- Skins to customize the look and feel of the utility.