TurboCASH on Lazarus/Firebird "proof of concept"

Developers from turboCASH are asking for Lazarus programers (people that program using Lazarus IDE) to set up a small test application to prove that Lazarus can be IDE of choice to port turboCASH to Linux.

there is information on how to adapt existing turboCASH code to run on Lazarus here:

http://www.box.co.za/wiki/index.php/Roadmap_Linux#Lazarus

Also read the original mail from turboCASH developer Philip Coperman:

-----------------------------------

Can anyone help with the following on Linux:

1) Setup a simple "proof of concept" in Lazarus

-------------------------------------------------------------
1) Lazarus and Linux

There are some useful contributions on Getting Lazarus and TurboCASH for Linux going here:

http://www.box.co.za/wiki/index.php/Roadmap_Linux#Lazarus

We have decided to use Firebird (80%) and possibly support MySQL (20%). In the Windows Project we are converting the current Delphi Code to work with Firebird and will add MySQL support if required afterwards. (In my project experience, that becomes unlikely)

I am now more concerned about:

1) How we are going to connect to the Firebird Database (and/or MySQL) - In Delphi we are using ZEOS Lib

2) What are we going to use for a Grid. In Delphi/Windows we use a quality commercial package - Infopower. I have struggled to find and Open Source alternative. Project Jedi seems to offer the best. The Grid is what gives TurboCASH batches and invoices that really friendly Spreadsheet look. How will we do this in Lazarus/Linux?

3) How are we going to write reports - In Delphi Linux we use Free Reports and Reportman. We have a legacy history with Quick Reports.

If you Linux guys (Even the Lazarus on Windows guys) - Could do the following :

i) Download the TurboCASH/Delphi project. Steal whatever you need
ii) "Open " a set of books simply by connecting to the TurboCASH Fro bird Database
iii) Set up any grid you like to edit any record you like in TurboCASH
iv) Write a simple report (take any one of ch windows one)

If we can do the above we can consider Lazarus as a serious proposition.
..::firebird::..::mysql::..::delphi::..::pascal::..

Wolf , Dolphin and Firebird - Story

Quote of the day

Until then, as Mickos has reportedly said, MySQL is sticking by the premise that trying to kill open-source products by buying companies that make open-source products is like trying to kill a dolphin by drinking the ocean.

..::firebird::..

MySQL Makes an Acquisition - Blog of the day

A bit more on a previous post about the acquisition offer Oracle made MySQL recently. The more I think about it, the more I think SAP is the intended target here. Why? Just look at the money involved.
Read Jeremy's Blog
MySQL::..:: Netfrastructure::..:: Firebird::..:: Oracle::..:: SAP::..:: Open Source

What will be fixed in Firebird v2.0 Release Candidate 1 - Tales from the Changelog

    * Fixed unregistered bug
        A few types of subqueries are wrongly treated as being variant,
        causing performance issues
      Contributor(s):
        Dmitry Yemanov 

    * Fixed Beta 2 bug (SF #$1433583)
        Unexpected error "key size exceeds implementation restriction" for UTF-8 charset
      Contributor(s):
        Adriano dos Santos Fernandes 

    * Fixed unregistered bug
        Indices used in explicit plans inside PSQL could be dropped, thus causing restore issues
      Contributor(s):
        Adriano dos Santos Fernandes 

    * Fixed unregistered bug
        fb_lock_print fails with message:
        "the requested operation cannot be performed on a file with a user-mapped section open".
      Contributor(s):
        Vlad Horsun 

    * Information API enhancements
        1) isc_info_active_transactions_count returns number of active transactions (SF #1315814)
        2) isc_transaction_info returns transaction isolation level and options (SF #1089646)
        3) isc_info_creation_date returns creation date of the database
      See also:
        /doc/sql.extensions/README.isc_info_xxx
      Contributor(s):
        Vlad Horsun 

    * Fixed unregistered bug
        Transaction ID cannot silently (and dangerously) overflow anymore (the limit is still 231)
      Contributor(s):
        Vlad Horsun 

    * Fixed unregistered bug
        Read committed transactions block garbage collection
      Contributor(s):
        Vlad Horsun 

    * Fixed unregistered bug
        ALL predicate may return wrong results
      Contributor(s):
        Dmitry Yemanov 

    * Fixed unregistered bug
        Thread safety issues in datetime functions of the FBUDF library
      Contributor(s):
        Claudio Valderrama 

    * Build improvement
        FBUDF library no longer depends on FBCLIENT
      Contributor(s):
        Claudio Valderrama 

    * Fixed unregistered bug
        Permissions are not checked for view columns
      Contributor(s):
        Dmitry Yemanov 

    * Fixed unregistered bug
        Server crashes if positioned UPDATE/DELETE is executed via DSQL
        and it references a cursor which is already released.
      Contributor(s):
        Vlad Horsun 

    * Fixed SF bug #1404157
        DFW is not ready for RECREATE TABLE/VIEW
      Contributor(s):
        Dmitry Yemanov 

    * Fixed unregistered bug
        Restored the code which replaces ROLLBACK with COMMIT if a transaction
        has not modified any data
      Contributor(s):
        Dmitry Yemanov 

    * Fixed unregistered bug
        ROW_COUNT is cleared after SUSPEND execution
      Contributor(s):
        Dmitry Yemanov 

    * Fixed SF bug #1408079
        Parser does not validate string literal markers
      Contributor(s):
        Claudio Valderrama 

    * Fixed Beta 2 bug
        Incorrect ambiguity error raised for quantified predicates (ANY/ALL/IN)
      Contributor(s):
        Arno Brinkman 

    * Fixed unregistered bugs
        1) Wrong statistics if relation\index data is longer than 232 bytes length
        2) Wrong statistics: average index key length rounded to integer value
      Contributor(s):
        Vlad Horsun 

    * Fixed unregistered bug
        Attachments with isc_dpb_no_garbage_collect option force the sweep
      Contributor(s):
        Vlad Horsun 

    * Fixed Beta 2 bug
        Wrong string length calculated for UNICODE_FSS system domains
        in users views and tables
      Contributor(s):
        Adriano dos Santos Fernandes 
        Dmitry Yemanov 

    * Fixed Beta 2 bug
        Incorrectly stored source for CURRENT_TIME\CURRENT_TIMESTAMP
        in procedure parameters default values
      Contributor(s):
        Vlad Horsun 

