Firebirdの歴史と概要

Size: px

Start display at page:

Download "Firebirdの歴史と概要"

あけなおことじ
5 years ago
Views:

1 Open Source Conference 2007.DB Firebird 2.0/2.1 Firebird FirebirdWeb

2 Agenda Firebird 2.0 Firebird 2.1 Firebird Firebird Firebird

3 Firebird 2.0

4 Firebird 2.0 Firebird 2.0Firebird ProjectRDBMS (Firebird 1.xInterBase 6.0) v2.0.1 v2.058bug fix Bug fix InterBasegds32.dll context already in use (BLR error) GC v2.0v2.0.1 V2.0.1 Gentoo Linux/FreeBSDFirebird GC v2.0.2

5 Firebird bitAMD64Intel EM64T v2.0linux V2.1Windows ODS version GB 40bit(64bit) DESSHA-1 CSService API

6 Firebird 2.0 SELECT <select list> FROM <table reference list> <table reference list> ::= <table reference> [{<comma> <table reference>}...] <table reference> ::= <table primary> <joined table> <table primary> ::= <table> [[AS] <correlation name>] <derived table> <derived table> ::= <query expression> [[AS] <correlation name>] [<left paren> <derived column list> <right paren>] <derived column list> ::= <column name> [{<comma> <column name>}...]

7 Firebird 2.0 CREATE SEQUENCE SQL:1999CREATE SEQUENCE CREATE GENERATOR CREATE GENERATORInterBase CREATE { SEQUENCE GENERATOR } <name> DROP { SEQUENCE GENERATOR } <name> SET GENERATOR <name> TO <start_value> ALTER SEQUENCE RESTART WITH <start_value> GEN_ID (<name>, <increment_value>) NEXT VALUE FOR <name>

8 Firebird 2.0 EXECUTE BLOCK DSQL EXECUTE BLOCK [ (param datatype =?, param datatype =?,...) ] [ RETURNS (param datatype, param datatype,...) } AS [DECLARE VARIABLE var datatype;...] BEGIN... END

9 Firebird 2.0 Procedure SQL DECLARE [VARIABLE] <cursor_name> CURSOR FOR ( <select_statement> ); OPEN <cursor_name>; FETCH <cursor_name> INTO <var_name> [, <var_name>...]; CLOSE <cursor_name>; Example: DECLARE RNAME CHAR(31); DECLARE C CURSOR FOR ( SELECT RDB$RELATION_NAME FROM RDB$RELATIONS ); BEGIN OPEN C; WHILE (1 = 1) DO BEGIN FETCH C INTO :RNAME; IF (ROW_COUNT = 0) THEN LEAVE; SUSPEND; END CLOSE C; END

10 Firebird 2.0 CROSS JOIN ROW SELECT... [ORDER BY <expr_list>] ROWS <expr1> [TO <expr2>] CURRENT_TIMESTAMPNOW GROUP BY GROUP BY SUBSTRING(CAST((A * B) / 2 AS VARCHAR(15)) FROM 1 FOR 2) ORDER BY SELECT * FROM RDB$RELATIONS ORDER BY 9

11 Firebird 2.0 Win32 Local Protocol: XNET Classic WAIT TIMEOUT isc_tpb_lock_timeout LIKE BLOB Knuth-Morris-Pratt(KMP) Blob UDFNULL External function(ib_udf) ASCII_CHAR, LOWER,LPAD, LTRIM, RPAD, RTIM, SUBSTR,SUBSTRLENNULL

12 Firebird 2.1 (Beta1)

13 Firebird 2.1 FirebirdSQL CREATE TRIGGERSQL:2003 Fyracle Oracle DB TEXT BLOB[VAR]CHAR PSQLDOMAIN Database SQL MERGE,UPDATE/INSERT SQL:1999 (CTE), Windows 64

14 Firebird 2.1 DB DB Oracle SQL Server 2005 SP2DB /

15 Firebird 2.1 SQL92 CREATE GLOBAL TEMPORARY TABLE OracleSQL-92 2

16 Firebird 2.1 (CTE) SQL:1999 Oracle (CTE)WITH WITH RECURSIVE 1024

17 Firebird 2.1 MERGE SQL:2003 Oracle DB2 LIST SQL BLOB Subtype1()[VAR]CHAR 32,765VARCHAR LIKE

18 Firebird 2.1 SQL ODS (GBK) Windows64 Web

