Compiling Flamerobin under Mac OS
Updated instructions are now here
https://github.com/mariuz/flamerobin/blob/master/BUILD.txt#L182
Thanks to Tomas Dvorak
Updated instructions are now here
https://github.com/mariuz/flamerobin/blob/master/BUILD.txt#L182
Thanks to Tomas Dvorak
Here is the guide on installing Firebird 2.5.3 from FreeBSD 10 Ports and
creating your first test database; also we show you how to install
Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 10 on a kvm-linux virtual machine.
Download a compressed snapshot of the Ports Collection into /var/db/portsnap.
# portsnap fetch
Or update it.
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:
# portsnap extract
If you already have a populated /usr/ports directory and you are just updating, run the following command instead:
# portsnap update
Enter firebird server ports directory:
# cd /usr/ports/databases/firebird25-server
Compile and install firebird server:
# make -DPACKAGE_BUILDING
# make install
Enable it by adding
firebird_enable="YES"
in
/etc/rc.conf.
Start it with:
# /usr/local/etc/rc.d/firebird start
logs and security2.fdb seems to be in /var/db/firebird.
# /usr/local/bin/isql-fb
To create a new database:
SQL> create database “tmp/first_database.fdb”;
SQL> connect “/tmp/first_database.fdb” ;
Commit current transaction (y/n)? <– y
Committing.
Database: “/tmp/first_database.fdb”
SQL>
If you want to create a simple table then insert 1-2 rows and select from it; here is one example:
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
To quit the isql-fb console, type quit:
SQL> quit
CON>;
For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:
# cd /usr/ports/databases/flamerobin/ && make install clean
Or if you don’t want to wait use pkg-add
# pkg-add -r flamerobin
To use firebird with php, you will need the php5 driver:
# cd /usr/ports/databases/php5-interbase/ && make install clean
You can choose to compile php with apache support (I have chosen cli, cgi , and apache support);
check it if is enabled with:
# /usr/local/bin/php -m
Or if you don’t want to wait compile all the php use pkg-add
# pkg-add -r php5-interbase
I have now also uploaded a new snapshot build for Mac OS. It’s also built against Boost libraries version 1.54.
The updated boost.m4 file necessitated a bump of the minimum deployment target to 10.5 (although I don’t think that anyone will even notice these days).
It’s still a 32 bit only universal build for PPC and x86. Unless I buy a new Mac this won’t change as my 10.5.8 Mac isn’t updatable to a more recent OS AFAICS.
If anyone feels like taking over the Mac OS side of FlameRobin and looking into 64 bit Cocoa builds against wxWidgets 3.0 I’ll gladly step aside…
Thanks
—
Michael Hieke
New flamerobin snapshots (git hash 5ece15b) for Windows 32 and 64 bit are uploaded to SourceForge.net.
The 32 bit build does no longer contain a version for Windows 9X
versions, only the Unicode build is included. The Inno Setup created
installer should not allow the installation on Win 9X but I haven’t
tested this.
All builds use Boost libraries version 1.54, for the necessary changes
to be able to compile it with MSVC++ 7.1 see boost ticket
Testing and reporting on your findings would be great
Check the instructions from sourceforge to clone the flamerobin repository from git
Flamerobin 0.9.3 revision 2216 binary snapshots for Debian Sid and Ubuntu Oneiric are ready to install and test. Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list.
New snapshot builds (SVN revision 2210) for Windows 32 and 64 bits are
available on SF.net.
Feedback on field and text delimiter settings for save grid data as CSV
file command would be especially welcome.
Thanks
—
Michael Hieke
Hi all,
yesterday I have uploaded new builds for 32 and 64 bit Windows, enjoy.
Thanks
—
Michael Hieke
The main change is that now it requires firebird2.5-dev instead of firebird3.0 headers and decided that is better to have a flamerobin 0.9.3 in the distros released for the next 1-2 years with a stable firebird 2.5.x and add firebird 3.0 requirement when is ready and stable ~1-2 years
Changelog:
* New upstream SVN snapshot : revision 2100
* Uploaded to unstable
* Stop using system-wide ibase.h.Unstable has no fb3.0 so system-wide ibase.h has no boolean defines,which are used by FR and were ported to IBPP’s embedded copy of ibase.h
* build-depend on firebird2.5-dev instead of firebird-dev(firebird-dev is only in experimental)
You can download and install the package directly from debian sid (tested and works on ubuntu natty too )
http://packages.debian.org/sid/flamerobin
Also for ubuntu the install guide is now updated