Re: [sqlite] New SQLite Forum requires Javascript?

On Mar 12, 2020, at 9:19 PM, J.B. Nicholson wrote: > > Richard Hipp wrote: >> The Forum is powered by Fossil. It has been in active use in the >> Fossil community for a couple of years, and has worked well. > > Is there a way to use this without running the Javascript? It should be, but I

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

On Mar 12, 2020, at 6:15 PM, Jens Alfke wrote: > > I strongly disagree with your using a homemade forum rather than something > like Discourse. Unlike SQLite proper, the Fossil project accepts outside contributions without a whole lot of gatekeeping. I myself have made a few improvements to

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

On Mar 12, 2020, at 2:59 PM, no...@null.net wrote: > > I would like to add my resistance "vote." If experience on the Fossil mailing list is any guide, this mailing list will be a ghost town soon. There have been just a few threads on the mailing list in the years since we started the forum,

Re: [sqlite] CSV import using CLI (header, NULL)

On Feb 27, 2020, at 11:51 PM, Christof Böckler wrote: > > 1. There should be no penalty for using header lines in CSV files. Thus a new > flag -h for .import is much appreciated. More than that, SQLite should be able to *actively use* the header when present. For instance, given: foo,bar,qux

Re: [sqlite] more efficient JSON encoding: idle musing

On Feb 21, 2020, at 5:20 AM, Wout Mertens wrote: > > In JavaScript, objects are key-value collections with unique keys, where > the order of the keys is important. ECMAScript §13.7.5.15 (2019 edition) says, "The mechanics and order of enumerating the properties is not specified but must

Re: [sqlite] JSON_EACH + recursive query = unexpected performance degradation

On Feb 12, 2020, at 10:53 AM, Jens Alfke wrote: > > You should be able to speed this up by creating temporary tables from the > JSON first, and then changing the CTE to use those tables. Do you not get the same effect by using the new generated columns feature, only without the manual work of

Re: [sqlite] Documentation improvement request

On Feb 8, 2020, at 11:56 AM, Simon Slavin wrote: > > ? I don't know whether this can be done automatically. Possibly for any > page which has section headers. Yes, it can be done, and I’ve lined out several options for doing so here: https://www.fossil-scm.org/forum/forumpost/a5e1391eb3

Re: [sqlite] New word to replace "serverless"

On Jan 28, 2020, at 9:25 AM, Richard Hipp wrote: > > On 1/28/20, Jan Danielsson wrote: >> On 2020-01-28 00:19, Richard Hipp wrote: >>> daemon-less? >> >> This is my favorite, the only problem is that it is culturally more a >> Unix-y term. > > Since suggesting daemon-less, someone else

Re: [sqlite] New word to replace "serverless"

On Jan 27, 2020, at 3:18 PM, Richard Hipp wrote: > > "serverless" has become a popular buzz-word that > means "managed by my hosting provider rather than by me.” “Serverless” it a screwy buzzword anyway, because of course there’s still a server under its new meaning. My vote? Keep using the

Re: [sqlite] Sqlite 3.31.0 breaks firefox and thunderbird

On Jan 23, 2020, at 8:33 AM, Bernhard Rosenkraenzer wrote: > > The Debian guys have also observed this: > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=949644 > (and also don't have a fix yet). > > Any ideas? Can you bisect SQLite to narrow the range here? This release had an unusually

Re: [sqlite] Bug report

On Jan 23, 2020, at 7:02 AM, Mark Benningfield wrote: > > ...whenever I do a Fossil pull of the latest > version takes a grand total of about 2 seconds, but it would be nice not to > have to remember to do it every time :) If you’re having to reapply the change on every Fossil update, you’re

Re: [sqlite] New uuid extension in amalgamation

