Re: [sqlite] Bug in SQLite version 3.31.1 and 3.32?

On 3/6/20 9:54 PM, Keith Medcalf wrote: On Friday, 6 March, 2020 19:25, Richard Damon wrote: It is sort of like NaN, where a Nan is neither less than, greater than or equal to any value, including itself. NULL (as in SQL NULL) means "missing value" or "unknown". NULL

Re: [sqlite] Bug in SQLite version 3.31.1 and 3.32?

ce you can have NULL values, you have to know the rules very well when you apply logic. Other values make sense, but NULL is not logical. It is sort of like NaN, where a Nan is neither less than, greater than or equal to any value, including itself. -- Richard Damon

Re: [sqlite] Performance Issue on Large Table

On 2/23/20 3:06 PM, R.Smith wrote: On 2020/02/23 21:23, Richard Damon wrote: On 2/23/20 8:31 AM, Olaf Schmidt wrote: An amount of 140 tables in such a "BibleVersions.db" is not uncommon and can be managed by SQLite in a good performance. I'm not sure that form of divisio

Re: [sqlite] Performance Issue on Large Table

e to lookup data from be taken from a field you get in a query. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to group this?

On 2/9/20 11:44 PM, Rowan Worth wrote: On Mon, 10 Feb 2020 at 11:12, Richard Damon wrote: On 2/9/20 7:24 PM, Bart Smissaert wrote: ID ENTRY_DATE TERM NUMERIC_VALUE ROWID 1308 15/Mar/2013 Systolic 127 701559 1308 15/Mar/2013

Re: [sqlite] How to group this?

the possibility (and at least throw out an error when it sees that). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] loading extension csv.c

