Developer News Archives - Page 57 of 57

IBPhoenix Developer CD No. 10 (February 2006) is now shipping

February 28, 2006 mariuz Leave a comment

IBPhoenix Developer CD No. 10 (February 2006) is now shipping, including a new in depth look at “How to Write an External UDF Function”.

Interesting Project Metrics

February 6, 2006 mariuz Leave a comment

I’ve been wonder for some about about metrics to evaluate the relative architectural cleanliness of various database implementations. To that end, I wrote a simple program that eat Visual Studio 7 projects files and analyzes the source files. Here are the results:

	Nfs Engine	Vulcan	Firebird 2	MySQL Server
Total Modules	429	633	232	123
Total Lines	63432	227814	126274	214356
Code Modules	206	218	70	99
Header Modules	221	394	162	15
Preprocessed Modules	0	16	0	0
Other Modules	2	5	0	9
Number Functions	2839	4706	1633	4960
Average Arguments	5.00	8.65	13.08	7.58
Average FunctionLines	14.86	32.46	55.95	31.70
Average Code Lines	11.80	21.20	37.12	26.90
Average Internal Comments	0.94	6.10	11.92	2.59
Average Internal WhiteSpace	2.12	5.16	6.92	2.21

The analysis program doesn’t try to follow conditional compilation, so everything is included whether active or not.

The Netfrastructure engine is roughly equivalent in functionality to Firebird. The Netfrastructure numbers, however, are for the database engine only, excluding the Java Virtual Machine and template engine. Since the trigger and procedure language in Netfrastructure are Java, this isn’t a strict apples to apples comparison. On the other hand,the Netfrastructure engine includes the remote server, which Vulcan does not.

[See remaining text…]

The Vulcan numbers are taken from the engine provider current code base. A small number of modules that, due to conditional compilation, couldn’t make it through the analysis program were omitted. Post-processed modules were also omitted. Since Vulcan contains quite of bit of archival, disabled Firebird code, its numbers are slightly bloated.

The Firebird number are taken from “engine” msvc7 project. Since Firebird 2 doesn’t use custom development steps, the preprocessed modules aren’t included (the project hasn’t been built, so the corresponding post-processed modules are not included either. I don’t actually know what is the Firebird 2 engine build, but I assume it doesn’t include DSQL and possible other common stuff.

The MySQL numbers are from their Windows source kit. I believe that they also use static libraries for cross component modules, so I suspect this is less than the full server. But it does give a feeling.

I think the two most interesting sets of number are the average number of arguments per function and the average number of code lines per function (code lines exclude comments and white space). It is most interesting that in each case, Vulcan falls halfway between Netfrastructure and Firebird 2. The average number of arguments is a good metric of the quality of a design. Bad (or in this case eroded) designs have to pass everything but the kitchen sink, and sometimes that. The Firebird 2 numbers are particularly scary because many additional parameters are passed covertly through thread data. The average code lines per function is a good metric of modularity — the degree to which common code is cleanly factored out.

The comment related metrics are substantially misleading since they are computed relative to number of functions rather than code lines — fewer code lines will always mean fewer comments. Even so, it is clear that Firebird has something to teach me and MySQL about internal commenting.

Both the ProjectAnalyst and ProjectsSummary projects are checked into the Vulcan tree under src. If you want to play or analyze Firebird 1.0 or 1.5, I’d like to see the results. You may also want to add more metrics. ProjectAnalyst generates xml (sans header) summary files, ProjectsSummary turns a set of xml summary into an HTML table.

--
Jim Starkey
Netfrastructure, Inc.
978 526-1376

« Hide it

Database Development Forum – For Developers, By Developers

January 30, 2006 Martijn Tonies Leave a comment

Upscene Productions and Arno Brinkman (Firebird core developer) started Database Development Forum, a place where developers can ask questions about database development. There are forums available for many different database engines and the idea is to start a community of developers that will ask and answer questions, all in a single website. You can register or anonymously ask questions, but registering has benefits – like getting e-mail notifications on answers.

Firebird 2.0: Status Update

January 27, 2006 dimitr Leave a comment

A few words to those interested in the v2.0 progress.

Currently we’re in the process of preparing the Beta 2 release. The CVS tree has been tagged a week ago, now the Release Notes are being updated. The binaries should be packaged soon. We did intend to release it earlier, but there were a few hard-to-track issues found in the codebase, so we had to solve them first. Also the final v1.5.3 release has been done at the same time. These are the reasons of the delay.

If nothing critical is reported in the near future, I expect that the next official build will be Release Candidate 1. We still have bugs reported quite regularly, but neither of recent bugreports mention database corruptions or server crashes, so it appears we can consider the codebase stable enough.

Please note that Release Candidate builds are intended to fix regressions only, there will be almost no old bugs fixed during this stage. Starting with RC1, our developers will switch their attention to the Vulcan merge and new features/improvements.

— Dmitry Yemanov

Version of SR UDF Library 2.0.1.0 is available

January 26, 2006 Martijn Tonies Leave a comment

There’s a new version of the SR UDF Library available. This external functions library includes 160 new functions to be used in your InterBase or Firebird databases.

For more information, see the SRMaster website.

« 1 … 55 56 57