Re: [sqlite] Parallel execution of queries in threads

I checked with following scenario. There are 2 script 1) continuously inserting a row at a time in table with exclusive lock mode. 2) executing 4 SELECT queries. e.g. o SELECT column1, SUM(column2) FROM table_name WHERE column3 BETWEEN X AND Y GROUP BY column1; o SELECT column4,

Re: [sqlite] Help for Garbled

>> for example, i insert String filled with gbk bytes and set the String >> charset 'UTF-8' > >What do you mean, "set String charset"? Set how and where? >-- >Igor Tandetnik Hi The String on java side is ok. > for example, i insert String filled with gbk bytes and set the String charset >

Re: [sqlite] Help for Garbled

On 3/1/2011 9:49 PM, 陈强 wrote: > How did the sqlite.exe work if insert data through it? > insert gbk string? Most likely. I wouldn't be surprised if these strings came out wrong on Java side, though. > can I insert data like it ? Probably, but I don't think you really want to. It'll be a

Re: [sqlite] Help for Garbled

>Try running this command before starting sqlite.exe, but I'm not sure >this will help: > >mode con cp select=65001 Hi I tried to change the charset of console to utf-8 before, but it didn't work correctly. Because the app will besent to custom, so i want to make sqlite.exe display correctly.

Re: [sqlite] Help for Garbled

On 3/1/2011 8:52 PM, 陈强 wrote: > But if i want to make the gbk console show String correctly, what should i do? Try running this command before starting sqlite.exe, but I'm not sure this will help: mode con cp select=65001 There also exists a number of nice graphical tools for working with

Re: [sqlite] Help for Garbled

At 2011-03-02 09:17:48，"Igor Tandetnik" wrote: >On 3/1/2011 8:05 PM, 陈强 wrote: >> At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: >> >>> 陈强 wrote: Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The

Re: [sqlite] Help for Garbled

On 3/1/2011 8:05 PM, 陈强 wrote: > At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: > >> 陈强 wrote: >>> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. >>> The Chinese from JDBC(rs.getString(index)) is normal but >>> the Chinese from

[sqlite] Fwd: Fwd: Fwd: fts virtual table questions

My problem is the term "virtual" I guess. I think of virtual as in-memory only or something. Once they are created in a SQLite database they seem to be as real as the other tables. >> I had an API problem, and I now think that the virtual table does not need >> to be created each time. I can't

Re: [sqlite] Help for Garbled

At 2011-03-01 20:56:49，"Igor Tandetnik" wrote: >陈强 wrote: >> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The >> Chinese from JDBC(rs.getString(index)) is normal but >> the Chinese from Sqlite.exe (Select data) is Garbled, my

[sqlite] Source code for system.data.sqlite

Since sqlite has taken on system.data.sqlite for .net you will be seeing issues on this until a forum is set up for it. Please try to make sure the entire source tips are available for download. The last time I checked 1.0.68 (or ?) did not compile due to missing linq related files. Hopefully

Re: [sqlite] Fwd: Fwd: fts virtual table questions

On Tue, Mar 1, 2011 at 4:54 PM, Paul Shaffer wrote: > I had an API problem, and I now think that the virtual table does not need > to be created each time. I can't find documentation that covers this. I don't think there is documentation which covers this, because it's

[sqlite] Fwd: Fwd: fts virtual table questions

I had an API problem, and I now think that the virtual table does not need to be created each time. I can't find documentation that covers this. The question on threading the virtual table construction still stands. If I don't have any response in a day or so I will close this issue.

[sqlite] tclsqlite Precompiled binary for tcl

Hi, is the precompiled binary for tcl not longer available? Best Regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query help

On 3/1/2011 6:47 PM, Jeff Archer wrote: > I think it will just happen to work out if I could get the first row > for each ImageID since the values should have been entered in > ascending order. I realize this will probably not be guaranteed to > get lowest X,Y but for my purpose at the moment

Re: [sqlite] Query help

>From: Igor Tandetnik [mailto:itandet...@mvps.org] >Sent: Tuesday, March 01, 2011 5:47 PM > >On 3/1/2011 5:01 PM, Jeff Archer wrote: >> And this select which I would like to modify to only return lowest X,Y >> value for each ImageID. > >What does "lowest" mean? If you have two points (100, 200)

Re: [sqlite] Query help

On 3/1/2011 5:01 PM, Jeff Archer wrote: > And this select which I would like to modify to only return lowest X,Y value > for each ImageID. What does "lowest" mean? If you have two points (100, 200) and (200, 100), which one is "lower"? -- Igor Tandetnik

[sqlite] Query help

Hi all, and thanks in advance for you help. I have the following schema CREATE TABLE [Scans] (ScanIDINTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ,Timestamp DATETIME NOT NULL UNIQUE ,EndTime DATETIME NOT NULL DEFAULT CURRENT_TIME ,ResultVARCHAR ); CREATE

