sqlite> insert or replace into main.dest ( name, value ) values
('allow',(select value from aux.source where name = 'allow'));
Error: database is locked
now without the db names:
sqlite> insert or replace into dest ( name, value ) values ('allow',(select
value from source where name = 'a
"main" to the well-known name we have specified
for that db instance. It worked like a charm until Dave discovered this
weird locking behaviour.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaran
On Mon, Oct 27, 2014 at 9:58 AM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 27 Oct 2014, at 8:43am, Stephan Beal <sgb...@googlemail.com> wrote:
>
> > - a couple months back Simon suggested ATTACHing the db to itself so that
> > we can effectively alias &quo
e mean time, i think the
workaround is to simply leave off the db names (since we know we don't have
table name collisions).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those w
On Mon, Oct 27, 2014 at 11:08 AM, Stephan Beal <sgb...@googlemail.com>
wrote:
> - TEMP tables get created in the MAIN db (assuming my memory of the docs
> is correct), which means we can (though accidental misuse or carelessness)
> end up filling up RAM with temporary table
als my ignorance on the topic ;). IIRC we aren't using a specific
temp store - we're using whatever's compiled in by default.
So... maybe paying for a :memory: handle we "don't really use" won't be as
painful as i first thought. Just add a pragma call to ensure that we're
using disk inste
On Mon, Oct 27, 2014 at 11:59 AM, Stephan Beal <sgb...@googlemail.com>
wrote:
> On Mon, Oct 27, 2014 at 11:53 AM, Hick Gunter <h...@scigames.at> wrote:
>
>> TEMP tables get created in database temp; which is located in "a file" or
>> "in memory&quo
ismatches in the "more transient" of the DBs) and would be
recoverable by a routine scan which client apps do anyway, so it's unlikely
that a user would ever even see it.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sl
E INDEX db.index_name ON [=>db.]table_name ...
>
> CREATE TABLE db.table_name (...) FOREIGN KEY (...) REFERENCES
> [=>db.]referenced_table
>
> CREATE TRIGGER db.trigger_name ... ON [=>db.]table_name ...
>
> CREATE VIEW db.view_name AS SELECT ... FROM [=>db.]table_name
attached under a
> different name.
>
> A TEMPORARY VIEW can reference tables in any attached file, and the use of
> qualified names is allowed and encouraged (at least by me).
>
That info will most certainly save me some future head-scratching. Thanks!
--
- stephan beal
, but generally by
> negligible amounts.
>
To add to that: the doubling of the size of a (void*) in 64-bit costs many
types of applications/libraries notably more memory, up to twice as much
for pointer-only structures.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gpl
The RIDs cannot be used to figure it out, and neither can
mtime. The only 100% reliable way i know of traversing the history is to
read each manifest, as the P-cards give us that piece of context we need to
know the ordering.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus
ngly, that test uses rid comparison for determining whether to say
"begat" or "derives from" (not seen above), but i've learned in the mean
time the rid comparison isn't strictly reliable because it's legal for
artifacts to get blobified (getting a blob.rid value) in an ar
ttings dir, i.e. no versioned settings, so
no, they're not synced with clones.
--
----- 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 t
On Thu, Nov 6, 2014 at 4:12 AM, nicolas riesch <nicolas.rie...@gmail.com>
wrote:
> http://www.sqlite.org/cvstrac/wiki?p=MultiThreading
Be aware that the cvstrac pages are all historical, possibly outdated, and
no longer maintained.
--
- stephan beal
http://wanderinghorse
e top of this page demonstrates what it is:
http://www.sqlite.org/lang_with.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 who insist on a perfect world, freedom will hav
e in formula outputs are quite large numbers
> and
> > > > clients do not want to round off.
>
The first answer to this thread might be helpful (but also probably not
what you want to hear):
http://sqlite.1065341.n5.nabble.com/How-point-numbers-are-they-stored-in-sqlite-td35739.html
On Fri, Nov 14, 2014 at 4:31 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> I understand the desire to avoid storing data on the web server, but it
> would
>
It doesn't - you can load local files.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/
at refers to a cte?
>
http://www.sqlite.org/lang_with.html
You can combine several CTEs into one big SELECT, which seems to be what
you're asking?
Search that page for "mandelbrot" for an extreme example.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbea
ql);
>
here. Because...
> throw new RuntimeException("unexpected argument type);
>
if that happens then you're not closing it.
> try {
> return statement.executeUpdateDelete();
> } finally {
> statement.clos
ivate mail (not the list, as SourceForge can't keep the spammers out of
it)).
Alternately, a lighter-weight, JSON-only solution:
http://fossil.wanderinghorse.net/repos/nosjob/
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since
[-Werror,-Wlong-long]
typedef unsigned long long int sqlite_uint64;
which can be squelched with:
gcc|clang -c -pedantic -std=c89 -Wall -Werror -Wno-long-long sqlite3.c
(clang now reports an unused var, but that's something else.)
--
- stephan beal
http://wanderinghorse.net/home/ste
table.html
https://www.sqlite.org/limits.html
might have what you're looking for.
--
- 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 hav
gt; the table name"("" "");
>
To whichl add: sqlite allows it. Your fellow colleagues, on the other hand,
will hopefully not let such things through code review ;).
(Empty strings? Really?)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus
ter ease of use and readability! ;)
--
----- 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 t
You need to change the outer quotes (around the whole select)
to single quotes, then use double quotes around "(asd*)" (as you've done).
Alternately, i believe '[' and ']' can be used instead of quotes around
table/field names.
--
- stephan beal
http://wanderinghorse.net/home/steph
hich is warning with an @ sign:
if( @someFuncWhichWarns() ) { ... }
--
----- 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 t
On Tue, Jan 6, 2015 at 10:45 AM, Stephan Beal <sgb...@googlemail.com> wrote:
> PHP's general-purpose mechanism for warning squelching is to prepend the
> command which is warning with an @ sign:
>
>
> if( @someFuncWhichWarns() ) { ... }
>
To be clear: the @ do
avoid them if
100% round-trip fidelity is required. In my experiments, i see round-trip
conversion errors of +/-1ms in somewhere between 0.25% (64-bit systems) to
2% (32-bit systems) of all timestamp converted round-trip between Julian
and ISO8601.
--
- stephan beal
http://wanderinghorse.ne
48573647856354765 +04:00');
> 2015-02-14 09:46:15.394
>
i should have been careful to note that i was using custom conversions
(based on Wikipedia and its outbound links), as opposed to sqlite's
methods, and using ms precision for the ISO strings.
--
- stephan beal
http://wanderi
-MM-DD HH:ii:ss...).
--
----- 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 doing?
>
How about continue to use it? Why do you feel that something is broken just
because it's big?
--
- 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 w
ion. What could be the possible
> reasons?
>
FWIW, fsync/fdatasync() are _system_ calls, so the OS or one of its drivers
(not sqlite) is taking "too much time" to return. See also:
https://www.sqlite.org/c3ref/c_sync_dataonly.html
https://www.sqlite.org/pragma.html#pragma_synchrono
y the file
descriptor fd to the disk device (or other permanent storage device)
...
i.e. if you have no disk (you are using an in-memory VFS), then you have no
file descriptor, so fsync/datasync _cannot_ be (legally) called.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
xed just last week:
http://sqlite.org/src/info/80541e8b94b713e8f9e588ae047ffc5ae804ef1c
Or maybe this is a related problem, not quite the same.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed
ve. The
> database was not really corrupt. The error was in the corruption
> detection mechanism. That error has long since been fixed.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy
does-float-have-a-negative-zero-0f
"the standard" (it's not clear if they mean C89 or C99) _requires_
"positive and negative zero to test as equal," an implication of which is
that it would be impossible to tell them apart in SQL implementations based
on that.
--
- stephan
s a big assumption. Network filesystems are historically _notorious_
for locking-related problems (the root of many corruption problems).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byprod
ic APIs (which, to the best of my (fallible) knowledge, it does
not do).
--
- 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, f
ocale-specific collations (a topic i'm not qualified to
comment on), with "ICU extension" being a common part of any answers.
Google says:
http://www.sqlite.org/src/info/d9fbbad0c2f647c3fdf715fc9fd64af53aedfc43
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http:/
book/dp/B008IGK5QM/
resp.
http://shop.oreilly.com/product/9780596521196.do
covers VFS creation in detail with a step-by-step example.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byprod
On Tue, Feb 10, 2015 at 5:58 PM, Jay Kreibich <j...@kreibi.ch> wrote:
> No, it does not. Using SQLite covers Virtual Tables in great detail, but
> not VFS systems. They’re somewhat unusual, after all.
>
My apologies - i mixed my terminology there!
--
----- st
geration), so it's _exceedingly_ unlikely to go
anywhere, regardless of how many +1s people collect to the contrary.
--
- 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 in
de of your call to
sqlite3_column_xxx(). (Users should always check the result codes of their
sqlite3 API calls.)
--
----- 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 pe
say:
"If the SQL statement does not currently point to a valid row, or if the
column index is out of range, the result is undefined. "
But you can figure out the count:
http://sqlite.org/c3ref/column_count.html
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.
quivalent is on Windows)
which simply causes mydb to be read into the filesystem cache,
independently of sqlite (again, subject to the whims of the OS).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the on
nything else is an update, delete, drop,
create table/view, non-select-like pragma, or similar.
--
----- 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, freedo
t.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 who insist on a perfect world, freedom will have to do." -- Bigby Wolf
te 3.7.7.1)
>
This looks like it was possibly (mis)handled by qt's driver internally, as
the sqlite docs say:
https://www.sqlite.org/datatype3.html
1.1 Boolean Datatype
SQLite does not have a separate Boolean storage class. Instead, Boolean
values are stored as integers 0 (false) and 1 (true
at error code does the insertion return? Perhaps the table is not getting
created due to the missing space?
--
- 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 behaviour you're asking about is explicitly undefined in sqlite. Today
it might work like you are reporting and tomorrow it might do something
different. The ONLY way to guarantee specific column names is to do what
Simon suggested: always use "as". If you don't, the exact results are
ed to port them into your app in order to use 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
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 is
still open.
--
- stephan beal
http:
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://wandering
error.
>
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 guaranteed byprod
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
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
a legacy 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 perfect w
ell.c). Grep the makefile and
shell.c for "linenoise" to see the compile flags and API uses (essentially
identical to the basic readline API).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed bypro
that, which won't work.
> snprintf(command, 512, INSERT_DN);
>
--
- 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 Fri, Jul 3, 2015 at 1:43 PM, Stephan Beal wrote:
> On Fri, Jul 3, 2015 at 1:39 PM, Kumar Suraj wrote:
>
>> #define INSERT_DN "BEGIN TRANSACTION; INSERT INTO TBL (dn) VALUES (?);
>> SELECT last_insert_rowid(); COMMIT;"
>>
>>
> prepare() expec
;
id = sqlite3_last_insert_rowid(...);
exec("COMMIT;");
--
- 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
m
>
FWIW, floor() and ceil() are also C99, not C89.
--
- 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
uot;has run to completion"?
Based on the above doc snippet, i would expect sqlite3_stmt_busy() to
return false after step() returns DONE.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed by
On Fri, Jul 31, 2015 at 10:51 AM, Hick Gunter wrote:
> SQLITE_DONE means that there are no (more) rows to be retrieved.
>
So that's the difference (for a SELECT) between that and "running to
completion"?
i think that's the source of the confusion.
--
----- s
m exceedingly glad that others have already implemented such gory
details.)
--
- 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
d sqlite, rather
than use a system-wide copy.
--
- 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) operation.
Not a complete answer, but a SELECT (or select-like pragma) will have a
column count of >0.
--
----- 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 pe
its storage model (don't remember why, just seem to
remember hearing/reading that). Perhaps this approach could be a viable
alternative?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
e matter.
That said, i have no idea how the python sqlite API reports errors - maybe
it's throwing an exception, which causes python to abort with code 255, but
i'm just speculating.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the
d, current_rank, original_rank)
> SELECT playerid, leagueid, auto_rank, auto_rank FROM t;
> DROP TABLE t;
>
That will lead to dupe IDs on subsequent transactions, won't it?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only guar
to
corrupt your database. See the bottom half of this page:
http://www.sqlite.org/whentouse.html
as well as any number of threads in this mailing list archives regarding
this topic.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only
e of a trade-off between space and time, and in the
general case more of one automatically implies less of the other.
[1] http://www.sqlite.org/pragma.html#pragma_page_size
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only guar
On Fri, Nov 1, 2013 at 12:53 PM, techi eth <techi...@gmail.com> wrote:
> DROP TRIGGER trigger_name From tbl_name = TestTbl WHERE ;
>
Google "drop trigger sqlite" says:
http://www.sqlite.org/lang_droptrigger.html
--
- stephan beal
http://wanderinghorse.net/home/st
for triggers.
It is possible (at least syntactically) to have the same trigger name in
two databases (attached to each other) but not two _different_ triggers
with the same name in the same db, as the documentation's diagrams clearly
imply:
http://www.sqlite.org/lang_createtrigger.html
--
----- steph
get MUCH better responses on this list if you will
start demonstrating that you've read the available documentation, rather
than showing us your hypothetical (obviously untested) SQL which in no way
reflects the realities of SQL nor sqlite3.
--
- stephan beal
http://wanderinghorse.net/home/ste
/wiki/Web_SQL_Database
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only guaranteed byproduct of those who insist on a
perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite
orth the extra
effort. Unfortunately, i have long since lost all that code (it was
implemented in JS, using a SpiderMonkey binding for sqlite), so i don't
have it to share with you, but the idea is simple enough that it doesn't
really need a demonstration.
--
- stephan beal
http://wanderinghorse.n
On Thu, Nov 7, 2013 at 12:15 PM, dd <durga.d...@gmail.com> wrote:
> Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
> ad this to my schema.
>
If you're only storing the list for local use on one machine, adding the
media ID is almost certainly overkill, but i
ckage).
>
How about telling your users that moving the data files while the app is
using them is "not supported"? i would think that this goes without saying,
but maybe some users need it to be explicit.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sg
when close() is called on the handle, the FS can then
free up that space.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only guaranteed byproduct of those who insist on a
perfect world
point which bit me once: if the input SQL is empty, the statement
will be NULL as well but 0 will be returned. So if the program is taking
arbitrary input from users, it may need to watch out for that case (and
simply do nothing).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://g
...
> It is safer and faster to use the sqlite3_bind_text() interface.
>
Also useful, if you can't use the bind() interfaces for some reason, is
sqlite3_mprintf(), which includes custom formatting specifiers which take
care of the quoting:
http://www.sqlite.org/c3ref/mprintf.html
S
sqlite> select last_insert_rowid();
1
sqlite> select rowid from t;
1
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Since tyranny's the only guaranteed byproduct of those who insist on a
perfect world, freedom will have to do." -- Bigby Wolf
sql >> bar.sql
[stephan@host:~/tmp]$ echo 'commit;' >> bar.sql
[stephan@host:~/tmp]$ time sqlite3 x.db < foo.sql
real 2m25.208s
user 0m0.380s
sys 0m0.468s
[stephan@host:~/tmp]$ rm x.db
[stephan@host:~/tmp]$ time sqlite3 x.db < bar.sql
real 0m0.344s
user 0m0.148s
sys 0m0.000s
B
On Fri, Nov 29, 2013 at 6:28 PM, J Trahair
<j.trah...@foreversoftware.co.uk>wrote:
> Does SQLIte run under Windows CE? And if so, which version should I
> download?
>
i know that the version which was current in late 2007 ran on WinCE, but i
haven't tried any newer versions.
--
ults (you
don't even need to step() 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 w
bar/baz you'll get the same thing. That page
is written in C. The /timeline part of the request is intercepted by C code
and the rest is ignored.
http://fossil-scm.org/index.html/timeline/foo/bar/baz
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freed
The first edition of this book coves SQLite version 3.6.23.1. As this goes
to press, work
on SQLite version 3.7 is being finalized."
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed by
the context, SQLITE_STATIC could be legally used, but only if
the string in question is guaranteed to survive (_unchanged_) for the life
of the statement.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only g
ear "table_info": syntax error
sqlite> create view v as select pragma table_info(vfile);
Error: near "(": syntax error
Is this possible?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the
uld be pretty easy to
> expand the given example to cover almost any SQL statement (including any
> PRAGMA).
>
> Even if you don't have a copy of the book, you can download the example
> code off the product page:
>
i've got the book, so many thanks for that tip - i'll take
), but there's nothing magical happening there which
can account for the "--" duplicates.
:-?
--
----- 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
table code near
the top of the linked snippet (stolen from fossil, of course, so the
original SQL came from you ;).
Thanks! That clarifies it!
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed by
;)
http://www.sqlite.org/c3ref/images/sqlite370_banner.gif
seems to be 404.
--
- 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, fr
wiki_lineage
ORDER BY mtime DESC;
Or am i misunderstanding what the docs intend to say?
--
- 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, fr
led explanation!
--
----- 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
___
unk)
and am free to use recursive select if necessary, but my instinct says that
this should be possible with joins and a CASE (for the status).
Any prods in the right direction would be much appreciated,
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Fr
On Sat, Feb 8, 2014 at 11:57 AM, RSmith <rsm...@rsweb.co.za> wrote:
> One way of doing it:
>
Many thanks to you and Kevin both! These examples give me plenty to study
for today :).
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"
name,
-max(case when vid=origin.v1 then 1 else 0 end )
+ max(case when vid=origin.v2 then 1 else 0 end)
from v, origin group by name
;
sqlite> .read x.sql
bar|0
barz|0
baz|1
foo|-1
Thank you very much :).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http:
1 - 100 of 621 matches
Mail list logo