linux on vax - project of the day

I guess someday firebird will run on linux on vax
Here you will find all you need to get the Linux Kernel up and running on a VAX computer.

Linux/VAX Porting Project

technorati tags:firebird, vms, vax, linux, netbsd, simh, emulator

Blogged with Flock

new jaybird release added on freshmeat

Release focus: Major feature enhancements

Changes:
Support for Firebird events, few other features and fixes

http://jaybirdwiki.firebirdsql.org

technorati tags:firebird, jaybird, jdbc, jdbc3, jdbc2, java, transactions, security, connections

Blogged with Flock

ajax+firebird mention on lockergnome

You have to admit, this concept of an Ajax builder could end up providing us with some pretty amazing products in the not too distant future.

AJAX made easier Down Under ~ Web Developers

technorati tags:firebird, ajax, csharp, rad, ide, javascript

Blogged with Flock

Easy Ajax with Firebird down under

The AJAX-based product features a visual designer and cross-compiling capabilities for programming in C#, Java, Visual Basic and Object Pascal. An embeddable Firebird database and Apache Web server are also included for application deployments. With WebOS AppsBuilder, Morfik saves developers from having to learn new languages for Web development, such as PHP (Hypertext Preprocessor) or Python.

AJAX made easier down under

technorati tags:firebird, firebird+database, ajax, php, csharp, pascal, delphi, oopascal, perl, python, webos

Blogged with Flock

Quote of the day "Interesting that they call if Firebird...Firebird Suite "

"Interesting that they call if Firebird. The obvious next step would be to bundle it with a word processor and spreadsheet. Then call it the Firebird Suite."
by Andrew B. on http://www.desktoppublishingforum.com/bb/showthread.php?t=3175

.:(firebird):..:(databases):..:(sql):.

free pascal , free beer meeting

Lazarus and FPC will be on the Systems 2006 in Munich in October in hall A3 booth 542. We will try to be there on all 5 days. You can find more information about the Systems 2006 here.[Ed:you can meet the team and talk about the lazarus ide, oopascal , firebird , open source , free beer ;) ]

Firebird News

Blogged with Flock

Firebir, Firefox mention in nepal - is time for iceweasel

The next major change came with the release of Firebird browser. Mozilla changed the name of the browser from Phoenix to Firebird. This was done to avoid trademark issues with a company called Phoenix Technologies, which makes a browser of its own. After months of brainstorming, the Mozilla team rested on a new name, Firebird. However, the name Firebird had to be changed again later because Firebird was the name of an open source development project that makes a relational database.

http://www.gorkhapatra.org.np/content.php?nid=4493

.:(firebird):..:(databases):..:(sql):..:(firefox):..:(iceweasel):.

qemu powerpc cpuinfo

cat /proc/cpuinfo
processor : 0
cpu : 604
clock : 200MHz
revision : 0.0 (pvr 0004 0000)
bogomips : 494.79
machine : PReP Mesquite cPCI (MCP750)
l2 cache : none
simms : 0:144M

uname -a
Linux debianppc 2.4.27.001 #1 Tue Oct 27 00:32:19 EET 1970 ppc GNU/Linux

.:(firebird):..:(databases):..:(sql):..:(qemu):..:(debian):..:(powerpc):.

steps for porting on powerpc64

sudo apt-get install autoconf libtool g++-4.1 libreadline5-dev valgrind bison

checkout latest release version  (almost stable)
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2

implementation error (ppc is not defined)
../src/jrd/inf.cpp: In function 'int INF_database_info(const SCHAR*, SSHORT, SCHAR*, SSHORT)':
../src/jrd/inf.cpp:406: error: 'IMPLEMENTATION' was not declared in this scope


patch the src/jrd/common.h

--- src/jrd/common.h    2004-12-01 07:49:10.076214624 -0800
+++ src/jrd/common.h_ppc        2004-12-01 07:46:23.809196816 -0800
@@ -129,6 +129,11 @@
 #define IMPLEMENTATION  isc_info_db_impl_linux_amd64 /* 66  next higher unique number, See you later  */
 #endif

+#ifdef PPC64
+#define IMPLEMENTATION  isc_info_db_impl_linux_ppc64 /* 68 next higher unique number, See you later  */
+#endif
+
+
 #ifdef i386
 #define I386
 #define IMPLEMENTATION  isc_info_db_impl_i386 /* 60  next higher unique number, See you later  */


in src/jrd/inf_pub.h search for isc_info_db_impl_freebsd_amd64 and add 


        isc_info_db_impl_freebsd_amd64 = 67,
        isc_info_db_impl_linux_ppc64 = 68,


in src/jrd/pag.cpp search for CLASS_FREEBSD_AMD64 

