FirebirdDatabaseOnMacOSX

Firebird Database firebird作为一款优秀的嵌入式（之一功能），用于桌面开发最合适不过了。之前也用过SQLITE做过一些小工具，但是在安全性方面表现不佳，而且不支持存储过程等特性，经过比较最终转向firebird，整理了下常用的命令语句和SQL。 用户管理 gsec

firebird作为一款优秀的嵌入式（之一功能），用于桌面开发最合适不过了。之前也用过SQLITE做过一些小工具，但是在安全性方面表现不佳，而且不支持存储过程等特性，经过比较最终转向firebird，整理了下常用的命令语句和SQL。

gsec -user sysdba -password masterkey
modify SYSDBA -pw gtlions
add gtlions -pw gtlions
quit

isql
create database &＃39;gtlions.fdb&＃39; user &＃39;SYSDBA&＃39; password &＃39;gtlions&＃39; default character set UTF8;
create database &＃39;gtlions1.fdb&＃39; user &＃39;gtlions&＃39; password &＃39;G1!tlion&＃39; default character set GBK;
exit;

isql gtlions.fdb -user sysdba -password gtlions
isql gtlions.fdb -u gtlions -p &＃39;G1!tlion&＃39;
isql gtlions1.fdb -u gtlions -p gtlions

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

vi script_for_remove_firebird.sh

#!/bin/sh
echo "Clean Services"
echo "Clean User"
dscl localhost -delete /Local/Default/Users/firebird
echo "Clean Group"
dscl localhost -delete /Local/Default/Groups/firebird
if [ -f "/Library/StartupItems/Firebird" ]; then
echo "Remove SuperServer StartupItem"
rm -fr /Library/StartupItems/Firebird
fi
if [ -f "/Library/LaunchDaemons/org.firebird.gds.plist" ]; then
echo "Remove Launchd"
launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist
rm /Library/LaunchDaemons/org.firebird.gds.plist
fi
echo "Remove Framework"
rm -fr /Library/Frameworks/Firebird.framework
echo "Remove Receipt"
rm -fr /Library/Receipts/Firebird*.pkg

sudo launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist