2011/8/2 Eric Scouten :
> It falls apart badly in a highly distributed environment where ...
>
> ...
May be a RDF storage is more reasonable for this. Operations with
atomic facts can be highly distributed. And SPARQL is similar to SQL.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
__
Yin,
A Google search of "sqlite java api" gives several good hits.
Click on the first http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
and scroll down to Java
Martin
Am 02.08.2011 06:01, schrieb yinlijie2011:
> Dear,
> I want use SQLite, but my program language is Java. And
> thewww.s
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
http
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
http://sqlite.org:8080/cgi-bin/mailman/lis
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
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 rep
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 perhaps an acceptable ans
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 decent
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 [slav...@bi
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
miss
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 valu
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/
___
sqlite-us
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 unc
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 c
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
row-level locking for edit?
>>>
>>> What prob
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 solving?
>
> Please stop asking key questions.
I don
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.
_
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/
___
sqlite-users mailing list
sql
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 a syntax error with
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.
>
> Thanks.
> --
> Marco
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
-
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
___
sqlite
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 multiple readers. Hence t
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
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 make
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.
__
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 location of the file ?
>
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 also works with grabbing t
28 matches
Mail list logo