..::firebird::..

World Domination with Firebird - Mastering Firebird Book

“The Firebird Book” is now avalable in Portuguese, "Dominando Firebird: Uma Referência Para Desenvolvedores de Bancos de Dados".

Brazilian’s version of Helen Borrie’s book was released today by LCM publisher, the same publisher of “Firebird Essencial“. In some weeks, LCM will release the “IB Expert” book in portuguese and a new book about Firebird Security Tips (by Luiz Paulo de O. Santos). Helen’s book title was changed to “Dominando Firebird”, something like “Mastering Firebird”.

Permalink

..::firebird::..

OSDB market soap opera update (mysql and firebird)

A quick pointer to the news announcement that mysql has purchased a company called netfrastructure inc, which happens to employ Jim Starkey (one of the founders of InterBase, an ancestor to Firebird) and perhaps more importantly Ann Harrison, one of th…
..::firebird::..::mysql::..::postgresql::..

What has happened to the Open Source Database Consortium?

A while ago, people from the major Open Source
database systems have met to form the Open Source Database Consortium - that was in October 2005.

OK,
that's not that long ago, but I hope that the ambitions to co-operate
aren't over again. It was told that a website will be created at www.osdbconsortium.org.
There's nothing to see except a "Just a web page" note. I haven't heard
any news about this since October - I believe, it would be nice if
MySQL, PostgreSQL, Firebird etc. could do some things together. That
would certainly be more welcoming than any deal with a proprietary
database vendor.

Read more on :Markus Popp's blog
..::firebird::..::mysql::..::postgresql::..

Oracle - they are just anti RDBMS competition - quote of the day

But on the whole Oracle isn't anti-open-source (look at what they are doing with linux), they are just anti RDBMS competition, and especially anti commercial RDBMS competition (and especially anti anti against RDBMS and SAP competition).

From Robert Treat blog via planetpostgresql.org

..::firebird::..::mysql::..::oracle::..

MySQL's response to Oracle's moves

MySQL have responded in the best way they can by Acquiring Netfrastructure, Inc, and as part of the agreement Jim Starkey will be working fulltime for MySQL AB. Jim Starkey is the father of Interbase (which forked into Firebird) as well as the inventor of the term blob.

Digg it
..::firebird::..::mysql::..::oracle::..

the wolf is gone to mysql - Jim Starkey joined MySQL AB

Jim Starkey, the original creator
of InterBase which became Firebird, just made it publicly known that he
now works for MySQL AB.

My company, Netfrastructure, Inc., has been acquired by MySQL, AB. As

part of the agreement, I will be working full time for MySQL. I expect

to lurk on the architecture list from time to time and may contribute

the occasional wolf-o-gram, but I will not be taking an active part in

Firebird development. Although Ann will work for MySQL, part time,

translating from wolf to English, she will continue to be active in the


Firebird project.

My decision to join MySQL has almost nothing to do with Firebird and

everything to do with Netfrastructure. The Netfrastructure platform

represents what I feel about contemporary computing hardware and future

application requirements, and has been the center of my technical heart

and soul for six year. Some aspects of Netfrastructure technology have

already been contributed to the Vulcan project, but Firebird and

Netfrastructure are architecturally incompatible. An attempt to

integrate the technologies would be unlikely to meet the goals of either


project.

MySQL and Firebird have never seen each other as competitors and I doubt

this will change in the future. The projects have different open source

philosophies, different technologies, different customer bases, and

different sweet spots. The ideas behind the two projects are, happily,

public and available to all. If MySQL and Firebird compete, it is only

competition in offering the best possible support to their respective

customers.

I am pleased to have had the opportunity to finish the Vulcan project.


The combination of Vulcan SMP and architecture combined the rich feature

set of Firebird 2 will make a solid release and a superb platform for

future development.

I wish the Firebird project all the best in years to come. And if you

need an opinion, please feel free to call.

Permalink
| Leave your comment
..::firebird::..::mysql::..

Backup your del.icio.us bookmarks in Firebird

"I'm a fan of del.icio.us because it allows me to seamlessly access my bookmars from whichever computer I am currently logged in to. A comment in a posting on this blog some time ago, brought my attention to Scuttle, an Open Source version of del.icio.us written in PHP. Scuttle is currently available in version 0.6.0.

The underlying database into which scuttle stores users and bookmarks, can be any of MySQL, Oracle, Postgres, SqLite, DB2, Firebird, and a couple others"

Read more on Jan-Piet's blog
http://blog.fupps.com/2006/02/16/delicious-scuttle/

..::firebird::..

Why Pay for a Database? - Why pay for sex when you can get it free?

As open-source databases have grown in popularity among large enterprises and small and midsize businesses alike, many CIOs have taken a closer look at the savings associated with switching to these noncommercial alternatives.

Despite the attractive prices that are drawing more CIOs to open-source applications such as MySQL and PostgreSQL, traditional software Relevant Products/Services from Insight vendors have not exactly thrown in the towel. Some — including Oracle, Microsoft, and IBM — are fighting back by releasing free, scaled-down versions of their fully featured database products in the hopes that customers might one day upgrade.