20 Firebird , Q2 () Beta 1 Firebird , Q3 Firebird , Q42008, Q2) Firebird 3.0 SQL (Java SQL

21 Firebird

22 Java JayBird Borland IBObject FIBPlus IBX, MDO Web Perl,PHP Python Ruby ODBC OLEDB IBPP Cfbclient.dll.NET Provider Firebird

JayBird 2001David Jencks 20034 1.0 20048 1.5 200511 2.

23 JayBird 2001David Jencks BSD JDK JDBC 3.0, JCA 1.0, JTA 1.0.1

24 Delphi() MDO(Mercury Database Object ) IBX RC2(2006/02/28) UIB(Unified InterBase) TdatasetdbExpress 2.0(2006/02/05) Zeos FirebirdDB 6.1.5(2004/04/30) IBX, BDE IBXInterBaseBDE IBXIBXBDEIBObject

25 Web PHP ADOdb PEAR Ruby FireRuby Python KInterbasDB Perl DBD::InterBase

26 (1) C Firebirdfbclient.dll IBPP Fbclient.dll SQLAPI++ FirebirdDLL ()

27 (2).NetProvider.Net Net 1.1Mono ODBC Odbc-jdbd Official Easysoft InterBase ODBC Driver Gemini InterBase/Firebird ODBC Driver OLEDB IBProvider SIBPROvider Zstyle OLE DB Driver

28 .Net & Windows WindowsFirebirdWindows ADO.NET Npqsql (PostgreSQL ADO.NET ) 1.0(2006/08).NET 1.1 Firebird ADO.NET1.x.NET1.1, 2.x.NET2.0Mono Windows 98RDBMSWindows NT 2000(NTFS)

29 OK! FirebirdMySQL FirebirdIPL(MPL) MySQL.Net Provider SQLite

30 RDBMS. PostreSQL, MySQL, Oracle Firebird, Microsoft Access, SQLite

31 C/S Embedded: C/S RDB Firebird(MySQL)

32 PHP (Linux+Apache+MySQL+PHP) (Linux+Apache+PostgreSQL+PHP) WebOK! MySQL (FPL) MF(irebird) MPLIPL Not LAMP but FLAP(Firebird + Linux + Apache + PHP) WindowsFWAP

33 Delphi FirebirdInterBase InterBaseFirebird (IBX) BDE IBObjectFIBPlus MDO(Mercury Data Object)

34 CodeGear(: Borland) BDE Paradox IBX dbase dbexpress BDP BDE RDBMS() Kylix Delphi C++Builder BDP dbexpress IBX RDBMS MySQL InterBase

36 IBSurgeon(IBPhoenix Russia) InterBase/Firebird InterBase/Firebird ibase.ruibphenix.com IBPhoenix Russia

37 IBBackupSurgeon

38 IBAnalyst(1) Firebird/InterBase ()

39 IBAnalyst(2) gstat IBAnalystgstat KB(Knoledge Base)

40 IBFirestAid DB (Diagnostician) (Ambulance )

41 IB FirstAID gfix IB FirstAID IBFirstAID Ambulance IBSurgeon DB

42 IBUndelete IBSurgeon

43 IBTM(IB Transaction Monitor) FirebirdInterBase Monitor Win32 DB Configuration Assistant Visualizer D

44 Firebird

45 Firebird ORCA Online Receipt Computer Advantage Project

46 Ver ,000 Windows 2000/XP MacOSX 10.3/10.4

47 Ver5.3.5 Java 1,100

48 Java / Java Firebird Windows Mac OSX intel PC intel Mac PPC Mac

49 Firebird Java Windows Macintoshintel/PPC Linux

50 OPEN ADMIN/STM Firebird

51 OPEN ADMIN/STM (200 (20073)

52 : : JCOM JBoss / Tomcat SMS/Billing (3) () JBoss / Tomcat

54 Firebird URL: apex-jp.com ASP Firebird+Linux+Apache+PHP5(FLAP) Brillia

56 Firebird URL: ExChecker RedHat 9+Firebird 1.0+Apache+CGI(C)

58 Firebird

Firebird 20044 Firebird Webhttp://firebird.gr.jp) ( http://groups.yahoo.co.

59 Firebird Firebird Webhttp://firebird.gr.jp) ( HP FirebirdSQL Foundation IBPfhoenix Developer CD-ROM($750

60 Firebird Firebird Firebird FlameRobin 0.76 CD

61 1 st Firebird Japan Conference Firebird 2007/04/14 Firebird

62 Firebird Firebird

InterBaseツール・ユティリティ大全

InterBaseツール・ユティリティ大全 InterBase (http://kimuradb.com) (KIMURA, Meiji) : Info@kimuradb.com InterBase/Firebird [2001] InterBase/Firebird http://www.geocities.jp/kimura804/rdb/ Ivan Prenosil's Firebird/InterBase site Welcome to