My Blog

Firebird on cloud

1-click AWS Deployment    1-click Azure Deployment



Overview

Firebird is a powerful and lightweight open source SQL relational database management system for Windows and Linux. Features include full support for stored procedures and triggers, full ACID compliant transactions, incremental backups and multiple access methods (e.g. native/API, ODBC, OLEDB, .NET, Python, PHP and Perl).

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows and a variety of Unix platforms. Firebird offers excellent concurrency, high performance and powerful language support for stored procedures and triggers.

Firebird is owned by Firebird (https://firebirdsql.org/) and they own all related trademarks and IP rights for this software.

Firebird is a fully featured and powerful RDBMS. It can handle databases from just a few KB to many Gigabytes with good performance and almost free of maintenance!

Firebird on Cloud runs on Amazon Web Services (AWS) and Azure and is built to offer many ANSI SQL standard features that runs on Linux, Windows and a variety of Unix platforms.

Cognosys provides hardened images of Firebird on all public cloud i.e. AWS marketplace and Azure.

Firebird on cloud for AWS

Features

Major Features Of Firebird

1.Support of all major platforms and operation systems

  • Firebird supports a number of hardware and software platforms: Windows, Linux, MacOS, HP-UX, AIX, Solaris and more.
  • It runs on at x386, x64 and PowerPC, Sparc and other hardware platforms and supports an easy migration mechanism between these platforms.
  • Firebird is included into the following Linux repositories: Fedora, OpenSuse, CentOS, Mandriva, Ubuntu.

2.Multi-generation architecture

  • One of the key Firebird features is its multi-generational architecture, which enables the development and support of hybrid OLTP and OLAP applications.
  • This makes a Firebird database capable of serving simultaneously as both an analytical and an operational data store, because readers do not block writers when accessing the same data under most conditions.

3.Powerful and developer-friendly SQL language: Firebird supports stored procedures and triggers and has comprehensive SQL92 support.

  • High compatibility with ANSI SQL
  • Common Table Expressions (CTE)
  • Flexible transactions management
  • Full-blown stored procedures (selectable SP enables joins w/tables)
  • Cross-database queries
  • Active tables concept and events
  • User Defined Functions

4.Logging and monitoring: Firebird offers Trace API and rich set of monitoring tables (MON$)

  • Real-time monitoring
  • SQL debugging

5.Security: 

a)Standard security

  • Users and roles
  • GRANT/REVOKE on main operations
  • Database owner concept

b)Windows Trusted Authentication

  • Single-sign on for end-users
  • Integration with Windows domain/Active Directory security

c)Network

  • The only network port should be open (3050 by default, configurable)
  • Aliases (path to the database is not exposed)

6.Developer Tools(Firebird is supported by numerous database connectivity options)

  • Firebird.NET
  • JayBird (Java)
  • Delphi/C++ Builder drivers (Embarcadero Delphi/C++ Builder IDEs include dbExpress drivers to work with Firebird.)
  • FreePascal & Lazarus
  • PHP for Firebird
  • FireRuby
  • and more!

7.More features

True Open Source: Firebird is free for commercial and educational usage: no license fees, installation or activation restrictions. No double licensing – Firebird license is based on Mozilla Public License.

8.Deployment

  • Embedded version (in dll) with multi-user support
  • Native Windows installer available, localized in most popular languages
  • Run as service or as application
  • RPM or tar.gz distributions available
  • Ability to create custom “100% silent” installers
  • Read-only deployments (database and server can be on CD, DVD, Blu-Ray etc)
  • Small footprint (minimal installation is 4Mb, standard is 33Mb)

9.Performance

  • Choice of architectures to fit all needs – Embedded, SuperServer, SuperClassic and Classic
  • Multi-CPU and multi-core SMP scalability for SuperClassic and Classic architecures
  • Database up to 20 Terabytes supported
  • Thread-Safe Client Library

10.Backup and restore

  • Online backup – ability to create backup copy without stopping database
  • Online dump – ability to quickly create copy even for very big database
  • Incremental backup – partially supported Point-In-Time Recovery.

AWS


Note: How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

1) Connect to the virtual machine using following RDP credentials:

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .

Step 2) Click the Windows “Start” button and select “All Programs” and then point to  Firebird (Run the setup on desktop so that the default Firebird instance is properly setup)

Step 3) Other Information:

1.Default installation path: will be in your root folder “C:\program files\FireBird3.0.1”

2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

AWS Step by Step Screenshots

Videos

Firebird on cloud

Related Posts