But the question remains: Does it make good business sense to pay for a commercial database product when well-established, open-source versions pose enticing alternatives? A growing migration away from commercial software suggests that, for many customers, it does not.

http://business.newsfactor.com/story.xhtml?story_id=41585

..::firebird::..::mysql::..::postgresql::..::mssql::..::oracle::..::db2::..

Open source database ‘years away from being a serious contender’

First they ignore you, then they ridicule you, then they fight you,
then you win.
by Mahatma Gandhi.

http://xrl.us/j2jd (Link to www.computerweekly.com)

Permalink | Leave your comment

..::firebird::..::mysql::..::postgresql::..
::mssql::..::oracle::..::db2::..

Firebird and SQL 2003 standard Conformance

This document outlines how much Firebird conforms to the current SQL standard.[2003] Please note that the following information is not a full statement of conformance, but just information for those interested in the subject.

What is your main language used with FB?

Seems that 80% of firebird users are  Delphi users
if i look at this pool votes (the one on the right sidebar)
http://www.firebirdnews.org/
In a way is no shock to me  - i started working as an interbase / Delphi
programmer
I think Lazarus+firebird package needs more attention (better
documentation+ more articles etc)

..::firebird::..::delphi::..::php::..::c#::..::java::..::c++::..::vb::..::ruby::..::asp.net::..::python::..

Porting the EMPLOYEE database from Firebird 2.0 to MySQL 5.1 part 7&8

Pabloj (moderator at devshed.com forums) wrote the last steps from
it's porting/comparative guide
Part 7 - Part8
..::firebird::..::mysql::..::database::..

Firebird and FireBase in “Anuario InfoCorporate 2006″

Firebird and FireBase (Brazilian Firebird dedicated portal) is mentioned in the Database section of the 2006 edition of “Anuário InfoCorporate“. Some months ago, a journalist from InfoCorporate called me by phone and made a small interview about Open Source databases and Firebird to be used in the publication.

The publication is a major source of indexed information to make the work of finding the best services/consulting providers of a specific area easier.

An excerpt of the article be be viewed below (portuguese only):

See remaining text… »

..::firebird::..::open source::..

SQL Manager 2005 for InterBase/Firebird released!

Written by EMS Software Development

Friday, 10 February 2006

EMS Software Development Company has released SQL Manager 2005 for InterBase/Firebird - the new major version of the powerful InterBase and Firebird administration and development tool! SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest features. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder and Stored Procedure Debugger to satisfy all their needs. EMS Software Development Company has released SQL Manager 2005 for InterBase/Firebird - the new major version of the powerful InterBase and Firebird administration and development tool!

You can learn more about SQL Manager 2005 for InterBase/Firebird at: http://www.sqlmanager.net/products/ibfb/manager




You can download SQL Manager 2005 for InterBase/Firebird at: http://www.sqlmanager.net/products/ibfb/manager/download

..::firebird::..

Firebird 2 beta 2 released

The Firebird Project has released the second Firebird 2.0 beta. Over the weekend, kits for Win32, Linux x86 (including NPTL builds for Superserver) and Linux x64 are being released for testing. Mirrors are slowly filling up; slower downloads from the pre-release area are also available temporarily but please try the main (mirror) links first.

You can download it here.

Thanks for Jiri Cincura for leting us know about this.

Permalink | Leave your comment

..::firebird::..::database::..::sql::..

firebird 1.5.3 gentoo package updated

Changed inetd USE flag to xinetd, bug #121886. Added doc USE flag handling useful docs from firebird website
http://packages.gentoo.org/ebuilds/?firebird-1.5.3-r1
..::firebird::..::gentoo::..::linux::..

Firebird Powered Web Forum dnfBB

dnfBB is a n-Tier, fast and lightweight .Net-powered discussion board written in C#. With native support for multiple forums within the same database structure. Initially designed to work with Firebird and MySQL, support for other databases is planned.
http://sourceforge.net/projects/dnfbb

..::firebird::..::mono::..::.Net::..::csharp::..::mysql::..::oracle::..::mssql::..::postgresql::..

Killing Microsoft Exchange with Firebird+Mailtraq

ServerWatch: Mailtraq Keeps Budgets, Features on Track "A budget friendly alternative to Microsoft Exchange" - uses Firebird.
..::firebird..::..microsoft..::..exchange::..

Status of the Firebird Tutorial for .NET

At the beginning of January I posted a Request for Ideas: Firebird in .NET Tutorial. First of all, thanks to all who contributed their ideas.

I'm currently working hard on the tutorial. The original idea was to write just a quick introduction but it seems there is a lot to tell... The weakest point of Firebird seems to be the lack of freely available documentation - so I decided to invest a little bit more time in the tutorial.

..::firebird::..::mono::..::dotnet::..::.net::..

Sequoia 2.6: A Transparent Middleware Solution with firebird support

Sequoia is a transparent middleware solution for clustering, load balancing and failover services for any database. The database is distributed and replicated among several nodes and Sequonia balances the queries among nodes. It is also known to handle node failures and support for checkpointing and hot recovery. It was formerly known as the clustered JDBC project and provides high availability and performance scalability for databases.

More about it on jax magazine

..::firebird::..::jdbc::..::java::..::clusters::..::mysql::..::postgresql::..
::mssql::..::oracle::..::db2::..

Lazarus 0.9.12 released

The Lazarus team is glad to announce the 0.9.12 release. This release is based on fpc 2.0.2 and the binary packages now contain many standard packages:

This release can be downloaded from the sourceforge download page:
http://sourceforge.net/project/showfiles.php?group_id=89339

