Solved

Secure Embedded Database

Posted on 2011-02-15
2
634 Views
Last Modified: 2012-05-11
I'm doing some retail software that I plan to distribute, and security of the data is a big issue. Not so much that the data is sensitive, but that I need to secure it from users being able to access it outside of the application. Reason being is that it ties back into my company that I would offer an additional data access option (Web), but if they have free access to it, then the push is pointless.

I can't require an internet connection, so SQL Server and MySQL are out. I know I can embed MySQL, but I just don't want the hassle of handling that in my JAVA app.

SQLite seems to lack any real security, but I have read that you can use SQLCipher to encrypt the database and decrypt at need for the data. How effective has this been for others? Is this a reasonable option?

What about HSQLDB? That seems to have a bit more options that I'd like to take advantage of, but I can't find much information on the web regarding security of the data.

JavaDB promotes security, but I haven't had a chance to play with it yet. Do you have any experience with it? Is it capable of what I'm after? Or maybe other suggestions?

Any and all suggestions would be greatly appreciated. In case it matters, this will be a swing application.
0
Comment
Question by:ALaRiva
2 Comments
 
LVL 6

Accepted Solution

by:
dr_linux earned 500 total points
ID: 34898682
If it's not tons and tons of data you simply read and write the data in files and encrypt and decrypt the data using something like
http://www.experts-exchange.com/Programming/Languages/Java/Q_23044531.html

Db4o is another option for a Java embedded database.  Works really well with Java.  However I used it back when it was free and I really didn't use any security at the time.  It has come a long way since then (and it is now commercial) http://www.db4o.com/  
0
 
LVL 10

Author Closing Comment

by:ALaRiva
ID: 35993087
Not exactly what I was looking for, and this is far from resolved, but the provided information helped open up a few ideas and set me ahead a bit further in the project, so I feel points are appropriate.

Thank You.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
topping3 challenge 14 50
Checkbox and ListView in Android Layout 4 39
maven project error 5 21
Update in Sql 7 0
Creating and Managing Databases with phpMyAdmin in cPanel.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now