can be seen at
http://www.sqlite.org/releaselog/3_7_6.html
Please send email to the sqlite-users@sqlite.org mailing list, or directly to
me, if you encounter any problems. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
On Apr 12, 2011, at 8:49 AM, D. Richard Hipp wrote:
> SQLite version 3.7.6 is not available from the website:
> http://www.sqlite.org/
The "not" in the sentence above should be "now", of course. Sorry for the typo.
>
> Version 3.7.6 is a regularly schedule
list (sqlite-users@sqlite.org) or
directly to me if you encounter any problems. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mailing list (sqlite-users@sqlite.org) if you
encounter any problems with this release.
--
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
versions is recommended.
Additional information about this release can be found at:
http://www.sqlite.org/releaselog/3_7_9.html
http://www.sqlite.org/news.html
As always, please let me know if you encounter any difficulty with this release.
D. Richard Hipp
d...@sqlite.org
we probably will make the prebuilt libraries threadsafe
on all
platforms.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
releases. But until I better understand the backwards compatibility
issues,
I think it is probably better to leave it off for now.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Sep 2, 2007, at 1:13 PM, Miguel Fuentes wrote:
I didn't know .lib were much larger =\
I always use .a files, so my bad
I just linked it into my exe and got a final 420kb exe.
See also http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite
D. Richard Hipp
[EMAIL PROTECTED
extension.
So it doesn't have an ECCN.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
, or 3?
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
table implementation (other than the
ones
that are included with SQLite - such as FTS1-3) that will be broken
by an
API change, please let me know. And please also advice me how much of
a hardship a change would be for you.
D. Richard H
t is often
a good idea to run your GUI in a separate process from your
compute engine so that long computations don't free the display.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED]
--
---
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
the highest precedence?
SQLite version 3.5.2
Enter ".help" for instructions
sqlite> select ~1 - ~5;
-8
sqlite> select (~1) - (~5);
4
That would be a bug in lemon...
D. Richard Hipp
On Nov 17, 2007, at 5:12 PM, D. Richard Hipp wrote:
On Nov 17, 2007, at 4:58 PM, Joe Wilson wrote:
I'm having difficulty with Lemon's operator precedence.
That would be a bug in lemon...
I was wrong. Turns out the bug was in the SQLite grammar
file parse.y. It was assigning the same
erator precedence as the SQL standard
requires. If I am wrong about that, please correct me and I will
change it.
On the other hand, changing the operator precedence to agree with
MySQL or MSSQL is not something we are interested in doing if they
are using a non-standard precedence.
D. Richar
system.
On Linux systems that typically use Doug Lea's malloc, there is
no measurable performance difference. But I have had some
people running embedded systems tell me that using the
malloc-free SQLite results in a significant speed boost. Your
mileage may vary.
D. Richard Hipp
[EMAIL PROTECTED
On Nov 19, 2007, at 12:36 PM, James Dennett wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 7:36 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Not only applicable to real time systems. If you want a program to
connection. SQLite
contains its own mutexes to serialize access.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ame database within the same process
and use them independently and locking should work correctly. You
should not have to change anything. It should just work.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ms.
Tried to index also 'ModifiedDate' but it didn't help.
What am i doing wrong?
Thanks,
Ofir Neuman.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ously here.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
GLOB where the right parameter is
a literal string. It will not do so if the right parameter is a
parameter. http://www.sqlite.org/optoverview.html#like_opt
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
imperfectly executed, but it is my goal.
If that means that SQLite is uncompetitive, then so be it.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
thorough, but I have found that users
can be very creative in stressing SQLite in ways that I would
have never imagined, and have not developed tests for.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email
and the thoroughness of the test suite. Not much
is likely to slip through the cracks.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
to
work on and less error prone. An entire class of errors (stack
overflow) such as the recent ticket #2832 (which could cause
database corruption) will become impossible since the VM will
no longer have a stack to overflow.
D. Richard Hipp
[EMAIL PROTECTED
On Jan 13, 2008, at 7:53 PM, Gerry Snyder wrote:
Joe Wilson wrote:
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
There are people on this mailing list (ex: Joe Wilson) who appear
to read every line of every change that we make to SQLite, within
minutes of making th
ometimes, when you want the
text of your SQL statement to be under program control, you want
to use "..." instead. Just be very sure you know exactly what you
are doing whenever you use "..."
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
]
--
---
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
This is the initial test message for the new SQLite mailing list, using
GNU mailman now instead of ezmlm.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
it, having never seen any benefit
for such a thing. Can you explain why you think strict affinity mode
might be beneficial to you? If somebody can provide a good
enough rational to justify strict affinity mode, we might just put it
in.
D. Richard
ndow’s eclipse environment
> with Sqlite-3.6.23.1.tar.gz file
> Thank you for giving many information. Thank you.
>
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
birthdays!
Thanks, everybody, for helping to make SQLite the most widely deployed
SQL database engine in the world. And Happy 10th Birthday to SQLite!
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
er,tstr);
> }
> strcat(DataBuffer,"\n");
>
> gettimeofday(,NULL);
> timeuse=100*(tpend.tv_sec-tpstart.tv_sec)+
> tpend.tv_usec-tpstart.tv_usec;
> timeuse/=100;
> printf("SQLCallBack Used Time:%f\n",timeuse); // print value :
> 0.000280s
>
> return 0;
> }
>
> //---
, code generator, and virtual machine from
SQLite in its Berkeley DB product. Additional information about
Berkeley DB's SQL API is available at
http://www.oracle.com/technology/products/berkeley-db/sql.html
D. Richard Hipp
d...@hwaci.com
quot; I have checked under M$ debugger (not coverable
errors in my PHP/PDO-Sqlite script with parameters binding), but
possible other cases in massive switch statement, I think ...
greetings from Poland,
JureKL.
--- End forwarded message -
D. Richard Hipp
d...@hwaci.com
___
. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-testing SQLite 3.7.0 in your application!
Report any problems found on this mailing list.
You can download daily snapshots from http://www.sqlite.org/draft/download.html
and view updated documentation at http://www.sqlite.org/draft/index.html
Thanks.
D. Richard Hipp
d...@hwaci.com
. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
will slip the release
again if necessary. Your beta testing is *very* important. Thanks!
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
me know at once.
Thanks!
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of the
possibility of database corruption, upgrading to version 3.7.0.1 is highly
recommended.
If you encounter any problems, please report them directly to me or to the
sqlite-users@sqlite.org mailing list.
D. Richard Hipp
d...@sqlite.org
___
sqlite
you login. Userid="anonymous"
Password="anonymous". Then click on the link again.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tead of saying:
sqlite3_prepare $::DB ...
we can now say:
sqlite3_prepare db ...
which is much more convenient. However, the test scripts have been
generated incrementally over the past 8 years and most of them have not
been upgraded to take advantage of the new syn
er
database with an historic version of SQLite - that would be
forwards compatibility. SQLite is generally forwards compatible,
except when the newer database uses features which were
added later.
The added feature is probably a descending index.
D. Richard Hipp
[EMAIL PROTECTED]
__
tomorrow.
But mem5 is high on the list of memory allocators to keep
since it can, under some circumstances, guarantee not to
fragment memory, which is a desirable property for
embedded systems.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users m
On Apr 1, 2008, at 2:37 PM, Richard Klein wrote:
>>
> Fair enough. But can I assume that mem5 *does* currently
> work, as far as you know? (I'd really like to use it, as
> I'm using SQLite on an embedded system.)
>
mem5 works as far as I know.
D. Richard Hip
s to the db inside callback
>
> sqlite3_prepare((sqlite3*)data_arg_3, [...])
>
> , an error SQLITE_MISUSE is returned to me
SQLite is not reentrant through the update hook.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sq
en which uses some
memory and at least one file descriptor. If you really are never
going to
use the database again (or at least not soon) it is better to call
sqlite3_close() too.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlit
On Apr 3, 2008, at 3:39 PM, Steven Fisher wrote:
> Can Final be called without Step first being called?
Yes.
>
>
> If Step is called, will Final always be called?
Yes
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
isk. Different strokes for different folks, I guess...
Anyway, you can fix the problem by either using the
precompiled binaries, or downloading the latest from
CVS.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sql
some way
to have pointers from the English-language pages over to the
translated pages.
This same offer applies to anybody else who wants translate SQLite
documentation into any other living language.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mail
>
> Thank you for your answer D. Richard,
>
> So I continue the translation and I will see fossil for future.
> Can you take a ticket for this evolution ?
>
We can work with you to import your translation whenever
you are ready.
D. Richard Hip
alendar
refer to two different people named Julius. The Julian Day Number
Julian is Julius Scaliger, the father of the guy who invented
the julian day number in 1583. Julian in Julian Calendar refers to
Julius Caesar, the Roman emperor.
The date and time routines in SQLite use the Gregorian calend
On Apr 7, 2008, at 6:27 PM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> See http://en.wikipedia.org/wiki/Julian_day
>>
>> Note that "Julian" in Julian Day Number and Julian Calendar
>> refer to two different people named Julius. The Jul
avvy but can blunder my way around. (am reading a
> basic C tutorial right now).
>
You might be interested in sqlite3_auto_extension
http://www.sqlite.org/c3ref/auto_extension.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlit
On Apr 8, 2008, at 12:57 PM, dark0s dark0s wrote:
> Hi all, I'd like write extension for sqlite3 creating soundex
> function like below:
>
SQLite already contains a soundex function. You just have to recompile
using -DSQLITE_SOUNDEX=1
D. Richard Hipp
[EMAIL
e to use the BTree routines directly,
and your code breaks or malfunctions due to some unseen subtly or
some future change, then the rule is: "No Tears".
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nerator. But you should know that we are not through
changing
it yet and more big changes could appear in future releases. The
virtual
machine in SQLite is not an API and we make positively zero effort to
maintain
backwards compatibility from one point release to the next.
D. Richard Hi
in front of the
column name). The plus sign is a no-op - it generates no code
and returns the value of its operand unchanged even if the value
is a string. But it also disables the term as a candidate for using
indices.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
across
> that page. Are these the only times you can get SQLITE_LOCKED errors?
If you are in the middle of a SELECT statement and from the same
database connection you try to DROP one of the tables that is being
read, the DROP statement will return SQLITE_LOCKED.
D. Richard Hipp
[EMAIL PRO
a table out from
under a reader.
I am not aware of any reason why you cannot retry an SQLITE_LOCKED
error after a delay, however. Have you actually tried doing that?
Is it giving you trouble?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailin
SQLITE_MISUSE
> being returned.
>
Did you call sqlite3_reset() before each retry?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
into every new database
you create
with the same schema.
Some database engines benefit from running ANALYZE periodically. SQLite
does not, in general.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.o
On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote:
>
> On Apr 14, 2008, at 4:47 PM, Steve Topov wrote:
>> I can open the file with 3.3.5. I did not try to dump it and recreate
>> with 3.5.6.
>>
>
> With version 3.5.5, please do this:
>
> sqlite3 you
On Apr 14, 2008, at 4:47 PM, Steve Topov wrote:
> I can open the file with 3.3.5. I did not try to dump it and recreate
> with 3.5.6.
>
With version 3.5.5, please do this:
sqlite3 yourdatabasefile.db .schema >schema.txt
then email me schema.txt file.
D. Richard Hipp
[EMA
On Apr 14, 2008, at 6:58 PM, Steve Topov wrote:
> 1.8 Meg
>
email it to me, please.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t problems on MacOSX using
SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran
PRAGMA integrity_check
using all four versions of SQLite and all return "ok".
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-
one can have a write transaction open
and one or more others can have a read transaction open, but
you cannot have two or more write transactions active at once
and all of the read transactions will need to close prior to the
write transaction committing (otherwise the writer g
ros you much
compile from canonical sources using a unix-like development
environment.
The reason for this is that SQLite includes several code files that
contain automatically generated code. And the generated code
depends on which OMIT macros are present.
D. Richard Hipp
[EMA
. Richard Hipp
[EMAIL PROTECTED]
P.S.: As I type this, two test failures have emerged in the new
release: utf16-bind-6.4 and utf16-bind-7.4. Both failures are
benign. The fault is actually in the test script, not in SQLite itself.
The test script in these cases assumes a UTF8 database and
hence
have the shell.c code.
>
> Was this intended ?
>
There are a dozen different build products in the latest release.
I'm sorry that the one you wanted is not there. Perhaps we can find
time to add it later.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-u
: [sqlite] SQLite>=3.5.6 does not open database file
>
> I am on Windows XP using sqlite 3.5.6 dll created from the source.
Why don't you try the pre-compiled DLLs off of the website.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing
It is doing a nested
> table scan instead of using the index for the left join.
>
Likely this has to do with ticket #3015.
http://www.sqlite.org/cvstrac/tktview?tn=3015
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-
id = pets.owner_id
instead if what you have. In other words, put the
table on the left side of the join before the equals
sign instead of after it.
It shouldn't make any difference. SQLite should
generate exactly the same code regardless of
whether you say A=B or B=A. Clearly something
is
ltiple pages.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
p would be appreciated
>
What value are you passing as the 4th argument to
sqlite3_open_v2()? (I assume you are using sqlite3_open_v2()
since that seems the mostly likely way to get this error.)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqli
here ORT.person_id = register.person_id
and ORT.document_id = register. document_id);
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
blank string - this would appear to be the problem!
> errorCode = sqlite3_open_v2("data/texts.db", ,
> SQLITE_OPEN_READONLY, "");
>
A null pointer (aka zero). 0. Very different from an
empty string.
D. Richard Hipp
[EMAIL PROTECTED]
mailing list if you think it would help.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious "sqlite.org" email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.
D. Richard Hipp
[EMAIL
in f.i. SQLiteSpy.
>
Perhaps: SELECT CAST(b AS TEXT) FROM table
Really I suppose it depends on what SQLiteSpy is using to
determine that the column type is BLOB. If you can subversion
that mechanism into thinking the column type is TEXT, then
it should just work.
D. Richard
uggest
you use a C compiler instead. Surely Visual Studio must
include a C compiler.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ateView referenced in function _yy_reduce
>
> Are there any workarounds for these, or will
> I have to remove the above OMIT options?
>
> Thanks,
> - Richard
> ___
> sqlite-users mailing list
> s
GMAS
the cache_size pragma is omitted. A feature of the PRAGMA
command is that unrecognized pragmas are silently ignored.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gt;>>> more
>>>>>>> than N*2 sec and dies on my SQLITE_BUSY asserts :/
>>>>>>>
>>>>>>> So, I am wondering, is there any ideas how to avoid this?
>>>>>>>
>>>>>>
>>>>>> ___
>>>>>> sqlite-users mailing list
>>>>>> sqlite-users@sqlite.org
>>>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> ___
>>>> sqlite-users mailing list
>>>> sqlite-users@sqlite.org
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>
>>>
>>>
>>> --
>>> Alexander Batyrshin aka bash
>>> bash = Biomechanica Artificial Sabotage Humanoid
>>> ___
>>>
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Alexander Batyrshin aka bash
> bash = Biomechanica Artificial Sabotage Humanoid
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
orrect? If so, what options are
> defined when it is being built? If not, how is it built?
>
> TIA
> Dennis Cote
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listin
on version 3.6.0.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mode
Before you rush out and try this on 3.5.8, please note that it is
currently only available in CVS HEAD.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
l
. The lack of a configuration file is a feature, not a bug.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
h8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_string FROM something"
> Version V8.5
>
> Why so much parentheses? A list, nested in a list, nested in a list?
> But why?
I get just {Version V8.5} when I try this.
D. Richard Hipp
[EMAIL PROTECTED]
__
On May 3, 2008, at 12:30 AM, Roger Binns wrote:
>
> I would like a #define of the current version number.
http://www.sqlite.org/c3ref/c_version.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.or
nature of binary files. I don't
think any SCM system is able to diff or merge arbitrary binary files.
There may be modules for diffing and merging specific binary files
formats (ex: DOC files) but not arbitrary binary files nor likely
SQLite database files. So take care not to fork. But
core SQLite, btw. It is
part of the CLI. You can find the code by searching for "import" in
the shell.c source file.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ERSIST mode nearly as carefully as we have the existing DELETE mode.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
orage (SD card). Has
> anyone ported
> this before to an embedded system without an OS?
>
I have doubts that you will be able to get SQLite to work on anything
less than a 32-bit processor.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-u
rrectness of the
database. In PERSIST journaling mode, you never know and you delete
the file at your peril.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 8, 2008, at 2:54 AM, C M wrote:
> How likely (or possible) is it to corrupt or in some way screw up an
> SQlite database if one is doing an UPDATE and it fails? (computer goes
> out, etc.) Thank you.\
http://www.sqlite.org/atomiccommit.html
D. Richard Hipp
[EMAIL
1 - 100 of 1539 matches
Mail list logo