Does any embedded DB support JSON datatype?

Question

I'm developing a Spring based web application with postgresql as database. I'm using JSON Datatype in postgresql. I have configured the entity with hibernate custom user type to support JSON Datatype.

Now i want to test my DAO objects using any embedded DB. Is there any embedded DB that support JSON data type which can be used in spring application.

Answer 1

When you use database specific features - like JSON support in PostgreSQL, for safety you have to use the same type of database for testing. In your case you want to test your DAO objects:

• assume that PostgreSQL is installed on localhost and make sure that it is the case for all environments where tests run
• or even better - try using otj-pg-embedded which downloads and starts PostgreSQL for JUnit tests (I haven't used it in real life projects)

Update

If you are able to run Docker in your test environment instead of embedded databases use real Postgres via TestContainers