SmallSQL

SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API.

There are 2 solutions to start with SmallSQL DBMS

1.) From an existing Database

You can convert an existing Database with JDbConverter. This is an open source tool to convert a database from one DBMS to another DBMS via JDBC. You can download it and convert your existing JDBC database.

2.) Create a database with a GUI tool

We does not have such tool but we recommended one of the follow:
JDBC Navigator. This is a free graphical Java tool. After you have download it
Select the menu "Open JDBC Data Source"
Name: Small SQL Database
Driver Class: smallsql.database.SSDriver
URL: jdbc:smallsql
Save and Connect
Open the menu "Connection | SQL Window"
Enter "CREATE DATABASE db1" and execute it with ENTER
Close the Connection
Select the menu "Open JDBC Data Source" and change the URL to
jdbc:smallsql:db1
Save and Connect

SQuirreL SQL Client. This is an open source graphical Java tool. After you have download and install it
Create a new JDBC Driver
Name: Small SQL Database
Example URL: jdbc:smallsql:
Create a new Alias
Name: Small SQL db1
JDBC Driver: Small SQL
URL: jdbc:smallsql
Auto Logon: Yes
Connect to the alias "Small SQL db1"
Change to the tab "SQL"
Enter "CREATE DATABASE db1" and execute it
Close the window
Change the alias
JDBC URL: jdbc:smallsql:db1
Connect to the alias "Small SQL db1"

Configuration:

JDBC Driver class name: smallsql.database.SSDriver

JDBC URL: jdbc:smallsql:< database >

< database > is a absolute or relative directory name

In the Java code for a directory "db1" this look like:

Class.forName( "smallsql.database.SSDriver" );
java.sql.Connection con = java.sql.DriverManager.getConnection( "jdbc:smallsql:db1" );

What is new in this release:

• Some minor bugs were fixed and the JDBC URL property "readonly" was added.
• Now you can share one database in read-only mode between multiple Java processes.

What is new in version 0.20:

• This release adds some features to make the SmallSQL Database syntax more compatible with MySQL.
• This makes a change simpler. Some critical thread problems were fixed.