• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

Which Database for portable Application?

Hi all,

I am working on an applications which will require database connection and I was wondering...

Which is the best database to use on my delphi project ?

Requirements:
1.  I need to be able to add my whole project to a zip file, take it to another computer and be able to unzip it and run the application without having to download and install external libraries etc.
I don't mind having dll's in my project's folder but that's about it.
2. I need to be able to create tables and modified them easily.
3. There must be delphi component for it.

Thanks
0
error77
Asked:
error77
  • 2
1 Solution
 
Emmanuel PASQUIERFreelance Project ManagerCommented:
FireBird is an excellent choice, in your case the embedded version :

* it is free
* it only requires a set of dll, and your DB file to operate
* you can use any component set for InterBase DB (FireBird is an opensource branch of InterBase), like IBxxx component all included in Delphi, or ADO, or ODBC with InterBase connections, or if even specific thrid-party component sets for FireBird (you will gain just a bit of extra performance, and maybe some extended compatibility with advanced functionalities)
* It will be easy to make your application run with a real DB, multi-user and everything, simply by setting the FireBird server and copy the correct dll along your client application : no change at all in the executable, it will find itself that you want it to run no longer with the embedded version.

look there :
http://www.firebirdsql.org/index.php?op=files&id=engine_250

the embedded version (x86) is the 4th link. There is also the x64 just a bit bellow.
You can find other documentation in this official site, or simply ask Google for more
0
 
Emmanuel PASQUIERFreelance Project ManagerCommented:
I forgot to mention :
there are a few free solutions to help you create and manage your DB :

* SQL Manager for InterBase & Firebird (Free for the Light version, which is enough to start)
http://www.sqlmanager.net/fr/products/ibfb/manager

* FlameRobin : Open Source, Lightweight, simple to use. Not as complete nor pretty than SQLManager, but hey, Free and Unlimitted !
http://www.flamerobin.org/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now