firebird databasefirebird作为一款优秀的嵌入式（之一功能），用于桌面开发最合适不过了。之前也用过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 servicesecho clean userdscl localhost -delete /local/default/users/firebirdecho clean groupdscl localhost -delete /local/default/groups/firebirdif [ -f /library/startupitems/firebird ]; thenecho remove superserver startupitemrm -fr /library/startupitems/firebirdfiif [ -f /library/launchdaemons/org.firebird.gds.plist ]; thenecho remove launchdlaunchctl unload /library/launchdaemons/org.firebird.gds.plistrm /library/launchdaemons/org.firebird.gds.plistfiecho remove frameworkrm -fr /library/frameworks/firebird.frameworkecho remove receiptrm -fr /library/receipts/firebird*.pkgsudo launchctl unload /library/launchdaemons/org.firebird.gds.plist