How to Init Databases With Quarkus

While developing Quarkus applications that use relational databases, we usually need to control or set the database schema and initial data. There are several approaches in Quarkus, including the dev services, and in this video we’ll see which approaches make sense for an efficient development workflow.
More information: blog.sebastian-daschner.com/e...
Example project: github.com/sdaschner/coffee-t...
Quarkus on-demand course: www.sebastian-daschner.com/co...
Quarkus workshop (Apr 17th & 18th): www.sebastian-daschner.com/wo...

[@ferjava]

Good tips! We actually don't need Postman, plain shellscript is waaay more efficient, nice ^^

[@RafaelDurelli]

Awesome vid :D

[@manee427]

Thanks perfect video. do we have something like JPARepository in Quarkus that make most of queried available out of the box or we have to always use plain SQL?

[@SebastianDaschnerIT]

czcams.com/video/pDSKwYiV_Ns/video.html :)

[@Markosiiiiii]

Great Sebastian! I have a question. I have my query sql: " select p.* from pcr_perfil p order by( select count(ppu.id_usu_perfil) from pcr_perfil_usuario ppu where ppu.id_perfil = p.id_perfil ) asc
" that's works fine in sql. Question. How to make that query from panache quarkus? Please can anyone translate it to panache query?

[@SebastianDaschnerIT]

Well, in general you can directly execute native SQL queries, i.e. you can paste that into your code (e.g. with entity manager). But it might make sense to consider rewriting this query, in JPA query language in fact.

[@stefanholtker3944]

How about using liquibase with context / label for test environments testdata?

[@SebastianDaschnerIT]

Haven't really used it as such, but yes, can surely work. What was your experience with it?

[@chandanupadhyay-oi7vo]

Can we create only one Entity for two database ( with same attributes ) in the project

[@SebastianDaschnerIT]

Yes, that should work

[@chandanupadhyay-oi7vo]

@@SebastianDaschnerIT how can u explain... or share any github link for reference