SmallSQL is a Germany-based Java Desktop SQL Database Engine. It is a relational and 100% pure Java DBMS implemented using the Java Database Connectivity (JDBC) API. [04][01]
- 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 built upon the belief that database runtime 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. However, this implies a lot of unimplemented or unsupported features, including user management, database sharing, and network interface.
SmallSQL have only limited use and popularty, and suffers from a lack of documentation.
SmallSQL is a Germany-based Java Desktop SQL Database Engine. It is a relational and 100% pure Java DBMS implemented using the Java Database Connectivity (JDBC) API.
SmallSQL is built upon the belief that database runtime 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. However, this implies a lot of unimplemented or unsupported features, including user management, database sharing, and network interface.
SmallSQL have only limited use and popularty, and suffers from a lack of documentation.[04][01]
Checkpoints
SmallSQL does not support savepoints. Whether it supports checkpoints is not explicitly stated anywhere.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/SSDatabaseMetaData.java'.
Data Model[06][01]
SmallSQL is a Relational Dababase Management System (RDBMS) implemented using the Java Database Connectivity (JDBC) API, which supports mostly RDBMS. It is also classified as a 100% pure Java DBMS, which is defined as a DBMS that is written in pure java with no link to any native library.
Foreign Keys
SmallSQL supports foreign keys, and stores information about foreign keys as an array list.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/ForeignKeys.java'.
Indexes
SmallSQL supports a radix tree index. The index data structure is implemented by the author himself, and supports both unique and non-unique keys. It will also attempt to convert stored values to a data type with comparable order.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/Index.java'.
Isolation Levels
SmallSQL supports four isolation levels: Read Uncommitted, Repeatable Read, Serializable, and None.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/SSDatabaseMetaData.java'.
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.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/Join.java'.
Storage Model
SmallSQL implements a Decomposition Storage Model.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/Column.java'.
Stored Procedures
SmallSQL does not support Stored Procedures.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/SSDatabaseMetaData.java'.
System Architecture[01]
SmallSQL is an embedded system that does not contain any network interfaces.
Views
SmallSQL supports materialized views.
This information is extracted from SmallSQL's source codes, at 'src/smallsql/database/View.java'.
Citations
6 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