SmallSQL 0.16

SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API. There are 2 solutions to start with SmallSQL DBMS

Developer:   Volker Berlin       more software by author → Price:  0.00 License:   LGPL (GNU Lesser General Public License) File size:   0K Language:    OS:    Rating:   0 /5 (0 votes) Your vote:   enlarge screenshot

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's New in This Release:

A command line interface was added.

Now you can modify the database without a third party GUI tool.
tags jdbc smallsql  small sql  url jdbc  smallsql database  sql database  the menu  name small  smallsql db1  jdbc driver  you can  database ssdriver  the alias  sql db1  

Download SmallSQL 0.16

 http://prdownloads.sourceforge.net/smallsql/smallsql0.16_src.zip?use_mirror=optusnet
 http://prdownloads.sourceforge.net/smallsql/smallsql0.16_src.zip?use_mirror=switch
 http://prdownloads.sourceforge.net/smallsql/smallsql0.16_src.zip?use_mirror=easynews

Authors software

SmallSQL 0.16 (by Volker Berlin) SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API. There are 2 solutions to start with SmallSQL DBMS

Similar software

SmallSQL 0.16 (by Volker Berlin) SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API. There are 2 solutions to start with SmallSQL DBMS

JDBC Driver for SQLite 006 (by David Crawshaw) JDBC Driver for SQLite is a thin layer on top of the SQLite 3.3.x C API

RmiJdbc 3.3 (by Objectweb RmiJDBC Team)

Craftsman Spy 1.0.5 (by Craftsman) Craftsman Spy is a an open source and free framework for JDBC logging

HA-JDBC 1.1.9 (by Paul Ferraro)

Gaudi - Database Visual Editor 1r1 (by Memoria Persistente) Gaud? - Database Visual Editor is a Java application that allows you to visually design the tables of a database using a JDBC 2.0 (or

Easysoft ODBC-JDBC Gateway 2.0 (by Easysoft Limited) Easysoft ODBC-JDBC Gateway lets ODBC-enabled applications such as Business Objects, Microsoft Access, Microsoft Excel and Microsoft S

JDBC SQL Profiler 0.3 (by Serge Huber) JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create i

SQLiteJDBC 030 (by David Crawshaw) SQLiteJDBC is a JDBC driver for SQLite which is written as a Java JNI layer over the SQLite 3.3.x API. SQLiteJDBC supports the mos

Template::Tutorial 2.15 (by Andy Wardley) Template::Tutorial are template toolkit tutorials. This section includes tutorials on using the Template Toolkit

Other software in this category

Berkeley DB 4.5.20 (by Oracle) Berkeley DB (libdb) is a programmatic toolkit that provides embedded database support for both traditional and client/server applicat

phpPgAdmin 4.0.1 (by Christopher Kings-Lynne) phpPgAdmin is a web-based administration tool for PostgreSQL

SQLite 3.3.8 (by D. Richard Hipp) SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Here are some ke

Firebird Relational Database 2.0 Final (by Firebird Project) Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms.

gdbm 1.8.3 (by Phil Nelson) gdbm is a database indexing library replacement for the traditional 'dbm' and 'ndbm' libraries