Hello, think I got it, but it is disappointingly simple, see below. Ed.
Markus Gritsch wrote:
Even more strange:
c.execute("""SELECT * FROM entry, word, word_entry WHERE
entry.id = word_entry.entry_id AND
word.id = word_entry.word_id AND
word.word GLOB ?
""", ('tes*',))
takes less than
Hello,
Now I'm using SQLite v3.4.2 in my Mobile Device(ARM9-200Mhz, 8MB SRAM)
and it works fine.
But when I updated to SQLitev3.5.3 this time I am facing problem.
Please let me know why it is happening.
This is my test source in MS's VisualC++ 6.0 (Console application).
On Sun, 9 Dec 2007 23:34:44 +0100, DJ Anubis
<[EMAIL PROTECTED]> wrote:
>Le dimanche 9 décembre 2007, Gilles Ganault a écrit :
>> It seems like I have two options:
>> - calling the SQLite library
>> - going through the PDO interface, and its SQLite module.
>>
>> Which of the two would you
At 23:34 09/12/2007 +0100, DJ Anubis wrote:
I would recommend using PDO interface, as this is the standard PHP5 API.
Don't worry about PHP4, as this old version will no more be supported soon...
Thanks for the tip.
-
Le dimanche 9 décembre 2007, Gilles Ganault a écrit :
> It seems like I have two options:
> - calling the SQLite library
> - going through the PDO interface, and its SQLite module.
>
> Which of the two would you recomend? Are there other options I
> should know about?
I would recommend using PDO
Hello
I'm not a PHP expert, and need to work with SQLite from PHP scripts on a
CentOS 5.1 server (from the command line, and web apps in FastCGI).
It seems like I have two options:
- calling the SQLite library
- going through the PDO interface, and its SQLite module.
Which of the two would
Hello,
someone could please help me... I try to build SQLite3VB, following exactly
the
instruction on the page: http://www.tannertech.net/sqlite3vb/
but at the end of the build process, I get allways the same error, like
this:
Linking...
sqlite3.def : error LNK2001: unresolved external
Thanks,
I thought that this might properly a bigger thing. Well, I found a
solution which fits my purpose at the moment. ( SELECT txt FROM test
WHERE txt=(SELECT max(CAST(txt AS REAL)) from test) )
I do not use selection of max() or min() very often - it seems it is the
best suiting
We built a fixed point arithmetic library using text strings. The
format stored is right justified, leading space filled decimal numbers
with embedded decimal points and leading sign. The purpose of that is
not for arithmetic efficiency but so that they can be directly output
into a printed
On 09/12/2007, Markus Gritsch <[EMAIL PROTECTED]> wrote:
> On 09/12/2007, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> >
> > SQLite will optimize a GLOB where the right parameter is
> > a literal string. It will not do so if the right parameter is a
> > parameter.
On 09/12/2007, Mag. Wilhelm Braun <[EMAIL PROTECTED]> wrote:
> hi Markus,
Hi Wilhelm
> I just tried for fun:
>
> start = time.time()
> SQLString=('''SELECT * FROM entry, word, word_entry WHERE
> entry.id = word_entry.entry_id AND
> word.id = word_entry.word_id AND
> word.word GLOB '%s'
> '''
On 09/12/2007, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Dec 9, 2007, at 5:27 AM, Kees Nuyt wrote:
>
> > Problematic SELECT:
> >> c.execute("""SELECT * FROM entry, word, word_entry WHERE
> >> entry.id = word_entry.entry_id AND
> >> word.id = word_entry.word_id AND
> >> word.word GLOB ?
hi Markus,
I just tried for fun:
start = time.time()
SQLString=('''SELECT * FROM entry, word, word_entry WHERE
entry.id = word_entry.entry_id AND
word.id = word_entry.word_id AND
word.word GLOB '%s'
''' % "hui*")
c.execute(SQLString)
and it is as fast as your first one - seems a pysqlite
On Dec 9, 2007, at 5:27 AM, Kees Nuyt wrote:
Problematic SELECT:
c.execute("""SELECT * FROM entry, word, word_entry WHERE
entry.id = word_entry.entry_id AND
word.id = word_entry.word_id AND
word.word GLOB ?
""", ('hui*',))
SQLite will optimize a GLOB where the right parameter is
a
Thanks Stanton,
could you elaborate a bit on that - I'm not sure if I get exactly what
you mean.
if you have a smallish example would be great. the help from 'Igor
Tandetnik' with cast is a good starting point - but on selections with
max or min I still get the incorrect rounded numbers
It does not, but you can attach triggers to a view to achieve the same
effect.
> -Ursprüngliche Nachricht-
> Von: Robert Smith [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 9. Dezember 2007 08:31
> An: sqlite-users@sqlite.org
> Betreff: [sqlite] Does SQLite support modifying date
Wilson, Ron uttered:
It has been a very long time since I have tinkered with lex/yacc but my
current project requires a parser. I'm thinking of learning lemon.
Frankly, the sqlite code base is far more complex than what I will
implement. Is anyone willing to share a lemon parse.y code
On 09/12/2007, Kees Nuyt <[EMAIL PROTECTED]> wrote:
> On Sun, 9 Dec 2007 10:55:16 +0100, "Markus Gritsch"
> <[EMAIL PROTECTED]> wrote:
>
> >Hi,
> >
> >when using bind variables I get a huge performace drop compared to
> >using a plain string. The query is demonstrated in the attached file
>
On Sun, 9 Dec 2007 10:55:16 +0100, "Markus Gritsch"
<[EMAIL PROTECTED]> wrote:
>Hi,
>
>when using bind variables I get a huge performace drop compared to
>using a plain string. The query is demonstrated in the attached file
>"problematic_query.py".
Problematic SELECT:
> c.execute("""SELECT *
Hi,
when using bind variables I get a huge performace drop compared to
using a plain string. The query is demonstrated in the attached file
"problematic_query.py".
The database used can be downloaded from
http://xile.org/le/prepared_statement.zip (1.75 MB)
or generated by using the attached
On Sat, 8 Dec 2007 23:31:16 -0800 (PST), Robert Smith
<[EMAIL PROTECTED]> wrote:
>I am trying to implement an embedded application using SQLite. I need to
>modify data through views. The update, insert, or delete operations may
>refer to a computed column or a built-in function in a view. I
21 matches
Mail list logo