Posts

Introduction to MariaDB Oracle Mode

MariaDB Oracle Mode is a compatibility feature designed to facilitate the migration of applications from Oracle Database to MariaDB.

Basic Usage of MariaDB in a Golang Application

In this article, we’ll explore the fundamental aspects of using MariaDB in a Go application, including establishing a database connection, retrieving data, inserting records, and updating data.

Basic Usage of MongoDB in a Golang Application

In this article, we’ll explore the fundamental aspects of using MongoDB in a Go application, including connecting to a MongoDB database, performing CRUD (Create, Read, Update, Delete) operations, and handling BSON (Binary JSON) data.

How to connect to MySQL 8 in a Helidon project?

This article shows how to connect to MySQL 8 in a Helidon project.

How to connect to MySQL 8 in a Micronaut project?

This article shows how to connect to MySQL 8 in a Micronaut project.

How to connect to MySQL 8 in a Quarkus project?

This article shows how to connect to MySQL 8 in a Quarkus project.

How to connect to MySQL 8 in a Spring boot project?

This article shows how to connect to MySQL 8 in a Spring boot project.

The database URL string used to connect to a MySQL database

This article shows how to use the jdbc database URL string used to connect to a MySQL database.

How to connect to MySQL8 in a Java Maven project?

This article shows how to connect to a MySQL 8 database in a Java Maven project.

How to connect to MySQL in Java

This article show you how to connect to a MySQL database in Java.

How to truncate text and append ellipsis in MariaDB

This article shows a technique for truncating text and appending ellipses in MariaDB.

Subtract minutes from a datetime value in MariaDB

This article implements several examples of subtracting minutes from a MariaDB datetime value.

Subtract hours from a datetime value in MariaDB

This article implements several examples of subtracting hours from MariaDB datetime values.

Subtract year from date value in MariaDB

This article gives an example of subtracting a year from a given date in MariaDB.

Subtract a day from a date value in MariaDB

This article gives an example of subtracting one day from a given date in MariaDB.

Show all locales in MariaDB

This article describes the method used to display all regional locales in MariaDB.

How to set named time zones in MariaDB

This article describes the steps to set up named time zones in MariaDB.

How to Set up automatic vertical output for MariaDB

This article discusses how to set the MariaDB command-line client to automatically verticle output.

How to get month and day name in different languages ​​in MariaDB

This article describes how to use the DATE_FORMAT()function return the month and week name in a given language.

How to get the day with a suffix in MariaDB

This article describes how to return date numbers with suffixes in MariaDB.

Use JSON_EXTRACT function to extract elements in JSON array in MariaDB

This article describes how to use the JSON_EXTRACT function extract elements in a JSON array.

How to left pad numbers with zeros in MariaDB

This article discusses how to left pad numbers with zeros with the help of the LPAD() function in MariaDB.

How to list all stored procedures in MariaDB

This article discusses two methods of listing all stored procedures in MariaDB.

How to check if a value does not contain numberical digit in MariaDB

This article provides an example for checking that a value does not contain numberical digit in MariaDB.

How to get the the month name in MariaDB

This article discusses how to use the DATE_FORMAT() function get the month name from the specified date in MariaDB.

How to get the end day of a month in MariaDB

This article discusses how to get the end day of a month using the LAST_DAY() function In MariaDB.

How to get the day name from a date in MariaDB

This article discusses how to get the day name from a specified date using the DATE_FORMAT() function.

How to generate random numbers in MariaDB

This article discusses how to use the RAND() function to generate random numbers in MariaDB.

Checks if a string contains a number in MariaDB

This article discusses how to check if a string field contains a number in MariaDB.

How to format numbers in MariaDB

This article discusses ways to format numbers in MariaDB.

Show time with AM/PM indicator in MariaDB

This article gives several ways to add AM/PM to time values ​​in MariaDB.

Convert lowercase letters to uppercase in MariaDB

This article describes two functions that convert lowercase letters to uppercase in MariaDB.

How to calculate age in MariaDB

This article describes how to calculate age using the TIMESTAMPDIFF() function.

How to Install PostgreSQL on Debian 11: A Step-by-Step Tutorial

In this step-by-step tutorial, we will guide you through the process of installing PostgreSQL on a Debian 11 system.