个人工具
登录
查看“UbuntuHelp:Firebird2.1”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:Firebird2.1”的源代码
来自Ubuntu中文
←
UbuntuHelp:Firebird2.1
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{From|https://help.ubuntu.com/community/Firebird2.1}} {{Languages|UbuntuHelp:Firebird2.1}} In Ubuntu 10.04 Lucid Lynx Firebird 2.1.3 is [http://launchpad.net/ubuntu/lucid/+source/firebird2.1 included] by default and you don't need to enable the firebird stable ppa from bellow and you should follow the instructions from "apt-get install" section The Firebird2.1 package (version 2.1.3) for Ubuntu Karmic 9.10 ,Ubuntu 9.04 Jaunty, Intrepid 8.10, Hardy 8.04, Dapper 6.06 is located into [https://launchpad.net/~mapopa/+archive this] repository (ppa) The repository must be added into sources.list , Here is the example for Karmic <pre><nowiki> sudo pico /etc/apt/sources.list.d/firebird.list </nowiki></pre> and you should add these lines <pre><nowiki> deb http://ppa.launchpad.net/mapopa/ppa/ubuntu karmic main deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu karmic main </nowiki></pre> You need to import my [https://help.launchpad.net/PPAKeys gpg key] <pre><nowiki> sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com ea316a2f8d6bd55554c23f680be6d09eef648708 </nowiki></pre> Then you need to update the cache repository <pre><nowiki> sudo apt-get update </nowiki></pre> Here is how you can inspect the firebird2.1 related packages <pre><nowiki> apt-cache search firebird2.1-* </nowiki></pre> Install the super server package (you will be asked about the SYSDBA password and what service to enable :Super Server or Classic ) <pre><nowiki> sudo apt-get install firebird2.1-super The following extra packages will be installed: firebird2.1-common firebird2.1-server-common libedit2 libfbclient2 libicu38 Suggested packages: firebird2.1-doc The following NEW packages will be installed: firebird2.1-common firebird2.1-server-common firebird2.1-super libedit2 libfbclient2 libicu38 0 upgraded, 6 newly installed, 0 to remove and 1 not upgraded. Need to get 11.7MB of archives. After unpacking 28.4MB of additional disk space will be used. Do you want to continue [Y/n]? y </nowiki></pre> Or install Classic if you have more than one cpu (dual core or SMP machine) and want [http://www.firebirdsql.org/manual/qsg2-classic-or-super.html SMP support] <pre><nowiki> sudo apt-get install firebird2.1-classic </nowiki></pre> You need to configure the package after is installed <pre><nowiki> sudo dpkg-reconfigure firebird2.1-super </nowiki></pre> Install the examples and dev files <pre><nowiki> sudo apt-get install firebird2.1-examples firebird2.1-dev </nowiki></pre> The employee.fdb archive will be under this dir /usr/share/doc/firebird2.1-examples/examples/empbuild/ <pre><nowiki> cd /usr/share/doc/firebird2.1-examples/examples/empbuild/ sudo gunzip employee.fdb.gz sudo chown firebird.firebird employee.fdb sudo mv employee.fdb /var/lib/firebird/2.1/data/</nowiki></pre> Connect to database using the isql-fb console <pre><nowiki> $ isql-fb SQL> connect "/var/lib/firebird/2.1/data/employee.fdb " user 'SYSDBA' password 'SYSDBApassword'; </nowiki></pre> If all is ok then you will have the message with what database connected and what user and ready to use sql prompt <pre><nowiki> Database: "/var/lib/firebird/2.1/data/employee.fdb ", User: SYSDBA SQL> </nowiki></pre> Now you can check the server version and the tables <pre><nowiki> SQL> show tables; COUNTRY CUSTOMER DEPARTMENT EMPLOYEE EMPLOYEE_PROJECT JOB PROJECT PROJ_DEPT_BUDGET SALARY_HISTORY SALES SQL> show version; ISQL Version: LI-V2.1.3.18185 Firebird 2.1 Server version: Firebird/linux Intel (access method), version "LI-V2.1.3.18185 Firebird 2.1" Firebird/linux Intel (remote server), version "LI-V2.1.3.18185 Firebird 2.1/tcp (eeepc)/P11" Firebird/linux Intel (remote interface), version "LI-V2.5.0.25920 Firebird 2.5 Release Candidate 2/tcp (eeepc)/P11" on disk structure version 11.1 </nowiki></pre> To create a new database <pre><nowiki> SQL> create database "/var/lib/firebird/2.1/data/first_database.fdb" user 'SYSDBA' password 'SYSDBAPASSWORD'; SQL> connect "/var/lib/firebird/2.1/data/first_database.fdb" user 'SYSDBA' password 'masterkey'; Commit current transaction (y/n)?y Committing. Database: "/var/lib/firebird/2.1/data/first_database.fdb", User: SYSDBA SQL> </nowiki></pre> If you want to create a simple table then insert 1-2 rows and select from it here is one example <pre><nowiki> SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20)); SQL> show tables; TEST SQL> INSERT INTO TEST VALUES (1, 'John'); SQL> INSERT INTO TEST VALUES (2, 'Joe'); SQL> select * from test; ID NAME ============ ==================== 1 John 2 Joe </nowiki></pre> To quit the isql-fb console type quit <pre><nowiki> SQL> quit CON>; </nowiki></pre> For a good open source GUI admin tool you might check the flamerobin administration tool included in ubuntu repository can be installed by an simple <pre><nowiki> sudo apt-get install flamerobin </nowiki></pre> Then use it from the menu Applications->Programming-> FlameRobin To use firebird with php , you will need the php5 driver <pre><nowiki> sudo apt-get install php5-interbase sudo /etc/init.d/apache2 restart </nowiki></pre> Next if you need to install an php administration tool like Firebird Web Admin <pre><nowiki> sudo apt-get install git-core git clone git://github.com/mariuz/FirebirdWebAdmin.git mv FirebirdWebAdmin/firebirdwebadmin /var/www/firebirdwebadmin </nowiki></pre> and load it in the browser [http://localhost/firebirdwebadmin http://localhost/firebirdwebadmin] It should look like this [http://farm3.static.flickr.com/2555/4159286187_9ab6033e88_o.png screen shot] =Other Firebird Related Guides= You can start with the main Firebird [http://www.firebirdsql.org/?op=doc documentation]. To use Ruby language with firebird I wrote a [http://mapopa.blogspot.com/2009/02/fireruby-howto-start-with-firebird-and.html tutorial] on howto install the stable driver. For Ruby on Rails i wrote [http://mapopa.blogspot.com/2009/02/installing-firebird-active-record-for.html howto] install the Firebird Active Record Adapter and start [http://mapopa.blogspot.com/2009/02/rails-on-firebird-status-after-adapter.html an application]. To use python you must use [http://www.firebirdsql.org/index.php?op=devel&sub=python the official ] firebird python driver and [http://mapopa.blogspot.com/2009/02/firebird-python-howto-on-ubuntu-wget.html here] is howto install and test it if it works. For [http://manpages.ubuntu.com/manpages/lucid/man1/lazarus-ide.1.html Lazarus IDE] i wrote an [http://mapopa.blogspot.com/2010/04/using-lazarus-ide-with-firebird-in.html visual guide] on howto use the database aware components in a simple application that uses Firebird. Lua Language does have a [http://code.google.com/p/fbclient/ good driver] and there is a [http://mapopa.blogspot.com/2010/04/getting-started-with-firebird-and-lua.html Getting started] guide with firebird on ubuntu [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:Firebird2.1
。