macro (7.1.4p1 in the C17 Standard) which it appears not to be (as that shouldn't cause a problem with the shown code). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is mutliple-execute-one-commit slower than multiple single-execute-single-commit?

multiple executes could exceed the memory cache, causing it to spill to the database, and then the commit needs to read that back and put it into the right place, while a commit after each execute keeps everything in memory until the commit writes it to the database. -- Richard Damon

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

ally happenstance, and might change by any number of things. If the order that the SQL engine happens to choose to fetch the data does happen to be in the order specified by the ORDER BY, then a good engine will optimize it out, so it is free. -- Richard Damon __

Re: [sqlite] How can I detect rows with non-ASCII values?

and if that is what has been stored in the database, it may be very hard to distinguish that from an actual question mark in the data. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unexplained table bloat

16 are supposed to be converted to their fundamental 21 bit value and that encoded into UTF-8. If the code doesn't validate the data well enough to catch that issue, then I suspect the character counting would count each half of the surrogate p

Re: [sqlite] Unexplained table bloat

will have values of that type (or NULL). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unexplained table bloat

pass through them to see if they violate the rule, as that is just adding a lot of overhead for very little benefit. It is really expected that applications will do this sort of test at the borders, when possibly untrusted strings come in, and know that if good strings come in, the following pr

Re: [sqlite] Unexplained table bloat

ule, which can be used to embed nulls in strings if the system doesn't enforce the minimum length encoding rule (at least for this character). I have no idea if that would work with SQLite though. -- Richard Damon ___ sqlite-users mailing li

Re: [sqlite] Causal profiling

the 'type' of the SQLite 'object'. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 18 minutes 41 seconds

ntury called the 1900's which went from 1900 to the end of 1999. Decade would work the same way, the 202st decade goes from 2011 to end of 2020, but the 2010s go from 2010 to end of 2019. -- Richard Damon ___ sqlite-users mailing list sq

Re: [sqlite] Causal profiling

ect, but link to it as an external resource. Yes, there is perhaps an option to provide some specific configuration macros to allow SQLite to be optimized when included statically in a project, but those options shouldn't change the API. -- Richard Damon _

Re: [sqlite] How to determine the column type? – virtual table?

On 12/14/19 1:55 PM, František Kučera wrote: > Dne 14. 12. 19 v 18:20 Richard Damon napsal(a): >> What he wants is different. He takes a basically arbitrary database >> (user provided) and an arbitrary SQL statement (also user provided) and >> he wants to determine what typ

Re: [sqlite] How to determine the column type? – explicit cast

ixed' and maybe handle mixed INTEGER and REAL some way). 2) Parse the expression yourself and determine the types (and know ahead of time if there are problem columns). There might be ways to use some internals of SQLite to help, but SQLite isn't going to do the job itself, as it has n

Re: [sqlite] How to determine the column type?

, but there actually are some cases that are hard or impossible to determine, then those hard cases make it hard to handle the general problem. Thus even without using SQLite's flexibility it types stored in columns, you can't predetermine the type of som

Re: [sqlite] How to determine the column type?

NULL previously to get the type. Part of the issue is that you ARE allowing multiple types (since NULL is its own type), so you need to be prepared for differing types. One big thing to watch out is that columns of NUMERIC type can easily return values of either INTEGER or REAL type. Your sing

Re: [sqlite] How to determine the column type?

each row, and if you have it currently recorded as NULL, check the type in this row and update if needed, otherwise use the recorded type. Note that you need to be prepared for different queries of the same set of columns (or the same query at different times) may give you changing types for a gi

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

then the fact that the fork succeeded is the promise that both processes have the right to access all of their address space. Any page that is writable needs to have swap space reserved, or you have allowed over committing. The OS can delay actually creating the new pages, and thus save some work, b

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

But without virtual memory, many applications combinations that work acceptably now would just fail to run at all. Virtual memory itself isn’t the issue. Also, an OS could fairly easily be set up so an application that start to thrash its virtual memory is dropped in priority to get memory, and

Re: [sqlite] built-in printf() not supporting \n or \t ?

for a newline. You are not typing your line into a C compiler, but the sqlite shell program, so it build strings differently.  ISO C also does not support positional arguments, that is an extension that many compiler provide as I believe it is a common extension used in linux. You also don'

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

extensions are just so commonly available on a variety of platforms that the limitation is minor. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Optimising query with aggregate in subselect.

the specified record by ROWID, if there is a index with the needed data, then the second lookup isn't needed. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] mport SQLite import Latin1 data?

n SQL command, but a command line in the SQLite shell. I don't think the shell is intended to be a 'Do Everything' tool, but a convenience and quick operation tool. As you command line operation shows, it isn't that hard to do the operation with other tools. -

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

hem edit it. The one thing you might not need is how to sort, because unless you directory listing for people to scan and find a person (and if you are, you probably should be asking explicit permission to do so), you generally don't really need to sort names, just be able to search names, and the

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

;last names' as they aren't always last, and 'Surnames' aren't accurate either) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

On 11/11/19 2:57 PM, Jose Isaias Cabrera wrote: > Igor Tandetnik, on Monday, November 11, 2019 02:24 PM, wrote... >> On 11/11/2019 12:50 PM, Richard Damon wrote: >>> Writing 20 UTF-32 characters may ALSO print less than 20 glyphs to the >>> screen. >> Or more, depe

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

On 11/11/19 3:49 PM, Jose Isaias Cabrera wrote: > Richard Damon, on Monday, November 11, 2019 02:37 PM, wrote... > >> No. > Aaaah, my apologies. We are talking about different things. You are talking > about a combination of Unicodes vs. full, character. I take it back.

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

On 11/11/19 2:16 PM, Jose Isaias Cabrera wrote: > Richard Damon, on Monday, November 11, 2019 12:50 PM, wrote... > >> Writing 20 UTF-32 characters may ALSO print less than 20 glyphs to the >> screen. > This is not true, if the string has more or at least 20 UTF32 characters,

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

On 11/11/19 12:39 PM, Jose Isaias Cabrera wrote: > Richard Damon, on Monday, November 11, 2019 11:19 AM, wrote... > >> UTF-32 is a reasonable internal operation format, if code-point >> operations are important. It does not make a good transmission format, > I agree. Th

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

' itself when being printed. Then you need to remember that the one of reasons for providing the combining characters was that it was decided that there would not be created code points for all the possible composed characters, that many would be expressed only as decom

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

nted glyph) of a string in UTF-32 is not trivial, because it could easily be more than one code-point due to combining characters. For many purposes it might not even include the first code-point, as that might be a formatting meta-point like the BOM or a tex

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

