Re: [sqlite] page_size on ATTACH-ed databases

2016-08-16 Thread Scott Robison
>> sqlite> > >> sqlite> pragma rd.page_size=4096; <- SET ATTACHED DB PAGE > SIZE TO 4K > >> sqlite> pragma rd.cache_size=32; > >> sqlite> pragma rd.mmap_size=0; > >> 0 > >> sqlite> pragma rd.busy_timeout=57000; > >> 57000 &

Re: [sqlite] 64-bit SQLite3.exe

2016-08-12 Thread Scott Robison
On Fri, Aug 12, 2016 at 12:02 PM, Warren Young wrote: > On Aug 11, 2016, at 7:50 PM, Scott Robison > wrote: > > > >> It’d be a lot of work just to avoid rebuilding for 64-bit, but maybe it > >> would be an interesting project for someone. Like a master’s

Re: [sqlite] 64-bit SQLite3.exe

2016-08-11 Thread Scott Robison
On Thu, Aug 11, 2016 at 6:37 PM, Warren Young wrote: > On Aug 11, 2016, at 3:19 PM, Scott Robison > wrote: > > > > I think you guys are just talking past each other. > > Well, at least one of us isn’t communicating clearly, that’s certain. I > just don’t yet know if

Re: [sqlite] 64-bit SQLite3.exe

2016-08-11 Thread Scott Robison
Lite access more than 4 GiB with appropriate hardware & OS support? Sure. Should a 32 bit build of SQLite stretch to support managing the address space itself as might be required? I don't think so. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How restrict access to SQLite database?

2016-08-09 Thread Scott Robison
sip2sip.info > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing lis

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

2016-07-13 Thread Scott Robison
quot; then sure, you are correct. But we still have to try to quantify what might break with any change and quantify the utility of the change. If anything, it is a statement that allows one to easily argue for not making a change to an include guard where the code is currently working for so many develope

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Scott Robison
On Jul 13, 2016 11:14 AM, "Simon Slavin" wrote: > > > On 13 Jul 2016, at 5:22pm, Scott Robison wrote: > > > His program is not involved. Just the SQLite shell. > > He's feeding the shell with a pre-prepared file. Depending on how the OS command shell w

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

2016-07-13 Thread Scott Robison
On Jul 12, 2016 10:32 PM, "Cory Nelson" wrote: > > While uncommon, it is not unheard of for apps to use include guards to > check for a library's existence. While it is indeed not in compliance, > in practice fixing this may affect existing SQLite users. Good point, though personally I would weig

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Scott Robison
On Jul 13, 2016 9:55 AM, "Simon Slavin" wrote: > > > On 13 Jul 2016, at 4:09pm, S.Ajina wrote: > > > Doing the same with the current version of sqlite3.exe (version 3.13.0) corrupts the database records when there are extended characters > > I would guess that your program is handing extended cha

Re: [sqlite] page checksums (was Re: Bad db feature request)

2016-06-29 Thread Scott Robison
On Jun 29, 2016 10:14 PM, "Roger Binns" wrote: > > On 29/06/16 19:13, Scott Robison wrote: > > Given the nature of VFS, it is trivial* for anyone to create a module to > > provide this very functionality. So you can write it yourself! > > > > *Not r

Re: [sqlite] page checksums (was Re: Bad db feature request)

2016-06-29 Thread Scott Robison
On Jun 29, 2016 5:08 PM, "Darren Duncan" wrote: > I notice that the ticket rejection didn't include any rationale or explanation, or I didn't find any when I looked. What was the rationale for rejecting that ticket? > > I believe that SQLite having page checksums would be a good idea whose time h

Re: [sqlite] Conversion failure

2016-06-25 Thread Scott Robison
ou are trying, as it would involve knowing what code page was in use at the time of object creation. This would be even worse if multiple machines created objects over time. But I'm driving across country and can't check source to confirm this. > > It is not UTF-8 and it is

Re: [sqlite] Conversion failure

