[
https://issues.apache.org/jira/browse/HDDS-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18121746#comment-18121746
]
Wei-Chiu Chuang commented on HDDS-16668:
----------------------------------------
The thing is Recon use SQL to query the db, which is not supported by RocksDB.
Also it depends on the type of queries, whether they are analytical or
transactional.
> Migrate from Derby
> ------------------
>
> Key: HDDS-16668
> URL: https://issues.apache.org/jira/browse/HDDS-16668
> Project: Apache Ozone
> Issue Type: Wish
> Reporter: Wei-Chiu Chuang
> Priority: Major
>
> Derby is retired. https://db.apache.org/derby/
> bq. On 2025-10-10, the Derby developers voted to retire the project into a
> read-only state. Derby development and bug-fixing have ended. No further
> releases will be published.
> Plus, there are known security vulnerabilities associated with Derby. We're
> not affected but from a supportability perspective we should move away from
> Derby as soon as feasibly possible.
> Possible solutions:
> 1. SQLite (least effort)
> 2. PostgreSQL, MariaDB, MySqL (if fullweight DB is needed, HA.. etc)
> 3. DuckDB (if we plan to have more analytical capabilities in Recon)
> 4. RocksDB (???)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
