Wednesday, April 14, 2010

Embedded Databases

When I went looking for a small, fast, and reliable embedded database, I cam across three contenders:
I've tried out SQLite briefly before, but I've only recently heard of Firebird. With the release if Service Pack 2 for SQL Server Compact Edition, I'm planning to spend some time there first. Each database is relatively mature, but each also lacks the power and grace of a full-size database server. There will be trade-offs, no matter which one I choose.
Posted by at 8:49 PM

2 comments:

Anonymous said...

So what makes you think Firebird "lacks the power and grace of a full-size database server"? Firebird comes in two forms, full server and embedded. The only difference between the two is that the embedded version of Firebird is designed for a single user only.

April 15, 2010 1:24 AM
Michael B. Farias said...

True, those are the words I wrote. I had not yet learned that, among other full-size features, Firebird supports single file databases up to 16 TeraBytes, depending on file system and hardware limitations.

Thanks for calling me on my blanket statement and nudging me into taking a closer look. I would not have imagined that an embedded database I've seen casually mentioned as an alternative to SQL Server Compact Edition and SQLite would be so much more capable.

Considering the challenges I've already encountered with SQL Server Compact Edition on my current project, Firebird clearly deserves more of my attention. I'll have to follow up with another post after I've learned more.

April 15, 2010 9:49 PM

Post a Comment

Subscribe to: Post Comments (Atom)