2016-06-24 Thread Scott Robison
owever, I am sleep deprived and anxiously awaiting a vacation to begin in a few hours so it may not have been clear. :) In fact, I may just bug out early. It's largely a ghost town around here at the moment anyway. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Conversion failure

2016-06-24 Thread Scott Robison
On Fri, Jun 24, 2016 at 12:54 PM, Keith Medcalf wrote: > > > On Friday, 24 June, 2016 12:17 -0600, Scott Robison said: > > > Okay, rather than guessing, I just did a test from a Windows 10 command > > prompt. I am getting appropriate UTF-8 sequences. Here is my experi

Re: [sqlite] Conversion failure

2016-06-24 Thread Scott Robison
On Fri, Jun 24, 2016 at 12:03 PM, Scott Robison wrote: > On Windows, when you get a string of characters, you either get an ANSI > string using some code page, or you get a wide character string. > > When you get an ANSI string, it is just a sequence of 8 bit bytes. UTF-8 > is als

Re: [sqlite] Conversion failure

2016-06-24 Thread Scott Robison
to UTF-8. If I am mistaken on that point, I apologize. If the two alt-code byte sequences create data your C++ code can then process (because it's valid UTF-8), you'll know for certain that the SQLite shell on Windows does not process UTF-8 for console IO, just internally to the database layer. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

2016-06-23 Thread Scott Robison
the db does corrupt how can i analyse which code is > causing the db corrupt It's hard to suggest what to do to prevent corruption when it seems you're already doing those things. > . > > > > > On Friday, June 24, 2016 1:27 AM, Scott Robison < > sc...@ca

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

2016-06-23 Thread Scott Robison
y, June 23, 2016 12:57 PM, mon siong > wrote: > > > > Both processes on a single computer accessing a local file system. The > sqlite file is store in USB drive , and I notice if the database corrupt , > the journal or shm file is also corrupt . > > > &g

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

2016-06-22 Thread Scott Robison
On Jun 22, 2016 9:25 PM, "mon siong" wrote: > > > PHP use 3.7.7.1 and my c program use 3.8.4.3 . Different version of sqlite is fine ? > I tried WAL and Delete Journal Mode , both type cause the db to corrupt . > > Under which scenario, two different global variables will be used ? Is either proc

Re: [sqlite] Referencing a column alias (subquery) as function parameter

2016-06-20 Thread Scott Robison
rentDate, ac, MyFn(c1,ac,CurrentDate) as xc1, MyFn(c2,ac,CurrentDate) from (select c1, c2, CurrentDate, (case ActiveCol when 0 then c3 else c4 end) as ac from test) Other possibilities exist to avoid restating the case expression mutiple times, but this should work. Haven't tested it with real da

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-27 Thread Scott Robison
even download it and start using it. Good points. Of course, will billions of deployments around the world, SQLite isn't hurting for devs or users (whether they know they're using SQLite or not). :) -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-27 Thread Scott Robison
On Fri, May 27, 2016 at 2:10 PM, Simon Slavin wrote: > > On 27 May 2016, at 7:50pm, Scott Robison wrote: > > > I'd like to see some sort of hybridized approach myself (for my own > > projects, not advocating for SQLite), where those who want email only can > > us

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-27 Thread Scott Robison
On Fri, May 27, 2016 at 4:43 AM, Jonathan Moules < jonathan-li...@lightpear.com> wrote: > I think there are two different use cases for a mailing list such as this, > and they're each better served by different access method; either email or > forums. > > One use case is the individual with a long

[sqlite] Time & between, midnight wrap around

2016-05-15 Thread Scott Robison
Off the top of my head: Select case when t1 < t2 then t3 between t1 and t2 when t1 > t2 then t3 >= t1 or t3 <= t2 end You might need to tweak it to handle the case when t1 = t2 if needed. Could mean one minute or could mean 24 hours depending on your pov. Hello, BETWEEN doesn't give the result I

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

