This post shows how to use Rust Rocket SQLX for MySQL for basic CRUD (Create, Retrieve, Update, and Delete) operations. Prerequisites For Building the Rust Application Based on Rocket We used the following items for this post. Rust Stable –
Rust – Connect to MySQL And Query For Data
This post is about connecting to MySQL from Rust.
Migrate from MySQL to PostgreSQL Using Pgloader Docker Container
This post shows how to migrate a database from MySQL to a PostgreSQL instance running on Windows using the pgloader (running as a Docker container) to perform the migration from MySQL to PostgreSQL. From within the container, we use docker.for.win.localhost
Aggregate gathered number of units using MySQL With Rollup
Aggregate gathered number of units using MySQL’s With Rollup
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.
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.
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.
How to connect Java to MySQL using JDBC
This post shows how to connect Java to MySQL using JDBC. Therefore, nothing fancy here. Just JDBC basics. MySQL JDBC Requirements We used the following items for this post. Although we can use newer versions, the Java JDBC codes pretty
Spring Boot Call Stored Procedure With Spring Data @Procedure
Although most applications use SQL statements, we may need to call stored procedures instead. For instance, we could reuse existing stored procedures instead of crafting new codes. As a result, we do not need to create new test cases, and
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 it as soon as possible. One reason is you cannot