Re: [sqlite] Progress update while Prepare() is executing

Thnk you for your thoughts. I have learned a few things as always. There is a tenency these days to question the question these days as most developers could benefit from a better design. It tends to divert the question in directions that were not intended and requires defending the underlying

[sqlite] SELECT issue with SQLite 3.6.10

Dear all, Yesterday I upgraded my SQLite version from version 3.5.9 to 3.6.10, and I now experience an issue while making a SELECT on one of my view : This query was previously working on version 3.5.9 : SELECT [GENERAL.ID] FROM VIEW_GENERAL; where "GENERAL.ID" is the name of a column in the

Re: [sqlite] INNER JOIN, JOIN Confusin

Thanks for the reply. Stats does contain 46 qids with sids of 7 there is one duplicate question now that i look harder in temp which is ok because 289 I forgot to mention that id in temp is not a key, this is because there is a test mode to ask random questions that aren't unique (so 289 was

Re: [sqlite] SELECT issue with SQLite 3.6.10

On Jan 27, 2009, at 5:24 AM, KurDtE wrote: > > Dear all, > > Yesterday I upgraded my SQLite version from version 3.5.9 to 3.6.10, > and I > now experience an issue while making a SELECT on one of my view : > > This query was previously working on version 3.5.9 : > SELECT [GENERAL.ID] FROM

Re: [sqlite] INNER JOIN, JOIN Confusin

"Cnichols" wrote in message news:21685825.p...@talk.nabble.com > Stats does contain 46 qids with sids of 7 > there is one duplicate question now that i look harder in temp which > is ok because 289 I forgot to mention that id in temp is not a key, > this is because there is

Re: [sqlite] INNER JOIN, JOIN Confusin

I expected it to return 46 results, not fewer as you mentioned, except it returns 51 which I am trying to figure out why ... there is only one duplicate in Temp, but why would that still produce more results then 46? Igor Tandetnik wrote: > > "Cnichols" wrote > in message

Re: [sqlite] Adding Custom Column Data Types

Mike McGonagle writes: > > Hello all, > > I am in the process of integrating SQLite into a multimedia > environment/programming language. One thing that I would like to be > able to do is support all the various datatypes in this language, and > one in particular is a list of other

Re: [sqlite] SQLite JDBC driver performance

On Wed, Jan 21, 2009 at 03:48:50PM -0800, Jim Dodgen wrote: > are you running the pure version of the sqlite driver? >From the profile output below, I'd say the pure Java version was being used. My guess is that the Java version is slower due to the fact that the Java version is based on

Re: [sqlite] SELECT issue with SQLite 3.6.10

Should not the GENERAL.ID be enclosed in double quotes? Or did I misread the SQL Standard? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Tuesday, January 27, 2009 8:06 AM To: General Discussion of

Re: [sqlite] INNER JOIN, JOIN Confusin

Ok I also tried to think about it from a different approached and didnt get the result I wanted ... SELECT COUNT() FROM Temp WHERE Id IN (SELECT QuestionId FROM Stats WHERE SessionId = 7) I expected that to return 46 results .. it returned 29? ... also kind of confusing What I was thinking that

Re: [sqlite] SELECT issue with SQLite 3.6.10

On Jan 27, 2009, at 10:08 AM, Fred Williams wrote: > > Should not the GENERAL.ID be enclosed in double quotes? Or did I > misread > the SQL Standard? You can use double-quotes to conform to the SQL standard. But SQLite also allows some non-standard quoting mechanisms for compatibility

Re: [sqlite] INNER JOIN, JOIN Confusin

I am trying to keep my thoughts as organized as possible. I want to refresh and try to simplify my question ... The following produces 52 results, which consists of 52 questions that where incorrect from session 6, the previous session, we are now in a new session, session 7 SELECT COUNT()

Re: [sqlite] INNER JOIN, JOIN Confusin

Cnichols wrote: > Igor Tandetnik wrote: >> >> "Cnichols" wrote >> in message news:21685825.p...@talk.nabble.com >>> Stats does contain 46 qids with sids of 7 >>> there is one duplicate question now that i look harder in temp which >>> is ok because 289

Re: [sqlite] INNER JOIN, JOIN Confusin

Cnichols wrote: > Ok I also tried to think about it from a different approached and > didnt get the result I wanted ... > > SELECT COUNT() FROM Temp > WHERE Id IN (SELECT QuestionId FROM Stats WHERE SessionId = 7) > > I expected that to return 46 results .. it returned 29?

Re: [sqlite] SELECT issue with SQLite 3.6.10

That's what I have always loved about standards! They are so flexible :-) -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Tuesday, January 27, 2009 9:30 AM To: General Discussion of SQLite Database

Re: [sqlite] INNER JOIN, JOIN Confusin

Cnichols wrote: > The following produces 52 results, which consists of 52 questions > that where incorrect from session 6, the previous session, we are now > in a new session, session 7 > > SELECT COUNT() FROM Questions Q > LEFT JOIN Stats S ON S.QuestionId = Q.Id > WHERE

Re: [sqlite] INNER JOIN, JOIN Confusin

Thanks you for all your help! FMI: Is it possible for it to return not distinct pairs also? Thanks again! Igor Tandetnik wrote: > > Cnichols wrote: >> Ok I also tried to think about it from a different approached and >> didnt get the result I wanted ... >> >> SELECT

[sqlite] help : sqlite database restore

Hi Iam new to sqlite, I have a database backup copy with extension trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and need to import this bak file to my local database and has to view the data in the table. can any one help me how to restore the database into my local

Re: [sqlite] SELECT issue with SQLite 3.6.10

First, thank you both for your help ! I'm getting pretty confused : When I execute the query SELECT "GENERAL.ID" FROM VIEW_GENERAL; on SQLite Administrator (which uses an older version of SQLite than 3.6.10), everything works fine, but when I try the same query with SQLite 3.6.10 on command

