## C++20 ♥ SQL John R Bandela, MD ## Overview SQL C++ Example Implementation techniques fixed_string meta_struct Parsing compile time strings into meta_structures  ## Overview SQL C++ Example Implementation Techniques https://github.com/google/cpp-from-the-sky-down/tree/master/meta_struct_20/cppcon_version ## SQL Probably the highest level mainstream HOPE YOU'RE HAPPY. AND I HOPE YOU'VE LEARNED TO SANITIZE YOUR DATABASE INPUTS. ## Avoiding SQL Injection Attacks SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON

 Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 ## Table of Contents 1. Introduction this document is to try to explain what goes on inside a Firebird database. Much of the information in this manual has been extracted from the Firebird source code — mainly on the ODS related code and headers patiently answered on the Firebird Support forums where the developers hang out. Much hex dumping of database files was undertaken in the creation of this document, but no Firebird databases were harmed during

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . ISC_PASSWORD Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 11. SQL Dialects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 18.18. SET SQL DIALECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1880ebc897/p1_1.jpg) # Firebird Database Cache Buffer Norman Dunbar, Martin Köditz Version 1.2, 28 May 2020 ## Table of Contents 1. Introduction ..... 2 2. The Firebird Cache ..... 3 3. Using Appendix A: Document history ..... 9 Appendix B: License notice ..... 10 ### Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to each time they are required. The following description of how Firebird uses its cache is taken from a posting by Ann Harrison on the Firebird Support mailing list. The posting was in response to a query

 # Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 ## Table of Contents 1. Introduction split large backup files even if gsplit is supplied with your Firebird release. Gsplit is only supplied with the Windows version of Firebird 1.5, it is not supplied with the Linux version. Linux doesn’t [Image](/uploads/documents/9/e/a/9/9ea98a65d2d4276aba4484f6ca6593e8/p3_2.jpg) In testing with Firebird 1.5 and Firebird 2.0 on Windows XP Home and Windows 2000, gsplit doesn’t seem to work properly and always

 # Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 ## Table of Contents 1. Introduction ..... 2 various Firebird databases. Using various options, users can be added, amended or deleted from the security database. A privileged user is an account on the database server which the Firebird engine considers • root • firebird • interbase • interbas (without the 'e') Normal users, ie all those accounts not listed above, can only see their own user details from version 2.0 of Firebird. They can,

 # Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 ## Table of Contents .... 27 11.2. Starting a Database ..... 28 11.3. New Startup and Shutdown States in Firebird 2.0 ..... 28 12. Database Page Space Utilisation ..... 30 13. Database Validation and Recovery -? switch, results in the following screen of helpful information: gfix usage instructions for Firebird 3.0.7 usage: gfix [options] plausible options are: -ac(tivate_shadow) activate shadow