[sqlite] Sqlite3.exe CLP features through sqlite3.dll

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

[sqlite] Why sqlite show qualified column names when selecting from views ?

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

[sqlite] Boolean constraint regression between 3.7.7.1 and 3.8.6?

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

[sqlite] Boolean constraint regression between 3.7.7.1 and 3.8.6?

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

[sqlite] Determine query type

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

[sqlite] Determine query type

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

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

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

[sqlite] datetime result help

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

[sqlite] Strange behaviour of sqlite3_stmt_busy

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

[sqlite] Strange behaviour of sqlite3_stmt_busy

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

[sqlite] Implement floor and ceil functions

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

[sqlite] error during bind

; 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

[sqlite] error during bind

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

[sqlite] error during bind

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

[sqlite] AUTOINC vs. UUIDs

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

[sqlite] Determine type of prepared statement via C Interface?

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

[sqlite] What software is deployed more than SQLite?

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

[sqlite] sqlite_column_blob & invalid index

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.

[sqlite] sqlite_column_blob & invalid index

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

[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

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

Re: [sqlite] sqlite3 mailing list broken

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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

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

Re: [sqlite] Encoding question

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:/

Re: [sqlite] Truncation of floating point numbers in SQLite?

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

Re: [sqlite] "database disk image is malformed" error occurs more

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

Re: [sqlite] Truncation of floating point numbers in SQLite?

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

Re: [sqlite] "database disk image is malformed" error occurs more frequently...?

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

Re: [sqlite] Buffered stderr on Windows (Take 2)

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

Re: [sqlite] Fsync or fdatasync performs slowly

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/

Re: [sqlite] Fsync or fdatasync performs slowly

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

Re: [sqlite] Database corrupted 28 billion bytes

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

Re: [sqlite] Best Practice: Storing Dates

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

Re: [sqlite] Support for millisecond

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

Re: [sqlite] Support for millisecond

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

Re: [sqlite] PHP: squelch warning and error messages

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

Re: [sqlite] PHP: squelch warning and error messages

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

Re: [sqlite] Parentheses in column name

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

Re: [sqlite] Table names length and content

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

Re: [sqlite] Table names length and content

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

Re: [sqlite] Table names length and content

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

Re: [sqlite] Bug report: USBAN failure

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

Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

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

Re: [sqlite] querying with BLOB in WHERE clause, possible?

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

Re: [sqlite] Recursive CTE on joined table

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

Re: [sqlite] sliteonline or sqlite in js

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/

Re: [sqlite] [SQLite] Support for 23,10 Precision number format

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

Re: [sqlite] cnt(x) what do the brackets signify

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

Re: [sqlite] Is sqlite thread-safety sufficient for use with "Go" language ?

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

Re: [sqlite] default ignore-glob for sqlite

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

Re: [sqlite] fixing time-warp

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

Re: [sqlite] fixing time-warp

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

Re: [sqlite] x64 vs x32 DLL

, 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

Re: [sqlite] Table qualification not supported in some cases (was: quasi-bug related to locking, and attached databases)

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

Re: [sqlite] Table qualification not supported in some cases (was: quasi-bug related to locking, and attached databases)

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] quasi-bug related to locking, and attached databases....

"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

Re: [sqlite] quasi-bug related to locking, and attached databases....

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

Re: [sqlite] calculating in the command line interface

On Wed, Oct 1, 2014 at 4:34 PM, Stephan Beal <sgb...@googlemail.com> wrote: > You're doing integer math. You need floating point: > > select round(1/2,10) as t; > 0.5 > And this time with the right copy/paste buffer: sqlite> select round(1.0/2,10) as t; 0.5 --

Re: [sqlite] calculating in the command line interface

let's try this, > > select round(1/2,10) as t; > > that also gave me 0.0. Then I said, h, let me try this, > You're doing integer math. You need floating point: select round(1/2,10) as t; 0.5 -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbe

Re: [sqlite] CLI dump command ignores view dependencies

other db files, possibly not attached, might be consumers of 'b'. -- ----- 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

Re: [sqlite] Trace callback is not called in a specific case

gument should have no spaces between them). It looks to me like you are linking the sqlite3 _binary_ (from the current directory) into your dbtest app (which is a usage error). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyrann

Re: [sqlite] Version info in doc pages

