Which Database Do You Prefer

[seanbee20]

He asked for a database that does not require installation of a database engine. More or less along the lines of an embedded solution. NexusDB can be embedded which would not require installation of a database backend or need for a client install.

I would assume that SQL Server would require such installation.

Ok I see what you are saying... I was just wondering if there was something more special about NexusDB in regards to .Net than the M$ database solutions.

[Blunty Killer]

Ok I see what you are saying... I was just wondering if there was something more special about NexusDB in regards to .Net than the M$ database solutions.

Naw, wouldn't think so. If Microsoft really was pushing .NET as the end all to a developer's nightmare they would be evil to include calls in the framework that only their database can take advantage of while crippling others.

Another thing to note, is that Nexus follows the SQL standard closely. I hear that SQL Server breaks a couple rules here and there.

[girldemsuga]

well, the NexusDB sound interesting, i will be checking it out but has anyone ever tried SQLite, I have not yet figured out how to connect to it with VB or a VB.net (those are the languages i program in).

[RobyG]

I use postgreSQL 8.x alot. In the past I have used Access, MySQL, Firebird, Advantage and couple others. I prefer postgres....I respect Oracle alot from what I have heard.

[girldemsuga]

Any reason in particular why you prefer postgreSQL and does it require the setup of a Database server to work (like MySQL and MS SQL).

[DigitHead]

VistaDB: Small, fast, versatile decent price

[Blunty Killer]

Any reason in particular why you prefer postgreSQL and does it require the setup of a Database server to work (like MySQL and MS SQL).

I work with PostgreSQL extensively and it's a workhorse of a database, truly. Yes you will need to install a service and also create a user account for that service, so if you are looking quick deployment not really for you.

[omik_1]

I prefer DBISAM drom elevatesoft.com

[digerati]

Are you saying that oracle somehow can have a database contained within a single file like access as i would not need to install the oracle server if i'm developing a simple application for a client?

No. You do need to install a database server as well as the client.
SQLite seems to be what you're looking for. It comes with C/C++ and TCL interfaces to easily connect and execute statements. sqlite3_open() sqlite3_exec() and sqlite3_close() would be the functions to pay attention to. I was able to download and connect and run a couple statements in minutes. Unfortunately I don't have a C/C++ compiler on my machine so I couldn't get to compile the sample code they had.

#include <stdio.h>
#include <sqlite3.h>

static int callback(void *NotUsed, int argc, char **argv, char **azColName){
  int i;
  for(i=0; i<argc; i++){
    printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
  }
  printf("\n");
  return 0;
}

int main(int argc, char **argv){
  sqlite3 *db;
  char *zErrMsg = 0;
  int rc;

  if( argc!=3 ){
    fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
    exit(1);
  }
  rc = sqlite3_open(argv[1], &db);
  if( rc ){
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    exit(1);
  }
  rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
  if( rc!=SQLITE_OK ){
    fprintf(stderr, "SQL error: %s\n", zErrMsg);
    sqlite3_free(zErrMsg);
  }
  sqlite3_close(db);
  return 0;
}

Read through the documentation for details.

[delly_jm]

SQL Server 2000 is my favourite