FirstSQL/J Embedded Mobile Edition, Version 3.20

FFE Software introduced FirstSQL/J Embedded Mobile Edition, Version 3.20. The Embedded Mobile Edition is a full featured Relational Database Management System (RDBMS), supporting JME and suitable for other embedded configurations. Version 3.20 offers significant performance improvements, additional persistent storage capability, enhanced SQL92 compliance, and full Unicode support. FirstSQL/J Embedded Mobile is an ideal database management system for embedded and mobile applications.

FirstSQL/J Embedded Mobile Edition, Version 3.20 HEnhancements

Personal Component

  • SQL92 Compliance
    • JOIN Construct — CROSS JOIN, INNER JOIN, FULL OUTER JOIN and NATURAL and USING clauses
    • INTERSECT, EXCEPT Set Operations and CORRESPONDING clause
    • NCHAR, NVARCHAR Datatypes — Unicode support
  • BOOLEAN Datatype, True/False scalar values
  • Resource File Capabilities
    • BuildResourceDb Utility — writes a physical database to a resource file for loading the db
    • CompileStaticSql Utility — writes execution plans for SQL commands to resource file for use by MIDP Component
  • Database Load, for in-memory mode
  • General Performance Improvements, and more

MIDP Component

  • SQL92 Compliance
    • NCHAR, NVARCHAR Datatypes — Unicode support
    • DECIMAL, NUMERIC, FLOAT, DOUBLE, REAL Datatypes — full support
    • File System Persistence, in addition to Record Management System (RMS)
  • Static Sql Operation, external compilation of SQL commands to resource file for use by MIDP runtime, yielding significant performance increases and reduction in memory use
  • Database Load, using externally created resource file
  • Best Practices Reference, best practices for developing database applications and libraries in resource constrained environments
  • General Performance Improvements, and more

More info: FFE Software