-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
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 thread/connect
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
s
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
http://sqlite.org:8080/cgi-bin/mailm
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 legion, including good
> free ones s
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 they are contained in a
> singl
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 called and UTF-
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
_
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
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 create queries and insert statements
>
>
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:
> >
> > You may want to open the file in a
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
B
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, Jan 27, 2009 at 11:57
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 defect tracking migration f
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 interf
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 line, I get :
>
> "G
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 crea
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 WHERE SessionId = 7)
>>>
>>> I expected that to
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 SQL
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 table.
>
> can any one
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 line,
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 ma
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 COUNT() FROM Temp
>> WHERE
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 S.SessionId = 6
> AND S.C
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
Subjec
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? ... also kind
> of confu
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 I forgot to mention that id in temp is not a
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() FROM
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
wi
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
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 SQLit
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 NestedV
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 primitive da
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 news:21685825.p...@tal
"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 a test mode to ask rand
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 VIEW_
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 aske
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 v
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 st
39 matches
Mail list logo