This month, the team added several new features listed below:

What's Change​

• DB2Rest now supports MariaDB.
• DB2Rest now works on Koyeb cloud.
• DB2Rest can now work with Neon PostgreSQL database.
• Support added for CockroachDB.
• SSL Certificate authententication for Cockroach DB and PostgresSQL.
• New capability to query tables with same name in different schema/catalog.
• Cloudflare D1 support dropped.

Whats's Next​

The work to support MongoDB is in full swing. This work is expected to be generally available by release 0.4.0. Again several features are currently undocumented, and we will continue to work on improvement of documentation.

This month, the team added several new features listed below:

What's Change​

• Upgrade to Spring Boot 3.2.2.
• Improved dependency free and faster core engine.
• Extensive and elaborate JOIN support (documentation to be added)
• Improved TSID support - based on column type and reduced metadata input.
• Support for view.
• Support for materialized view of PostgreSQL
• Support for insertion of JSON data type PostgreSQL, MySQL
• Support for timestampz and timetz column data types.
• Exists query to check if a record exists in a table.
• Reduced docker image size and executable jar size.
• API Auth with Unkey

Whats's Next​

Next release will mostly focus on adding AI/ML support around PostgreSQL with PostgresML and pgvector. These features will simplify MLOps and make it super easy to build intelligent applications with DB2REST. This release is expected to arrive end of March 2024.

After a month of code crunching, I am pleased to announce that DB2Rest - 0.0.9 has been released. Some of the key changes are listed below.

What's Change​

• Support for sort.
• Replaced jOOQ with Mybatis Dynamic SQL for typesafe SQL creation.
• Support added for remote procedure calls - invoke stored procedures and functions over REST.
• Improve error reporting based on Problem detail specification.
• Support for custom SQL query execution.
• Support TSID column for primary key for both single or bulk records insert.
• Support both number and string based TSID auto-generation for any database.
• Bulk insert now supports both JSON and CSV content or records.
• Implicit multi table join based on path.
• Support - find one row.
• 52 new integration tests added.
• DELETE success operation now returns 204 (subject to change)
• Add data type conversion support for Java to SQL (ongoing)

Besides these changes we have created several automations to ensure better documentation and thoroughly tested releases going forward. For example we have integrated Spring REST Docs with integration tests to auto generate examples and keep documentation in sync with code. New Github Action has been added to ensure tests are always run for code push.

Whats's Next​

Next release with we will improve the existing features to be more robust, bulk uploads and security features. This release is expected to arrive end of February 2024. The documentation is still behind schedule and work is underway to improve and add more documentation soon.