Detailed list of changes

Lazarus supports Firebird with SQLdb package that comes with the IDE
or third party components.

..::firebird::..::lazarus::..::delphi::..

Playing with the Firebird Database - Blog of the day

In my last blog entry reguarding the rumored SunDB I immediately discounted the Firebird Database as a contender. In the comments posted to that entry it was suggested that Firebird shouldn't be so quickly discarded and may even be a "diamond in the rough". Well, if I'm wrong I'm willing to explore it and admit that I'm wrong if thats the case, afterall, what if Firebird really that great? I certainly don't want to miss out on a good thing. So thanks to Gentoo I quickly emerged Firebird 1.5.2 and started playing.

..::firebird::..

Quote of the day - I tried to make Interbase as simple and fast as possible : no tuning , no configuration control , no overrides

It's from 2000 and from Firebird Architect list

"What I'm trying to do is establish a cultural mindset for Interbase
development, soon to be a world wide effort, that easy to use means
intelligence in the system, not thousands of individual features.

Open Source has produced some very high quality software but often

at a cost of great obscurity.  Samba, for examples, emulates what
on Windows takes three mouse clicks, but requires 140 pages of
documentation to read and understand before installation.  Of
the "info" documentation reader with so many easy to remember
commands that they ran out upper case letters, lower case letters,
control-letters that they had to resort to keyboard chords.

I tried to make Interbase as simple and fast as possible -- no
tuning (other than indexes), no configuration control (undone
by Sys-V shared memory!), no overrides.  Where tuning was
traditionally required, I found alternative algorithms that
we insensitive to tuning.  Although memory sizes now make
the feature unnecessary, the optimizer computers the number of
page buffers required to efficiently perform a query and
warns the cache manager to find more memory.

I want Interbase developed by people who believe that smart,
small, and simple is good.  I want it used by people with
a problem to solve but who don't want to be database experts.


Jim Starkey"

..::firebird::..

Speed Comparison - Sqlite Posgtresql Mysql and Firebird

Benchmarks with Firebird 1.5.2 and the rest of the pack , Draw your own conclusions

http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison

Spoted on Tim Anderson's Tech writing blog

..::firebird::..mysql::..sqllite::..postgresql::..

New Evans Data Survey

“Evans Data: Today we have posted the 2006 Linux/Open Source Software survey. The survey is open to ALL panelists familiar with Linux or open source software.”

Firebird is mentioned in two questions:

Which Open Source databases do you use most often?

What database are you using on the platform for which MOST of your applications are targeted?

Don’t forget to vote for Firebird!

Permalink | Leave your comment

..::firebird::..

ANN: CopyCat Replication Suite version 1.03.0

Microtec is pleased to announce a new version of CopyCat, our Delphi /
C++Builder component set for database replication.

CopyCat can be used for integrating replication functionality into your
applications, or for making your own customized replicators, enabling
off-site database work, asynchronous work over slow connections,
automatic live backup, etc.

For information about CopyCat, see here

Changes in version 1.03.0:

See remaining text… »

• Added support for BDS 2006.
  
• Added a new OnResolveConflict event, providing easy access to all the
  information concerning the conflict, and allowing the user to resolve
  the conflict in a simple way.
  
• Removed TCcTables and TCcProcedures components. Instead, TCcConfig
  now creates two new tables in the database, RPL$TABLES and
  RPL$PROCEDURES, thus replacing and simplifying the previous INI-file
  system, which was too error-prone.
  
• The example projects have been considerably improved and extended.
  
• Added a Getting started manual, explaining the first steps to using
  CopyCat, as well as detailing each of the provided examples.
  
• Fixed some internal errors, that sometimes caused access violations
  and IDE instability at design-time.
  

« Hide it

Permalink | Leave your comment

..::firebird::..

Firebird 1.5.3 and Trustix linux

Here are the experiences on Trustix 3 , and maybe someone will contribute the firebrd rpm to trustix too. (with dependencies solved)
..::firebird::..trustix::..linux::..

Firebird 1.5.3 debian packages are available for testing

I've done preparing Firebird 1.5.3 packages.

deb[-src] ftp://shrek.creditreform.bg/public sid main

All feedback is warmly welcome. If no problems are found, I'll proceed with
upload to the archive.

Ah, also there you can find packages for flamerobin.

Damyan Ivanov
All you need to do is to add the above repository to your /etc/apt/sources.list
and then apt-get update ; apt-cache search firebird
then install what you need (classic or super server)

..::firebird::..::debian::..::ubuntu::..

OSS databases making inroads - Blog of the day

Here is a good link in businessweek on how OSS databases are horning in on

the database market.

I personally think that the majority of database users can do there work

with either Postgrsql, MySql or others like the Borland interbase now know

as Firebird or even Computer Associates Ingres which was recently made

opensource. Really do most company really need all those extra features or

are they just selling feature like Picture in picture was on your new TV

which you never use now.

Here is the link for you to check out:

http://www.businessweek.com/technology/content/feb2006/tc20060206_918648.htm
Best regards,
-Richard Houston
..::firebird::..::mysql::..::mssql::..::postgresql::..::oracle::..

Open Source vs. the Database Vendors - on slashdot

"BusinessWeek has another spread on open source this week. Among them is an article about open source vs. the database vendors
which focused on how businesses are looking to save money with open
source (rather than using the source to innovate). From the article:
"The databases work fine, but as data volume grows, so do the checks to
Oracle, IBM, or Microsoft. Many users aren't clamoring for more
features, and some don't even use the bells and whistles they already
paid for. They would happily trade some to get their hands on the
source code and a better deal."
Original source for news slashdot.org

..::firebird::..::mysql::..::mssql::..::postgresql::..::oracle::..

