Re: ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- From: Ivan Pastine <dontmail@xxxxxxxx>
- Date: Wed, 09 Aug 2006 01:15:10 +0100
Paul Dolen wrote:
So, you have some good reasons for using Nexus over
Firebird?
I haven't used either in earnest, but am evaluating both at the moment. I'm writing you to try to help, but mostly to clarify my own mind. So take what I say with a grain of salt.
Advantages of Nexus over Firebird: (in the order that they come to mind, certainly not the order of importance)
1. You control the server. You can use their server, or its really easy to do your own (or modify theirs, which is an almost trivially simple application -- basically just a few components on a Delphi form). So you can change things, add specialized data handling etc to the server. The server can also be inside your app (like the Firebird embedded version but without a dll).
2. Extensions (udf's) are done directly in Delphi. Can be done with Firebird, but I gather its easier and more powerful in Nexus. I haven't tried this, just trolled through newsgroups, but as you know everything on the internet is true.
3. The download footprint is smaller.
4. An empty database is much smaller. With large databases I don't know. I've heard it go both ways, depends on the data I suppose.
5. Since you have complete control over the server you don't have to make your users go through the Firebird installer for the server version (although I bet their are ways around this in Firebird). But also since you have control of the server and can make it your own app you can be sure that some other program won't screw it up. Your user won't install Firbird 3 alpha 1 and then complain when he loses all his data.
6. Nexus has a TTable component for direct access to a table which might be nice from time to time.
7. Rumor has it that Nexus tends to be faster. There is a free embedded version that you can use to see if this is true with your data (or indeed use for commercial programs). Both are plenty fast with my data.
8. Support is rumored to be great. Certainly the newsgroup is active, and people are very helpful even with pretty stupid questions.
9. .... there may be more, I'm hardly an expert. Any additions folks?
Advantages of Firebird over Nexus:
1. Single file database. Important for me, not important for lots of folks.
2. Really nice third party access components.
3. Generally a bit better 3rd party support. Nexus also has good third party support, but since Firebird is based on Interbase which has been around forever, I do think there is more out there for Firebird. I picked up the Firebird Book in my local bookstore, for example. However, the important thing is what exactly is on offer, and the newer sets of high-end stuff seems to either support both, or one or the other. But its not obvious which one does better among the newer stuff. Best think carefully about what you need and check out which has better support in those areas.
4. Free(ish). Life is much nicer if you get Database Workbench and maybe some commercial data access components. But its still comes in cheaper than the client-server version of Nexus. But not necessarily cheaper than the embedded version with source. The nexus ODBC costs extra however.
5. .... Other Firebird advantages? Any thoughts?
.
- Follow-Ups:
- References:
- ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- From: Eivind Bakkestuen
- Re: ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- From: Paul Dolen
- ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- Prev by Date: Re: MultiTier?
- Next by Date: Re: Looking for code to create Spectrum analyzer
- Previous by thread: Re: ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- Next by thread: Re: ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
- Index(es):
Relevant Pages
|
