SmallSQL is a German desktop-oriented database engine. SmallSQL is built upon the belief that database run time should not be the largest part of a desktop application, and is designed to have minimal runtime storage, producing only 200 to 300 KB of jar file. It is written entirely in Java and does not require linking to an external library.[04]
- Website
- http://www.smallsql.de[01]
- Source Code
- https://sourceforge.net/projects/smallsql/[02]
- Developer
- Country of Origin
- DE
- Start Year
- 2005 [02]
- End Year
- 2013
- Project Type
- Open Source
- Written in
- Java
- Supported Languages
- Java
- Operating System
- All OS with Java VM
- License
- LGPL v3
SmallSQL is a German desktop-oriented database engine. SmallSQL is built upon the belief that database run time should not be the largest part of a desktop application, and is designed to have minimal runtime storage, producing only 200 to 300 KB of jar file. It is written entirely in Java and does not require linking to an external library.[04]
Foreign Keys
SmallSQL supports foreign keys, and stores information about foreign keys as an array list.
Indexes
SmallSQL uses a radix trees for its indexes. The index supports both unique and non-unique keys. It will also attempt to convert stored values to a data type with comparable order.
Isolation Levels
SmallSQL supports four isolation levels: Read Uncommitted, Repeatable Read, Serializable, and None.
Joins
SmallSQL supports nested loop join methods including inner join, outer join, cross join, full join, left join, and right join. SmallSQL also supports indexed nested loop join using a scroll index, but only for inner join requests.
System Architecture
SmallSQL is an embedded system that does not contain any network interfaces.
Citations
7 sources- SmallSQL Database - the Java Desktop Database with JDBC interface smallsql.de
- SmallSQL Database - Java DBMS download | SourceForge.net sourceforge.net
- SmallSQL Database Documentation smallsql.de
- General FAQ SmallSQL Database smallsql.de
- https://sourceforge.net/p/smallsql/discussion/456961/thread/f1c54022 sourceforge.net
- 100% pure Java DBMS smallsql.de
- SmallSQL/src/main/java/smallsql/database/View.java at master · CptTZ/SmallSQL · GitHub github.com