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 »

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: 5317
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 196 times
Been thanked: 208 times
Contact:

Post by Rathinagiri »

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 »

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: 5317
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 196 times
Been thanked: 208 times
Contact:

Post by Rathinagiri »

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 »

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: 5317
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 196 times
Been thanked: 208 times
Contact:

Post by Rathinagiri »

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 »

Please!!! Thank you!!! :D

Post Reply