The news is added in the Other Articles of Interest area in the UWN #292
In this next installment, we’ll be looking at two (arguably very contrasting) databases. The first is Gladius DB, which is a flat file database written in pure PHP. The second is Firebird, another database veteran, which has features similar to some of the better-known databases, such as Microsoft SQLServer.
So with that, let’s get going.
The article is on dzone too
InfoQ: Q&A with Jiri Cincura of the Firebird Database Project about the ADO.NET provider , ORM ,EF …
Jiri Cincura was recently interviewed for InfoQ article – Q&A with Jiri Cincura of the Firebird Database Project. We touched Firebird, ADO.NET, O/RMs, Entity Framework etc. If you have any questions, feel free to ask.
Update: The article seems to be retracted for the moment , Don’t panic we asked why and investigate the cause (see the comments section) ,
Here is the full text from Google cache
We recently spoke with Jiri Cincura of the Firebird database project.
InfoQ: Can you tell us briefly about yourself and your role in creating the ADO.NET provider for Firebird?
Jiri: Currently I’m project lead for the ADO.NET provider for Firebird project. And actually only one active right now. I’m doing majority of development (although there are some worth contributions) and all the stuff around, like testing, releases, issue tracker watching, replying in mailing list etc.
InfoQ: And for the benefit of our readers who are unfamiliar with it, who would you describe Firebird?
Jiri: Firebird is a fully featured RDBMS, with small footprint and zero maintenance. It supports all standard features you’d expect – stored procedures, triggers, views, UDFs, monitoring, online (remote) backup/restore etc. There’s also so called Embedded version, that just one main DLL and few supporting it, without install or need to copy something somewhere. You’ll just reference this DLL and you have all the features of standalone (network) Firebird in your application. And of course, whole Firebird is completely free (and open source).
InfoQ: In the SQL Server world we have to deal with a serious trade-off. If you choose to use the embedded version, SQL Server Compact, then you lose the ability to use a lot of features. Is there any sort of tradeoff like that for Firebird or do you really get access to the whole feature set either way?
Jiri: Absolutely not. Firebird Embedded is fully featured as “big” server. It’s even built from same sources, only with different output (DLL file). You can use everything Firebird offers. And not only that. Migration is super easy. You’ll just take the database file and put it to some place where server can access it and you’re done.
InfoQ: So what’s involved in writing a ADO.NET provider?
Jiri: It’s actually pretty simple. You’re fixing bug, moving with features as Firebird server moves further and improving stability and code itself. Cleanup, refactoring. With all that you’re trying to keep backward compatibility and not introduce some breaking changes. And on the other hand you’re moving along with .NET and ADO.NET (i.e. Entity Framework) world and other data access providers and components.
InfoQ: DId you also work on the Entity Framework provider? If so, what’s your opinion of the ORM?
Jiri: Yes I did. I worker on provider since early versions around 2007. I believe Firebird was first 3rd party ADO.NET provider to have working Entity Framework support (and it’s open source). I think Entity Framework is good ORM, comparable to others, like LLBLGen Pro or NHibernate. It’s not here that long but still very good. I don’t think anybody can say i.e. NHibernate is best because … Every project needs something more and something less. And every ORM (including Entity Framework) has strong points and places where there’s room for improvement.
InfoQ: What areas in particular do you think the .NET-based ORMs need to improve upon?
Jiri: There’s mismatch between relational world and OOP world, even if you believe ORMs are hiding it, it’s there. For simple small applications, this is not a problem. But for a big applications, the ORM needs to be flexible enough to allow really experienced developer hook in and in rare cases when performance is critical or special needs are placed in front of him/her allow to do it own way without creating huge disruption in your code.
InfoQ: If you had more resources available to you (i..e. developers, hardware, etc), what would you like to do with Firebird and .NET that you can’t do right now?
Jiri: Provide more seamless experience for .NET developers using Firebird and improve codebase. Move further faster and provide more features, both from Firebird world and (ADO).NET world.
It’s that time of year again — make sure your voice is heard!
The 17th annual Readers’ Choice Awards are under way! Voting will close on Sep. 2, 2011.
Please note: You are not required to vote in every category, please simply skip over a question if you wish.
Thank you for participating!
Your friends at Linux Journal
ps: send this to firebird-general mailing list too (i’m banned there and for some reason i can’t post there anymore )
Marco Cantu posted in his blog:
…While most of the questions are on the choice and number of servers used (MS SQL Server being the most widely adopted, Oracle the most critical, and Firebird has a significant 4% 5.5% presence for large companies). Other questions are tuned for Embarcadero products (like evaluating the need for automating some DBA tasks). A few questions are interesting for their broad perspective, like those focused on the relationship between developers and DBAs…
Btw, interesting that there is no mention of Embarcadero’s Interbase in the survey results.
Here is the guide on installing Firebird 2.5 from FreeBSD 8.1 Ports and creating your first test database.
The article now is on howtoforge.com , please retweet 😉
Brazilian magazine ActiveDelphi, ed. 81, brings Firebird 2.5 in the cover article. The article shows the major enhancements of the latest FB release.
The decline will not be immediate, it will take some time, notably Apache distributions like XAMPP and WAMP will have to offer users alternatives to MySQL, as most developers use these packages, instead of installing products independently. All is not lost, the Open Source community has plenty of options. There are two well established alternatives to MySQL: PostgreSQL and Firebird. Both have large established communities, and support of major corporations. One of these will become the next MySQL
Well now i noticed that there is a contest so here Firebird is mentioned and enters in the top 5 databases on Linux (Thanks to the Linux Journal readers)