2016-05-15 Thread Scott Robison
On May 15, 2016 8:06 AM, "Tony Papadimitriou" wrote: >>> > (Many open source projects have bugs waiting for months or years for someone to be bothered to fix, often driving people away!) > > To sum it up, a big thanks to Richard and his team! True. Last December I received a notice that a patch I

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

2016-05-15 Thread Scott Robison
On May 15, 2016 6:30 AM, "Tim Streater" wrote: > > What's all this about licences. AIUI, SQLite is explicitly in the public domain. Meaning the question of licence doesn't arise. The question of license arises when comparing two pieces of software. While PD isn't a license per se, it is license-e

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread Scott Robison
t; > > > > _______ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread Scott Robison
, the question is often asked "what does PostgreSQL do?" Sadly, the backward compatibility requirements prohibit SQLite from being a 100% feature / implementation match. -- Scott Robison

[sqlite] How to get 1 row with no null columns

2016-05-11 Thread Scott Robison
nglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] 64bit DLL vs 32bit

2016-05-10 Thread Scott Robison
On Tue, May 10, 2016 at 9:56 AM, Jeremy Nicoll < jn.ml.sqlu.725 at letterboxes.org> wrote: > On Tue, 10 May 2016, at 16:26, Scott Robison wrote: > > > I believe the tools provided by the site statically like SQLite so no DLL > > is required. The DLL is provided as a cour

[sqlite] 64bit DLL vs 32bit

2016-05-10 Thread Scott Robison
On May 10, 2016 8:48 AM, "Jeremy Nicoll" wrote: > > On Tue, 10 May 2016, at 14:45, J Decker wrote: > > On Tue, May 10, 2016 at 2:23 AM, Jeremy Nicoll > > > > I was under the impression that I'm using the 64-bit DLL on a W8.1 > > > 64-bit system, with the 32-bit tools. Does that mean that there's

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
s.] > > Regards > David M Bennett FACS > > Andl - A New Database Language - andl.org > > > > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
l.org > > > > -Original Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > > bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison > > Sent: Monday, 9 May 2016 4:13 PM > > To: SQLite mailing list > >

[sqlite] SELECT DISTINCT question

2016-05-09 Thread Scott Robison
"S#") as x from s group by city order by x asc); But I'm not a SQL master. Distinct used with group by seems redundant, but again, I might just not understand how they are useful together. -- Scott Robison

[sqlite] Fastest way to backup/copy database?

2016-05-04 Thread Scott Robison
On Wed, May 4, 2016 at 12:38 PM, Dominique Devienne wrote: > On Wed, May 4, 2016 at 5:51 PM, Scott Robison > wrote: > > > > > This is going to become a bigger problem for us as the database will > > > > only get bigger so any advice welcomed. > > >

[sqlite] Fastest way to backup/copy database?

2016-05-04 Thread Scott Robison
on, sadly. > > > Rob > > > On 4 May 2016, at 16:51, Scott Robison wrote: > > This is going to become a bigger problem for us as the database will >>>> only get bigger so any advice welcomed. >>>> >>> >> Perhaps, rather than backing up

[sqlite] Fastest way to backup/copy database?

2016-05-04 Thread Scott Robison
> > This is going to become a bigger problem for us as the database will > > only get bigger so any advice welcomed. Perhaps, rather than backing up the live data, you create an append only log of each and every query you send to the database. Should you need to restore, you replay the log of stat

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Scott Robison
On Mon, May 2, 2016 at 6:10 PM, Richard Hipp wrote: > On 5/2/16, Scott Robison wrote: > > I don't have an answer, but given that each linux distro of dozens or > > hundreds of independently sourced packages has many separate instances of > > the GPL, that would begin

[sqlite] SQLite vs GPLed software

2016-05-02 Thread Scott Robison
I don't have an answer, but given that each linux distro of dozens or hundreds of independently sourced packages has many separate instances of the GPL, that would begin to eat into SQLITE'S lead. But probably not enough to win. On May 2, 2016 5:42 PM, "Richard Hipp" wrote: > There is a discussio

[sqlite] sqlite3 command line, read-only

