[sqlite] 32-bit to 64-bit on Snow Leopard

Hi folks. Just wondering if the tables will remain if I configure SQLite to install the 64 bit version on Snow Leopard over my current 32 bit version. Cheers _ Rich in Toronto ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] SQLite and Java

Dear, I want use SQLite, but my program language is Java. And thewww.sqlite.org not supply API for Java. What should I do? Thank you! Yin Lijie ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

On 2 Aug 2011, at 1:10am, Igor Sereda wrote: > To my humble knowledge, operations with NULL have well-defined semantics, > both in SQL-you-name-it standards and in SQLite. "A < B" may have three > results - TRUE, FALSE and NULL. It doesn't matter whether you can make any > sense of it - it's the

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

Simon, Michael - To my humble knowledge, operations with NULL have well-defined semantics, both in SQL-you-name-it standards and in SQLite. "A < B" may have three results - TRUE, FALSE and NULL. It doesn't matter whether you can make any sense of it - it's the spec ;) Therefore I'm trying to

Re: [sqlite] Will SQLite supports UnQL?

On Sun, Jul 31, 2011 at 12:58, Simon Slavin wrote: These two go together. Multi-master replication (one example of which is a > document store) is relatively easy. Datestamp every value (document) and > whichever one has the lastest date is the one you want. > This is

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

On 1 Aug 2011, at 10:45pm, Black, Michael (IS) wrote: > If it's meaningless then shouldn't it be a syntax error? It's about as meaningless as X <= maxreal so it would take quite a lot of processing time to identify it as meaningless. Not sure as if it's worth the processing time. Any

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

If it's meaningless then shouldn't it be a syntax error? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

On 1 Aug 2011, at 9:47pm, Igor Sereda wrote: > So - who else thinks it's a bug? The SQL standard says 'NULL' means 'I don't know' or 'value missing' or something of the kind. So using a comparison like X > NULL doesn't mean anything, since there can't be a well-ordering principle for a

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

Thanks Jay, That's a good hint about the origin of the problem. However, you refer to the sort order, but the problem is with WHERE statement. Since numeric comparison with NULL always evaluates to NULL (see section 4.0 of the link you gave me), a statement like "SELECT * FROM table WHERE

Re: [sqlite] Will SQLite supports UnQL?

2011/8/1 Simon Slavin : > I'm sorry Alexey, I was trying to be funny and failed.  Your question is very > important for this situation. Oh, I'm sorry! My english is bad by night :) -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

On Mon, Aug 01, 2011 at 12:34:33PM -0700, Igor Sereda scratched on the wall: > > Hello, > > I'm seeing strange input given into xBestIndex method of my virtual table. > > I'm maintaining sqlite4java wrapper and I'm trying to upgrade it from SQLite > 3.7.4 to 3.7.7.1. A couple of failed tests

[sqlite] Virtual Table xBestIndex and NULL Search Conditions (Bug?)

Hello, I'm seeing strange input given into xBestIndex method of my virtual table. I'm maintaining sqlite4java wrapper and I'm trying to upgrade it from SQLite 3.7.4 to 3.7.7.1. A couple of failed tests uncovered that there's a problem when searching a simple virtual table with constraints that

Re: [sqlite] Will SQLite supports UnQL?

On 1 Aug 2011, at 7:20pm, Alexey Pechnikov wrote: > 2011/8/1 Simon Slavin : >> >> On 1 Aug 2011, at 6:56pm, Alexey Pechnikov wrote: >> >>> 2011/8/1 Black, Michael (IS) : This is a side-question to this thread...but has anybody every done

Re: [sqlite] Will SQLite supports UnQL?

2011/8/1 Simon Slavin : > > On 1 Aug 2011, at 6:56pm, Alexey Pechnikov wrote: > >> 2011/8/1 Black, Michael (IS) : >>> This is a side-question to this thread...but has anybody every done >>> row-level locking for edit? >> >> What problem are you

Re: [sqlite] Will SQLite supports UnQL?

On 1 Aug 2011, at 6:56pm, Alexey Pechnikov wrote: > 2011/8/1 Black, Michael (IS) : >> This is a side-question to this thread...but has anybody every done >> row-level locking for edit? > > What problem are you solving? Please stop asking key questions. Simon.

Re: [sqlite] Will SQLite supports UnQL?

2011/8/1 Black, Michael (IS) : > This is a side-question to this thread...but has anybody every done row-level > locking for edit? What problem are you solving? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___

Re: [sqlite] Comments

On 1 Aug 2011, at 2:10pm, Richard Hipp wrote: > On Mon, Aug 1, 2011 at 8:53 AM, Marco Bambini wrote: > >> Why this valid statement: >> >> CREATE TABLE USER( >> id text, -- the id of the user >> nametext-- the name of the user >> ); >> >> gives me

Re: [sqlite] Comments

On Mon, Aug 1, 2011 at 8:53 AM, Marco Bambini wrote: > Why this valid statement: > > CREATE TABLE USER( >id text, -- the id of the user >nametext-- the name of the user > ); > > gives me a syntax error with sqlite 3.7.6.3? > Works for me. > >

Re: [sqlite] Sqlite-Wal file location

I think database will go corrupt if the power goes off during the process of checkpoint. Database will remain intact even if wal file is lost due to power failure. For embedded devices its a balance between flash life, db performance and ram memory usage. Sent from BlackBerry® on Airtel

[sqlite] Comments

Why this valid statement: CREATE TABLE USER( id text, -- the id of the user nametext-- the name of the user ); gives me a syntax error with sqlite 3.7.6.3? Thanks. -- Marco Bambini http://www.sqlabs.com ___

Re: [sqlite] Sqlite-Wal file location

On Mon, Aug 1, 2011 at 8:45 AM, wrote: > Hi, > > Thanks for the detailed explanation. > My original question was more in relation to the .db-wal file. I guess the > same discussion is applicable to the db-wal file also?. In my project, in > all probability one writer and

Re: [sqlite] Sqlite-Wal file location

Hi, Thanks for the detailed explanation. My original question was more in relation to the .db-wal file. I guess the same discussion is applicable to the db-wal file also?. In my project, in all probability one writer and multiple readers. Hence the chances of corruption is greatly reduced. One

Re: [sqlite] Will SQLite supports UnQL?

This is a side-question to this thread...but has anybody every done row-level locking for edit? I can see it: create table t(id int primary key,stuff text, lock l); insert into t values(1,'stuff1',0); select * from t where id=1 and lock=0; // or drop lock to get all and check lock!=0 to

[sqlite] AUTO: Alessandro Azzolini is out of the office (returning 22/08/2011)

I am out of the office until 22/08/2011. Note: This is an automated response to your message "Re: [sqlite] How to convert a database with FTS2 to FTS3/4?" sent on 01/08/2011 4.32.58. This is the only notification you will receive while this person is away.

Re: [sqlite] Sqlite-Wal file location

On Sun, Jul 31, 2011 at 11:51 PM, Sreekumar TP wrote: > Hello, > > Inorder to suit the needs of my embedded device, I have changed the > location > of the .db-wal file from the location of the db file to tmpfs. Does sqlite > make assumptions(persistence etc) based on the

Re: [sqlite] SQLITE_OMIT_UTF16

Where would I use the SQLITE_OMIT_* flags? On Sun, Jul 31, 2011 at 8:06 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/31/2011 09:14 AM, Baruch Burstein wrote: > > I can use Linux if it makes it easier, > > This is how I build which