On Jan 23, 2020, at 5:45 AM, Dominique Devienne wrote: > > Hi. Looks like 3.31 (congrats on the release) does not include that > small extension in the amalgamation. Could it please? It’s easy to fix: 1. Get the SQLite source proper (https://sqlite.org/src/) 2. Add “uuid.c” to the loop

Re: [sqlite] Find schema of a table in a query

On Jan 19, 2020, at 2:41 AM, x wrote: > > I was hoping for something simpler. Such as? I mean, your question basically reduces to “I need to be inside the parse loop,” and SQLite has come along and said, “Hey, check this out, you can be inside the parse loop.” I mean, how cool is that?

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

On Jan 9, 2020, at 6:51 AM, Warren Young wrote: > >./configure CFLAGS='-DSQLITE_ENABLE_INTERNAL_FUNCTIONS' > > The reasons for the recommendation have to do with complications that result > from multiple variables, nested Makefile.am, etc. It also allows autoreconf t

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

On Jan 9, 2020, at 6:37 AM, Richard Hipp wrote: > > On 1/9/20, Xingwei Lin wrote: >> >> How can I pass -Dxxx compile option when I build sqlite? Such as, - >> DSQLITE_ENABLE_INTERNAL_FUNCTIONS. > > Option 1: > > CFLAGS='-O2 -DSQLITE_ENABLE_INTERNAL_FUNCTIONS' ./configure && make > > Option

Re: [sqlite] Upgrading from version 3.6.16 to 3.30.1

On Jan 4, 2020, at 12:49 PM, Gerry Snyder wrote: > > On Fri, Jan 3, 2020 at 10:57 AM Richard Watt wrote: > >> Does anyone know of any potential issues I might encounter and how to >> correct them please? >> > Few packages are maintained with more care about backward compatibility > than

Re: [sqlite] Question about passwords in System.Data.Sqlite

On Jan 4, 2020, at 12:23 AM, Mike King wrote: > > This is the subject: > > Hex Password with System.Data.Sqlite (.Net Core) My Python-fu sucks, but I don’t think that can match the administrivia rule: https://gitlab.com/mailman/mailman/blob/master/src/mailman/rules/administrivia.py It

Re: [sqlite] Question about passwords in System.Data.Sqlite

On Jan 2, 2020, at 3:47 PM, Mike King wrote: > > ...suspected administrivia! (not sure what that is - > I guess it's a US English word but it's certainly not an English one). It’s not defined in any of the mainstream dictionaries I have on my phone — three of them, because I’m a word nerd —

Re: [sqlite] Long long int constants in sources

On Dec 24, 2019, at 12:32 PM, Max Vlasov wrote: > > I didn't mention it was for sqlite > static compiling with Delphi 32 bit, that supports (also quite old) OMF > static libraries format Would it be out of the question to compile SQLite to a DLL? Then you can use any Windows C compiler. You

Re: [sqlite] Long long int constants in sources

On Dec 24, 2019, at 3:19 AM, Max Vlasov wrote: > > an "ancient" bcc 5.5 compiler Yes, [almost 20 years old][1] now. Even in these times of slowing technology, that’s still a very long time in computing. To put things into perspective, that compiler is about as old as SQLite itself! It’s a

Re: [sqlite] Securing user supplied SQL statements in a single process

On Dec 12, 2019, at 6:08 AM, Mike King wrote: > > ...I decided on a simple subset of > SQL and then wrote a parser using a regex as the tokeniser. First, [SQL is not a regular language][1], so it probably cannot be completely parsed by regexes. Not by a single regex without surrounding logic,

Re: [sqlite] Coding standard

On Dec 12, 2019, at 12:12 PM, Jens Alfke wrote: > > On Dec 12, 2019, at 10:36 AM, Simon Slavin wrote: >> >> For instance CodeSonar reports every use of memset() because you /can/ leak >> uninitialised bits of memory using memset() > > ...by writing to a field of a struct AFTER zeroing the

Re: [sqlite] SLOW execution: Simple Query Uses More than 1 min

On Dec 9, 2019, at 12:54 PM, Richard Damon wrote: > > But without virtual memory, many applications combinations that work > acceptably now would just fail to run at all. You don’t even have to get into swapping to find such cases. I once ran a headless app on a small cloud VPS that would run

Re: [sqlite] SQL to SQLite

On Dec 3, 2019, at 5:38 AM, gideo...@lutzvillevineyards.com wrote: > > The squigly red line starts at (PARTITION .. PARTITION BY is a valid SQLite window function: https://www.sqlite.org/windowfunctions.html#the_partition_by_clause but that feature is only about a year old in SQLite:

Re: [sqlite] 1 Writer and 1 Reader in WAL mode in two different processes, but as soon reading is started writer crashes

On Dec 2, 2019, at 3:02 AM, avinash.jha2493 wrote: > > The issue appears similar to what was mentioned here: > https://github.com/tensorflow/tensorboard/issues/1467 Yes, and OP posted a reply to his own issue a few days later giving the correct answer: TensorFlow needs to pick one of the two

Re: [sqlite] SQL to SQLIte

On Dec 2, 2019, at 11:22 AM, Simon Slavin wrote: > > Please post again, this time with the query. The table schema might also help: sqlite> .schema TableName ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] What is the C language standard to which sqlite conforms ?

On Nov 21, 2019, at 3:54 AM, Richard Hipp wrote: > > The solution is here: https://www.sqlite.org/src/info/0d1055a5da8274a5 memset before free? Why does that help? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] What is the C language standard to which sqlite conforms ?

On Nov 19, 2019, at 8:43 PM, Dennis Clarke wrote: > > On 11/20/19 2:26 AM, Warren Young wrote: >> On Nov 19, 2019, at 7:06 PM, Dennis Clarke wrote: >>> >>> gmake: *** [Makefile:1256: tcltest] Segmentation fault (core dumped) >> … >>> CC=/opt/

Re: [sqlite] What is the C language standard to which sqlite conforms ?

On Nov 19, 2019, at 7:06 PM, Dennis Clarke wrote: > > gmake: *** [Makefile:1256: tcltest] Segmentation fault (core dumped) … > CC=/opt/bw/gcc9/bin/gcc You’re using a nonstandard compiler (i.e. not provided by Red Hat) with non-default options, but it’s SQLite at fault here? Seems like quite

Re: [sqlite] Can SQLite import Latin1 data?

On Nov 15, 2019, at 2:15 PM, Jose Isaias Cabrera wrote: > > Shawn Wagner, on Friday, November 15, 2019 04:01 PM, wrote... >> >> If you're on Windows, which cp1252 suggests, just make sure that you don't >> end up with a BOM at the start of the file when you convert it. Windows >> tools that

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

On Nov 13, 2019, at 11:31 AM, Simon Slavin wrote: > > Don't substring searches help you more than sorted lists ? There’s a relevant question for this list: how do we do this efficiently? The naive solution involves a table scan. Enable FTS on that column? Manual extraction into indexed

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

On Nov 13, 2019, at 3:47 PM, Peter da Silva wrote: > > the nurse wastes time looking me up some other way, and > tells me I'm Peterda Silva. My “Young II” saga probably burnt an hour of both my time and that of the insurance company, since it required multiple calls to get it sorted. I use a

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

On Nov 11, 2019, at 1:49 PM, Jose Isaias Cabrera wrote: > > If there is a combination, is just like the accented e, é, why not use the > one character vs the combination? Big “if.” There isn’t always a pre-composed character. Typically, pre-composed characters exist in Unicode for

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

m for my name’s suffix, so I put it after the last name, and their data entry drone put it in the database’s last-name field as “Young II”, so to their DBMS, there was indeed no “Warren”, “Young” row! ___ sqlite-users mailing list sqlite-users@mailinglists.s

Re: [sqlite] Multiple files for a single SQLite database

On Oct 31, 2019, at 5:40 AM, Aydin Ozgur Yagmur wrote: > > How can it be raised to 125? Define SQLITE_MAX_ATTACHED at build time: https://www.sqlite.org/limits.html#max_attached > I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED, > 125)" but there is no effect.

Re: [sqlite] DELETE extremely slow

On Oct 31, 2019, at 3:51 AM, Thomas Kurz wrote: > > delete from dataset; Is that command representative of actual use, or are you deleting all rows just for the purpose of benchmarking? I ask because if you’re going to just delete all rows in a table, it’s usually faster to DROP TABLE and

Re: [sqlite] https://www.sqlite.org/draft/gencol.html Typo

On Oct 29, 2019, at 7:20 AM, Simon Slavin wrote: > > > > OMG. Much welcomed feature. Yes, I can see immediate use for this. One question I had after reading the draft doc is whether an application-defined SQLITE_DETERMINISTIC function can be used

Re: [sqlite] sqlite - AIX memory fault coredupm when using .output command [WARNING! - EXTERNAL]

On Oct 29, 2019, at 2:56 PM, Dawson, Jeff G wrote: > > SQLite version 3.7.14.1 2012-10-04 19:37:12 I infer that you’re migrating a legacy system. There are two good alternatives to your current method that should avoid the symptom entirely: 1. Build a current version of SQLite for the old

Re: [sqlite] Roadmap?

On Oct 26, 2019, at 6:28 PM, J. King wrote: > > a good designer will choose a good schema from the start and thus rarely need > to change it When you add new features to a long-lived application, you may occasionally have to ALTER the table(s) the app uses to allow the new feature. My

Re: [sqlite] Roadmap?

On Oct 20, 2019, at 9:20 PM, Darren Duncan wrote: > > Rowan, you're talking about Unicode codepoints; however, Unicode graphemes, > what typical humans consider to be characters, are sequences of 1..N > codepoints, example a letter plus an accent that get composed together, and > this is what

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

On Oct 17, 2019, at 4:33 AM, Warren Young wrote: > > $ echo 'select count(*) from MyTable where rowid > 1234' | > nc dbserver Clarification: that echo line should begin with “Query: “ and end in a semicolon, which is a short form method of querying a Bedrock DB over the n

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

On Oct 16, 2019, at 11:42 PM, Peng Yu wrote: > > Suppose A is a sqlite3 db file, B is some other file which is > generated based on the content in A. When A is not changed, there is > no need to change B, otherwise, B will need to be regenerated. In > other words, B depends on A, and can be

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

On Oct 16, 2019, at 4:08 PM, Warren Young wrote: > > I think this project needs someone to fork it. Sorry, that’s immoderate. It looks like they’ve still got active committers, so the software isn’t abandonware. Still, that long list of old issues is a problem. I wonder if the real

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

On Oct 16, 2019, at 8:45 AM, Graham Holden wrote: > > ...write a pair of what could be relatively simple > client-server programs that police access to the SQLite DB (which the > server will be accessing as a local file). > > ... > > ** I believe someone has tried/succeeded in doing something

Re: [sqlite] Last record

On Oct 15, 2019, at 1:52 PM, Don V Nielsen wrote: > > what if one has a peanut allergy? You’re joking, but it gives us cause to extend the fable profitably: use the proper WHERE clause. SELECT * FROM food WHERE type != 'peanuts' The maid delivers whatever you ask for, within the limits

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 15, 2019, at 8:07 AM, Peter da Silva wrote: > A mail server speaks SMTP for both inbound and outbound That’s only useful if you’ve configured Fossil to integrate with a third-party bidirectional SMTP server, which is *not* the only way to configure Fossil’s email integration:

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 14, 2019, at 3:04 PM, Keith Medcalf wrote: > > On Monday, 14 October, 2019 14:18, Warren Young wrote: > >> Fossil Forums allow you to subscribe to email notifications. From the >> reader’s perspective, it’s really very little different from the current &g

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 11:33 AM, Tim Streater wrote: > > A mailing list suits me just fine. It works well and gets next to no spam. In > addition, it's not yet another damn website I have to log into to use and > remember my username/password for. And I don't care if it's not "modern”. Fossil

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 9:56 AM, Brannon King wrote: > > I'd like to propose that we > upgrade to something more modern and secure like Sympa or mlmmj, or even a > more drastic system upgrade to something like Redmine -- a project > tracker + forum. This is a really old argument, which we’ve had at

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 9:41 AM, Mike Bayer wrote: > > what is the reason that the SQLite mailing list archives...are private for > members only in order to be read? Probably because you can extract email addresses and real names from the archives. Harvesting of such information is a problem

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

On Oct 10, 2019, at 2:03 PM, Jose Isaias Cabrera wrote: > > 2. The normal SQlite snapshots plus a series of libraries and functions that > can easily be compiled with the original light SQLite. This is basically the model for FOSS OS distros: a bunch of people get together and work on a

Re: [sqlite] Import XLS file?

On Oct 1, 2019, at 12:46 PM, Simon Slavin wrote: > > 1) export your XLS data in CSV format > 2) Use the SQLite shell tool to import the CSV data into your database Beware that SQLite’s CSV import requires that the imported data have the same number of columns as the table you’re importing it

