Firebird News

Via Paul Beach Blog

I was recently contacted by a Firebird user on MacOSX who was trying to get the Firebird ODBC driver to build on MacOSX. I thought I would try and step in to help.

For those of you who follow the CVS checkins for OdbcJdbc you might have noticed the addition of a number of a new directory in the Builds directory called Gcc.darwin containing a makefile, a readme and a .sh file to create a lipo’ed dylib. The driver sucessfully builds and passes some simple tests. Feel free to contact me for a copy of the dylib to test further.

The readme contains the following information

(6 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

Hey!

If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:

• The necessity to add ALL parameters manually.
• Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
• The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
• The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
• No execution of SQL scripts which contain several SQL expressions per command. This list of difficulties a .NET developer has to deal with is far from complete. Now it’s all different in a fundamentally new .NET Data Provider for OLE DB

IBProvider Team

(4 votes, average: 3.00 out of 5)

 Loading ...

Permalink | Comments Off

I was recently in a talk related to Firebird and I found, that people are not aware of these two constructs. Either they don’t know both or don’t know they differ. These statements are doing similar stuff, but the evil is in details.

(2 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

Dmitry Yemanov wrote a series of articles related to Firebird network performance
First article is : Generic thoughts about the network performance
Second article is : Protocol packets and buffers
And the last one is : Records batching

(1 votes, average: 5.00 out of 5)

 Loading ...

Permalink | 1 Comment

For several years now, I’m yearning for a feature that I think that all SQL based databases that I know are missing, and throw it back to the program side.

The feature I wish to have is a way to set a specific record to be valid for only a known period of time, and when the time is up, I’ll be able to do something.

In this post I’ll try to create some sort of general specification for such feature, and I hope that there will be many comments on this that will benefit everyone, and I hopeful, that they will make the idea better.

(1 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.

Read the rest on Accounting++ blog

(1 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

From Paul Beach’s Blog:
We are currently preparing to release Firebird 2.0.7, since I take responsinility for the Mac builds, I did a 2.0.7 build on MacOSX 10.7 using the development tools installed by XCode 4.1 (gcc 4.2.1 etc). I set up the relevant environment variables for this older 32bit only build CFLAGS, CXXFLAGS, LD_FLAGS and also set the MACOSX_DEPLOYMENT_TARGET=10.4. The builds completed without any problems, some simple tests on MacOSX 10.7 showed no problems.

Now – Imagine my surprise when Philippe told me that when he tried to QA the builds on MacOSX 10.5 we got this error on SuperServer startup.

(4 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

New snapshot builds (SVN revision 2210) for Windows 32 and 64 bits are
available on SF.net.

Feedback on field and text delimiter settings for save grid data as CSV
file command would be especially welcome.

Thanks

–
Michael Hieke

(4 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

From http://ramsees.blogspot.com:

I did some comparitions selecting 1000, 10000 and 100000 with Ruby Fb gem, Delphi Fibplus and the FB .NET driver, here is the result:

The results are on milliseconds, the table is from a production database with 40 fields and about 3 million records, as you can see, native code is still the king, .NET result are quite good, but Ruby is quite dissapointing handling lots of data.

(5 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment

This post will show an example of using an embedded firebird database in .NET/C# projects.

(1 votes, average: 5.00 out of 5)

 Loading ...

Permalink | Leave your comment