2016-04-26 Thread Scott Robison
On Apr 26, 2016 8:16 PM, "Mark Foley" wrote: > > I'm back with more read-only issues. > > Thanks to postings on this list, I've made progress, but still more issues. > > Using the sqlite3 command-line, I'm attempted to open, > read-only, a database located on a Windows 7 workstations, from a Linux

[sqlite] No datasize field - why?

2016-04-25 Thread Scott Robison
le do (one typographical unit), then you have to deal with varying numbers of code points per character, even in a "fixed width" encoding like UTF-32. There is no hard limit on how many combining marks can be appended to a base code point. See http://stackoverflow.com/questions/10414864/whats-up-with-these-unicode-combining-characters-and-how-can-we-filter-them for a stupid / extreme example. -- Scott Robison

[sqlite] No datasize field - why?

2016-04-25 Thread Scott Robison
sometimes used > in-memory, > but efficient processing on some algos, but still. Unicode Codepoints != > Variable Length Encoded sequences. > Even with UTF-32 there is not a correlation between "characters" and "codepoints". One character can in UTF-32 be built from multiple code points. Unicode processing is far more complex, in any UTF, than simple single byte character sets like ASCII. -- Scott Robison

[sqlite] No datasize field - why?

2016-04-24 Thread Scott Robison
On Apr 24, 2016 6:42 PM, "James K. Lowden" wrote: > > On Sat, 23 Apr 2016 19:22:04 -0600 > Scott Robison wrote: > > > So if you could make your table up of integers, floats, and text > > ... > > As I tried to make clear in my reply to Keith, efficiency

[sqlite] No datasize field - why?

2016-04-23 Thread Scott Robison
On Apr 23, 2016 6:21 PM, "Simon Slavin" wrote: > > > On 24 Apr 2016, at 12:58am, Scott Robison wrote: > > > For any SQL datastore, the way the data is stored is completely an > > implementation detail. The SQL engine would be free to serialize all values > &g

[sqlite] No datasize field - why?

2016-04-23 Thread Scott Robison
ze them on the way back. I certainly don't know of any that do that, but the impetus for the creation of VARCHAR fields (I imagine) was specifically to avoid storing padding for data that did not require it. -- Scott Robison

[sqlite] Is it possible that dropping a big table takes very long

2016-04-20 Thread Scott Robison
ocesses, it's not a heavy load. -- Scott Robison

[sqlite] Is it possible that dropping a big table takes very long

2016-04-20 Thread Scott Robison
l version 3.11.0. D:\>\bin\sqlite3.exe checkUUID.sqlite SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> .schema sqlite> It's a big enough file, but there is no schema present. -- Scott Robison

[sqlite] Is it possible that dropping a big table takes very long

2016-04-17 Thread Scott Robison
independent and isolated" process. Whenever I'm trying to measure performance, I close all other applications, maybe disconnect from the network, turn off services. Depending on just how accurate I want to be with the measurement (not all measurements are as important / picky). It'

[sqlite] System.Data.SQLite version 1.0.100.0 released

2016-04-15 Thread Scott Robison
sers mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Why pragma case_sensitive_like do not return theactualsetting ?

2016-04-14 Thread Scott Robison
On Apr 14, 2016 5:46 AM, "Domingo Alvarez Duarte" wrote: > > So there is a way to have a callback that intercept pragmas ? > > Because if we make a piece of derived/composed software that can be used by > third party how to maintain our overloads/overwrites ? Since SQLite swaps like/glob function

[sqlite] Article about pointer abuse in SQLite

2016-03-24 Thread Scott Robison
Forgive top posting, on my phone. But two points. 1. There is a flag if you want zero initialized memory from HeapAlloc. 2. These types of heaps are private to the process and must be created first. The heap creation process reserves virtual address space and allocates memory on demand from a low

[sqlite] Article about pointer abuse in SQLite

