[sqlite] whish list for 2016

records found in a search. For now, the current method of create new, drop and rename, isn't unworkable (and mostly hidden in an abstraction layer), but being able to directly add a field would be nice. -- Richard Damon

[sqlite] whish list for 2016

ide breadth of Databases, but will still use an Abstraction layer. ) -- Richard Damon

[sqlite] Can SQLite be used from DLL

i-run time problem. If the DLL and the mainline are using different copies of the run time this can happen (your giving free a block of memory its malloc didn't allocate). The general fix is that if you are using DLL's then EVERYTHING in the program needs to use DLLs for anything used in any DLL to use the same copy. -- Richard Damon

[sqlite] out of the void: xDlSym

would work, giving you a working function pointer. It was never promised by the standard to work in general, and there are machines where it doesn't work (you just need a larger program space than data space). -- Richard Damon

[sqlite] Random-access sequences

was a quantum leap in range, adding 32 doubling to the limit, which will take a while to catch up (which we likely will). The 140 terabyte limit is something that I could see being hit now in some applications. -- Richard Damon

[sqlite] 64bit DLL vs 32bit

64 bit code needs to make sure it puts the data in the lower 4GB, or the thunk layer needs to know enough about the data to copy it. This works for WOW64, as the 64 bit side is code designed to make it work with the thunking layer. For arbitrary 64 bit code, the thunking layer won't know enough about what needs to be copied into accessible memory. -- Richard Damon

[sqlite] 64bit DLL vs 32bit

VB6 ActiveX > exe could access a 64 bit SQLite dll? > All this only comes into play for me when using 64 bit VBA in Excel. > I have no problem to access the 64 bit SQLite dll from 64 bit VBA. > > RBS > > On Sun, May 15, 2016 at 7:12 PM, Richard Damon > wrote: > >

[sqlite] Password Protect SQLite DB

ent: Friday, May 20, 2016 4:11 PM > To: SQLite mailing list > Subject: Re: [sqlite] Password Protect SQLite DB > > On 5/20/16, Agarwal, Rajesh wrote: >> Are there any extensions available >> to password protect the SQLite database? > The SQLite Encryption Extension (S

Re: [sqlite] Bug: SQLite's include guards are reserved identifiers

be removed (or have been removed -- perhaps it's now too late). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug: SQLite's include guards are reserved identifiers

by a programmer who doesn't own a domain? Owning a domain is not a requirement for writing software. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

ariable is perfectly legal (but perhaps VC is warning that the presence of the variable is going to make that initilization less efficient, as it can't just make a static copy of the initialization value and memcpy that to the variable). -- Richard Damon ___

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

99 apparently decided that rather than making the programmer make the transformation to update a few 'call time' values, it was better to make the compiler do that work (as it would be less error prone). -- Richard Damon ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Thread safety of serialized mode

The issue here (with the INC instruction) isn't 'Thread' but "Multi-Master/(Core)' On as single processor, the INC is atomic. When you have a possibility of multiple masters (or cores) access the same location, you need to be more careful, and that LOCK prefix due to what it needs to do to

Re: [sqlite] Inserting a new record (anywhere) into a table of ordered records that have an integer auto-increment primary key

/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] Changing ID's to UUID

hat number, but it is about right, we have used about 1/2 the bits, which about the point you expect the first duplicate) -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailma

Re: [sqlite] Autoincrement sequence not updated by UPDATE

might have been deleted. If it strictly just used the auto-increment value then any use of that as a foreign key in some other table gets broken. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglist

Re: [sqlite] Inserting a new record (anywhere) into a table of ordered records that have an integer auto-increment primary key

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 -- R

Re: [sqlite] Inserting a new record (anywhere) into a table of ordered records that have an integer auto-increment primary key

anged too, all in an 'atomic' transaction. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] does integrity check ever modify the db file?

bypass sqlite and directly manipulate the database file, you need to understand the temporary auxiliary files and process those too, or make sure that you only are working with files that are in a clean state, so it is a single file. -- Richard Damon

Re: [sqlite] How does one block a reader connection?

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

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

t's best handled at the user project level. The problem with this is that if the header file is put in a namespace in the user code, then the source file that defines these functions needs to also be changed to put the files in that same namespace, or the things being defined won't be found. -- Richard Damon

Re: [sqlite] Get rid of old-style function declarations/definitions in lemon.c

a function. The empty parameter list means with an unspecified parameter list in C. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] If I got many to many relationship data first, how do I insert them to my table?

rder is confirmed and payed for) . While the order is being built, you normally keep track of the data in a separate place, a 'shopping cart', and for those things, you will be keying to shopping cart id (a session or cookie id). -- Richard Damon ___ sqli

Re: [sqlite] Selecting NEXT / PREVIOUS recurring item in a column