Re: [sqlite] Fossil Public Accounts

On Oct 1, 2019, at 8:02 AM, J. King wrote: > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera > wrote: >> >> Is there a Fossil public account site like git? Git doesn’t provide public accounts. There are a number of *proprietary web services* that offer Git hosting, but don’t

Re: [sqlite] General Amalgamation vs Your Own

On Sep 21, 2019, at 11:29 AM, Stephen Chrzanowski wrote: > > How does one have their own code base for SQLite, with their own customer > logic or functionality or whatever, then, have updates provided by the > SQLite team implemented in when updates and such are provided? What kind of code are

Re: [sqlite] How to install REGEXP support?

On Sep 18, 2019, at 8:33 AM, Peng Yu wrote: > > But I don't want to always specify a full path. I am asking where is > the standard place to put the library file so that I don't have to > always specify the whole path. You’re verging into “How do I program my computer?” or even “How do I use my

Re: [sqlite] How to install REGEXP support?

On Sep 16, 2019, at 6:24 PM, Peng Yu wrote: > > Do you know what the commands are to just compile for the regex support? https://www.sqlite.org/loadext.html ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] strip off file metadata in sqlar

On Aug 27, 2019, at 2:40 PM, Peng Yu wrote: > > Where is the binary or source code of sqldiff? The source is part of the complete SQLite source tree: https://www.sqlite.org/cgi/src/doc/trunk/README.md (As opposed to the amalgamation.) You will then find it in tool/sqldiff.c, and you can

