Using SQLite + SQLCipher + Harbour (only)

Source code related resources

Moderator: Rathinagiri

Post Reply
User avatar
Barrimbhal
Posts: 13
Joined: Mon Aug 06, 2012 3:02 am
Location: Minas Gerais - Brazil
Contact:

Using SQLite + SQLCipher + Harbour (only)

Post by Barrimbhal » Sun Oct 14, 2012 6:52 pm

Dear friends, greetings!

I found the implementation of SQLite + SQLCipher simply phenomenal.
Do not believe that today has something better in terms of database in embedded system, than SQLite.
Congratulations to Rathinagiri, Sudip and all who contribute to this project!

I would be very happy by any example of functional code!
We need a lot of SQLCipher by issue of confidentiality of data.
Could someone please post an example of SQLite + SQLCipher using only the Harbour, with its LIBs settings in HBP?

Thanks in advanced! :^)

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Mon Oct 15, 2012 2:06 am

I think my library is pure Harbour only.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Barrimbhal
Posts: 13
Joined: Mon Aug 06, 2012 3:02 am
Location: Minas Gerais - Brazil
Contact:

Post by Barrimbhal » Mon Oct 15, 2012 3:14 am

Ok, ok! I do not think I expressed right, forgive me!
Could not configure in console mode (no GUI) using SQLite + SQLCipher...
Always worked with DBF and plan to migrate to SQLite, but without encryption, it would make sense.
Needed a simple example.

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Mon Oct 15, 2012 3:26 am

Hi,

Please tell me what type of example you want?

Just to access data? Or encryption?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Barrimbhal
Posts: 13
Joined: Mon Aug 06, 2012 3:02 am
Location: Minas Gerais - Brazil
Contact:

Post by Barrimbhal » Mon Oct 15, 2012 4:24 am

I am novice in SQL and Harbour, any help is greatly appreciated.
My intention is to transpose DBF tables that are permanently encrypted (can decrypt it...) to SQLite and use SQLCipher.
Considering the Contrib folder examples of Harbour (SQLite), which one would serve to demonstrate the use of SQLCipher and how to mount the file .HBP? Please.

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Mon Oct 15, 2012 9:25 am

For encryption, SQLCipher is the best option.

I will create a simple sample and give here.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Barrimbhal
Posts: 13
Joined: Mon Aug 06, 2012 3:02 am
Location: Minas Gerais - Brazil
Contact:

Post by Barrimbhal » Mon Oct 15, 2012 11:20 am

Please!!! Thank you!!! :D

Post Reply