MySQL, PostgreSQL

Convert MySQL INSERT IGNORE to PostgreSQL

This post shows an example of the MySQL INSERT IGNORE statement in the PostgreSQL version. There are good reasons why you should use PostgreSQL at the onset or migrate to

Read More...

Rust, Software Development

Rust – Connect to MySQL And Query For Data

This post is about connecting to MySQL from Rust.

Read More...

Docker, MySQL

docker-compose.yml for MySQL For Local Development

This post provides a another basic docker-compose.yml .This time is to create a MySQL container with initial user accounts.

Read More...

Ruby, Ruby Tutorial

Ruby – Connect to MySQL without Rails

This post demonstrates how to connect to MySQL from Ruby, insert, select and delete table rows.

Read More...

Software Development

MySQL JSON Type

MySQL has started supporting JSON column data type since MySQL 5.7.8. This post explores this new type and its basic usages.

Read More...

Software Development

Call Stored Procedure using Spring Data and @Procedure

This post demonstrates how to call Stored Procedure using Spring Data and @Procedure.

Read More...

Software Development

Spring Boot, JPA/Hibernate for Java EE 6 Java Persistence API Developer Certified Expert 1Z0-898

If you are planning to take Java EE 6 Java Persistence API Developer Certified Expert (1Z0-898), this post is for you. It demonstrates how to create a sample application using Spring Boot, and JPA/Hibernate to aid in your study.

Read More...

Java, Software Development

Using @Query to execute a MySQL function

Using @Query to execute a MySQL function as follows. Here is an example that uses Spring Data @Query to execute a MySQL function that returns a string value. Let’s say

Read More...

Software Development

How to use Hibernate JPA in a simple Application

This article demonstrates how to use Hibernate Entity Manager 4.3.7 in a simple application.

Read More...

Software Development

How to use @ManyToMany in JPA

This article demonstrates how to use @ManyToMany in JPA using Hibernate JPA.

Read More...