How to clone a table structure in MySQL
April 27, 2021
I have often needed to clone a table without it’s data in MySQL.
Read More
pt-online-schema-change Add Index
March 19, 2021
Percona has a great toolkit that allows you to perform schema changes on a MySQL or MariaDB database without any downtime, it works by creating a new table with the same schema, making the changes to it and applying triggers for insertion, deletion and all updates, all while performing your valuable schema updates for you!
Read More
The Relational Database Model
June 17, 2020
Relational databases first made an appearance in the mid-1970s, between the years 1974 and 1977 with the creation of Ingres and System R which led to the creation of MS SQL Server, Sybase, Wang?
Read More
Product Update: ADD becomes Serengeti
June 9, 2020
As a product update; The “Autonomous Distributed Database”, otherwise known as simply ADD has been renamed to Serengeti.
Read More
All About Distributed Databases
May 26, 2020
A database “is a structured collection of data. Card indices, printed catalogues of archaeological artefacts and telephone directories are all examples of databases”.
Read More
Distributed Database Systems Observations
May 12, 2020
Traditional database systems were a centralised powerful database server that housed all operations pertaining to the database.
Read More
Top-down vs Bottom-up Database Design
May 9, 2020
There are essentially two different approaches one can take when designing databases; these, from a high-level analytic point of view, narrow down to what is typically called “Top-down” and “Bottom-up” philosophies or methods.
Read More
Relational Database Proprietary Extensions
May 2, 2020
Standard Query Language – or SQL for short – is a language designed for relational databases that allows end users such as developers and database administrators (DBAs) to manipulate data.
Read More
Locks used in Database Management Systems
May 1, 2020
Database Management Systems (DBMS?) are designed to store any amount of data that can then be retrieved or manipulated at a later date.
Read More
Resolving InsufficientPrivilege Errors in Redshift
April 26, 2020
If you are getting the mysterious error: [ERROR] InsufficientPrivilege: permission denied for schema errors
Read More
How to increase column size in Redshift database tables
April 25, 2020
It is only possible to alter VARCHAR columns, and only under the following circumstances:
Read More
Entity and Referential Integrity in Relational Databases
April 23, 2020
Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.
Read More
Data Warehouses vs Data Marts
April 22, 2020
Although the terms “data warehouse” and “data mart” sound similar, they are quite different.
Read More
Graph Databases and their Properties
April 20, 2020
The concept of a graph in mathematics is simply a collection of elements which are typically called Nodes and are joined together by Edges.
Read More
How to Install MongoDB on Mac
January 4, 2020
You can use Homebrew to install MongoDB on a Mac.
Read More
Relational (SQL) vs NoSQL Database Models
February 4, 2018
The Relational (SQL) database has been a central piece to businesses since the 1970s when they first had their claim to fame.
Read More
When to use FLUSH PRIVILEGES in MySQL
December 6, 2017
So if you’ve ever created users and given them specific permissions from with SQL or the commandline, you will be familiar with a statement called FLUSH PRIVILEGES.
Read More
MySQL Community Server MSI Installer Hangs on Windows 10
December 6, 2017
I was trying to install MySQL Community Server for Windows 10 using the standard .
Read More
A bit on SQL Standards
November 12, 2017
SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the International Organisation for Standardisation (ISO) which is affiliated with the International Electrotechnical Commission (IEC).
Read More
A Brief Talk on Databases
October 29, 2017
Databases have been around since ancient times, when elaborate database systems were deployed by governments, hospitals and organisations to keep track of vast amounts of information; but only until around the 1960s did computerised databases start to take shape and become cost effective for private organisations to start using (Quickbase, n.
Read More