to find the
offset to a particular column in that row. The fewer prior columns
there are, the less work is involved for this step.
--
D. Richard Hipp
drh at sqlite.org
https://twitter.com/john_lam/status/593837681945092096
--
D. Richard Hipp
drh at sqlite.org
ttp://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
e child process *uses* SQLite?
>
I think it is only a problem if the child process tries to use SQLite.
--
D. Richard Hipp
drh at sqlite.org
y management logic
(2) The pseudo-random number generator (PRNG)
(3) The encoder/decoder
SQLite only implements (2). It omits (1) and (3). And hence, the RC4
kernel inside of SQLite cannot be used for encryption.
--
D. Richard Hipp
drh at sqlite.org
mmap.h which is #included from
sqlite3.c.
--
D. Richard Hipp
drh at sqlite.org
ave problems with www.sqlite.org, there are mirror sites
(in different datacenters, in different cities) at www2.sqlite.org and
www3.sqlite.org.
--
D. Richard Hipp
drh at sqlite.org
k fine as
long as you do not open the same SQLite database file at the same time
in the same process using different versions of SQLite for each
connection.
--
D. Richard Hipp
drh at sqlite.org
ftColumn;
> pIdxCons[j].iTermOffset = i;
>
> Best regards.
> Carlos Tangerino
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
t;<\EOF
SELECT * FROM t1;
PRAGMA journal_mode;
.exit 1
EOF
ls -l t1.db
--
D. Richard Hipp
drh at sqlite.org
e that behavior
dates back to 3.7.6 and maybe earlier. It isn't something new.
(Testing on Ubuntu).
--
D. Richard Hipp
drh at sqlite.org
hat's true, your little script should actually
> throw an error for 3.7.6!
>
My mistake. Checked my shell history and in fact the problem goes
back to 3.7.8, not 3.7.6 as I originally reported. The point is: It
goes back a long time. This is on Ubuntu though. Maybe something
changed
edly?
>
The TEMP tables are reset by both:
PRAGMA temp_store=;
PRAGMA temp_store_directory=;
--
D. Richard Hipp
drh at sqlite.org
s that demonstrate your
problem, that will be helpful in tracking down the cause.
--
D. Richard Hipp
drh at sqlite.org
On 8/18/15, Sam Roberts wrote:
> What mechanism is used to create the temporary files?
On Unix, unlink() after open is used.
On Windows, the FILE_FLAG_DELETE_ON_CLOSE flags is used when the
temporary file is opened.
--
D. Richard Hipp
drh at sqlite.org
qlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
;
My contention remains that this is a bug in the compiler/linker.
--
D. Richard Hipp
drh at sqlite.org
dependencies is not a required feature in this
case.
--
D. Richard Hipp
drh at sqlite.org
On 8/21/15, jungle Boogie wrote:
>
> Is it possible to compile in libtclsqlite3?
>
Dunno. But you can compile the libtclsqlite3.so yourself:
make tclsqlite3.c
gcc -fPIC -shared -I. -o libtclsqlite3.so tclsqlite3.c
--
D. Richard Hipp
drh at sqlite.org
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
The on-line fix
(https://www.sqlite.org/src/artifact/24323faac?ln=3785) together with
commentary and test cases is now on trunk
(https://www.sqlite.org/src/info/351bc22fa9b5a2e5}.
On 8/21/15, Richard Hipp wrote:
> Thanks for the test case. The error seems to have been introduced by
>
that "somefunction(*)" does not expand the "*" to
a list of all columns in any other function in any other SQL database
engine, that I am aware of. That behavior is without precedent.
--
D. Richard Hipp
drh at sqlite.org
might sometimes be zero and
the compiler felt compelled to share that bit of knowledge, thinking
that we might have meant to put the zero in the penultimate parameter
(1) which is of type int.
--
D. Richard Hipp
drh at sqlite.org
s in SQLite.
See https://www.sqlite.org/src/artifact/b8fb7befd85b3a9b for an
example of how to implement table-valued functions. This is a new
feature so there is no documentation on it yet. But the example is
well-commented. This capability will be in the next release, so
you'll have to compile from trunk if you want to use it right away -
it is not found in 3.8.11.1.
--
D. Richard Hipp
drh at sqlite.org
sound advisable?
>
That depends on so many things that it is hard to say. You could
certainly try it and see how it works out! But I think if you just
avoid constantly opening and closing connections, things will go
better.
--
D. Richard Hipp
drh at sqlite.org
~12:46
> 3.8.11.1 : ~15:08
>
> I'm out of ideas here. Can someone help me with further investigation?
>
> --
> Gruesse,
> Jakub
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
SQL operations (using sqlite3_trace()) as well as
the starting state of the database and reproduce the problem by
running a log of the SQL operations against a copy of the initial
database?
--
D. Richard Hipp
drh at sqlite.org
Tcl_Alloc() always panics. See
http://core.tcl.tk/tcl/artifact/d25497d9849b8704?ln=1089 for the
implementation.
--
D. Richard Hipp
drh at sqlite.org
shouldn't be any issues - other than the
fact that you have to go to the extra trouble of compiling from
canonical sources.
--
D. Richard Hipp
drh at sqlite.org
e ignored this warning and depend on the
(unsupported) behavior of whatever version of SQLite they were
originally developed on. So the reality is that we are extremely
careful not to change the result column naming algorithms, for fear of
breaking billions of cellphone apps.
--
D. Richard Hipp
drh at sqlite.org
On 8/25/15, Tim Streater wrote:
> On 25 Aug 2015 at 19:37, Richard Hipp wrote:
>
>> On 25/8/15, Simon Slavin wrote:
>>>
>>> "If there is no AS clause then the name of the column is unspecified and
>>> may
>>> change from one r
CREATE TABLE t1(a DATETIME);
WITH RECURSIVE
c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<10)
INSERT INTO t1(a) SELECT datetime('now') FROM c;
The entire INSERT statement will be a single sqlite3_step() call, and
so all billion rows of t1 will get set to the same time.
--
D. Richard Hipp
drh at sqlite.org
On 8/26/15, Shrenik Shah wrote:
>
> We wish to use sqlite in our commercial embedded application. We would link
> our application to binary of sqlite.
>
You can do that. SQLite is in the Public Domain.
https://www.sqlite.org/copyright.html
--
D. Richard Hipp
drh at sqlite.org
plications should not use EXPLAIN or EXPLAIN QUERY PLAN since
their exact behavior is variable and only partially documented."
--
D. Richard Hipp
drh at sqlite.org
>
Clever! I was about to write back that SQLite does not provide the
capability that Dominique wants, but I think Clemens's answer is
better!
--
D. Richard Hipp
drh at sqlite.org
On 8/27/15, Scott Doctor wrote:
>
> Is FTS5 fully tested and part of the current version, or is it
> still experimental?
>
It is merged with trunk, but it is not included in a standard build.
I'd call it experimental yet.
--
D. Richard Hipp
drh at sqlite.org
ttps://www.sqlite.org/autoinc.html) since it probably does not do
what you think it does.
>
> Lev
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/l
How many indexes on your data?
Can you DROP your indexes for the insert, then CREATE INDEX them again
after all the content is in place?
--
D. Richard Hipp
drh at sqlite.org
On 12/1/15, jungle Boogie wrote:
> On 30 November 2015 at 06:27, Richard Hipp wrote:
>>> Just curious. Why does SQLite allow those? Legacy (i.e.
>>> backward-compatibility)? Valid in ANSI SQL? --DD
>>
>> I don't know if it is valid ANSI SQL or not. But SQLit
On 12/2/15, sanhua.zh wrote:
> I make a database, create a table and insert some data.
> And then delete a section of data manually using binary editor,
Did you really "delete" the data, or did you simply change the data to
have all NULL content?
--
D. Richard Hipp
drh at sqlite.org
andles TEXT and VARCHAR equally well. There are no issues.
Perhaps a 3rd-party GUI shell wrapper around SQLite is having problems
with TEXT?
--
D. Richard Hipp
drh at sqlite.org
QLite would choose ex1b
since it guesses the keys would be shorter and will compare faster and
the fanout will be greater, and hence extb can be searched using fewer
CPU cycles.
--
D. Richard Hipp
drh at sqlite.org
commit operation does not return
until all content is safely on disk.
--
D. Richard Hipp
drh at sqlite.org
S.E.E. or other
> kind), so that the application information would be transparently
> encrypted?
>
You'll have to compile in your own copy of SQLite using the JNI.
Instructions here:
http://www.sqlite.org/android/doc/trunk/www/index.wiki
--
D. Richard Hipp
drh at sqlite.org
On 12/6/15, gwenn wrote:
> Hello,
> Would you mind adding argument names in function prototypes ?
Would you mind explaining why this might be helpful?
--
D. Richard Hipp
drh at sqlite.org
ter, then simply move the database file to a workstation and
run the (dot)commands there using a shell.
--
D. Richard Hipp
drh at sqlite.org
"PRAGMA vdbe_debug=ON;" command should give you copious amounts of
debugging information on standard output. Does it not?
You did you manage to implement new UDFs if you are not a C programmer?
--
D. Richard Hipp
drh at sqlite.org
in a GUI on Windows.
--
D. Richard Hipp
drh at sqlite.org
is
"undocumented". SQLite nor any other SQL database engine is obligated
to provide the behavior you want. It happens as you like purely by
chance. Do not depend on this behavior since it might change at any
moment, without warning.
--
D. Richard Hipp
drh at sqlite.org
> parsed once if it is involved in json1 functions? For example:
>
No. The JSON parsing turned out to be so fast that such optimizations
didn't seem worth the effort. Of course, things might change in the
future.
--
D. Richard Hipp
drh at sqlite.org
y=y+100;
SELECT rowid, y FROM t2;
} x {unset -nocomplain x(*); puts [array get x]}
puts "***"
db2 eval {
SELECT rowid, y FROM t2;
} x {unset -nocomplain x(*); puts [array get x]}
db close
db2 close
--
D. Richard Hipp
drh at sqlite.org
On 12/10/15, jungle Boogie wrote:
>
> Updating to trunk this morning results in this failure when attempting to
> build:
>
Should be fixed now. Please try again.
--
D. Richard Hipp
drh at sqlite.org
write up a
tutorial. I'll try to get that done before the end of the year...
--
D. Richard Hipp
drh at sqlite.org
use of grave accents to quote column names is a
mysql-ism. SQLite also supports that for compatibility. But you
still shouldn't do it. The proper SQL-standard way is double-quote.
--
D. Richard Hipp
drh at sqlite.org
Doing so still gives a correct
answer, but it wastes space and CPU cycles.
--
D. Richard Hipp
drh at sqlite.org
tually
measuring that it presents performance problems) because premature
optimization is the root of all evil
(http://c2.com/cgi/wiki?PrematureOptimization).
--
D. Richard Hipp
drh at sqlite.org
itoring an inbound flight on flightaware
when this issue report arrived in my inbox. :-)
--
D. Richard Hipp
drh at sqlite.org
f the programming is not ideal.
>
> which one is faster?
> Is the efficiency between the two methods great?
>
I think both methods are about the same speed. Have you measured a
difference between them? They both do about the same amount of work,
I think.
--
D. Richard Hipp
drh at sqlite.org
On 12/15/15, ??? <2004wqg2008 at 163.com> wrote:
>I mean only compare the two ways of get the database handl.
> 1.sqlite3_open
> 2.ATTACH DATABASE
I think they both do about the same amount of work.
--
D. Richard Hipp
drh at sqlite.org
On 12/16/15, Janto Ranjan Paul wrote:
>
> Hi All,
>
> From last couple of days, I am trying to port Sqlite-3.10 database into
> Vxworks...
The latest release version of SQLite is 3.9.2. Are you using
unreleased code from trunk?
--
D. Richard Hipp
drh at sqlite.org
atch the timeline (https://www.sqlite.org/src/timeline)
for a simple fix which will likely be added later this morning.
--
D. Richard Hipp
drh at sqlite.org
ate from me. For that matter, I was never consulted about
them. None of them represent real vulnerabilities, in my assessment.
All of the problems identified have been fixed for a long time.
I think that these reports achieve nothing beyond vulnerability
fatigue. I think it is shameful that nv
pplication will render the mmap_size mote - it won't matter.
--
D. Richard Hipp
drh at sqlite.org
hen using ZIPVFS, the "PRAGMA mmap_size=NNN" command is
a no-op.
--
D. Richard Hipp
drh at sqlite.org
tly delete the message
> and any attachments. Thank you
>
>
> _______
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
in this public forum.
--
D. Richard Hipp
drh at sqlite.org
e3_msize().
(3) If you use sqlite3_mprintf(), then sqlite3_free() must be used to
release the string once you are done with it.
Otherwise, there is no real advantage to using SQLite memory allocator
interface in place of your standards system memory allocator.
--
D. Richard Hipp
drh at sqlite.org
s own private copy of the string.
--
D. Richard Hipp
drh at sqlite.org
blem is more acute for dropping a column - what
do you do then, change each reference to NULL?
--
D. Richard Hipp
drh at sqlite.org
bytes." ?
>
Thanks. Typo fixed at
https://www.sqlite.org/docsrc/info/1cc43dde6cdc5642 and the website
has been updated.
--
D. Richard Hipp
drh at sqlite.org
to do a single scan through the entire database file, reading each
page only once, and without doing a lot of seeking. It can therefore
be a lot faster.
--
D. Richard Hipp
drh at sqlite.org
tml !
>
> And there is one such link there on that page.
>
> JSON SQL FunctionsSQL functions for creating, parsing, and
> querying JSON
> content.
>
That link was added after Domingo sent in his suggestion
--
D. Richard Hipp
drh at sqlite.org
e date/times instead of
just second resolution. But the unix-time format is more familar to
many programmers, and can be stored in 4 bytes instead of 8.
--
D. Richard Hipp
drh at sqlite.org
-U 8" option, to include
more context.
--
D. Richard Hipp
drh at sqlite.org
Please test the alternative patch found at
https://www.sqlite.org/src/info/a0a08b8c0bbd4d71 and let me know
whether or not the alternative patch fixes your problem.
On 12/30/15, Quan Yong Zhai wrote:
>>From: Richard Hipp
>>Sent: 2015?12?30? 20:21
>>To: SQLite mailing list
>
On 12/30/15, Roland Martin wrote:
> Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries do not
> work if case does not match.
Please test and let us know if the
https://www.sqlite.org/src/info/0a99a8c4facf65ec check-in fixes your
problem.
--
D. Richard Hipp
drh at sqlite.org
assert( pc + info.nSize - 4 <= usableSize );
> 9166 pgnoOvfl = get4byte([info.nSize - 4]);
>
> _______
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
On 12/30/15, Richard Hipp wrote:
>
> I'll continue look for an alternative way to make the intent of the
> code clearer.
>
See https://www.sqlite.org/src/info/1541607d458069f5 for another
attempt at removing magic numbers. But I don't like it. It seems to
complicate more than it cl
On 2/13/15, Mayank Kumar (mayankum) wrote:
> when we
> do a rsync, does it make sense to copy the journal file
Yes, yes. Emphatically, Yes.
--
D. Richard Hipp
drh at sqlite.org
some other
reasonable number of milliseconds) shortly after opening the database
connection will likely cure your problem.
https://www.sqlite.org/pragma.html#pragma_busy_timeout
You might also want to consider switching to WAL mode
(https://www.sqlite.org/wal.html) for its greater concurrency.
--
D. Richard Hipp
drh at sqlite.org
;focus group", and provide feedback, comments,
suggestions, and/or criticism about the revised document. Send your
remarks back to this mailing list, or directly to me at the email in
the signature.
Thank you for your help.
--
D. Richard Hipp
drh at sqlite.org
above the break. See:
>>
>> https://www.sqlite.org/whentouse.html
>>
>> Please be my "focus group", and provide feedback, comments,
>> suggestions, and/or criticism about the revised document. Send your
>> remarks back to th
database file, make sure every other
process closes that database file first.
--
D. Richard Hipp
drh at sqlite.org
D. Richard Hipp
drh at sqlite.org
a lot of redesign!
>
And, there would likely be a performance hit.
--
D. Richard Hipp
drh at sqlite.org
scratch the next
time SQLite boots up anyhow. Only the -wal needs to be preserved
after a crash.
--
D. Richard Hipp
drh at sqlite.org
On 2/19/15, Donald Shepherd wrote:
> Is there a way to get (not set) the current value of busy_timeout when
> using an SQLite version older than 3.7.15 and the addition of "PRAGMA
> busy_timeout;"?
>
You can add a hack to the code. But other than that, no.
--
D. Richard Hipp
drh at sqlite.org
On 2/19/15, Simon Slavin wrote:
>
> On 20 Feb 2015, at 12:08am, Richard Hipp wrote:
>
>> You can add a hack to the code. But other than that, no.
>
> Given that so many PRAGMAs have a way to find out the current setting, could
> this be added without too much extra cod
.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
condition inside the first join, the query
> works OK.
> The same happens on Windows Phone using sqlite.net.
> Any suggestions would be appreciated...
> Thanks in advance,
> Grisha.
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
t;
I get \r\n in CSV output from the command-line shell in SQLite 3.8.8.x
when I try it on Linux.
--
D. Richard Hipp
drh at sqlite.org
___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
On 2/25/15, Igor Tandetnik wrote:
>
> Why both are needed, I'm not sure.
>
Historical accident
--
D. Richard Hipp
drh at sqlite.org
> AE ka ? ?
>>> AE km ??
>>> AE kn ???
>>> AE ko ?? ??
>>> AE lo
>>> AE lt Jungtiniai Arab? Emyratai
>>>
>>> So, it lo
On 7/6/15, Zsb?n Ambrus wrote:
> On Thu, Jun 18, 2015 at 4:34 PM, Richard Hipp wrote:
>> Thanks for the bug report. The problem is now fixed on trunk.
>>
>> On 6/18/15, Jean Chevalier wrote:
>>> The likelihood() function, which should help select a query plan but
a more recent version of
SQLite?
--
D. Richard Hipp
drh at sqlite.org
ooting the problem, since he is an expert at both
python and SQLite and is likely to get to the bottom of the matter
faster than any of the core SQLite devs.
--
D. Richard Hipp
drh at sqlite.org
nsumer gadgets that you can buy off-the-shelf
today (in blister packs) that contain an instance of SQLite that talks
directly to flash memory - essentially using SQLite as the filesystem.
I think Shuhrat is just trying to do this again.
--
D. Richard Hipp
drh at sqlite.org
tion? A
> paper, a book? In the simplest form I will use URL.
>
I think just the URL: https://www.sqlite.org/
If possible, please provide a link to your paper when it becomes available. :-)
--
D. Richard Hipp
drh at sqlite.org
201 - 300 of 6136 matches
Mail list logo