Re: [sqlite] strip off file metadata in sqlar

On Aug 27, 2019, at 9:21 AM, Peng Yu wrote: > > The .sqlar files contain file metadata. I'd like two .sqlar files to > be exactly the same (`cmp` should return 0) when they store the same > content. Is it possible to strip off all metadata of stored files? [XY Problem][1]. Try sqldiff instead:

Re: [sqlite] Attached databases and union view.

On Aug 22, 2019, at 9:27 AM, Peter da Silva wrote: > > Have an existing application that's pushing the limit If the limit is in hardware, shards won’t help. For example, a SQLite DB on a 7200 RPM spinning disk is limited to about 60 transactions per second under the stock SQLite fsync logic,

Re: [sqlite] Error response for automatic transaction rollback

On Aug 20, 2019, at 9:09 AM, Matt Zand wrote: > > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. It sounds like you’re looking for CREATE TRIGGER…BEFORE UPDATE…RAISE(ROLLBACK)

Re: [sqlite] Happy birthday to the SQLite Fossil repo

On Aug 18, 2019, at 12:36 PM, Gregory Moore wrote: > > Happy belated birthday to the Sqlite Fossil repo. Will there be cake and > candles? Yes, but the cake is [an immutable artifact][1] and the candles require [flint starters][2]. You can have your own cake by [cloning ours][3], then eat

