Re: [sqlite] Incompatibility into configure.ac

On 04/04/2017 23:20, Richard Hipp wrote: On 4/4/17, Pavel Volkov wrote: The "+ =" operator works as you would expect in bash only. And it causes an error in the Bourne shell, for example. You have piqued my curiosity. Who is still using Bourne shell instead of

Re: [sqlite] Incompatibility into configure.ac

On 05/04/2017 19:23, Richard Hipp wrote: On 4/4/17, Jens Alfke wrote: The issue here seems to be that some scripts in the SQLite source distribution are _implicitly_ assuming that the default shell is bash, or else that ‘sh’ is an alias of bash. The best fix, IMHO, would

Re: [sqlite] Macro expansion of B0 on Linux PPC system

On 19/12/2017 13:55, Richard Hipp wrote: On 12/18/17, Lee, Greg wrote: I am still seeing the problem on Power 8 and others report the problem persists on Power 9. Please see the spack github issue. I also attached a configure/make output if that helps. So, what you are

Re: [sqlite] Macro expansion of B0 on Linux PPC system

On 19/12/2017 13:55, Richard Hipp wrote: On 12/18/17, Lee, Greg wrote: I am still seeing the problem on Power 8 and others report the problem persists on Power 9. Please see the spack github issue. I also attached a configure/make output if that helps. So, what you are

Re: [sqlite] Many ML emails going to GMail's SPAM

On 22/11/2017 01:30, Richard Hipp wrote: On 11/21/17, Paul Sanderson wrote: Coincidence! I have just been in my gmail folder marking a load of SQLite email as 'not spam' I've been seeing mailing list emails go to spam for a while now. Nothing has changed with

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

On 14/06/2018 23:05, Richard Hipp wrote: On 6/13/18, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now Mailing lists are now back on-line and once again accepting

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

On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now. Your suggestions are welcomed. This mailing list has operated for many years using GNU MailMan.

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

On 14/06/2018 03:37, John Long wrote: On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: This is an increasing problem, and has been discussed on the Mailman mailing list recently, you should join them and see what mitigation strategies are available. Well I'm sure he would like

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

On 13/06/2018 21:42, Gary R. Schmidt wrote: On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment.  I am working to come up with a fix or an alternative now.  Your suggestions are welcomed. This mailing list has

Re: [sqlite] UTF8 and NUL

On 27/01/2018 00:55, Peter Da Silva wrote: What is the goal of this discussion? Changing the string terminator SQLite uses? I think it's almost 50 years too late for that, but I'm sure that if Unicode and UTF8 had been a thing in 1970 then C would have selected FF as the string terminator.

Re: [sqlite] UTF8 and NUL

On 27/01/2018 05:32, Peter Da Silva wrote: On 1/26/18, 12:31 PM, "sqlite-users on behalf of J Decker" wrote: ctrl-z was end of file text character in DOS (wrote char 26; not FF) DOS wasn't an operating system.

Re: [sqlite] SQLite 3.24.0 Solaris 9 build failure

On 2018-07-28 08:33, Andy Goth wrote: SQLite 3.24.0 fails to build on Solaris 9 (a.k.a. Solaris 2.9) due to not finding fchmod, fchown, readlink, lstat, usleep, struct timeval, and gettimeofday. To correct, do not #define _XOPEN_SOURCE. There's already a check for Mac OS X, so I would suggest

Re: [sqlite] SQLite mailing list

On 13/10/2018 16:28, Balaji Ramanathan wrote: 8. Re: sqlite-users Digest, Vol 130, Issue 11 (Shawn Wagner) On Thu, 11 Oct 2018 09:51:15 -0500, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: 2. Re: SQLite mailing list The 1990's called and they want their mailing lists

Re: [sqlite] Regarding CoC

