SQLCipher ported to Harbour (Windows)

Moderator: Rathinagiri

User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post by Hazael »

Hello Rathinagiri,

I was looking the code of your usefull utility sql1.prg and I found something I didn't understand:
It is on the function sql():

Code: Select all

ASize( tablearr, 0 )      
Shouldn't it be:

Code: Select all

ASize( tablearr, len(table)-1 )
?
Just trying to understand it...
Thanks for any help.
Harbour | GTWVT | MingW | Visual Studio Code
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by Rathinagiri »

Hi Qatan,

It is just an initialization of the variable tablearr. Since it is a local variable, I think that line is not at all required.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post by Hazael »

Hello Rathinagiri,

Right. I thought it was the case but maybe I didn't understand the logic.
BTW do you have the last version of sql1.prg for sqlite only? (or could you point where to download it?)
Thanks for your help
Harbour | GTWVT | MingW | Visual Studio Code
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by Rathinagiri »

I will upload here.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by Rathinagiri »

This is HMGSQL library source code for bridging SQLite/MySQL/PostgreSQL.
Attachments
HMGSQL.zip
(11.93 KiB) Downloaded 365 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post by Hazael »

Now I noticed it was included with HMG 3.0.44.

BTW I found this info that explains TCL is not needed to build SQLite (I do know if it would work for SQLCipher): http://www.sqlite.org/cvstrac/wiki?p=Bu ... WithoutTcl

I think it is worth of a try... what do you think?
If it works it would reduce the need for an extra tool (TCL) so it would make the whole process even simpler.

And this one: http://techtonik.rainforce.org/2005/12/ ... ndows.html seems very good too.

Thanks for all your help.
Harbour | GTWVT | MingW | Visual Studio Code
User avatar
mol
Posts: 3774
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by mol »

Hi Rathi!
Can you place a little working sample with SQLCipher?
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by Rathinagiri »

Oh yes. I will do it tomorrow.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by Rathinagiri »

What kind of sample you want?

Exclusive for SQLite handling or SQLcipher handling?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply