On Tue, 9 Oct 2018 10:22:12 -0700
Jens Alfke wrote:
> You could implement a custom query function to do this (custom
> functions are quite simple, and there are examples online).
http://www.schemamania.org/sql/sqlite/udf/
Been there, done that. :-)
--jkl
On Sat, 6 Oct 2018 21:21:38 +0100
Simon Slavin wrote:
> There is never any point in this process when a manager looks at
> what's being done with Excel and says "Okay we need to hire a
> programmer to turn this into a proper App.".
Hmm, there is such a point. I used to do work like that, and
On 9 Oct 2018, at 10:38pm, Keith Medcalf wrote:
> And just what is NSFW spam?
Messages purporting to come from young women. Some including images purporting
to be them in various states of undress.
Simon.
___
sqlite-users mailing list
On Oct 9, 2018, at 3:05 PM, Simon Slavin wrote:
>
> On 9 Oct 2018, at 9:49pm, Warren Young wrote:
>
>> Also: This list may be an unusually juicy target, given the number of places
>> SQLite is deployed.
>
> The minute SQLite gains any sort of internet connectivity, a hundred thousand
>
>One of the problems we’ve been having on these lists is that every
>time someone posts to it, they get NSFW spam, presumably because by
>posting, you’ve just proven that your email address is valid.
>Everyone on the ML sees the poster’s email address. My mailer
>included yours in the quoting
On Oct 9, 2018, at 2:50 PM, Darren Duncan wrote:
>
> On 2018-10-09 12:56 PM, Eric wrote:
>> On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote:
>>> Gmane is part of the problem that lead to the creation of the Fossil
>>> forum feature. Viz., it enables spammers, by design:
>>>
>>>
On Oct 9, 2018, at 1:56 PM, Eric wrote:
>
> I suppose I must be an "anti-forum type" even though I have never used
> Gmane, but it does rather sound as though you are applying a somewhat
> perjorative label here.
I make no value judgement. If you are against web forums, then you are
On 9 Oct 2018, at 9:49pm, Warren Young wrote:
> Also: This list may be an unusually juicy target, given the number of places
> SQLite is deployed.
The minute SQLite gains any sort of internet connectivity, a hundred thousand
man-hours of cracking attempts will be launched. Which is why it's
On 2018-10-09 12:56 PM, Eric wrote:
On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote:
Gmane is part of the problem that lead to the creation of the Fossil
forum feature. Viz., it enables spammers, by design:
http://gmane.org/about/
I don't see that page saying what you claim it
On Oct 9, 2018, at 1:20 PM, Ian Zimmerman wrote:
>
> There are many mailing lists which are not moderated by a human (to my
> knowledge) and do not suffer from this problem. Why? Maybe because
> someone took time to put a well tuned spam filter in place on the MTA
> level?
Would you rather
On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote:
> On Oct 9, 2018, at 7:48 AM, Scott Robison wrote:
>>
>> Isn't Gmane a web forum style interface to email lists?
>
> Gmane also provides NNTP access. I suspect the anti-forum types are
> using Usenet news readers to follow such lists.
On 2018-10-09 11:19, Warren Young wrote:
> Gmane is part of the problem that lead to the creation of the Fossil
> forum feature. Viz., it enables spammers, by design:
>
> http://gmane.org/about/
>
[...]
> It is possible that Fossil will grow an email submission feature
> before that
> On Oct 9, 2018, at 6:47 AM, Leonardo Inácio de Freitas
> wrote:
>
> Using SQLite, can you use masks (or regex) (like '% str%') inside
> instr / substr, to delimit the output of a select, instead of me
> determining the beginning and end of the substring?
You could implement a custom query
On Oct 9, 2018, at 7:48 AM, Scott Robison wrote:
>
> Isn't Gmane a web forum style interface to email lists?
Gmane also provides NNTP access. I suspect the anti-forum types are using
Usenet news readers to follow such lists.
Gmane is part of the problem that lead to the creation of the
well...
It's not quite that categorical "no", although Simon's more than correct.
There's extensions that allow for regexp(), such as you might find in
SQLite Studio that allow for some really handy cross-functionality when
paired with group_concat(), for example. (It's addictive to have it
On 9 Oct 2018, at 2:47pm, Leonardo Inácio de Freitas
wrote:
> Using SQLite, can you use masks (or regex) (like '% str%') inside
> instr / substr, to delimit the output of a select, instead of me
> determining the beginning and end of the substring?
No. Sorry. You have to use string core
On Tue, Oct 9, 2018, 6:34 AM Will Parsons wrote:
> On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote:
> >
> > Many people do not "do" web forums. I am one of them. If there is not
> a mailing list then it does not exist.
>
> I completely agree. I read and post to the SQLite mailing
Hello!
Using SQLite, can you use masks (or regex) (like '% str%') inside
instr / substr, to delimit the output of a select, instead of me
determining the beginning and end of the substring?
What I need (example): SELECT (substr (my_field, like% abc,
until_next_spacechar_after (like% abc))) from
On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote:
>
> Many people do not "do" web forums. I am one of them. If there is not a
> mailing list then it does not exist.
I completely agree. I read and post to the SQLite mailing via Gmane,
and I used to do the same for Fossil. Now that
19 matches
Mail list logo
