[Extension Proposal] SQLite4j JDBC - sqlite in pure java

[andreaTP]

Description

We already have an extension in the Quarkiverse leveraging the stable and mature xerial/sqlite-jdbc driver: quarkus-jdbc-sqlite.

I just finished the port of the driver to pure Java leveraging Chicory, you can find the relevant repo here.
In the "Design decisions" section there is a collection of motivations that makes the two drivers "different enough" to be alternatives depending on the environment.

I initially explored sending a PR to the current extension, even having received an answer, I'm now convinced that the two projects are different enough and people would not be happy to switch the JDBC driver without them knowing.

Repository name

quarkus-sqlite4j

Short description

SQLite driver for Quarkus with Agroal in pure Java built on SQLite4j

Repository Homepage URL

https://docs.quarkiverse.io/quarkus-sqlite4j/dev/

Repository Topics

• quarkus-extension

...

Team Members

• @andreaTP

Additional context

I prepared a ready to ship (🤞) repository under my account that can be easily transferred preserving attributions:

https://github.com/andreaTP/quarkus-sqlite4j

[quarkus-bot]

/cc @aloubyansky (extension-proposal), @barreiro (jdbc), @gastaldi (extension-proposal), @gsmet (extension-proposal), @maxandersen (extension-proposal)

[Sanne]

Awesome, thanks @andreaTP !

[yrodiere]

Great idea, the existing extension wouldn't be a great place for this given the different dependencies.

We may want to look into using conditional dependencies for the hibernate-community-dialect part... I'll see if I can get to this once I merged the PR for Derby (#41310)

[andreaTP]

oh, wow, that would be really appreciated @yrodiere !

[melloware]

+1 on this...

[gastaldi]

https://github.com/quarkiverse/quarkus-sqlite4j is now available, enjoy!

[andreaTP]

Thanks @gastaldi !

[melloware]

@gastaldi for consistency shouldn't it be quarkus-jdbc-sqlite4j to be consistent with other JDBC extensions?

[gastaldi]

@melloware ah right, I forgot about that. @andreaTP any problem if I change the repository name?

[gastaldi]

The artifact Id would probably need to be renamed as well

[andreaTP]

Oh, sorry for the delay, I have no big issues with the naming, I removed the -jdbc- infix as it's already in the groupId: io.quarkiverse.jdbc.