Re: [sqlite] SQLITE_CORRUPT error

Citando "D. Richard Hipp" : > > On Jun 18, 2009, at 12:36 PM, galea...@korg.it wrote: > >> This statement is giving me truoble: >> INSERT INTO PlayList_Song(id_song, id_playlist, song_number) VALUES >> (5235, 9, 256) > > That INSERT statement works fine for me. > > Did you try

Re: [sqlite] Database inserts gradually slowing down

Yes, I've been looking into using the prepare/bind/step functions instead. I'm at a complete loss as to what might have caused the behavior I initially saw, since every test I run now runs in constant time. Thanks for the doc links Dennis, and thanks to everyone for their help and suggestions.

[sqlite] FTS

Dear all,   we plan to use FTS in embedded devices for address search. One requirement is to save storage.   Assume I create a table FTS_addresses (Field1,Field,2,..Fieldn), where Field1 is an identifier for my addresses. If now field1 would be used as document id, and if every fts query returns

[sqlite] very bad performance with triggers and indexes

Hi I have a very strange performance problems involving indexes and triggers. A somewhat simplified example of what I want to do (but which allows to reproduce the behavior) is the following: CREATE TABLE MY_FC (ID integer, DESCRIPTION text); I then proceed to insert 5 rows from my

[sqlite] sqlite3_auto_extension

Hi Nico, Thank you for your answer. >It's obvious from the function prototype (no DLL/DSO file name >argument). Yes, of course. I'm not confusing a string holding a filename and a function pointer! >However, you can use sqlite3_load_extension() instead per-DB connection, >OR, you can even do

[sqlite] Literal replacements in prepared statements

I'm trying to add some literal replacements in my prepared SQL statement but I'm currently getting a SQL syntax error. Here's a snippit of what I'm trying to do: ... sqlite3_stmt* stmt; sqlite3_prepare_v2(db, "Select * from ?", -1, , NULL); <-- near "?": syntax error

Re: [sqlite] Literal replacements in prepared statements

You're trying identifier replacement, not literal replacement. It's not allowed. You have to write table name without binding. Pavel On Fri, Jun 19, 2009 at 9:58 AM, Shaun Seckman (Firaxis) wrote: > I'm trying to add some literal replacements in my prepared SQL

Re: [sqlite] Literal replacements in prepared statements

Not sure I fully understand what you mean. Is it not possible to replace the table name in the prepared statement? What sort of things can I replace then? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent:

Re: [sqlite] Literal replacements in prepared statements

Yes, it's impossible to replace table or column names. You can replace any constant values like this: select table.column2, column3 + ? from table where column1 = ? and column2 + ? > column3 limit ?, ? Pavel On Fri, Jun 19, 2009 at 10:06 AM, Shaun Seckman (Firaxis)

Re: [sqlite] Literal replacements in prepared statements

Ah, that makes more sense :) Thanks a bunch for the clarification! -Shaun -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Friday, June 19, 2009 10:57 AM To: General Discussion of SQLite Database Subject:

Re: [sqlite] Literal replacements in prepared statements

On 20/06/2009 12:06 AM, Shaun Seckman (Firaxis) wrote: > Not sure I fully understand what you mean. > Is it not possible to replace the table name in the prepared statement? It is not possible. > What sort of things can I replace then? You can do replacement at any place where a "literal"

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009/6/19 hiral : > Hi Simon / John, > > Thank you for replies. > >> You are able to repeatably corrupt the db under SQLite 3.5.9? It would >> be worthwhile publishing a script that can do that. >  > "was getting error often" or "did get error ONCE"?? > I am running

[sqlite] sqlite3.dll and async io ??

I want to test sqlite3asynch io but it seems that all the ex\async files are : not it amalgamation ? not in zipped source files ?? not included in the sqlite3.dll ??? But it seems to work fine with win32 platform using amalgamation + sqlite3async files ! Does future sqlite3.dll/libsqlite3.so

[sqlite] Group_concat includes null if first in the group

Hello, I found an issue in group_concat, that appears mainly cosmetical, however may be good to be aware of for those making a more creative use of this function. See the ticket http://www.sqlite.org/cvstrac/tktview?tn=3923. Edzard. ___ sqlite-users

[sqlite] async io and locks

I finally got around to reviewing SQLite's asynchronous I/O functionality. http://sqlite.org/asyncvfs.html We actually have an C++ wrapper to uses the same concept, a background thread for I/O. The async functionality included w/ SQLite is not a

Re: [sqlite] async io and locks

