Databases

How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04

A MySQL transaction is a group of logically related SQL commands that are executed in the database as a single unit. Transactions are used to enforce ACID (Atomicity, Consistency, Isolation, and Durability compliance in an application. This is a set of standards that govern the reliability of processing operations in a database. In this tutorial, you will use the PDO PHP Extension, which provides an interface for working with databases in PHP, to perform MySQL transactions.

Read more
How To Manage and Use MySQL Database Triggers on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Manage and Use MySQL Database Triggers on Ubuntu 18.04

In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and is destroyed once a table is dropped. You can specify a trigger action time and set whether it will be activated before or after the defined database event. In this tutorial, you’ll create, use, and delete different types of triggers on your MySQL database.

Read more
How To Use PostgreSQL with Your Ruby on Rails Application on macOS — step-by-step Databases tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on macOS

When using the Ruby on Rails web framework, the PostgreSQL database could be a robust and flexible choice for your application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on a local macOS machine. You will install and configure PostgreSQL, and then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
CHAT