Re: [sqlite] [EXTERNAL] Re: DEF CON (wasL A license plate of NULL)

On Aug 14, 2019, at 12:27 AM, Hick Gunter wrote: > > But surely any compiler worth ist salt would optimize away all of that code > and just use the result of the expression given as argument in the call ;) You joke, but the answer is “Maybe.” See https://godbolt.org/z/K9g-ai In English,

Re: [sqlite] Backward compatibility vs. new features (was: Re: dates, times and R)

On Aug 14, 2019, at 9:55 AM, Stephen Chrzanowski wrote: > > On Tue, Aug 13, 2019 at 7:30 PM J Decker wrote: > >>> Why are you storing the timezone? You display the TZ of the user who is, >>> later, viewing the data. And that user could be anywhere. >> >> Because the actual time on the clock

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

On Aug 13, 2019, at 3:11 PM, Jose Isaias Cabrera wrote: > > Somewhere in my basement exists a book called, "The C Programming Language.” It’s worth a re-read, even if you no longer use C. You will certainly find insights that affect however you *do* program these days. The last time I dipped

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

On Aug 13, 2019, at 1:16 PM, Jose Isaias Cabrera wrote: > > I see all of you smart programmers using this non-column matching behavior, > and I ask myself why? Thoughts? Or not. :-) It started in the days of real terminals, where the extra line was one of the 24-ish you got on a glass tty

