about the BETWEEN operator. How about this:
WHERE birth BETWEEN date('now','-24 years') AND date('now','-12
years')
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
r...@macscripter.net
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
't solve the problem.
It means the index is corrupt. Try running "REINDEX".
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and ready for production use.
Please let me know if you encounter any problems.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
abase file onto the
device, your copy utility corrupted the database file (again, possibly
by \r to \r\n translation) (3) your compiler somehow thinks that
sizeof(char)!=1.
There might be other causes, but those are the ones that come to mind.
> CLOSE 16
D. Richard H
;
> cheers,
> Stef
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://s
e and maintain a private branch of SQLite. See
> http://www.sqlite.org/privatebranch.html
> for further discussion.
>
> (5) In our experience, Fossil works better than CVS over slow and/or
> unreliable networks. And, Fossil allows users behind res
Can you suggest better ways of organizing the
documentation above?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is no
network traffic with "fossil diff").
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
We are on schedule to release SQLite version 3.6.18 on Monday,
2009-09-14. For a preview, see
http://www.sqlite.org/draft/index.html
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
s of code shown above.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sep 3, 2009, at 8:25 PM, Mark Spiegel wrote:
> D. Richard Hipp wrote:
>> You are both right and both wrong. There are two different integer
>> representations used in SQLite.
>>
>> (1) "varint" or variable length integer is an encoding of 64-bit
>>
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e
= is coerced into a 1. See section 3 "Comparison Expressions" of the
same document: http://www.sqlite.org/datatype3.html
This all seems really complicated. But we did it that way because it
causes SQLite to mimic the behavior of other statically typed database
engines (ex: MySQL, PostgreSQL, Oracle, etc.) and hence maximizes
compatibility.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
not contain such a claim coming from
someone who does not understand how SQLite3 works.
I think if you try my do-over suggestion you will find the people here
will be nice, friendly, and much, much more helpful.
D. Richard Hipp
d...@hwaci.com
___
On Sep 2, 2009, at 9:46 AM, D. Richard Hipp wrote:
>>>
>>> It worked for me before. No idea what is happenning.
>> Can you please send me your env?
>
>
sqlite-imac:bld drh$ ./sqlite3
SQLite version 3.6.17
Enter ".help" for instructions
Enter SQL stateme
On Sep 2, 2009, at 9:39 AM, Alberto Simões wrote:
Hello, drh.
On Wed, Sep 2, 2009 at 2:28 PM, D. Richard Hipp <d...@hwaci.com> wrote:
Works for me:
sqlite-imac:bld drh$ ./sqlite3
SQLite version 3.6.17
Enter ".help" for instructions
Enter SQL statements terminated w
Works for me:
sqlite-imac:bld drh$ ./sqlite3
SQLite version 3.6.17
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t1(x);
sqlite> insert into t1 values('Alberto Simões ξ € 夷');
sqlite> select * from t1;
Alberto
ows where Field='3' and different rows where
Field=3 and SQLite will distinguish between them.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 31, 2009, at 11:07 AM, Kalle Last wrote:
> 2009/8/31 D. Richard Hipp <d...@hwaci.com>:
>>
>> On Aug 31, 2009, at 10:28 AM, Kalle Last wrote:
>>
>>> Hello,
>>>
>>> I'm having a big performance problem while trying to use sqlite as a
ase? I think the migration command is:
>
> echo '.dump' | sqlite3 $db | sqlite3 $dbnew
>
> Maybe the internal database structure has changed?
The file-format is unchanged.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlit
?
Chim is using a version of SQLite that is over 5 years old. The
behavior he describes is not present in any recent version of SQLite,
at least not as far as anyone is aware.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sq
conveniently
packaged in a tarball on the download page):
sqlite3.c
sqlite3.h
shell.c
Then run:
gcc -static -o sqlite3 -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl
Then move the resulting stand-alone, dependency-free executable
"sqlite3" to someplace on your $PATH.
D.
now'));
>
Put parentheses around the strftime() function call:
CREATE TABLE info(..., stamp DEFAULT (strftime('%f','now')))
The extra parentheses are needed to avoid a parsing ambiguity in the
SQL language.
D. Richard Hipp
d...@hwaci.com
___
sqlite-
tandard". The standard is
defined here: http://en.wikipedia.org/wiki/ISO_8601
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 21, 2009, at 2:49 PM, Shaun Seckman (Firaxis) wrote:
> This is great! Exactly what I was looking for. Do you by any chance
> know the function name of the standard collation used for string
> comparisons? I'd like to use that as a foundation for building a new
> one.
>
/*
** This is
time that can
> be
> shaved off will be noticed.
The entire key will be read into memory regardless. The extra time
spent in memcmp() bypassing a common prefix is likely to be
unmeasurable.
D. Richard Hipp
d...@hwaci.com
___
sqlite-use
s a
simple column value. If x is an expensive subquery of some kind, it
could make a difference since with BETWEEN x is only evaluated once,
whereas it would be evaluated twice for "x>=y AND x<=z". Other than
the number of times that x is evaluated, there is no difference in
On Aug 16, 2009, at 11:18 PM, Mohammad Reaz Uddin wrote:
> can you please tell me how can i get a debuggable executable file? i
> have
> sqlite3.c(the single monolithic file) and sqlite3.h
gcc -o sqlite3 -g -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl
D. Richard Hipp
d...@
I can't find it anywhere.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 13, 2009, at 5:30 AM, Otto Grunewald wrote:
> Hello,
> The following is what my code looks like :
> sqlite3 *db_handle;
> char* errmsg;
> char cStr(255);
>
> sqlite3_open(_handle);
>
sqlite3_open() takes two parameters. Did you make a mistake in
transcribing
twos
complement integer is 9223372036854775807.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 11, 2009, at 4:28 PM, Mark Richards wrote:
> D. Richard Hipp , On 8/11/2009 16:02:
>>
>> Perhaps pthreads is going goofy. Please recompile with -
>> DSQLITE_THREADSAFE=0 and see if that helps.
>>
> BINGO.
>
> env CC="gcc-cris -mlinux -isystem $
ith stdin or stdout.
We've done things like this before. We know it works.
Perhaps pthreads is going goofy. Please recompile with -
DSQLITE_THREADSAFE=0 and see if that helps.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-user
flags = 0;
> fcntl(fd[0], F_SETFL, flags | O_NONBLOCK);
>
> .. within a loop:
>
> got=read(fd[0], buf, sizeof(buf));
> if (got>-1)
> {
> snprintf(cValue,4,"%s",buf);
> break;
> }
> // got ==-1
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng the
>> amalgamation tarball.
>
> The TEA tarball is apparently affected in the same way, and doesn't
> seem to
> have been updated.
Does it need to be? Does anybody every define SQLITE_API to anything
other than nothing on a TEA build?
D. Richard Hipp
d...@hwaci.com
e present fix
is to do "make clean; make sqlite3.c" before rebuilding the
amalgamation tarball.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
characters. sqlite3_strnicmp() is intended for use by
extensions.
As always, please let us know if you encounter any problems.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
ernal representation of the index layout."
>
> Does this mean that all of the indices are regenerated when the
> database is opened, or is the index stored and this is just
> confirming the structure?
The latter. The index content is stored and the layout is confirmed
ea
sqlite3_vfs_register() to install your alternative OS driver.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n contained in this electronic mail transmission
> may be privileged and confidential, and therefore, protected
> from disclosure. If you have received this communication in
> error, please notify us immediately by replying to this
> message and deleting it from your computer without copyin
egards,
>
> Noah Hart
>
> --
> View this message in context:
> http://www.nabble.com/Pros-and-cons-of-various-online-code-sharing-sites-tp24413069p24413069.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _________
The documentation never says you cannot use
SQLITE_ENABLE_UPDATE_DELETE_LIMIT with the amalgamation, but it
should, since SQLITE_ENABLE_ is really just SQLITE_OMIT_ with the
default behavior inverted, and so SQLITE_ENABLE_ will not work with
the amalgamation for exactly the same reason that SQLITE_OMI
REATE TEMP TABLE xyz AS SELECT * FROM table1 WHERE;
SELECT * FROM xyz; -- make changes to table1 as xyz is read
DROP TEMP TABLE xyz;
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e it gives up
and quits. This is not a promise, but I do not think 2 errors are
likely to exceed 255 characters in length.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or sqlite releases ?
There is the sqlite-annou...@sqlite.org mailing list. Much lower
traffic - basically just announcements of releases.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailm
if you encounter any problems with the
new 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
LITE_OK) {
> printf("Recieved an sqlite failure. : Failed msg: %s",
> errmsg);
> sqlite3_free(errmsg);
> }
> else
> printf("Successfully inserted row idx %d\r\n", idx);
On Jun 26, 2009, at 12:22 PM, D. Richard Hipp wrote:
>
> On Jun 26, 2009, at 12:13 PM, Shaun Seckman (Firaxis) wrote:
>
>> I have a column ("ID") in a table that is the primary key integer
>> so it
>> should be an alias for ROWID. Is it safe to have a R
9223372036854775807, inclusive of both ends and of zero. And, yes,
the boundary values are tested in the test suite.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 25, 2009, at 5:07 PM, Ben Atkinson wrote:
>
> On Jun 25, 2009, at 4:27 PM, D. Richard Hipp wrote:
>
>> What are you trying to install? The command-line shell? A shared
>> library? If the latter, why do you need or want a shared library on
>> your
o install? The command-line shell? A shared
library? If the latter, why do you need or want a shared library on
your embedded system. Are aware that the command-line shell is a
single stand-alone binary with no dependencies other than libc?
Are you using the amalgamatio
grows.
Did you mean to say "logarithmically" where you wrote "exponentially"?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ery quickly figure out that they should exit without doing
>> anything.
>>
>>
> strangely, it didn't helped, time is almost the same with not exists
> or with
> your idea. actually with function its even a little bit worse
>
Are you reparsing every
that they should exit without doing
anything.
>
>
>
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OMIT_TRACE. If I compile with this
> defined, it crashes.
http://www.sqlite.org/cvstrac/chngview?cn=6784
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 23, 2009, at 9:49 AM, D. Richard Hipp wrote:
>
> On Jun 23, 2009, at 3:16 AM, Andrea Galeazzi wrote:
>
>> Any news about this problem?
>
> http://www.sqlite.org/cvstrac/tktview?tn=3929
We will strive to release SQLite version 3.6.16 on or about 2009-07-01
00:0
ng is that the
> trigger doesn't even use the index; the two should not relate at
> all. Is this a known problem, a bug, or am I just doing something
> wrong?
>
> best Regards,
> David
> ___________
t; troubles. So I don't thing it's a compiler issue.
> Did you make the test with windows console? Have I send you the
> database again?
> Thanks for your helpfulness!
>
>
>
>> Citando "D. Richard Hipp" <d...@hwaci.com>:
>>
>>
>>> On Ju
t;
> __
> GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://movieflat.web.de
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us
FTER trigger and it
will work.
>
> The ids in table a are as expected (1 & 2).
>
>
> __
> GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://movieflat.web.de
>
> __
On Jun 18, 2009, at 12:36 PM, galea...@korg.it wrote:
> This statement is giving me truoble:
> INSERT INTO PlayList_Song(id_song, id_playlist, song_number) VALUES
> (5235, 9, 256)
That INSERT statement works fine for me.
Did you try recompiling with optimizations turned off?
D. Ric
query, specifically, is giving you trouble?
Also: We sometimes run into compiler bugs. Please try recompiling
with optimization disabled and see if that clears the problem. If it
does, that suggests the problem is in your compiler.
D. Richard Hipp
d...@hwa
I lack the
KORGCOLLATE collating function. So maybe the problem is in one of
your indices. Have you tried running REINDEX?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/li
On Jun 18, 2009, at 11:01 AM, galea...@korg.it wrote:
> I run "PRAGMA integrity_check" using version 3.6.14 at the end of the
> code and it executed a query with only one row "ok", so where do I
> have to send the databbase?
d...@sqlite.org
>
> Than
t, then it eventually gives up and
returns SQLITE_SCHEMA.
> Manohar
>
> --
> hope is the only thing which keeps us all happy
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sql
I would also need.
>
> Additionally, since asynchronous i/o seems to sit apart from the
> main sqlite3, I was wondering if it would be possible to use with an
> older (3.5.9) version of sqlite3 that we already use in house.
D. Richard Hipp
d...@hwaci.com
_
ong (id)
> ON DELETE CASCADE
> ON UPDATE CASCADE,
> CONSTRAINT fk_PlayList_Song2 FOREIGN KEY (id_playlist)
> REFERENCES PlayList (id)
> ON DELETE CASCADE
> ON UPDATE CASCADE);
>
> CREATE INDEX PlayList_Song_song_number_idx ON
> PlayList_Song(song_
database. Open with sqlite3_open(":memory:",
). Or if your content is too big for memory, use a temporary
database whose name is the empty string: sqlite3_open("", ).
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
is ignored. That used
to be the case. I don't know if it still is.
Note that this does *not* control your operating systems file cache.
This is SQLite's user-space cache only.
If more pages than the cache allotment are required, the the cache
size
he bug was in 3.5.4. It should never have accepted the double-quoted
string as a default value. SQL always uses single quotes for string
literals.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
manually and edit sql ,make changes so that everything
>> works fine.
>>
What do you have to manually edit to make it work. Please show us the
text before and after you edit.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing lis
6.15 should be able to read and write any SQLite
database back through version 3.0.0. If you find an instance where
this is not the case, then that is a bug. Please report it.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite
es. But if you do
CREATE TABLE t2 AS SELECT * FROM mytable;
Then the reported datatypes for t2 will be INT and TEXT.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
be properly quoted so that it
could be parsed again. The logic that did this quoting was complex
and contained bugs. It was much easier to strip out the whole thing
and replace it with primitive datatype generator (that inserts "NUM"
in place of the complex string show above) t
sqlite?
> That would include the memory for page cache , any other other
> internal
> memory used the sqlite ,as well as the memory for database itself.
> Thanks
> for your help.
http://www.sqlite.org/c3ref/memory_highwater.html
http://www.sqlite.org/malloc.
hat there are significant changes
between SQLite 2.x and SQLite 3.x so porting, while not overly
difficult, will also not be trivial.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
thout a
very good reason (such as the number is too large to represent as an
integer, or there was an explicit cast). Unless, of course, you are
using a really, really old version of SQLite, like version 2.8 or
something.
Can you provide a test case that shows an integer being c
t.mk
> 2. sqllogictest.h
> 3. sqllogictest.c
>
>
> - How can I install it?
> - Just to migrate the files to which folder?
>
> Thanks for your help.
>
> Tsachi Ofir
> ___
> sqlite-users mailing list
> sqlite-user
de file together with the actual code.
Either run "strip" on the file first (to remove the extraneous
information) or measure the size using the "size" command.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@s
was
approximately linear. What about situations where you have a 4- or 5-
way join on tables that are not indexed? Do other database engines
handle those more efficiently than SQLite somehow? Is this something
we need to look into?
D. Richard Hipp
d...@hwaci.com
is falling
>> and
>> why the problem is not being reported back up to the top level.
>
> How would I run a single test?
You can't. You have to run an entire test script. Skip over the
breakpoints prior to the point of interest.
gdb testfixture
br sqlite3Fault
D one wo]
> Got: [AND one woe]
>
> Thanks,
>
> Nico
> --
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
_
ehaviour and should users update
> their SQL accordingly?
This query makes sense because now the GROUP BY is against a column in
the table that is being queried. And so one would expect this to work.
Have you tried these two queries on other SQL database engines besides
SQLite? What do PostgreS
On May 28, 2009, at 8:43 AM, Oza, Hiral_Dineshbhai wrote:
>
> Can you please let me know meaning of 'Cell' in Btrees used in
> sqlite3.
See line 43 of the btreeInt.h source file for the definition. You
will want to read the previous 42 lines of that same file for context.
D. Richa
roup by t_outer.c)
> from t t_outer;
>
This query does not make any sense. What are you trying to do?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
at I expected because I deliberately coded it
that way. Once you us an AS clause, the table is thereafter known
only by its AS name, not its original name.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
canned in order to output rows in order by
b. Finally, the c value is pulled directly from the index, avoiding a
lookup of the original table.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/
signed or
unsigned? Just cast the result to whatever you need and it will work.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nge, then this
> is the explanation why I see so much slower speed.
Your OS and filesystem configuration have a big impact too. I've
notice, for example, that transactions are really slow on RieserFS on
linux compared to Ext3. What OS are you using? And what filesystem?
D. Richard Hipp
t; sqlite> ^Z
>
> This seems very much a corner case and I don't imagine this is a
> problem
> in practice; any concern about this number being when it is too high
> for
> the software opening the file, and as far as I can guess there is no
> "too low"
ces. This was
seen as undesirable. FTS3 strives to give much better worst-case
insertion times by doing index merges incrementally and spreading the
cost of index merges across many inserts.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sq
the kinds
of queries that might hit this bug. For that reason, we have done an
unscheduled patch release to fix the problem.
The bug that is fixed was introduced in version 3.6.14. So upgrading
is recommended for users of versions 3.6.14 and 3.6.14.1.
D. Richard Hipp
d...@hwaci.com
are making these fixes available in this unscheduled version
3.6.14.1 release.
As always, please let me know if you encounter any difficulties.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
table1 BEGIN
SELECT do_something_using_c_code();
END;
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 18, 2009, at 2:18 PM, Mitchell L Model wrote:
> Is it really possible to have a SELECT with no FROM? If so, could
> someone provide an example; i
SELECT sqlite_version();
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
John.
The changes within an SQLite transaction are not visible to other
database connections until the transaction commits. (However, they
are visible within the same database connection.)
An exception to the previous paragraph is if you are using shared
cache mode and you do a PRAGMA read_unco
above code is omitted and you should not get any extra process table
entries.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
hema or else the SQLITE_SEQUENCE table does not exist.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-journal file, I thried to open the
> database,
> but got an error with every SELECT. On sqlite.org is written, that the
> database should repair itself on next open, but that seems not to work
> every time.
Is the journal file readable? Is it empty?
> Now me question to this
201 - 300 of 1539 matches
Mail list logo