On Fri, Jul 6, 2012 at 5:29 PM, Gavin T Watt wrote:
> Can anyone tell me where (what country) the SQLite server(s) are located?
>
If i remember Richard's recent presentation properly there are 3 in the US
(west coast, Texas, and east coast) and a newer one in the UK(?).
--
----- s
On Sat, Jul 7, 2012 at 12:24 AM, Gavin T Watt wrote:
> BTW, do you know if the SQLite team runs any kind of static code analysis
> on the source?
>
http://www.sqlite.org/testing.html
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.
ings than have been found by static
analysis."
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
order of the -lxxx
flags relative to my own .o/.a files which use symbols from the -lxxx
libraries.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
inux-gnu/libc.so.6 (0x7f07c9da1000)
/lib64/ld-linux-x86-64.so.2 (0x7f07ca396000)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailm
ill prefer the file
GNUmakefile over Makefile if it exists.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
stephan@tiny:~/cvs/fossil/sqlite4$ uname -a
Linux tiny 3.0.0-12-generic #20-Ubuntu SMP Fri Oct 7 14:50:42 UTC 2011 i686
i686 i386 GNU/Linux
--
- stephan beal
http://wanderinghorse.net/h
. That branch is needed to compile sqlite.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng language of choice.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
r purposes of bind_parameter(),
or may only parameters in the main expression be named? e.g. if @p1 had been
part of the WHERE clause in a subselect?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users
data. If it did, the runtime would probably be O(N) or worse, not O(1)
(as described above).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/lang_altertable.html
and read the 3rd paragraph. If it is not part of a trigger, then simply
correct the spelling in your program/SQL script.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sq
m a session with the MySQL or ocilib
(Oracle) APIs.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
l so far, and i haven't yet had any
mis-parsing except on code which was itself not legal SQL (i.e. it doesn't
seem to create any new problems where there isn't already a problem).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
instinct is to trust this description. The
linux man pages tend to explicitly mark any behaviours which do not conform
to the spec(s) mentioned in the "CONFORMING TO" section of the given man
page.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
For that small handful of sqlite3+v8 hackers out there...
http://code.google.com/p/v8-juice/wiki/JSPDO
JSPDO is a PHP PDO-like db access abstraction API, but using JavaScript (via
the Google v8 JS engine). It supports sqlite3 and MySQLv5.
Happy Hacking!
--
- stephan beal
http
), and the
extra 80kb were from the hard drive's large block size (slack space reported
by 'df').
Kinda funny, though, that sqlite3 actually decreases the amount of storage
required in this case.
--
- stephan beal
http://wander
system that do versioning as well as backups
> (such as Time Machine).
>
In this case that's not the issue - the application using the db _is_ the
wiki back-end/manager, so the pages have to be in the db. i only have them
as files because i imported them from a GoogleCode project.
-
red text files.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sing g++? If so, please tell me how.
>
There is NOTHING wrong with mixing .c and .cpp files in one C++ project.
Compile the C code with gcc and C++ code with g++, and then link them
together as you would any other objects.
--
----- stephan beal
http://wanderinghorse.n
we use whatever's
on the system. i did that because when i launched my project on my web
hoster i found that i couldn't compile there because they have an ancient
(3.3?) sqlite3. So i added the option to add your own amalgamation to my
tree.
--
- ste
On Tue, Jun 28, 2011 at 8:04 PM, Stephan Beal wrote:
> You're both very right, and might i suggest a compromise: in my latest
>
Might i add that all involved machines were some flavour of Linux, which
favour's Simon's argument against relying on the system's sqlite
le and needs HARD TABS, which will almost certainly
be lost through the email path.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Jun 28, 2011 at 8:42 PM, thilo wrote:
> sqlite> select (select v from t1 where n="a") wrong,* from a1;
>
use SINGLE quotes, not double quotes.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite
ouble quotes, but that is an unportable SQL extension.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ter wrote about it in "C++ Coding Standards", if i'm
not mistaken.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Jun 30, 2011 at 9:06 PM, Tom Browder wrote:
> Thanks, Richard (and Simon), I think I can solve my web access problem
> by giving the db file its own directory.
>
You can also try disabling the temp files (telling it to use memory
instead).
--
- stephan
memory for the journal, but i
was assuming the journal is considered a temp file.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ould expend
the effort to look for a real solution, rather than relying on something
like that (i can't sleep at night if i know my software might break at any
second due to hacks like that one).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
ck will be greately appreciated!
>
See:
http://www.php.net/manual/en/pdo.error-handling.php
and enable exception throwing. Then any errors will throw an exception and
the problem will be easy to track down.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
(same directory)?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
O _only_ throws exceptions if you set the exceptions reporting option. Try
instantiating it like this:
$attr = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION );
$dbh = new PDO($dsn, "", "", $attr );
--
- stephan beal
http://wanderinghorse.net/home/stephan/
On Thu, Jul 7, 2011 at 2:17 PM, Simon Slavin wrote:
> For each operation you should test the $result and check to see it's
> SQLITE_OK.
>
Or enable exceptions and you don't have to check for errors (because they
will cause an exception).
--
- stephan beal
http://wand
this in order to write the journal).
>
> $dbh = new PDO('sqlite:db1.db');
> $result=$dbh->query("create table tbl2 (one varchar(10),two
> varchar(10));");
> var_dump($result);
> ?>
>
Can you show us the OUTPUT of that command?
And i highly recommend
however your db is named)
Order allow,deny
Deny from all
so that people who know the db is there can't fetch it over http.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-user
On Mon, Jul 11, 2011 at 2:41 AM, James_21th wrote:
> $result=$dbh->query("create table tbl2 (one varchar(10),two
> varchar(10));");
>
A CREATE statement has no results. In PDO, only SELECT (and similar) return
a result, if i'm not mistaken.
--
- stephan beal
htt
ptimizations is not an option)? If I know
>
Coincidentally, i just tried -O3 and the end result was almost 0.5MB larger
than with -g -Os.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@
resses (as you
demonstrated), 10 bytes x 100B records = 1 terrabyte JUST for the addresses
(not including any sqlite3-related overhead per record, which is probably
much larger than the 10 bytes you're saving).
--
- stephan beal
http://wanderinghor
y case: that page claims that the limit of the
file size is theoretically 2^64 but that 14TB is the practical limit. i
thought that the limit was somewhere under 4GB.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing
cii-compatible up to value 127).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Jul 25, 2011 at 4:39 PM, Dave Hope wrote:
> make sqlite3.c "-DSQLITE_OMIT_ALTERTABLE -DSQLITE_OMIT_ANALYZE
>
Shouldn't that be:
make sqlite3.c CPPFLAGS="..."
?
Make doesn't understand -D (no, that's not a smiley).
--
- stephan beal
ht
-..."
So it seems that OPTS= is missing.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
y using command line tool.
> ...what could be the reason
>
Can you show us the C code? Without that we can only guess.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
wo which i'm not aware
of.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ost never" a good idea to implement copy ctors for classes which
refer to stream handles and such.
The absolute simplest/sanest/safest way to implement this is to declare the
copy ctor and copy assignment operator as private and NOT implement them.
--
- stephan beal
http://wand
oints to them. A
memcpy() will copy the pointers but not their contents. i.e. you'll have 2
copies of an sqlite3 handle which both point to (and own!) the underying
memory.
NEVER use memcpy() to copy non-trivial types (e.g. those which contain owned
pointers).
--
- stephan
On Thu, Aug 4, 2011 at 7:15 PM, Vinoth raj wrote:
> It would be a great help if you can shed some light on my problem. Is it
> possible at all to save SQLite database on a server?
>
http://www.sqlite.org/whentouse.html
--
- stephan beal
http://wanderinghorse.net/hom
On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal wrote:
> http://www.sqlite.org/whentouse.html
>
Specifically: 2nd section, 1st list item.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite
undo/redo implementation can be written in surprisingly
little code."
i'm wondering if anyone can point me to an example of implementing such a
beast?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing li
On Thu, Aug 4, 2011 at 8:13 PM, Dustin Sallings wrote:
>https://github.com/dustin/kvtest/blob/master/sqlite-base.cc#L160
>
The code is short and to the point. Thank you :).
--
- stephan beal
http://wanderinghorse.net/home/s
On Thu, Aug 4, 2011 at 9:44 PM, Alexey Pechnikov wrote:
>
> http://sqlite.mobigroup.ru/artifact/265e408b4352d66cfc79a9990cb2c22fb390d3b6
>
> http://sqlite.mobigroup.ru/artifact/2250bbbc83f80eff73ce003ab7a30293c688ae9b
That is one of the coolest things i've seen months :).
uot;), in the form you describe, is not
ANSI-specified.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
berally licensed.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, Aug 12, 2011 at 2:09 PM, Sumit Gupta wrote:
> query is only reading about 400-500 record per minute. This way it is going
>
If you are not currently using a transaction to wrap the whole import, add a
transaction and the speed will improve a great deal.
--
- stephan bea
ill
> taking minutes to record that data.
>
The answer is the same as it was yesterday: wrap the inserts in a
transaction.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://s
istory(X)
# define write_history(X)
# define stifle_history(X)
#endif
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Aug 17, 2011 at 6:25 PM, Stephan Beal wrote:
> Just to be pedantic for a moment: the shell is GPL if you #define
> USE_READLINE to a true value. Such is the reality of viral licenses. From
> shell.c:
>
And to be even more pedantic: that code came from the WRONG shell.c (
o do...
Happy Hacking!
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Aug 17, 2011 at 11:52 PM, Richard Hipp wrote:
> On Wed, Aug 17, 2011 at 12:28 PM, Stephan Beal >wrote:
>
> > But the reality is still: if the sqlite3 shell links with libreadline, it
> > is GPL.
> >
> >
> Not.
>
Sorry, i wasn't clear: the res
which we kids
should not try at home.
:-?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
quot;
given this particular problem, and i'm suspicious because of that. It
_seems_ to be exactly what i'm looking for, but i also know that my
knowledge for the effect of EINTR on system calls is too constrained for me
to have my own educated, confident opinion on it.
--
- stephan beal
h
a little gem i didn't know. That clarifies things greatly.
Thank you :).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or
> EAGAIN, or maybe some others.
>
That's the key semantic i was missing.
> I HOPE that an interrupt in a large interrupted write will NOT return
> EINTR, because if it does, the partial write is screwed up.
>
i hope so, too! :-D
Thank you for your
On Thu, Aug 18, 2011 at 6:10 PM, Stephan Beal wrote:
> On Thu, Aug 18, 2011 at 5:27 PM, David Garfield <
> garfi...@irving.iisd.sra.com> wrote:
>
>> I HOPE that an interrupt in a large interrupted write will NOT return
>
> EINTR, because if it does, the partial write i
tion.
>
The workaround would be simply to switch the order of the DROP TABLEs,
wouldn't it?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tatbuf.st_size==0 && (pFile->fsFlags & SQLITE_FSFLAGS_IS_MSDOS)!=0 ){
do{ rc = osWrite(fd, "S", 1); }while( rc<0 && errno==EINTR );
if( rc!=1 ){
line 1159 in my copy. In that particular case, with a length of 1, they are
"probably" semantically e
hen
SQLite is not in autocommit
mode<http://www.sqlite.org/c3ref/get_autocommit.html>).
Attempting to do so does not return an error; it simply has no effect.
so the pragma switch would have to come before/after the transaction, as
opposed to being part of it.
--
- stephan b
o maybe it has a byte
or two of historical value ;).
And for C/C++ wrappers:
http://fossil.wanderinghorse.net/repos/cpdo/
cpdo is a PDO-like db access abstraction layer for C. Includes a C++ wrapper
API.
Happy Hacking!
--
- stephan beal
http://wanderingh
se send me some instructions on what I need to install and how to
> install it? Thanks a lot.
>
You just did install it. That program is sqlite.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-u
ever decrements. If the
rowid limit is ever hit (very unlikely to happen!) you'll get a "db full"
error, in which case it's probably time to recreate the table to get the
rowid to start counting at 1 again.
--
- stephan beal
htt
attempt to insert a new row
will fail with an SQLITE_FULL error."
and didn't consider that there might be different algorithms in play.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sql
that the "last" insert ID (sqlite3_last_insert_rowid()) in his case was the
ID of an insert (in a different table) caused as a side-effect of an
on-insert trigger in the original target table.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
Oracle's CLI client
("sqlplus") - as long as i had sqlplus opened and connected, my PHP pages
couldn't insert any data.
i.e. this type of problem isn't limited to sqlite3.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
egory of problem is not specific to the
combination of sqlite3/AFP.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
GB of that might not be allocatable to non-root
processes.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
00% or more. It's probably not always that slow, but
it was on the couple of Linux/Solaris systems i tested on a couple years
ago.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:/
that diff (in the unchanged part)
which look like they might also need to be updated (but i'm not certain, as
i don't grok that code at all):
...
** that the file needs to be extended at this point. Otherwise, the
** SQLITE_FCNTL_SIZE_HINT operation is a no-op for Unix.
Happy Hacking
s table (848207 rows):
select pays, zip, ville, region from allcountries where typos(ville,
> 'saopaul%') < 3 group by pays, ville, region
>
Cool - can you please post a link to the sources?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
_
e using CREATE TABLE ... AS SELECT ... could violate
the space constraint.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Aug 30, 2011 at 6:41 PM, NOCaut wrote:
>
> This line most finalizate
> q.finalize(); <<<<<<
>
> or not?
>
it doesn't if the query throws unless the query class also calls finalize()
in its dtor.
--
- stephan be
On Thu, Sep 1, 2011 at 9:10 AM, NOCaut wrote:
>
> How wait for finish query?
> while(q1.step()); // or q1.fetch() <<< this function i not find
>
try q1.finalize(), as someone suggested for your previous post.
--
- stephan beal
http://wanderingh
mall wrapper function which does the logging and
executes the statements? It could take additional arguments, e.g. a symbolic
name for the source of the query (e.g. "app2.funcA()").
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sql
conditions and can therefore (at least in
principal) respond with the first result more quickly.
Whether or not that explains the whole difference, i cannot say (only
profiling could), but some of the gurus on the list can probably give you
some ballpark numbers on the effect the WHERE clause has.
--
---
he whole row (and thus the
overhead of the blob is disproportionately high, since we are copying it but
not modifying it).
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.or
On Mon, Sep 5, 2011 at 6:59 PM, Dan Kennedy wrote:
> You could get the same effect by wrapping your loop in a BEGIN/COMMIT
> block.
Out of curiosity: would a BEGIN/ROLLBACK be equivalent for this case (where
only SELECTs are used)?
--
- stephan beal
http://wanderinghorse.net/home/s
worry about multi-anything, then you shouldn't see anything alarming.
>
Doh, i wasn't aware that an explicit rollback is treated as an error, but my
quick tests with the JavaScript bindings show that it is.
--
- stephan beal
http://w
lag;
>
wouldn't it be simpler (and more accurate) to return rc instead of
successFlag (which is not set properly, IMO, if journalMode, eventLogTable,
or trigger fail to exec().
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
because of external problems. e.g. out-of-memory or i/o
error. Once you get one of these errors, it's generally not a good idea to
continue using the db handle (i would argue, though there are those who
could rightly argue otherwise).
--
- stephan beal
http://wanderinghorse.net
On Tue, Sep 6, 2011 at 5:33 PM, Eduard Filipas wrote:
> i searched your website and i cant find sqlite3.h file. where can i get
> proper one?
>
http://www.sqlite.org/download.html
it's part of the download bundles. Try the top link on that page.
--
- ste
emoves a dep on -ldl (which, when linked in, prohibits static linking of my
CGI binary).)
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Sep 8, 2011 at 12:32 PM, Stephan Beal wrote:
> i reported this problem before, then retracted it because i couldn't
> reproduce it, and now i seem to have stumbled again upon the magic
> combination which triggers it...
>
and of course i should have mentioned: Ubuntu 10
o you could workaround with that in mind.
>
Yes, you can. i do it all the time, along with for the standard
printf/scanf format specifiers (but _those_ don't support int64_t on 32-bit
platforms in C89 mode, in my experience).
--
- stephan beal
http://wanderinghorse.net/home/stephan
0GB on-storage db on that same machine.
:-?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Sep 14, 2011 at 6:06 AM, Freddy López wrote:
> I would like to know if you can help me with it. My knowledge of C is poor.
>
We can't possibly help until we know what the problem is. Can you please
post the compiler output?
--
----- stephan beal
http://wanderinghorse.net/h
maining errors are side effects of that.
Can you try:
gcc -std=c99 -fPIC -lm -shared extension-functions.c -o
libsqlitefunctions.so
to see if that works around the problem? (If not, please post the errors
again if they are notably different from the ones you already posted.)
--
- stephan
ng on an old sqlite3 API (which possibly had an
i64 typedef). But i'm just guessing.
:-?
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
)&";"
>
That code can't possibly evaluate to valid SQL, i think: there's a missing
"& pair before the 2nd sqlite_escape() call.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
on, e.g. links between btree nodes. i can't say with certainty how
much of those 70 bytes is overhead, but one of the devs probably can.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.or
p://orafaq.com/faq/difference_between_truncate_delete_and_drop_commands
DROP has less overhead associated with it (e.g. no triggers fired). Note
that TRUNCATE described on that page is (apparently) not supported in
sqlite3 (or that's what my shell tells me).
--
- stephan beal
http://wanderin
bsequent insertions.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
401 - 500 of 626 matches
Mail list logo