On 11/11/19 10:49 AM, Jose Isaias Cabrera wrote: > > Richard Damon, on Monday, November 11, 2019 09:47 AM, wrote... >> On 11/11/19 9:26 AM, Jose Isaias Cabrera wrote: >>> Simon Slavin, on Monday, November 11, 2019 08:50 AM, wrote... >>>> On 11 Nov 2019, a

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

rring data from one system to another. Another option would be to define some user defined code point pair as a graphics escape, and put within it an encoding of a graphics file containing the glyph, but at that point you are really outside of being 'Unicode' -- Richard Damon

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

and even then, someone with turn up whose > name is 'n' recurring to an infinite number of characters or something! > > Cheers, >     Gary    B-) Actually, 'The Artist whose name formerly was Prince' (which wasn't his name, his legal name was an unpronounceable pictograph), breaks every computer system I know. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >> users > ___ > sqlite-users maili

Re: [sqlite] Deterministic random sampling via SELECT

On 11/7/19 5:13 PM, Doug Currie wrote: > On Thu, Nov 7, 2019 at 4:23 PM Richard Damon > wrote: > >> One thought would be to generate a ‘hash’ from part of the record, maybe >> the record ID, and select records based on that value. The simplest would >> be something lik

Re: [sqlite] Deterministic random sampling via SELECT

> On Nov 7, 2019, at 2:15 PM, Merijn Verstraaten wrote: > >  >> On 7 Nov 2019, at 19:16, David Raymond wrote: >> >> Along those lines SQLite includes the reverse_unordered_selects pragma >> https://www.sqlite.org/pragma.html#pragma_reverse_unordered_selects >> which will flip the order it send

Re: [sqlite] Roadmap?

Anything much more complicated  could easily require that SQLite update the whole table row by row, and that likely would require making sure that nothing else was looking at the database, as it might not be possible to keep the view consistent. -- Richard Damon ___

Re: [sqlite] Roadmap?

and computing the mean and stdev from that in code, as was shown earlier in the thread, but having STDEV as a built-in summary function could be useful. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mail

Re: [sqlite] Roadmap?

acters, that this can be a language specific problem, and Unicode can't really solve that issue. (Two langauges might use some of the same characters, but treat them differently for sorting). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Standard deviation last x entries

unbiased estimates" are undefined for sample-size == 1) >>> >>> Finally for those interested, the CTE-based "iterated Square-Root", >>> cut out for an isolated calculation of sqrt(2). >>> >>> With r(s2, s, i) As (Select 2, 1, 1 Union All >>

Re: [sqlite] Standard deviation last x entries

make a UDF >>> as I am doing this in an Android phone app) but I can do this last step >>> in >>> code. >>> >>> RBS >>> _______ >>> sqlite-users mailing list >>> sqlite-users@mailinglists

Re: [sqlite] Standard deviation last x entries

On 10/12/19 11:23 AM, Richard Damon wrote: > On 10/12/19 10:08 AM, Bart Smissaert wrote: >> How do I get the standard deviation of the last 4 entries (there could be >> less than 4) of an integer column grouped by an integer ID entry in another >> column in the same table. &

[sqlite] /

be considered a sample you need to make a small adjustment in the formula to Estimated Variance of Popultion = S2 / (N-1) - S * S / (N * (N-1)) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

t; http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users My guess is that column mode doesn't understand all the strangeness that comes with Unicode and fonts, and probably expects that each code point is exactly the same width. I note that at least on my computer th

Re: [sqlite] Conflict between snapshots and checkpoints

olation appears to be a Term of Art, not a Standardized Term so it can be forgiven if it isn't used in the documentation. Also, it seems to imply non-serialized writes, which SQLite does NOT provide, so isn't even really applicable. -- Richard Damon

