3 posts tagged with "db2rest"

As a maintainer of open source projects it's not always possible to support feature requests instantly. We were just getting started on supporting Vector databases and embeddings for March release. However, when one of the collaborators came with a pressing need to support Cloudflare D1 for a startup, we decided to take a look. Initially we were a bit hesitant, because D1 is meant to be used from Cloudflare Workers and Pages.

After initial analysis we figured out that it is possible to support this database and CRUD, in few days. The core framework is extremely pluggable now to support any database in just few days or even less. Really great work by the team. This was also an opportunity for us to refactor the core engine now to make it ready to support non-relational databases. I promise, that MongoDB support will arrive later this year.

What's Change​

• Support for Cloudflare D1 - Query, Filter, Insert, Update, Delete.
• Refactoring the core to pave way for non-relational databases.

Whats's Next​

Ok we are now back into simplifying AI/ML support around PostgreSQL with PostgresML and pgvector. Besides, this we will work on documentation, which is lagging. March 2024, is few hours away, knowing the team, we can deliver bit more as well....

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.