How to increase column size in Redshift database tables
It is only possible to alter VARCHAR columns, and only under the following circumstances:
- You can not alter a column with compression encodings …
Databases
22 articles about databases development, tools, and best practices
Entity and Referential Integrity in Relational Databases
Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.d.).
In order to achieve data integrity, it is important …
Read Article →Data Warehouses vs Data Marts
Although the terms “data warehouse” and “data mart” sound similar, they are quite different. It is important to first …
Read Article →Graph Databases and their Properties
The concept of a graph in mathematics is simply a collection of elements which are typically called Nodes and are joined together by Edges. Each Node …
Read Article →How to Install MongoDB on Mac
You can use Homebrew to install MongoDB on a Mac.
For ages you were able to simply do:
brew install mongodb, but more recently, that has stopped …
Relational (SQL) vs NoSQL Database Models
The Relational (SQL) database has been a central piece to businesses since the 1970s when they first had their claim to fame.
Experts say that the …
Read Article →When to use FLUSH PRIVILEGES in MySQL
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 …
Read Article →MySQL Community Server MSI Installer Hangs on Windows 10
I was trying to install MySQL Community Server for Windows 10 using the standard .MSI installer provded from the MySQL website and the installer just …
Read Article →A bit on SQL Standards
SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the …
Read Article →A Brief Talk on Databases
Databases have been around since ancient times, when elaborate database systems were deployed by governments, hospitals and organisations to keep …
Read Article →