On Sun, Sep 21, 2014 at 2:53 PM, Stephan Beal <sgb...@googlemail.com> wrote: > fossil has its own built-in copy of sqlite. It sounds like you're using > one which was built with the --internal-sqlite=0 flag. > My UTMOST apologies - i'm confusing traffic from two lists here (an

Re: [sqlite] Version info in doc pages

ing to a newer version, if you've got an old one) and it should "just work." -- - 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 perfec

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Tue, Sep 9, 2014 at 6:46 AM, Stephan Beal <sgb...@googlemail.com> wrote: > On Tue, Sep 9, 2014 at 12:45 AM, Nico Williams <n...@cryptonector.com> > wrote: > >> I've played with building a JSON extension for SQLite3 using jq's >> excellent JSON C library. The

Re: [sqlite] What if OpenDocument were built atop SQLite?

nd, of course, > parse) in many cases where it could be avoided with some help from > SQLite3. > FWIW: http://fossil.wanderinghorse.net/wikis/cson/?page=cson_sqlite3 -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyr

Re: [sqlite] Request to change int parameter to size_t parameter / potential bug on iOS (64 bit)

would change the semantics and break and and all applications which rely on the current semantics (some of which are mine). See also: http://www.sqlite.org/limits.html which documents the 31-bit limit. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Free

Re: [sqlite] papercut wish list : a PRAGMA encoding='UTF-8-SIG'

On Wed, Sep 3, 2014 at 11:13 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > > "Stephan Beal" wrote... > > On Wed, Sep 3, 2014 at 9:56 PM, big stone <stonebi...@gmail.com> wrote: >> >> issues. Many software chokes on a BOM (e.g. i've s

Re: [sqlite] papercut wish list : a PRAGMA encoding='UTF-8-SIG'

seless in UTF8 because UTF8 has no byte-ordering issues. Many software chokes on a BOM (e.g. i've seen PHP-based sites go down because a dev's editor inserted one and it got deployed). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But si

Re: [sqlite] Curiosity question for an apparent change in Sqlite/timeline pattern

On Tue, Aug 26, 2014 at 6:58 PM, big stone <stonebi...@gmail.com> wrote: > (maybe I'm wrong and all is as speedy as usual) > Maybe this additional info will help: http://sqlite.org/src/reports?view=byweek http://sqlite.org/src/reports?view=bymonth -- ----- steph

Re: [sqlite] Window functions?

On Mon, Aug 25, 2014 at 9:43 PM, forkandwait <webb.spra...@gmail.com> wrote: > Stephan Beal <sgbeal@...> writes: > > > For the small percentage of users who need it (or would even know how to > > apply it). i've been following this list since 2006 or 2007 and i rec

Re: [sqlite] Window functions?

been following this list since 2006 or 2007 and i recall this topic having come up only a small handful of times, which implies that only a small minority of users feels the need for it. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But sinc

Re: [sqlite] How do I know the python functions registered on SQLite ?

f-query) http://fossil.wanderinghorse.net/repos/libfossil/index.cgi/wiki?name=DbFunctions -- ----- 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

Re: [sqlite] Problem with coalesce in a where clause with bind variables

7fffd16b3068 ref#=1] ==> Db@0x1eb4d20 s2> d.each({sql:"select * from t where coalesce(a,'9')=$a",callback:'print(this)',bind:{$a:1}}) [1] s2> print(d.selectValue("select 1='1'")) 0 -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal &

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

On Thu, Jul 24, 2014 at 4:51 PM, Stephan Beal <sgb...@googlemail.com> wrote: > [stephan@host:~/cvs/fossil/libfossil/src]$ f-query -e "select * from > ckout.vfile limit 1" -S > BTW: the -S option has historically meant "SQL Tracing," but i think i'll ren

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

On Thu, Jul 24, 2014 at 4:45 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Jul 2014, at 3:38pm, Stephan Beal <sgb...@googlemail.com> wrote: > > > THANK YOU! > > You're welcome. I'm still learning more from this list than I'm putting > out. > Ho

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

On Thu, Jul 24, 2014 at 4:10 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Jul 2014, at 3:07pm, Stephan Beal <sgb...@googlemail.com> wrote: > > > A simpler solution which would serve my goals just as well: the ability > to > > rename only 'main' (e

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

ite3_rename_db(sqlite3*, char const * newName)). i don't need 'main' because main is fluid in these apps. i need a well-defined name which sticks with a db regardless of whether it is opened or attached. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

On Thu, Jul 24, 2014 at 3:51 PM, Stephan Beal <sgb...@googlemail.com> wrote: > i did in fact try that (way back in the beginning), using a :memory: db as > my main db. > note that i can't justify using a file for this purpose, because that file has to live somewhere, and the

Re: [sqlite] feature request: aliasing (or renaming) db (not table) names

ain db. However, the :memory: VFS is (interestingly) not capable of generating temp file names, and i need that feature :/. -- ----- 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 insis

[sqlite] feature request: aliasing (or renaming) db (not table) names

oldname newname either one would suit my purposes just fine. :-? -- - 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 ___

Re: [sqlite] Hexadecimal integer literals

ns which take hex strings and return an int. Then you've got much more freedom in terms of error reporting, as it all happens via the function: select hexint('0x10') 16 -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is slo

Re: [sqlite] SQLite memory testing

that. > And yet they refuse to remove 'lite' from the name ;). -- - 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

