Password Protect a SQLite DB. Is it possible?

Question

I have to face a new little project. It will have about 7 or 9 tables, the biggest of them will grow by a max rate of 1000 rows a month.

I thought about SQLite as my db... But i will need to protect the db in case anybody wants to change data from the db

My main question is:

Is it possible password protect a sqlite db as you would do on access?

What other RDBMS would you recommend for such a small solution?

[EDIT TO ADD] Thanks for the answers till now.

The development would be on C#, but i'm searching something free.

Answer 1

One option would be VistaDB. They allow databases (or even tables) to be password protected (and optionally encrypted).

Answer 2

You can encrypt your SQLite database with the SEE addon. This way you prevent unauthorized access/modification.

Quoting SQLite documentation:

The SQLite Encryption Extension (SEE) is an enhanced version of SQLite that encrypts database files using 128-bit or 256-Bit AES to help prevent unauthorized access or modification. The entire database file is encrypted so that to an outside observer, the database file appears to contain white noise. There is nothing that identifies the file as an SQLite database.

You can find more info about this addon in this link.

Answer 3

for your question about password protecting your sqlite db, i don't think it can be done.

you can encrypt it though, here's some information on that:

http://sqlcrypt.com/

it's $149 per platform.

Answer 4

You might want to check out SQLiteCrypt

Answer 5

Why do you need to encrypt the database? The user could easily disassemble your program and figure out the key. If you're encrypting it for network transfer, then consider using PGP instead of squeezing an encryption layer into a database layer.