But this is an open source conference, and Clarion is a closed source product. What exactly is ClarionMag doing here?
In my experience there are are plenty of Clarion developers already using open source products and tools. For the most part that means databases such as MySQL, Firebird, PostgreSQL and Ingres, and web tools, of which there are a great many (Apache and PHP are popular choices).
.:(firebird):..:(databases):..:(sql):.
Friday, July 25, 2008
On MySQL forks and MySQL’s non-Open Source documentation
One of the things that sets MySQL apart (in, IMHO, a very bad way) from other Open Source database projects/products such as PostgreSQL (license) and Firebird (license) is that the MySQL documentation is NOT Open Source. The MySQL documentation is and always has been copyright MySQL AB, and “… use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of MySQL AB”.
http://jcole.us/blog/archives/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-documentation/
.:(firebird):..:(databases):..:(sql):.
http://jcole.us/blog/archives/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-documentation/
.:(firebird):..:(databases):..:(sql):.
Friday, July 18, 2008
Zeos is Now Ready for FB 2.1.1
Here is the full blog post
The first FB 2.1 version has a problem when attempt first connect to the database but the version 2.1.1 seem already fix that bug, as in the Zeos forum "Seawolf" analyze that "(CORE-1868) The server could crash in isc_dsql_free_statement(). fixed by A. Peshkof" is the problem that make Zeos crash at first connection to the DB. Here is the link to the discussion about this problem in Zeos forum. So if you want to use the Firebird 2.1 version with Zeos then move to Firebird version 2.1.1
.:(firebird):..:(databases):..:(sql):.
The first FB 2.1 version has a problem when attempt first connect to the database but the version 2.1.1 seem already fix that bug, as in the Zeos forum "Seawolf" analyze that "(CORE-1868) The server could crash in isc_dsql_free_statement(). fixed by A. Peshkof" is the problem that make Zeos crash at first connection to the DB. Here is the link to the discussion about this problem in Zeos forum. So if you want to use the Firebird 2.1 version with Zeos then move to Firebird version 2.1.1
.:(firebird):..:(databases):..:(sql):.
Firebird - Technical Question
Just starting to migrate our application from an Access backend to Firebird. We have created a firebird database and can connect to it through our app however our SQL statements require objects to be quoted, i.e.
.:(firebird):..:(databases):..:(sql):.
.:(firebird):..:(databases):..:(sql):.
Thursday, July 10, 2008
Firebird Embedded use on linux
Here is the guide for firebird 1.5.x on linux , I will try to use the guide on ubuntu and
later with firebird 2.x
also i will try to use it with both c++ and mono
http://tirania.org/blog/archive/2005/Sep-30-2.html
http://www.firebirdfaq.org/Firebird-Embedded-Linux-HOWTO.html#Final_directory_structure
To use Firebird on Linux without needing to add users or set permissions, you can use the Classic server and get it down to just a few files. I used FirebirdCS-1.5.x on SuSE 9.2 but it should work for any Linux distribution and any recent Firebird release. What you need is:
1. A directory to setup a mini Firebird environment. I used ~/firebird and you need these files in the directory:
libfbembed.so
firebird.conf
security.fdb
intl/fbintl
bin/fb_lock_mgr
2. You need to link with or dynamically load the libfbembed.so library. It will allow direct connection to the database without needing a server process.
3. The firebird.conf file just needs one line with "RootDirectory=?" where ? is the full path of the mini Firebird environment directory.
4. The security.fdb file will be used to validate the username and password when you connect so you can either setup users in it or just set the sysdba password to a known value and login using sysdba. This security file is really a dummy file and will not provide any real security but its an embedded database so you are not looking for the same type of security a networked server would need.
5. The files all need to be owned by the user who will be opening the database so in my case they were all owned by me. Special care needs to be taken with the fb_lock_mgr since the one in /opt/firebird/bin is setup owned by firebird.firebird and with the setuid bit turned on but you will not need any of this for this configuration. In general if you're application is running as user "foo" then that user needs to have read/write access to the database you are trying to open, to the security.fdb file, and to the directory you installed the Firebird mini environment.
In your code you need to set the environment variable FIREBIRD to the location of the mini Firebird environment and then you should be able to use isc_attach_database and just pass a full pathname to the database file you want to use.
Here is the original article , but the site seems to be missing
http://web.archive.org/web/20070611151645/http://fbtalk.net/viewtopic.php?id=194
.:(firebird):..:(databases):..:(sql):.
later with firebird 2.x
also i will try to use it with both c++ and mono
http://tirania.org/blog/archive/2005/Sep-30-2.html
http://www.firebirdfaq.org/Firebird-Embedded-Linux-HOWTO.html#Final_directory_structure
To use Firebird on Linux without needing to add users or set permissions, you can use the Classic server and get it down to just a few files. I used FirebirdCS-1.5.x on SuSE 9.2 but it should work for any Linux distribution and any recent Firebird release. What you need is:
1. A directory to setup a mini Firebird environment. I used ~/firebird and you need these files in the directory:
libfbembed.so
firebird.conf
security.fdb
intl/fbintl
bin/fb_lock_mgr
2. You need to link with or dynamically load the libfbembed.so library. It will allow direct connection to the database without needing a server process.
3. The firebird.conf file just needs one line with "RootDirectory=?" where ? is the full path of the mini Firebird environment directory.
4. The security.fdb file will be used to validate the username and password when you connect so you can either setup users in it or just set the sysdba password to a known value and login using sysdba. This security file is really a dummy file and will not provide any real security but its an embedded database so you are not looking for the same type of security a networked server would need.
5. The files all need to be owned by the user who will be opening the database so in my case they were all owned by me. Special care needs to be taken with the fb_lock_mgr since the one in /opt/firebird/bin is setup owned by firebird.firebird and with the setuid bit turned on but you will not need any of this for this configuration. In general if you're application is running as user "foo" then that user needs to have read/write access to the database you are trying to open, to the security.fdb file, and to the directory you installed the Firebird mini environment.
In your code you need to set the environment variable FIREBIRD to the location of the mini Firebird environment and then you should be able to use isc_attach_database and just pass a full pathname to the database file you want to use.
Here is the original article , but the site seems to be missing
http://web.archive.org/web/20070611151645/http://fbtalk.net/viewtopic.php?id=194
.:(firebird):..:(databases):..:(sql):.
Thursday, June 19, 2008
Back in from the cold - to firebird
I've been looking at several tools for this venture. Delphi is a requirement as I can deliver a great application to the intended audience using Delphi. I've looked very seriously at both Firebird and ElevateDB as the intended database that I will be using. I still have not made up my mind on these yet as both have their strong points.
If I end up going with Firebird, then I'll most likely be using the IBObjects components. I've used these before at a customer's site and have been impressed at the genuine speed that results.
http://stevepeacocke.blogspot.com/2008/06/back-in-from-cold.html
.:(firebird):..:(databases):..:(sql):.
building minimal php with only firebird/interbase extension
if you want to build minimal an php+firebird extension only setup
here is how to do it without xml/mysql/sqlite and all that stuff that
you might not need it
tar -jxvf php-5.2.6.tar.bz2
cd php-5.2.6/
./configure --disable-all --with-interbase --prefix=/tmp/foo
--with-apxs2=/usr/bin/apxs
make
make install
/tmp/foo/bin/
./php -m
[PHP Modules]
date
interbase
Reflection
standard
[Zend Modules]
and you can test the minimal php and eats less memory in apache/lighttpd/nginix
-- ls -lah php
-rwxr-xr-x 1 root root 6.5M 2008-06-19 17:35 php
.:(firebird):..:(databases):..:(sql):.
here is how to do it without xml/mysql/sqlite and all that stuff that
you might not need it
tar -jxvf php-5.2.6.tar.bz2
cd php-5.2.6/
./configure --disable-all --with-interbase --prefix=/tmp/foo
--with-apxs2=/usr/bin/apxs
make
make install
/tmp/foo/bin/
./php -m
[PHP Modules]
date
interbase
Reflection
standard
[Zend Modules]
and you can test the minimal php and eats less memory in apache/lighttpd/nginix
-- ls -lah php
-rwxr-xr-x 1 root root 6.5M 2008-06-19 17:35 php
.:(firebird):..:(databases):..:(sql):.
Tuesday, June 10, 2008
Wednesday, June 04, 2008
Firebird builds on both ARM and ARMEL
from this table you can see that firebird builds on both ARM and ARMEL ( ARMEL is just ARM with some hardware extras.)
http://buildd.debian.org/build.cgi?pkg=firebird2.0
and here is the buildlog
if you use debian then you can download from here
http://packages.debian.org/sid/armel/firebird2.0-super/download
According to http://eetimes.eu/showArticle.jhtml?articleID=199702110
from linux tiny
Arm shipped the processors in 250 million "smart phones" in 2006 (83%
market share in that niche).
According to ARM Inc. quarterly results for Q1 2007:
http://media.corporate-ir.net/media_files/irol/19/197211/press/Q12007EarningsRelease.pdf
In the first quarter of 2007, the licensees of ARM Inc. shipped 724 million
ARM processors. In one quarter. (ARM Inc. collected $45 million in license
fees, which is an average of 6.2 cents/processor.)
In a May 23 2006 presentation to ARM investors, ARM Inc. estimated its 2006
market share at 80-90% of the cell phone market, but only 21% of the larger
market. (The embedded world is big, folks.)
Drew highlighted five key growth areas for ARM between now and 2010...
[The first four are] set-top-box, high-definition television and DVD systems,
solid-state and hard disk drive storage, automotive electronics and 32-bit
microcontrollers. In these areas in 2006, ARM had market shares of 14, 20,
5 and 13 percent respectively... They are also market sectors that will
represent a total available annual market of nearly a billion cores or more
each in 2010. The biggest annual market opportunities are likely to be
automotive and 32-bit microcontrollers at 2.0 billion and 1.9 billion cores
each.
ARM's fifth key target market is the smart phone, where it is already
enjoying success. In this area the company shipped 250 million units in 2006
and has a market share of 83 percent, according to its own estimates.
.:(firebird):..:(databases):..:(sql):.
http://buildd.debian.org/build
and here is the buildlog
if you use debian then you can download from here
http://packages.debian.org/sid
According to http://eetimes.eu/showArticle
from linux tiny
Arm shipped the processors in 250 million "smart phones" in 2006 (83%
market share in that niche).
According to ARM Inc. quarterly results for Q1 2007:
http://media.corporate-ir.net
In the first quarter of 2007, the licensees of ARM Inc. shipped 724 million
ARM processors. In one quarter. (ARM Inc. collected $45 million in license
fees, which is an average of 6.2 cents/processor.)
In a May 23 2006 presentation to ARM investors, ARM Inc. estimated its 2006
market share at 80-90% of the cell phone market, but only 21% of the larger
market. (The embedded world is big, folks.)
Drew highlighted five key growth areas for ARM between now and 2010...
[The first four are] set-top-box, high-definition television and DVD systems,
solid-state and hard disk drive storage, automotive electronics and 32-bit
microcontrollers. In these areas in 2006, ARM had market shares of 14, 20,
5 and 13 percent respectively... They are also market sectors that will
represent a total available annual market of nearly a billion cores or more
each in 2010. The biggest annual market opportunities are likely to be
automotive and 32-bit microcontrollers at 2.0 billion and 1.9 billion cores
each.
ARM's fifth key target market is the smart phone, where it is already
enjoying success. In this area the company shipped 250 million units in 2006
and has a market share of 83 percent, according to its own estimates.
.:(firebird):..:(databases):..:(sql):.
debian build log firebird2.0/hurd-i386 failing reason
[Category: none]
> ../src/jrd/gds.cpp:176: error: 'MAXPATHLEN' was not declared in this scope
http://buildd.debian-ports.org/status/package.php?p=firebird2.0#fail-firebird2.0-hurd-i386
.:(firebird):..:(databases):..:(sql):.
Monday, June 02, 2008
Wednesday, May 28, 2008
firebird2.0 (2.0.4.13130-1.ds1-1) experimental; urgency=low
* New upstream bugfix release
+ adapt debian/get-orig-source.sh; remove more generated files
* refresh patches, drop patches present upstream:
cvs-security-remote-crash.patch
cvs_security-long-username_CVE-2008-0467_#463596.patch
* cvs-port-ia64.patch: drop -fno-rtti as RTTI is needed in 2.0. Hopefully
Closes: #460219 for real
* move booting ot autotools from patch to rules; cleanup rules; invoke
debconf-updatepo in clean target
* rules, make_packages.sh
+ determine version from src/jrd/build_no.h
+ unify with 2.1's version
* patches
+ add local-CFLAGS.patch from 2.1
+ merge create-run-dir into lock-file-location
+ terminate-lock-manager (as we supply CXXFLAGS from rules)
* add deprecated-charp-conversion.patch
+ add -Werror=write-string to exterminate that warning
* stop provifing libfbclient2 package, firebird2.1 (in experimental)
provides it. Instead, build-depend on it
.:(firebird):..:(databases):..:(sql):.
+ adapt debian/get-orig-source.sh; remove more generated files
* refresh patches, drop patches present upstream:
cvs-security-remote-crash
cvs_security-long-username_CVE
* cvs-port-ia64.patch: drop -fno-rtti as RTTI is needed in 2.0. Hopefully
Closes: #460219 for real
* move booting ot autotools from patch to rules; cleanup rules; invoke
debconf-updatepo in clean target
* rules, make_packages.sh
+ determine version from src/jrd/build_no.h
+ unify with 2.1's version
* patches
+ add local-CFLAGS.patch from 2.1
+ merge create-run-dir into lock-file-location
+ terminate-lock-manager (as we supply CXXFLAGS from rules)
* add deprecated-charp-conversion
+ add -Werror=write-string to exterminate that warning
* stop provifing libfbclient2 package, firebird2.1 (in experimental)
provides it. Instead, build-depend on it
.:(firebird):..:(databases):..:(sql):.
Friday, May 23, 2008
firebird2.1 Debian package for itanium
The firebird2.1 Debian package has been successfuly built[1] on IA64
[1] http://experimental.debian.net/fetch.php?&pkg=firebird2.1&ver=2.1.0.17798-0.ds1-4&arch=ia64&stamp=1211549239&file=log&as=raw
.:(firebird):..:(databases):..:(sql):.
[1] http://experimental.debian.net
.:(firebird):..:(databases):..:(sql):.
geting firebird locks
sudo /usr/lib/firebird/2.1/bin/fb_lock_print
[sudo] password for xxxx:
LOCK_HEADER BLOCK
Version: 244, Active owner: 0, Length: 1048576, Used: 25208
Semmask: 0x0, Flags: 0x0001
Enqs: 1530, Converts: 0, Rejects: 342, Blocks: 42
Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
Acquires: 0, Acquire blocks: 60060822667264, Spin count: 0
Mutex wait: inf%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 0
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners: *empty*
Free owners (9): forward: 20848, backward: 21040
Free locks (21): forward: 24384, backward: 21752
Free requests (20): forward: 23872, backward: 21560
Lock Ordering: Enabled
Event log:
DEL_OWNER: owner = 20848, lock = 20848, request = 0
DEL_OWNER: owner = 22200, lock = 22200, request = 0
DEL_OWNER: owner = 21368, lock = 21368, request = 0
DEL_OWNER: owner = 21040, lock = 21040, request = 0
The tool for checking the lock table is fb_lock_print, which is a command line utility in the bin directory of the Firebird installation tree. The full lock print describes the entire state of the lock table and is of limited interest. When your system is under load and behaving badly, invoke the utility with no options or switches, directing the output to a file
Read more on this page
http://ibdeveloper.com/issues/issue-2-oct-17-2005/locking-firebird-and-the-lock-table/
.:(firebird):..:(databases):..:(sql):.
[sudo] password for xxxx:
LOCK_HEADER BLOCK
Version: 244, Active owner: 0, Length: 1048576, Used: 25208
Semmask: 0x0, Flags: 0x0001
Enqs: 1530, Converts: 0, Rejects: 342, Blocks: 42
Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
Acquires: 0, Acquire blocks: 60060822667264, Spin count: 0
Mutex wait: inf%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 0
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners: *empty*
Free owners (9): forward: 20848, backward: 21040
Free locks (21): forward: 24384, backward: 21752
Free requests (20): forward: 23872, backward: 21560
Lock Ordering: Enabled
Event log:
DEL_OWNER: owner = 20848, lock = 20848, request = 0
DEL_OWNER: owner = 22200, lock = 22200, request = 0
DEL_OWNER: owner = 21368, lock = 21368, request = 0
DEL_OWNER: owner = 21040, lock = 21040, request = 0
The tool for checking the lock table is fb_lock_print, which is a command line utility in the bin directory of the Firebird installation tree. The full lock print describes the entire state of the lock table and is of limited interest. When your system is under load and behaving badly, invoke the utility with no options or switches, directing the output to a file
Read more on this page
http://ibdeveloper.com/issues/issue-2-oct-17-2005/locking-firebird-and-the-lock-table/
.:(firebird):..:(databases):..:(sql):.
Thursday, May 22, 2008
firebird 2.1 for fedora 9 and fedora 8
here is for fedora 9
http://mirror.yandex.ru/fedora/tigro/9/i386/
here is for fedora 8
http://mirror.yandex.ru/fedora/tigro/8/i386/
.:(firebird):..:(databases):..:(sql):..:(fedora):..:(linux):.
http://mirror.yandex.ru/fedora/tigro/9/i386/
here is for fedora 8
http://mirror.yandex.ru/fedora/tigro/8/i386/
.:(firebird):..:(databases):..:(sql):..:(fedora):..:(linux):.
maintainer for suse offer
http://thread.gmane.org/gmane.linux.suse.opensuse.packaging/2237
Hi I'm Philippe Makowski
I'm a member of Firebird Project and will be pleased to help you
as I did for Mandriva
May I suggest you start from the Mandriva RPM
http://distrib-coffee.ipsl.jussieu.fr/pub/linux/MandrivaLinux/devel/cooker/SRPMS/contrib/release/
firebird-2.0.4.13130.1-1mdv2009.0.src.rpm
In Mandriva you will find also rpm for Flamerobin,
PHP driver, Python driver, Java driver
just let me know what you need or to what or other things
I have to subscribe
I would be pleased to setup an opensuse box to test your future work
.:(firebird):..:(databases):..:(sql):.
Old security bug fixed already in 2.0.4 and 2.1
Security vulnerability in Borland InterBase
A security vulnerability discovered early this year in open source database Firebird also affects Borland's InterBase. The security vulnerability allows ...
.:(firebird):..:(databases):..:(sql):.
A security vulnerability discovered early this year in open source database Firebird also affects Borland's InterBase. The security vulnerability allows ...
.:(firebird):..:(databases):..:(sql):.
Popularity contest statistics for firebird2.1
here are stats for debian firebird2.1 installs
http://qa.debian.org/popcon.php?package=firebird2.1
.:(firebird):..:(databases):..:(sql):.
http://qa.debian.org/popcon.php?package=firebird2.1
.:(firebird):..:(databases):..:(sql):.
Wednesday, May 21, 2008
firebird ports for intanium and hppa
if you watch the debian building logs for different architectures then there are a few ones left to be done , intanium , hppa and alpha (dead one)
http://buildd.debian.org/build.cgi?pkg=firebird2.0
and seem that this will be solved very soon
.:(firebird):..:(databases):..:(sql):.
http://buildd.debian.org/build.cgi?pkg=firebird2.0
and seem that this will be solved very soon
.:(firebird):..:(databases):..:(sql):.
Subscribe to:
Posts (Atom)