Speedment Open Source is the equivalent of Speedment Stream limited to use with Open Source databases. Like Stream, it analyzes the metadata of an existing SQL database and automatically creates a Java representation of the data model. Queries are then expressed as standard Java Streams instead of a sequences of SQL constructs.
Pure Java - Stream API instead of SQL eliminates the need of a query language
Dynamic Joins - Ability to perform joins as Java streams on the application side
Parallel Streams - Workload can automatically be divided over several threads
Streams are Lazy - Content from the database is pulled as elements are needed and consumed
Pipeline Introspection - Optimized performance by short circuiting of stream operations
Code Generation - Automatic generation of a Java representation of the database eliminates boilerplate code and the need of manually writing Java Entity classes
Null Protection - The risk involved with database null values is eliminated by use of Java Optionals
Enum Integration - Mapping of String columns to Java Enums increases memory efficiency and type-safety
Speedment Open Source currently supports SQLite, MariaDB, PostgreSQL and MySQL.