On Oct 11, 2018, at 12:06 AM, Random Coder wrote:
>
> On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote:
>> The salt is the project code combined with the user ID, not a secret
>> per-user salt. Both of those values are publicly visible, but it does
>> defeat rain
On Oct 11, 2018, at 12:26 AM, Darren Duncan wrote:
>
> On 2018-10-10 1:36 PM, Eric wrote:
>> Too much overhead, how often must I clone ...
>
> This makes me think that it would be useful, if it doesn't already, for
> Fossil to have something analogous to a database replication feature.
That’s
On Oct 11, 2018, at 2:25 PM, Eric wrote:
>
> On Thu, 11 Oct 2018 10:20:08 -0600, Warren Young wrote:
>> On Oct 11, 2018, at 12:26 AM, Darren Duncan wrote:
> 8><
>
>>> This makes me think that it would be useful, if it doesn't already,
>>&
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
On Oct 10, 2018, at 10:39 AM, Eric wrote:
>
> * mailing lists come to me, I don't have to go and get them
So do Fossil email alerts.
> * mailing lists all work the same
No, they don’t.
There are many different mailing list managers, each with different
subscription methods, unsubscription
On Oct 10, 2018, at 9:09 AM, Eric wrote:
>
> I don't think that "all been had" applies.
Pedantically speaking, yes, you’re right, every possible argument has not been
had on this mailing list yet.
In order to avoid an “infinite monkeys” argument, let’s make it concrete: what
substantial
On Oct 10, 2018, at 11:51 AM, Chris Green wrote:
>
> Warren Young wrote:
>> Fossil forum email alerts include the full content of the message.
>
> And can you then simply 'reply' from your E-Mail client? If not then
> it doesn't really help much.
I already addressed that
On Oct 10, 2018, at 11:23 AM, Tim Streater wrote:
>
> On 10 Oct 2018, at 18:10, Warren Young wrote:
>
>> On Oct 10, 2018, at 10:39 AM, Eric wrote:
>>>
>>> * mailing lists come to me, I don't have to go and get them
>>
>> So do Fossil email ale
On Oct 10, 2018, at 1:26 PM, Keith Medcalf wrote:
>
> there is also absolutely no way to perform "positive identity checks" on a
> web page post that cannot be equally trivially falsified.
You’re conflating physical identity with forum identity.
I don’t care whether you have state-approved
On Oct 10, 2018, at 2:36 PM, Eric wrote:
>
> On Wed, 10 Oct 2018 11:10:24 -0600, Warren Young wrote:
>> On Oct 10, 2018, at 10:39 AM, Eric wrote:
>>>
>>> * mailing lists come to me, I don't have to go and get them
>>
>> So do Fossil email alerts.
&
On Oct 10, 2018, at 2:42 PM, Keith Medcalf wrote:
>
> On Wednesday, 10 October, 2018 14:08, Warren Young wrote:
>
>> On Oct 10, 2018, at 1:26 PM, Keith Medcalf wrote:
>
>> The “security code” is just a CAPTCHA
>
> I hate captcha's and will not use them. They r
On Oct 6, 2018, at 9:46 AM, Roger Schlueter wrote:
>
> In addition to the freebies mentioned by Luuk, WordPerfect Office X9 is a
> commercial product that includes all of Excel's features including
> import/export of Excel data.
I guess neither of you read the article, because the point of
On Oct 6, 2018, at 2:21 PM, Simon Slavin wrote:
>
>
> Excel ate the financial business world because companies use Excel to solve a
> simple problem, then add a feature, then add another feature, and keep going
> until they have some crawling creeping horror that needs to return to R'lyeh.
>
On Oct 7, 2018, at 12:28 PM, Luuk wrote:
>
> The 'software development department' should forbid 'software
> developmentprojects' which iare not done by them.
Yes, and corporate laptops should be absolutely locked down, so that people
can’t install software not approved by IT, which list will
On Oct 6, 2018, at 10:23 AM, Warren Young wrote:
>
> What we want is a SQLite-based program along the lines of Access or
> FileMaker, preferably with some kind of cloud capability.
I’ve come up with a plan to do this within Fossil, or as a fork of it:
https://fossil-scm.
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 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 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
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
On Sep 2, 2018, at 4:15 AM, Richard Hipp wrote:
>
> On 9/1/18, Rocky Ji wrote:
>> Hi everyone,
>>
>> (Mailing list newbie here). Where can I get a corpus of all the
>> -stmt.gif that are shown in the online docs e.g.
>> https://sqlite.org/images/syntax/insert-stmt.gif ?
>
>
On Dec 20, 2018, at 3:38 PM, Igor Tandetnik wrote:
>
> On 12/20/2018 1:34 PM, Dennis Clarke wrote:
>> A more interesting topic of discussion would be the speed and complexity
>> of circuitry designed for another number base such as 5 or even decimal.
>
>
On Sep 11, 2018, at 2:29 AM, Domingo Alvarez Duarte wrote:
>
> I think that could be a good idea to add an option to fossil update command
> to allow override the url for the repository so in cases like today I could
> do:
>
> fossil updata --url https://www1.sqlite.org/cgi/src
There are
On Mar 26, 2019, at 8:35 AM, Wout Mertens wrote:
>
> what would be the best way to answer these, given `CREATE TABLE foo(id
> TEXT, json JSON);` and json is always a json object:
>
> - all rows with a given key bar
> - SELECT * FROM foo WHERE json_extract(json, '$.bar') IS NOT NULL;
>
On Apr 3, 2019, at 6:30 AM, Lifepillar wrote:
>
> By default, the precision is limited to 39 digits and exponents must be
> in the range [-99,999,999,+99,999,999] (for some mathematical
> operations, the exponent must not exceed 99,999 in absolute value).
That’s enough. :)
I once calculated
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
On Apr 3, 2019, at 7:05 AM, Dominique Devienne wrote:
>
> Seems like you're using non-ascii chars in your source code, notably
> the #pragma mark.
I think you’ve got two nits there, not one.
As for the non-ASCII characters, they’re UTF-8, which is the de facto standard
character set on the
On Mar 28, 2019, at 4:15 AM, Wout Mertens wrote:
>
> - I don't see how json_type can help
I don’t see “json_type” in this thread at all, other than this message.
> - Schemaless data is really nice to work with
Sure, but it has a cost. Unless you’re willing to give us a *lot* more
On Feb 22, 2019, at 2:34 AM, Domingo Alvarez Duarte wrote:
>
> I'm writing here because I've tried to create an account on fossil-scm.org
> and it doesn't seems to work.
No user with this email is in the Fossil forum user table. I’ve just tested it
with an email address I don’t use on the
On Mar 12, 2019, at 11:30 AM, Ted Goldblatt wrote:
>
> I have been writing software for too many decades to casually dismiss the
> possibilities of software bugs. If there couldn't be bugs in SQLite, there
> would have been no bug fixes since the version being used here, and having
> briefly
On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera wrote:
>
> Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do something
> like this,
You may be interested in the sqldiff program that comes with SQLite:
$ sqldiff --help
Usage: sqldiff [options] DB1 DB2
Output SQL text that
On Feb 12, 2019, at 10:30 AM, Zach Wasserman wrote:
>
> Is anyone aware of an API I can use to determine which tables are accessed
> by a given query? Or, is there a way to retrieve the parsed AST of a query?
> If this is possible directly through the SQLite shell that would be great,
> but C
On Feb 9, 2019, at 12:20 PM, Jose Isaias Cabrera wrote:
>
> Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote...
> >
> >You may be interested in the sqldiff program that comes with SQLite:
>
> Yeah, I know about it, but I thought it was for two different DBs
On Feb 13, 2019, at 2:10 PM, Marek Sebera wrote:
>
> re-compiling system provided library is not an option
What version and system are we talking about? It matters greatly. If we’re
talking about the epochal 3.7.x series, the answers are very different than if
we’re talking about a version
On Jan 28, 2019, at 1:26 AM, Vladimir Barbu
wrote:
>
> This vulnerability has been addressed in SQLite 3.26.0. When could we expect
> new version (official) of System.Data.SQLite which uses 3.26.0?
Are you both using FTS3 *and* letting your users execute arbitrary SQL?
Most of the time, the
On Jan 28, 2019, at 9:17 AM, mzz...@libero.it wrote:
>
> I developed an application that need to create 1 table with thousand of rows
> every time when a certain event occours.
>
> This works in a good way, but when the number of the tables become huge
> (about 15000/2 tables) the first
On Jan 28, 2019, at 2:44 PM, Chris Locke wrote:
>
>> The table name should not be meaningful to your application; nothing in
>> your application should conjure up a table name.
>
> I can't get my head around this advice. Is this just for this occasion, or
> for every application? What if I'm
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
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.
>
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
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
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
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 */ );
>
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
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
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:
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
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
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
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
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
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,
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
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
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
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
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
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 =
> 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
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.
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
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.
…
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
>
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
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
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.
… :)
___
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
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
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:
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
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.
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
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
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
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
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,
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)
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,
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:
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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,
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
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
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
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:
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
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
201 - 300 of 335 matches
Mail list logo
