RE: [sqlite] sqlite performance questions.

2006-10-18 Thread Robert Simpson
> -Original Message- > From: Mohd Radzi Ibrahim [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 3:23 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite performance questions. > > Hi, > Could you tell me what breaks the transaction? Is create > table/index withi

Re: [sqlite] Extra functions - New Project?

2006-10-18 Thread RohitPatel9999
Mike When are you planning to put code of your SQL functions for SQLite ? Waiting...eagerly... I may try to use it in my app. Thanks Rohit -- View this message in context: http://www.nabble.com/Extra-functions---New-Project--tf1674436.html#a6887312 Sent from the SQLite mailing list archive a

Re: [sqlite] sqlite performance questions.

2006-10-18 Thread Mohd Radzi Ibrahim
Hi, Could you tell me what breaks the transaction? Is create table/index within transaction breaks it? best regards, Radzi. - Original Message - From: "Isaac Raway" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 2:07 AM Subject: Re: [sqlite] sqlite performance questions.

Re: [sqlite] sqlite performance questions.

2006-10-18 Thread Isaac Raway
I'm going to agree with Robert here, I have an application that makes heavy use of large blob of text in a sqlite database. Performance was unbearable, wrapping even small sets of operations in transactions greatly improved the performance. I don't have numbers, but suffice it to say that it went

[sqlite] Best GUI Toolkit. Was: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread drh
FWIW, as all these emails were arriving I was busy working on an application for a customer that consists of 25K+ lines of Tcl/Tk plus some C extensions. The whole thing compiles into a standalone binary that is right at 4MiB. SQLite is used as the application file format. (That is to say, when

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Noel Frankinet
Rob Sciuk a écrit : On Wed, 18 Oct 2006, Rich Shepard wrote: Rob, And, ... there's pysqlite2 which is a teriffic implementation of the python database API. I'm using python, wxPython, and pysqlite2 in our approximate reasoning models. It's a nice system. Rich So many scripting

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Rob Sciuk
On Wed, 18 Oct 2006, Rich Shepard wrote: > Rob, > >And, ... there's pysqlite2 which is a teriffic implementation of the > python database API. > >I'm using python, wxPython, and pysqlite2 in our approximate reasoning > models. It's a nice system. > > Rich So many scripting languages, and s

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Rich Shepard
On Wed, 18 Oct 2006, Rob Sciuk wrote: Or that ... I imagine that the wxPython combination is more modern looking, given the native look and feel of the wxWidget set project, though I've not tried it yet. Hmmm ... note to self ... Rob, And, ... there's pysqlite2 which is a teriffic implemen

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Noel Frankinet
Rich Shepard a écrit : On Wed, 18 Oct 2006, Rob Sciuk wrote: Interesting, but I'm wondering why not use the tcl/tk binding to simply generate the forms using the well crafted tcl binding which comes with the SQLite language? Tcl/TK is a very simple scripting language which is portable to all

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Rob Sciuk
On Wed, 18 Oct 2006, Rich Shepard wrote: > On Wed, 18 Oct 2006, Rob Sciuk wrote: > > > Interesting, but I'm wondering why not use the tcl/tk binding to simply > > generate the forms using the well crafted tcl binding which comes with the > > SQLite language? Tcl/TK is a very simple scripting langu

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Noel Frankinet
<.02$> Interesting, but I'm wondering why not use the tcl/tk binding to simply generate the forms using the well crafted tcl binding which comes with the SQLite language? Tcl/TK is a very simple scripting language which is portable to all major platforms, has a very useful GUI widget set, and w

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Rich Shepard
On Wed, 18 Oct 2006, Rob Sciuk wrote: Interesting, but I'm wondering why not use the tcl/tk binding to simply generate the forms using the well crafted tcl binding which comes with the SQLite language? Tcl/TK is a very simple scripting language which is portable to all major platforms, has a ve

RE: [sqlite] sqlite performance questions.

2006-10-18 Thread Robert Simpson
> -Original Message- > From: Andrew Cheyne [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 8:08 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] sqlite performance questions. [snip] > I have then been writing some sample C programs making use > of the C API, > but hav

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Rob Sciuk
On Wed, 18 Oct 2006, Noel Frankinet wrote: > Date: Wed, 18 Oct 2006 17:23:43 +0200 > From: Noel Frankinet <[EMAIL PROTECTED]> > Reply-To: sqlite-users@sqlite.org > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite GUI app that offers layouts > > Sorry, the correct url is : > > http://www.

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Noel Frankinet
Sorry, the correct url is : http://www.gistek.net/gui.html -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread Noel Frankinet
COS a écrit : Hi Tom, - Original Message - From: "T&B" <[EMAIL PROTECTED]> To: Sent: Tuesday, October 17, 2006 9:47 PM Subject: [sqlite] SQLite GUI app that offers layouts Hi all, There seem to be several SQLite GUI apps around. But I haven't seen any that offer building of lay

[sqlite] sqlite performance questions.

2006-10-18 Thread Andrew Cheyne
Hello, I¹m relatively new to SQLite and have a couple questions centered around performance. I am running SQLite 3.1.3 on Mac OSX 10.4 (this is the version that is pre-installed). I created a very simple database with one Table: sqlite3 test-db "create table Node (NodeId INTEGER PRIMARY KEY,

Re: [sqlite] bail out patch

2006-10-18 Thread drh
Jim Ursetto <[EMAIL PROTECTED]> wrote: > Hi, > > I created a patch which adds "-bail" and ".bail" commands to the sqlite3 > shell. When bail is enabled, the shell will exit with a non-zero return > code immediately upon encountering the first SQL error. This is useful > when you pass a number of

Re: [sqlite] Transactions across attached databases

2006-10-18 Thread drh
"Nakarada, Bob" <[EMAIL PROTECTED]> wrote: > Could someone definitively answer the following question about version > 2.8 of SQLite and transactions on an attached database? > > Is this expected behaviour? > At this point the "expected behavior" of 2.8 is whatever it does. If somebody find

Re: [sqlite] SQLite GUI app that offers layouts

2006-10-18 Thread COS
Hi Tom, - Original Message - From: "T&B" <[EMAIL PROTECTED]> To: Sent: Tuesday, October 17, 2006 9:47 PM Subject: [sqlite] SQLite GUI app that offers layouts > Hi all, > > There seem to be several SQLite GUI apps around. But I haven't seen > any that offer building of layouts, ie posit

[sqlite] Transactions across attached databases

2006-10-18 Thread Nakarada, Bob
Could someone definitively answer the following question about version 2.8 of SQLite and transactions on an attached database? Following is "pseudo code' for the type of transactions we issue. The statement to the table in the attached database sometimes fails with a busy error; the busy wait