This powerful piece of software allows you to set up your own SQL database. Moreover, it gives you the ability to backup data and store it on external drives.
Firebird
Firebird is an open source Windows program that can be used as a relational database management system. With it, you are able to edit information, create queries and scripts. It is also possible to save backup files to external storage devices.
Setup
In order to use the main functions of this software package, you need to install the server on your hard drive. Then you can select the boot mode and specify the database name. There is also an option to run the program on system startup.
Similar to Oracle Database, this application allows you to create and manage queries in the SQL language. By default, the tool can work with data stored in multiple directories. You are also able to connect external libraries to expand the overall functionality of the database. The maximum size for an individual file is 64 terabytes.
Controls
You can create stored procedures. They are basically sets of SQL statements. With their help, you are able to perform various calculations and operations on character data. Additionally, it is possible to add triggers that are automatically activated when a certain event occurs. The function of backing up and writing data to external media is also available.
Features
- free to download and use;
- compatible with modern Windows versions;
- can be used for managing relational databases;
- it is possible to extend its functionality by downloading additional libraries;
- relies on SQL programming language;
- allows you to backup necessary data.