Databases

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.

October 19, 2021October 19, 2021

How to Install a LAMP Stack on Ubuntu 20.04

Watch out! This tutorial is over 3 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

A LAMP (Linux, Apache, MySQL, PHP) stack is a common, free, and open-source web stack used for hosting web content in a Linux environment. Many consider it the platform of choice on which to develop and deploy high-performance web apps (you can also use NGINX as your web server and MariaDB for the database, depending on speed and load requirements).

Continue reading “

May 16, 2019August 8, 2019

Accessing Your Docker Containers on your Private Network

Watch out! This tutorial is over 5 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

This tutorial follows on from Using Pre-Built Docker Container Templates and is part of a series. If this is your first time here, maybe start at the beginning.

Continue reading “

May 15, 2019September 17, 2019

Using Pre-Built Docker Container Templates

Watch out! This tutorial is over 5 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

This tutorial follows on from Creating a Docker Container from a Pulled Image and is part of a series. If this is your first time here, maybe start at the beginning.

Continue reading “

January 7, 2019

Why is Adminer better than phpMyAdmin?

Watch out! This tutorial is over 6 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

Adminer is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

Continue reading “

October 4, 2018May 13, 2019

Getting root access to new install of PHPMyAdmin

Watch out! This tutorial is over 6 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

Immediately after doing a fresh install on LAMP on a barebones Linux Server using Xen Orchestra or otherwise), you should secure your database before going into production.

Continue reading “

September 7, 2018May 13, 2019

Connect to a MySQL Server using PHP

Watch out! This tutorial is over 6 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

In this tutorial we will show you how to have a PHP Powered Web Server send/obtain data to/from a separate MySQL Database server before presenting the HTML output to the client browser.

Continue reading “

May 3, 2018May 13, 2019

How To Install LAMP in Ubuntu 18.04

Watch out! This tutorial is over 6 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

The objective of this tutorial is to install the LAMP stack (Linux, Apache, MySQL and PHP server) on Ubuntu 18.04 “Bionic Beaver”, which is now available in the ITLC’s Xen Orchestra sandbox as a “Quick Instance”.

Continue reading “

April 25, 2018May 13, 2019

Saving Data to MongoDB Database from a Node.js Application

Watch out! This tutorial is over 6 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

In this tutorial we will be creating a very simple Node application, that will allow users to input data that they want to store in a MongoDB database. You can use the the existing template in XenServer to launch a Linux machine with Node.js and MongoDB pre-installed.

Continue reading “

January 15, 2017January 18, 2017

Top 5 Databases for Web Developers

Watch out! This tutorial is over 8 years old. Please keep this in mind as some code snippets provided may no longer work or need modification to work on current systems.

When listening to developers talk about databases you will usually hear buzz words like robust, scalable, efficient, etc. Discussions will focus on the power of the DBMS (Database Management System) and how it integrates with other technologies. In our case, however, we don’t really care about most of those things. Instead we are going to be looking at the cost of getting started, tools, the user interface and availability of help, especially help for the beginner.

In the following list we’ll talk briefly about each DBMS, give you some pros and cons, and show you how to download and get started with each of them.

Continue reading “