On Jun 20, 2009, at 12:06 AM, Robert Lehr wrote: > I finally got around to reviewing SQLite's asynchronous I/O > functionality. > >http://sqlite.org/asyncvfs.html > > We actually have an C++ wrapper to uses the same concept, a > background thread for

[sqlite] search in archive

Is it possible to have a search feature for the archive? I.e. rather than having to do a linear search through 18 archives for an answer to a question, have a google-like search across all of the archives? Ray Rizzuto raymond.rizz...@sig.com Susquehanna

[sqlite] shared library versions

I noticed that the sqlite.so (SLES 9 32-bit) is numbered .0.8.6 in 3.5.9 and 3.6.15 versions. This caused me some issues when I tried running an application build against 3.6.15, but the .so that it found was from 3.5.9. It partially worked, depending on the methods I called. Part of the

[sqlite] sqlite3_exec() documentation

The documentation found at http://sqlite.org/c3ref/exec.html is unclear about some parts: is it possible to not request an error message (via passing NULL as the errmsg parameter)? And what are the possible return values? - Sherief ___ sqlite-users

Re: [sqlite] search in archive

On Fri, 19 Jun 2009 13:56:52 -0400, "Rizzuto, Raymond" wrote: > Is it possible to have a search feature for the > archive? Which archive? I'll assume you have 18 different databases and you want to search them in parallel. > I.e. rather than having to do a linear >

Re: [sqlite] [noob] merge statement equivalent?

thanks! On Jun 18, 2009, at 6:01 PM, Dennis Cote wrote: > James Gregurich wrote: >> on that update statement, is the SQL optimizer smart enough to not >> rerun that select statement for each column in the update's set >> clause? Is it going to run a single select statement to get , >> , etc.

Re: [sqlite] search in archive

There is a search of archives at http://www.mail-archive.com/sqlite-users%40sqlite.org/ On Fri, Jun 19, 2009 at 2:43 PM, Kees Nuyt wrote: > On Fri, 19 Jun 2009 13:56:52 -0400, "Rizzuto, Raymond" > wrote: > > > Is it possible to have a search feature

Re: [sqlite] search in archive

Hello KN On Fri, 19 Jun 2009 13:56:52 -0400, "Rizzuto, Raymond" KN wrote: KN KN > Is it possible to have a search feature for the KN > archive? KN KN Which archive? I think Raymond means the sqlite-users archive. You could download all the txt.gz files, cat them

Re: [sqlite] search in archive

The link I posted (http://www.mail-archive.com/sqlite-users%40sqlite.org/) only goes back to March 10, 2009 It searches well but is currently incomplete. Will it be expanded to include older posts? http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/ goes back much further, but

Re: [sqlite] search in archive

My apologies for being unclear. I meant the archive of all the sqlite-users messages. I prefer not to ask a question that has already been answered. The link http://www.mail-archive.com/sqlite-users@sqlite.org/ suggested by Adam DeVita does has such a function. I was accessing the archives

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

On 19 Jun 2009, at 06:36, hiral wrote: > I am running application which uses the db over the NFS. If I move > the db > over the local drive then it's working fine. > So I m observing this bug in NFS environment frequently. > In the same test environment (in which I am getting db corrupted), >

[sqlite] (no subject)

Date: Fri, 19 Jun 2009 14:53:05 -0700 From: Robert Lehr Subject: Re: [sqlite] async io and locks To: sqlite-users@sqlite.org In-Reply-To: <43c62cbb-57db-4d1b-af36-2facf239c...@gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes I have never been

Re: [sqlite] async io and locks

Once again, I am forced to reply to the top-level, outside the thread b/c I am not receiving individual replies. I apologize for the inconvenience. On Jun 20, 2009, at 12:30 AM, Dan wrote: > On Jun 20, 2009, at 12:06 AM, Robert Lehr wrote: > > I finally got around to reviewing SQLite's

Re: [sqlite] async io and locks (CORRECTION)

(A) I was able to reply inside the thread. *confused* (B) "that the lock is acquired independent..." is incorrect and irrelevant. It should be ignored. -robert ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] search in archive

On 20/06/2009 3:56 AM, Rizzuto, Raymond wrote: > Is it possible to have a search feature for the archive? I.e. rather than > having to do a linear search through 18 archives for an answer to a question, > have a google-like search across all of the archives? http://search.gmane.org/ In the

Re: [sqlite] async io and locks

On Jun 20, 2009, at 6:22 AM, Robert Lehr wrote: > Once again, I am forced to reply to the top-level, outside the thread > b/c I am not receiving individual replies. I apologize for the > inconvenience. > > On Jun 20, 2009, at 12:30 AM, Dan wrote: >> On Jun 20, 2009, at 12:06 AM, Robert Lehr