2016-03-21 Thread Scott Robison
On Mar 21, 2016 2:48 PM, "Scott Perry" wrote: > > On Mar 21, 2016, at 3:17 AM, Klaas Van B. wrote: > > > >>> On 3/19/16, James K. Lowden wrote: > > > >>> ... If the correctness of the code is > >>> subject to change by the compiler's interpretation of the language, how > >>> is the programmer to

[sqlite] Article about pointer abuse in SQLite

2016-03-19 Thread Scott Robison
On Mar 19, 2016 1:19 PM, "James K. Lowden" wrote: > > On Sat, 19 Mar 2016 02:04:35 -0600 > Scott Robison wrote: > > > As he says, there's not real choice between fast and > > > correct > > > > Except that testing can verify something is co

[sqlite] Article about pointer abuse in SQLite

2016-03-19 Thread Scott Robison
On Mar 18, 2016 11:12 PM, "James K. Lowden" wrote: > > On Fri, 18 Mar 2016 16:33:56 -0600 > Scott Robison wrote: > > > I'd rather have code that might use some "undefined behavior" and > > generates the right answer than code that always conformed

[sqlite] Article about pointer abuse in SQLite

2016-03-18 Thread Scott Robison
d to which they were written, but not to a later standard (such as ANSI C / C89 / C90 vs C99 or C11 or whatever). It's great to conform to both when reasonable, but it may not always be reasonable (as I can't necessarily conceive of every possibility). -- Scott Robison

[sqlite] CAST STRING => INTEGER

2016-03-16 Thread Scott Robison
On Mar 15, 2016 7:33 PM, "Keith Medcalf" wrote: > > > On Tuesday, 15 March, 2016 07:46, James K Lowden wrote > > To my way of thinking, SQLite's handling of giant integers per se > > is an edge case. Because such huge numbers don't normally arise, the > > non-error path (inputs in bounds) almost

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Scott Robison
And here is a copy of my answer posted at stackoverflow (which assumes the context of the question): A see a few problems here. 1. The first SQL statement (CREATE TABLE ...) is malformed due to an extra comma between the last column and the closing parenthesis. 2. The third SQL s

[sqlite] ASK SQLite algoritm to chose Index

2016-02-27 Thread Scott Robison
On Sat, Feb 27, 2016 at 10:49 PM, Simon Slavin wrote: > > On 28 Feb 2016, at 5:47am, Keith Medcalf wrote: > > > I do not see a link ... do you see a link? > > I saw no link. > > The OP may not actually be posting to this mailing list. He may be using > a web interface which does the posting for

[sqlite] Correlated subquery throwing an error

2016-02-16 Thread Scott Robison
On Tue, Feb 16, 2016 at 11:44 AM, James K. Lowden wrote: > On Mon, 15 Feb 2016 14:19:12 -0700 > Scott Robison wrote: > > > Each job will take some amount of time to process. The order doesn't > > matter as long as all jobs are eventually processed and you have a >

[sqlite] Performance comparison between SQLite and SQL Server?

2016-02-15 Thread Scott Robison
On Mon, Feb 15, 2016 at 9:07 PM, Keith Medcalf wrote: > > On the other hand if you drive either on a road with a speed limit of 30 > miles per hour (and go the speed limit), they both go the same distance in > the same time. > > In other words, inquiring "which gets from one side of town to the o

[sqlite] Correlated subquery throwing an error

2016-02-15 Thread Scott Robison
s still a potential use for limit (though maybe there's another way I haven't considered). You have a table representing a job queue. Each job will take some amount of time to process. The order doesn't matter as long as all jobs are eventually processed and you have a single process running the jobs. Limit 1 is a reasonable way to grab a single job. -- Scott Robison

[sqlite] Windows A and W APIs dual support

2016-02-12 Thread Scott Robison
On Fri, Feb 12, 2016 at 8:05 PM, Warren Young wrote: > On Feb 12, 2016, at 4:42 PM, Scott Robison > wrote: > > > > I find it kind of interesting that Microsoft takes a lot > > of (deserved) flack for not adhering to standards, yet UTF-8 came about > > specifical