> 5 AND ID = "john" ORDER BY progr_no ASC LIMIT 1 (I think that's correct, doing strictly from memory). Not sure what the best index would be, probably an index on ID, progr_no since ID needs an exact match -- Richard Damon ___ sqlite-users ma

Re: [sqlite] UTF8-BOM not disregarded in CSV import

it does have another meaning, things become messy, and we are stuck with trying to decide which wrong thing we should do, -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] Article: UUID or GUID as Primary Keys? Be Careful!

possible character (of course, since we are only storing ASCII characters, we need to declare that so they take only 1 byte per character). Comparing that to 128 bits (16 bytes) is the 9x factor. Richard Damon ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Article: UUID or GUID as Primary Keys? Be Careful!

On 6/10/17 6:31 PM, R Smith wrote: On 2017/06/10 8:24 PM, Richard Damon wrote: On 6/10/17 8:13 AM, R Smith wrote: The typical usage, storing full text UUID minus braces in an ASCII/UTF-8 sequence will result in a hair over 2.3 times[1] the storage of INTs. Not really that bad I think

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

a compiled option. kinda looks like all those are actually bad. But that's not 217 of those... On Thu, Oct 5, 2017 at 6:59 PM, Richard Damon <rich...@damon-family.org> wrote: On 10/5/17 8:06 PM, James K. Lowden wrote: On Fri, 29 Sep 2017 16:55:05 -0400 Igor Korot <ikoro...@gmail.c

Re: [sqlite] Foreign keys - one to one, one to many relationship

of larger blobs, I push those out to a different table, and enforce (Through my software, not a unique constraint as mentioned) the one-to-one relationship. There is no reason to keep the blob on a record that is queried constantly. On Sat, Oct 14, 2017 at 6:37 AM, Richard Damon <rich...@da

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

e to force a default, you would need to look through all the code, make a list of all the option macros used, then see if there are unconditional defines for them (perhaps they are always given a value, possibly based on other conditions. Leaving them undefined and letting the warning trigger is

Re: [sqlite] Foreign keys - one to one, one to many relationship

please post again. Simon. One way to make them build one to at-most-one relationships is too add a unique index on the foreign key, then it can only occur once. A True one-one relationship by the normailization rules says that they should all be in the same record. -- R

Re: [sqlite] Problem with mailing list

it to you. (unless you get messages from the list in something like a digest). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Amalgamation compilation with SQLITE_THREADSAFE=0

the space is a lot of work for little gain. Yes, there is a use case where you delete a lot of records and it will be a long time before more records are created, and perhaps freeing the space may be important, so in that particular case, the program should do the vacuum. -- Richard Damon

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

tic wrapped on overflow like unsigned, then the program has a problem. My guess is that the code is good enough not to have the overflow issue. That sort of warning is aimed at 'sloppy programmers' who think that just because it seems to work, it must be right and to the standard. -- Richard Da

Re: [sqlite] Joining list?

ypically has to confirm their subscription). But again, thanks for letting me know and sorry for all the noise! -aps Not all mailman lists require confirmation. It sounds like this list may be setup for just approval. -- Richard Damon ___ sqlite-users

Re: [sqlite] Compiling spellfix for sqlite3

" list of places are the user include path, and it is fairly normal that the "" list includes the current directory. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Re: SQLITE bug

inal state, and it can't be "rolled back" because some data is not in it's original state. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Richard Damon Gesendet: Sonntag, 03. September 2017 19:13 An: sqlite-users@mai

Re: [sqlite] SQLITE bug

the obvious perils in the cases you noted? One BIG example of a place to overrule the default ID assignment via auto-increment is in restoring a backup. Here, you NEED to ID to be the same as before so Foreign keys in other tables stay pointing to the right record. -- Richard Damon

Re: [sqlite] How to create primary key from two another PK's?

__ 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] "BIGINT" doesn't act like INTEGER on table creation [Bug]

, making the big key the primary key would make sense. Disclaimer: This is only my opinion, well, I'm not completely alone in it, but it is still an opinion and not a general SQL prescription. -- Richard Damon ___ sqlite-users mailing list sqlite-users

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

If it was meant that EVENTUAL, after an impossibly long time, you will get a collision, that is being absurd. I can say with better certainty that long before that happens, the computers running this database are going to break, so we will never get to the point of the collision. -- Richard Dam

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

g an SQLite database with 2^64 non-trivial records in a single table is likely going to have other issues besides unique key collisions. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

nuscule in the period of the lifetime of a typical computer), it seems to be a reasonable assumption. A big part might be the consequences of a collision. JcD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.o

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

the intended sphere where there are issues still to be resolved. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Need SQLite datafiles to be locked on OS level (Windows)

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

Re: [sqlite] Stored Procedures

s SQLite is often compared as a better way to get information then using simple disk i/o, so the 'cost' of using SQLite (compared to the alternative) shouldn't include the base time to read the file, but only any extra i/o above that. -- Richard Damon ___

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

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

Re: [sqlite] Criteria to define two fields as Primary Key or Unique

would be a second independent constraint. UNIQUE(id_user, login) doesn't make each item listed unique, but says that there that there can be only one record for each unique combination. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

