![]() |
![]() |
|
![]() |
||
Basic ![]() ![]() ![]() ![]() ![]() ![]() |
What's included and excludedWhat's IncludedInstantDB supports all of the the following features.
What's Missing
Miscellaneous LimitationsJoins are currently only supported in the WHERE clause, e.g WHERE table1.col = table2.col. Joins are not currently supported via the ANSI standard NATURAL JOIN or INNER JOIN phrases in the FROM clause. InstantDB accepts such statements as syntactically correct, but currently ignores them. There is also a limitation on the use of the UNIQUE keyword when use in a CREATE TABLE statment. If several columns are included in a UNIQUE clause, then InstantDB ensures that each column is individually unique. This deviates from the ANSI SQL specification where the columns should be collectively unique. This will be fixed in a future release. For safetys sake, it is recommended that only a single column be used in each UNIQUE clause. Collective uniqueness across multiple columns can be enforced using the CREATE UNIQUE INDEX statement. InstantDB is a single database program. Attempting to open more than one database simultaneously will result in an exception. Java CompatabilityAll the classes were compiled using the 1.1 JDK. All deprecated methods have been removed. This release will only run on 1.1 compliant JVMs.InstantDB has been successfully tested against Java 2 (formerly JDK 1.2) and found to be fully Java 2 compatable. InstantDB can't claim the 100% pure java badge (that costs money!). However, it does get through the JavaPureCheck test, which should be good enough to be getting on with. |