SmallSQL 0.21

The ultimate Java Desktop SQL Database Engine

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!

What's new in SmallSQL 0.21:

  • 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.
Read full changelog
send us
an update
LICENSE TYPE:
LGPL (GNU Lesser General Public License) 
USER RATING:
3.0/5 21
DEVELOPED BY:
Volker Berlin
HOMEPAGE:
www.smallsql.de
CATEGORY:
ROOT \ Database \ Database Engines
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" );

Last updated on June 22nd, 2011

#SQL database #database engine #database server #SmallSQL #SQL #database #engine

Add your review!

SUBMIT