For some time now the entire FieldWorks team has been engaged on a rearchitecture effort. This involves a complete change to the way that FW stores its data. In particular, the tight dependency on the MS SQL Server database is being severed, and replaced with multiple interchangeable back-ends. These new back-ends range from a flat XML file through db4o to MySql.
Language software for Linux and Mac OS X
David asked, “I’m curious to know why Firebird has been chosen as a database engine [for FieldWorks] out of the many other RDBMSs out there, such as MySQL.”
I get this question from time to time, especially when I go to our Computer Technical Conference (CTC), which comes around every two years. It is a fair question, and since CTC is just a month away, I’m taking the opportunity to remember why we did what we did. I had to ask the people that made the decision, because I had a hard time remembering. It’s been a few years.
Since we’re porting from SQL Server to Firebird, code that works on both RDBMSs is highly valuable. We want to connect to either using C#.
I’m a Michigander working in Texas. I’ve been working on databases for FieldWorks since 2001. Currently FieldWorks uses SQL Server. My role in the Linux team is to help port from SQL Server to Firebird.