Path: ...!weretis.net!feeder9.news.weretis.net!news.quux.org!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: p.dean@invalid.net (Peter Dean)
Newsgroups: comp.os.linux.misc,alt.folklore.computers
Subject: Re: The joy of SQL
Date: Sat, 26 Oct 2024 16:35:04 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 9
Sender:  <peter@flo.local>
Message-ID: <vfj5no$3ptrj$1@dont-email.me>
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>   <nv2dnXjQd4-8foT6nZ2dnZfqn_sAAAAA@earthlink.com> <vfcptl$2hjp4$1@dont-email.me> <CCadnQ4B-oXSboT6nZ2dnZfqnPidnZ2d@earthlink.com> <vfebuf$2pkdl$4@dont-email.me> <Os6dnedZ6uqxbof6nZ2dnZfqn_WdnZ2d@earthlink.com> <nCQSO.297925$EEm7.62385@fx16.iad> <lo2as5Fj476U1@mid.individual.net> <vfh6rk$3brp2$9@dont-email.me> <7t6cnTF27tl40YH6nZ2dnZfqnPidnZ2d@earthlink.com> <vfhkrh$3i0mb$2@dont-email.me> <lo3eutFo19fU4@mid.individual.net>
Injection-Date: Sat, 26 Oct 2024 18:35:04 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="34fb30748ab4efa1747173c0eb821ab8";
	logging-data="3995507"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/yBATyduxxIPrVZ16ULiZj"
User-Agent: tin/2.6.3-20231224 ("Banff") (Linux/6.11.5-arch1-1 (x86_64))
Cancel-Lock: sha1:HHRrUi9e22NUur3Wg4s6zY13L9M=
Bytes: 1736

In alt.folklore.computers rbowman <bowman@montana.com> wrote:
 
> 
> It does work well. I was going to look into SpatiaLite but never got 
> around to it. Supposedly the syntax is similar to PostGIS, which would be 
> nice.

It has a very kludgy syntax for the KNN operation. Last time I looked anyway.
Postgis has the <> operator.  I use that a lot.