After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.
Firebird 2.1 added the long-awaited monitoring tables. By querying special system tables starting with MON$, you get a snapshot of the current activities in your database like who is connected to your database, which transactions and statements are running and so on. You even can cancel a running query by executing a DELETE statement on MON$STATEMENTS. Firebird 2.5 will also allow you to cancel an entire attachment via a DELETE on MON$ATTACHMENTS.
VVV is an application that catalogs the content of removable volumes like CD and DVD disks for off-line searching.
Folders and files can also be arranged in a single, virtual file system. Each folder of this virtual file system can contain files from many disks so you can arrange your data in a simple and logical way.
Other than CREATE USER something really valuable has been added, the ability to query other databases.
The recent release of Firebird version 2.1.1 is very welcome.
Here are a few of the fixes I consider important for 2.1 production servers and so recommend the update:
The complete list of bugs fixed and the downloads are at the Firebird SQL website.
Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.
Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.
Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for each attachment. The benefit being that it uses fewer kernel resources and is a bit faster.
Read a deeper comparison between the three architectures.
Hello, Dear Firebird Team Members!
After almost two years in development, four betas and four release
candidates, Red Database 2.1 is finally released.
Information about the release is present here:
http://www.red-soft.biz/en/index.html
Plazma ERP+CRM is user-friendly application for small and middle business and here is the faq
In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.
The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.
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:
