Link to home
Start Free TrialLog in
Avatar of prasiddutta
prasidduttaFlag for India

asked on

Which database is better for Delphi7?

Sir,
I want to build a  School Management System in delphi 7. Which database is better. Please tell me.

Prasid
ASKER CERTIFIED SOLUTION
Avatar of thiagoblimeira
thiagoblimeira
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@pcelba,
On the other hand, I would enthusiastically use Delphi for such an application.  It has all of the things you mention about Visual FoxPro as well as several other properties that make it my "weapon of choice" for such pplications.  Of course, I am also sure that VFP has other aspects that may make it your "weapon of choice."
However, the key point here is whether or not it is Uprasiddutta's "weapon of choice" (or, possibly, "weapon of necessity" ;-).
Delphi has a fairly large following outside of the US (and not that small of one inside the US ;-), so it is entirely possible that there is more support for the application if it is written in Delphi than if it is written in VFP.  
In any case, I would think that we should honor the initial problem statement given in the original post:
"I want to build a  School Management System in delphi 7."
Since you probably have Office - use Access as the back-end database.
Then in D7 use the ADO components.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of prasiddutta

ASKER

May be 3000 records present. And I also like VFP and access. Am I right?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oooo! Huge size. I'm tensed... What is the main problem if I use Access with help of ADO Connection?
In my opinion Access is not designed for large amount of data or for concurrent multiuser access.

In my opinion the best database for such application is either Firebird or PostgreSQL. Both are efficient, the have no significant limits, very easy administration and they are free.

In my projescts ususally use Firebird.
My drawback:
I don't know sql, oracle, firebird, interbase. You can provide me example for delphi.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
if you do not know SQL it will be difficult.
I suggest you use Access 2007.It has nice built in templates which
you can easily adjust for your needs (see the pic)
sys.png
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Geert, you always differ than others... I will try.
Geert,
Just out of curiosity, which version of Delphi is applicable to that project?
It work on delphi 7 version....! but not completely...
Did you try it on D6?
no no no
I did help out in it with D7.
What doesn't work ?
I didn't check what's in the zip ...
Lot of error. Plz run in your D7. I'm not expert thus I can not predict the error.
you don't need to predict
copy paste works from the messagebox which has focus

i allready stated it is the worst code i have ever seen
i think the newer version required the devexpress quantumgrid and treeview
Yes! This instruction help me little bit!