Firebird Open Source Database Quick Start (froscon2023)

Published: Aug. 6, 2023, 3:45 p.m.

b'1. The Firebird licenses\\n2. Installing Firebird\\n3. Version 2.5/3.0/4.0/5.x\\n4. Server modes\\n5. Installing on Windows.\\n6. Installing on Linux \\n7. Server configuration and management\\n8. Administration tools\\n9. Working with databases\\n10. Connection strings\\n11. Connecting to an existing database\\n12. Connecting with isql\\n13. Connecting with a GUI client\\n14. CREATE DATABASE \\n15. User management and grants\\n16. SYSDBA\\n17. Firebird SQL DDL Basics\\n18. Tables and other Metadata Objects\\n19. Firebird SQL DML Basics\\n20. Backup.\\n21. The Firebird Project.\\n\\nFeatures\\nThe open source Firebird\\xae relational database management system performs excellently and scales impressively, from an embedded, single-user model to enterprise-wide deployments with multiple Tb+Gb databases running with hundreds of simultaneous clients.\\n\\nSupport of all major platforms and operation systems\\n \\nOS\\tFirebird 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.\\nFirebird is included into the following Linux repositories: Fedora, OpenSuse, CentOS, Mandriva, Ubuntu.\\nMulti-generation architecture\\n\\nOne 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.\\n\\nPowerful and developer-friendly SQL language\\n\\nFirebird supports stored procedures and triggers, and has comprehensive SQL92 support.\\nHigh compatibility with ANSI SQL\\nCommon Table Expressions (CTE)\\nFlexible transactions management\\nFull-blown stored procedures (selectable SP enables joins w/tables)\\nCross-database queries\\nActive tables concept and events\\nUser Defined Functions\\nactive tables\\n\\nLogging and monitoring\\n\\nFirebird offers Trace API and rich set of monitoring tables (MON$)\\nReal-time monitoring\\nSQL debugging\\nAudit\\nEvents\\nPartial or full logging\\nThrough remote connection\\nmonitoring \\n\\nsecurity\\n\\nStandard security\\nUsers and roles\\nGRANT/REVOKE on main operations\\nDatabase owner concept\\nWindows Trusted Authentication\\nSingle-sign on for end-users\\nIntegration with Windows domain/Active Directory security\\nNetwork\\nThe only network port should be open (3050 by default, configurable)\\nAliases (path to the database is not exposed)\\nDeveloper Tools\\n \\n\\tFirebird is supported by numerous database connectivity options:\\nFirebird.NET\\nJayBird (Java)\\nDelphi/C++ Builder drivers (Embarcadero Delphi/C++ Builder IDEs include dbExpress drivers to work with Firebird.)\\nFreePascal & Lazarus\\nPHP for Firebird\\nFireRuby\\nand more!\\n\\nMore features\\n\\nTrue Open Source\\n\\nFirebird 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.\\n\\nDeployment\\nEmbedded version (in dll) with multi-user support\\nNative Windows installer available, localized in most popular languages\\nRun as service or as application\\nRPM or tar.gz distributions available\\nAbility to create custom \\u201c100% silent\\u201d installers\\nRead-only deployments (database and server can be on CD, DVD, Blu-Ray, etc)\\nSmall footprint (minimal installation is 4Mb, standard is 33Mb)\\nPerformance\\nChoice of architectures to fit all needs \\u2013 Embedded, SuperServer, SuperClassic and Classic\\nMulti-CPU and multi-core SMP scalability for SuperClassic and Classic architecures\\nDatabase up to 20 Terabytes supported\\nThread-Safe Client Library\\nBackup and restore\\nOnline backup \\u2013 ability to create backup copy without stopping database\\nOnline dump \\u2013 ability to quickly create copy even for very big database\\nIncremental backup \\u2013 partially supported Point-In-Time Recovery\\nFull Text Search\\nIntegration with Sphinx, Full Text Search Engine\\nHigh compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.\\n\\nThe mix of high performance, small footprint, supreme scalability, silent and simple installation and 100% royalty-free deployment make Firebird a highly attractive choice for all types of software developers and vendors.\\n\\nIt is used by approximately 1 million of software developers worldwide.\\n\\nFirebird works\\nabout this event: https://programm.froscon.org/2023/events/2871.html'