[sqlite] Increase safety of the DataBase

Hi ! I want to process many data with python, and want to store in database. In the prior version of my code I create a simple thing that delete the old results, recreate the database and fill up it. But that is not too flexible, because when an power supply or hardware problem occured, all of

Re: [sqlite] Creating tables with open statements

Jay Sprenkle wrote: The SQLITE_SCHEMA case is handled in our code. But in this case, we are in the middle of iterating a statement. Can we prepare it again without "losing our place"? Is this the right action considering that we are getting a SQLITE_ERROR when executing the statement, not

[sqlite] Select from indexed table

Hi! I have sqlite version 3.1.3, and Suse 9.3. i have a table (LOG) with about 500.000 records. The column "result" is a indexed column, if i make the select "select * from LOG where (result ="OK") limit 10;" it takes over 24 second to access all Values, instead with "select * from LOG where

Re: [sqlite] Increase safety of the DataBase

"Dara Durum" <[EMAIL PROTECTED]> wrote: > > The transactions are very good things, but does not protect the database > from injuring. Yes they do. Transactions in SQLite are Atomic, Consistent, Isolated, and Durable - even if a power failure occurs in the middle of the transaction. -- D.

Re: [sqlite] Creating tables with open statements

On 4/3/06, Matthew Gertner <[EMAIL PROTECTED]> wrote: > My questions: > 1) If I am stepping though a statement and change the schema, shouldn't > the next step() or prepare() return an error requiring me to recreate > the statement? How come I'm not observing this behavior? Note that none > of the

Re: [sqlite] Re: Probably, bug in SQLite (Or, what is wrong with this query?)

