The Relational Database Model
With relational database systems, you use tables to store and manage information. This sounds simple but involves quite complex concepts such as normal forms, key relationships, and JOINs. This article will introduce the basics of the relational database model, compare its advantages and disadvantages, and delimit this type of data storage from alternative approaches, like object databases,…
The Relational Database Model
What are CLOBs (Character Large Objects)?
Databases normally save information in database blocks. The size of the data plays a key role here: Especially large data objects that exclusively comprise strings are saved as CLOBs (Character Large Objects) or TEXT and are usually stored with a reference. Read the following article to find out what’s behind the CLOB data type as well as the advantages and disadvantages it provides.
What are CLOBs (Character Large Objects)?
Columnar Database
Databases are usually based on rows of data. Columnar databases turn this system on its side. Instead of saving each entry one after the other, in a columnar database entries are stored category by category. This results in a decisive speed advantage when working with massive quantities of data. But how exactly does a column-oriented DBMS work?
Columnar Database
How do Document Stores work?
Almost every application utilizes databases in one form or another. Besides classic relational databases, document-oriented databases have also become well-established in the course of the development of web apps. Instead of working with complex tables, these document stores use semi-structured data in simple documents. But how exactly does this work?
How do Document Stores work?REDPIXEL.PLShutterstock
Prepared statements in PHP: Basics and examples
In order to improve the performance of repeated SQL queries and also significantly reduce the risk of manipulation in database access, you can take advantage of prepared statements in PHP and other programming languages. But how does this work, and how can you use prepared statements for managing your database systems?
Prepared statements in PHP: Basics and examples
PostgreSQL vs. MySQL
Many web developers will already be familiar with MySQL as a relational database management system (RDBMS). Those managing more professional projects may be aware of its powerful competitor PostgreSQL. But did you know the latter is an object-relational database management system (ORDBMS)? Find out what this difference means in practical terms.
PostgreSQL vs. MySQL