FirebirdClient 2.0 Beta 4 released.

FirebirdClient 2.0 Beta 4 for Visual Studio 2005 & Microsoft.NET 2.0,
the ADO.NET Data Provider for Firebird, is available for download.

Download information can be found here:

http://www.firebirdsql.org/index.php?op=files&id=netprovider


· Beta 4 ( 2006-02-03 ) ·

(Please read the Changelog for details)


Bug Fixes:

    - Fixed Foreign Keys schemas.

    - Fixed problem with the COLUMN_SIZE column in the FbViewColumns schema.

    - Bug fix in FbPoolManager when trying to return back to the pool a
connection.

    - Fixed DataTypes schema in the FbMetaData.xml file.

New Features:

    - [DDEX] Foreign keys should be now automaticalled added to DataSets
at design time when
    dropping tables from the Server Explorer.

    - Added correct support for the new .net 2.0
    DbParameter.SourceColumnNullMapping property (Alexander V. Leshkin)

    - Initial implementation of the new extended support for
char/varchar fields
    with OCTETS character set.

Changes:

    - Added RemoteEventId property to FbRemoteEvent class.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

..::firebird::..::mono::..::dotnet::..::.net::..

Interesting Project Metrics

I've been wonder for some about about metrics to evaluate the relative
architectural cleanliness of various database implementations.  To that
end, I wrote a simple program that eat Visual Studio 7 projects files
and analyzes the source files.  Here are the results:

	Nfs Engine	Vulcan	Firebird 2	MySQL Server
Total Modules	429	633	232	123
Total Lines	63432	227814	126274	214356
Code Modules	206	218	70	99
Header Modules	221	394	162	15
Preprocessed Modules	0	16	0	0
Other Modules	2	5	0	9
Number Functions	2839	4706	1633	4960
Average Arguments	5.00	8.65	13.08	7.58
Average FunctionLines	14.86	32.46	55.95	31.70
Average Code Lines	11.80	21.20	37.12	26.90
Average Internal Comments	0.94	6.10	11.92	2.59
Average Internal WhiteSpace	2.12	5.16	6.92	2.21

The analysis program doesn't try to follow conditional compilation, so
everything is included whether active or not.

The Netfrastructure engine is roughly equivalent in functionality to
Firebird.  The Netfrastructure numbers, however, are for the database
engine only, excluding the Java Virtual Machine and template engine. 
Since the trigger and procedure language in Netfrastructure are Java,
this isn't a strict apples to apples comparison.   On the other hand,
the Netfrastructure engine includes the remote server, which Vulcan
does not.
The Vulcan numbers are taken from the engine provider current code
base.  A small number of modules that, due to conditional compilation,
couldn't make it through the analysis program were omitted. 
Post-processed modules were also omitted.  Since Vulcan contains quite
of bit of archival, disabled Firebird code, its numbers are slightly
bloated.
The Firebird number are taken from "engine" msvc7 project.  Since
Firebird 2 doesn't use custom development steps, the preprocessed
modules aren't included (the project hasn't been built, so the
corresponding post-processed modules are not included either.  I don't
actually know what is the Firebird 2 engine build, but I assume it
doesn't include DSQL and possible other common stuff.

The MySQL numbers are from their Windows source kit.  I believe that
they also use static libraries for cross component modules, so I
suspect this is less than the full server.  But it does give a feeling.

I think the two most interesting sets of number are the average number
of arguments per function and the average number of code lines per
function (code lines exclude comments and white space).  It is most
interesting that in each case, Vulcan falls halfway between
Netfrastructure and Firebird 2.  The average number of arguments is a
good metric of the quality of a design.  Bad (or in this case eroded)
designs have to pass everything but the kitchen sink, and sometimes
that.  The Firebird 2 numbers are particularly scary because many
additional parameters are passed covertly through thread data.  The
average code lines per function is a good metric of modularity -- the
degree to which common code is cleanly factored out.

The comment related metrics are substantially misleading since they are
computed relative to number of functions rather than code lines --
fewer code lines will always mean fewer comments.  Even so, it is clear
that Firebird has something to teach me and MySQL about internal
commenting.

Both the ProjectAnalyst and ProjectsSummary projects are checked into
the Vulcan tree under src.  If you want to play or analyze Firebird 1.0
or 1.5, I'd like to see the results.  You may also want to add more
metrics.  ProjectAnalyst generates xml (sans header) summary files,
ProjectsSummary turns a set of xml summary into an HTML table.

-- 

Jim Starkey
Netfrastructure, Inc.
978 526-1376

Porting the EMPLOYEE database from Firebird 2.0 to MySQL 5.1 in steps:1-2-3-4

Hi, I've decided to make an in depth test of MySQL's new functionalities by porting Firebird's EMPLOYEE.FDB database to MySQL 5.1.5, here is what I found, I hope it will be useful for people porting apps from MySQL to Firebird and vice-versa.
http://pabloj.blogspot.com/2006/01/porting-employee-database-from.html
..::firebird::..::mysql::..

IBM Introduces a Free (as in Beer) Version of DB2

This week IBM became the latest proprietary database vendor to add a free offering to their lineup, according to ZDNet:
Source: http://news.zdnet.com/2100-3513_22-6032676.html

It would be difficult to estimate the balance between appealing to developers and the influence of Open Source databases such as MySQL, but I would tend to believe that competetion from Postgres, Firebird, MySQL, et al. to be a significant factor in the decision to release free versions of proprietary databases.

Source for this news/blog of the day
http://www.openwin.org/mike/index.php/archives/2006/01/ibm-introduces-a-free-as-in-beer-version-of-db2/
..::firebird::..::mysql::..::postgresql::..::oracle::..::mssql::..::db2::..

