Category: Databases

Okay folks, this is going to be a short one! Sometimes you may want to reset a PostgreSQL sequence, for instance after removing data from a tabel. You can do…

Read More Resetting PostgreSQL Sequence

PostgreSQL

If you have ever needed to calculate the age of someone based on their date of birth, then you might have been left puzzled at first. Many people seem to over complicate things, so in this article, a simple function is provided to convert dates to ages.

Read More Calculate Age From Date of Birth in MySQL

MySQL

The primary index is essential in databases. In this article, we present the main characteristics of the primary index along with its problems and solutions. A primary index physically orders the records on the secondary storage device to speed up the retrieval of data records. The index is sparse or non-dense because it only contains a block pointer for each block in the data file.

Read More Primary Index

Database Theory