On 26/10/2018 14:12, Philip Warner wrote: On 25/10/2018 9:59 PM, Mike King wrote: I’m a good atheist but I love the CoC. Not bothered by the religious bits but I get the sentiment. I guess it appeals to my British sense of irony and odd sense of humour :) I agree with the humour. As a

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 10/10/2018 22:20, Petite Abeille wrote: [SNIP] ( Also, fwiw: please keep the mailing list, it's perfectly functional as is. ) Seconded. It isn't broken, so please don't try and fix it. Cheers, GaryB-) ___

Re: [sqlite] Question about floating point

On 03/01/2019 22:22, Peter da Silva wrote: Why is the exponent in the low bits, since it forces unnecessary shifts for integer operations? That's easy, because the high bits are closer to the barrel shifter, so it takes less time for the electron to get there![1][2] Cheers,

Re: [sqlite] SQLite 3.24.0 Solaris 9 build failure

On 20/01/2019 15:03, Dennis Clarke wrote: On 1/19/19 10:55 AM, Igor Korot wrote: Dennis, On Sat, Jan 19, 2019 at 9:31 PM Dennis Clarke wrote: And SPARC version is still available for download... Let us know when you get that running. Install of x86 went very smooth. The x86_64

Re: [sqlite] SQLite 3.24.0 Solaris 9 build failure

On 20/01/2019 15:03, Dennis Clarke wrote: On 1/19/19 10:55 AM, Igor Korot wrote: Dennis, On Sat, Jan 19, 2019 at 9:31 PM Dennis Clarke wrote: And SPARC version is still available for download... Let us know when you get that running. Install of x86 went very smooth. The x86_64

Re: [sqlite] Database locking problems

On 21/01/2019 18:46, andrew.g...@l3t.com wrote: Okay, I put in some instrumentation. Basically I print out all database queries as they happen, along with all calls to sqlite3OsLock() and sqlite3OsUnlock() (including their lockType argument and any abnormal return code). Also I print out

Re: [sqlite] Question about floating point

On 2018-12-17 02:41, Simon Slavin wrote: On 16 Dec 2018, at 2:54pm, Wout Mertens wrote: imagine having to handle the Zimbabwean Dollar, which ended up having 100 trillion dollar notes. Good way to overflow your integers. Indeed. But when the crisis started in the early 2000s, the currency

Re: [sqlite] [EXTERNAL] Re: Getting the week of the month from strftime or date functions

On 07/05/2019 16:46, Hick Gunter wrote: Even the concept of "year" is subject to differing religious and cultural viewpoints, with some traditions still insisting on a lunar calendar with the corresponding shift of seasons by 11 days each year. And in one case, the length of a month depending

Re: [sqlite] Safe to use SQLite over a sketchy network?

On 26/09/2019 15:00, Jens Alfke wrote: On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote: There are not, to my knowledge, any client/server database systems that will work properly if the database resides on a network filesystem (meaning remote multi-access). The "client" is remote from the

Re: [sqlite] Safe to use SQLite over a sketchy network?

On 26/09/2019 15:30, Keith Medcalf wrote: -Original Message- From: sqlite-users On Behalf Of Gary R. Schmidt Sent: Wednesday, 25 September, 2019 23:13 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Safe to use SQLite over a sketchy network? On 26/09/2019 15:00, Jens

Re: [sqlite] Things you shouldn't assume when you store names

On 10/11/2019 13:44, Doug wrote: Au Contraire, Jens! In many local contexts you can normalize people's names. I was born in Kansas, USA. My parents filled out a birth certificate for me. It had a place on the form for first name, middle name, last name, and a suffix like II or III. That

Re: [sqlite] Performance vs. memory trade-off question

On 15/12/2019 00:27, Richard Hipp wrote: A new feature on a branch has the following disadvantages: (1) It uses about 0.25% more CPU cycles. (Each release of SQLite is normally about 0.5% faster, so enabling this feature is sort of like going back by one-half of a release cycle.) (2) The

Re: [sqlite] CVE-2019-19317

On 15/12/2019 10:16, Yongheng Chen wrote: When we report the bugs, we said that they were from 3.31 version, but people in mitre changed them to 3.30.1. We just reported what we found. And the commit we reported in the bug report is referencing to the official GitHub repo. Of course the

Re: [sqlite] Network file system that support sqlite3 well

On 16/10/2019 10:38, Jens Alfke wrote: On Oct 15, 2019, at 3:47 PM, Peng Yu wrote: I'd like to use sqlite3 db files on many compute nodes. But they should access the same storage device for the sqlite3 db files. Why not use an actual client-server database system like MySQL? It's

Re: [sqlite] Network file system that support sqlite3 well

On 17/10/2019 16:42, Peng Yu wrote: I will need to use the actual files to test for dependency (just as the dependency that can be used by GNU make) I don’t understand what that means. You want to use a makefile that checks the mod date of the database? Suppose A is a sqlite3 db file, B is

Re: [sqlite] Regarding the whole C89/C90 language compliance debacle ...

On 24/11/2019 10:35, Simon Slavin wrote: On 23 Nov 2019, at 11:06pm, Richard Hipp wrote: given the choice between (1) Code that works and does something useful (2) Code that is standards compliant I'll always go with (1). Another problem is that different compilers, or the same compiler

Re: [sqlite] Safe to use SQLite over a sketchy network?

On 25/09/2019 15:36, Rowan Worth wrote: On Wed, 25 Sep 2019 at 12:58, Simon Slavin wrote: When I first learned the SQLite had problems with Network File Systems I read a ton of stuff to learn why there doesn't seem to be a Network File Systems that implements locking properly. Still, I

Re: [sqlite] Date time input

On 09/10/2019 10:25, Kevin Benson wrote: On Tue, Oct 8, 2019 at 2:40 PM James K. Lowden wrote: On Tue, 8 Oct 2019 09:06:24 -0700 Jens Alfke wrote: I think the idea of a semi-official ?SQLite++? has been floated here before OK, but it needs a better name. -- SQLiteXTD SQLArdArse.

Re: [sqlite] how to pass -Dxxx compile option

On 09/01/2020 17:47, Xingwei Lin wrote: Hi, How can I pass -Dxxx compile option when I build sqlite? Such as, - DSQLITE_ENABLE_INTERNAL_FUNCTIONS. ./configure --help will tell you that CFLAGS is how you do that, so: ./configure CFLAGS=-Dwhatever If you have many options: