Re: [sqlite] Problem in cross compiling sqlite for MIPS Little endian target

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 >

[sqlite] Encryption implementation from System.Data.SQLite

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

Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

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

[sqlite] Oracle Berkeley DB now supports the SQLite API

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 , review the documentation

Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

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

Re: [sqlite] Feature request: hash index

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 wrote: > Hello! > > On Monday 05 April 2010 22:22:40 Roger Binns wrote: > > Virtual

Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

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 >

Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

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

Re: [sqlite] Question about lemon

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

[sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

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

Re: [sqlite] ?bug causing sigsegv

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

Re: [sqlite] Question about lemon

> 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

[sqlite] Virtual Tables problem with queries like to "rowid in (...)"

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>

Re: [sqlite] Feature request: hash index

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,

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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/

Re: [sqlite] Feature request: hash index

Yep. A big change... Artur :3 - Am 05.04.2010, 16:11 Uhr, schrieb Roger Binns : > 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 >

Re: [sqlite] Feature request: hash index

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

Re: [sqlite] Feature request: hash index

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:

Re: [sqlite] Feature request: hash index

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

[sqlite] Feature request: hash index

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.

[sqlite] Problem in cross compiling sqlite for MIPS Little endian target

Hello everyone, My aim is to build SQLite for a mips, little endian target I have downloaded the sqlite-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