JSQLiteClient 2.1 Help

JSQLiteClient is Copyright © 2017, P. Lutus.

JSQLiteClient is released under the GPL: http://www.gnu.org/licenses/gpl.html

Please visit http://www.arachnoid.com/JSQLiteClient for more documentation and to acquire the latest version of JSQLiteClient. This help page explains how to use JSQLiteClient, while the home page covers installation issues and certain other topics in greater depth.

For formatting reasons and to properly read these instructions, users may want to temporarily make the JSQLiteClient program frame larger.

Introduction | Features | Command-line Operation | Miscellaneous Notes


JSQLiteClient is a Java program that serves as a SQLIte/SQLIte3 database client (meaning a program that interacts with database files). With JSQLiteClient you can create, author and edit SQLite databases, and conduct sophisticated searches (in database terminology these searches are called "queries"). You can analyze database construction and optimization, and copy generated content to other environments in several formats. You can create, delete, and modify data and tables, and perform many kinds of maintenance tasks using JSQLiteClient's built-in SQLite terminal.

Because JSQLiteClient is written in Java, it will run on virtually any platform. And to run, JSQLiteClient needs the most recent version of Java, available free at http://java.com. Many runtime issues are resolved by simply upgrading to the most recent Java runtime engine.


This section's topics follow the order of the JSQLiteClient tabs one uses to access different features. The topics are:

Command-line Operation
JSQLiteClient has some command-line arguments that simplify launching the program with a particular configuration, or one of many configurations for different purposes. The arguments are:
Usage: -f "name of font" -d database -t table
       -r read table -h help
Miscellaneous Notes

Unicode issues

Similarities with the "sqlite3" command-line utility

Program state preservation

Partition bar

Saved Web pages

JSQLiteClient resources

Here are some JSQLiteClient-related resource locations:

JSQLiteClient Home Page http://arachnoid.com/JSQLiteClient
JSQLiteClient version 2.1
User home directory (user home directory)
JSQLiteClient Web page directory location (webpage path)
JSQLiteClient configuration file location (configuration path)
Currently running JSQLiteClient application location (application path)

Bug reports