Re: [sqlite] Grammar police

On Jul 12, 2019, at 10:16 AM, Jose Isaias Cabrera wrote: > >>> Here in the Southeastern US (specifically in Charlotte, NC) we really >>> do say "an historical oversight". If you said "a historical >>> oversight", people would look at you funny. > > "an historical oversight" is the correct

Re: [sqlite] Grammar police

On Jul 11, 2019, at 10:41 AM, Richard Hipp wrote: > > Here in the Southeastern US (specifically in Charlotte, NC) we really > do say "an historical oversight". If you said "a historical > oversight", people would look at you funny. … :) ___

Re: [sqlite] wal

On Jun 28, 2019, at 2:12 AM, ingo wrote: > > I see a wal file being created and deleted. Just for my > understanding, would it be of advantage to have a second persistent > connection just for keeping the wal alive? You’ve basically got it backwards. It’s a *good thing* when the WAL file

Re: [sqlite] the sqlite3 documentation would be pretty good if it wasn't tragic...

On Jun 26, 2019, at 3:31 PM, James K. Lowden wrote: > > You won't find many examples included with your C compiler That depends a lot on the C compiler in question. Some C compilers include a *lot* of examples. Arguably, K is a bound book of examples for the AT Unix C compiler. Where is

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

On Jun 26, 2019, at 2:58 PM, ingo wrote: > > On 26-6-2019 22:22, Warren Young wrote: >> 3. Lack of types. > > Not being a programmer, that was a revelation to me Behind my prior two posts isn’t an attitude of criticism of SQLite’s design and implementation, but rath

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

On Jun 26, 2019, at 2:22 PM, Warren Young wrote: > > 3. …types…table…more comprehensive, so that whatever weird data type you > search for, you either get a simple mapping to one of SQLite’s few base data > types or to a recipe showing how to construct a suitable alternative. …

Re: [sqlite] the sqlite3 documentation would be pretty good if itwasn't tragic...

On Jun 26, 2019, at 11:11 AM, Simon Slavin wrote: > > I too have missed sample code from the SQLite documentation. I agree that > there are some drawbacks to including it. But there are some things, like > the correct sequence is for understanding ROLLBACKs, which are strange and >

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

On Jun 12, 2019, at 10:02 AM, James K. Lowden wrote: > > On Wed, 12 Jun 2019 09:35:13 -0400 > Richard Hipp wrote: > >> Question: Should SQLite be enhanced to show -0.0 as "-0.0"? > > 2. Math. Negative zero is not a mathematical concept. The best kind of correct:

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

On Jun 12, 2019, at 10:45 AM, Richard Hipp wrote: > > On 6/12/19, James K. Lowden wrote: >> 1. Prior art. I can't think of a single programming language that >> displays -0.0 without jumping through hoops. > > Prints -0.0 as "-0.0" or just "-0": glibc, Tcl, Python, Javascript Chrome’s JS

Re: [sqlite] SQLite4 version

On May 29, 2019, at 7:12 AM, Mike King wrote: > > Would it make sense for DRH to rename V4 to something else? For the > uninitiated it’s not always apparent that V3 is what you should be using. drh appears to use major version number changes to mean “breaking file format change,” rather than

Re: [sqlite] SQLite4 version

On May 29, 2019, at 6:16 AM, Simon Slavin wrote: > > There may one day be a release of SQLite4 It doesn’t look like it: https://sqlite.org/src4/info/c0b7f14c0976ed5e ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] round function inconsistent

