| Database Features: Relational SQL Database SQL Editor (iSQLView) In memory Indexes Inner joins via the WHERE clause Inner and outer joins via the FROM clause Sub-selects including correlated subselects Data encryption Transaction support Deadlock detection Triggers Referential Integrity User-Defined Functions Imports from text files and other data sources Full prepared statement support Multiple disk support Table aliasing Unlimited connections/statements Thread safety Date, currency and binary types Auto increment for integer values Configurable date and currency formatting AVG, SUM, MIN, MAX, COUNT functions User-defined functions GROUP BY and HAVING ORDER BY ALTER TABLE SELECT, INSERT, UPDATE, DELETE BLOBS, CBLOBS Check constraints Read-only mode Debug tracing Metadata support Result set navigation extensions Near-zero maintenance Performance tuning Automatic recovery GUI Administration XA Support Thread-Safe Implementation Multi-Threaded Bulk Loader Locking
JDBC usage: datasource.driver=org.enhydra.instantdb.jdbc.idbDriver datasource.url=jdbc:idb:c:/myapps/data/simpleApp.prp datasource.user= datasource.password= |
| |