Recently, we got a request to create an analytics dashboard for the application’s data we have. The data was stored within PostgreSQL and our initial idea was to build a queries which would drive these dashboards.
-
posts
-
Elasticsearch and Near Real Time Analytics
-
PostgreSQL, JSON and Hibernate
If you ever worked on a project which use SQL database, there is a possibility that in one point of time you’ve added a text column where you stored arbitary JSON data. This may be usefull when you have lot of metadata to store which is not used by system and is not very important.