Consider query below;
SELECT key
FROM t1
LEFT JOIN (
SELECT key,max(rev),data
FROM t2
WHERE rev < ?
GROUP BY key
) USING (key)
ORDER BY key ?
LIMIT ?
In above query sqlite will materialize the t2-sub-query and then start
working on the outer query. I have a lot of data in t2 so this will
Hi,
Is it possible to call a java function from a trigger in SQLite? If so, is
there an example showing how to do it?
Thanks,
Faria
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
On Sat, 28 Sep 2019 at 06:59, Roman Fleysher
wrote:
> ( somewhat related to Re: [sqlite] Safe to use SQLite over a sketchy
> network?)
>
> Dear SQLiters,
>
> I am using SQLite over GPFS distributed file system. I was told it
> honestly implements file locking. I never experienced corruption. But
> On Sep 29, 2019, at 5:05 PM, Faria wrote:
>
> Is it possible to call a java function from a trigger in SQLite?
Yes, but you'd have to implement a C function that calls the Java function via
JNI, then register the C function with SQLite, then call that function in your
trigger.
—Jens
You mean something like this:
select key,
maxrev,
data
from (
select key,
null as maxrev,
null as data
from t1
where key not in (select key
from t2
Or this, which is even simpler:
select t1.key,
max(t2.rev) as maxrev,
t2.data
from t1
left join t2
on t1.key == t2.key
and rev < :rev
group by t1.key
order by t1.key;
--
The fact that there's a Highway to Hell but only a Stairway to Heaven says
Hello,
The fts5 table in your database was created with a custom FTS5 tokenizer
named "TrackerTokenizer" (see
https://www.sqlite.org/fts5.html#custom_tokenizers).
Custom FTS5 tokenizers must be registered in each SQLite connection to the
database file, or you get an error like "no such
On Sun, Sep 29, 2019 at 2:13 PM Keith Medcalf wrote:
> On Sunday, 29 September, 2019 01:28, Gwendal Roué
> wrote:
> >Those N reader connections allow concurrent database reads. Those "reads"
> are
> >generally wrapped in a deferred transaction which provides snapshot
> >isolation.
>
> No, it
On 9/30/19 4:28 AM, Gwendal Roué wrote:
> According to
> http://dbmsmusings.blogspot.com/2019/06/correctness-anomalies-under.html,
> SNAPSHOT ISOLATION is stronger than REPEATABLE READ, in that it prevents
> "phantom reads" (
>
According to
http://dbmsmusings.blogspot.com/2019/06/correctness-anomalies-under.html,
SNAPSHOT ISOLATION is stronger than REPEATABLE READ, in that it prevents
"phantom reads" (
http://dbmsmusings.blogspot.com/2019/05/introduction-to-transaction-isolation.html).
I think SQLite prevents phantom
On Monday, 30 September, 2019 02:06, Dominique Devienne
wrote:
>On Sun, Sep 29, 2019 at 2:13 PM Keith Medcalf wrote:
>> On Sunday, 29 September, 2019 01:28, Gwendal Roué
>> wrote:
>> >Those N reader connections allow concurrent database reads. Those
>> "reads" are generally wrapped in a
On Mon, Sep 30, 2019 at 2:07 PM Keith Medcalf wrote:
> On Monday, 30 September, 2019 02:06, Dominique Devienne <
> ddevie...@gmail.com> wrote:
> >On Sun, Sep 29, 2019 at 2:13 PM Keith Medcalf
> wrote:
> >> On Sunday, 29 September, 2019 01:28, Gwendal Roué <
> gwendal.r...@gmail.com> wrote:
>
>
12 matches
Mail list logo