SR UDF Library version (2.0.1.0)

A user defined function library (160 UDFs) for InterBase and Firebird on the Windows platform. This version of SR UDF Library supports the following standard routins: Math, File, DateTime, String, Regional in addition to Conversion routins for converting different measurement units.

http://www.srmaster.com
..::firebird::..

IBExpert v2006.01.29 now available

HK Software have announced the immediate availability of a new Version of IBExpert (2006.01.29).

Visit www.ibexpert.com to download this version
..::firebird::..

Advanced Data Generator v1.6

Upscene productions have announced the availability of a new version of their Advanced Data Generator V1.6.0

..::firebird::..

Security Hot Issue for Open-Source Database Developers

Open-source database deployments rose dramatically in the last half of 2005, and as one might expect, as more IT pros get acquainted with these non-proprietary systems, security is a chief concern. Open-source database makers like MySQL and PostgreSQL [ED: and Firebird] simply must answer some of the most prevalent security-related questions in order to win more market share.

One of those questions is, with recent headlines suggesting customer data stored on organizational databases is at risk, should those who opt for open-source database applications be worried? Not according to data suggesting proprietary database software is breached more often. But data alone is not enough. What IT executives really want to know is what specific technological security precautions open-source DB developers need to take.

"We continue to see the maturation of open-source databases reflected by the continually increasing levels of adoption," said John Andrews, President, Evans Data. "In a number of our ratings categories, we're seeing open-source databases meeting or exceeding proprietary databases."

Read this full article at TechNewsWorld
..::firebird::..::mysql::..::postgresql::..::oracle::..::mssql::..::db2::..

New list: firebird-job-board

Hello all,

A new list has been started on Yahoogroups - a job board for devs
with Firebird skills and for employers looking for them. :-)

It's a pretty tightly moderated list.

You can look it up from the Lists and News Groups page of our main
website, or go straight there if you like.
http://www.yahoogroups.com/community/firebird-job-board

All you'll see in the archives right now is a couple of messages
posted by Calin Pirtea, who's helping with the
moderation. (Actually, you won't see the archives at all if you're
not a member...)

Feel free to link to the list from your own websites. It all helps
for getting us "out there".

Helen

..::firebird::..

Firebird Embeddable Database for .NET - Blog of the day

"An article about dotLucene at CodeProject suggests FireBird as a DBMS for .NET apps with comparable and even better capabilities (for some features) than the commercial counterparts."

Read more on his blog
..::firebird::..::dotnet::..::.net::..

Whats New in Firebird 1.5.3

Spoted the list of changes on fbtalk also you can find them in release notes
Whats New

(1.5.3) Two ISQL Improvements
C. Valderrama, D. Ivanov
1. Command line switch -b to bail out on error when used in non-interactive mode.
2. Return an error code to the operating system from command-line isql


(1.5.3) Make Old Column Naming Convention available
Paul Reeves
Added OldColumnNaming parameter to firebird.conf to allow users to revert to pre-V1.5 column
naming in Select expressions.


(1.5.3) Security diagnostics added
Alex Peshkoff
Attempts to send signals via a missing gds_relay may be an exploit attempt. They are now logged.


(1.5.3) Closed an Endemic Security Hole
Alex Peshkoff
Previously, a user could log into a server on a Unix/Linux host remotely, using a Linux UID and password
accepted on that host. It was recognised as a security hole and fixed in Firebird 2 development.
It is an endemic security bug in previous versions and InterBase. The security fix has been back-ported
to Firebird 1.5.3: a UID received from the client side is now not trusted.

..::firebird::..

Firebird 1.5.3 Released

The Firebird Project is pleased to announce the Firebird 1.5.3 release, representing a year of bug fixes and minor enhancements, many back-ported from the Firebird 2.0 developments. Kits are available for Windows and Linux.

..::firebird::..

Firebird ODBC Driver V2.0 (Beta V2.00.000...000000000000000.00126) is available for download.

A new version of the Firebird Open Source ODBC Driver V2.0 (Beta V2.00.00.00126) is available for download.
..::firebird::..::odbc::..::unix::..::linux::..

How Relevant for firbird project is the Homeland Security Grant?

How it will work ,Shows how Coverity worked with linux kernel developers in the past sending them patches

"For now, Coverity plans to publish the defect reports on a semi-private Web site so that any developer associated with a particular open source project can examine the list, determine if something actually needs to be fixed, and then create a fix and submit it to the project lead. This is currently the model used by Coverity for the defects they published for the Linux kernel."

http://www.linuxplanet.com/linuxplanet/reports/6146/1/
..::firebird::..::linux::..::security::..

how to work with fishes (BLOBS) in firebird

Devrace have published an article entitled "How to work with Blobs using FIBPlus" written by Sergey Vostrikov, translated by Marina Novikova.

Read more | Post comment

..::firebird::..

Firebird User Community Map - win an Cuckoo clock

There is now a Frappr map for Firebird. Go ahead and register yourself. The 1,000th registrant might be honoured with a Cuckoo clock.

Read more | Post comment
..::firebird::..

InstantObjects 2.0 beta 2 released

On behalf of the InstantObjects team, I am proud to announce the
release of the second beta of the long-awaited version 2 of
InstantObjects.

Download URL:

http://prdownloads.sourceforge.net/instantobjects/InstantObjects-2.0.beta2-src.zip?download

Feedback:

Please test this release and report back any problems by means of our
newsgroups and trackers.

Ciao
--
Nando Dessena
..::firebird::..

The government is here to help open source

The government is here to help open source by ZDNet's Dana Blankenhorn -- Sounds like a win-win-win. Tell me it's not.

..::firebird::..

