yi02
asked on
Is there generic database engine or file type (binary etc) to hold data in tabular format (e.g. microsoft Access file in window) that can implement database capacity in a platform independent way?
Dear all:
Is there generic database engine or file type (binary file etc) to hold data in tabular format (such as microsoft Access file in window) that can implement database capacity in a platform independent way (Window, Mac, Unix/Linux etc)? the "database capacity' means between these files or within the file, I can do database query or join tables etc. In other words, I am looking for generic method or file that can allow my java program to have database capacity (not neccessary to be complex capacity but very basic database capacity e.g. simple query or join operation etc) but DO NOT have to install any full database engine such as microsoft access, mysql or oracle etc. Anybody has an idea how to do that?
Thanks a lot
yi02
Is there generic database engine or file type (binary file etc) to hold data in tabular format (such as microsoft Access file in window) that can implement database capacity in a platform independent way (Window, Mac, Unix/Linux etc)? the "database capacity' means between these files or within the file, I can do database query or join tables etc. In other words, I am looking for generic method or file that can allow my java program to have database capacity (not neccessary to be complex capacity but very basic database capacity e.g. simple query or join operation etc) but DO NOT have to install any full database engine such as microsoft access, mysql or oracle etc. Anybody has an idea how to do that?
Thanks a lot
yi02
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
bloodredsun
or HyperSonic or Sqlite as other embedded DB options
Hypersonic is quite cool actually :-) I had a go the other week, and was suprised ;-)
ASKER
Dear TimYates and others:
regarding your comments:
Why not just include MySQL or Postgres? THey are both free..
Because I want my application work through java web start and do not want to bother users to install MYSQL or postgres even they are free. My applciation did use remote centralized database in our server (this is going to be a 3-tier archtecture with user front end, java servlet and server side database. I wish the front end can has some database capacity in user's local machine and do not bother to access the remote database all the time. So I am looking for some light database capacity which can come along with my program to the user's local machine with minimal installation requirement. That is the point I am looking for such things if existing.
Any more suggestions, thanks a lot.
yi02
regarding your comments:
Why not just include MySQL or Postgres? THey are both free..
Because I want my application work through java web start and do not want to bother users to install MYSQL or postgres even they are free. My applciation did use remote centralized database in our server (this is going to be a 3-tier archtecture with user front end, java servlet and server side database. I wish the front end can has some database capacity in user's local machine and do not bother to access the remote database all the time. So I am looking for some light database capacity which can come along with my program to the user's local machine with minimal installation requirement. That is the point I am looking for such things if existing.
Any more suggestions, thanks a lot.
yi02
yi02,
that;'s why i recommend to try my link as those are java based embeded database engines
Cheers!
that;'s why i recommend to try my link as those are java based embeded database engines
Cheers!