Firebird Database On MacOSX，firebirdmacosx

Firebird Database On MacOSX，firebirdmacosx
Firebird Database

firebird作為一款優秀的嵌入式（之一功能），用於案頭開發最合適不過了。之前也用過SQLITE做過一些小工具，但是在安全性方面表現不佳，而且不支援預存程序等特性，經過比較最終轉向firebird，整理了下常用的命令語句和SQL。

使用者管理

gsec -user sysdba -password masterkeymodify SYSDBA -pw gtlionsadd gtlions -pw gtlionsquit

建立資料庫

isqlcreate database 'gtlions.fdb' user 'SYSDBA' password 'gtlions' default character set UTF8;create database 'gtlions1.fdb' user 'gtlions' password 'G1!tlion' default character set GBK;exit;

串連資料庫

isql gtlions.fdb -user sysdba -password gtlionsisql gtlions.fdb -u gtlions -p 'G1!tlion'isql gtlions1.fdb -u gtlions -p gtlions

安裝完成後的配置，禁止啟動

sudo launchctl unload /Library/LaunchDaemons/org.firebird.gds.plistsudo launchctl unload /System/Library/LaunchAgents/com.apple.bird.plist

卸載指令碼

vi script_for_remove_firebird.sh#!/bin/shecho "Clean Services"echo "Clean User"dscl localhost -delete /Local/Default/Users/firebirdecho "Clean Group"dscl localhost -delete /Local/Default/Groups/firebirdif [ -f "/Library/StartupItems/Firebird" ]; thenecho "Remove SuperServer StartupItem"rm -fr /Library/StartupItems/Firebirdfiif [ -f "/Library/LaunchDaemons/org.firebird.gds.plist" ]; thenecho "Remove Launchd"launchctl unload /Library/LaunchDaemons/org.firebird.gds.plistrm /Library/LaunchDaemons/org.firebird.gds.plistfiecho "Remove Framework"rm -fr /Library/Frameworks/Firebird.frameworkecho "Remove Receipt"rm -fr /Library/Receipts/Firebird*.pkgsudo launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist