Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Most applications need some form of persistence—a way to store the data outside the application for safekeeping. The most basic way is to write data to the file system, but that can quickly become a ...

If you’ve worked with relational database systems for any length of time, you’ve probably participated in a discussion (argument?) about the topic of this month’s column, surrogate keys. A great ...

PostgreSQL compatibility is a no-brainer for any modern database offering a unique feature set. Every modern database vendor is now offering some level of compatibility to reach developers and ...