SQLite 3.8.7

A command-line access program that was especially designed in order to provide an uncomplicated means of working with SQLite databases
Handling SQLite databases and running various commands to create or query them are tasks for specialized programs and users with lots of experience in this field. Among the many dedicated utilities that are meant to ease the job for users and administrators there's a lightweight software called SQLite.

Since it is a command-line tool, you will not get a proper graphical interface, but if you are familiar with the syntax, you shouldn't have any difficulties in working with SQLite. All SQL statements you type in must end with a semicolon, so they can be executed as soon as the 'Enter' key is pressed.

An important aspect that you should take under consideration is the existence of a hefty set of commands that are quite different from the others. The main difference resides in the fact that as opposed to regular input you provide and is send to the SQLite library, these ones are processed only by the sqlite3 application.

In order to access the special functions (also called 'dot commands'), you can checkout the list that can be displayed from within the command-line utility. These instructions are made to allow the execution of some prepackaged statements as well as to modify the format of the results of a query.

An interesting characteristic of this tool is the ability to present the query output in several modes. Choosing the one you need can be done only through the use of those special commands mentioned earlier. The formats in which SQLite can show you the results are column, HTML, CSV, line, insert, list, tcl and tabs.

After spending some time with this application, one conclusion can be drawn and it is that SQLite is a utility that targets a specific audience and, thus, is addressed to specialists and not the general public.

Reviewed by on November 14th, 2013


last updated on:
October 18th, 2014, 6:43 GMT
file size:
303 KB
price:
FREE!
developed by:
Richard Hipp
license type:
Freeware
operating system(s):
Windows All
category:
C: \ Internet \ Servers \ Database Utils

FREE!

In a hurry? Add it to your Download Basket!

softpedia rating

3.5/5

user rating 30

4.3/5
 

0/5

1 Screenshot
SQLite - SQLite3 comes with a command-line shell that comes in handy for accessing and editing SQLite databases
What's New in This Release:
  • Performance Enhancements:
  • Many micro-optimizations result in 20.3% more work for the same number of CPU cycles relative to the previous release. The cumulative performance increase since version 3.8.0 is 61%. (Measured using cachegrind on the speedtest1.c workload on Ubuntu 13.10 x64 with gcc 4.8.1 and -Os. Your performance may vary.)
  • The sorter can use auxiliary helper threads to increase real-time response. This feature is off by default and may be enabled using the PRAGMA threads command or the SQLITE_DEFAULT_WORKER_THREADS compile-time option.
  • Enhance the skip-scan optimization so that it is able to skip index terms that occur in the middle of the index, not just as the left-hand side of the index.
read full changelog
 

Application description

The SQLite library includes a small command-line utility SQLite3 that will allow you to manually enter and execute SQL...

Add your review!

SUBMIT