IBPhoenix Developer CD No. 10 (February 2006) is now shipping, including a new in depth look at “How to Write an External UDF Function”.
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:
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:
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 Firebird 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.
ZDNet talks about recent moves… read more here.
Andrew Hudson has a review of open source database companies over on OSNews. "IBPhoenix employs 6 people, grossed $50k its first year, and has nearly doubled revenue each year since. Beach formed InterBase Software to commercialize the existing and mature code base that Borland had taken open source after several years of closed source development. Borland continues to sell InterBase as a closed source product. InterBase is a relatively small company but it is profitable, it has a solid international presence, and it is growing rapidly."
Read more here
Neil McAllister has an insightful article on the relative position of proprietary and closed source databases. He argues that "free to develop, pay to deploy" is becoming the norm in both worlds.
Read more here
SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5, supports all of the latest features and offers plenty of powerful tools for experienced users to satisfy all their needs.
In the newest program version the ability to register multiple local servers has been added. Also a lot of improvements and bugfixes have been made.
You can download SQL Manager 2005 for InterBase & Firebird at: http://www.sqlmanager.net/products/ibfb/manager/download
You can purchase SQL Manager 2005 for InterBase & Firebird at: http://www.sqlmanager.net/products/ibfb/manager/buy
More information at: http://www.sqlmanager.net/news/801
“I’m very happy that Jim, Ann and Taneli have joined MySQL AB,” said Michael “Monty” Widenius, the company’s co-founder, in a statement.
“There is plenty of work to go around, and with their combined experience, they can help us deliver on all the plans that we haven’t had time to pursue yet — and also supply us with lots of fresh new ideas.”
Read the full article here.
My note: The article says that Jim is involved with Firebird since 2000. This is not true. Jim got involved with Firebird only when IBPhoenix hired him to develop Vulcan.
Business Week Online writes: "Can open-source upstarts compete with Oracle, IBM, and Microsoft? It's an uphill battle, but customers are starting to look at the alternatives."
Read more here
Here is a recent interview I did with Ann, by email. I hope this can clarify a bit more the recent moves regarding Ann, Jim, Firebird and MySQL.
FBNews: In Jim’s recent announcementmessage, he says that you will be working for MySQL AB too. Are you officially employed at MySQL AB? If so, what is your currently role there?
Ann: Yes, I’m working half time for MySQL as a senior architect. In other words, I critique designs and try to make the system fit together smoothly.
FBNews: As you are one of IBPhoenix owners, how do you plan to handle working for two databases that are, in some way, competitors? Are you considering leaving IBPhoenix?
Ann: I plan to make my best efforts for both companies and build the reputation of Open Source Databases and Open Source as a better model for doing business. The database market is huge and the availability of high quality open source databases is accelerating the growth. There’s plenty of room for Firebird and MySQL and PostgreSQL and Ingres and CloudScape and SQLite and all the rest. In specific, the differences in licenses and configurations of MySQL and Firebird mean that they appeal to different segments of the market.
FBNews: Can you tell us if Netfrastructure will be open sourced by MySQL? If don’t so, what do you think is the currently role of Netfrastructure in the actual MySQL AB business?
Ann: At the moment, no one knows. MySQL hired Jim for his mind and his track record, not for the 17″ stack of listings that are Netfrastructure.
FBNews: What is Jim currently job in MySQL AB? Will he only work in Netfrastructure improvements or is he going to participate in MySQL database development?
Ann: He’s also a senior architect.
FBNews: Do you think MySQL will use Jim’s expertise to create its own full featured MySQL engine, considering that now Oracle has InnoDB?
Ann: Certainly, MySQL recognize the benefits of a transactional backend. They hired Jim because he designed and implemented three transactional engines: Rdb/ELN, InterBase and the Netfrastructure engine called JSTar.
FBNews: Can you explain to the common users what are the major conceptual and architecture differences between Netfrastructure and Firebird?
First, Firebird started as a C program and is only gradually adopting serious object discipline. All of Netfrastructure is designed and build as objects. The code looks completely different.
Second, Firebird relies on careful write directly to the database to maintain on-disk consistency at every point in its operation, eliminating the need for a recovery process.JStar writes data changes to a log file – logged changes are gradually propagated to the database. After a crash, a recovery process brings the database to a consistent state before restart.
Third, Firebird is multi-generational on disk. JStar is multi-generational in memory, but only the most recent committed data is stored on disk. This reduces the cost of garbage collection and greatly increases the memory usage.
Fourth, Firebird has a tiny memory footprint for a relational database. Data is cached only as it occurs on pages. JStar maintains an in-memory record cache with version chains.
FBNews: Many times you are referenced by the community as the InterBase/Firebird “mother”. With the recent events, can we expect that Firebird is getting orphan?
Ann: Firebird has dozens of parents – Paul, Dmitry, Arno, Helen … It can never be an orphan again. And I’m not leaving. I may cut down on consulting so I can be more annoying on the lists to make up for Jim’s cutting back there.
FBNews: In your vision, what are the benefits and loss (if any) to Firebird project with all the recent moves?
Ann: Not much of either, frankly. This really isn’t about Firebird, it’s about Netfrastructure and Jim. The lists will hear less from Jim, but he’s promised to lurk on architecture where he has most to contribute. His work on Vulcan is done except for some bug fixing that’s included in everyone’s plans. The integration will go more smoothly without him, I suspect.
eWeek article bring some more info about recent moves:
“MySQL and Firebird will continue as two distinct code bases,” said Steve Curry, a spokesperson for MySQL, in an e-mail exchange.
“Any MySQL projects that [Starkey] is involved in will be based on new work, not re-use of existing Firebird or InterBase code. Firebird is a fine product, one that we do not see as a competitor.”
Read the full article at eWeek.