SQLite with Delphi Prism

DuriPro
DuriPro used Ask the Experts™
on
I'm currently in the process of learning Delphi Prism, in order to write a multi-platform application. But I need simple database access and found SQLite as a serious option, since it is small and single-filed. But now, how do I use SQLite from a Delphi Prism application, where I'd like to stick to a write-once-compile-everywhere approach. And everywhere is Windows, Linux and Mac using the Mono-platform.

I'm open to other simple, file-based databases if that is easier to deal with.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chief Technology Officer
Most Valuable Expert 2011
Commented:
See if this helps since no one has yet presented other options: http://sqlite4delphi.sourceforge.net/ 
developmentguruPresident
Commented:
This link (page 23) shows an example of connecting to (and creating the DB file if needed) a sqlite database using Delphi Prism.

http://www.danysoft.com/free/delphiphone.pdf

You will need to test on each platform.  Do you have the hardware to do all that testing?  I suspect that the setup of .NET (or mono) drivers will need to be tuned for each environment.  The nice thing is that the code should run well in each environment, once you are past the setup of the environment.

Let me know if you need more.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial