Friday, December 23, 2005
Latest Firebird Relational Database Released (Pre Final)
Release Candidate 3 is available for download and testing.
This sub-release introduces a number of retrospective fixes (backports) to bugs that became apparent and were fixed in the Firebird 2 tree during the alpha and beta phases of the Firebird 2.0 development. This release candidate (RC3) will become the final stable version in about a few days.
It is probably OK to regard this as the final release version, but we do not guarantee that something won't appear during this pre-release round.
..::firebird::..
For all Firebird fans we've prepared a nice gift - Firebird 2006 Calendar.
Dear Friends,..::firebird::..
I sincery wish you Merry Christmas and Happy New Year!
I hope you will be our readers in forthcoming year.
For all Firebird fans we've prepared a nice gift - Firebird 2006 Calendar.
Details: http://ibdeveloper.com/calendar-2006/
All garthered funds will be used for preparing next issues of our free magazine.
With best regards,
Alexey Kovyazin
Editor-In-Chief
The InterBase and Firebird Developer Magazine
Thursday, December 22, 2005
Synapse-EMR electronic medical records system that uses the open source RDBMS Firebird.
Synapse-EMR is a powerful multi-user electronic medical records system that uses the open source RDBMS Firebird.
[ED:I like the technical]
Synapse-EMR is written using REBOL, a functional programming language with an internet bias. The GUI is written using Ashley Truter's great RebGUI, which provides added functionality over REBOL's original Visual Interface Dialect. Communication between the client and server is by multiple asynchronous encrypted tcp channels which produces a very flexible and responsive GUI.
Although apparently a client-server architecture, the server is also capable of acting as a client to another server instance allowing a number of servers to share anonymous epidemiological information, as well as provide secure messaging between servers.
Synapse-EMR uses the open source RDBMS Firebird to store all data. Firebird has a long history starting off life originally as Borland's Interbase. Firebird is reknown for being a zero administration ANSI SQL-99 database that is suitable for use in mission critical systems. It is free of licensing restrictions.
..::firebird::..::rebol::..
Firebird Blogs of the week
"I don't know if I have posted this before, but everyone should be a programmer. If you work with computers at all, which for better or worse most of us do, you can make your lives much easier.
For instance: My business deals with a lot of peoples Interbase databases (Well, Firebird but you get the idea)."
More on Robin's Aussie Blog
Writing some classes in php
"Last friday i was kinda bored at work so i decided to renew my functions and write some classes, so i started with the ones that i use most, and just wrote a class to conect, execute a sql query and return an array with the data using a firebird database, nothing really usefull, but makes my life easier :)"
by Fabio Gomes on his own yet another coding blog
How to start firebird on slackware (or any linux) Indonesian blog written by Budi Raharjo
[ED: blogger Location JAWA Barat - nice name i remember some motor bikes with JAWA name)
..::firebird::..
Firebird 1.5.3 in gobolinux.org
" GoboLinux is an alternative Linux distribution which redefines the entire filesystem hierarchy.
In GoboLinux you don't need a package manager because the filesystem is the package manager: each program resides in its own directory, such as /Programs/Xorg/6.7.0/ and" /Firebird-client/1.5.3/
..::firebird::..::linux::..
Firebird was almost interesting...
Quote from planet.debian.org blog
"I was looking at the Firebird database recently. Free Software, very feature complete, and one neat feature was that it could run either client/server (like PostgreSQL) or as a standalone .so (like Sqlite). I was starting to look into using it.
Then I discovered it only supports i386 on Linux, and no progress has been made in 3 years on that."
False firebird is supported on other arhitectures
Firebird2 now builds and runs just fine on amd64.
Anyone with access to anything other than i386 or amd64 is warmly welcome to
try to build it and contact developers
Quoting From Vulcan Overview
Vulcan had four primary goals.
• Portability: Vulcan was developed simultaneously on four platforms: 32 bit
Windows using the Microsoft compiler from Visual Studio 7, 32 bit Linux and 64
bit Linux for AMD64/Opteron using various versions of gcc, and 64 bit Solaris
using the Sun Forte C++ compiler. Ports exist to 64-bit MVS UNIX, Itanium, and
AIX. See the Portability section.
Portability
Firebird
Firebird V1.5 and V2.0 are sensitive to minor variations in C++ compilers, which is a
serious liability given the somewhat cavalier attitude of compiler developers toward
version-to-version compatibility.
Vulcan
Vulcan was developed on four compilers simultaneously: gcc 2.96, gcc 3.3.4,
Solaris/Forte 5.5, and Microsoft VC7. To make that work, Vulcan eliminated the
dependency on std.lib, minimized all other dependencies outside the core clib (c library),
and reduced the complexity of template usage
..::firebird::..::debian::..::ubuntu::..
Wednesday, December 21, 2005
A review of "GoldMine Corporate Edition 7.0" - They are using firebird
Source for news ibphoenix.com
..::firebird::..::crm::..
Explaining interbase bottlenecks
TPC-C sources, TPC-R vulcan, firebird tests on the way
Hello everyone,
Thanks for attention. Next step will be testing beta versions (Vulcan and Firebird 2), simultaneously we’re working at TPC-C, which is closer to real-life. After that we have plans to run such test on other DBMS.
Marius, all sources for tests are available here http://ibdeveloper.com/tests/tpc-r/how-to-run-tpc-r-based-test/
Sincerely, Alex Kovyazin
..::firebird::..
Firebird mention in tuxjournal.net - blog of the day
http://www.tuxjournal.net/wordpress/?p=17
..::firebird::..::linux::..
xBaseView 6.2 with firebird support
http://www.totalcmd.net/plugring/xBaseView.html
..::firebird::..::databases::..
ADODB 4.68 released (Default branch)
More on freshmeat.net
..::firebird::..::php::..
EMS SQL Manager for InterBase/Firebird (ver. 3.9.5)
Tuesday, December 20, 2005
Friday, December 16, 2005
Firebird File and Metadata Security
Existing manaul docbooked and added to our documentation collection: Firebird File and Metadata Security by Geoff Worboys.
..::firebird::..::security::..
KInterbasDB 3.2a1 released
----------------------------
The primary goals of version 3.2 are:
- the removal of internal limits
- the exposure of more sophisticated features to the client programmer
- optimization
The code has been overhauled to enhance robustness and performance.
The documentation in general, and the Usage Guide in particular, have
already been updated to cover KInterbasDB 3.2.
The documentation, including a specific changelog, is available online at:
http://kinterbasdb.sourceforge
Where can I learn more about and download KinterbasDB?
------------------------------
http://kinterbasdb.sourceforge
..::firebird::..::python::..
Thursday, December 15, 2005
firebird blog of the day - Carlos Guzmán Álvarez
Is in Spanish
http://carlosga.blogspot.com/
..::firebird::..::mono::..::dotnet::..
Firebird Banner is here
Well, I just did one...
Get it on www.firebase.com.br/fb/banners
I hope you enjoy ;)
Carlos H. Cantu
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
..::firebird::..
Wednesday, December 14, 2005
Pentaho = Open-source Business Intelligence with Firebird
Business Model: The company sells open-source business intelligence software that includes: reporting, analysis, dashboards, data mining, and workflow. It is stewarding the development of a interoperable suite of software components that can be configured into an integrated BI stack. Open-source projects that it supports include: Mondrian OLAP Server, JPivot, Firebird RDBMS, Enhyra Shark, Weka Data Mining, and Eclipse BIRT.
..::firebird::..
Firebird article in "Entwickler Magazin"
in the forthcoming edition of the well-known German development magazineand babelfish translation
"Entwickler Magazin", there will be an article about Firebird 2.0.
The cool thing *this* time is, that the article isn't only available in
the printed edition, but also Online (in German of course):
http://www.derentwickler.de/itr/online_artikel/psecom,id,783,nodeid,56.html
Enjoy!
Regards,
Thomas
..::firebird::..
Ruby on Rails 1.0 Released with firebird support
Rails works with a wealth of web servers and databases. For web server, we recommend Apache or lighttpd running either FastCGI or SCGI. For database, you can use MySQL, PostgreSQL, SQLite, Oracle, SQL Server, DB2, or Firebird. Just about any operating system will do, but we recommend a 'nix-based one for deployment."
http://otherthingsnow.blogspot.com/2005/12/ruby-on-rails-10-released.html
and slashdot
http://developers.slashdot.org/article.pl?sid=05/12/14/0034219&tid=156&tid=8
..::firebird::..::ruby::..::rubyonrails::..
Tuesday, December 13, 2005
FireRuby included in RubyOnRails 0.14.4 (Active Record 1.13.1)
"Now with integrated goodness! It looks like Rails 0.14.4 (Active Record 1.13.1) has the Firebird Adapter and patches to work with Firebird. Worked out the box for me with Firebird 1.5 Superserver. Skip the patching directions but all the usage rules below still apply."
..::firebird::..::ruby::..::rubyonrails::..
FireRuby 0.4.1
over the Firebird open source RDBMS C API.
This is a maintenance release. Work on getting the library working on a 64 bit
platform threw up some (ahem!) questionable code. This code was corrected and
this release brings those updates to all existing supported platforms. A 64
bit Linux build has also been created and added to the list of available gems.
Thanks go to David Walthour for getting the 64 bit version working.
No new functionality has been added for this release and all existing
functionality remains unchanged. As usual check the README that accompanies
the release for more details.
..::firebird::..::ruby::..::rubyonrails::..
Which DB is more compatible with Lazarus?
Will there be a native component for mysql5 into Lazarus?
There already is. That is, if you use the newest fpc version from svn.
(2.0.3 or 2.1.1)
Then install the sqldb package that you can find in the components
directory of your Lazarus installation.
> It's not a troll but which DB is more compatible with Lazarus?
> eepascal.org/mailarchives
Sqldb, which is part of fpc supports Mysql 4.0,4.1,5.0,
firebird/interbase, postgresql, ODCB and Oracle.
Firebird/Interbase and Oracle supports the most features. Followed by
Postgresql, ODBC and the least supportive is MySQL.
Firebird/Interbase is tested and used the most. Oracle is brand new, and
no-one tried it really...
So if you can choose your database, I would go for Firebird, Postgres or
eventually Oracle.--
Met vriendelijke groeten,
Joost van der Sluis
CNOC Informatiesystemen en Netwerken
http://www.cnoc.nl
..::firebird::..::mysql::..::postgresql::..::oracle::..
Mac OSX (10.4) port of Firebird 3.0 (Vulcan)
The Mac OSX port of Vulcan is working though it hasn't
been tested multi-user, and has some rough edges in the
build. It uses gcc 4.0 which offers some warnings that
I could live without, and will figure out how to eliminate.
Here's the procedure.
1) download vulcan from CVS
2) define the environmental variable VULCAN to be
/install
3) define ISC_USER and ISC_PASSWORD as SYSDBA and
masterkey respectively.
4) add $VULCAN/install/bin to your PATH variable
5) add $VULCAN/install/bin to your DYLD_LIBRARY_PATH
variable
6) edit the fileautogen.sh changing all
instances of libtool and libtoolizer to glibtool
and glibtoolizer respectively.
7) run autogen.sh
8) go to the/src/buildgen directory and
9) make buildgen (i.e. type "make")
10) in the same directory type "make install"
11) go to the/src directory
12) edit the files build and boot_build, changing gmake
to make.
13) test that you can find buildgen (which buildgen)
14) fix whatever it is that keeps you from finding buildgen
15) type "./set_platform darwin" - without the quotes of course.
16) run boot_build piping output and errors to a file.
You'll find a number of warnings about the incorrect use of
offsetof macro - MemMgr and a few other files. It works fine.
Jrd reports lots of multiply defined symbols from gds.o but
appears to work find and won't link on Windows without gds.o.
Burp gives lots warnings about
non-local variable ':: ::isc_xxx
uses anonymous type. It works too.
Regards,
Ann W. Harrison
..::firebird::..::macosx::..
Monday, December 12, 2005
Morfik crew released Alpha version of their Ajax IDE - WebOS
More on http://www.ajaxdeveloper.org/news/597
..::firebird::..
Events API implementation in Jaybird
I've just committed the initial implementation of the Events API into
CVS. Up until now it's only been tested on my system (Linux), so I'd be
particularly interested in hearing from anyone who can test it on
Windows and other systems.
For anyone who's interested in trying it out, I would suggest looking in
the javadoc for org.firebirdsql.event.FBEventManager. It should
(hopefully) be quite self-explanatory. If there are any suggestions,
problems, questions, etc. please don't hesitate to post them.
Regards,
Gabriel
..::firebird::..
InterBase 7.5.1 and Firebird 1.5.2 TPC-R based test results
"Our first goal was testing of existed current release versions of InterBase and Firebird – InterBase 7.5.1 and Firebird 1.5.2 accordingly. Well, we’ve encountered problems with InterBase 7.5.1 testing – it generated so bad plan for queries 3 and 20 that we were not able to wait its finishing, so these queries were omitted in test results."
..::firebird::..
Firebird is a very impressive DB - blog of the day
"Firebird is a very impressive DB and could easily gain market share if those who develop it tried harder to create a buzz about it. It is free, has paid support if you want it, has many years development behind it, is light in resource usage, is cross-platform and has had many features for years (such as stored procs) which MySQL only recently gained. One to watch."
http://www.argolon.com/?p=35
..::firebird::..
Friday, December 09, 2005
Firebird Internal Engine Version 8.0 = 3.0 (aka Vulcan)
> Does anybody know what version FB would now be at if it hadn't been
> renamed, re-branded etc over the last 21 years?
There was only one release of Rdb/Eln... So add
1 to all the InterBase numbers. If you consider V1.0
of Firebird equivalent to V7.1 of the long historical
record, V1.5 is V7.5, and the new one is V8.
Best,
Ann
..::firebird::..
Sourceforge Google Firebird
On 12/9/05, paulruizendaalwrote:
> If you type "sourceforge" in Google, Firebird appears as result #9.
> Somehow Firebird is more closely associated with sourceforge than
> almost all other popular projects.
Interesting ,
Is good reason to suggest sf.net so they include firebird in project
of the month
http://sourceforge.net/potm/
(Interested in having your project be Project of the Month? Here's
how to apply, it's easy: Write a note to staff at sf.net with the subject
line: POTM. Mention your project name and why you think your project
should be selected.)
ps: maybe the news page on sourceforge should be updated ,
News is included in sourceforge newsletter (more eyeballs)
http://sourceforge.net/news/?group_id=9028
..::firebird::..
Fyracle 0.8.10 released
=======================
Changes:
- Added support for Delphi clients
- Added support for CAST expressions
- Added support for CREATE PACKAGE, etc.
- Added support for overloading
- Fixed the behaviour of CHECK constraints
when dealing with NULL values
- Many bug fixes and small enhancements
Download:
The new runtime installers can be downloaded from:
http://www.fyracle.org/downloads
The developer kit can be downloaded via:
http://www.janus-software.com/fb_buy.html
Read the rest on fyracle news group
..::firebird::..::oracle::..
Compiere 2.5.3a for Fyracle released
version 2.5.3a. The Compiere port has been created by our
partner "Jotel" and can de downloaded from:
http://www.jotel.com.pl/index.php/39/0/?&L=1
User happily working with Compiere 2.5.1g can continue
to do so. For these users, Fyracle 0.8.10 fixes a regression that had been introduced in Fyracle 0.8.7
Note that "porting" Compiere is mainly adding a Fyracle option to the login screen and moving the default database content; The core of the Compier code is unchanged. The big work in "porting" Compiere is carefully test the functionality and ensure that things work as they should.
Support for Compiere on Fyracle is available:
http://www.jotel.com.pl/index.php/37/0/?&L=1
..::firebird::..::oracle::..
quote of day - alternative to mysql
It's MySQL (GPL version!!) that doesn't allow this, you need a commercial license.Let me add that Firebird is an excellent embedded database."
Read the rest on devshed forum
..::firebird::..
Firebird useful resources
Today, AJAX Enters The Next Phase (With Firebird help)
Morfik, a company from Tasmania, has a very cool tool they call WebOS. WebOS is, to put it plainly, an AJAX IDE. As far as I know, it is the first one. You don't have to know javascript, or PHP, or how to configure Apache or mySQL, or some other server to build AJAX applications. You can use a graphical environment, draw up tables and queries, draw forms, reports, etc., and write your code in Basic, Pascal, C#, or Java and WebOS will build both the client and server side portions for you. The Server side is a combination of Apache for the web server and Firebird for the database server.
Read the rest on Ajax developer (blog)
..::firebird::..
The Inquirer: Open Source databases rounded up and rodeod
the market, highlighting the recent MySQL vs Oracle InnoDB mess as an
example. FB gets a mention in the round-up.
http://www.theinquirer.net/
[quote]
*Firebird*
Date established: 1984
Number of employees: 15
Latest release: Firebird 1.5.3, released in July
Strong points: A very mature database requiring minimal administration,
full-featured SQL ACID-compliant database engine that implements most of
the SQL-99 standard. Compiere module runs Oracle PL/SQL code, highly
portable, available in three sizes: classic, superserver and embedded,
supports databases that can span multiple files with a theoretical limit
of 64 terrabytes for a single-file database.
Weak points: Needs better public relations
Executive quote: Ann Harrison, CTO, "Our current focus is targeting
application developers creating applications for resale. We think this
is an area not well served by MySQL because of their GPL, and not well
served by postgres because it is not designed to be installed transparently"
Recent news: Very successful conference in Prague, prepping the V2.0 Beta
[/quote]
Scott
..::firebird::..::mysql::..::postgresql::..::oracle::..::mssql::..
Thursday, December 08, 2005
Turbocash looks to Linux/Firebird for expansion
http://www.tectonic.co.za/view.php?id=756
..::firebird::..
Wednesday, December 07, 2005
Firebird Slackware package [DONE]
"This site is dedicated to the the enrichment and enhancement of the Slackware Linux operating system. We are gathering a vast resource of Slackware packages from around the world. "
http://www.linuxpackages.net/pkg_details.php?id=8274
ps:some romanians are involved with site code
This web site is hand coded, it is not based off any nuke puke or any of those other prefab portals. The backend alone is a monster amount of php code and continues to grow.
Mihai Ionascu (mihai at roundpixel dot org) - Graphic DesignCristian Voinea (trotter at opensys dot ro) - HTML template
Robert Stan (robalo at linuxpackages dot net) :-)
Jason Woodward (woodwardj at jaos dot org) Backend scripts
John Vallejos (jav at linuxpackages dot net) Package approvals and Good friend
..::firebird::....::linux::....::slackware::..
Firebird blog of the day
..::firebird::..
Firebird Expert released
Devrace have released FIBPlus V6.30
..::firebird::..
Firebird Database Workbench v2.8.0 released!
Database engines supported
* InterBase
* Firebird
* Microsoft SQL Server
* MySQL
* Oracle
New Features
Version 2.8 includes new features like:
* Microsoft SQL Server 2005/SQL Express 2005 support
* MySQL 5 support
* Increased Oracle support (v8, 9 and 10)
* Two-way Visual Query Builder
* Create INSERT script from any ODBC datasource
and much more...
Enhancements and bugfixes
Version 2.8 also includes many enhancements to make development easier and many bugfixes in many areas. Enhancements include:
* New "SQL Insight" module
* Code/SQL Editor enhancements
* Many user interface enhancements
* More complete Schema Migrate/Compare features
* Automatic image-type recognition in BLOB Editor
Download now: http://www.upscene.com
..::firebird::..
New version of Interbase/Firebird Development Studio has been released
includes several new features and major improvements:
- Code Formatting
- Data Browser - a very useful tool to browse data from linked tables.
- Plan Analyzer is able to extract selectivity values for indicies used in the query plan.
- Database Designer now contains SQL Script objects.
A lot of minor improvements and fixes have been made.
30 days trial version is available from our download page:
http://www.sqlly.com/download.html
More detailes about Interbase/Firebird Development Studio can be found on
these pages:
http://www.sqlly.com/IBDS.html
http://www.sqlly.com/dbdesigner.html
--
Best regards,
Pavel Kutakov
SQLLY Development team
..::firebird::..
Monday, December 05, 2005
The InterBase and Firebird Developer Magazine - third edition
I am glad to announce the third issue of “The InterBase and Firebird Developer Magazine”. Electronic version is available for free download here:
www.ibdeveloper.com/issue3/ibdeveloper03.zip
www.ibknowledgebase.com/download/ibdeveloper03.zip
http://www.ibsurgeon.com/download/ibdeveloper03.zip
Printed version is also available:
http://www.lulu.com/content/196160
We have done a lot of work and I hope you will enjoy new design and quality of our magazine (especially “luxury”print version).
Please do not forget to express your opinions, thoughts and suggestions in blog or via email readers@ibdeveloper.com
Sincerely yours,
Alexey Kovyazin
Editor-In-Chief
The InterBase and Firebird Developer Magazine
..::firebird::..
Migrating from InterBase 6.01 to Firebird 1.5 / 2.0
..::firebird::..
JayBird 2.0.1 released
release following bugs were fixed:
* Bug 1370017. NullPointerException in updatable result set if new value is
set to null.
Best regards,
Roman Rokytskyy.
.::firebird::..
Friday, December 02, 2005
FSQL v1.4.0
It has some enhancements, like commands to import data from csv,
show attached users, inserting file contents into blob, etc.
To list new commands execute HELP command, short description,
some examples, and link for download is here:
http://www.volny.cz/iprenosil/interbase/
Any feedback is welcome.
Ivan Prenosil
..::firebird::..