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

Host multiple databases in a HSQLDB server

On this post, we’ll host multiple databases in a single HsqlDB server running locally on a Windows machine. The following are additional details about the Software application used. [wp_ad_camp_5] 1.

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 connect to PostgreSQL using JDBC

This article demonstrates how to connect to Postgres using JDBC.

Read More...

Software Development

How to use Hibernate with simple JDBC application

This article demonstrates how to use Hibernate 4.3.x with MySQL 5.6.16 in Java using JDBC.

Read More...

Software Development

How to List a Specific number of Random Rows in MySQL

Let’s say you have a list of 10 items you want to display but these items are randomly chosen items. In MySQL, you use the rand() function in the ORDER BY clause. This article demonstrates how to list a specific number of random rows my MySQL.

Read More...

Software Development

How to determine the current size of a MySQL Database

Background [wp_ad_camp_1] Sometimes you may need to limit the size of a particular MySQL specially for demo applications. Limiting the size of a database requires determining its current size before

Read More...

Software Development

SQL Update on a Date Column in Informix

If I had my way, Java applications that do not to directly access, e.g., file-based inter-application one-way communication, legacy systems written in Informix 4GL will use other RDBMS’s that are modern, robust, scalable, and cheaper instead of reusing a fossil. This is just one among many ways to escape a vendor lock-in. Slowly but surely.

Read More...

MySQL, Software Development

Top n values without using a limit clause or its equivalent

Top n values without using a limit clause or its equivalent

Read More...

Software Development

Giving SQL SELECT Priority over SQL INSERT/UPDATEs in MySQL

Giving SQL SELECT Priority over SQL INSERT/UPDATEs in MySQL

Read More...