Re: [sqlite] help : sqlite database restore

On 1/27/09, venkat karri wrote: > Hi > > Iam new to sqlite, I have a database backup copy with extension > trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and > need to import this bak file to my local database and has to view the data > in the

Re: [sqlite] SELECT issue with SQLite 3.6.10

Please supply the SQL TEXT for the TABLE and the VIEW; Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of KurDtE Sent: Tuesday, January 27, 2009 8:41 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SELECT issue with

Re: [sqlite] INNER JOIN, JOIN Confusin

Cnichols wrote: > Igor Tandetnik wrote: >> >> Cnichols wrote: >>> Ok I also tried to think about it from a different approached and >>> didnt get the result I wanted ... >>> >>> SELECT COUNT() FROM Temp >>> WHERE Id IN (SELECT QuestionId FROM Stats

Re: [sqlite] help : sqlite database restore

Hi Kishor, Actually iam working on defect tracking migration from trac to qualitycenter, the trac developers have given me this .bak file, the person who has taken this bak file is no longer with the company, so they asked me to restore the .bak file and see the data, I dont know how its been

Re: [sqlite] SELECT issue with SQLite 3.6.10

KurDtE wrote: > I'm getting pretty confused : > When I execute the query SELECT "GENERAL.ID" FROM VIEW_GENERAL; on > SQLite Administrator (which uses an older version of SQLite than > 3.6.10), everything works fine, but when I try the same query with > SQLite 3.6.10 on command

Re: [sqlite] Adding Custom Column Data Types

We do thisby usig the Sqlite "Declared Type" (which can be anything you choose) and intercepting it in a layer of software between Sqlite and the application language manager. For example we have a decimal number type, a date type etc. The data is stored as Sqlite TEXT or FLOAT but the

Re: [sqlite] help : sqlite database restore

You may want to open the file in a basic text editor to see if it's a SQL dump. The dump will usually have the queries to create the tables and insert data into them. Simon On Tue, Jan 27, 2009 at 11:57 AM, venkat karri wrote: > Hi Kishor, > > Actually iam working on

Re: [sqlite] help : sqlite database restore

Yes it has create queries and insert statements On 1/27/09, Simon wrote: > > You may want to open the file in a basic text editor to see if it's a > SQL dump. The dump will usually have the queries to create the tables > and insert data into them. > > Simon > > On Tue,

[sqlite] SQLite utilty to import XML

Hello, I'm looking for an SQLite utility (Windows / Linux) to import XML files into an SQLite Database (free/open source), so I can use it in a shell script to periodicly search a directory and import the XML files. I tried to find one in: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Re: [sqlite] help : sqlite database restore

On 1/27/09, venkat karri wrote: > Yes it has create queries and insert statements in which case, it is a SQL dump. Read up the help on the .read command or the .import command in the command line sqlite3 program. > > > On 1/27/09, Simon wrote: >

Re: [sqlite] help : sqlite database restore

This morning I had a meeting with the team and found that we also have a db file, could you please send me the complete syntax to import or restore this .db file in sqlite. On 1/27/09, P Kishor wrote: > > On 1/27/09, venkat karri wrote: > > Yes it has

Re: [sqlite] help : sqlite database restore

Venkat, If you have a ".db" file it almost certainly *is* an sqlite database. A great attribute of sqlite databases is that they are contained in a single file. If you're looking for a GUI frontend, they are legion, including good free ones such as sqlite3explorer and a plug-in sqliteManager for

[sqlite] UTF-8 by default?

I haven't found, yet, where it says this but, I assume UTF-8 is the default storage for character strings in the database? I see where I can specify UTF-16*. Is there support for UTF-32? Thanks, J. R. J. R. Westmoreland E-mail: j...@jrw.org

Re: [sqlite] UTF-8 by default?

J. R. Westmoreland wrote: > I haven't found, yet, where it says this but, I assume UTF-8 is the > default storage for character strings in the database? http://sqlite.org/c3ref/open.html The default encoding for the database will be UTF-8 if sqlite3_open() or sqlite3_open_v2() is

Re: [sqlite] help : sqlite database restore

Hi Donald, Thanks for the link thats helpful, How do i access the .db file and read the data... On 1/27/09, Griggs, Donald wrote: > > Venkat, > > If you have a ".db" file it almost certainly *is* an sqlite database. > A great attribute of sqlite databases is that

Re: [sqlite] help : sqlite database restore

On 1/27/09, Griggs, Donald wrote: > > Venkat, > > If you have a ".db" file it almost certainly *is* an sqlite database. > A great attribute of sqlite databases is that they are contained in a > single file. > > If you're looking for a GUI frontend, they are

Re: [sqlite] help : sqlite database restore

Venkat, Sorry. I really intended to quote page: http://www.sqlite.org/sqlite.html Though http://www.sqlite.org/quickstart.html May be helpful as well. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Transaction behavior with large numbers of inserts

I have an application which on a single thread writes data to a database. This writing can result in millions of writes to the database in a single transaction (started with BEGIN TRANSACTION.) I also have other threads and processes which read the same database, but never write to it, and never

Re: [sqlite] Transaction behavior with large numbers of inserts

Nope your not missing anything. Thats how it works. It acquires the lock when it must spill its dirty cache to disk! What happens is the journal file holds the original pages and the new writes (inserts) are written to the db file. So an exclusive lock is taken out by the writing

Re: [sqlite] Transaction behavior with large numbers of inserts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ian Frosst wrote: > My question is; am I assessing the situation correctly, and if so, is there > anything I can do to avoid this rather nasty situation? I would rather not > take the periodic-commit approach, and increasing the page cache size would