Hello SQLite users,
and VB sqlite users,
I have just released SQLiteDB, a COM wrapper around sqlite written in ATL. Go get your
copy from http://www.terrainformatica.com/users/george (note that the link will change
in a few days to http://www.terrainformatica.com/SQLiteDB).
You will also get
> I am just wondering if it was done or there is an easy way..
As suggested by Kurt, given a subsequent index from idx = 1 ... N, you may
use color = idx%2 to compute your color.
To work around the problem of insert/delete, I'd try to employ a trigger on
these events to renumber the index
The trigger is a nice idea, but renumbering the index won't work,
since the index might be used as a key to link the record to another
table.. I guess I could use a new index, just for this purpose but
that seems to be a waste of resources..
How do you renumber an index anyway?
Randall Fox
It would be great if you can add the link to your
component in Sqlite wiki. There have been requests
recently posted to this list asking for components
that can be used from VB.
Thanks,
Jalil Vaidya
--- George Ionescu <[EMAIL PROTECTED]> wrote:
> Hello SQLite users,
> and VB sqlite users,
>
>
I reinstalled DBD-SQLite, will that Perl module know which version of
SQLite to use?
On Jul 21, 2004, at 10:37 PM, D. Richard Hipp wrote:
gohaku wrote:
I just installed SQLite v3.0.0.
However, I still have v2.8.11 of the SQLite interpreter ( sqlite ) on
my system.
I would like to know the
Hi everyone,
I apologize in advance if this is not the right place to ask this
question
but I am looking for a webhost that supports PHP and SQLite.
Is there such a webhost or will I have to wait until some webhosts
upgrades to PHP5?
Thanks in advance.
-gohaku
>You are correct that LIKE and GLOB only work for 7-bit ascii
>strings. If you need a LIKE and GLOB that work with Unicode,
>you can register alternative LIKE and GLOB functions using
>the sqlite3_create_function() API.
Yes, I know it can be done that way. BTW, I'm not using Unicode. :)
I meant
I have a database that's been created with 2.8.14 and it has grown to
100M. When I zip it, however, I end up with a file that's about 1M. So
I'd kind of like to try to figure out where all the space is going.
I'd heard there was a tool for analyzing SQLite databases, but I can't
seem to track it
D. Richard Hipp wrote:
SQLite 2.8 and SQLite 3.0 can peacefully coexist. They can even be
linked together into the same binary.
I have just done this for inclusion in the next version of the SQLite DB
Browser, and it works great. The only problem is how to identify the
file format when I open a
On Thu, Jul 22, 2004 at 10:16:34AM -0400, gohaku wrote:
> but I am looking for a webhost that supports PHP and SQLite.
> Is there such a webhost or will I have to wait until some webhosts
> upgrades to PHP5?
I assume you are looking for inexpensive hosting on a shared machine,
but since you are
- Added experimental modify table wizard, since SQLite does not
support the ALTER TABLE SQL command. Use it with care. Works correctly
for all tables originally created in SQLiteBrowser.
Do you manage also the TRIGGERS? (when dropping a table any associated
trigger is lost...)
Paolo
After analyzing my database I see that the average entry size is 381
bytes, which is over the recommended 230 bytes. The average unused
bytes per entry is 961. Also, there are about 8 entries and about
100% of them overflow and about 85% of the overflow pages are unused
space. I'm wondering if
Will Leshner wrote:
I have a database that's been created with 2.8.14 and it has grown to
100M. When I zip it, however, I end up with a file that's about 1M. So
I'd kind of like to try to figure out where all the space is going.
I'd heard there was a tool for analyzing SQLite databases, but I
Two new versions of SQLite are available on the website.
See the news column on the right for details.
http://www.sqlite.org/
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Ok. I think I know what is going on. Each of the rows in my database
is "too big" to fit on the main page (about 320 bytes for each row).
So each one is forcing an overlow page. I'm assuming that each
overflow page only stores one row of data. In other words, the
overflow pages don't share rows as
HI George,
I have tested the SQLiteDB for Visual Basic. I find it to be excellent - it
has raised the standard for VB wrappers exponentially. I will be changing
over all our new applications to this product - please keep it standardized
as I will be posting references to it all over the 'Net.
At 3:03 PM -0300 7/22/04, Mauricio Piacentini wrote:
When I open a SQLite 2.8.x db with sqlite3_open() I do not get any
errors. I can even call sqlite3_exec() on it with some pragma
commands, no errors returned.
However when I attempt to retrieve more info (the table structure) I
get error code
D. Hipp,
is there a 2.8.15 pre-compiled DLL available?? I still couldn't find any =(
Thanks,
Roger Reghin.
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 22, 2004 4:10 PM
Subject: [sqlite] Versions 2.8.15 and 3.0.3
I just discovered that malformed pragma's statements return SQLITE_DONE.
For instance "pragma table_info (foo);"
if table "foo" does not exist, SQLITE_DONE is returned.
Also occurs in completely malformed pragma's like "pragma x;".
Also verified in v.2.8.13
One question:
I'm returning a
Good news. And since Matt hasn't brought it up here yet, I will.
Yesterday, Matt Sergeant posted DBD::SQLite v1.0 on CPAN, which is
the first version to incorporate SQLite v3.x.
Suffice it to say, you actually can start using SQLite 3 in Perl now.
And this means that *I* can now start putting
Matt Sergeant wrote:
On Thu, 22 Jul 2004, D. Richard Hipp wrote:
Two new versions of SQLite are available on the website.
See the news column on the right for details.
http://www.sqlite.org/
Did 3.0.3 have a very negative effect on create/drop table speed? I have a
benchmark in the
Darren Duncan, dando pulos de alegria, escreveu :
That doesn't sound right. sqlite3_open() *should* return an error when
you try opening a 2.x database, citing that the file is not a SQLite
(v3) database file.
I already noticed this, but I think of it as a feature (but it should be
well
Hello everyone!
I need to count the number of occurances of different characters in a
string in my database. So that I can select records where a string
contains a number of occurences of a certain character (independent of
order). I'm not sure if this is easy or hard to accomplish, but I'd
Roger Reghin (Duty/Sedes/CWB) wrote:
D. Hipp,
is there a 2.8.15 pre-compiled DLL available?? I still couldn't find any =(
Thanks,
Roger Reghin.
I have compiled the 3.0.3 DLL as well as 2.8.15 (my first time with the
2.8.x so hopefully its right) and put them on my website:
Fredrik Axelsson <[EMAIL PROTECTED]> writes:
> I need to count the number of occurances of different characters in a string
> in my database. So that I can select records where a string contains a number
> of occurences of a certain character (independent of order). I'm not sure if
> this is easy
Scott Leighton <[EMAIL PROTECTED]> writes:
> On Thursday 22 July 2004 2:40 pm, Darren Duncan wrote:
>> Good news. And since Matt hasn't brought it up here yet, I will.
>>
>> Yesterday, Matt Sergeant posted DBD::SQLite v1.0 on CPAN, which is
>> the first version to incorporate SQLite v3.x.
>>
>>
At 11:22 PM -0400 7/22/04, [EMAIL PROTECTED] wrote:
Scott Leighton <[EMAIL PROTECTED]> writes:
> OK, but what happens to existing sqlite databases we're already
using with Perl? From what I can see, if I update to the new
DBD:SQLite, I'll end up with v 3.x even though all my existing
db's
On Thursday 22 July 2004 8:56 pm, Darren Duncan wrote:
> At 11:22 PM -0400 7/22/04, [EMAIL PROTECTED] wrote:
> >Scott Leighton <[EMAIL PROTECTED]> writes:
> > > OK, but what happens to existing sqlite databases we're already
> >>
> >> using with Perl? From what I can see, if I update to the
On Thu, Jul 22, 2004 at 08:56:50PM -0700, Darren Duncan wrote:
> The simplest answer for both of these is to use DBD::SQLite 0.31 for
> version 2 databases, and DBD::SQLite 1.0 for version 3 databases. If
> you mean, use them both simultaneously, then that's more complicated,
> and I won't go
29 matches
Mail list logo
