Path: ...!news.roellig-ltd.de!open-news-network.org!weretis.net!feeder8.news.weretis.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: rbowman <bowman@montana.com>
Newsgroups: comp.os.linux.misc,alt.folklore.computers
Subject: Re: The joy of SQL
Date: 26 Oct 2024 06:02:06 GMT
Lines: 26
Message-ID: <lo3eutFo19fU4@mid.individual.net>
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
	<vf5442$sjo3$1@dont-email.me> <20241021075543.00000494@gmail.com>
	<vf6f0q$13ctc$2@dont-email.me> <20241021151652.00005675@gmail.com>
	<vf6n47$14l9a$3@dont-email.me> <lno9vqF368kU2@mid.individual.net>
	<vf6u3q$15nlq$3@dont-email.me> <20241022095931.00001d38@gmail.com>
	<vf93a5$1l20u$6@dont-email.me> <20241022144815.00007ea5@gmail.com>
	<vf98l2$1lsqn$3@dont-email.me> <20241022153631.00002ec9@gmail.com>
	<vfamtn$21039$1@dont-email.me> <vfbo4u$28v56$5@dont-email.me>
	<vfcft1$2ftu7$1@dont-email.me> <vfcgcv$2g0g1$3@dont-email.me>
	<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>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net PMau0cGHed8kNCUIUtbS2gSmjd2y2qXyZLQ6wc42w78guX8v95
Cancel-Lock: sha1:xRLewkAstIB2CSDr+oZPfncyPgI= sha256:jo8NmwruRcDu+8QTu3+y6oLzIFo/gqsx12Tbj97pZb8=
User-Agent: Pan/0.149 (Bellevue; 4c157ba)
Bytes: 2527

On Sat, 26 Oct 2024 02:40:49 -0000 (UTC), Lawrence D'Oliveiro wrote:

> On Fri, 25 Oct 2024 21:58:44 -0400, 186282@ud0s4.net wrote:
> 
>> On 10/25/24 6:41 PM, Lawrence D'Oliveiro wrote:
>>
>>> On 25 Oct 2024 19:46:13 GMT, rbowman wrote:
>>> 
>>>> My personal hell is database programming.
>>> 
>>> I’ve done a bunch of it. Interfacing to SQL from Python can be done
>>> quite elegantly, just for example.
>>> 
>>> What, you thought I was using PHP?
>> 
>> What about pre/no-SQL DBs ?
> 
> Don’t use them.
> 
> SQLite is so powerful and so resource-light (as per its name), what
> point is there in using anything less?


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.