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 –
This post is about connecting to MySQL from Rust.
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’s With Rollup
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.
This article demonstrates how to use Hibernate Entity Manager 4.3.7 in a simple application.
This article demonstrates how to use Hibernate 4.3.x with MySQL 5.6.16 in Java 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
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
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