ObjectBox Java (Kotlin, Android) VS HikariCP

When I first attempted to publish to F-Droid, I experienced several pipeline issues. After reading through the pipeline logs in GitLab, I realized that my application's database (ObjectBox) was not entirely FOSS compliant and was causing build failures. The following day was spent migrating my app to Room.

I would focus on Kotlin instead of Java, there's really no point in sticking to Java at this point. And when it comes to databases, some local ones that are pretty easy to get into are Realm and ObjectBox, SQLite can definitely be a bit overwhelming at the beginning.

Not sure what exactly the issue is in your case, but linux-aarch64 is already a supported platform for ObjectBox (with some dependencies on libc versions etc). Maybe raise an issue for https://github.com/objectbox/objectbox-java with your specific error output and some details on your setup?

Just to add to this, there's also Realm and ObjectBox as alternatives.

Adding ObjectBox [0] to the list.

[0] https://objectbox.io/

Obectbox

While - strictly speaking - "database" refers to a systematic collection of data, "Database Management System'', or DBMS, refers to the piece of software that provides an efficient and versatile method of working with data(eg: ObjectBox). However, often the term "database" is also used loosely to refer to a DBMS, and you will find most DBMS only use the term database in their name and communication.

Maybe this? I've been looking at it recently.

https://github.com/objectbox/objectbox-java is an alternative to Room.

Here's the issue

Looks like HikariCP is also awaiting fixes for this https://github.com/brettwooldridge/HikariCP/pull/2055

I have used hikari and exposed to do this in the past with postgres, although other dialects are supported.

I found one suggestion from the author of HikariCP on how to address this, which I implemented and it worked. However, there are additional classes involved, and it feels a little clunky and hard to follow.

Not really, you can change some things in spring boot but doing so will typically trigger a refresh which is less reliable than restarting but still causes a large performance hit. You could probably do it with hikari if you really needed to but it's inadvisable to build your application around this mechanic.

# https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing

Not familiar with Python but this thread about a Java connection pool might be interesting: https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing

Whatever you choose, presuming your app is database heavy, I highly recommend spending time on DB schema design to make all queries as short as possible, avoid relying on transactions, and keep your connection pool tiny. For reference: https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing

You reminded me of the HikariCP library and it’s documentation: Clear and simple with references to other libraries trying to accomplish the same thing. It is not in the closure space though.

https://github.com/brettwooldridge/HikariCP