On May 24, 2019, at 7:10 AM, Jose Isaias Cabrera wrote: > > Dr. Richard Hipp, on Friday, May 24, 2019 08:44 AM, wrote... >>> Dr. Hipp, how many more scenarios, where round gives the wrong answer, >>> exist? Thanks. >> >> Consider these two queries: >> >> SELECT round(3.255,2); >> SELECT

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

On May 23, 2019, at 4:28 PM, R Smith wrote: > > it is very easy to add things to the base distro, but extremely hard to > impossible to ever take it away again, which means one should only ever "add" > with great caution. Easy fix: -DSQLITE_OMIT_EXTENDED_MATH_LIBRARY Include it by default,

Re: [sqlite] readfile() enhancement request

On May 17, 2019, at 7:49 PM, sql...@zzo38computer.org wrote: > > (For Macintosh you may need to change "xclip -o" to the proper command on > Macintosh, pbpaste > For Windows, this extension is unlikely to work There are pipes in the NT line of kernels, and there are ways to tie that to

Re: [sqlite] Bug in table_info pragma

On May 17, 2019, at 4:55 AM, J. King wrote: > > SQLite version 3.28.0 2019-04-16 19:49:53 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create table t(a text default '' /* comment */ ); >

Re: [sqlite] How to retrieve "latest" fileio.c, test_windirect.c/h files?

On May 11, 2019, at 10:46 PM, Justin Clift wrote: > > One of the steps uses curl to download fileio.c, test_windirent.c/.h > from fossil [snip] > Is there a way to always get "the latest" version of the file? :) $ curl -L -o src/extensions/fileio.c

Re: [sqlite] SQLite with single writer on Windows network share

On May 11, 2019, at 5:52 PM, Jose Isaias Cabrera wrote: > > Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... >> >> On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: >> >> It should run under Cygwin and WSL. > > I tried to build it. I fould out that

Re: [sqlite] SQLite with single writer on Windows network share

On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: > >> How about you give up on the idea of using Windows shares to distribute a >> SQLite DB and use a tool meant for the job, such as BedrockDB? > > BedrockDB is recommended here now and then, and it sounds interesting indeed. > However, it's

Re: [sqlite] SQLite with single writer on Windows network share

On May 9, 2019, at 4:56 PM, James K. Lowden wrote: > > file I/O operations act on the kernel’s filebuffer It’s more widely called a buffer cache or page cache: https://en.wikipedia.org/wiki/Page_cache > If this sounds like an indictment of NFS, it's really not. In large part, it’s a

Re: [sqlite] SQLite with single writer on Windows network share

On May 8, 2019, at 10:30 AM, Jose Isaias Cabrera wrote: > > Warren Young, on Wednesday, May 8, 2019 12:10 PM, wrote... > >> How about you give up on the idea of using Windows shares to distribute a >> SQLite DB >> and use a tool meant for the job, such a

Re: [sqlite] SQLite with single writer on Windows network share

On May 8, 2019, at 8:42 AM, Andrew Moss wrote: > > We are currently backed into a corner by a customer In what way, exactly? It might help to know. > and are looking at > using an SQLite database hosted on a windows network share (using server > 2012 R2 or later). You’ve fallen victim to the

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

On May 6, 2019, at 11:58 AM, Jose Isaias Cabrera wrote: > > we have discover DNA; shouldn't we have the knowledge to come up with a > dating system that should work for the world. :-) The Earth year doesn’t divide evenly by Earth days. No matter what you do, the solution *will* be messy.

Re: [sqlite] COLLATE NOCASE index on REAL column malfunctions

