Re: [sqlite] ANN: SQLite3 Decimal Extension

2019-04-05 Thread Ian Zimmerman
On 2019-04-03 11:44, Warren Young wrote:

> As for the non-ASCII characters, they're UTF-8, which is the de facto
> standard character set on the Internet since around the time of The
> Bubble.  Ignoring the embedded world, I can't think of an in-support
> OS that doesn't have built-in support for UTF-8.  The only place I'd
> caution against using such characters is in printf() output and such,
> and then only because the Windows Console defaults to UTF-16LE.

The LANG and LC_* environment variables exist for a reason.

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite mailing list

2018-10-09 Thread Ian Zimmerman
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 happens, so that this list *appears* to remain in place,
> even after it's moved to a Fossil forum on the back end.  If that
> happens, I expect such email will be moderated by default.  I'm not
> sure whether it will ever be safe to mark email submissions as not
> needing moderation, due to the ease of email From address forgery.

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? 

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] META: polite plea to the clueful [Was: Web draft problem]

2018-07-20 Thread Ian Zimmerman
On 2018-07-20 17:51, R Smith wrote:

> The Web-site seems to have a bit of an error on the draft pages (which
> may only be because of the draft pages and not matter at all, but I
> thought I'd post it just in case it is something needing attention).

This was wholly unrelated to the post you replied to.  Please keep the
threading tidy by starting a new _thread_ (not just a new Subject) when
appropriate.  Thanks!

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Mailing list shutting down...

2018-06-14 Thread Ian Zimmerman
On 2018-06-14 17:17, Vincenzo Campanella wrote:

> uses googlegroups.com, that then works exactly as a mailing list
> (their mail address is wx-us...@googlegroups.com); perhaps this can
> give you an alternative idea...

It works fine as a mailing list _if_ most (better: all) posters use
it as such.  When you get large number of posts from the Web interface
it gets ugly, with broken threads and such all over.

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Fixes to the transliteration table in ext/misc/spellfix.c

2018-03-30 Thread Ian Zimmerman
On 2018-03-30 11:28, Marcin Ciura wrote:

>   { 0x0426,  0x54, 0x63, 0x00, 0x00 },  /* Ц to Tc */
>   { 0x0446,  0x74, 0x63, 0x00, 0x00 },  /* ц to tc */
> 
> This Cyrillic letter is usually transliterated as Ts.  Unless "Tc" is
> a hack meant to cover both "Ts" and the rarer transliteration "C", it
> looks like a typo: https://en.wikipedia.org/wiki/Tse_(Cyrillic)

Also often as "Cz".  Unfortunately :-P

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] .dump command and user_version

2018-03-29 Thread Ian Zimmerman
On 2018-03-29 12:47, Wout Mertens wrote:

> I noticed that `.dump` does not output the user_version pragma. It
> seems to me that that is part of the database data?

I have run into this too.  I was trying to transport Mozilla browser
"places" database this way, and it turned out their code cares about the
user_version datum and thinks the file is corrupt if the value doesn't
match their expectation.

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] json question

2018-03-27 Thread Ian Zimmerman
On 2018-03-27 19:26, Keith Medcalf wrote:

> Actually, it is very simple and straightforward to implement
> hierarchical structures using Relational Database Models.

But not recursive structures (or to be more precise, recursive queries)
which are the next very natural step.

You can have a "parent" database and you can use it to answer queries
like "all X, Y where X is a parent of Y", "all X, Y where X is a
grandparent of Y", "all X, Y where X is a great-grandparent of Y" etc.
All that with a single table.  But no amount of SQL mastery will allow
you to answer "all X, Y where X is an ancestor of Y".

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Ian Zimmerman
On 2015-10-17 23:57 -0700, Darren Duncan wrote:

> This just happened to me as well.
> 
> I got a direct message with return address alexa at nsadatemail.com like
> Jose described and it looks like a phishing attempt; it had the email
> subject "Re: Re: [sqlite] Sqlite good on Windows XP but very very slow
> on Windows Seven", a post I replied to today.
> 
> Someone on the SQLite mailing list has been hacked and/or a phisher
> has subscribed to the list.

FWIW, it happened to me too, minutes after I _subscribed_ to the list,
without ever having posted.  So I am inclined to think it's a compromise
of the list server itself.

-- 
Please *no* private copies of mailing list or newsgroup messages.
Rule 420: All persons more than eight miles high to leave the court.


[sqlite] crash

2015-10-12 Thread Ian Zimmerman
Please do not "repurpose" (trying to be polite here) threads.  Thanks.

-- 
Please *no* private copies of mailing list or newsgroup messages.
Rule 420: All persons more than eight miles high to leave the court.