On 4/2/06, Alexander Kozlovsky <[EMAIL PROTECTED]> wrote: > Put my initial question another way, I think this is correct SQL: > > select ( > select a > from (select a > from (select a > from (select a > from (select a >

Re: [sqlite] SQLite & Palm!

"Clay Dowling" <[EMAIL PROTECTED]> wrote: > Just got news about SQLite being available on the next generation of > PalmOS systems (which is Linux based). This is fantastic news from the > perspective of somebody looking to start Palm development. The concept of > a Palm device that I can ssh to

RE: [sqlite] How to unsubscribe from this maillist ?

I had an issue with my computer where I started getting files filling my temporary directory without reason that began with "sqlite_" and wanted to ask the forum if anyone new why this was. In order to do so I had to join the forum, knowing no other avenue to find out. I got my answer -

Re: [sqlite] How to unsubscribe from this maillist ?

"Bill Giannotti" <[EMAIL PROTECTED]> wrote: > turns out that AOL and McAfee use the sqlite database I knew about AOL's use of SQLite. But this is the first I have heard that McAfee was using it. How do you know that McAfee is using SQLite? -- D. Richard Hipp <[EMAIL PROTECTED]>

RE: [sqlite] How to unsubscribe from this maillist ?

Richard, See the following link for a comment from one of the developers, http://tinyurl.com/pobqu Cheers! -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the

Re: [sqlite] Question regarding schema change error

[EMAIL PROTECTED] wrote: "Andrew Shakinovsky" <[EMAIL PROTECTED]> wrote: According to the docs, I am asked to finalize the statement [after SQLITE_SCHEMA], and re-prepare it. Unfortunately this doesn't fit nicely into my architecture. It is easy to put wrappers around

RE: [sqlite] Question regarding schema change error

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 01, 2006 7:08 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Question regarding schema change error > ... > It is easy to put wrappers around sqlite3_prepare(), > sqlite3_step(),

[sqlite] SQLite 2.8.17 - Interface

Hello, I just wanted to ask if there is an interface change from version 2.8.16 to 2.8.17? Because I need to know it for Ubuntu Dapper. https://launchpad.net/distros/ubuntu/+source/sqlite/+bug/36732 Thanks, A. Klitzing

[sqlite] How to configure without 'configure' script?

Hi, I would like to compile the SQLite 3 sources directly into my app. Since I'm using Visual C++ 6 how can I configure the sources to allow me to compile them? Can I use MSYS and run /configure and then just copy the 'configured' sources to my Visual C++ app and compile them there? Or is

RE: [sqlite] Question regarding schema change error

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 01, 2006 7:08 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Question regarding schema change error ... > It is easy to put wrappers around sqlite3_prepare(), sqlite3_step(), > and

RE: [sqlite] How to unsubscribe from this maillist ?

To remove your address from the list, just send a message to, <[EMAIL PROTECTED]> Cheers! -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the

RE: [sqlite] How to unsubscribe from this maillist ?

smime.p7m Description: S/MIME encrypted message

Re: [sqlite] How to configure without 'configure' script?

> Hi, > I would like to compile the SQLite 3 sources directly into my app. > Since I'm using Visual C++ 6 how can I configure the sources to allow > me to compile them? > Can I use MSYS and run /configure and then just copy the > 'configured' sources to my Visual C++ app and compile them there?

[sqlite] [ANN] SQLite ODBC driver version 0.67

Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQLite 2.8.17 version of the driver and now fully supports binary data. The Win32 version is now made with a MinGW cross compiler and NSIS. Enjoy,

[sqlite] last modified time or version of sqlite database

I am generating web pages from an sqlite database. I would like to generate an ETag header so I need some handle on when the database has changed, either a last modified time or a revision number of the data. Is there an easy way to get this out of SQLite? In this case the db is very simple so

Re: [sqlite] Question regarding schema change error

Andrew Shakinovsky wrote: Thanks. That works great. I would agree with Dennis that this functionality should belong in the API, however, after reading the following post, I can see why it is not done this way: http://www.mail-archive.com/sqlite-users@sqlite.org/msg11398.html Andrew, The

[sqlite] how to fix problem of lock

I have a database that i do a lot of insert and select... really a lot but i have a problem with the lock database, couse when i do a lot of insert i can do a select i know that that is normal, but how can i fix it?, using a memory for insert or using another database like a mirror or how???

Re: [sqlite] how to fix problem of lock

On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > I have a database that i do a lot of insert and select... really a lot > > but i have a problem with the lock database, couse when i do a lot of insert > i can do a select > > i know that that is normal, but how can i fix it?,

Re: [sqlite] last modified time or version of sqlite database

Regards

Re: [sqlite] how to fix problem of lock

I have a database ok... i do a lot of insert and select, but there is sometime that i cant do the select couse the database is locked... i have to do a lot of insert every time, so how can i do for dont lock the database... understand guy? On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:

Re: [sqlite] how to fix problem of lock

On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > I have a database ok... i do a lot of insert and select, but there is > sometime that i cant do the select couse the database is locked... > > i have to do a lot of insert every time, so how can i do for dont lock the >

Re: [sqlite] how to fix problem of lock

thanx man but is posible open several DATABASE with a programm and do transaccion without locked the table??? On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > I have a database ok... i do a lot of insert and select,

Re: [sqlite] how to fix problem of lock

HElp me, couse i just need to do insert and select, i dont use delete or replate or update On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > thanx man > > > but is posible open several DATABASE with a programm and do transaccion > without locked the table??? > > On 4/3/06, Jay

Re: [sqlite] how to fix problem of lock

An INSERT can change the results of your SELECT, so the database has to be locked during INSERT. Otherwise, the result of your SELECT would depend on whether the INSERT had finished yet. (The INSERT might even have only partly finished, which would mean the SELECT was looking at a database in an

Re: [sqlite] how to fix problem of lock

i insert numbers and select numbers, so what could be the solutions, couse i have to do that On 4/3/06, Pam Greene <[EMAIL PROTECTED]> wrote: > > An INSERT can change the results of your SELECT, so the database has to be > locked during INSERT. Otherwise, the result of your SELECT would depend

[sqlite] Programmatical determination of sqlite version via SQL?

Is it possible (if so how) to programmatically determine version of sqlite that is in use? Ie something like this: select @@version The reason I ask is because I have some .NET code that uses Mono as run-time, and it seems that in some cases Mono picks some other sqlite DLL than the one

Re: [sqlite] Programmatical determination of sqlite version via SQL?

On 4/3/06, Alex Chudnovsky <[EMAIL PROTECTED]> wrote: > Is it possible (if so how) to programmatically determine version of > sqlite that is in use? SELECT sqlite_version(); -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Programmatical determination of sqlite version via SQL?

On 4/3/06, Alex Chudnovsky <[EMAIL PROTECTED]> wrote: > Is it possible (if so how) to programmatically determine version of > sqlite that is in use? > > Ie something like this: select @@version > > The reason I ask is because I have some .NET code that uses Mono as > run-time, and it seems that in

RE: [sqlite] Programmatical determination of sqlite version via SQL?

I'm sorry? That's exactly what Alex was asking for, he needs to know the version of SQLite DLL that Mono picked up. Via query, 'select sqlite_version()' -> '3.3.4' Via function, sqlite3_libversion() -> '3.3.4' Cheers! -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street

Re: [sqlite] Programmatical determination of sqlite version via SQL?

Nemanja Corlija wrote: On 4/3/06, Alex Chudnovsky <[EMAIL PROTECTED]> wrote: Is it possible (if so how) to programmatically determine version of sqlite that is in use? SELECT sqlite_version(); Perfect answer, thank you very much! Also thanks to Boris and Jay (that answer was

Re: [sqlite] how to fix problem of lock

please i need some help On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > i insert numbers and select numbers, so what could be the solutions, > couse i have to do that > > > On 4/3/06, Pam Greene < [EMAIL PROTECTED]> wrote: > > > > An INSERT can change the results of your

[sqlite] file locking on Mac OS X

Mac OS X 10.4.6 was just released today with this interesting fix: "file access and byte range locking with AFP file sharing". There is some chance this meansn that SQLite locking will now work on shared volumes on OS X.

Re: [sqlite] how to fix problem of lock

Cesar David Rodas Maldonado wrote: please i need some help Cesar, I suspect that the tone of your messages and your insistence on getting some sort of unspecified help has irked more than a few members of this list. I appreciate that English may not be your first language, but your

Re: [sqlite] how to fix problem of lock

"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote: > but is posible open several DATABASE with a programm and do transaccion > without locked the table??? No. A transaction will always lock the database at some point. Regards

Re: [sqlite] how to fix problem of lock

> I suspect that the tone of your messages and your insistence on getting > some sort of unspecified help has irked more than a few members of this > list. I didn't think I could help without spanish. I'm the guy who asked 'who is the bathroom' when I tried it last... ;)

[sqlite] Dumping in a more portable format

Is it possible to dump an SQLite table in a format something like this? INSERT INTO employee (last_name, first_name, mi, username, id, extension, home_phone, cell_phone, status, email_primary, email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14', '555-1212', '525-2123', 'a',

Re: [sqlite] last modified time or version of sqlite database

Thanks - but this seems to give the number of changes during the lifetime of a db session. With CGI the sessions will be short lived. On a new session I want to know when the db was last modified (or some other indication of

RE: [sqlite] last modified time or version of sqlite database

Umm, how about a "last modified at" file attribute on your db file? -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless

Re: [sqlite] last modified time or version of sqlite database

On Mon, April 3, 2006 15:49, Chris Fletcher wrote: >> > > Thanks - but this seems to give the number of changes during the > lifetime of a db session. With CGI the sessions will be short lived. > On a new session I want to know when the db

Re: [sqlite] Dumping in a more portable format

Steve Bergman wrote: Is it possible to dump an SQLite table in a format something like this? INSERT INTO employee (last_name, first_name, mi, username, id, extension, home_phone, cell_phone, status, email_primary, email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14',

Re: [sqlite] last modified time or version of sqlite database

Near the bottom of http://sqlite.org/pragma.html you'll find: "PRAGMA [database.]user_version; PRAGMA [database.]user_version = integer ; The pragmas [...] user_version are used to set or get the [...] user-version, [which is a] 32-bit signed integers stored in the database header. [...] The

Re: [sqlite] Dumping in a more portable format

Steve Bergman wrote: Is it possible to dump an SQLite table in a format something like this? INSERT INTO employee (last_name, first_name, mi, username, id, extension, home_phone, cell_phone, status, email_primary, email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14',

RE: [sqlite] Re: Db copy

Dennis, I looked at the .dump feature implementation in shell.c as well as how vacuum is implemented. Based on that an idea will be to iterate through the metainformation on the SQLITE_MASTER table in order to recreate the new Db schema and for each table run SQL statements that will transfer the

Re: [sqlite] Re: Probably, bug in SQLite (Or, what is wrong with this query?)

Oracle 8.1.7: select a, (select c from (select d + 1 as c from dual) ) as d from (select 1 as a, 2 as b from dual) ORA-00904: invalid column name If you replace (d + 1) with a number this query runs fine. Perhaps it isn't a valid correlated subquery. Anyone know the SQL spec well enough to

Re: [sqlite] how to fix problem of lock

You can't SELECT from your database while an INSERT has not finished. SQLite will return the SQLITE_BUSY error if you try. You can't fix that. It is not broken. In fact, it's necessary. You can have your application simply loop with a delay, trying the SELECT and waiting for the SQLITE_BUSY to

Re: [sqlite] last modified time or version of sqlite database

Ignore this bit - cut and paste error con=apsw.Connection("aaa") con=apsw.Connection("temp") Martin

Re: [sqlite] How to configure without 'configure' script?

Olaf Beckman Lapré wrote: Hi, I would like to compile the SQLite 3 sources directly into my app. Since I'm using Visual C++ 6 how can I configure the sources to allow me to compile them? Can I use MSYS and run /configure and then just copy the 'configured' sources to my Visual C++ app and

Re: [sqlite] Re: Probably, bug in SQLite (Or, what is wrong with this query?)

I just realized I performed the wrong query - I should have used (b + 1)! If no one queries this on Oracle in the meantime, I will try it again tomorrow at work. Sorry for the noise. --- Joe Wilson <[EMAIL PROTECTED]> wrote: > Oracle 8.1.7: > > select a, (select c from (select d + 1 as c from

Re: [sqlite] how to fix problem of lock

Try to explain what you are doing. How do you access SQLITE? What language? What SQL are you using. How many concurrent users do you have? Are you getting a LOCK error because of multiple users? Cesar David Rodas Maldonado wrote: please i need some help On 4/3/06, Cesar David Rodas

Re: [sqlite] Dumping in a more portable format

Steve Bergman wrote: Is it possible to dump an SQLite table in a format something like this? INSERT INTO employee (last_name, first_name, mi, username, id, extension, home_phone, cell_phone, status, email_primary, email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14',