Page 9 of 11
Re: SQLCipher ported to Harbour (Windows)
Posted: Tue Apr 01, 2014 3:01 pm
by Hazael
Rathinagiri wrote:When I tried to compile an existing project with your library and latest harbour nightly build, I got this error.
Code: Select all
C:/hmg.3.2a/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2738): undefined reference to `sqlite3_enable_load_extension'
However, if I replace with my library, it works ok. I don't understand why.
Well, I searched a bit and tried to add
--enable-load-extension to ./configure
Seems fine. Now please test again:
http://dropcanvas.com/0p2bj" onclick="window.open(this.href);return false;
Re: SQLCipher ported to Harbour (Windows)
Posted: Tue Apr 01, 2014 4:30 pm
by Rathinagiri
Still I am having the same error.
Now the size of the lib is much less.
Re: SQLCipher ported to Harbour (Windows)
Posted: Tue Apr 01, 2014 5:56 pm
by Hazael
Rathinagiri wrote:Still I am having the same error.
Now the size of the lib is much less.
Sorry, just realized that the libsqlcipher.a I sent to you is the one automatically generated by the amalgmation process (MSYS).
The correct is to build it from Harbour, isn't it?
So I think I am obviously missing the basics here.
Now that I have sqlite3.c and sqlite3.h from the MSYS process what should I do next? I think I am kind of lost at this point.
Please explain clearly (even the obvious) because I realize it's not obvious to me...
Thanks for your help.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Apr 02, 2014 1:52 am
by Rathinagiri
Once you get this sqlite3.c and sqlite3.h you have to create the sqlcipher.hbp, sqlcipher.hbc and buildlib.bat as mentioned in the first post of this topic and build the library.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Apr 16, 2014 10:01 am
by Hazael
Hello Rathinagiri,
You are right. I will do it.
Sorry for the delay in answering. I had to go for a trip on an area close to the montains and there is no internet there.
As soon as I can connect again I will let you know if it worked or not.
Thanks for your help.
Re: SQLCipher ported to Harbour (Windows)
Posted: Tue Aug 12, 2014 11:55 am
by Rathinagiri
SQLCipher new version is ready for SQLite version 3.8.4.3
I had not yet tested it. Please do so if you are interested. I will also let you know about the results soon.
Re: SQLCipher ported to Harbour (Windows)
Posted: Tue Aug 12, 2014 12:30 pm
by Hazael
Thank you
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Aug 13, 2014 3:10 am
by Rathinagiri
I have verified and it works fine.
From SQLite 3.8.3 'WITH' clause is implemented. More details
here.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Aug 13, 2014 7:32 am
by Hazael
WITH looks pretty complex to me... but it's interesting.
By the way which Harbour and MingW version did you use to build the lib?
I would suggest to add this information for any lib you create:
HMG xx.xx
Harbour xx.xx
MingW xx.xx
SQLite xx.xx
SQLCipher xx.xx
As you may know even SQLCipher is not a 100% secure way to keep your data since one can overcome the encryption barrier. The only way is to protect the database from phisical access but it certainly helps a lot and may be suitable for the great majority of the situations.
Thanks again for providing such nice lib.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Aug 13, 2014 8:51 am
by Rathinagiri
I will list the versions soon.
Regarding the security I don't understand how one can overcome the encryption barrier if they don't know the password.
The only way the security being breached is to capture the main memory dump since the decrypted data is placed only at main memory.