RE: [sqlite] sqlite performance questions.

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

Re: [sqlite] Extra functions - New Project?

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

Re: [sqlite] sqlite performance questions.

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

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

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

RE: [sqlite] sqlite performance questions.

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

COS a écrit : Hi Tom, - Original Message - From: "T" <[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

[sqlite] sqlite performance questions.

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

Re: [sqlite] bail out patch

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

Re: [sqlite] Transactions across attached databases

"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

Re: [sqlite] SQLite GUI app that offers layouts

Hi Tom, - Original Message - From: "T" <[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

[sqlite] Transactions across attached databases

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