On Tue, 2007-06-19 at 11:51 -0700, Gerry Snyder wrote:
> Michael Hooker wrote:
> > Many thanks for the explanation Dan.
> Ditto the thanks.
> > I suspected the purpose of ROLLBACK was as you say, but couldn't see
> > why it was used here. You point out the "under the hood" difference
> > betwe
On Tue, 2007-06-19 at 15:39 -0400, Igor Tandetnik wrote:
> Shane Harrelson
> <[EMAIL PROTECTED]> wrote:
> > To use pragmas from code, do I simply prepare them as a regular SQL
> > statement and then execute them?
>
> Yes.
Another thing to note: Some pragmas take effect during
sqlite3_prepare(),
Very informative. Thank you.
Jeff
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 19, 2007 8:59 PM
Subject: Re: [sqlite] Tcl and BLOB data
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
I don't really understand why, when my data has a binary
representation an
At 20:47 19/06/2007 -0500, John Stanton wrote:
Such a server can be made simpler then mine by making it single threaded.
Is it publicly available from http://www.viacognis.com?
Thanks
G.
-
To unsubscribe, send email
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
>
> I don't really understand why, when my data has a binary
> representation and I'm trying to place it in a BLOB field,
> the string representation is used instead (assuming it exists).
>
I wrote up a terse explanation on the Tclers wiki. See
htt
Gilles Ganault wrote:
At 16:49 19/06/2007 -0700, Medi Montaseri wrote:
While its difficult to tell what the problem statement (or context)
is, but the ingrediants like HTTP and POST spells SOAP.
The context is that, until now, our apps were almost used on stand-alone
hosts with only a few c
Gilles Ganault wrote:
At 11:20 19/06/2007 -0400, Clay Dowling
wrote:
I'm going to recommend PostgreSQL.
Thanks for the idea, but if possible, we'd rather something really
basic, typically a single EXE. Besides, using eg. PostgreSQL would
require rewriting our application.
I went throug
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 19, 2007 3:43 PM
Subject: Re: [sqlite] Tcl and BLOB data
I did this change at your request, because it seemed like
a good enhancement.
Thanks. I agree, it sounds like a good enhancement. Though, I don't
reall
At 16:49 19/06/2007 -0700, Medi Montaseri wrote:
While its difficult to tell what the problem statement (or context) is,
but the ingrediants like HTTP and POST spells SOAP.
The context is that, until now, our apps were almost used on stand-alone
hosts with only a few customers hosting the (sma
While its difficult to tell what the problem statement (or context) is,
but the ingrediants like HTTP and POST spells SOAP.
-Original Message-
From: Gilles Ganault [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 4:32 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Recommend s
At 11:20 19/06/2007 -0400, Clay Dowling
wrote:
I'm going to recommend PostgreSQL.
Thanks for the idea, but if possible, we'd rather something really basic,
typically a single EXE. Besides, using eg. PostgreSQL would require
rewriting our application.
I went through the list of servers on t
Thank you, Gerry.
So basically, it seems, ROLLBACK, COMMIT or END would all do nicely in this
particular context. Hopefully I'll never need to worry about locking etc
because I have no intention of changing the data in the database and far> I've successfully managed to extract what I want from
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
> Interesting. That sounds like exactly what I need. I'm curious, did
> the patch somehow arise from my query, or is the timing of the query
> and the patch just coincidental?
>
> Also, how soon would you expect this patch to make it into an
> "offici
Interesting. That sounds like exactly what I need. I'm curious, did
the patch somehow arise from my query, or is the timing of the query
and the patch just coincidental?
Also, how soon would you expect this patch to make it into an
"official build"? I've never built SQLite from the sources
Shane Harrelson
<[EMAIL PROTECTED]> wrote:
To use pragmas from code, do I simply prepare them as a regular SQL
statement and then execute them?
Yes.
And when can they/should they be done? As the first statement after
an open?
Some pragmas have to be set early, others may be changed at any
To use pragmas from code, do I simply prepare them as a regular SQL
statement and then execute them?
And when can they/should they be done? As the first statement after an
open?
Are the pragma values stored with the database? Or do they have to be
issued after each open?
Thanks.
-Shane
Michael Hooker wrote:
Many thanks for the explanation Dan.
Ditto the thanks.
I suspected the purpose of ROLLBACK was as you say, but couldn't see
why it was used here. You point out the "under the hood" difference
between ROLLBACK and COMMIT, but what about END? My main (third-party,
commer
1. Review your oracle 10g db and fix the "HUGE I/O" issues.
2. Why not do the lookups using oracle? Allocate the extra 5 gig to the oracle
buffer cache.
3. If you want good lookup performance, try to use the Array level interface
so that you don't need to take multiple trips (context switch) t
Can you consolidate your multiple binaries to a Single Binary?
Then Use threading and sqlite's shared caching to perform the Lookups and
updates.
That way the cache wouldn't get invalidated???
Someone else here correct me if this is a bad idea!!!
pompomJuice <[EMAIL PROTECTED]> wrote:
I
DLL version
Sqlite3.3.17
The os is windows
After the last query of sqlite3_step
I decided to so some more tests, with threads, if synchronized properly,
it seems that you can use more than one thread without any problem as
long as
Sqlite3_finalize is called is this correct?
Ple
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
>
> Is there a way I can "force" SQLite to insert my data as a BLOB, even if the
> containing variable has a string representation? I tried to CAST the data to
> a BLOB during the insert, but the results were the same.
>
If you get the patch I just ch
Hi All,
I have an interesting Tcl / SQLite BLOB issue going on that I hope you can help
with...
I have binary data stored in a Tcl variable that I'm stuffing into SQLite BLOB
field. The resulting data in the BLOB field is corrupted. After much
experimentation, and help from the folks on comp
Just some observations after reading mail on this forum.
It is wise when using Sqlite to design your database and application to
work to the strengths, not weaknesses of Sqlite. Be aware that Sqlite
only uses one index per table in a query and that it's cache is tied to
a connection. If you
T&B wrote:
In case the original question has been clouded by discussions of
running a general store and the arson habits of the Hand Crafted
Guild, allow me to crystalize my purely SQLite question:
I know I can update via:
update Table1
set
c1 = (select d1 from Table2 where Table2
Does every single process (however insignificant) that reads or writes
to that sqlite database file run on the same 16 processor machine?
> 16 Processor machine
> ~40Gb ram
> EMC storage
> Running a huge Oracle 10G database
> Running a 3rd party application that generates HUGE IO.
> Part of this
We have implemented a decimal arithmetic module to handle money in
Sqlite. It uses the regular SQL definitions and maintains precison and
scale. The data are stored as TEXT and in "display format", right
aligned with leading spaces so that they display without editing or
radix transformation
On 6/19/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
I had lots of problems here when starting with SQLite and painstaking I
think I've figured it out.
Me too.
You have sqlite3_prepare, which compiles the sql into byte code, then
Sqlite3_step to execute the query or update, if it is an u
Gilles Ganault wrote:
> We'd really like to stick to SQLite because it's very easy to set up, and
> most of our customers don't have anyone technical around to help them set
> up a DBMS server.
I'm going to recommend PostgreSQL. It's very easy to install from your
application's installer and qu
I hear you.
If nothing else works then I will have to switch to using Oracle. it would
require a substancial code rewrite though. sigh.
Thanks for the adice.
Andrew Finkenstadt wrote:
>
> On 6/19/07, pompomJuice <[EMAIL PROTECTED]> wrote:
>>
>>
>> Running a huge Oracle 10G database
>> Running
Hello
Until now, our users were mostly single-hosts, and the few who did share
an SQLite database through a shared drive had a small database and very low
concurrency. But a couple of new ones have a DB that's about 50MB, running
on a 10Mbps LAN... and an INSERT takes about 10 seconds :-/
S
Many thanks for the explanation Dan. I suspected the purpose of ROLLBACK
was as you say, but couldn't see why it was used here. You point out the
"under the hood" difference between ROLLBACK and COMMIT, but what about END?
My main (third-party, commercial) application may well have some data s
On 6/19/07, pompomJuice <[EMAIL PROTECTED]> wrote:
Running a huge Oracle 10G database
Running a 3rd party application that generates HUGE IO.
Part of this 3rd party application is my application that does lookups.
1.) Data comes in in the form of files.
2.) 3rd party application decodes and pr
Thats exactly why I thought this sqlite would work.
16 Processor machine
~40Gb ram
EMC storage
Running a huge Oracle 10G database
Running a 3rd party application that generates HUGE IO.
Part of this 3rd party application is my application that does lookups.
1.) Data comes in in the form of file
John Elrick wrote:
I've been using the Delphi ASGSqlite components with static linking
for some time with version 3.3.13. I'd like to move on up to 3.4.0,
however, no one seems to have documented how to do this yet.
I tried compiling the Amalgamation with Borland C++ 5.0 and it
generates the
wcmadness <[EMAIL PROTECTED]> wrote:
I'm writing a financial application and MUST have exact math decimals
(no floats). So, I'm using Python's decimal module.
My database is Sqlite (and my language is Python with Pysqlite);
Sqlite doesn't offer a non-floating point decimal type. But, it does
hav
pompomJuice uttered:
I suspected something like this, as it makes sense.
I have multiple binaries/different connections ( and I cannot make them
share a connection ) using this one lookup table and depending on which
connection checks first, it will update the table.
What is your working se
Uma Krishnan uttered:
Hey, There's no need to be offensive. I did not mean to be critical. Far
from it, it does a great a job (far more than I'm capable of producing).
What I was trying to find out was, if it is possible for a .y files to
be broken such that it can be built on top on other .y
> My question is then, if any one connection makes any change to the database
> ( not neccesarily to the huge lookup table ) will all the other connections
> invalidate their entire cache?
Yes. The entire cache, regardless of what table was modified etc.
Dan.
I suspected something like this, as it makes sense.
I have multiple binaries/different connections ( and I cannot make them
share a connection ) using this one lookup table and depending on which
connection checks first, it will update the table.
My question is then, if any one connection makes
wcmadness wrote:
Hey, Folks:
I'm writing a financial application and MUST have exact math decimals (no
floats). So, I'm using Python's decimal module.
My database is Sqlite (and my language is Python with Pysqlite); Sqlite
doesn't offer a non-floating point decimal type. But, it does have ad
Hello
I'm doing a bulk insert by calling
sqlite3 -init BulkinsertItems.sql mydatabasefile
with the BulkinsertItems.sql file containing:
.separator \t
.import BulkItems.txt items
.quit
The command window opens and the import works, but then it does not close
again.
How can I have this clsoe aut
On Tue, 2007-06-19 at 09:42 +0200, Roberto Davico wrote:
> Hi all,
>
>I am Roberto and I find a problem using sqlite3 (version: SQLite
> version 3.3.8).
>
>I make a sample db to explain the situation:
>
>1) Create the sample database using command line tool:
>
> sqlite> .schema
> C
On Tue, 2007-06-19 at 01:06 -0700, pompomJuice wrote:
> Hello there.
>
> I need some insight into how SQLite's caching works. I have a database that
> is quite large (5Gb) sitting on a production server that's IO is severely
> taxed. This causes my SQLite db to perform very poorly. Most of the tim
I had lots of problems here when starting with SQLite and painstaking I
think I've figured it out.
You have sqlite3_prepare, which compiles the sql into byte code, then
Sqlite3_step to execute the query or update, if it is an update then
there is no row, if query then call step until no more rows
When I pressed post message it told me "read error" Connection reset or
something and after the third time I thought I'd restart my browser only to
see that it did post 3 times!.
--
View this message in context:
http://www.nabble.com/Sorry-about-the-multiple-threads...-tf3944931.html#a11190427
Hello there.
I need some insight into how SQLite's caching works. I have a database that
is quite large (5Gb) sitting on a production server that's IO is severely
taxed. This causes my SQLite db to perform very poorly. Most of the time my
application just sits there and uses about 10% of a CPU wh
Hello there.
I need some insight into how SQLite's caching works. I have a database that
is quite large (5Gb) sitting on a production server that's IO is severely
taxed. This causes my SQLite db to perform very poorly. Most of the time my
application just sits there and uses about 10% of a CPU wh
Hello there.
I need some insight into how SQLite's caching works. I have a database that
is quite large (5Gb) sitting on a production server that's IO is severely
taxed. This causes my SQLite db to perform very poorly. Most of the time my
application just sits there and uses about 10% of a CPU wh
Hi all,
I am Roberto and I find a problem using sqlite3 (version: SQLite
version 3.3.8).
I make a sample db to explain the situation:
1) Create the sample database using command line tool:
sqlite> .schema
CREATE TABLE LOG (ID INTEGER PRIMARY KEY AUTOINCREMENT, MSG TEXT );
CREATE TABLE
49 matches
Mail list logo