Hello everyone,
My aim is to build SQLite for a mips, little endian target
I have downloaded the
http://www.sqlite.org/sqlite-amalgamation-3.6.23.1.tar.gzsqlite-amalgamation-3.6.23.1.tar.gz
from the SQLite download page.
I am using the Code Sourcery gcc 4.3.2 toolchain for mips.
I have
Hello!
The b-tree index is not good choice for high-selective data, but there is no
hash index in SQLite. The hash index will be useful for many new projects
and will optimize a lot of existing applications.
Is anyone interested in this feature?
Best regards, Alexey Pechnikov.
On 5 Apr 2010, at 1:45pm, Alexey Pechnikov wrote:
The b-tree index is not good choice for high-selective data, but there is no
hash index in SQLite. The hash index will be useful for many new projects
and will optimize a lot of existing applications.
Is anyone interested in this feature?
Hello!
On Monday 05 April 2010 16:47:48 Simon Slavin wrote:
Do you have an idea when a tree index should be used, and when a hash index
should be used ? Will you use both all the time, or allow the user to select
which one to use ?
See tests here:
On 04/05/2010 05:45 AM, Alexey Pechnikov wrote:
Is anyone interested in this feature?
Wouldn't it require changing the file format?
Roger
___
sqlite-users mailing list
sqlite-users@sqlite.org
Yep. A big change...
Artur :3
-
Am 05.04.2010, 16:11 Uhr, schrieb Roger Binns rog...@rogerbinns.com:
On 04/05/2010 05:45 AM, Alexey Pechnikov wrote:
Is anyone interested in this feature?
Wouldn't it require changing the file format?
Roger
Hello!
On Monday 05 April 2010 18:11:40 Roger Binns wrote:
Wouldn't it require changing the file format?
It's not required. The FTS3 extension works with current file format
and rtree extension too.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
Yes. I think a couple of hash choices would be a good addition to SQLite.
I posted recently asking about INTERSECT and whether a minimal perfect
hash might be worth consideration for that function.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg51046.html
And a standard sparse hash
Hello!
On Monday 05 April 2010 19:48:06 you wrote:
On Monday 05 April 2010 18:11:40 Roger Binns wrote:
Wouldn't it require changing the file format?
It's not required. The FTS3 extension works with current file format
and rtree extension too.
May be a new interface for virtual indices
On 04/05/2010 10:23 AM, Alexey Pechnikov wrote:
May be a new interface for virtual indices will be best solution. But it
can be realised as virtual table too. Or in SQLite core engine of cource.
Virtual tables already let you implement indices in any way you want - see
the xBestIndex and
Hello!
On Monday 05 April 2010 22:22:40 Roger Binns wrote:
Virtual tables already let you implement indices in any way you want - see
the xBestIndex and xFilter methods. (The former is especially hard to
understand until you have worked with it a bit.)
Now virtual tables performance is bad
On 04/05/2010 12:22 PM, Alexey Pechnikov wrote:
Now virtual tables performance is bad in some useful situations. As example
this query produce full-scan of the FTS3 virtual table 'data':
I don't see what FTS3 has to do with your hash indices, nor do I see
requirements to implement things the
Hello!
On Tuesday 06 April 2010 00:16:32 Roger Binns wrote:
I'd recommend just going ahead and implementing a prototype using the
virtual table API. That would at least allow you to substantiate any
requests for a different/changed API.
Well, it's good for prototype.
Best regards, Alexey
Hello!
This query produce full-scan of the FTS3 virtual table 'data':
sqlite select count(*) from data where rowid in (1);
^CError: interrupted
After 30 minuts I cancel the query.
sqlite explain query plan select count(*) from data where rowid=1;
0|0|TABLE data VIRTUAL TABLE INDEX 1:
sqlite
Hi, sorry to bump this thread, but I thought I'd just try once more to
see
whether anybody might have some insight on the problem I'm having with
Lemon, as detailed in the original post below. I'm sure posts that
languish
on this mailing list quickly get snowed under! I appreciate its not
Looking at this output from gdb:
#0 0x in ?? ()
#1 0x08058f8e in sqlite3_mutex_enter (p=0x90d98c0) at
3rdparty/sqlite3/sqlite3.c:14549
I can say that you don't have any mutex module installed (even a no-op
mutex module). It means that sqlite3_intialize() wasn't called because
mutex
Hi sqlite-users,
I'm looking for an easy way to backup a sqlite3 database while it is in use.
If I could get away with linux 'cp', that'd be easier than
writing c++ code according to the online backup API
(http://www.sqlite.org/backup.html), and also it has the advantage that it
would not
Hi Andy,
Instead of adding the definition
cmd ::= set_item.
have you thought about defining the acceptable alternatives to SET? For
instance,
set ::= SET.
set ::= .
cmd ::= set set_list.
The way you specified it on cmd I think created your problem. By adding
another level it may give the
Just a little logic: if you want some backup mechanism that won't
block writers then what state the backed up database should be in? In
the state that was when backup process started or in the state that
was when backup process ended? If the former then how would you
distinguish file contents that
On Apr 5, 2010, at 5:42 PM, Joshua Redstone wrote:
Hi sqlite-users,
I'm looking for an easy way to backup a sqlite3 database while it is
in use. If I could get away with linux 'cp', that'd be easier than
writing c++ code according to the online backup API
IN( {inlist} ) syntax is not optimized, Alexey.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg49985.html
Regards
Tim Romano
On Mon, Apr 5, 2010 at 3:22 PM, Alexey Pechnikov pechni...@mobigroup.ruwrote:
Hello!
On Monday 05 April 2010 22:22:40 Roger Binns wrote:
Virtual tables
On 5 Apr 2010, at 10:42pm, Joshua Redstone wrote:
I'm looking for an easy way to backup a sqlite3 database while it is in use.
If I could get away with linux 'cp', that'd be easier than
writing c++ code according to the online backup API
(http://www.sqlite.org/backup.html), and also it
Hello,
As you may have already heard, the latest release of Oracle Berkeley DB
now supports SQL, via integration with the SQLite API.
You can read the press release
http://www.oracle.com/us/corporate/press/063695, review the
documentation
Thanks for the responses. I'll probably write a little c++ program to use the
online backup API.
Josh
On Apr 5, 2010, at 3:07 PM, D. Richard Hipp wrote:
On Apr 5, 2010, at 5:42 PM, Joshua Redstone wrote:
Hi sqlite-users,
I'm looking for an easy way to backup a sqlite3 database while it
Hello All.
I'm just looking for a little clarification, or perhaps ratification is a
better word.
I'm writing a line-of-business app for a small business segment, and I need
to be able to provide on-disk encrypted database files. The encryption
doesn't need to be a brick wall, just a hurdle
Is there any helping suggestions on this topic..??
Regards,
Sen
*
*
On 4/5/2010 3:04 PM, Navaneeth Sen B wrote:
Hello everyone,
My aim is to build SQLite for a mips, little endian target
I have downloaded the
26 matches
Mail list logo