Lorenzo Alberton

London, UK   ·   Contact me   ·  

« Articles

Firebird 2 cheat sheet

Abstract: Cheat sheet for the upcoming Firebird 2. A handy reference of the FB2 datatypes, an useful query reference and a list of the PHP Firebird/Interbase functions.

Since I couldn't find a Firebird SQL cheat sheet, I wrote one, listing useful information about the upcoming Firebird 2 external link such as its data types, its internal and UDF functions, and the php ibase functions.

Update 08-11-2006: thanks to Carlos H. Cantu and Ivan Prenosil for their suggestions. I have updated the cheat sheet accordingly.

A detailed description of the cheat sheets follows, and you can start downloading them here:

Firebird SQL Cheat Sheet - Details

Firebird SQL cheat sheet - Data types The cheat sheet is organized in 5 sections. The first section contains a list of the available data types, their description and the range of values that each of them supports.

Firebird SQL cheat sheet - Internal functions The second section contains a list of the Internal functions. The ones listed here are the Firebird 2 built-in functions; they're grouped by field of interest (aggregate, conditional, string functions).

Firebird SQL cheat sheet - Default UDF functions The third section contains a list of the Default UDF functions. Firebird bundles an UDF library with some useful functions not included in the core. These functions are listed here, grouped by field of interest (mathematical and string functions).

Firebird SQL cheat sheet - Useful queries The forth section contains some useful queries, like the most useful queries to manage TRANSACTIONs, SAVEPOINTs, SEQUENCEs, a sample query with a "LIMIT / OFFSET" clause, and some queries against the System Tables to retrieve a list of the tables, fields, indices and constraints.

Firebird SQL cheat sheet - PHP functions The last section holds a list of the PHP ibase_* functions external link. PHP has a Firebird/Interbase module and this is used by PHP developers to connect to, and query, a Firebird database. This section lists the functions available in PHP for connecting to and managing a Firebird database.


If you wish to link to the Firebird SQL cheat sheet from elsewhere, rather than linking directly to the sheet please link to this page so others can find the description. Thank you.

7 responses to "Firebird 2 cheat sheet"

joe, 11 January 2011 20:30

This is one of the most incredible blogs Ive read in a very long time. The amount of information in here is stunning, like you practically wrote the book on the subject. Your blog is great for anyone who wants to understand this subject more. Great stuff; please keep it up!

Daniel, 03 February 2011 14:11

Hi Lorenzo,
just a short inquiry: How can I get the other 4 Pages? The Downloads lead to just one page...
Best regards, Daniel

Lorenzo Alberton, 03 February 2011 14:15

Hi Daniel, it's just one page, with 5 different sections (which I highlighted in yellow in the description above)

Daniel, 07 February 2011 03:45

Ah.. okay. So I didn't miss anything. Thanks Lorenzo, nice work.

suyonob, 26 March 2011 23:23

Ahh, Awesome Lorenzo for cheat sheet.Good Job. Thanks.

Carol Stuart, 25 June 2011 21:24

Firebird SQL cheat sheet is really the best way to handle it.

edy prast, 21 June 2012 15:54

Thanks for cheat sheet info..

Related articles

Latest articles

Filter articles by topic

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework