Firebird bug trackers are now based on JIRA

Firebird Project: In order to provide additional and much needed functionality to assist in tracking project issues, the existing Sourceforge bug trackers are being replaced with a new tracker based on JIRA. The new tracker will be hosted on a new server and will be using Firebird as its database engine. To facilitate this migration, all of the Sourceforge Trackers have been closed. Once the migration has been completed (a couple of days), a message will be posted providing the URL links for the new tracker site. Dimitrios Chr. Ioannidis and Pavel Cisar should be thanked for their work on the configuration of the new server, the installation and configuration/implementation of the new tracker and migration of the existing data.

Firebird Website Moves to new House

Finally we have moved to our new server in Canada, thanks to the generosity of Broadview Software. More news shortly about our other new server, running a Firebird back-end and our new tracker system. [Ed: this server is way faster than sf.net watch the Alexa’s Site Stats ]

Nick joins DevCo & Delphi Team

Nick Hodges, long time Delphi fellow, is the new Delphi Product Manager for the soon-to-be DevCo. A great opportunity for him, the company, and the entire Delphi community.

Nick discusses his new job (and his great mood) in a post in his blog. He has also an irresistible post in the non-tech group:

" B orland finally went and hired a new Delphi Product Manager. He seems a pretty cool guy. Oh, wait, it's me!"

Is Nick a good choice for the job? Indeed. He is part and will remain part of the community, knowns a lot about the product, has great connections with all of the key players and team members... so he'll certainly be able to serve Delphi need to get back in the hand of more and more developers and students, find its place in software companies and universities alike... and also serve the community helping DevCo to improve the products to better serve its users (and not some "disconnected" analysts).

New job

Yesterday, June 19th, was last day of my USAID TAMP job. It was great experience for me...

My next job will be USAID TARA, and I will start at July 3 ;-)

Go Delphi! Go Firebird!

Back!

I had a surgery last monday, had gall stone removed.
I am recovering fast, so expect some posts these days ;-)

Skype, yeah it too is written in Delphi

posted by Steve Trefethen

"I've seen this mentioned before but since I just posted about Yahoo's Go for TV I figured what the heck, might was well throw Skype into the mix too. Skype is only slightly harder to recognize as being written in Delphi but only because they've decided to package the whole application up into a single 18MB EXE btw, isn't it nice how Delphi gives you that option. If you search for strings in the Skype.exe you'll see lots of Delphi classnames like TInterfacedObject and friends.

Inevitably, the question "Can you point me to any well known large Delphi applications out there?" comes up time and again on the public newsgroups. Well, I think Skype.exe weighing in at 18MB and worth $2.6 Billion answers that question wouldn't you agree?"

Yahoo Go for TV, yeah it's written in Delphi

posted by Steve Trefethen

"Today I was searching for this old project called myHTPC which used to be located here but now redirects you here. So I downloaded and installed Yahoo Go for TV and low and behold rtl70.bpl, vcl70.bpl and vclx70.bpl sitting right in c:\Program Files\Yahoo!\Yahoo! Go for TV. In case you're not familiar with Delphi these files are part of the redistributable portion of the Delphi runtime."

FirebirdClient v2.0 Release Candidate 5 released

FirebirdClient v2.0 Release Candidate 5 is available for download.

Hope this can be the last Release Candidate version before the final
release, of course, if there are no big issues reported in the next weeks.

Download information can be found here:

· Release Candidate 5 ( 2006-06-01 ) ·

[See remaining text…]

( Please review the changelog for details )

Bug Fixes:

• Fixed bug #1490166.
• Fixed bug #1489770.
• Fixed bug in Domains schema.
• Added the information of the of IscException’s errors to the errors collection.
• Fixed incorrect number of bytes per character in the UTF-8 character set information.
• Fixed FbDataReader.GetEnumerator method to allow the Reader to be closed with CommandBehavior.CloseConnection

Changes:

• Changed GetIPAdressMethod to use IPAddress.Parse with the Data Source when getting an exception with Dns.GetHostEntry.
• Changes on Dispose implementations of FbDataReader, FbCommand and FbConnection classes.
• Added a minor hack to the FbParameter.Size property to try to ha a better detection of Clob parameters
• Added initial support for connection string property synonyms in the DDEX provider.

Some more DevCo info

Allen Bauer had the honor of being interviewed by Huw Collingbourne, the editor of Bitwise Magazine.

FB 2.0 release notes in HTML

The release notes of Firebird 2.0 is now available in HTML format here.

Deconstructing databases with Jim Gray

Jim Gray is one of the nestors of database engineering and currently a MS 'distiguished engineer'. In a Reg interview he speaks about transactions in internet-scale distributed systems and about using graphical processors for parallel processing of streams.
Read more

Morfik defends its IP rights against Google

ZDNet writes: "A couple of weeks ago Google released its Google Web Toolkit (GWT) and almost immediately there were rumors of an alliance between Google and Morfik, the Web OS vendor which has a Javascript converter as one of its main products. The reason? GWT bore more than a casual resemblance to Morfik... " By the way, the developer Journal #4 has a write-up about Morfik and its use of Firebird.

Read more

More on DevCo and Firebird

Marco Cantu talks in his blog about what he expects regarding the relationship between DevCo and Firebird. Check the full post here.

Oracle and Open Source

Open source is hot these days, and Oracle knows it. The company is facing challenges from open source competitors by embracing open source technology in its own right - acquiring and developing key companies and products in this area - as well as fighting to show its merits over other open source choices. How does Oracle stack up against PostgreSQL or Firebird? How do Oracle and Linux work together? What's next for Oracle on the open source front?

IB/FB Developer Magazine #4 is available

I guess some of our readers have become a bit tired of waiting and wondering when the new issue would be released. I am really sorry about the long delay, but there have been some serious financial and time issues holding up production.

Read more

Lazarus 0.9.16 released

Vincent writes "The Lazarus team is glad to announce the 0.9.16 release. This release is
based on fpc 2.0.2.

This release can be downloaded from the sourceforge download page.
"

FlameRobin 0.7.2 released

FlameRobin 0.7.2 has been released. Windows (setup & zip), Linux (gtk1 &. gtk2), Mac OS X and source packages are available for download.
Read more

New technology licenses from IBExpert

From Holger Klemt:

"A lot of customers asked us regarding a cheaper possibility to use our ibeblock technology for their own software. The IBExpert VAR License gives a distribution license for all modules including the IBExpert IDE. Some smaller software companies just asked for a way to integrate our technology for a cheaper price."
Read more

Devrace aquires Metadataforge

Devrace have recently acquired Metadataforge company (SQLHammer project) and will immediately start selling the product. Read details in the press-release
Read more

Download Sizes: Firebird vs Sqlserver

[ED:blog of the day is Ben Ward’s post about firebird vs sqlserver download sizes/requirements]

Originally, my Desktop Search application (‘Oak’) was to use a Microsoft SQL Server Express database backend. Full of glorious developer friendly features (like .NET integration) it is a powerhouse of a database.

[See remaining text…]

However, whilst building some initial test applications I made the horrifying discovery that rather than embed itself in my application, as I’d mistakenly thought it would, SQL Server Express insists on being run as Windows service. Since it’s not distributed as a key part of Windows that would have meant having to download about 40MB of SQL server, alongside the 20MB .NET 2.0 redistributable, alongside my application (lets say that’ll be somewhere around 6 meg).

This download size prompted me to switch from SQL Server to Firebird – which adds only 2MB to the application and runs embedded, not as a standalone service.

eWeek: "Save Me from Cleverness" - One more reason I love Delphi

Peter Coffee's "Save Me from Cleverness" (May 15, 2006) is another
great example of why I love Delphi.

http://www.eweek.com/article2/0,1895,1959854,00.asp

Although the article does not specifically mention Delphi, it does
speak volumes regarding the tersness of the C family of languages
and the impact of cleverness in programming.

IDC confirms Firebird's leading position !!

Oracle has last year's report as well, with even more detail. It shows Borland as a quickly growing database company, riding the FB/IB success wave. It's database sales are closely tracking MySQL, with 2004 sales already at the $9 million mark. Read more link has the PDF with full details.

Read more

Details of IDC's market estimates

Oracle is publishing a summary of IDC's market report, with sales estimates for the main proprietary players for the last 3 years. The Read More link has a PDF with that summary.

Read more

Should Oracle fear open source?

Referring to Oracle's acquisition of Sleepycat Software, Graham said: "Open source in general starts small but then it ends up having a big impact. Oracle knows this. They happened to acquire an open source vendor themselves, because thy want to get on that train." She added: "We expect [open source database software sellers] to gain market share, and probably pretty quickly."
Read more

PostgreSQL fix could break applications

PostgreSQL users have been put in a potentially sticky situation by a serious security flaw made public this week. The flaw allows for SQL injection attacks, and affects all versions of PostgreSQL, aside from fixed versions released this week. However, the fix, PostgreSQL developers admit, will break many users' applications.
Read more

Suggesting DevCo Name

DevCo is looking for a name... and suggestions. Name debate is hot!

Michael Swindell has officially asked for suggestions for the new name (but not only that) in a blog post. Meanwhile, the non-tech group has a long thread (106 messages at this moment) spawned by Marco Cantu's blog post, with very few good suggestions and tons of nonsense ones. Cure ideas: "But we wrote Delphi Dev Co", "The Developers Company", "BIMB Is Not Borland", "Be Rad, Inc."... and many more.

Remember, the web site must be available, should not be a trademark, and should possibly start with "B".

Why we all sell code with bugs - firebird mentioned

[Quoting from this article where firebird is mentioned http://technology.guardian.co.uk/weekly/story/0,,1781895,00.html ]

For instance, our product, Vault, stores all data using Microsoft SQL Server. Some people don’t like this. We’ve been asked to port the back end to Oracle, PostgreSQL, MySQL and Firebird. This issue is in our bug database as item 6740.

Read complete story

Temporary tables

From Dmitry Yemanov:
Implementation of the SQL-2003 compliant global temporary tables has been committed into the HEAD branch. This feature will be released in the next (post-v2.0) Firebird version. Design and implementation of the local temporary tables (both “defined” and “declared”, see the SQL specification for details) are being investigated, but there are no timeframes defined for that.

Another Opportunity to Pump Up Delphi on JoelOnSoftware

http://discuss.joelonsoftware.com/default.asp?biz.5.345746.28

Once again, feel free to jump in and give your $0.02.

Previous discussions are here:
http://discuss.joelonsoftware.com/default.asp?joel.3.342621.17

How many ISV here use Delphi ?
http://discuss.joelonsoftware.com/default.asp?joel.3.342621.85
and
Delphi for easy cross platform development
http://discuss.joelonsoftware.com/default.asp?joel.3.342623.19

SAS’s Goodnight won’t say goodbye yet

“…I think, to some extent, that Oracle is getting to that perch in the database business. Yet there is a lot of movement in the database business with open source software. We use one called Firebird. They should do something about it.

We had an experience when we were thinking about going public and our consultants said that we needed to get off SAS for our internal ERP work because it is just not a recognised brand and they suggested Oracle. It was Ernst and Young and we spent three or four years and $10m and it was just outrageous. And in the release (of Oracle) that we were working on there were over 10,000 bugs. That’s horrible.“

Read complete article here.

SQLServer 2005 at 6 Months

"MS Sausage" has been out for six months. ENT News writes: "Six months after its launch, SQL Server 2005 remains free of showstopper bugs or known security issues. Still after five years between database releases, Microsoft hasn’t shown evidence yet that there’s huge pent-up demand for SQL Server." One poster complains that, yes, there are no showstopper bugs, but plenty of regular bugs. Time to switch?

Added: One of the comments on the article by Bobby Jasper from Baltimore, MD says: "You could have a look at the open source RDBMS Firebird (www.firebirdsql.org). These folks have built up a good reputation on releasing rock solid stuff. It is probably the most used open source databse on the windows platform."

Read more

Firebird in China

From the Site of the day department here is the firebird dedicated site in china www.firebird.net.cn/
[Ed : you will need the babel fish maybe ]

Adarvo and Firebird

From IBPhoenix - Adarvo Ltd, Switzerland (www.adarvo.net) run a collaboration server that is based on a Firebird database. Current (May 2006) size of the database is about 49GB and there are more than 2000 customers currently using the service at this site.

First two chapters of "Using Firebird" available

Paul Vinkenoog writes: "I think I’ve done most of the necessary update/correction/extension work, but I may have overlooked some things, and possibly introduced some fresh errors too. But I’ve gone through so many cycles of reading, updating and re-reading by now that I can’t look at it with a fresh eye anymore. High time somebody else had a look."

Read more

Who gives, who takes?

Information Week writes: "This spirit of volunteerism is alive and well in the world of open source software. Thousands of people donate their time and expertise to the benefit of all. But not everyone is giving as much as they're getting. Large companies, those with the greatest wherewithal to help, are surprisingly minor players in the roll-up-your-sleeves work of open source development."

Read more

Free vs. gratis databases

Analyst firm Hydrasight research director John Brand says: "I think we'll also see a fairly aggressive push from vendors in trying to influence, if not control, the open source database development market. It's such a huge market that could potentially influence so many other market segments." That said, Brand believes the days of databases themselves being valuable is "somewhat over", because the needs of users have evolved and the race is now on to control the business process layers of software, not just data structure and storage.

Read more

Google licensing Morfik's JST?

Morfik developed the breakthrough web app RAD tool, WebOS. WebOS generates AJAX web applications in an environment that resembles Delphi C/S development. It uses Firebird as its DB server. One important part of its technology is "JST", a javascript compiler. Google has released a similar technology, perhaps licensed from Morfik.

Read more

Full-Text Search: Fast, Damn Fast and DotLucene

DotLucene is an open-source search engine library for .NET. There is now set up a demo site (damnfastdotlucene.org) that tests DotLucene performance on quite a big set of documents
[ED:Lucene.net index can be stored in firebird database]

FlameRobin 0.7.1 released

Windows (setup & zip), Linux (gtk1 &. gtk2), Mac OS X and source packages are available for download. Read more here, changelog included

Firebird snapshot builds

From Dmitry Yemanov:

For those who's not yet aware - Linux x86 snapshot builds are available at http://www.dqteam.com/fb2/. They include a few recent builds of the Firebird 2.0 release candidate as well as builds from the HEAD branch (where new development happens). Win32 snapshot builds (Firebird 2.0 only) are still here. Snapshots are intended for Firebird developers and experienced beta testers. These builds are untested and provided with no guarantees.

Firebird 2.0 Release Candidate 2 for Win32 is Released

The Firebird Project is pleased to announce the second release
candidate of Firebird 2.0, for final testing. The binary kits for Win32
have been uploaded and should be available soon.

FirebirdClient v2.0 Release Candidate 4

FirebirdClient v2.0 Release Candidate 4 is available for download.

Download information can be found here:

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

· Release Candidate 4 ( 2006-05-15 ) ·

( Please review the changelog for details )

Bug Fixes:

- Fixed bug in Domains schema.

Changes:

- Changed info calls reponse length handling to handle responses
with a small size than the requested one.

- Changed validations on FbCommand.CommandText property.

FlameRobin 0.7.0 Released!

0.7.0 (win32 setup) is out.
The other kits will be done soon.

Firebird 2.0 Release Candidate 2 is Released (Linux Builds Only Currently)

The Firebird Project is pleased to announce the second release
candidate of Firebird 2.0, for final testing. The Source tarball
and the binary kits for Linux have been uploaded and should be available
soon. There will be a delay with the Windows kits so please be patient.

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

Regards.
Firebird Project

FIBPlus V6.4.1 with Delphi 2006 support

FIBPlus V6.4.1 is available for download. This new version includes Delphi 2006 support and several bug-fixes for V6.4. Please read the release notes for more details.

EMS software for Interbase or Firebird with a 15% discount

EMS announce a special May offer, this offer allows you to purchase any EMS software for Interbase or Firebird with a 15% discount. The offer is valid for only 15 days.

Why Microsoft will fail

Toorg's Tales mentions Firebird.

Firebird: Improved remote protocol

Dmitry Yemanov reports:

The remote protocol has been slightly improved to perform better in slow networks. In order to achieve this, more advanced packets batching is now performed, also there are some buffer transmission optimizations. In a real world test scenario, these changes showed about 50% less API roundtrips, thus causing about 40% less TCP roundtrips. Hopefully, this is an improvement some our users could benefit from (mostly it should affect over-the-internet database access).

This work has been committed into the HEAD branch to be included into the next Firebird version. Further protocol improvements are also planned.

Borland Unveils New Organizational Structure

More, "interesting" news from Borland today: "Borland Unveils New Organizational Structure"

And, Nick Hodges have few words to say:

" What I do know is that we Delphi people need to start realizing that this isn't something for us to be concerned about anymore. Borland and DevCo are de facto separate entities -- soon to be de jure separate. It's been a long time, and it will likely take some getting used to, but Borland's fate really isn't ours anymore. While I'm sure we all wish Borland well, DevCo is on a separate path, doing separate things, with a different market and a separate business model to follow. Borland laying off peole doesn't really seem to affect DevCo. It appears as though DevCo is pressing forward."

Morfik on ZDNet

ZDNet blog brings article about Morfik WebOS, wich uses Firebird 2.0 as its official database. WebOS is the the next big thing in web app development, raising the level of abstraction above the level that PHP and AJAX have achieved. With WebOS you can write very advanced web applications, very easy, very fast and very robust. No wonder it picks FB as its default database choice. Read more

David Intersimone on Borland spin-out "DevCo"

The leadership team of DevCo includes: Nigel Brown, Michael Swindell, Steve Todd, Alan Bauer, Ben Netick, and David Intersimone. They have 3-year roadmaps for Delphi, JBuilder, and Interbase. The size of DevCo will be ~250-300 at the start, i.e. about 20% of Borland's workforce. "Develop" has $100 mln in sales, about 30% of the total. Sounds like "DevCo" will be quite profitable from the start.

Read more

Common Firebird Errors and Firebird .NET Provider Exceptions

Common Firebird Errors and Firebird .NET Provider Exceptions

Jim outlines Falcon

Jim outlined Falcon at the MySQL user conference. All the Firebird concepts are in place: single file paged storage, indexes hold no data, self-tuning, multi-versioning, careful write, etc. The main design difference with Firebird is that record versions are kept in memory, with overflow to disk, i.e. the 'sweeper' thread is replaced by a 'writer' thread. Falcon is due to appear in Q3, which makes it a 90-day project .. just like Vulcan.

Read more

The Open Source Venture Capital Universe

Sys-Con discusses how VC investments in Open Source have worked and are working. Says one VC: "What I find most compelling in the OSS business models is the recent shift from the support- and services-based revenue models to the commercial open source. In the commercial open source model, about 80 percent of the product functionality is released as OSS, which guarantees a great product for most customers. The remaining 20 percent of functionality, which is useful to only large customers, is released as a low cost commercial product." Like Fyracle, you mean?

Read more

LinuxDevices on Firebird

Although most Firebird users deploy on Windows, the Linux community is increasingly discovering the benefits of this database system: easy, compact, powerful. LinuxDevices reports.

Read more

Mickos critical of 'crippled' closed-source databases

MySQL CEO Mickos told conference delegates: "There's no freedom in crippleware... I learned when I moved to the US there's no such thing as a free lunch. If a company that gives you a free version is closed source, they gain nothing unless you upgrade to the expensive version." At the same time MySQL are partnering with Microsoft, IBM's DB2 division and Oracle. Who's paying for that lunch?

Read more

Jim Starkey: Introducing Falcon (Storage Engine for MySQL)

Last session of the MySQL UC is Jim Starkey giving an introduction to the new Falcon storage engine. Jim is an icon in the database field, was the creator of MVCC and the BLOB data type. There’s a can of Falcon beer for anyone who asks a good question.

Read the Falcon intro

[Ed :When i read the word Falcon i always associate it with Millennium Falcon, Yes Jim is fighting a good cause against evil empire ]

Firebird used at siemens.com

Firebird seems to be used in embedded area at siemens (amd mips processors) .
You can follow the mips porting thread on sf.net

falcon will rock on fulltext searches (mysql)

via Jeremy's blog

The good news is that the recently announced falcon storage engine should have a FULLTEXT engine that rocks. After explaining the situation a bit more, we decided that in the mean time a 64-bit MySQL with a ton of RAM is probably the only viable solution.

Xul for thought: Strange Blog behaviour and Firebird Embedded Database on Linux

[ED:Don't know what was the solution to his problems , at least firebird embedded is used by someone ;)]

Read more at xullicious.blogspot.com...

Nigel Brown talks about IDEs future

Nigel Brown, "DevCo" general manager discusses some of the plans for Delphi and the JBuilder. Very interesting.

You can find the full interview on The Register. You can also find comments from Allen Bauer, Nick Hodges (hey, Nick, you forgot the title!), and people in the newsgroups (using Marco Cantu's AJAX frontend).

What's my take? I find it very interesting and it sheds a new light on the way DevCo could sell Delphi. They want to take again the lead over Microsoft ("Our goal is to get back to that scenario where we are leading"), invest more moeny in the IDE tools, rehire "engineers and architects who were at the forefront of developing languages", mentions an "installed base of three million developers", wants to start "making money from support and added services".

New SQL functions

Dmitry Yemanov writes:

Implementation of a new aggregate function LIST has been committed into the HEAD branch. It's one of the remaining changes that weren't ported from the Yaffil codebase yet. There are other built-in functions to port, they will be discussed in firebird-devel later this week.

Syntax: LIST ( [DISTINCT] value [ , delimiter ] )

Semantics is similar to the LIST function in Sybase SQL Anywhere and GROUP_CONCAT function in MySQL, with the exception of the ORDER BY clause which is not supported yet.

Also, Adriano dos Santos Fernandes has implemented the new REPLACE function (also about to be committed into HEAD). It can be considered a simplified version of the standard MERGE statement, which allows conditional INSERT or UPDATE operation based on a primary key match.

Syntax: REPLACE INTO table [ ( column_list ) ] VALUES ( value_list )
[ RETURNING column_list [ INTO variable_list ] ]
The SQL99-compliant MERGE statement is also planned for implementation in the future.

Read more

More info about Falcon

Here you can find more information about the new MySQL engine. Falcon is the new “toy” from Jim Starkey

Firebird Foundation blog

FF just started its own blog. You can check the first posts here.

if you can’t connect to localhost with firebird2 rc1

Problem is the installer for firebird 2.0 rc1 currently changes permissions on /etc/services file to 600 and permisions need to be 644.

This has been posted on Firebird Devel List and is patched.
I will repost it here so others have less problems finding it.

REPOST FROM Firebird Devel List

[See remaining text…]

The FB-2-beta2 still changes the access rights to
/etc/services.

I finally figured out why my java (after
fb-installation) failed to work with a network. This
failure had nothing to with fb, even a simple
InetAddress.getByName(”localhost”);
failed.

The reason is, that the install process sets the access
rights to /etc/services from 0644 to 0600!

This prevented Java to access the network (except for
user root).

Using Firebird with SME Server 7.O (an modified version of Red Hat Enterprise Linux)

Here are the instructions to run firebird on SME Server

Firebird bigger than MySQL on Windows

Marten Mikos says that 40% of MySQL is on Windows. Taking an installed base of 5 mln, this means about 2 mln on Windows. Firebird is 70..80% on Windows, so >2 mln. Marten further wants to be partners with Microsoft. "Hi Bill, I've just hired Firebird's Jim Starkey to write Falcon and compete with SQLServer head-on. Want to be friends?"

Read more here

Birds, Dolphins and now… Falcons (isn’t Falcon a bird?)

“At the MySQL’s fourth annual users conference, Jim Starkey, a database trailblazer with InterBase and currently a MySQL senior software architect, will discuss MySQL’s developing storage engine, code-named Falcon, said Zack Urlocker, executive vice president of marketing Cupertino, Calif.-based MySQL. The conference kicks off Monday in Santa Clara, Calif.” - Read more here.

Linux SS new install package - mainly for slackware

Alex Peshkov writes:

I’ve done some changes regarding SS installation. This mainly deals with
Slackware support, but some changes concerning another things are also
done. Who interested, may try Snapshot builds from
http://www.insi.yaroslavl.ru/fb/.

Creating Firebird database programatically in delphi

Today my colleague asked me the question, “How to create FB database programatically from Delphi?”. Well, the solution is very easy, just use the following code:

[See remaining text…]

IBDatabase1.DatabaseName := ChangeFileExt(Application.ExeName, '.fdb');
IBDatabase1.Params.Add('USER ''SYSDBA''');
IBDatabase1.Params.Add('PASSWORD ''masterkey''');
IBDatabase1.Params.Add('PAGE_SIZE 4096');
IBDatabase1.Params.Add('DEFAULT CHARACTER SET WIN1250');
IBDatabase1.CreateDatabase;

Jiří Činčura - http://blog.vyvojar.cz/jirka/

Are you ready?!

Are you ready for TPC-C based test results? Are you looking forward to know who is the winner?! Be prepared - 4th issue of IBDeveloper is coming soon!

Want to know who is who? Read IBDeveloper magazine!

JDBStudio - with Firebird and Fyracle support

New Java database administration tool - JDBStudio, that has plugins to support both Firebird and Fyracle functionality. More details, and free download.

Indiana Jones of the Balkans and the mystery of a hidden pyramid

“We’re talking about a huge construction effort here. The size of this pyramid will shock the archaeological world. It’s substantially higher than the Great Pyramid of Egypt,” said Mr Osmanagic, who has spent 15 years researching the pyramids of Central and South America. “We have discovered tunnels linking the pyramid with other hilltops. We have also found a huge entrance plateau, paved with thousands of handmade sandstone plates. Once the world accepts that we have this huge pyramid we will start trying to answer the questions: who? when? how? and why?”

Source

BDS2006 Update #2 - English

Now available for all registered users of BDS 2006. This is a patch that will install on either the initial released version or the C++Builder update version.

Read more

INFORMATION_SCHEMA for Firebird

Lorenzo Alberton writes:

"The SQL 2003 Standard introduced a new schema called INFORMATION_SCHEMA. PostgreSQL, SQL Server and now MySQL have it. ORACLE, DB2, Sybase, Ingres, Informix and other DBMS have something similar, usually called System Tables. The INFORMATION_SCHEMA is meant to be a set of views you can query using regular SELECT statements, for instance if you need to know something about the defined triggers, or the structure of a table to which you have access. Firebird doesn't have it, but you can retrieve pretty much everything you need from the system tables. These are metadata tables, their names start with "RDB$". Let's see how we can retrieve some useful informations from them."

Avalon3D vs Delphi

From Mabster's blog:

"

Something quite funny:

I forwarded a link to Channel9's latest demo of Avalon3D to a co-worker of mine who does a lot of OpenGL/Direct3D stuff in Delphi.

As part of my email, I commented on how impressive it was that they knocked up a 3D scene with an animated camera in only 30-or-so lines of code.

Within a few minutes, Pete sent me back an exe he'd written in Delphi using about 30 lines of code, that did exactly what the demo's application did.

I keep forgetting just how advanced the old dog is, even compared to Microsoft's "next big thing"! :)

"

More eyes on the code = better quality

From Dmitry Yemanov

Adriano dos Santos Fernandes has joined the Firebird code reviewing team (we can now call it a team, since there are now two people involved in this task - Claudio and Adriano). Adriano will be assisted by a grant from the Firebird Foundation.

Warning! Serious GBAK issue!

From Dmitry Yemanov

Running GBAK -C by a non-privileged user (i.e. neither SYSDBA nor database owner) causes an original database to be overwritten instead of the expected “database already exists” message.

This bug seems to be inherited from IB 6.0 and it exists in all FB versions. However, FB 2.0 is not affected due to different default restore rules.

"Oracle Accord Means Business-as-Usual"

from OpenEnterpriseTrends:

"Not taking any chances, however, MySQL is also developing its own transactional storage engine and will extend its transaction support by adding technologies developed by one of the creators of InterBase (which later became core technology for the Open Source Firebird project)."

SQL/e - Microsoft answer to FB Embedded?

From Steve Lasker’s Web Log - “I’m not familiar with the details of Firebird Embedded, so I can’t make a comparison. To capture the essence: SQL/e is a lightweight, in-proc relational database that offers a subset of the data types and TSQL syntax to provide queries over relational stored data with transactional support. The SQL/e data format can be password protected with encryption. SQL/e is based on the proven history of the Microsoft SQL Server Mobile Edition technology.”
Read more here.

To quote the FAQ on website:

Q: Does SQL/e support stored procedures, or views?
A: No. Because SQL/e is targeted at lightweight, in-proc scenarios these features aren’t available. However, these features are typically used to provide multi-user abstraction from the underlying database schema. Because SQL/e runs in-proc with your application these features would typically provide more overhead than value. Because SQL/e runs in-proc with your application, why limit yourself to T-SQL within a stored procedure? By creating a data access layer to your SQL/e database you can use the full power of the .NET Framework.

Q: How big is the SQL/e runtime?
A: For all 7 dlls, the entire runtime is 1.4mb. This is less than a SQL Express .mdf file.

Q: What is the data file size limitation of SQL/e?
A: Both SQL/e and SQL/x share the same 4gig size limitation.

‘Nuff said!

Delphi 2006 and WinForms in .NET 2.0

via Marco Cantu

"

Delphi 2006 can be used to write .NET 2.0 applications... by using the command line compiler.

In a recent blog post, Daniel Wischnewski shows how to compile a Delphi application for .NET 2.0. The trick is to use (from the command line compiler, not from the IDE) the --clrversion flag. He shows that you can compile a .NET 2.0 console application (using a specific 2.0 feature, the console background color) with this command:

dccil -CC
 -NSC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
 --clrversion:v2.0.50727
 --no-config
 SimpleSampleNET2.dpr

The only extra operation you have to do the first time is to copy to the project folder the source code file Borland.Delphi.System.pas and compile it with the following command:

dccil -CC
 -NSC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
 --clrversion:v2.0.50727
 --no-config
 -Q -M -y -Z -$D-
 Borland.Delphi.System.pas

   

Now, before you think I'm only quoting his work in my blog post, I've easily replicated Daniel's steps, but gone one step forward. I've used Delphi 2006 to create a new Delphi for .NET WinForms application, added to it code specific to version 2.0 of WInForms, and compiled it with a similar command line call.

In my extra code I've added the flat style to a button and used a new .NET 2.0 control to play a sound. This is my code:

procedure TWinForm3.ButtonClick(sender: TObject; e: System.EventArgs);
var
 sndPlayer: SoundPlayer;
begin
 Button1.FlatStyle := FlatStyle.Flat;

 sndPlayer := SoundPlayer.Create;
 sndPlayer.SoundLocation := 'C:\Program Files\Messenger\type.Wav';
 sndPlayer.LoadAsync;
 if sndPlayer.IsLoadCompleted then
   sndPlayer.Play;
end;

Now you cannot compile this code with the Delphi 2006 IDE, as some of the features are specific to .NET 2.0. But you can compile it with the following command line, similar to the previous ones but with references to the assemblies used:

dccil -CC
 -NSC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
 --clrversion:v2.0.50727
 --no-config
 projform20.dpr
 -luC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll
 -luC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Windows.Forms.dll

Of course, with no help from the designer, no IDE-based compilation, and no proper Code Insight (although it might be possible to turn these on), building WinForms 2.0 applications in Delphi 2006 is far from a great experience. However, if you want to experiment with some of the new components and properties, while you wait for Highlander (next version of Delphi), and don't care to install Visual Studio, this might be an interesting option. This also speaks in favor of the flexibility of the BDS IDE."

InstantObjects 2.0 Beta 3

via Marco Cantu

"A new beta of InstantObjects was released a few days ago... a very interesting O/R mapping solution for Delphi Win32.

InstantObjects is a powerful object persistence layer based on an object/relational mapping approach for Delphi Win32 VCL applications. In other words, your application code deals with objects in memory and the corresponding data is saved in a standard relational database. InstantObjects was based on the classic approach of Scott Ambler . It has recently been extended to work better in a SQL server world and supports a large set of databases. The architecture of InstantObjects is really very neat, and I find it nicer than many other more popular O/R mapping libraries.

At first, InstantObjects was a commercial product. When it was abandoned by the original developers and released as an open source project, a group of users set up a real and active open source project. Development has been steady and both bug fixing and new features are countless. There is an energetic community of developers and end users that is not only keeping the product alive but really improving it. Sadly this is not true for other Delphi open source projects, like those originating from TurboPower.

By combining this two features (a solid technical foundation, an active community) InstantObjects is a very interesting option as a framework for many different types of development projects. Learning the core features of InstantObjects is relatively easy, as you can find out looking at the classic (even if quite out-of date) presentation video. Its IDE integration helps a lot in defining new classes and their attributes. Its integration with Delphi's TDataSet architectrure lets you work on the user interface as with any other dataset.

I have no space for a full presentation, but I really suggest you evaluate it (the previous beta was also in the Delphi 2006 Companion CD) if you are interested in this kind of architecture. Certainly I'm biased towards it because part of the core group of developers are some Italian friends of mine (which is why the IO home page is hosted on my office server, like this blog) but I woudn't be pushing it if I wasn't sure of its technical merit."

Chess game in ajax - done by morfik team

via Mauricio Longo’s blog

Much had been said about the browser as a platform. It was an idea strongly promoted by, the now gone, Netscape at the start of the Web revolution, but we never got there. Did we? Yes, we did! We just did not notice it!
If you take your browsers to this chess game, you might start to understand what I mean.

< This game has a great interface and is played against you by your own computer. Your moves do not get sent off to a server which comes up with a response and sends a move order back to your browser. The analisys of the play and the decision of the move is entierly done in Javascript, in your own machine, by the browser.

JStar will be MySQL's own egine

Apparently MySQL will use JStar as an alternative to InnoDB. “What we didn’t tell people when we bought Netfrastructure is that we were getting more than just people. We were also getting software,” Mickos said. What else has he left out of his story, to reveal later??

Read more

MS vaguely outlines plans with SQLServer

Paul Flessner says that MS will release a light version of SQLServer called SQLServer Everywhere. Probably similar to Firebird embedded dynamic library, but with fewer features. He also says: "Today the cost of storage continues to be on an amazing trajectory; one could reasonably expect that the cost of a terabyte will be reduced from about $1000 today to $100 in 2007."

Read more

MySQL fills Oracle-consumed hole in database

MySQL fills Oracle-consumed hole in database by Martin LaMonica on ZDNet.

" The storage engine MySQL is working on will be available this year. The engine derives from MySQL's acquisition of Netfrastructure, which employed database luminary Jim Starkey and other engineers.

"What we didn't tell people when we bought Netfrastructure is that we were getting more than just people. We were also getting software," Mickos said.

At the company's customer conference later this month, MySQL executives will further detail its strategy for storage engines.

The company will disclose partners that are writing their own storage engines for MySQL and further detail its "plug-in" architecture for storage engines, said Zack Urlocker, MySQL vice president of marketing."

MySQL to unveil new transaction engine

MySQL to unveil new transaction engine by China Martens on LinuxWorld.

"MySQL is due to unveil a new transaction database engine at its upcoming user conference later this month, according to a company executive. The open-source database vendor will also be showcasing database engines from third parties, Zach Urlocker, vice president of marketing at MySQL, said Thursday.

The new transaction database was developed by Jim Starkey, a noted database software architect who joined MySQL when it acquired his Web application technology company in February, Urlocker said in an interview at the LinuxWorld conference in Boston. When Starkey joined MySQL from Netfrastructure, rumors immediately circulated that he had been hired to develop a new transactional engine for the company."

RedHat acquired JBoss

As predicted by many, JBoss has entered into an agreement to be acquired - by Red Hat, which anticipates accellerating the shift to SOA. According to the press release by Red Hat, they are acquiring JBoss for approximately $350 million in initial consideration, plus approximately $70 million subject to the achievement of certain future performance metrics.

Read more

SourceForge community loves the blue frog

"Of note was Firebird's second place in the database category. This relational database is quietly picking up both in community interest and market share, and could rival PostgreSql and MySql in time. "
Read here

I’m an Open Source project - buy me

via silentpenguin

With an - umm - “interesting” choice in wording, Pentaho announce the acquisition of the Kettle project. Kettle is an Open Source project centered around data integration. Matt Casters’ announcement on the same subject is more along the lines of the project “joining” Pentaho. Pentaho have hired Matt to be a data integrations architect there.

Win32 Classic and keepalive packets

From Dmitry Yemanov:

It has been discovered recently (thanks to Eugene Kilin) that Win32 builds of Classic Server did not set up some socket options properly, including SO_KEEPALIVE. So if you have troubles with “zombie” processes not terminating after the keepalive internal, this is the reason. The patch has been committed into HEAD today and it will be available in the v2.0 RC2 release.

Also, Windows builds (both SuperServer and Classic) are now in sync with the POSIX ones and also have the Nagle algorithm disabled by default. If you want to change this behaviour, set the config option TcpNoNagle to zero.

Linux kernel gets Oracle cluster support

Oracle's Cluster File System is to become part of Linux kernel 2.6.16 The Cluster File System is designed to let multiple Linux servers use the same file system and ease management of Linux servers. Time to start dusting of Firebird's cluster code.
Read more

Evans Data IDE Study Shows Borland Toolset Still a Powerhouse

"Evans Data today announced the results of Developers' Choice - IDEs, a study in which over 700 developers ranked the features and capabilities of nine top IDEs that they currently use. IBM's Rational Application Developer edged past Borland's JBuilder to receive the highest overall relative scores against top IDEs including Eclipse, Macromedia Studio MX, and Oracle Developer Suite. IDEs were ranked in 13 distinct categories including compiler/interpreter, debugger, editor, compiler performance, performance of resulting apps, ease of use, sample apps, and libraries/frameworks."

SAS Launches Enhanced Vertical BI Line

SAS Institute at its annual user conference introduced on March 27 three new and seven enhanced business intelligence applications designed to give customers tools for performing data analysis that predict trends and uncover potential problems. SAS is a prominent user of Firebird, as they explained at the last conference (zip with two pdf's hosted at IBPhoenix).

Gracco uses Firebird

Gracco - a new software developed by Zats & Loib - offers a complete and integrated solution for management business-oriented pertaining to legal profession for the Brazilian market. A free version of the tool can be download here. Gracco uses Firebird SuperServer as database.

Getting VCL/.NET ready for .NET 2.0 and 64bit CLR

by Allen Bauer

Changes, my friends, are afoot. While waiting for the Delphi/.NET compiler (dccil) to embrace all the latest goodies in the CLR world (partial types, generics, nullable types, anonymous methods, etc...) other engineers have been working on a lot of things that are independent of all the new compiler goodness. The biggest change that is going to happen to VCL/.NET is the change from using Integer for handles (ie. THandle = Integer;), it must now be changes to IntPtr. One common misconception (and one I admit to having fallen prey to as well) is that somehow IntPtr is some kind of “Pointer” type represented as an Integer. Well, call me foolish and gullible, but I'm going to go out on a limb here and say that “IntPtr” is not what I'd call a very good name. OK, OK... it basically sucks as a name. I can see why at first glance one would be led to the misconception that “IntPtr” is a “Pointer.” So what is this odd bit of identifier madness? In actual fact (and to the more intelligent and astute among you, this is all mindless drivel), it really means this “Integer whose physical size and precision matches the physical size of a Pointer on the currently running underlying platform for which the “Just-In-Time” compiler is actually generating code” (pay no attention to the nested quotes in that statement).

Read more here

DRoster Employee Scheduler

Kappix Releases DRoster Employee Scheduler 2.2.1 - Uses "a standard Software industry database (Firebird)".

MediaWiki roadmap - Firebird support in version 2.0

Major plans for 2.0 - Firebird support will be added

MySQL AB Acquires Firebird Foundation and Flamerobin

Milan Babuskov, one of original creators of fbManager which became Flamerobin, just made it publicly known that he now works for MySQL AB.

My project, Flamerobin and Firebird Foundation , have been acquired by MySQL, AB. As part of the agreement, I will be working full time for MySQL. I expect to lurk on the flamerobin-devel list from time to time and may contribute the occasional wolf-o-gram, but I will not be taking an active part in Flamerobin development. Although Mariuz will work for MySQL, part time, translating from wolf to English, He will continue to be active in the Firebird/Flamerobin projects.

Ann Harrison gave the idea to buy all the firebird developers with this post
on firebird-support

Update 4/4/2006: Till next year, happy April Fools.

MyPostBirdSQL 2.0 RC1 released

Today first RC1 release is announced that many oss developers had been awaiting

MyFireGreSql 2.0 is based on code from mysql 6.0 ,firebird 3.0,postgresql 9.0
We needed a big shake up in open source database world and working on the common code base have it’s
advantages:Firebird and Postgresql borrowed from mysql’s speed , mysql used MVCC for it’s transactional engine (is based on firebird) .

[See remaining text…]

SQL2003 is implemented in all three engines now that is published as standard .So why working on a three SQL200X implementations when we could work only on one? , The project’s model is linux kernel where vendors are using only one source code for their distributions (patched properly) but there is only one organization for working on the kernel osdl.