Lion King
Lion King

Reputation: 33823

Is there a way to program an application that uses a database system and does not require install a database server on client machine

Notice: this question general, It does not matter what is the programming language. but my inquire about c++ Qt, c# languages.

I want programming an windows application that uses database system.
But I want choose a database system does not require install a database server on a client computer. Just I want the client install the application, then he can use the application after installation and does not require install a database server.

I don't know what is the database appropriate to me ?
mySql , msSql, sqlite, etc.

Upvotes: 0

Views: 105

Answers (2)

Nejat
Nejat

Reputation: 32685

SQLite is a nice fast database to use in standalone applications. There's dozens of GUI's around to create the schema you want and interfaces for pretty much any language you would want (C/C++/Java/Python/Perl/C#). It's also cross platform and is suitable for Windows, Linux, Mac, Android, iOS and many other operating systems.

Here are some advantages for SQLite:

• Speed :

  • In many cases at least 2-3 times faster than MySQL/PostgreSQL.
  • No socket and/or TCP/IP overhead.

• Functionality :

  • Sub-selects, Triggers, Transactions, Views.

  • Up to 2TB of data storage.

  • Small memory footprint.

  • Self-contained: no external dependencies.

  • Atomic commit and rollback protect data integrity.

  • Easily movable database.

• Security :

  • Each user has their own completely independent database(s).

Upvotes: 2

Aaron
Aaron

Reputation: 1411

I think you are looking for a local database. In the Windows world you would usually use .sdf file. This is a good tutorial to get you started. Local Database Tutorial

Also you can see how to deploy it here:

http://msdn.microsoft.com/en-us/library/aa983326(v=vs.90).aspx

Upvotes: 1

Related Questions