Firebird Database on MacOSX

Firebird Database

Firebird is an excellent embedded (one feature) that is best suited for desktop development. Previously also used SQLite to do some small tools, but poor security performance, and does not support the characteristics of stored procedures, after the final turn to Firebird, collation of the following commonly used command statements and SQL.

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.FD B ' user ' gtlions ' password ' g1!tlion ' default character set gbk;exit;

Connecting to a database

isql gtlions.fdb-user sysdba-password gtlionsisql gtlions.fdb-u gtlions-p ' g1!tlion ' isql gtlions1.fdb-u gtlions-p GT Lions

Configuration after the installation is complete, disable startup

sudo launchctl unload/library/launchdaemons/org.firebird.gds.plistsudo launchctl unload/system/library/ Launchagents/com.apple.bird.plist

Unload 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

Firebird Database on MacOSX