How to install Firebird 3
IBSurgeon just published an article about How to install Firebird 3.0 (snapshot build) on Windows. There are some differences compared to previous Firebird versions, so everyone should read this.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Firebird vs Windows: file-system caching issue
This article, from Dmitry Yemanov, is a must read for everyone using Firebird on more recent Windows versions, specially Windows 2008. As some people already experienced, it seems that the Windows Cache Manager intelligence in those versions of Windows are not smart enough, and can produce very bad performance for database access in some circumstances.
Clojure connection with JDBC is successfully done
Generic thoughts about the Firebird network performance
Free Pascal full text index/searcher classes committed in Lazarus svn
ХудожникMichael Van Canneyt announced his full text indexer project:
I’ve committed a file/database indexing and search engine, fpindexer, to SVN.
It was developed by Darius Blaszijk, with help from me. One of the planned uses is
to create searchable documentation. I’ve also (in a private project) used it to
implement full-text search on a database that doesn’t support that natively.
Timeout records – Feature request
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.
We are currently preparing to release Firebird 2.0.7
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.
The bleak future of SSD drives
The technology trends we have described put SSDs in an unusual position for a cutting-edge technology: SSDs will continue to improve by some metrics (notably density
and cost per bit), but everything else about them is poised to get worse. This makes the future of SSDs cloudy: While the growing capacity of SSDs and high IOP rates will make them attractive in many applications, the reduction in performance that is necessary to increase capacity while keeping costs in check may make it difficult for SSDs to scale as a viable technology for some applications.
Not good news, specially for those thinking about using the for critical work, like database servers.
Read full research here (in English). Short article in portuguse here.
Kitto – A framework for creating data-driven web applications with Delphi and ExtJS
Kitto allows to create Rich Internet Applications based on a data model that can be mapped onto any database. The client-side part uses ExtJS (through the ExtPascal library) to create a fully AJAX application, allowing you to build standard and advanced data-manipulating forms in a fraction of the time.
Kitto is aimed at Delphi developers that need to create web application without delving into the intricacies of HTML, CSS, Javascript or learning to use a particular library such as ExtJS, yet it allows access to the bare metal if required.
Kitto includes a database-agnostic data-access layer, allowing to create applications that work on any database engine and port applications between database engines.
A Kitto application is described in a set of easily maintained YAML files, keeping definitions abstract and declarative and allowing for future extensions. Business rules are enforced either declaratively or through small javascript fragments on the client, or in Delphi code on the server.
Kitto was designed by Nando Dessena and its development is sponsored by Ethea, which uses Kitto for internal development projects and client work and provides Kitto-related tools, support and development services.
Start here for further information.
The getting started guide can be tested with Firebird and Delphi
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?