Re: [sqlite] Re ad Lock not released..

On Tue, Mar 01, 2011 at 12:20:32PM -0800, mmudi scratched on the wall: > > We are using sqlite version 3.3.17 in a production environment, and are > facing an issue where a particular process is not releasing the read lock on > the sql file. This locks up the database when any write operations

Re: [sqlite] Re ad Lock not released..

> From my debugging efforts, the issue appears to be that the process entered > the sqlite library at some point in its operation, acquired a read lock, and > returned from the library, but failed to release the read lock. Under what > circumstances can this occur? This is a normal behavior for

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

pavel, > > I suspect that "as soon as the application launches" means that no > parallel threads are working yet (if they work already then look into > what those threads are doing). Then the problem could be in some > linking issues. E.g. you have some function that is named the same as > some

[sqlite] Re ad Lock not released..

We are using sqlite version 3.3.17 in a production environment, and are facing an issue where a particular process is not releasing the read lock on the sql file. This locks up the database when any write operations are attempted by other processes. The process under question is not multi

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

hi all, i've just discovered that the bug is there when compiling with the LLVM compiler 1.6, which comes as a standard compiler with the iOS SDK, and is the direction that Apple is moving towards. the problem is NOT there when compiling with GCC 4.2. the problem is

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

>        i also took the same statement and tried to run it in our app in a > method called as soon as the application launches, and it fails.  so we have > something going on at a different level. I suspect that "as soon as the application launches" means that no parallel threads are working

Re: [sqlite] adding fdopen to VFS?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/01/2011 01:07 AM, Philip Graham Willoughby wrote: > I argue that this implies a problem in the Chromium sandbox rather than a > problem in the SQLite code. SQLite's implementation makes things worse because the xOpen implementation is not 5

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

michael, > Have you run your test with and without crypto? If Apple can compile > 3.6.23.2 to work you should be able to also (might be overly optimistic here > but compilers are 100% deterministic, although not necessartiliy 100% binary > match). we have encrypted and read a

[sqlite] ANN: C#-SQLite 3.7.5

C#-SQLite has been updated to release 3.7.5 and is now ready for use. The 2/28 release features: * SQL_HAS_CODEC compiler option * Silverlight support * Windows 7 Phone Does not support WAL It now runs 54,618 of the tcl testharness tests without errors. The project is located at

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

On Tue, Mar 01, 2011 at 05:13:00PM +0100, pcun...@fsmail.net scratched on the wall: > > Your examples suggest that actually sqlite3-bind_text "is not > > accepting std::string", not sqlite3_prepare_v2. But how exactly it > > "doesn't accept"? You pass SQLITE_STATIC as 5th parameter there; are you

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

UPDATE - Problem solved ! I found the error. I am so sorry, I try to test and be a helpful member... :( I was calling sqlite3_prepare_v2() twice and it was canceling out everything apparently. I am building these queries on the fly so I just missed that. How this happend was because when building

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

> Your examples suggest that actually sqlite3-bind_text "is not > accepting std::string", not sqlite3_prepare_v2. But how exactly it > "doesn't accept"? You pass SQLITE_STATIC as 5th parameter there; are you sure > you don't destroy or change your strings before statement is executed? Correct, it

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

Try using SQLITE_TRANSIENT instead of STATIC. Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of pcun...@fsmail.net

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

Your examples suggest that actually sqlite3-bind_text "is not accepting std::string", not sqlite3_prepare_v2. But how exactly it "doesn't accept"? You pass SQLITE_STATIC as 5th parameter there; are you sure you don't destroy or change your strings before statement is executed? Pavel On Tue, Mar

[sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

Maybe I am to sleepy, but sqlite3_prepare_v2 is not accepting a std::string as a parameter in the following example: // Setup table structure SQLiteCommand("CREATE TABLE IF NOT EXISTS USR_EVENTS(AID INTEGER PRIMARY KEY AUTOINCREMENT,USER_ID BIGINT,GROUP_ID BIGINT,SIS_EVENTS_PTR BIGINT");

Re: [sqlite] Help for Garbled

陈强 wrote: > Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The > Chinese from JDBC(rs.getString(index)) is normal but > the Chinese from Sqlite.exe (Select data) is Garbled, my environment as list: Console window doesn't know UTF-8. The strings are

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

Have you run your test with and without crypto? If Apple can compile 3.6.23.2 to work you should be able to also (might be overly optimistic here but compilers are 100% deterministic, although not necessartiliy 100% binary match). Michael D. Black Senior Scientist NG Information Systems

Re: [sqlite] adding fdopen to VFS?

On 28 Feb 2011, at 20:38, Roger Binns wrote: >> Why is it not possible to create a custom VFS for the intended purpose >> and register it for the connections that need it? > > Because that custom VFS would be an almost duplicate of the existing VFS but > with a few key places changed. > > If