OK, I understand better now.
This though doesn't seem quite right to me:
0, //sqlite3_libversion,
It looks sqlite3_libversion should be a string. Would it matter that I make
it 0, rather than say ""? If it should be an empty string then how would I
do that in C?
RBS
-Original Message
Hi,
I want to know how many time is spent when create a sqlite connection. Is it
effeciency? My application creates a connection and close it when access DB
everytime, is it OK?
--
powered by python
RB Smissaert wrote:
OK, I understand better now. This though doesn't seem quite right to
me:
0, //sqlite3_libversion,
It looks sqlite3_libversion should be a string.
No, this is a list of function pointers. C has no notion of the *name*
of the function, only its address. Functions are called
Alex Cheng wrote:
Hi,
I want to know how many time is spent when create a sqlite connection.
> Is it effeciency? My application creates a connection and close it
> when access DB everytime, is it OK?
Going by your sig, here are the times for Python 2.5 running under XP
SP2 on a 1.6GHZ dua
Is there other mailing list, primarily targeted for developers of sqlite?
I think my question about crosscompilation matches no person, which is able to
check sqlite's configure script for error in crosscompilation setup.
Thank you
Jakub Ladman
BTW. Sorry if i am impatient.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jakub Ladman wrote:
> Is there other mailing list, primarily targeted for developers of sqlite?
No.
> I think my question about crosscompilation matches no person, which is able
> to
> check sqlite's configure script for error in crosscompilation s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ulrich Telle wrote:
> I have no proof how secure my solution is but the encryption key is generated
> in much the same way as it is for Adobe PDF. So I guess what's good enough
> for PDF should be good enough for SQLite. But I won't give you a guaran
Roger Binns wrote:
-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 whe
Dne neděle 25 únor 2007 11:36 Roger Binns napsal(a):
> Jakub Ladman wrote:
> > Is there other mailing list, primarily targeted for developers of sqlite?
>
> No.
>
> > I think my question about crosscompilation matches no person, which is
> > able to check sqlite's configure script for error in cros
Jakub Ladman wrote:
Is there other mailing list, primarily targeted for developers of sqlite?
SQLite's primary developer and at least one of the wrapper developers
are active on this list, so here is as good as you'll get.
I think my question about crosscompilation matches no person, which i
> No, this is a list of function pointers
Ah, I see now. This all a bit alien for a simple VBA coder like me.
Thanks for clearing that up and I suppose I got it right now then.
RBS
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 25 February 2007 09:46
To: sqlite
Martin Jenkins <[EMAIL PROTECTED]> wrote:
>
> As I said the yesterday, the autoconf stuff is unmaintained and slightly
> broken. Dr Hipp doesn't use it:
>
It is true that I do not use autoconf much. But I do use it now
and then. The main problem is that autoconf is broken on my
SuSE 10.1 inst
Hi Roger,
> The problem isn't so much how you generate keys, but how you use them.
> Google shows over a million hits for 'pdf encryption crack'.
You're certainly right. But there is a difference between the PDF encryption
and the SQLite encryption I implemented.
PDF encryption is designed in s
Came across a situation where it was impossible to delete or rename a SQLite
db file even after the application (Excel) that had locked the database was
closed. It wasn't me, so I don't have very exact information, but there was
a statement to create a table and to insert data. For some reason this
Dne neděle 25 únor 2007 11:50 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > Is there other mailing list, primarily targeted for developers of sqlite?
>
> SQLite's primary developer and at least one of the wrapper developers
> are active on this list, so here is as good as you'll get.
>
> > I
Hello.
At 13:37 2/25/2007 +, you wrote:
Came across a situation where it was impossible to delete or rename a SQLite
db file even after the application (Excel) that had locked the database was
closed. It wasn't me, so I don't have very exact information, but there was
a statement to create a
Thanks Ulrich.
Regards
Marek
Ulrich Telle wrote:
>
> 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
Thanks; that must be a possibility.
Will pass it on in case it happens again.
RBS
-Original Message-
From: Guy Hachlili [mailto:[EMAIL PROTECTED]
Sent: 25 February 2007 14:26
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Locked database
Hello.
At 13:37 2/25/2007 +, you wrote:
>
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> INSERT INTO "foo" (a,b,c) VALUES (x,y,z)
>
> So, question: is there a way to get the .dump command to emit dumps in
> the latter form?
Not to my knowledge.
It would be nice if .dump could optionally omit PRAGMAs as well.
___
> > Did you try hacking the Linux Makefile like I suggested?
Maybe i am completelly stupid, but i do not know, how to compile with the
linux makefile without configure
I made changes in it, but what should i run after?
Tried to run
make Makefile.linux-gcc
but no target found
I am starting to
One way or another you have to apply sweat or treasure to protect your
data asset. Just how valuable is it?
mxs wrote:
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 releas
> 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#crypto
Somebody is using that Sqlite Author solution ?
May i used that solution on all the platform ?
I need it for windows, mac os, windos ce
I've read somewhere that sqlite is a really good solution if you want
to share database in a network, if the program do not use many update
queries, cause Sqlite lock all the database on update process, is it
correct ?
How to detect is sqlite is on lock mode on a network ?
Some articles to read o
Jakub Ladman wrote:
You want "make -f Makefile.linux-gcc"
This
> make Makefile.linux-gcc
Will try to build "Makefile.linux-gcc" from a file called "Makefile"
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
Hello All,
You also have to accept that, if it's on the user's PC and they REALLY
want that data, they can get it. They don't even need to crack the
encryption. They just need to figure out what key the program's using
to unlock the DB. There's absolutely no way to protect data that's
stored on so
The following message is a courtesy copy of an article
that has been posted to gmane.comp.db.sqlite.general as well.
[EMAIL PROTECTED] writes:
> It is true that I do not use autoconf much. But I do use it now
> and then. The main problem is that autoconf is broken on my
> SuSE 10.1 installation
Adam Megacz <[EMAIL PROTECTED]> wrote:
>
> I also printed out and signed the copyright papers and mailed them in.
>
[...]
>
> Below is a copy of the patch updated to work against latest CVS.
> Don't forget to run 'autoreconf' after applying.
>
I'm sorry if I failed to respond to your submissio
Hi, I'm running a project using pysqlite for database support. It's
awsome.
Now I have a user who produces this warning: "Warning: You can only
execute one statement at a time."
At:
con = sqlite.connect(path)
cur = con.cursor()
cur.execute(sql)
I'm wondering if it can have something to do with mult
I found out that doing a:
sqlite3 my.db .dump > mydump.sql
rm my.db
sqlite3 my.db < mydump.sql
is faster than doing a VACUUM on my.db.
Are there any advantages of doing one over the other? My goal is to keep the
database's structures in their best shape for performance and integrity. So I
Dne neděle 25 únor 2007 19:25 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
>
> You want "make -f Makefile.linux-gcc"
Oh, of course, sorry.
And how to fix this?
[EMAIL PROTECTED] ~/src/sqlite-3.3.13 $ make -f Makefile.linux-gcc
sh4-pc-linux-uclibc-gcc -Os -DNDEBUG=1 -DHAVE_FDATASYNC=1 -DTHREADS
mr sql <[EMAIL PROTECTED]> wrote:
> I found out that doing a:
>
> sqlite3 my.db .dump > mydump.sql
> rm my.db
> sqlite3 my.db < mydump.sql
>
> is faster than doing a VACUUM on my.db.
>
> Are there any advantages of doing one over the other? My goal is to keep the
> database's structures in t
[EMAIL PROTECTED] wrote: mr sql wrote:
> I found out that doing a:
>
> sqlite3 my.db .dump > mydump.sql
> rm my.db
> sqlite3 my.db < mydump.sql
>
> is faster than doing a VACUUM on my.db.
>
> Are there any advantages of doing one over the other? My goal is to keep the
> database's structur
The following message is a courtesy copy of an article
that has been posted to gmane.comp.db.sqlite.general as well.
Using sqlite 3.3.10 I'm experiencing a strange situation where .dump
appears to repeat the last few lines of the dump (not including the
final "COMMIT") twice.
Has anybody else ex
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> Using sqlite 3.3.10 I'm experiencing a strange situation where .dump
> appears to repeat the last few lines of the dump (not including the
> final "COMMIT") twice.
>
> Has anybody else experienced this?
I've never seen this before. Does it happen with
I don't have any market value in mind, but I do know that the data in the
database took a lot of time to put together (and I mean a lot). It was very
lengthy process of one individual. So it does have a high value, although
not one you can put a monetary value on, not at least for now.
Regards
M
I get that, but I will draw an analogy for you. My dad cannot rip a
commercial movie DVD and because he doesn't know how he even doesn't try. So
if someone doesn't know how to crack it I'd say that most people will not
even bother, very few might and some of those could succeed. But I can live
wit
On Sun, 2007-02-25 at 22:48 +0100, Jakub Ladman wrote:
> Dne neděle 25 únor 2007 19:25 Martin Jenkins napsal(a):
> > Jakub Ladman wrote:
> >
> > You want "make -f Makefile.linux-gcc"
> Oh, of course, sorry.
>
> And how to fix this?
>
> [EMAIL PROTECTED] ~/src/sqlite-3.3.13 $ make -f Makefile.linu
Btw.
According to
python
import pysqlite2.dbapi2 as sqlite
print sqlite.version
He is running sqlite 2.0.5.
It works fine in 2.3.2.
I guess it is a bug which has been fixed.
Is there any way to make the code backwards compatible, or will I just
have to ask him to upgrade?
søn, 25 02 2007 kl. 22
Thomas Dybdahl Ahle wrote:
Hi, I'm running a project using pysqlite for database support. It's
awsome.
Now I have a user who produces this warning: "Warning: You can only
execute one statement at a time."
Hard to say without knowing the value of sql in
cur.execute(sql)
pysqlite's execute met
Hi everybody,
Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.If so can the same sqlite3
library and the executable used in windows can be used in MAC OS or a
different version has to be used.
Regards,
Kirrthana
40 matches
Mail list logo