SmallSQL

The ultimate Java Desktop SQL Database Engine
Download

SmallSQL Ranking & Summary

Advertisement

  • Rating:
  • License:
  • LGPL
  • Price:
  • FREE
  • Publisher Name:
  • Volker Berlin
  • Publisher web site:
  • http://www.smallsql.de/

SmallSQL Tags


SmallSQL Description

The ultimate Java Desktop SQL Database Engine SmallSQL is the ultimate Java Desktop SQL Database Engine with JDBC 3.0 API.There are 2 solutions to start with SmallSQL DBMS1.) From an existing DatabaseYou 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 toolWe 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 itSelect the menu "Open JDBC Data Source" Name: Small SQL Database Driver Class: smallsql.database.SSDriver URL: jdbc:smallsql Save and ConnectOpen the menu "Connection | SQL Window"Enter "CREATE DATABASE db1" and execute it with ENTERClose the ConnectionSelect the menu "Open JDBC Data Source" and change the URL to jdbc:smallsql:db1Save and Connect SQuirreL SQL Client. This is an open source graphical Java tool. After you have download and install itCreate a new JDBC DriverName: Small SQL DatabaseExample URL: jdbc:smallsql:Create a new AliasName: Small SQL db1JDBC Driver: Small SQLURL: jdbc:smallsqlAuto Logon: YesConnect to the alias "Small SQL db1"Change to the tab "SQL"Enter "CREATE DATABASE db1" and execute itClose the windowChange the aliasJDBC URL: jdbc:smallsql:db1Connect to the alias "Small SQL db1"Configuration:JDBC Driver class name: smallsql.database.SSDriverJDBC 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: · 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.


SmallSQL Related Software

About SoftwareSea