On Firebird Python mailing list there is an interesting thread about rewriting Firebird Python Driver
Here is Pavel response
There is some information at python driver web space at Firebird project
Driver has also it’s own project at JIRA tracker.
> Is there any documentation for firebird protocol?
But it doesn’t cover protocol enhancements from FB 2.1
Also JayBird source is good implementation reference.
« Hide it
This article shows howto use Firebird Embedded 2.1.x with C# and how to write your first application
Here is the original article in Spanish and here is the google translated one
Attached is a patch file ( a ZIP file with extension changed , you should rename it from piz to zip ) with
changes to allow v1.7 of the provider to connect against Firebird 2.1,
changes has been done by backporting 2.5 svn sources to the v1.7 sources.
[ED: soon there will be an v1.7 release that will integrate this patch]
Via Jiri’s Blog
As you (maybe) know, there was a bug in
left outer join so the model generation/update etc. in Entity Framework and similar tools was failing. The bug is now gone. Well, it’s not in some oficial release, but it’s in sources. If you want to test it, grab sources and build or grab this build (only SuperServer executable). Also take into accout, that it’s build from current sources and can be very unstable.
What would you think is harder to do? Run a .NET Client/Server application through mono on Linux or install Ubuntu on Microsoft’s Virtual PC?
Here is the long answer
Server generated values – not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.
Today, after some days/weeks, I finally created some noticable (= not only internals) progress with Entity Framework provider for Firebird.
Now, the provider is able to use, map, call, … stored procedures (and functions [very experimental]). You can select stored procedures from database, map these to some operations in EF, create “function imports” etc. You can see this working on picture:
NHibernate 2.0.0.Beta1 is released. It is comparable to Hibernate 3.2 in terms of features.
This article was originally created for Databazovy Svet (in Czech) and covers a little bit more about this topic. This shortened version is focused only on solutions for Firebird, without any other stuff.
Sometimes I see question(s) in forums, groups, lists about ability to run program from trigger or better to say perform some action done by external program. Well you can create many of possible solutions, working best for your case. But I’ll cover two “special” features available in Firebird that can help you with this
« Hide it