SmallSQL

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.

Checkpoints

Not Supported

SmallSQL does not support checkpoints.

Data Model

Relational

SmallSQL uses the relational data model.

Foreign Keys

Supported

SmallSQL supports foreign keys, and stores information about foreign keys as an array list.

Indexes

Patricia/Radix Trie

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

Read Uncommitted Serializable Repeatable Read

SmallSQL supports four isolation levels: Read Uncommitted, Repeatable Read, Serializable, and None.

Joins

Nested Loop Join Index Nested Loop Join

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.

Logging

Not Supported

SmallSQL does not support logging and log recovery.

Storage Architecture

Disk-oriented

SmallSQL is a disk-oriented DBMS.

Stored Procedures

Not Supported

SmallSQL does not support Stored Procedures.

System Architecture

Embedded

SmallSQL is an embedded system that does not contain any network interfaces.

SmallSQL Logo
Website

http://www.smallsql.de/

Source Code

https://sourceforge.net/projects/smallsql/

Tech Docs

http://www.smallsql.de/doc/index.html

Developer

Volker Berlin

Country of Origin

DE

Start Year

2005

End Year

2013

Project Type

Open Source

Written in

Java

Supported languages

Java

Operating Systems

All OS with Java VM

Licenses

LGPL v3