Database options for Delphi hobbyist ?
Posted on 2014-03-17
Years ago, I used to develop freeware programs using Delphi 5 for hobby / gaming use - little assorted database programs that stored assorted information about whatever hobby I had going at the time.
I'd write the program using Delphi 5 Professional and stored the data in Paradox tables. When someone else wanted the program, they could install the BDE and download the program and data files and be away.
I bought a copy of Delphi XE3 a little while back and have thought about delving into this again - updating some of my old programs just for the sake of learning with the updated tools.
I want to be able to use standard SQL to query the database.
From the point of view of ease of redistribution (I know a few people who would use updated versions of the programs if I ever got around to updating them), what's the easiest DB software to deal with ? If someone wanted to play with the updated program, what's the easiest solution for someone else to install so they could use the program ?
The version of XE3 I have supports ODBC (and I think it even has support for some other databases, I think the version of XE3 I have is Enterprise or Ultimate, I'd have to check what it was I bought).
Have not toyed with Dephi much in years (still have Delphi 5 installed and when I need a quick programmatic solution for a problem I still use it) but figured I should use the newer version I went to all the trouble of buying rather than sticking with the old one :)
Thanks in advance for sharing your experiences.