[sqlite] Windows A and W APIs dual support

2016-02-12 Thread Scott Robison
s instead of UTF-8! Note: I still wish they supported UTF-8 directly from the API. -- Scott Robison

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

2016-02-09 Thread Scott Robison
On Feb 9, 2016 3:16 AM, "Clemens Ladisch" wrote: > > all text values are UTF-8 by default? > > Yes. It would be possible to configure databases to store text values > as UTF-16, but nobody does this, and they would be converted > automatically when using sqlite3_column_text(). Certainly one migh

[sqlite] Bug: Using custom function seems to not work on Universal App Platformv. 3.10.2.0 x86 build only

2016-02-05 Thread Scott Robison
't pick the right one, Bad Things(TM) can happen. From what I read online, 64 bit calling convention in Windows is simple (there is only one) and I would suspect ARM would be a bit more standardized. -- Scott Robison

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-01 Thread Scott Robison
#x27;t that the exact nature of the problem being discussed? Journal is deleted, hard power loss occurs, and journal file still exists when the OS next powers up and looks for the journal file? -- Scott Robison

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-01-31 Thread Scott Robison
here could be a "paranoid" journal mode, where it first zeros out the header ala persist, then truncates the file, then deletes the file. -- Scott Robison

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

2016-01-31 Thread Scott Robison
rite crappy code in any language, and it is possible to write elegant / efficient code in most languages. Often the choice is not the language but rather the algorithms implemented. I would never suggest that everyone must use OO, but to suggest it is worthless or never works seems suspect to me. -- Scott Robison

[sqlite] SQLite crashing

2016-01-26 Thread Scott Robison
gine the difference being measurable in most cases and I prefer cleaning up explicitly most of time). That being said, delete also invokes destructors which can do far more than just return memory to the C++ free-store. It's not necessarily related to this precise problem, obviously, just a warning flag that popped up in my reading. -- Scott Robison

[sqlite] sqldiff.c : 2 benign warnings in 64 bits builds

2016-01-26 Thread Scott Robison
meric_cast. It inlines to a normal cast in cases where there is no danger (non-truncating conversions) and can throw an exception in the case of a truncating or signed conversion that is out of range. Sadly, something like that isn't possible in pure C89. -- Scott Robison

[sqlite] Slight problem with sqlite3_compileoption_get

2016-01-23 Thread Scott Robison
alling convention issue. The @4 suffix on the function name usually means that the function is STDCALL and that the callee will clean up the stack. If for some reason both the caller and callee cleaned up the stack for this function, that would definitely be a problem. -- Scott Robison

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

2016-01-17 Thread Scott Robison
On Sun, Jan 17, 2016 at 1:33 PM, Howard Chu wrote: > Scott Robison wrote: > >> Sorry for the OT diversion, but I'm just curious as I don't have >> historical >> POSIX standards for reference. Does POSIX really *require* an MMU? >> Certainly Unix like syste

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

2016-01-17 Thread Scott Robison
On Sun, Jan 17, 2016 at 10:09 AM, James K. Lowden wrote: > On Sat, 16 Jan 2016 14:21:26 -0700 > Scott Robison wrote: > > > > Huh. An example of which is the "medium model" of the Intel 8086: > > > 20-bit code pointers and 16-bit data pointers. A machin

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

2016-01-16 Thread Scott Robison
I don't have historical POSIX standards for reference. Does POSIX really *require* an MMU? Certainly Unix like systems were written for 8086 class computers, but given that POSIX was first standardized in 1988 I'm just curious as to whether or not an MMU is a requirement or just really nice to have. -- Scott Robison

[sqlite] batch or one by one?

2015-12-16 Thread Scott Robison
, your hardware, your operating system ... who knows what. -- Scott Robison

[sqlite] about attach database

2015-12-16 Thread Scott Robison
On Wed, Dec 16, 2015 at 1:37 AM, Dominique Pell? wrote: > Scott Robison wrote: > > > Why would that be of benefit to you? Are you intending to attach a > database > > and never use it? It seems to me the same amount of time will be taken > > either way. > &g