and add new class

static const int CLASS_LINUX_PPC64 = 26;// LINUX  on PPC64

change CLASS_MAX to 

static const int CLASS_MAX = CLASS_LINUX_PPC64


add ArchitectureType in archMatrix (in our case BigEndian)

archBigEndian // CLASS_LINUX_PPC64

Define the const SSHORT CLASS after the AMD64 one 


#if defined LINUX && defined AMD64
const SSHORT CLASS              = CLASS_LINUX_AMD64;
#endif

in src/jrd/utl.cpp
search for  "Firebird/FreeBSD/amd64",   /* 67 */
and add 
 "Firebird/linux PPC64",     /* 68 */


in src/remote/xdr.cpp search for 
#elif defined(sparc) || defined(PowerPC)
and replace and add PPC64 define check 

#elif defined(sparc) || defined(PowerPC) || defined(PPC64)

change in the 
 gen/make.platform 
and add DEV_FLAGS=-DPPC64

it should look like this
DEV_FLAGS=-ggdb -DLINUX -pipe -MMD -p -fPIC -Wall -Wno-switch -DPPC64

.:(firebird):..:(databases):..:(sql):.

compiling on an powerpc VM

I have started compiling firebird on an 32 bit powerpc emulated machine
here is the guide for installing debian on powepc (qemu)
is good to install dhcpd and vde interface
so you can work with ssh on the emulated machine

.:(firebird):..:(databases):..:(sql):..:(powerpc):..:(debian):..:(ubuntu):.

quote of the day from php source code

 /**
 * These aliases are provided in order to maintain forward compatibility. As Firebird
 * and InterBase are developed independently, functionality might be different between
 * the two branches in future versions.
 * Firebird users should use the aliases, so future InterBase-specific changes will
 * not affect their code
 */

you can browse firebird extension on php.net

.:(firebird):..:(databases):..:(sql):.

building time on dual cores (amd athlon x2 4200+ am2)

Today i tested a new machine based on amd athlon x2 4200+ am2 with 1G of ddr2 4200 (@533Mhz) and 3x320G drives (it will have 4G of ddr2 in dual channel soon with max of 8G)
Motherboard is asus m2npv

here are the build times for firebird 2 rc5
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2
cd firebird2
./autogen.sh --prefix=/opt/firebird2 --enable-debug --enable-superserver
time make
real 4m38.617s
user 4m2.259s
sys 0m27.574s

cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1000.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm cr8legacy ts fid vid ttp tm stc
bogomips : 2007.24

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1000.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm cr8legacy ts fid vid ttp tm stc
bogomips : 2007.24


.:(firebird):..:(databases):..:(sql):..:(amd):.

booting netbsd on vax

Here is one howto
boot netbsd on an emulated vax machine , I wonder if firebird will work on it ;)
someday

.:(firebird):..:(databases):..:(sql):..:(vax):..:(bsd):..:(netbsd):.

firebird on other architectures (powerpc/arm/ultrasparc/s390)

I read the mips porting thread and here is the one thing to care when doing the port (besides code patches)

Alex Peshkov wrote:
As I see from your answer about cross-compilation, security.fdb in your
package is created by INTEL, not MIPS, binary. And, therefore, it can't
be opened on MIPS, which, I suppose, may have different endianness,
different alignment rules, etc. Therefore you must create security
database at MIPS box to have it usable. But to do it you must attach to
the server, and to attach you need security.fdb => dead lock.

Let's start from the simplest opportunity - do you have isql_static for
MIPS (it's created during normal BOOT_BUILD) ?


.:(firebird):..:(databases):..:(sql):.

building firebird 2.0 rc5 on ubuntu edgyeft beta

I have just installed my ubuntu edgy and wanted to test the new machine
so i will show how i compiled it on it (32 bit system = sempron 2800+ )

sudo apt-get install autoconf libtool g++-4.1 libreadline5-dev valgrind bison
checkout latest release version (almost stable and soon will be officially)
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2
cd firebird2
./autogen.sh --prefix=/opt/firebird2 --enable-debug --enable-superserver
make
sudo make install
ps -ax | grep firebird
/opt/firebird2/bin/isql -u SYSDBA -p ********** /opt/firebird2/examples/empbuild/employee.fdb




.:(firebird):..:(databases):..:(ubuntu):..:(edgy):..:(edgyeft):.

big table google video presentation

You can watch the video presentation how bigtable based database is working for google.com
(inside view).
Another related paper (pdf) with bigtable info is located at google's labs

http://labs.google.com/papers/bigtable-osdi06.pdf

.:(firebird):..:(databases):..:(sql):..:(google):..:(bigtable):..:(clusters):.