Latest number of DB FreeMagazine (#007) is out

The lastest number of DB FreeMagazine (#7) brings an article about how to configure Wine on linux to be able to run IBExpert and other Delphi applications.
How to backup Mysql databases using Replication ,
Installing Oracle10 under Slackware, Firebird Conference 2005,
Firebird usage statistics (opinion poll)
Magazine is free, but is in portuguese. Some work is being done to have a version of the article in english.
..::firebird::..oracle::..linux::..mysql::..slackware::..postgresql::..wine::..

All you didn't want to know about Firebird's Unicode

You can now download the slides from Stefan Heymann's talk "What Developers Should Know about Character Sets, Unicode etc.".
It was presented at Firebird Conference 2005 .

Dmitri Kovalenko, LCPI wrote about unicode in September issue of The Firebird Developer Magazine:
Working with UNICODE in InterBase/Firebird

Related to unicode is Joel Spolsky's article The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)


..::firebird::...::unicode::...::delphi::..

Firebird ADO.NET Data Provider 2.0 Beta 3 released

The Firebird ADO.NET Data Provider 2.0 Beta 3 for Microsoft.NET 2.0 is
available for download.

Download information can be found here:

http://www.firebirdsql.org/index.php?op=files&id=netprovider

(Please read the Changelog for details)

Bug Fixes:

- Fixed problem with the FbDataAdapter design time support.

- Fixed TableAdapter integration in Visual Studio 2005 now the
tableadapters should have select, insert, update and delete commands
when requested.

- Fixed bugs in Indexes and Index columns schemas.

..::firebird::....::mono::....::.net::....::dotnet::..

Homeland Security helps secure Firebird

I saw firebird in the list of targets

“Through its Science and Technology Directorate, the department has
given $1.24 million in funding to Stanford University, Coverity and
Symantec to hunt for security bugs in open-source software and to
improve Coverity’s commercial tool for source code analysis,
representatives for the three grant recipients told CNET News.com.”

http://news.com.com/Homeland+Security+helps+secure+open-source+code/2100-1002_3-6025579.html?tag=nefd.lede

..::firebird::..security::..

Firebird News HQ

Hello!

I always claimed about the lack of an "oficial" HQ for news related
to Firebird. Until now, people needed to dig into several sites to get up
to date with the "Firebird World".

For this reason, I created www.firebirdnews.org

The site is mainly a blog and will be driven by the community. I mean,
registered people who wants to be authors for the site will be allowed
to post new items with no moderation and full speed, ie: 1-LogIn, 2-Write It,
3-Publish it, and it will be online! No delays, no authorization
requests!

In other words: The site needs you! Being an author doesn't
means that you will have to write documents with dozen pages. It means
that you will have the right to post to the site. Actually the posts
are not big, since usually it will just give the user an introduction
to something hosted in another site.

Please enter the above URL and read the "About this site" and "Author
rules", and if you agree (why not?), please register yourself. As
soon as I see your registration, you will be promoted to Author role
and can begin posting new items.

For the RSS entusiasts, the site already offers possibility to track
the new posts and comments using a RSS reader.

[]s

Carlos (Membro do TeamFB - FireBase)
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

..::firebird::..

The Firebird ADO .NET Data Provider V2.0 Beta 2

The Firebird ADO .NET Data Provider V2.0 Beta 2 for Microsoft .NET 2.0 is available for download.
..::firebird::....::mono::....::.net::....::dotnet::..

Daffodil CRM 1.5 includes Firebird support

Daffodil Software have broadened the number of database choices for their CRM product. Previously limited to DaffodilDB, the CRM product now also supports Firebird, acknowledging Firebird's continuing march forward as the database workhorse for midmarket business applications.

Read more | Post comment
..::firebird::..::crm::..

An interview with Chris Date

O'Reilly has an in-depth interview with Chris Date, who co-wrote "The third manifesto" and helped promote the relational model in the mid-70's. Chris has outspoken views about the relational model, SQL, object-relational databases and much more. What would our own Jim Starkey have to say about Chris' views?

Read more | Post comment

..::firebird::....::databases::....::sql::....::rdbms::..

FBMail V1.2 is available for download.

FBMail V1.2 is available for download.
Project (where FBMail is included) announces New support mechanism :
FBUtils now has a new email list for support, the email list is fbutils-users. All feature requests and bug reports should still be added via the Sourceforge interface.
..::firebird::..::php::..::mail::..

Sample Code for Shriking a Database (aka Firebird Vacuuming)

Oscar Porcar contributed a piece of code (c#) that does a database backup and restore to keep its size as small as possible. It might be useful for cases when you insert and delete some temporary data and the database size increases (the server doesn't shrink it automatically - instead it reuses the "empty" space when adding new data.)
..::firebird::....::mono::....::.net::....::dotnet::..

How to use firebirds GSEC utility to add, delete and modify users.

GSEC is a utility firebirds utility for managing users.
Here is how to use it
..::firebird::..::Sekrty::..

All-in-one installer for Compiere + Fyracle

Mohdizaniahmad writes: "I managed to prepare an all-in-one installer for windows environment. It has compiere 2.5.3a + fyracle-0.8.10 + jdk 5.0 in a single install. [...] You can install compiere in just a minute with the necessary shortcut ready for you. The installer is about 250 MB in size."
Read more
..::firebird::...::oracle::...::crm::...::compiere::..

Firebird SQL Roadmap for 2006 - sqlsummit.com

Following a recent developer conference in Prague, the Firebird Project published a roadmap for 2006 and beyond. Firebird 3.0 will merge Firebird 2.0 with the Vulcan code base, which includes fine-grained multi-threading and enhanced security. Target date for a beta version of Firebird 3.0 is the second quarter of 2006. (more).

..::firebird::..

Firebird Performance - Build for Speed

- Add more ram is cheap (if server is swapping)
- Buy an 64 bit server (for databases is an must to have more than 4G of ram) if database is more than 30G
- Build an raid 0 array (for speed)
- Use Firebird Classic for SMP systems (multicore)
More ideas in this blog post
..::firebird::..

Firebird - open your FLAP[s] - New acronym

FLAP is an acronym for a set of Free Software programs commonly used together to run dynamic web sites:

• Firebird, the database management system (or database server);
• Linux, the operating system;
• Apache, the web server;
• Perl, PHP, and/or Python, scripting languages.

..::Firebird::..::Linux::..::Apache::..::Perl::..::Php::..::Python::..

Request for Ideas: Firebird in .NET Tutorial

Dan working on a tutorial that should cover the basics of Firebird and its usage in .NET.
http://www.dotnetfirebird.org/blog/...ird-in-net.html
..::firebird::....::mono::....::.net::....::dotnet::..

Latest Firebird Relational Database Released (Pre Final)

The Firebird Project is pleased to announce the last release candidate for the forthcoming Firebird 1.5.3 final version.
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,


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

..::firebird::..

Synapse-EMR electronic medical records system that uses the open source RDBMS Firebird.

What is Synapse Electronic Medical Record?
Synapse-EMR is a powerful multi-user electronic medical records system that uses the open source RDBMS Firebird.

[ED:I like the technical]

Geek Stuff

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

Why everyone should be a programmer

"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

Firebird is included in Yet Another Linux Distro named 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

Firebird3 (vulcan code name) will work on more arhitectures

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::..

A review of "GoldMine Corporate Edition 7.0" - They are using firebird

A review of "GoldMine Corporate Edition 7.0" by John Clyman for PC Magazine, "Some of the biggest changes in GoldMine 7.0 happened under the hood: dBASE has been supplanted with the open-source Firebird database..."
Source for news ibphoenix.com
..::firebird::..::crm::..

Explaining interbase bottlenecks

Results of TPC-R based test attracted a lot of attention and raise many questions. The most important question is why queries 3 and 20 were so slow?
Here is the answer
..::firebird::..::interbase::..

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

"Il Firebird project ha appena rilasciato la prima versione beta del suo famoso database. La nuovissima versione, anche se in versione beta, contiene un grande numero di nuove caratteristiche."

http://www.tuxjournal.net/wordpress/?p=17
..::firebird::..::linux::..

xBaseView 6.2 with firebird support

xBaseView is a universal viewer and editor of databases. xBaseView can open any database via the ADO, ODBC and BDE universal technologies, and can directly open 15 types of databases. It provides direct export of the data to 16 formats (direct import - from 14 formats), and can export (and import) them to any format of databases via the universal technologies. The database experts can create up to 10 various types of files; can perform SQL-queries and other operations.

http://www.totalcmd.net/plugring/xBaseView.html
..::firebird::..::databases::..

ADODB 4.68 released (Default branch)

ADODB is a set of advanced PHP database abstraction classes. It supports MySQL, PostgreSQL, Interbase/Firebird, Informix, Sybase ...

More on freshmeat.net

..::firebird::..::php::..

EMS SQL Manager for InterBase/Firebird (ver. 3.9.5)

Simple and powerful GUI tool for administering InterBase and Firebird.
New version released
..::firebird::..::interbase::..

Firebird Stored Procedure written in C#

Carlos Guzman wrote an example of Stored Procedure using C# as language
and Firebird/Fyracle as server
More on his blog (spanish).You can use the babel fish to translate it

..::firebird::..::mono::..::dotnet::..::.net::..

Firebird File and Metadata Security

Paul Vinkenoog updated documentation area on sf.net and wrote:
Existing manaul docbooked and added to our documentation collection: Firebird File and Metadata Security by Geoff Worboys.

..::firebird::..::security::..

KInterbasDB 3.2a1 released

What's new in release 3.2a1?
----------------------------
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.net/dist_docs/


Where can I learn more about and download KinterbasDB?
------------------------------------------------------
http://kinterbasdb.sourceforge.net

..::firebird::..::python::..

firebird blog of the day - Carlos Guzmán Álvarez

This is an nice surprise ;)
Is in Spanish

http://carlosga.blogspot.com/
..::firebird::..::mono::..::dotnet::..

Firebird Banner is here

Some days ago someone requested an animated banner for Firebird.

Well, I just did one...


Get it on www.firebase.com.br/fb/banners/firebird_banner.gif

I hope you enjoy ;)

Carlos H. Cantu
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
..::firebird::..

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.

Original article is here
..::firebird::..

Firebird article in "Entwickler Magazin"

in the forthcoming edition of the well-known German development magazine
"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

and babelfish translation
..::firebird::..

Ruby on Rails 1.0 Released with firebird support

"What else do I need?
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::..

FireRuby included in RubyOnRails 0.14.4 (Active Record 1.13.1)

Details on Firebird Adapter (for Rails) page
"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

FireRuby is an extension for the Ruby language that provides an OO interface
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 file autogen.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::..

Morfik crew released Alpha version of their Ajax IDE - WebOS

There's been a major announcement from the Morfik crew today - the release of the Alpha version of their much anticipated 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

First test results for Firebird 1.5.2 and InterBase 7.5.1 are published.

"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

I agree with him and i'm not the only one who knows we need to create more "buzz" I have said many times what are the methods , You can start with small things:blog , spread firebird logo on your site ... (search in the firebird-general list archive for all the ideas)

"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::..

Firebird Internal Engine Version 8.0 = 3.0 (aka Vulcan)

Si Carter wrote:
> 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::..