Continue to use ClickHouse as TSDB 邰翀 青云QingCloud 数据库研发工程师 ► Look back: Why we choose it ► Now: How we do ► Future: What we do Content Why we choose it Why we choose it Why we choose it

Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Contents 1 Chapter 1. Introduction The purpose of 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 everyone who has contributed to the manual. Chapter 1. Introduction 2 Chapter 2. Database Structure When you create a new database, be it single or multiple file, a number of things happen: • The database

Firebird Generator Guide A guide on how and when to use generators in Firebird Frank Ingermann Version 0.3, 27 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . Basics 2.1. What is a generator? Think of a generator as a “thread-safe” integer counter that lives inside a Firebird database. You can create one by giving it a name: CREATE GENERATOR GenTest; Then you easy to “predictably” set it directly to a certain value and then obtain that same value — it’s inside the database, but outside of transaction control. 2.2. What is a sequence? “Sequence” is the official

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 4.1. Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.1.3. Conditional Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 4.1.4. NULL in Expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 6.1.16. Common Table Expressions (“WITH … AS … SELECT”) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 312 6.2. INSERT

...............................................................................36 4.2. Value Expressions............................................................................................... ..........................................................................40 4.2.7. Aggregate Expressions........................................................................................40 4.2.8 .........................................................................44 4.2.10. Collation Expressions .......................................................................................44 4.2.11

...............................................................................32 4.2. Value Expressions............................................................................................... ..........................................................................36 4.2.7. Aggregate Expressions.................................................................................36 4.2.8. Window .........................................................................39 4.2.10. Collation Expressions ................................................................................40 4.2.11. Scalar

...............................................................................36 4.2. Value Expressions............................................................................................... ..........................................................................40 4.2.7. Aggregate Expressions........................................................................................40 4.2.8 .........................................................................43 4.2.10. Collation Expressions .......................................................................................44 4.2.11

...............................................................................32 4.2. Value Expressions............................................................................................... ..........................................................................36 4.2.7. Aggregate Expressions.................................................................................36 4.2.8. Window .........................................................................39 4.2.10. Collation Expressions ................................................................................40 4.2.11. Scalar

...............................................................................36 4.2. Value Expressions............................................................................................... ..........................................................................40 4.2.7. Aggregate Expressions........................................................................................40 4.2.8 .........................................................................45 4.2.10. Collation Expressions .......................................................................................45 4.2.11

...............................................................................32 4.2. Value Expressions............................................................................................... ..........................................................................36 4.2.7. Aggregate Expressions.................................................................................37 4.2.8. Window .........................................................................41 4.2.10. Collation Expressions ................................................................................41 4.2.11. Scalar