Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

May I know about one database which is portable and encryptable and open source?

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know it is very difficult to find. But I've found so many that don't
satisfy my requirements.
Thanks
Jack
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "portable"? Is it an embeddable database such as JavaDB?

Also, why do you want to encrypt the database? Who is the person you don't want to access the data?

1) The end user of your application? This will not work very well, as the encryption key needs to be compiled into your application somehow. Putting the key and the encrypted data into the same place is obviously a disaster.

2) Someone else? That would assume that your application doesn't store the key, but it is supplied by the user eg. upon startup. That might protect the data in case it is stolen, but I'd say that you might as well leave it to the user to encrypt his data if he wants to. There are already tools for encrypting any data, not just a database, that are stored on someone's hard disc.
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Portable, yes, I meant embedded.
I want it encrypted because there are several levels of users in
my system, without being the administrator,
I don't want them to be able to create new accounts
Currently I am using SQLite
I found some of the encryption tools
in the marketplace. But I am in doubt,
I have to whether keep a copy of the unencrypted database in hard disc
or in memory so that there may be, just in case, inconsistent
with the master database.

EDIT:
Which one is more suitable for CRM? HSQLDB or JavaDB?
Thanks
Jack
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Googling for portable java database with encryption gave me JavaDB End-to-End Security as the first link. At the first blush it seems it might be relevant to you.

I'd suggest using google to get some grip on the differences between the two databases you've mentioned (eg. javadb vs hsqldb).
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good, thanks
Jack
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic