Open ia3andy opened 1 month ago
Zulip discussion (https://quarkusio.zulipchat.com/#narrow/stream/187038-dev/topic/Json.20File.20JDBC.20driver) abstract:
Title: Implementing a JDBC Driver for JSON File Storage
Description:
Andy Damevin is exploring the possibility of using a JDBC driver to access and manipulate data stored in human-readable text files (preferably JSON) synchronized through Git. The goal is to allow easy data editing and storage in a format that supports version control and diffing, without requiring an additional runtime process.
Key Points:
Discussion Highlights:
Next Steps:
Links:
Feel free to provide additional input or alternative solutions for efficiently managing and syncing human-readable file-based data storage through JDBC.
"Find a way to use hibernate to query and use data from a file store" - what is the queries you are after doing?
This is a good example: https://github.com/FroMage/RivieraDEV-Quarkus/tree/main/src/main/java/model
@ia3andy can you point a bit more specific - I browsed around and didn't find any queries - just a model easy to iterate on.
What I would do is:
Possibly using H2.
Did I mention I have a JSON import/export for ORM in 🦊? 😇
It would store the data as a file synchronised with git. This would allow querying the data and use it in the app that gets generated as a static website.
The prerequisite is to have something easy to run in a CI (like github action) and that gives readable diffs for git.