DBMS for basic application data storage

August 19, 2006

An application I am making requires a basic DBMS and it would be ideal if I could have this as a standalone file without having to install mySQL or another service based DBMS on a users computer when it is not necessary. Microsoft Access files definately do the job but I’d like an alternative. All the file needs to do is store the SQL data and provide a DBMS engine. I don’t need any of the visual functions (form creation, etc).

I’ll proberly end up going with OO.o Base 2 due to the simplicity. The other alternatives include: looking for or implementing an XML based storage solution, using an object database to directly save objects, using an API based database engine or as mentioned installing mySQL on the client.

For quick and easy implementation it is much easier to use a datafile, ODBC, and SQL. I’ll install OO.o Base 2 and see what I come up with, still have assignments that I need to get done at the moment though!

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: