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
- 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
- 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.
