Hi Marek,
> Thanks Ulrich, but I think that goes beyond the scope of my knowledge
> and tools I have available to me.
>
> I wish somebody (who has C++ knowledge) has done it already and
> released version of SQLite with encrypt and decrypt functionality.
Well, there is a prebuilt DLL with encryp
On 2/25/07, mxs <[EMAIL PROTECTED]> wrote:
I realize that, but this is about making it difficult for the average Joe not
to stop professional hackers who I assume can steal anything they want.
Look for SQLITE_FILE_HEADER in the code (it's in the btree.c file). By
redefining it, only your applic
RB Smissaert wrote:
Due to me not knowing C I hadn't realized that this structure had to be left
intact.
It's not a C thing as such, it's the way Dr Hipp has designed it. It's
an interface - the third entry in the list always does the same thing
but the function that actually runs to do tha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
mxs wrote:
> I wish somebody (who has C++ knowledge) has done it already and released
> version of SQLite with encrypt and decrypt functionality.
DRH already did! You get a perpetual license. It is also well
integrated into the SQLite code, and can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stef Mientki wrote:
> Uptill now the dbase is small so no performance problems yet.
Wait until you have performance problems and then solve them :-) It is
almost always the case that performance issues don't crop up where you
think they will.
> I ca
I realize that, but this is about making it difficult for the average Joe not
to stop professional hackers who I assume can steal anything they want.
Web based approach will not happen in my case and I am not sure you could
guarantee its safety there either. It might be safer with close monitorin
Well, it might sound contradictory, but it's not. I don't know how well the
product will sell and I am not prepare to drop down my own cash to do it.
Not at least at the begining.
Regards
Marek
Roger Binns wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> mxs wrote:
>> One of t
Thanks Ulrich, but I think that goes beyond the scope of my knowledge and
tools I have available to me.
I wish somebody (who has C++ knowledge) has done it already and released
version of SQLite with encrypt and decrypt functionality. I cannot believe
that there is not more need for it between SQ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
mxs wrote:
> One of the
> application I work on contains data which have very high value.
[...]
> I found a link talking about encryption, but this is not exactly affordable
> for my type of project.
> http://www.hwaci.com/sw/sqlite/prosupport.html#cr
I think it compiles much better now when I do in loadext.c :
const sqlite3_api_routines sqlite3_apis = {
sqlite3_aggregate_context,
sqlite3_aggregate_count,
sqlite3_bind_blob,
sqlite3_bind_double,
sqlite3_bind_int,
sqlite3_bind_int64,
sqlite3_bind_null,
sqlite3_bind_parameter_coun
It seems that when doing a dump/restore on databases with FTS1
enabled, the INSERT commands in the dump need column names. That is,
if the dump looks like this:
INSERT INTO "foo" VALUES (x,y,z)
You get the error
SQL error: table foo has 4 columns but 3 values were supplied
Apparently if t
RB Smissaert wrote:
Will give that a try and see if it gives any less warnings.
OK, but as Dennis suggested and Dr Hipp has confirmed this isn't the way
to go. I was assuming the VB thing was a bit of a hack and didn't really
read enough of the C code.
Martin
--
RB Smissaert wrote:
How would I do this:
compile with -DSQLITE_OMIT_LOAD_EXTENSION=1 to leave it out.
Remember that link tab I said about earlier?
There's a C/C++ tab next to it with a Preprocessor definitions edit
box. I think what you want is to put ",SQLITE_OMIT_LOAD_EXTENSION=1" at
the
OK, when I do instead of commenting those lines out:
0, //sqlite3_last_insert_rowid,
Etc. I get less warnings. Got 143 now instead 265 and no more
Warnings of the type C4028 and nil anymore in the .c file loadext.c
So, that looks much better.
Is it OK though to do this:
0, //sqlite3_libvers
Scott Hess wrote:
I think only the dot commands are special (.help, etc). Everything
else is fair game. Best reference for what you can feed a prepare or
exec is http://www.sqlite.org/lang.html .
Scott,
thanks for this valuable information.
Now how beautiful it would be if it was all in 1 pd
Sure, but it seems I messed up the source code, so maybe VC6++ is not to
blame. Not sure now how to correct it though.
RBS
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 20:37
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] compiling with VC++
--
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Could try with MinGW and MSYS and it may give less warnings, but would it
> produce a dll that is any better? If possible I want to avoid installing
> more software when I already have VC6++.
It's completely up to you. How much time do you want to spen
Ok, thanks. I am not a C coder and was following some (faulty?)
instructions.
How would I do this:
compile with -DSQLITE_OMIT_LOAD_EXTENSION=1 to leave it out.
I mean where do I put it?
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 20:
> You're confusing me with someone else.
No, I know it wasn't you.
Could try with MinGW and MSYS and it may give less warnings, but would it
produce a dll that is any better? If possible I want to avoid installing
more software when I already have VC6++.
RBS
-Original Message-
From: Jo
Will give that a try and see if it gives any less warnings.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 19:21
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Did you make the alterations to mak
Thanks, that sounds it might be something.
How exactly do I do this:
Instead you should disable compiling the loadable module extension by
defining SQLITE_OMIT_LOAD_EXTENSION.
RBS
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 19:24
To: sqlite-use
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> All C4028 warnings originate from this code block:
>
> const sqlite3_api_routines sqlite3_apis = {
[...]
> sqlite3_busy_timeout,
> //sqlite3_changes,
> //sqlite3_close,
> sqlite3_collation_needed,
> sqlite3_collation_needed16,
>
> Not sure it
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Downloaded it from the one you pointed to me:
You're confusing me with someone else.
Here's a way to build sqlite3.dll without Microsoft tools using the
official sources:
Grab and install MinGW and MSYS (google for it),
download http://sqlite.org/sq
Hi Marek,
> I'll be honest with you I had to google around to find out what is
> wxWidgets (obviously I've seen it before, but never dipped in). Pls
> understand I've been messing around for years with VB (not even the
> .NET version) and it served me quite well. But I decided to move on
> to some
RB Smissaert wrote:
Microsoft Visual C++ 6 Enterprise edition.
Hmm. I'm using VC6++ Pro. I wonder if it's safe to assume the compilers
are the same and the difference is that I don't have the Enterprisey
middleware gubbins.
I think it is the latest before .net came in.
Dunno. I kind of l
The suggested changes the web site recommends are incorrect:
loadext.c
Comment out the following lines is loadext.c by adding 2 back slashes ("//")
to the start of the
line. This prevents errors due to our changes.
sqlite3_changes,
sqlite3_close,
sqlite3_last_insert_rowid,
sqlite3_libver
RB Smissaert wrote:
Thanks, that is very helpful and reassuring as well.
Will see if I can figure out then what is causing this one:
warning C4028, as you say that could be a typo.
I've just built 3.3.12 source with VC6 and didn't see that error. I
changed the warning level to 4 and got 500 wa
RB Smissaert wrote:
Did you make the alterations to make the dll VB compatible?
I don't think Dennis was building the VB version. The lines that Todd
says you have to comment out - did you comment them out or replace them
with a 0?
I haven't analysed the code fully but I'm a bit suspicious
* mxs:
> If anybody knows hot to ensure that the data is not readable without the
> front end I would appreciate it.
You need to turn your application into some kind of web-based service
which is actively monitored for misuse.
Anybody who's got a copy of the application can reverse-engineer it
Downloaded it from the one you pointed to me:
and a zip file - sqlite-source-3_3_13.zip - containing preprocessed source
for Windows users at:
http://www.sqlite.org/download.html
Where else could I get it from?
RBS
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: 24
Microsoft Visual C++ 6 Enterprise edition.
I think it is the latest before .net came in.
I am compiling the latest 3.3.13 source as from the URL you mentioned to me.
Keep in mind I altered the source to make it VB compatible as in this URL:
http://www.tannertech.net/sqlite3vb/index.htm
RBS
---
The function signatures at the lines in question look wrong to me.
Do you have the correct version of sqlite3ext.h?
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Here examples of all 3, all from the same source file and the same code
> block:
>
> C:\SQLite\SourceWin\loadext.c(138) : warning C4047
Did you make the alterations to make the dll VB compatible?
RBS
-Original Message-
From: Dennis Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 18:39
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Thanks, will have a look at that.
>
All C4028 warnings originate from this code block:
const sqlite3_api_routines sqlite3_apis = {
sqlite3_aggregate_context,
sqlite3_aggregate_count,
sqlite3_bind_blob,
sqlite3_bind_double,
sqlite3_bind_int,
sqlite3_bind_int64,
sqlite3_bind_null,
sqlite3_bind_parameter_count,
sqlite
On Sat, 24 Feb 2007, Martin Jenkins wrote:
mxs wrote:
I decided I'd like to try Python and SQLite
Check out wxPython too.
Python->wxPython->pysqlite2->sqlite3
Works for me.
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, In
RB Smissaert wrote:
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
I use VC 6.0 and it compiles just fine. I did not follow the
instructions on the web site. I didn't even read them. I just put all
of the C files into a single director
Adriano,
this one looks good and the price is not out of the world although not cheap
either.
So this is basically a modified sqlite database which has an additional
function .encrypt and .decrypt. I haven't used many open source products
before so I am not sure how it works as far taking basica
Thanks, that is very helpful and reassuring as well.
Will see if I can figure out then what is causing this one:
warning C4028, as you say that could be a typo.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 18:11
To: sqlite-users@sqlite.org
mxs wrote:
I had to google around to find out what is wxWidgets
...
I decided I'd like to try Python and SQLite
Check out wxPython too.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
Jakub Ladman wrote:
Hi Friends
Please help me
I need crosscompile sqlite for my sh4 cpu based linux system, but configure
script (any version of sqlite i have tryed, even the actual one from sqlite
homepage) fails if crosscompilation is selected.
Crosscompiler works good in other cases.
Thank
Hi Olaf,
so I took a quick look and it looks interesting, certainly very affordable.
One caveat could be that it doesn't seem to work under OS X which will be
important to me. Also all I coud find was how to encrypt stuff through their
GUI, but nothing about available API. When I distribute the a
Here examples of all 3, all from the same source file and the same code
block:
C:\SQLite\SourceWin\loadext.c(138) : warning C4047: 'initializing' : 'int
(__cdecl *)(struct sqlite3_stmt *,int )' differs in levels of indirection
from 'const char *(__cdecl *)(struct sqlite3_stmt *,int )'
const sqlit
RB Smissaert wrote:
When compiling this source code I get 265 warning, which doesn't really
worry me that much as it all seems to be working fine, but in general what
kind of warning should be taken seriously?
This has come up the list before. Dr Hipp assigns a lot more weight to
his tests pas
Hi Ulrich,
I'll be honest with you I had to google around to find out what is wxWidgets
(obviously I've seen it before, but never dipped in). Pls understand I've
been messing around for years with VB (not even the .NET version) and it
served me quite well. But I decided to move on to something ra
Hi John,
thanks for the suggestion, but that is rather more than I can swallow right
now. I will have to keep looking for more complete solution which I can just
benefit from.
Regards
Marek
--
View this message in context:
http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html
Dne sobota 24 Ășnor 2007 18:33 Jakub Ladman napsal(a):
> Hi Friends
> Please help me
> I need crosscompile sqlite for my sh4 cpu based linux system, but configure
> script (any version of sqlite i have tryed, even the actual one from sqlite
> homepage) fails if crosscompilation is selected.
> Crossc
Hi Friends
Please help me
I need crosscompile sqlite for my sh4 cpu based linux system, but configure
script (any version of sqlite i have tryed, even the actual one from sqlite
homepage) fails if crosscompilation is selected.
Crosscompiler works good in other cases.
Thank you very much.
Jakub L
They're probably harmless.
Even so, can you post the file name/line of one example of each of the
following 3 warnings as they seem odd:
warning C4047: 'initializing' : '__int64 (__cdecl *)(struct Mem *)' differs
in levels of indirection from 'char *(__cdecl *)(const char *,char *)'
warning C41
When compiling this source code I get 265 warning, which doesn't really
worry me that much as it all seems to be working fine, but in general what
kind of warning should be taken seriously?
I only have 8 different types of warnings:
warning C4018: '!=' : signed/unsigned mismatch
warning C4028: fo
Thanks, that is it, nice and simple.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 15:40
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
> Now what do I do make it compile a dll called SQLite3VB.dl
RB Smissaert wrote:
Now what do I do make it compile a dll called SQLite3VB.dll?
I think it defaults to the project name, but have a look at the Link tab
in the Project|Settings dialog (Alt-F7) - there's an edit box titled
"Output file name" which might do what you want.
Martin
--
Just one simple question:
I have a VC6++ project now that compiles a dll called SQLiteVB.dll
Now what do I do make it compile a dll called SQLite3VB.dll?
I can see no simple configuration setting for this. I could of course start
a new project, but that seems silly.
Thanks for any advice.
RBS
--
> which I will try now
And it works fine.
So the instructions at:
http://www.tannertech.net/sqlite3vb/index.htm
are fine to compile with VC6++ if you pick the right source files:
http://www.sqlite.org/download.html
and just ignore this bit:
We need to set our Module Definition File.
* Righ
You could use encryption like DES etc in your application. Since sqlite
is open source you could build encryption into the DB. Since an Sqlite
database is one file you can encrypt that file in the file system.
If those are too difficult, make a deal with Dr Hipp for his encrypted
Sqlite.
m
Think I got this fixed now.
It simply was something I had overlooked to change:
//const char *sqlite3_libversion(void);
BSTR __stdcall sqlite3_libversion(void);
Lots of warnings (265) but no errors and a dll is produced, which I will try
now.
RBS
-Original Message-
From: RB Smissaert [m
OK, thanks a lot.
I think I have made a lot of progress, probably because of the different
source files you pointed me to.
I get one error though and that has to do with this bit of code:
/*
** The version of the library
*/
const char sqlite3_version[] = SQLITE_VERSION;
BSTR __stdcall sqlite3_li
RB Smissaert wrote:
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
I'm pretty sure I've compiled it with VC6++. I've been compiling on
Debian and Solaris machines recently and have sort of lost track of
building stuff on Windows. I tried upgr
Adriano schrieb:
> I'm in the same boat too.
> I've just found http://www.sqlcrypt.com/
> not tryed yet
>
> i need something that can works either on pc or on windoes mobile
> devices
Since I was in need of encrypting my SQLite database, too, and could not
afford a commercial solution I created
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 24 February 2007 12:02
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] compiling with VC++
RB Smissaert wrote:
RB Smissaert wrote:
Could anybody pass me step by step instructions to compile the source with
MS VC++ ? I don't code or compile in C at all and only code in VB/VBA.
There a some instructions at:
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
and a zip file - sqlite-source-3_3_13.zip - co
Could anybody pass me step by step instructions to compile the source with
MS VC++ ? I don't code or compile in C at all and only code in VB/VBA.
I am following the tutorial by Todd Tanner:
http://www.tannertech.net/sqlite3vb/index.htm
But this is with Visual Studio Net and I am running in some p
I'm in the same boat too.
I've just found http://www.sqlcrypt.com/
not tryed yet
i need something that can works either on pc or on windoes mobile devices
thanks
Adriano
-
To unsubscribe, send email to [EMAIL PROTECTED]
62 matches
Mail list logo