[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Which Database for portable Application?

Posted on 2011-05-08
2
Medium Priority
?
352 Views
Last Modified: 2012-05-11
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
Comment
Question by:error77
  • 2
2 Comments
 
LVL 25

Accepted Solution

by:
epasquier earned 2000 total points
ID: 35716536
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
 
LVL 25

Expert Comment

by:epasquier
ID: 35716547
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month18 days, 6 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question