Re: [sqlite] Conflict between snapshots and checkpoints

me Database Connection SQLite provides isolation between operations in separate database connections. However, there is no isolation between operations that occur within the same database connection. -- Richard Damon ___ sqlite-users mailing list sql

Re: [sqlite] Conflict between snapshots and checkpoints

yourself). By passing the snapshot and not the connection with transaction with the snapshot, you can be sure that the receiver can't disturb the session and invalidate the snapshot. By opening the snapshot, the receiver is able to recreate the database at that point, to read its state, but

Re: [sqlite] Conflict between snapshots and checkpoints

allow that transaction to be committed or invalidate the snapshot until the snapshot is freed. What that would ultimately do is cause your program to get an error from SQLite3 farther down the road when you did some action on the connection that would potentially invalidate your precious snaps

Re: [sqlite] SQLite - macOS

> On Sep 23, 2019, at 1:25 PM, Simon Slavin wrote: > >> On 23 Sep 2019, at 5:53pm, Pierre Clouthier >> wrote: >> >> Can anyone explain how to write UTF-8 in SQLite on the Mac? >> >> We use this statement: >> >> sqlite3_exec("PRAGMA encoding = \"UTF-8\";") > > This is not a SQLite problem

Re: [sqlite] SQLite - macOS

Not sure what you code is doing, and you aren’t showing how you are getting your 'é' into SQLite, but U+FFFD is the standard character for malformed data, so something somewhere is complaining about converting something into UTF-8. Also, you CAN’T have a UTF-8 value like 0xC3A9, as that is not

Re: [sqlite] What is wrong with this SQL?

converted to a LEFT JOIN. INNER JOIN only returns records that match BOTH tables, so to pass the first INNER JOIN the record need P.SEX = 'Male', and then to pass the second it would need P.SEX = 'Female' at the same time.  -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT vs BEGIN

t was standard (if not universally supported, but that is somewhat common with SQL) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .save always errors: database is locked

'save' a database after working with it. The 'Save' command is basically similar to the 'Save As' command for a document. Since the database is current open, trying to save back over the original copy can't be done, as it is open for reading, and also doesn't need to

Re: [sqlite] Unexpected REINDEX behavior.

planner chose a different plan which works better. Perhaps you could look at and compare the query plans of the two different scenarios. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update request

> On Aug 15, 2019, at 10:37 AM, Simon Slavin wrote: > > > > says that sqlite_master cannot be changed. > > > > tells you how to change it. > You under quote, the faq says it “can not be changed (except

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

syntax error with miss-matched braces, and letting your editor find matching braces it tends to be fairly quick to locate it. The key is to compile (or have the editor syntax check) often enough that you can't make two opposing errors like thi

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

uding some short > description. There have been many great ideas and it would be a pity if they > got lost in the depths of the mailing list ;) > > Just my 2cts > Thomas -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: Explicit "read transaction" with journal_mode=WAL.

If, and it is possible for there to be sequencing to enforce it, You KNOW that step 1, get a read transaction (which the OP presumes implies includes getting the lock) occurs before step 2, and thus step 4 seeing changes from step 3 says something is wrong. Yes, if you only can use the database

Re: [sqlite] [SPAM?] storing blobs in a separate table

ll blobs, it may be better to keep them in the main table. It is always good to know the WHY behind these rules of thumbs, so you know how to apply them. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: Explicit "read transaction" with journal_mode=WAL.

utations, Met vriendelijke groeten, Mit besten >> Grüßen, >> Olivier Mascia >> >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _

Re: [sqlite] [SPAM?] Re: Explicit "read transaction" with journal_mode=WAL.

re it really needs to access the database that it establish its 'end-mark'. Doing the SELECT is one way to do that, adding some variation of BEGIN that immediately starts a SHARED lock would be another. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: [EXTERNAL] Determining valid statement placeholders.

