InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

About InstantDB

InstantDB is a 100% Java,™ Relational Database Management System (RDBMS). Features supported include joins, transactions, triggers, sub-selects, table aliasing and much, much more that you wouldn't normally expect to find in a free RDBMS.

Since its launch in July 1997, InstantDB has been adopted by thousands of internet and database developers around the world. It is small, efficient, easy to install, and comes with lots of examples to help get the novice developer started. InstantDB is accessed via its own JDBC™ driver. By using standard SQL and Sun's JDBC™ API, InstantDB ensures that your applications enjoy a high degree of portability.

Lutris Technologies purchased InstantDB in April of 2000. The intent is to Open Source InstantDB in the near future, and create the most popular Open Source Java™ RDBMS.

What's Included
What's Missing
Java™ Compatibility


What's Included
InstantDB supports all of the the following features.
  • Indexes
  • Inner joins via the WHERE clause
  • Inner and outer joins via the FROM clause
  • Sub-selects, including correlated sub-selects
  • Data caching
  • Data encryption
  • Transaction processing with automatic table locking
  • Automatic deadlock detection
  • Triggers
  • Imports from text files or other JDBC™ data sources
  • Full PreparedStatement support
  • Multiple disk support
  • Table aliasing
  • Unlimited simultaneous Connections and Statements
  • Thread safety
  • Date, currency and binary data types
  • AUTO INCREMENT integer values
  • Configurable date and currency formatting
  • AVG, MAX, MIN, SUM and COUNT functions
  • GROUP BY and HAVING
  • ORDER BY
  • ALTER TABLE
  • SELECT, INSERT, DELETE, UPDATE
  • CREATE, DROP, IMPORT
  • COMMIT, ROLLBACK
  • NULL, UNIQUE and DISTINCT testing
  • Readonly mode
  • Debug tracing
  • Metadata support
  • Results set navigation extensions
  • Zero maintenance operation
  • Tuning capabilities to balance performance and reliability
  • Millenium compliance and millenium aware capabilities
  • Automatic recovery
  • Foreign key support
What's Missing
  • No database views
  • No multiple user names or privileges
  • No BIT types
  • No understanding of referential integrity checking
  • ANY and ALL are not supported.

Many of the above features will be included in later releases. If users have any particular preferences for the order in which these should be implemented then please feel free to say so.

Java™ Compatibility

All the classes were compiled using the 1.2 JDK. All deprecated methods have been removed. This release will only run on 1.1 or later JVMs. InstantDB and its JDBC™ driver have been tested with JavaPureCheck.™ Both are 100% Java.™