SQL
-
Core Java
Converting Between LocalDate and SQL Date In Java 8
A quick guide to convert between LocalDate and java.sql.Date objects in java 8 with examples. 1. Overview In this tutorial,…
Read More » -
Software Development
Use the Power of your Database: XML and JSON
Today databases have a lot of functionality that is often not used by software developers because they simply not know…
Read More » -
DevOps
Run a docker PostgreSQL instance locally for Testing
Running a PostgreSQL instance ad-hoc for testing is not always as bootstraping as it should be. This blog will run…
Read More » -
Software Development
SQL GROUP BY and HAVING Example – Write SQL Query to find Duplicate Emails – LeetCode Solution
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email |…
Read More » -
Enterprise Java
[MEGA DEAL] The Ultimate SQL Bootcamp Certification Bundle (98%)
Manage Tasks & Databases Like a Pro with 6 Courses on SQL Lite, Microsoft SQL, MySQL, PostgreSQL, Rest API, and…
Read More » -
Enterprise Java
SQL as a Service
I’ve been thinking about this since 2007, somewhere around the time S3 was launched by Amazon. I even tried to…
Read More » -
Enterprise Java
Read replicas and Spring Data Part 4: Configuring the read repository
Previously we set up two EntityManagers in the same application. One for the reads and one for the writes. Now…
Read More » -
Enterprise Java
Read replicas and Spring Data Part 3: Configuring two entity managers
Our previous setup works as expected. What we shall do now is to get one step further and configure two…
Read More » -
Enterprise Java
Read replicas and Spring Data Part 2: Configuring the base project
In our previous post we set up multiple PostgreSQL instances with the same data.Our next step would be to configure…
Read More »
