Re: Accuracer Database

> I think what is more relevant however is whether the results are correct.
> I have not seen that disputed anywhere. Have you?

well ok, I'll dispute the relevance of the results.

For a start, take the first example where NexusDB 'failed':

"SELECT First_Name, Last_Name FROM coders ORDER BY Salary"

Does standard SQL allow you to order by a field not in the result set? I
don't know, I don't think so, but it appears NexusDb wasn't designed to work
that way. Is this a bad thing? Probably not. Perhaps it's more efficient to
only order by the fields in the result set. I don't know.

In any case, NexusDb have made it a priority to work towards extensive
compliance with standard SQL (I forget which particular standard) in version
2.

Secondly, ALL the referenced document assesses is whether each DB supports a
particular chosen set of SQL commands. The list is highly selctive, eg it
does not include stored procedures (which NexusDB 2 will support). It tells
you nothing about the database architecture, the performance, the ease of
use, the level of support from the vendor, the value for money, the
stability and reliability of the product, the tools for adminstrating the
database, and a variety of other factors of considerable import in selecting
a database vendor.

Now, I put it to you that if you were a database vendor, you could very
easily pick a set of SQL commands that your product passes and others fail,
simply because they did not implement the same SQL as you - you added
proprietary extensions, they added different ones; you did not implement
some of the SQL standard, they did not implement other parts etc.

FWIW, I think this document by itself presents a poor basis for making a
decision. My experience is that NexusDB 1 has provided an adequate SQL
command set for my needs (although I would have liked a mechanism to
auto-generate DDL commands from the tables - perhaps this is in V2?)

HTH

Lauchlan M



.

Relevant Pages

  • Re: Adding Rows to Data-Bound DataGridView
    ... "Fill,GetData" SQL commands), I created an Insert and an Update SQL command. ... If you use the DataAdapter or generated TableAdapter Update method, ... Hitchhiker’s Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • ANN: NexusDB2 database update; C++Builder 2007 support added
    ... A maintenance release of NexusDB v2 is about to be released. ... Some minor SQL ... NexusDB v2 is a royalty-free Client/Server and Embedded database system with ... features that rival other heavily licensed products. ...
    (borland.public.delphi.thirdpartytools.general)
  • ANN: NexusDB 50% discount offer - only 1 week left
    ... This is a reminder that our biggest ever discount offer is closing in just one ... a huge 50% discount on ALL our products and support contracts. ... With NexusDB v2, you ... SQL stored procedures/functions ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How I can sysnchronize changes in DataTable with my Database?
    ... Normaly we a not able to made changes when is no connection. ... I like SQL but I would like to learn some other approach to change data. ... >> What is the purpose of this apporach if we use plain SQL commands? ... > the database within a single method call. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How do I issue SQL to a Access database from command line
    ... you can query the MSysObjects table. ... will give you all of the tables in the database. ... > window like SQLPLUS or ISQL/W which will enable me to run SQL commands ...
    (microsoft.public.access.externaldata)