> -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
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
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.
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
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
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
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
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
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
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
<.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
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
> -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
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.
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]
--
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
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,
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
"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
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
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
21 matches
Mail list logo