Kotlin library to request postgres with native SQL queries
This library allows you to make sql requests and return the result in json format, then deserialize it into an entity. It also allows you to save an entity (INSERT) by serializing it and sending the json to the database, allowing you to insert several entities with their children, in a single request.
It also manages the migrations of the schema of tables and stored procedures.
All sql requests are handled manually for full control over what you do.
- Total control of all Postgresql features and SQL language
- More speed and flexible than an ORM
- Multi level request (Can return multiple tables and these children in a single request)
- Queries are written in separate native
.sqlfiles - Unit testing of SQL queries
- Migrations are written in separate native
.sqlfiles - Automatic tested database migration and rollback
- Installation
- Migrations
- Usage
- How that works (Diagram)
- How to begin