But he was to be able to provide the args as {‘0’:’one, ‘10’:’ten’} and since he only uses positional rags 1 and 10 that it be OK, i.e. positional args are treated as key word args, and only those actually used are needed. THAT can’t be provided by the API. > On Jul 22, 2019, at 9:22 AM, Keith

Re: [sqlite] [SPAM?] Re: [EXTERNAL] Determining valid statement placeholders.

The problem is you are defining your problem differently than SQLite does, so it can’t help you. To SQLite, a query with ?10 in it has (at least) 10 positional parameters, and if you are defining that the user needs to explicitly provide values for all parameters, (by SQLite) that means they wi

Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

One big issue is that in general (as I remember right) pragmas generally affect the connection, not the database itself, so shouldn’t change how the schema is interpreted, or another connection (or before issuing the pragma) might interpret things differently and possibly see the database as som

Re: [sqlite] [SPAM?] Re: Grammar police

(the n sound breaks up the double vowel). words that begin with an initial unstressed h-vowel might not have the h really vocalized, so the following sound is vowelish, so it takes 'an' (there isn't enough h to break up the vowel cluster). This can largely be affected by the accent o

Re: [sqlite] [SPAM?] Re: [SPAM?] Is WAL mode serializable?

et a busy that tells you that you will NEVER be able to upgrade, then you need to close the transaction, and when you restart, you should forget the previous data you read (at least as it relates to what you might want to write) as it might have changed, so you need to read it again t

Re: [sqlite] [SPAM?] Re: Is WAL mode serializable?

nsaction and re-do its reads before it can do its write. The differences is that in WAL mode, one transaction doesn't need to wait for all the reads to finish before it can start. -- Richard Damon ___ sqlite-users mailing list s

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

On 6/14/19 7:15 AM, R Smith wrote: > > On 2019/06/14 4:23 AM, Richard Damon wrote: >> On 6/13/19 10:51 AM, R Smith wrote: >>> On 2019/06/13 4:44 PM, Doug Currie wrote: >>>>> Except by the rules of IEEE (as I understand them) >>>>> >>>>

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

ems), so defining the result is much better than just defining that anything could happen. It could have been defined as just a NaN, but having a special 'error' value for +Inf or -Inf turns out to be very useful in some fields. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

-0.0 < 0.0 is FALSE, so -0.0 is NOT "definitely left of true zero" -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: round function inconsistent

u can easily get answer that seem wrong (but actually follow the rules). This is why many business application and the supporting languages for them adopted a 'Decimal' number that stores numbers with decimal fractions (base 10), to get around the fact that as people we are used to thinking in numbers base 10. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to set access permissions to protect a database file?

so unauthorized applications can't access the file. It isn't perfect protection, because someone still will have the ability to delete/overwrite the file, to protect from that seems to need the protection method you describe, but if you are only trying to

Re: [sqlite] [SPAM?] Re: round function inconsistent

ers (do you math in pennies or a fraction of a penny, so the binary issue isn't an issue any longer, since 0.5 is a number that IS exactly representable, so the rounding point is exact). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mai

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

eves > that someday, as John Lennon sang, "...the world will live as one." ;-) > > Happy dating... > > josé It depends a lot on how you want to define a 'week' and what you are going to use it for. If printing a traditional calendar, a one d

Re: [sqlite] Problem with REAL PRIMARY KEY

that is down in implementation details (a 'Double' has less than 59 significant bits, so can not express the value 0x7ff) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help with sqlite3_value_text

> On Apr 12, 2019, at 12:58 PM, x wrote: > > I’ve been asking myself if I could have done the above more efficiently as > sqlite’s converting the original string then I’m converting it and copying > it. While thinking about that I started to wonder how c++ handled utf8/16. > E.g. To access t

Re: [sqlite] Remove row to insert new one on a full database

On Apr 5, 2019, at 12:31 PM, James K. Lowden wrote: > > On Fri, 5 Apr 2019 15:45:10 +0300 > Arthur Blondel wrote: > >> The data is always the same. That's why removing one row should be >> enough to insert a new one. >> My problem is that some times I need to remove many rows to add one >> new

