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
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
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.
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
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
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
--- 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
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
[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
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
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
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
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
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
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
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
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]
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
> 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
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
> > 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
--- 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.
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
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
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
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
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
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
-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
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.
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
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
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
33 matches
Mail list logo
