########################
OpenSource DataBase
  Ƥ memo
MySQL vs PG vs Firebird
2005-03-26
########################

ͥä礪!

1  Ȥˤ
1.1  MySQL
version ΤɤȤ
-- 3.23 :ƽ
-- 4.0  : ƤĤ
-- 4.1  : main stream
-- 5.0  : Ū˹

4.1 
-- UTF8 ˤ
-- 桼Τʤ˼ưѴˤ
-- cp932, eucjpms 5.0

4.0 ޤǤϼưѴʤ

1.2  FireBird
- 2000ǯOpenSource
- 1983 ǯλͤҤ
-- SQLѡΥСإåɤ礭
- OpenSource ưް
- QA ɤ
- ȯԤ¾DB
- ܸSJISUnicodeΥޥåԥ󥰤
- UCS4бͽ


1.3  postgresql
- ٤
-- O? case by case. ʿѤǤ٤
-- ʤȤʻƨƻϤ뤫?(̥ǡɤ߹ߤλcommitʤǤȤ ѤΥ̵Τߤ)
--- O ƨƻ¿
- ®ˤϤʤˤˤΤ
- ǥåĥäƥɤ٤(MySQLƱ)

- InnoDB  postgres ٤ȤΤ?
-- Super-Smack Τ̤ǤϡInnoDB ᤫä
--- ʥꥪ褫? ->׸
-- UPDATE,SELECTˡԤ褦ʥƥȤȡMySQL ٤ʤäpostgresϤޤѤʤäȤ̤->ɻ


- FireBird ϥ꡼礭褦˲¤ʤȡä٥ΥƥȤˤԸ?
-- RAM disk Ĥä㤦Ȥ⤢


2  ¾
2.1  MySQL 
- JDBC Ϥᡣprepare()μǡprepareȤ̾ statement ٤ƤȤƤĤʤ٤ʤ롣
- Java ǤΥƥȤǤϡMySQL ϰ̤ФȤˤʤ
--> 󡢴ְ㤤Ȥ٤ʤ뤱ɡȤ prepare()  statement ®Ʊ餤եɤηȡJava¦ηƱˤʤȤʤ

2.2  postgres
-饤Ȥ³ƤȥץեŤ

-RPM(distributionˤĤƤѥå)
-- locale ꡢȤƤ̤㤯.
-- Τ
-- ۥƥ󥰤ξ(ѰդƤΤȤ虜)

-- MySQL Ρdistributer  latin1 ѰդƤ뤫ʸȯΩ⤤ޤ饤ѹǸŤСѤƤdistribution¿
-- FireBird Ϥޤ distribution äƤʤ(BorlandΥ饤󥹤, win Υ桼¿ʤɤͳ)

2.3  FireBird
-- fork ǥȥåɥǥ뤬.
--- case by case ®㤦
-- Ȥ߹Ӥ¿ơOpenSource ˼Ȥͺ­
-- ȯVC++¿

3  ܸΰ
3.1  postgres
- ʣΥ󥳡ǥ󥰤ϤǤʤ
- DB ñ̤Ѥ

3.2  FireBird
- եñ̤ǥ󥳡ǥ󥰤ѹǤ
- FireBird ΥǥեȤϥ饯åȤʤ
--> Ф餷
-- ³λǥ饯åȤѤ뤳Ȥǽ
-- cp932 <-> Unicode Ϥ

3.3  MySQL
- եñ̤Ѥ
- 4.1 ʾǤϡܸΰ¿

ʲΤɤ줫
- 4.1ʾϤ
- unicodeǤ
- Сȥ饤ȤΥ饯åȤƱˤ
-- Сȥ饤ȤΥ饯åȤο㤤

- 4.1 ϡ饤Ȥϥ饤ȼȤĥ饯åȤǥСˤĤʤ˹Ԥ줬ʸ˲θΰġ

- ưѴ
--> äȤո⤢
- postgres  EUC ΥСʤ EUC Υ饤ȤǤĤʤФ
- postgres Ǥϥ󥳡ɤˤϵ˴ƤʤưѴߤ(˾)
- postgres ΥɥޥåפϤʤܿͤäƤ
- MySQL ϺǶἫưѴää麮𤷤Ƥ롣4.0ޤǤ̵äޤޤǤѤä麮𤷤Ƥ⡣

4  С
4.1  MySQL
- MySQL κ٤ӥ¿ơΤʤʹ֤ˤȽǤǤʤ
- СˤäƤεǽΰ㤤ʬʤ

-- 3.23 replication, InnoDB
-- 4.0  ޥ饯å, query cache
-- 4.1  Sub Query, GIS,  SSL, utf8
-- 5.0 stored, view
-- 5.1 trigger

-- ȯǤΤθ?

-- 4.1 ʾϡ񻺤ʤͤˤOK(줫鿷˻Ϥʤ4.1ʾOK)4.0ޤǤλ񻺤褫ϤޤꤪǤʤ

- MySQL3.23ϰɡΤεǽϦȤȤΤϤäȺ(Τ?)

- ɲäǽˤĤƤϥХϤ뤱ɡstable ꡼ˤޤ˵ǽɲä뤳Ȥä

- ޥ˥奢εҤС󤰤㤰˽񤫤ƤꡢɤΥСˤĤƤΤȤʬˤ
- ܸޥ˥奢4.1.1ǻߤޤäƤ

- С󥢥å᤹ʤ? 1,2upgradeä...
-- 䡢3.211ȤѤäȤ⤢ä֤ѤäƤ뤳Ȥ(ver.3)¿ä٤кϤޤѤʤ͡

4.2  PostgreSQL
- postgres ΥС󤬤褯夬
- 8.0 (1̡2)ޤǤ᥸㡼ֹ档ǽɲäɽ
-- ο㤦ϸߴ̵Ƥ⤤Ȥݥꥷ
--- ڤ

-- СѤȡǡdump ƥꥹȥɬפ
--- MySQL ϲκȤפʤΥСΥեϤΤޤ޻Ȥ

-- 3(ex. 8.0.1) ϥХեå򼨤
-- Ť饤ȤϿСˤĤʤ
--- С饤Ȥ̤ưѤ

- postgresܸޥ˥奢ϤˤǤ롣ɽƤ롣
-- postgres ꡼Ȱܸޥ˥奢뤬Ф
-- ᥸㡼 upgrade λѹ¿ɡ
4.3  FireBird
FireBird Υޥ˥奢Ϻ档

FireBirdQA
- QAѥƥब
-- 
- ݥ󥵡ȤΥ󥸥˥ΥեɥХå⤢
- borland桼äƤ
- ʤΤǡȯ5ͤ餤ɡƥȤʹ֤¿
- ӥ󥢥åפʤλȤߤͤƤ