[sqlite] about attach database

2015-12-16 Thread Scott Robison
ase. I say no advantage ... maybe I just can't think of one. Why do you think there would be an advantage to deferring the open & schema processing of an attached database? -- Scott Robison

[sqlite] Bug with DATETIME('localtime')

2015-12-13 Thread Scott Robison
r be 100% accurate (or rather to get everyone to agree on what 100% accurate really means). We need a metric calendar. I propose redefining the second so that a day is 100,000 seconds long... ;) -- Scott Robison

[sqlite] Bug with DATETIME('localtime')

2015-12-13 Thread Scott Robison
add TZ functionality. That functionality would almost certainly only be required for hosted implementations. Freestanding implementations have a much smaller set of requirements (they don't even require the *current* time functions!), and are the types of implementations used in targeting all these embedded devices that make SQLite (likely) the most deployed software in the world. -- Scott Robison

[sqlite] Problem with accumulating decimal values

2015-12-11 Thread Scott Robison
e.com/sqlite-users at > mailinglists.sqlite.org/msg04587.html > (web search sqlite "simple math question") > > It has background, theory, and they show how the conversions of > decimals to floating point and how they add works, using several > examples. > +1 -- Scott Robison

[sqlite] sqlite3_errmsg and wide char

2015-12-07 Thread Scott Robison
ue of Mac all through history. They might not have been called "code pages" but Mac most definitely had different character sets to support different markets. -- Scott Robison

[sqlite] website documentation wording

2015-12-04 Thread Scott Robison
list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] sqlite3_errmsg and wide char

2015-11-27 Thread Scott Robison
ing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] sqlite3_errmsg and wide char

2015-11-27 Thread Scott Robison
On Fri, Nov 27, 2015 at 1:19 AM, J Decker wrote: > On Fri, Nov 27, 2015 at 12:17 AM, Scott Robison > wrote: > > On Thu, Nov 26, 2015 at 11:42 PM, Igor Korot wrote: > > > >> Hi, Scott, > >> > >> On Fri, Nov 27, 2015 at 1:01 AM, Scott Robison >

[sqlite] sqlite3_errmsg and wide char

2015-11-27 Thread Scott Robison
On Thu, Nov 26, 2015 at 11:42 PM, Igor Korot wrote: > Hi, Scott, > > On Fri, Nov 27, 2015 at 1:01 AM, Scott Robison > wrote: > > On Thu, Nov 26, 2015 at 10:13 PM, Igor Korot wrote: > >> > >> Hi, > >> Is there any way to have "sqlite3_errmsg&quo

[sqlite] sqlite3_errmsg and wide char

2015-11-26 Thread Scott Robison
to treat all char objects as ASCII or Latin-1, then you can convert char strings to wchar_t strings by simply zero extending each character while copying it. Something like this (without any error checking): void copy_narrow_to_wide(wchar_t* dst, const char* src) { while (*src) *(dst++) = (unsigned char)(*(src++)); *dst = 0; } -- Scott Robison

[sqlite] attempt at output with thousands separator via extension

2015-11-22 Thread Scott Robison
arator format is standard, as it is not). But the OP wants to be able to do formatting from within SQL as he is using the SQLite shell, thus there is no programming language at his disposal in this use case. An understandable wishlist item, even if it isn't likely to happen for equally understandable reasons. -- Scott Robison

[sqlite] attempt at output with thousands separator via extension

