Menu

Articles

How to use the MySQL CONVERT_TZ() function

The CONVERT_TZ() function in MySQL converts a datetime value from one time zone to another. This allows converting datetimes between different timezones.

PostgreSQL CRUD Tutorials in Ruby/Rails: A Step-by-Step Guide

In this tutorial, we will explore how to perform CRUD (Create, Read, Update, Delete) operations with PostgreSQL using Ruby on Rails.

How to Install MariaDB on Oracle Linux 7 (Legacy Guide)

Legacy MariaDB guide for Oracle Linux 7; Extended Support began in January 2025 and requires an Oracle support entitlement.

How to use the MySQL CHAR() function

The CHAR() function in MySQL returns the character corresponding to an ASCII code value. It is useful for converting ASCII codes to their character representation.

Oracle CRUD Tutorials in Ruby/Rails: A Step-by-Step Guide

In this tutorial, we will explore how to perform CRUD (Create, Read, Update, Delete) operations with Oracle Database using Ruby on Rails.

How to use the MySQL ASCII() function

The ASCII() function in MySQL returns the ASCII code value of the leftmost character of a string. It can be used to get the ASCII value of alphanumeric and other characters.

MySQL CRUD Tutorials in Ruby/Rails: A Step-by-Step Guide

In this tutorial, we will explore how to perform CRUD (Create, Read, Update, Delete) operations with MySQL using Ruby on Rails.

How to Install MariaDB on macOS with Homebrew

Install MariaDB Server on macOS with Homebrew, start it as a login service, connect through the local account, and create a restricted application user.

How to use the MySQL ADDTIME() function

The ADDTIME() function in MySQL is used to add a time interval to a time value and return a new time value. It is useful for calculating future or past times based on a start time and a time interval to add.

MongoDB CRUD Tutorials in Ruby/Rails: A Step-by-Step Guide

In this tutorial, we will explore how to perform CRUD (Create, Read, Update, Delete) operations with MongoDB using Ruby on Rails.