trings, often intentionally obfuscated
(MSIE does this now, we recently discovered, presumably to try to keep
people from implementing IE-specific workarounds).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduc
g they do.
It's likely that assumption about my preferences/limits which annoys me
more than the limitation itself does.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect worl
text stretch to the whole browser width, which is not very readable.
>
A counter-opinion, though apparently in the small minority: i _absolutely
despise_ fixed-width web site layouts.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny
r such platforms, be irrelevant. i _suspect_ that you are overestimating
the impact of your perceived performance problem on the end users.
But that's all just my opinion based on experience - i have no facts or
statistics to back it up. Maybe it will work well for you.
--
- stephan beal
gger problems
than the perceived performance problems you have right now. The chances
that something breaks with that approach is, i suspect, very high. You will
eventually corrupt a database and then write back to the list to ask why
that approach corrupted it.
--
- stephan beal
http://wanderinghor
On Wed, Aug 31, 2016 at 10:43 AM, Stephan Beal
wrote:
> On Wed, Aug 31, 2016 at 10:39 AM, sanhua.zh wrote:
>
>> In my testcase, I can only [mmap] a db file at most 1.4GB size. But in
>> this new way, I can map a file at most 3.2GB. The test device is iPhone 6S.
>>
>
p
3.2G. In any case, as Simone said, _other apps_ require memory of their own
as well. Your app does not have that whole 2G to itself.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on
ude a schema design tool). Server Explorer is
a 3rd-party product.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
__
rs etc is very much preferred in most cases, but
> wondered if those cases where SQL is application provided were an
> exception. I'm leaning towards a no on that now. Thanks for your input and
> in advance or any additional insight.
>
FWIW, internally, exec() is just a proxy for prepar
nges the result, so it is not the
> case, that SQLite does not process the scope operation via the
> Python-SQLite interface.
>
> Any idea?
>
It sounds to me like your python and local sqlite shell are using different
sqlite versions.
--
- stephan beal
http://wanderinghorse
ot be reproduced in the
cli client then the wrapper is the most likely culprit.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -
ough this argument? Compound statements,
> transactions? What syntax?
>
The first _SQL statement_ is processed. Anything after that is ignored. e.g.
select 1 from foo; -- first statement ends here
select 2 from foo; -- this is ignored.
--
- stephan beal
http://wanderinghorse.net/home/stepha
On Sun, May 15, 2016 at 2:29 PM, 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.
>
it does, actually, because PD is not recognized in all jurisdictions.
--
size of the target database
> should be kept consistent with the source database. Otherwise, quite lots
> of disk space will be wasted in case source database shrinks
Not a bug: sqlite saves removed "pages" for later use. Use the VACUUM
command to tell it to get rid of them and shrink y
On Mon, May 9, 2016 at 7:00 PM, jungle Boogie
wrote:
> On 8 May 2016 at 23:13, Stephan Beal wrote:
> > On Mon, May 9, 2016 at 5:40 AM, Stephan Beal
> wrote:
> >
> >> That suggests that the script is not consistently telling sqlite which
> TZ
> >> to use
d in sqlite by default.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
On Mon, May 9, 2016 at 5:40 AM, Stephan Beal wrote:
> That suggests that the script is not consistently telling sqlite which TZ
> to use in all calculations. i will take a look at it as time
>
just fyi: i can now reproduce the problem on my x64, where my days are
shifted 1 to the left.
That suggests that the script is not consistently telling sqlite which TZ
to use in all calculations. i will take a look at it as time allows.
Probably just need to be sure to consistently pass the final argument to
strftime().
- stephan
(Sent from a mobile device, possibly from bed. Please ex
On Sun, May 8, 2016 at 10:53 AM, Stephan Beal wrote:
> The system clock is correct on your x64 machine, i assume? (Even if it's
> wrong, that doesn't explain the days being shifted left by 1.)
>
One idea comes to mind: perhaps it doesn't consistently deal with timezone
eloped on).
The system clock is correct on your x64 machine, i assume? (Even if it's
wrong, that doesn't explain the days being shifted left by 1.)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the o
t again, etc
i think this is easier: check if the year as 365 or 366 days:
sqlite> select strftime('%j', '2016-12-31');
366
sqlite> select strftime('%j', '2015-12-31');
365
with the usual caveats for dates in the far past.
--
- stephan beal
http
On Fri, Apr 22, 2016 at 9:18 AM, Rowan Worth wrote:
> On 22 April 2016 at 14:54, Stephan Beal wrote:
> > but i beg to differ that that works in 100% of cases.
> >
>
> Lets see, for a 64-bit float we have 53 bits of significand. The number
> ...of ambiguity. Pretty sur
On Fri, Apr 22, 2016 at 8:43 AM, Clemens Ladisch wrote:
> Stephan Beal wrote:
> > On Thu, Apr 21, 2016 at 4:12 PM, jrhgame wrote:
> >> SELECT julianday('2016-04-15 12:10:10') ==>2457494.00706
> >> SELECT datetime(2457494.00706) ==>2016-04-1
r on ARM platforms, compared to i64.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
n (a in ('abc','def'))";
> $stat = $p->exec($sql);
>
('abc' & 'def') does not produce a syntax error:
sqlite> select 'abc' & 'def';
0
so your SQL was well-formed, just not what you wanted. Your IN(...)
effe
Does anyone have a good reason why SHA1 is still
> needed ?
>
FWIW:
https://en.wikipedia.org/wiki/SHA-2
"Although (as of 2015) no example of a SHA-1 collision has been published
yet..."
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Fr
de there. If you'll check those
codes, you may be able to find out immediately what the problem is.
A Golden Rule of C APIs is: if you ignore the result codes, the API may
ignore you.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is slopp
the original table
create table original_table (...); -- w/ new schema
insert into original_table (a,b,c) select a,b,c from foo; -- assuming no
transformation needs to take place
drop table foo; -- though you'll probably want to keep the old copy "just
in case"
--
- stephan be
to use integers above 9223372036854775807 is something that is better
> not to be done.
>
Also beware that some scripting languages only support 48 bits of integer
precision, so 64 bits may or may not be usable in any given scripting
language environment.
--
- stephan beal
http://wanderingh
r to take advantage
of SQLITE_OMIT_* options.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
On Sat, Mar 5, 2016 at 9:22 PM, Stephan Beal wrote:
> Aggregates are _currently_ modeled as a single function which gets called
> just like normal function, but in the aggregate's "final" call the engine
> calls the aggregate function with no arguments (this is how t
On Sat, Mar 5, 2016 at 11:58 PM, Richard Hipp wrote:
> On 3/5/16, Stephan Beal wrote:
> > On Sat, Mar 5, 2016 at 10:43 PM, Domingo Alvarez Duarte <
> >
> > The scenario i'm concerned about is that sqlite calls my aggregate N
> times,
> > then an error is
On Sat, Mar 5, 2016 at 11:21 PM, Stephan Beal wrote:
> On Sat, Mar 5, 2016 at 10:43 PM, Domingo Alvarez Duarte <
> sqlite-mail at dev.dadbiz.es> wrote:
>
>> Hello !
>>
>> There is an user pointer that you pass and you can get it back using
>> http
is triggered elsewhere which keeps sqlite from making the
final() aggregate call. Currently i reset my accumulation state in the
final() bits, but if final() is never called, then the _next_ time someone
calls the aggregate, it will still have accumulated state from the previous
attempt which failed
aggregate before the _next_
round of calls.
How are script bindings handling such situations? Where are they
initializing and resetting any "accumulator data" in their aggregates?
Any insights and suggestions would be appreciated.
--
- stephan beal
http://wanderinghorse.net/home/s
616
or about 1.8e+19). This limit is unreachable since the maximum database
size of 140 terabytes will be reached first. A 140 terabytes database can
hold no more than approximately 1e+13 rows, and then only if there are no
indices and if each row contains very little data.
--
- stephan beal
htt
, strftime() uses them and the Fossil SCM (which hosts sqlite) uses
them:
https://www.sqlite.org/lang_datefunc.html
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those wh
[SQLITE_DETERMINISTIC] flag is recommended where possible.
Note that it says within a single statement, not a transaction.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
thos
27
> 28 29
>
LOL! i needed about 6 hours (and 6 times the code) to do that!
Extremely impressive!
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist
On Fri, Feb 19, 2016 at 1:53 AM, Stephan Beal wrote:
> It can now optionally mark the current date (but this feature slowed it
> down from 'instant' to 'just under a second or so', possibly due to SQL
> inefficiencies on my part).
>
Trimming the list of years
On Fri, Feb 19, 2016 at 12:36 AM, k wrote:
> On 18/02/2016 21:55, Stephan Beal wrote:
>
>>
>>> http://fossil.wanderinghorse.net/download/cal.sql
>>>
>>>
>> Excellent CTE query, thanks, but one question: the query uses
> group_concat() and the d
On Thu, Feb 18, 2016 at 10:42 PM, Stephan Beal
wrote:
> Here we go:
>
> http://fossil.wanderinghorse.net/download/cal.sql
>
sorry, one more: it was just updated with minor doc improvements and better
syntax conformance (i had used a lot of double-quotes simply out of recent
scr
On Thu, Feb 18, 2016 at 10:22 PM, Stephan Beal
wrote:
> On Thu, Feb 18, 2016 at 10:19 PM, Richard Hipp wrote:
>
>> On 2/18/16, Stephan Beal wrote:
>> >
>> > Thanks again to all for the feedback and suggestions!
>> >
>>
>> After your talk,
On Thu, Feb 18, 2016 at 10:19 PM, Richard Hipp wrote:
> On 2/18/16, Stephan Beal wrote:
> >
> > Thanks again to all for the feedback and suggestions!
> >
>
> After your talk, can we publish your calendar CTE as another example
> in the SQLite documentation?
>
On Thu, Feb 18, 2016 at 9:52 PM, Stephan Beal wrote:
> --
>> Feb 2016
>> 1 2 3 4 5 6 7
>> 8 9 10 11 12 13 14
>> 15 16 17 18 19 20 21
>> 22 23 24 25 26 27 28
>>
>> Thank you!!!
>>
>> Not half bad, if
On Thu, Feb 18, 2016 at 9:50 PM, Stephan Beal wrote:
> i could do with the \r, but CHAR(10) does indeed do the trick:
>
withOUT the \r...
>
> --
> Feb 2016
> 1 2 3 4 5 6 7
> 8 9 10 11 12 13 14
> 15 16 17 18 19 20 21
> 22 23 2
26 27 28
Thank you!!!
Not half bad, if i may say so :).
i will post the complete solution (for a given definition of "solution")
once i've cleaned it up notably... and figure out how the last part of it
actually works. :/ Look for it over the weekend.
Thanks again!
--
On Thu, Feb 18, 2016 at 9:16 PM, Stephan Beal wrote:
> Okay, i've hit a small stump and i'm looking for a hint without giving it
> away:
>
> January and February 2016:
>
> [stephan at host:~/tmp]$ sqlite3 < cal.sql
> 1 2 3
> 4 5 6 7 8
indentation wasn't half as problematic as i expected.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
4 25
26 27 28 29 30 31
Next to figure out indentation/line breaks based on the dayOfWeek (which i
have but isn't shown above).
> The first CTE sets up some parameters in the first 3 fields used to draw
> the graph - play with those parameters for fun.
>
i wouldn't even know wha
3|2
Feb|2|24|3
Feb|2|25|4
Feb|2|26|5
Feb|2|27|6
Feb|2|28|7
Feb|2|29|1
(Note that i adjust day-of-week to Sunday=7 (instead of 0) because that's
just how we roll in Germany.)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
o!
>
> Look at the year 1752 -- you may notice something odd happened that
> September. :-)
>
Yeah, i should have mentioned that i'm simplifying to the range of dates
"sometime within my lifetime." Anything else is irrelevant for my
presentation ;).
--
- stephan bea
r my calendar CTE outputs:
[stephan at host:~/tmp]$ sqlite3 < cal.sql
2016|1|31
2016|2|29
2016|3|31
2016|4|30
2016|5|31
2016|6|30
2016|7|31
2016|8|31
2016|9|30
2016|10|31
2016|11|30
2016|12|31
Obviously still lots to do here. (Again, _please_ don't post spoilers for
calendar CTE solution
x27;ve stored the data as a
BLOB, not TEXT. You need to confirm that you haven't stored the field as a
blob.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on
but someone on this list does and will likely answer very soon. (Yes,
i'm looking at you, Simon!)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
not normally contain NUL characters, the length(X) function will
usually return the total number of characters in the string X. For a blob
value X, length(X) returns the number of bytes in the blob.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Free
utf8.c
It also takes care of some weird Appleness cases.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
point when that was the newest.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
On Tue, Feb 9, 2016 at 5:38 PM, Stephan Beal wrote:
> fossil pull --verily
>
> in the past that's helped people reporting problems about a repo silently
> failing to pull past a certain version.
>
OTOH, if that tag is checked out, which your output indicates is the case
e:
fossil pull --verily
in the past that's helped people reporting problems about a repo silently
failing to pull past a certain version.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only gua
;
>
> right?
>
That's what Unix would do. So... on Windows, probably not ;).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
a US layout.)
- Google for "utf8 character tables" and copy/paste them.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
ckoverflow.com/questions/30585552/how-to-represent-an-array-with-empty-elements-in-json
tl;dr: "jsonlint" also says empty array elements aren't allowed.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's
--
From: Douglas Crockford
To: Stephan Beal
Subject: Re: Is escaping of forward slashes required?
It is allowed, not required. It is allowed so that JSON can be
safely
embedded in HTML, which can freak out when seeing strings containing
On Tue, Jan 26, 2016 at 6:40 PM, Scott Robison
wrote:
> On Tue, Jan 26, 2016 at 8:21 AM, Stephan Beal
> wrote:
> > fwiw, in case this matters: size_t has an unspecified size and it's not
> in
> > C89. It's defined by C99 in stddef.h
> >
>
> size_t (and
yway.
>
fwiw, in case this matters: size_t has an unspecified size and it's not in
C89. It's defined by C99 in stddef.h
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduc
ppears. The bookmark database is still completely intact - it
> just went backwards in time a little.
>
Or, alternately, it _never went forward_ in time.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's th
On Fri, Jan 22, 2016 at 12:22 PM, Stephan Beal
wrote:
>
>
> On Fri, Jan 22, 2016 at 12:11 PM, Bart Smissaert > wrote:
>
>> Say I want 1 random numbers between 100 and 1000 how can I do that
>> without
>> selecting from a table?
>> I know I can do:
>
619|3
380|4
412|5
263|6
563|7
877|8
573|9
468|10
just swap out the 'conf' part with 1000.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
The problem is that you are using unusual quotes. Use only standard
double-quotes for identifiers and single-quotes for strings. Your example
uses "fancy" quotes commonly seen in word processors.
- stephan
Sent from a mobile device, possibly from bed. Please excuse brevity, typos,
and top-post
On Thu, Jan 14, 2016 at 2:09 PM, Stephan Beal wrote:
> FULL means the drive is full. Most apps can't do much about that. It
> generally needs to be resolved by user action - freeing up space.
>
Alternately, FULL can mean that the current VFS cannot allocate space, even
though i
work with it - there is no generic recovery
strategy aside from throwing the DB away and building it anew.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
different error codes (all of them
serious). That misuse is what corrupted it.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
On Mon, Jan 11, 2016 at 7:57 PM, Stephan Beal wrote:
> On Mon, Jan 11, 2016 at 7:55 PM, Warren Young wrote:
>
>> On POSIX systems, you can securely create a temp file that only your user
>> can see via the mkstemp(3) C library call. SQLite will happily open the
>&g
:)
>
sqlite exposes the functionality of fetching a temp file name using its
mechanism, but i don't recall at the moment how it's done. A quick google
isn't revealing it but i recall using it but finding out that it doesn't
work with the :memory: VFS.
--
- stephan beal
http://w
I need to know before stepping, but it can do that.
>
> For a SELECT which returns no rows I presume it returns the number of
> columns asked for.
It does. i use this in a db abstraction layer to fetch column names without
needing to fetch data.
--
- stephan beal
http://wanderi
acy interface that is preserved for backwards compatibility.
Use of this interface is not recommended.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perf
On Mon, Dec 14, 2015 at 11:47 AM, Stephan Beal
wrote:
> On Mon, Dec 14, 2015 at 11:21 AM, ??? <2004wqg2008 at 163.com> wrote:
>
>> hi, every one.
>> Here is a very strange and interesting problem.
>> I used the following SQL to create the table teache
x27;m guessing that you are using an abstraction layer which is changing
the returned name of your rowid.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
ror.
>
It's a hypothetical problem. It doesn't happen with correct usage, and
sqlite cannot protect users from all possible misuse.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guarant
rrors when you open the db. It
would have to read the whole db to figure that out, slowing sqlite to a
crawl. Since most dbs are not corrupt, it would be slowest for the average
case and faster for the error case (since it must stop reading on the first
error).
--
- stephan beal
http://wand
> If I figure out some clever I will share for the benefit of other shell
> junkies that like neat easily readable numeric output - all 6 of us :)
>
i think you mean all 6,0 of you ;).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom i
On Mon, Nov 16, 2015 at 6:42 PM, Stephan Beal wrote:
> On Mon, Nov 16, 2015 at 6:11 PM, Igor Korot wrote:
>
>> The variables referenced are defined as "std::string" and the code is in
>> C++.
>>
>
> the std::string(char const *) constructor does not, la
ng::_S_construct null not valid
Aborted
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
on it and completely
bypass the file-sharing problems and corruption which _will_ happen if you
try to use sqlite3 on a shared network filesystem.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed
t; join option4_name on
> option4_map.name_id=option4_name.name_id \
>
...
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
that someone wasn't paying attention in the
design and/or implementation.
That poor guy.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
ot entered by end
users): UDFs are variadic, so you could pass an optional 2nd parameter with
any information as a string to the final parameter, e.g.:
select quarter(t.a, 't.a'), quarter(4,'four') from t;
--
- stephan beal
http://wanderinghorse.net/home/stephan/
They
only get passed the values resolved by the surrounding evaluation engine.
By the same token (no pun intended), in JavaScript:
var x = 3;
quarter(x);
gets only the number 3, not any information about where that 3 comes from
or how it was derived.
--
- stephan beal
http://wanderinghor
n, it would sometimes be helpful to
> have the associated field (if any) that the value is associated with.
>
> Is there any way to retrieve that?
>
UDFs receive expanded/evaluated values, not fields:
select quarter(t1.a+t2.a+t3.a+3.0) from t1, t2, t3...;
what field would you expect t
on than you could possible
want on the reason:
http://www.mail-archive.com/sqlite-users at
mailinglists.sqlite.org/msg04466.html
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
results at a specific precision.
See: http://floating-point-gui.de/
the first example of which demonstrates the problem you are seeing.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
> We carefully monitor the size of the compiled SQLite binary. A graph
> of that size is shown at
>
> https://www.sqlite.org/binary-size.jpg
>
> The 627.4KB for 3.8.11 is within reason, depending on what compiler
> you are using. But SQLite has *never* been as small as 44.8 KB. Is
> that a
On Sun, Oct 18, 2015 at 12:30 PM, Richard Hipp wrote:
> On 10/18/15, Stephan Beal wrote:
> > It didn't appear to come directly from the list - i suspect someone is
> > scraping the ML archives.
> >
>
> Are the messages you are receiving passing through the
spect someone is
scraping the ML archives.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
very very slow on Windows Seven", a
> post I replied to today.
>
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
r hypotheses: if you are on the same hardware which was running XP,
the hardware might simply be too old to perform well (for anything) on Win7.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guarant
] --sqltrace
that option works with any fossil CLI commands.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
e
multiple connections to a single :memory: db.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
sed.
> but if I looked in the db I still see the row/entry for 'loki'
>
Nope - you have only run the BEGIN part of the transaction. prepare()
prepares only one single statement, not multiples (you have 4 statements in
your SQL). Thus when you try to run another transaction, that BEGIN i
1 - 100 of 626 matches
Mail list logo