_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 insist on a perfect world, freedom
.
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 byproduct of
those who insist on a perfect
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!
--
- stephan beal
http://wanderinghorse.net
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://gplus.to/sgbeal
Freedom is sloppy. But since
) 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, freedom will have to do. -- Bigby Wolf
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 byproduct of
those who insist on a perfect
) _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 beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
Freedom is sloppy. But since tyranny's the only
of [1412fcc480]
Actually, Fossil version 331204dc93 contained a dodgy version of
SQLite which could generate corruption reports such as the above. The
database was not really corrupt. The error was in the corruption
detection mechanism. That error has long since been fixed.
--
- stephan beal
://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 byproduct of
those who insist
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/
http://gplus.to/sgbeal
Freedom
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_synchronous
--
- stephan beal
http://wanderinghorse.net
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 world, freedom will have to do
a
pain in the butt. If your data are there for the software, as opposed to
the humans, i personally find Unix Epoch simpler to work with. If the data
are strictly for display/reading by humans, without much app logic tied to
them, ISO8601 is my preferred form (-MM-DD HH:ii:ss...).
--
- stephan
-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://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
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.net/home/stephan/
http://gplus.to/sgbeal
Freedom is sloppy. But since tyranny's
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 to do. -- Bigby Wolf
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 @ does NOT change the result of the function
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/stephan/
http://gplus.to/sgbeal
Freedom is sloppy. But since
://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 have to do. -- Bigby Wolf
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.to/sgbeal
Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist
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 to do. -- Bigby Wolf
]
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/stephan/
http://gplus.to/sgbeal
, 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 tyranny's the only guaranteed byproduct
...
throw new RuntimeException(unexpected argument type);
if that happens then you're not closing it.
try {
return statement.executeUpdateDelete();
} finally {
statement.close();
}
--
- stephan beal
http://wanderinghorse.net/home
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/sgbeal
Freedom
://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/sgbeal
Freedom is sloppy. But since tyranny's
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
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http
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 have to do. -- Bigby Wolf
. 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 to do. -- Bigby Wolf
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.net/home/stephan
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 arbitrary order.
--
- stephan beal
http://wanderinghorse.net
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://gplus.to/sgbeal
Freedom is sloppy
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.to/sgbeal
Freedom is sloppy. But since tyranny's
...
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 ...
Thanks for the details :).
--
- stephan beal
http://wanderinghorse.net/home
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
http://wanderinghorse.net/home/stephan/
http
. 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 guaranteed byproduct of
those who insist on a perfect world, freedom will have to do
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 main to the well-known name we have specified
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 who insist on a perfect world, freedom will have to do. -- Bigby Wolf
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 tables (which we use regularly
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 instead of memory for temp store.
--
- stephan beal
http
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 depending on the SQLITE_TEMP_STORE preprocessor symbol
ever even see 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
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 = 'allow'));
--
- stephan beal
http
, 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 to do. -- Bigby Wolf
/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/sgbeal
Freedom is sloppy. But since tyranny's the only
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
--
- stephan beal
http
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 tyranny's the only guaranteed
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 perfect world, freedom will have to do. -- Bigby Wolf
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 (and
thought yours
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 tyranny's the only guaranteed byproduct of
those who
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 biggest problem with that work
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
Freedom is sloppy. But since tyranny's the only guaranteed byproduct
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 since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do
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 seen PHP-based sites go
down because a dev's editor inserted
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
--
- stephan beal
http://wanderinghorse.net
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 since tyranny's the only
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 recall
this topic having come up only
://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 to do. -- Bigby Wolf
where
coalesce(a,'9')=$a,callback:'print(this)',bind:{$a:1}})
[1]
integer column and integer binding
s2 print(d.selectValue(select 1='1'))
0
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
Freedom is sloppy. But since tyranny's the only guaranteed byproduct
the db (not table) names, so
that i can tell libfossil that, e.g., repo is always the repo db, even if
it's really (also) main.
Perhaps a pragma:
pragma table_alias oldname aliasname
or
pragma table_rename oldname newname
either one would suit my purposes just fine.
:-?
--
- stephan beal
, 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 insist on a perfect world
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 only reasonable place
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 is sloppy. But since tyranny's the only guaranteed
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.g. sqlite3_rename_db(sqlite3*, char const
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.
Hope we never meet, because i will likely kiss you
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
rename it to Simon now ;). i've been fighting
--
- 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-users mailing
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 world, freedom will have to do. -- Bigby Wolf
___
sqlite
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://gplus.to/sgbeal
Freedom is sloppy. But since tyranny's the only guaranteed byproduct
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://wanderinghorse.net/home/stephan
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 traversal (via ptr++ resp. ++ptr) could not work.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
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 $?
1
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
Freedom
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.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http
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://gplus.to/sgbeal
Freedom is sloppy
.
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/home/stephan/
http
. 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 perfect world, freedom will have to do. -- Bigby
,
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 byproduct of
those who insist on a perfect world, freedom will have to do
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 .dump [t]
PRAGMA foreign_keys=OFF;
BEGIN
On Fri, May 23, 2014 at 8:53 PM, Humblebee fantasia.d...@gmail.com 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 ONLY
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
those who insist on a perfect world, freedom will have
defined and made by someone
else so I cannot change it. I'm a bit stuck with the way it is.
Then you're stuck with the problem you've got.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
Freedom is sloppy. But since tyranny's the only guaranteed byproduct
or pay forever.
If it IS a class assignment, the professor's point will almost certainly be
along the lines of, see how difficult that was? Now let's see how much
easier it can be done... (at which point he introduces normalization).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http
://sqlite.org/c3ref/complete.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
to achieve.
--
- 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
for me on Mint (Debian derivative).
it fails to link pthread at the end, but that's easy enough to fix: there's
a commented out line here:
#THREADLIB = -lpthread
THREADLIB =
With that, it builds for me.
(interestingly, it wants pthread even though THREADSAFE is set to 0?)
--
- stephan beal
--
- 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-users mailing list
don't think a WHERE is necessary to improve the efficiency. The statement
only gets prepared, not stepped, and i would not expect any analysis of
results until the first step() (but maybe i'm assuming too much).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
On Fri, May 9, 2014 at 11:38 AM, Stephan Beal sgb...@googlemail.com wrote:
i don't think a WHERE is necessary to improve the efficiency. The
statement only gets prepared, not stepped, and i would not expect any
analysis of results until the first step() (but maybe i'm assuming too
much
On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner sqliteh...@web.de wrote:
The PHP connection to SQLite DB (3.3.7) is made with PDO.
It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3
is ancient.
http://www.sqlite.org/releaselog/3_3_7.html
--
- stephan beal
http
On Fri, May 9, 2014 at 2:09 PM, Stephan Beal sgb...@googlemail.com wrote:
On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner sqliteh...@web.de wrote:
The PHP connection to SQLite DB (3.3.7) is made with PDO.
It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3
is ancient
if the second PREPARE succeeds.
}
--
- 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
message.
But that woudl require more memory and CPU cycles.
That would be resources well spent.
And might even be justifiable given other recent speed improvements which
offset them ;).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
Freedom is sloppy
.)
--
- 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-users mailing
On Mon, May 5, 2014 at 7:31 PM, Petite Abeille petite.abei...@gmail.comwrote:
On May 5, 2014, at 7:15 PM, Stephan Beal sgb...@googlemail.com wrote:
Why expect an error? It's abstractly the same as saying WHERE 'a' = 'b’,
I mean ‘where 1’, or ‘where ‘1 - 1’, or ‘where null’, or ‘where 0 / 0
implements a DCVS (i.e. Fossil), at which point sequential
numbers become literally impossible to generate.
--
- 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
be
platform-portable without settling on an encoding. If the goal is only
performance, though, it might (without encoding) be (marginally) faster
than using string-format data (be sure to use SQLITE_TRANSIENT when binding
the memory, too).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http
, to avoid that sqlite makes a copy of
the memory.
--
- 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 32bit limit and is self imposed by any 32 bit application
See also: https://sqlite.org/limits.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
with the database. This is to give
you the opportunity to issue PRAGMA statements that might influence the
opening process.
Running a very simple statement like
SELECT 1 FROM sqlite_master LIMIT 1;
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
On Fri, Apr 4, 2014 at 10:52 AM, 김병준 bjkm1...@naver.com wrote:
filesystem help, but there will be performance gain. ( e.g. From not
using Journaling
See:
http://www.sqlite.org/pragma.html#pragma_journal_mode
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to
1 - 100 of 501 matches
Mail list logo