On May 1, 2019, at 3:31 PM, Manuel Rigger wrote: > > CREATE TABLE test (c0 REAL); > CREATE INDEX index_0 ON test(c0 COLLATE NOCASE); > INSERT INTO test(c0) VALUES ('+/'); > SELECT * FROM test WHERE (c0 LIKE '+/‘); That behavior *does* reproduce here. Making the final query’s predicate “c0 =

Re: [sqlite] COLLATE NOCASE index on REAL column malfunctions

On May 1, 2019, at 1:18 PM, Richard Hipp wrote: > > I am unable to reproduce the observed behavior. Nor I, on 3.28.0 release with our custom build. Thank you for providing a simple test case, Manuel: it helps greatly! > What version of > SQLite are you testing with? Are you compiling it

Re: [sqlite] althttpd.c check-in: efdc1b8e66

> On Apr 29, 2019, at 7:18 AM, Richard Hipp wrote: > > On 4/29/19, Jose Isaias Cabrera wrote: >> >> I know I can probably use cygwin to run this tool, but plain Windows is not >> an option, right? >> > > Althttpd is built around fork(). Windows does not support fork(). > The cygwin

Re: [sqlite] Options used for precompiled dll for Windows?

On Apr 18, 2019, at 2:37 PM, sky5w...@gmail.com wrote: > > Searched a while...what was the makefile or the options used to create the > latest precompiled sqlite3.dll? > https://www.sqlite.org/download.html > --> sqlite-dll-win64-x64-328.zip Execute “PRAGMA compile_options;” and it’ll tell

Re: [sqlite] SQLite v3.27.2 memory usage

On Apr 14, 2019, at 10:18 PM, David Ashman - Zone 7 Engineering, LLC wrote: > > It appears that there is a leak somewhere. It is certainly in your code. My bet’s on a missing sqlite3_finalize() call, but there are many other possibilities. > Does anyone know why this error occurs? I

Re: [sqlite] Help with sqlite3_value_text

On Apr 12, 2019, at 1:06 PM, Keith Medcalf wrote: > > Actually you would have to convert the strings to UCS-4. UTF-32 is the new name of that standard: https://en.wikipedia.org/wiki/UTF-32#History > UTF-16 is a variable-length encoding. Only if you’re outside the BMP, which is why I

Re: [sqlite] Help with sqlite3_value_text

On Apr 12, 2019, at 8:51 AM, x wrote: > > How do I do the same thing if the string param is a utf-8 or utf-16 string > and the SearchChar is a Unicode character? Convert the characters to 32-bit wide characters first, then iterate over the array of uint32_t or similar. One method is shown by

Re: [sqlite] compressed sqlite3 database file?

On Apr 11, 2019, at 1:27 PM, James K. Lowden wrote: > > On Wed, 10 Apr 2019 15:14:59 -0600 > Warren Young wrote: > >> If you?re going to buy some more storage, you should put ZFS on it >> then, too. :) > > That's interesting advice for a DBMS mailing list. >

Re: [sqlite] compressed sqlite3 database file?

On Apr 10, 2019, at 2:12 PM, Keith Medcalf wrote: > > It is far cheaper and much more reliable to just buy some file storage space. > If you’re going to buy some more storage, you should put ZFS on it then, too. :) You get a whole lot more from ZFS than just transparent compression. You

Re: [sqlite] compressed sqlite3 database file?

On Apr 10, 2019, at 12:08 PM, Peng Yu wrote: > > https://softwarerecs.stackexchange.com/questions/45010/transparent-file-compression-apps-for-macos > > I work on Mac. Would this be worthwhile to try? The first link didn’t work here because it didn’t like the APFS drive I tried it on.

Re: [sqlite] Option to control implicit casting

On Apr 8, 2019, at 9:08 PM, Joshua Thomas Wise wrote: > > there should be a compile-time option to disable all implicit casting done > within the SQL virtual machine. That’d be nice, especially when using SQLite with a strongly- and statically-typed programming language and a

Re: [sqlite] compressed sqlite3 database file?

On Apr 9, 2019, at 11:39 PM, Peng Yu wrote: > > Is there a way to make the database file of a size comparable (at least > not over 5 times) to the original TSV table in the .gz file? Transparent file compression is a feature of several filesystems: NTFS, ZFS, Btrfs, and more:

Re: [sqlite] ANN: SQLite3 Decimal Extension

On Apr 3, 2019, at 6:30 AM, Lifepillar wrote: > > does SQLite support indexes on blobs? It claims to: $ sqlite3 x.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. sqlite> create table x (a blob); sqlite> create index xi on x(a); sqlite> explain query plan select a

  1   2   3   4   >