Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] compiling with VC++

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

Re: [sqlite] (newbie) pictures in tables, what's the best way ?

-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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] SQLite - how to protect the data

-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. >

[sqlite] FTS1 dump/restore needs column names

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

Re: [sqlite] compiling with VC++

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

Re: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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,

Re: [sqlite] Re: Re: how to get field names of empty tables ?

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

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

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

> 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:

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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:

Re: [sqlite] compiling with VC++

"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

RE: [sqlite] compiling with VC++

--- 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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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,

Re: [sqlite] compiling with VC++

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

Re: [sqlite] compiling with VC++

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

Re: [sqlite] SQLite - how to protect the data

* 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

RE: [sqlite] compiling with VC++

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:

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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. >

Re: [sqlite] SQLite - how to protect the data

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,

Re: [sqlite] compiling with VC++

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

Re: [sqlite] SQLite - how to protect the data

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

RE: [sqlite] compiling with VC++

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

Re: [sqlite] SQLite - how to protect the data

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]

Re: [sqlite] sqlite ebuild - my problem, i have half year ago, is still here.

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

Re: [sqlite] SQLite - how to protect the data

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

RE: [sqlite] compiling with VC++

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

Re: [sqlite] compiling with VC++

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

Re: [sqlite] SQLite - how to protect the data

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

Re: [sqlite] SQLite - how to protect the data

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:

[sqlite] Problem with crosscompiler and sqlite - was subject mismatch Re: [sqlite] sqlite ebuild - my problem, i have half year ago, is still here.

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. >

[sqlite] sqlite ebuild - my problem, i have half year ago, is still here.

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

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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:

RE: [sqlite] compiling with VC++

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

Re: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

> 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. *

Re: [sqlite] SQLite - how to protect the data

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.

RE: [sqlite] compiling with VC++

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

RE: [sqlite] compiling with VC++

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

Re: [sqlite] compiling with VC++

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

[sqlite] Re: SQLite - how to protect the data

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

RE: [sqlite] compiling with VC++

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:

Re: [sqlite] compiling with VC++

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 -

[sqlite] compiling with VC++

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

Re: [sqlite] SQLite - how to protect the data

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]