Re: [sqlite] Remove row to insert new one on a full database

every record added, will smooth out the access time, at the cost of possibly higher disk usage at times (but maybe a better ratio of size per records). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] ANN: SQLite3 Decimal Extension

of information) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Remove row to insert new one on a full database

On 4/4/19 11:35 PM, Simon Slavin wrote: > On 5 Apr 2019, at 4:14am, Richard Damon wrote: > >> I think is logic is to attempt to insert a row, and if rather than >> inserting it, the call returns the error condition, 'Database Full' > Okay. So now we understand what

Re: [sqlite] Remove row to insert new one on a full database

; ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Remove row to insert new one on a full database

om in the database, as it can bring together all the odd holes from the various pieces of deleted data.  -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: UPSERT with multiple constraints

t;> with the new name and A, B, C properties. >> >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing li

Re: [sqlite] DATA RACE on sqlite3GlobalConfig.isInit

seeing that isInit was false, does an initialization that would be improper because it had already been done, then THAT would be a data race, but its scope is bigger than just those two lines. -- Richard Damon ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Handling ROLLBACK

On Mar 3, 2019, at 8:32 AM, Simon Slavin wrote: > > To summarize, the list feels that this is an incorrect model > >BEGIN; >... first set of commands >ROLLBACK; >... second set of commands >END; > > whereas this is how things are meant to work: > >BEGIN; >... first

Re: [sqlite] ON CONFLICT with partial indexes

> On Feb 18, 2019, at 10:23 AM, Charles Leifer wrote: > > Thanks for the explanation. So does this mean that two identical queries > can have completely different query plans depending on whether they use a > parameters vs literal values embedded in the SQL string? > Remember the query plan is

Re: [sqlite] sqlite 3.37.1: void function returns value

> On Feb 11, 2019, at 6:33 AM, Peter da Silva wrote: > > I am pretty sure that the code is not legal C because it's using the return > value of a void function, as well as returning a value from a void > function. Compilers that "do what I mean" and accept it are in error. It's > certainly possib

Re: [sqlite] GROUP BY and ICU collation

; 'Šudden' > Actually, the way those collations work is that on first pass, S and Š compare equal, but if two words on first pass compare equal, then effectively a second pass take place, and on the second pass, S and Š compare with an order (I thought I remembers there even being some cases that needed a third pass). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database locking problems

Some operations can be order of microseconds if the data resides in cache, slightly longer if the database is in flash memory, and perhaps 100s of microseconds to milliseconds if the database is on spinning rust, and the operation needs to access the drive to get the needed data. -- Richard Damo

Re: [sqlite] Database locking problems

hreads, then the fact that other DBMS run the database server in a separate process handles a lot of the sharing issues (at the cost of overhead). SQLite, gets rid of a lot of that overhead at the cost of the application needs to follow a set of rules. -- Richard Damon

Re: [sqlite] Database locking problems

On 1/20/19 4:51 PM, andrew.g...@l3t.com wrote: > James K. Lowden wrote: >> On Sat, 19 Jan 2019 08:07:42 -0500 Richard Hipp wrote: >>> The busy timeout is not working because you start out your transaction >>> using a read operation - the first SELECT statement - which gets a read >>> lock. Later

Re: [sqlite] Conditional lowering of value

ote that this database is obviously using SQLite's variation from SQL of mixed type columns, as it appears that totalUsed is likely a column that is normally numeric, but sometimes a string. -- Richard Damon ___ sqlite-users mailing list sqlite-us

Re: [sqlite] A Minor Issue Report: Extra const Keyword in PragmaName zName

hat is declaring that zName is an immutable pointer to a immutable string/character, which is actually likely true, as the code shouldn't be changing the names of pragmas. Your modified definition says that the code is allowed to poke through zName and change the string represen

Re: [sqlite] Using sqlite3_interrupt with a timeout

ds, I don't think SQLite is spending time checking a flag to stop in the middle of processing a step to allow the processing to terminate early without a result. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >