Database management

Important new features and enhancements include:

  • Password changes   All passwords are case sensitive, regardless of the case-sensitivity of the database. New databases are created with a default user ID of DBA with the password sql. Consequently user IDs, passwords and trusted root certificates are not preserved as you upgrade your database from earlier releases.

  • Improved database properties and connection parameters   Database properties and connection parameters have been enhanced and simplified to allow you describe database and connection behavior more easily. See UltraLite database properties and UltraLite connection parameters for a complete list of database properties and connection parameters you can set for this release of the database.

  • Increased index performance   UltraLite index performance has been enhanced with this release. One of the major improvements is the introduction of index hashing. UltraLite now has a configurable index hash size. By setting the hash size to a value between 1-32 bytes, UltraLite stores part or all of the indexed value in the index page. This reduces the number of row lookups required. See UltraLite max_hash_size creation parameter.

  • Checksum validation   You can now include checksums on database pages to validate data integrity of these pages as they are stored on disk. See UltraLite checksum_level creation parameter.

  • Extended BLOB support   UltraLite databases now have extended support for BLOBs. UltraLite allows you to update, cast data types and get the length of these BLOBs.