Questions tagged [smallsql]

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

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

From their Welcome to SMallSQL page:

Advantages and Disadvantages of the SmallSQL Database

Advantages

  • It has a LGPL license.
  • You can redistribute it with your software for free.
  • It is 100% pure Java. You can use it on all platforms with Java version 1.4 or higher.
  • It is open source. You can look in the source code if you want it.
  • It is embeddable in you application. There is no additional setup required.
  • It is a very small Java library.
  • The quality is tested with JUnit and Emma Coverage.

Disadvantages

  • It does not has a network interface.
  • It required Java. No other access API is available currently.
  • You can't share the database between different applications at the same time.
  • There are no user management.
1 questions
38
votes
6 answers

Do conditional INSERT with SQL?

I have a database that is updated with datasets from time to time. Here it may happen that a dataset is delivered that already exists in database. Currently I'm first doing a SELECT FROM ... WHERE val1=... AND val2=... to check, if a dataset with…
Elmi
  • 5,899
  • 15
  • 72
  • 143