Firebird Database On MacOSX, firebirdmacosx
Firebird Database
Firebird, as an excellent embedded (one function), is most suitable for desktop development. I have also used SQLITE to do some gadgets before, but it does not perform well in terms of security and does not support features such as stored procedures. After comparison, I finally switched to firebird and sorted out common command statements and SQL statements.
User Management
gsec -user sysdba -password masterkeymodify SYSDBA -pw gtlionsadd gtlions -pw gtlionsquit
Create a database
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;
Connect to database
isql gtlions.fdb -user sysdba -password gtlionsisql gtlions.fdb -u gtlions -p 'G1!tlion'isql gtlions1.fdb -u gtlions -p gtlions
After the installation is complete, start prohibited
sudo launchctl unload /Library/LaunchDaemons/org.firebird.gds.plistsudo launchctl unload /System/Library/LaunchAgents/com.apple.bird.plist
Uninstall script
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