Comparing different approaches

There are several database options available for Delphi programmers when you have the power of a desktop environment, but this isn't the case in the cross-platform arena. The two we'll look at in this chapter use very different approaches to provide database capabilities, and each has their pros and cons. First, we'll look at InterBase and its several editions.

Learning about InterBase's editions

InterBase is Embarcadero's database offering and has a long history of being a pioneer of small footprint databases requiring little management, while still providing solid performance with multiple connected users. It's renowned for being able to quickly recover from backups and provides 256-bit encryption, role-based security, scalable replication with change views, robust transactional support, and strict compliance with SQL standards. Its rich language supports building complex stored procedures and triggers with generators...