Re: [sqlite] Tcl and BLOB data

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

Re: [sqlite] Recommend server for Windows?

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

Re: [sqlite] Recommend server for Windows?

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

Re: [sqlite] Tcl and BLOB data

- 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

RE: [sqlite] Recommend server for Windows?

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

RE: [sqlite] Recommend server for Windows?

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

Re: [sqlite] Recommend server for Windows?

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

Re: [sqlite] Proper way to transfer a live sqlite database

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

Re: [sqlite] Tcl and BLOB data

"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 >

Re: [sqlite] Tcl and BLOB data

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

[sqlite] Re: How to use pragmas from code?

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

[sqlite] How to use pragmas from code?

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

Re: [sqlite] Proper way to transfer a live sqlite database

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,

Re: [sqlite] Cache invalidation after insert statements.

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)

Re: [sqlite] Cache invalidation after insert statements.

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:

[sqlite] More SQLite Misuse

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?

Re: [sqlite] Tcl and BLOB data

"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

Re: [sqlite] Cache invalidation after insert statements.

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

Re: [sqlite] Custom Aggregation Not Working

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

Re: [sqlite] Step Query

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

Re: [sqlite] Recommend server for Windows?

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

[sqlite] Recommend server for Windows?

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 :-/

Re: [sqlite] Proper way to transfer a live sqlite database

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

Re: [sqlite] Cache invalidation after insert statements.

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

Re: [sqlite] Cache invalidation after insert statements.

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

Re: [sqlite] Need help linking into Delphi Application

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

[sqlite] Re: Custom Aggregation Not Working

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

Re: [sqlite] Cache invalidation after insert statements.

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

Re: [sqlite] Lemon Parser - Modular & Extensible ?

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

Re: [sqlite] Cache invalidation after insert statements.

> 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.

Re: [sqlite] Cache invalidation after insert statements.

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

Re: [sqlite] Custom Aggregation Not Working

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

[sqlite] How do I close the command line window

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

Re: [sqlite] problems with .dump procedure

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 >

RE: [sqlite] Step Query

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

[sqlite] Sorry about the multiple threads...

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:

[sqlite] SQLite cache question.

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

[sqlite] Cache invalidation after insert statements.

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

[sqlite] Cache invalidation after insert statements.

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

[sqlite] problems with .dump procedure

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