2015-11-21 Thread Scott Robison
s that it is using printf, which displays the actual characters of the floating point value directly to stdout, completely bypassing SQLite. Then the return value of printf (the number of characters printed) is used as the value of sqlite3_result_double. Obviously the ' extension isn't being honored here either, maybe because the "C" locale is in use. Either way, it isn't doing what you expect. One way to go would be to extend the format capabilities of the SQLite version of the printf function (which has nothing in common with the standard C library printf function) to honor a thousands separator. I don't know if there would be any interest on the part of the SQLite team to implement something like that. -- Scott Robison

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Scott Robison
error). Where the error is should be obvious since it was the analysis > stage which led to the constraints being deferred in the first place. > > The ultimate "lite" system, in my opinion, was the ancient TRS-80 BASIC. > It had only three error messages from which you ought to be able to > determine types of errors they represent: > Altair 8800 was much lighter than TRS-80 BASIC. At least the "basic" machine (not to be confused with BASIC). Lights on a panel! -- Scott Robison

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-14 Thread Scott Robison
rovide a lot of the benefits outlined above. Still no SQL interface. Hmmm, maybe a VFS or virtual table for SQLite... -- Scott Robison

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Scott Robison
source of problems. Many people use them successfully, but when they break, they break hard. Asking "which network file system is best for my data integrity" might be likened to asking "which brand of cigarettes are best for my health". You can probably answer them in some way, but the real answer is "none" in both cases. -- Scott Robison

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread Scott Robison
On Nov 12, 2015 7:44 AM, "James K. Lowden" wrote: > > On Tue, 10 Nov 2015 13:45:52 -0700 > Warren Young wrote: > > > This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, > > DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, > > Access, SQL Server Express? > > The

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Scott Robison
On Nov 10, 2015 2:19 PM, "John McKown" wrote: > > On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian < keith1christian at gmail.com> > wrote: > > > A great thing for Windows users. > > > > My only caveat is: Beware corporate pressure. Stay Free. > > > > > ?I agree. I'm not any kind of MS fan. I sim

[sqlite] Why SQLite take lower performanceinmulti-threadSELECTing?

2015-11-02 Thread Scott Robison
erations, or if the > library you're using has threaded capabilities. > iOS is BSD based, not linux based. Not that they're hugely incompatible, but ... just FYI. -- Scott Robison

[sqlite] Simple Math Question

2015-10-23 Thread Scott Robison
arithmetic performed will potentially involve rounding of some form, and the final conversion back from binary floating point to decimal representation for humans can only work with what is left over after those previous potential approximations. > Il 23/ott/2015 18:31, "Scott Ro

[sqlite] Simple Math Question

2015-10-23 Thread Scott Robison
ers at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > This email and any attachments are only for use by the intended > recipient(s) and may contain legally privileged, confidential, proprietary > or otherwise private information. Any unauthorized use, reproduction, > dissemination, distribution or other disclosure of the contents of this > e-mail or its attachments is strictly prohibited. If you have received this > email in error, please notify the sender immediately and delete the > original. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Simple Math Question

2015-10-23 Thread Scott Robison
g/cgi-bin/mailman/listinfo/sqlite-users > This communication is the property of CenturyLink and may contain > confidential or privileged information. Unauthorized use of this > communication is strictly prohibited and may be unlawful. If you have > received this communication in error, please immediately notify the sender > by reply e-mail and destroy all copies of the communication and any > attachments. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Simple Math Question

2015-10-23 Thread Scott Robison
___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] [sqlite-dev] Proposed new version numbering scheme for SQLite - Feedback requested

2015-10-08 Thread Scott Robison
On Thu, Oct 8, 2015 at 10:53 AM, Richard Hipp wrote: > On 10/8/15, Scott Robison wrote: > > > > 3.1.0 is released > > 3.1.1 fixes a bug in 3.1 > > 3.2.0 is released with new features. > > 3.2.1 fixes a bug originally introduced in 3.1.0 > > > > Some

[sqlite] [sqlite-dev] Proposed new version numbering scheme for SQLite - Feedback requested

2015-10-08 Thread Scott Robison
ntained with bug fixes / z level patches. For example: 3.1.0 is released 3.1.1 fixes a bug in 3.1 3.2.0 is released with new features. 3.2.1 fixes a bug originally introduced in 3.1.0 Some people are going to expect that bug fix to be back ported into the 3.1 branch and have a 3.1.2 release cut from it. -- Scott Robison

<    1   2   3   4   >