only one pending subscription for a given email address (and these by default expire after 3 days), so if the botnet is spamming the subscription address, the victim gets just one email every 3 days. It should also be possible to log these IP addresses and excess

Re: [sqlite] Insert with an '

t inserting data from some source into a SQL string. Using prepare is the best, at a minimum you need to run it through a quoting function appropriate for that language. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] new Error database disk image is malformed

o keep the worker threads simple. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] primary key in another column

all the work is done, the manager table is discarded. I'm still not sure I understand, but: while you are building out this manager table, can't you leave fileName column blank, and then right before processing, run UPDATE A SET fileName='prefix_'||ID; on

Re: [sqlite] primary key in another column

is now universal, can be applied to any table. If I modify SELECT inside it to fit specific purpose, forEachRow will use universality. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Richard Damon [rich...@damon-family.org

Re: [sqlite] -Wsign-compare warning in lempar.c

yy_lookahead[0]) );    ^ Nick Looks like not a problem. The danger of comparing a signed value to an unsigned is that you can get an unexpected result if the signed value is negative, but in this case we first check that i is positive, so that issue never occurs. --

Re: [sqlite] [EXTERNAL] (no subject)

aps not obvious. > > > Cheers, > Ryan > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > __

Re: [sqlite] Kind of pivot table

ivide up those numbers into bins. To get rid of the bias you generally need to throw out some values so you have an equal number in each bin (unless you luck out and start having an even number in each bin). Your second solution did this. If your first solution was good enough, so should have MOD.

Re: [sqlite] Database is locked

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

Re: [sqlite] Persistent snapshots and rollbacks

you select such that start is less than or equal to the time, and the end is greater than the time or NULL. You can purge old records based on the end time being old enough, or total roll back by deleting records with start greater than the time, and changing end date greater to NULL. -- Richard

Re: [sqlite] Persistent snapshots and rollbacks

On 10/5/18 2:37 PM, Daniel Kraft wrote: > Hi! > > On 2018-10-05 20:27, Richard Damon wrote: >> On 10/5/18 2:19 PM, James K. Lowden wrote: >>> Add a "version" column to your table. Create views that (using a >>> self-join) show only the latest version.

Re: [sqlite] unsubscribe

> 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] Broken Foreign key

man/listinfo/sqlite-users > > > _______ > 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] Using sqlite3_interrupt with a timeout

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

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] Database locking problems

s, 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

f 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 Damon ___

Re: [sqlite] Question about floating point

decimal digits, but by periodically rounding to that two decimals resets the rounding error. The error is in doing this sort of rounding when the input numbers are NOT known to be 'exact' to those two digits, but you round to that precision. THAT rounding will increase the error in the calculation. --

Re: [sqlite] geopoly - rules re data entry

it really necessary to ensure a counterclockwise > order when a polygon shape is entered for the first time in the table. > > regards, > > Graham > My guess would be that SOME operations will need the vertices in the right order, and others will work regardless of order. -- Ric

Re: [sqlite] Conditional lowering of value

ously 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-users@mailinglists.sqlite.org http://

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

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 representing the pragma

Re: [sqlite] [EXTERNAL] The "natural" order of the query results.

s in Schema, not performance tuning, and is expected to be added at the very end of development (and by implication, will have no noticeable impact on the results). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

the same polygon (4), or > if they just overlap (1). > > I haven't documented those behaviors, because I wanted to leave myself > some wiggle room in case I need to change the behavior in the future. Maybe it should say 'Non-Zero' or 'Greater than Zero' rather than true,

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

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] Remove row to insert new one on a full database

s 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

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 OP meant

Re: [sqlite] ANN: SQLite3 Decimal Extension

bit 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

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.sqlite.org/cgi-bin/mailman/

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] [SPAM?] Re: UPSERT with multiple constraints

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 list > sqlite-users@mail

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] DATA RACE on sqlite3GlobalConfig.isInit

s 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-users@mailinglists.sqlite.

Re: [sqlite] GROUP BY and ICU collation

ond 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] 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

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

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

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?

s 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 protect against Murphy, and not Machiavelli (as the sa

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

action 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@mailinglists.sqlite.org http://mailinglists.sqli

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?

-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: [EXTERNAL] Re: Should SQLite distinguish between +0.0 and -0.0 on output?

ng 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] Getting the week of the month from strftime or date functions

hn 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 day week makes a lot of sense. The first

Re: [sqlite] Problem with REAL PRIMARY KEY

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] [SPAM?] Re: [SPAM?] Is WAL mode serializable?

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 to be

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

at 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 one talks with (which can be related but different than the dialec

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

iss-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 this that hide each other. -- Richard Damon

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] Backward compatibility vs. new features (was: Re: dates, times and R)

scription. 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] .save always errors: database is locked

ave' 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 be done. -- Richard Damon

Re: [sqlite] INSERT vs BEGIN

(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] 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

  1   2   >