Re: [sqlite] ANN: SQLite3 Decimal Extension
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
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]
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...
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
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
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
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
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
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.