Re: [sqlite] think I need better error-handling guidance in the C API

On Thu, Jul 3, 2014 at 4:44 PM, Stephan Beal <sgb...@googlemail.com> wrote: > non-error, non-0 error codes (SQLITE_STEP and SQLITE_DONE). Anywhere else > in the API, non-0 means Bad News. There > correction: SQLITE_ROW and SQLITE_DONE -- ----- stephan beal http://wanderin

Re: [sqlite] think I need better error-handling guidance in the C API

verable (IMO). The fact that (literally) millions of applications get written despite any perceived shortcomings in the documentation suggests that the docs are at least "adequate," if not "perfect." -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplu

Re: [sqlite] Porting SQLite to Nurit OS ver

misunderstanding the problem (haven't got the code on this machine and am too lazy to google it up), it's simple to deduce that this is a compiler bug: in C, for any array of type X, any element of that array is guaranteed to be exactly sizeof(X). C guarantees this, or conventional array traver

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

cwal/s2]$ echo $? 1 So yes, it fails. Any specific error code it returns is moot, though, because POSIX doesn't guaranty any specific range of errors other than OK and Not OK. Additionally, a large-enough error code could overflow (as in my first example), leading to unpredictable results. --

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

ed. Failing to SELECT or DELETE anything is not an error, so no, it won't fail in that case. It will fail if your syntax is wrong: [odroid@host:~/fossil/fossil]$ echo "drop foo;" | sqlite3 Error: near line 1: near "foo": syntax error [odroid@host:~/fossil/fossil]$ echo $?

Re: [sqlite] lifetime of buffer referred to with SQLITE_STATIC

. i use SQLITE_STATIC quite a lot for non-static data (b/c copying bytes for this type of thing pains me greatly), and the only guaranty i've ever needed making is that the bytes outlive the step() which accesses them. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gpl

Re: [sqlite] sqlite4 Windows build

qlite3 and may not apply for v4. There is, AFAIK, no pending release for v4 planned in the immediate future. -- - 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

Re: [sqlite] Comments loss in sqlite_master table

allowed to appear is implicit. That said: there are very likely client programs out there which parse the schema from sqlite_master for various purposes, and comments could very well break them: create table foo(a) -- old version: create table foo(a,b) ; -- - stephan beal http://wanderinghorse.net/

Re: [sqlite] Simple Select from IN - from a newbie.

On Fri, May 23, 2014 at 8:53 PM, Humblebee wrote: > Does this mean that if the View is Temporary, then it's not cached? > and for normal views, it's cached? > No - a TEMP VIEW means the view is automatically destroyed when you close the db connection, and that view is

Re: [sqlite] Simple Select from IN - from a newbie.

On Fri, May 23, 2014 at 8:33 PM, Stephan Beal <sgb...@googlemail.com> wrote: > FWIW, you can also use [table] instead of "table". > With, apparently, some corner-cases: sqlite> create table [t] (a,b,c); sqlite> insert into [t] values(1,2,3); But... sqlite> .d

Re: [sqlite] Simple Select from IN - from a newbie.

. Single quotes, on the other hand, > are used to enter string literals. > FWIW, you can also use [table] instead of "table". -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed b

Re: [sqlite] Suggestion for shell .IMPORT improvement

oose the S.Q.L. of sqlar which sounds to > me like C-quel-ar ;) > Maybe this is stretching it a bit, but how about... darh? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of tho

<    1   2   3   4   5   6   7   >