[sqlite] Does column order matter for performance?

2015-04-30 Thread Richard Hipp
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

[sqlite] SQLite using internally by Windows 10

2015-05-01 Thread Richard Hipp
https://twitter.com/john_lam/status/593837681945092096 -- D. Richard Hipp drh at sqlite.org

[sqlite] insert use sqlite3_step function return SQLITE_ROWS not return SQLITE_DONE

2015-08-10 Thread Richard Hipp
ttp://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite, fork(), and exec()

2015-08-10 Thread Richard Hipp
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

[sqlite] Lawyers, encryption, and RC4

2015-08-11 Thread Richard Hipp
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

[sqlite] setup C code with cppunit using test db

2015-08-11 Thread Richard Hipp
mmap.h which is #included from sqlite3.c. -- D. Richard Hipp drh at sqlite.org

[sqlite] Site unavailable.

2015-08-11 Thread Richard Hipp
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

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Richard Hipp
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

[sqlite] Logically dead code in function sqlite3_index_info

2015-08-15 Thread Richard Hipp
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] journal files not always removed

2015-08-15 Thread Richard Hipp
___ > 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] journal files not always removed

2015-08-15 Thread Richard Hipp
t;<\EOF SELECT * FROM t1; PRAGMA journal_mode; .exit 1 EOF ls -l t1.db -- D. Richard Hipp drh at sqlite.org

[sqlite] journal files not always removed

2015-08-15 Thread Richard Hipp
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

[sqlite] journal files not always removed

2015-08-15 Thread Richard Hipp
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

[sqlite] Temporary table unexpectedly disappears

2015-08-17 Thread Richard Hipp
edly? > The TEMP tables are reset by both: PRAGMA temp_store=; PRAGMA temp_store_directory=; -- D. Richard Hipp drh at sqlite.org

[sqlite] Boolean constraint regression between 3.7.7.1 and 3.8.6?

2015-08-17 Thread Richard Hipp
s that demonstrate your problem, that will be helpful in tracking down the cause. -- D. Richard Hipp drh at sqlite.org

[sqlite] do temporary on-disk databases get cleaned up on abnormal process termination?

2015-08-19 Thread Richard Hipp
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

[sqlite] Compile warnings

2015-08-20 Thread Richard Hipp
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

[sqlite] Compile warnings

2015-08-20 Thread Richard Hipp
; My contention remains that this is a bug in the compiler/linker. -- D. Richard Hipp drh at sqlite.org

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

2015-08-21 Thread Richard Hipp
dependencies is not a required feature in this case. -- D. Richard Hipp drh at sqlite.org

[sqlite] libtclsqlite3 assistance

2015-08-21 Thread Richard Hipp
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] BUG: sqlite 3.8.11.x left join

2015-08-21 Thread Richard Hipp
> sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] BUG: sqlite 3.8.11.x left join

2015-08-21 Thread Richard Hipp
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 >

[sqlite] There is any reason to sqlite not expand "*" in function calls ?

2015-08-22 Thread Richard Hipp
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

[sqlite] Compile warnings

2015-08-22 Thread Richard Hipp
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

[sqlite] Lua inside SQLite

2015-08-23 Thread Richard Hipp
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

[sqlite] Threading-mode for an encrypted database

2015-08-24 Thread Richard Hipp
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

[sqlite] Performance problems on windows

2015-08-24 Thread Richard Hipp
~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

[sqlite] Performance problems on windows

2015-08-25 Thread Richard Hipp
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

[sqlite] Potential for Segmentation Violation/Fault in sqlite 3.8.11.1

2015-08-25 Thread Richard Hipp
Tcl_Alloc() always panics. See http://core.tcl.tk/tcl/artifact/d25497d9849b8704?ln=1089 for the implementation. -- D. Richard Hipp drh at sqlite.org

[sqlite] Enable SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default

2015-08-25 Thread Richard Hipp
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

[sqlite] Why sqlite show qualified column names when selecting from views ?

2015-08-25 Thread Richard Hipp
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

[sqlite] Why sqlite show qualified column names when selecting from views ?

2015-08-25 Thread Richard Hipp
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

[sqlite] order by not working in combination with random()

2015-08-26 Thread Richard Hipp
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

[sqlite] Use of sqlite in commercial application

2015-08-26 Thread Richard Hipp
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

[sqlite] explain plan change between SQLite 3.8.3.1 and 3.8.11.1

2015-08-27 Thread Richard Hipp
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

[sqlite] explain plan change between SQLite 3.8.3.1 and 3.8.11.1

2015-08-27 Thread Richard Hipp
> 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

[sqlite] FTS5

2015-08-27 Thread Richard Hipp
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

[sqlite] autoincrement field

2015-08-27 Thread Richard Hipp
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

[sqlite] Insertion into the large DB drastically slows down at some point

2015-08-27 Thread Richard Hipp
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

[sqlite] SQLDIFF problem

2015-12-01 Thread Richard Hipp
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

[sqlite] Why Corrupted DB File Cause No Error?

2015-12-02 Thread Richard Hipp
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

[sqlite] TEXT columns with Excel/VBA

2015-12-02 Thread Richard Hipp
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

[sqlite] TEXT columns with Excel/VBA

2015-12-02 Thread Richard Hipp
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

[sqlite] SQLite - Support for VSS writer

2015-12-03 Thread Richard Hipp
commit operation does not return until all content is safely on disk. -- D. Richard Hipp drh at sqlite.org

[sqlite] PhoneGap with SQLite Encryption Extension?

2015-12-04 Thread Richard Hipp
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

[sqlite] Name the arguments in the prototypes.

2015-12-06 Thread Richard Hipp
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

[sqlite] Exporting

2015-12-06 Thread Richard Hipp
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

[sqlite] How to see SQLite debugging information

2015-12-08 Thread Richard Hipp
"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

[sqlite] How to see SQLite debugging information

2015-12-08 Thread Richard Hipp
in a GUI on Windows. -- D. Richard Hipp drh at sqlite.org

[sqlite] INSERT OR IGNORE consuming too many rowids

2015-12-09 Thread Richard Hipp
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

[sqlite] JSON1 detecting if a path exists vs. json null value

2015-12-09 Thread Richard Hipp
> 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

[sqlite] Obscure peculiarity with 3.9.2

2015-12-09 Thread Richard Hipp
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

[sqlite] build failure: undeclared identifier 'uintptr_h'

2015-12-10 Thread Richard Hipp
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

[sqlite] Problem with accumulating decimal values

2015-12-11 Thread Richard Hipp
write up a tutorial. I'll try to get that done before the end of the year... -- D. Richard Hipp drh at sqlite.org

[sqlite] Putting an index on a boolean

2015-12-12 Thread Richard Hipp
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

[sqlite] Integrity check with a SQL command

2015-12-12 Thread Richard Hipp
Doing so still gives a correct answer, but it wastes space and CPU cycles. -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite3_free needed when calling sqlite3_result_text ?

2015-12-15 Thread Richard Hipp
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

[sqlite] bug when columns are missing in embedded subselect

2015-12-15 Thread Richard Hipp
itoring an inbound flight on flightaware when this issue report arrived in my inbox. :-) -- D. Richard Hipp drh at sqlite.org

[sqlite] about attach database

2015-12-15 Thread Richard Hipp
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

[sqlite] about attach database

2015-12-15 Thread Richard Hipp
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

[sqlite] Porting SQLITE-3.10 into VxWorks-6.9

2015-12-16 Thread Richard Hipp
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

[sqlite] sqlite3.c:89394: int sqlite3ExprCompare(Expr *, Expr *, int): Assertion `0' failed.

2015-12-21 Thread Richard Hipp
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

[sqlite] SQLite Vulnerabilities reported in NVD

2015-12-22 Thread Richard Hipp
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

[sqlite] about compile configure

2015-12-22 Thread Richard Hipp
pplication will render the mmap_size mote - it won't matter. -- D. Richard Hipp drh at sqlite.org

[sqlite] about compile configure

2015-12-22 Thread Richard Hipp
hen using ZIPVFS, the "PRAGMA mmap_size=NNN" command is a no-op. -- D. Richard Hipp drh at sqlite.org

[sqlite] Query Regarding Shared Cache

2015-12-23 Thread Richard Hipp
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

[sqlite] In the case of ZIPVFS

2015-12-23 Thread Richard Hipp
in this public forum. -- D. Richard Hipp drh at sqlite.org

[sqlite] Malloc getting segmentation fault in sqlite

2015-12-24 Thread Richard Hipp
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

[sqlite] Malloc getting segmentation fault in sqlite

2015-12-24 Thread Richard Hipp
s own private copy of the string. -- D. Richard Hipp drh at sqlite.org

[sqlite] whish list for 2016

2015-12-24 Thread Richard Hipp
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

[sqlite] Maybe a typo in documentation...

2015-12-27 Thread Richard Hipp
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

[sqlite] whish list for 2016

2015-12-28 Thread Richard Hipp
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

[sqlite] JSON1 Extension should appear on top level doc page

2015-12-28 Thread Richard Hipp
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

[sqlite] Date as integer

2015-12-29 Thread Richard Hipp
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

[sqlite] A small patch for the SQLite shell in windows.

2015-12-30 Thread Richard Hipp
-U 8" option, to include more context. -- D. Richard Hipp drh at sqlite.org

[sqlite] A small patch for the SQLite shell in windows.

2015-12-30 Thread Richard Hipp
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 >

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread Richard Hipp
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

[sqlite] Magic number in sqlite source code

2015-12-30 Thread Richard Hipp
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

[sqlite] Magic number in sqlite source code

2015-12-30 Thread Richard Hipp
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

[sqlite] sqlite journal file question

2015-02-13 Thread Richard Hipp
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

[sqlite] Waiting on RESERVED locks

2015-02-17 Thread Richard Hipp
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

[sqlite] Appropriate Uses For SQLite

2015-02-18 Thread Richard Hipp
;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

[sqlite] Appropriate Uses For SQLite

2015-02-18 Thread Richard Hipp
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

[sqlite] Error 1032: SQLITE_READONLY_DBMOVED with one writer and one reader process

2015-02-18 Thread Richard Hipp
database file, make sure every other process closes that database file first. -- D. Richard Hipp drh at sqlite.org

[sqlite] Appropriate Uses For SQLite

2015-02-18 Thread Richard Hipp
D. Richard Hipp drh at sqlite.org

[sqlite] Appropriate Uses For SQLite

2015-02-19 Thread Richard Hipp
a lot of redesign! > And, there would likely be a performance hit. -- D. Richard Hipp drh at sqlite.org

[sqlite] 0 bytes in -wal file indicates successful checkpoint?

2015-02-19 Thread Richard Hipp
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

[sqlite] Getting the current value of busy_timeout

2015-02-19 Thread Richard Hipp
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

[sqlite] Getting the current value of busy_timeout

2015-02-19 Thread Richard Hipp
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] Using incremental BLOB functions against a BLOB column in a virtual table

2015-02-23 Thread Richard Hipp
.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] outer join/order by bug?

2015-02-24 Thread Richard Hipp
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

[sqlite] new line now \r\n regardless the OS

2015-02-25 Thread Richard Hipp
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] sqlite crash with malloc_printerr in sqlite3MemFree

2015-02-25 Thread Richard Hipp
___ > 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] sqlite3_column_count and sqlite3_data_count

2015-02-25 Thread Richard Hipp
On 2/25/15, Igor Tandetnik wrote: > > Why both are needed, I'm not sure. > Historical accident -- D. Richard Hipp drh at sqlite.org

[sqlite] Characters corrupt after importing a CSV file

2015-02-26 Thread Richard Hipp
> AE ka ? ? >>> AE km ?? >>> AE kn ??? >>> AE ko ?? ?? >>> AE lo >>> AE lt Jungtiniai Arab? Emyratai >>> >>> So, it lo

[sqlite] Likelihood() in Left Join affecting results

2015-07-06 Thread Richard Hipp
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

[sqlite] SIGSEGV rolling back in-memory DB‏‎

2015-07-07 Thread Richard Hipp
a more recent version of SQLite? -- D. Richard Hipp drh at sqlite.org

[sqlite] SIGSEGV rolling back in-memory DB‏‎

2015-07-07 Thread Richard Hipp
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

[sqlite] VFS for an MCU internal flash

2015-07-13 Thread Richard Hipp
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

[sqlite] how to cite SQLite

2015-07-13 Thread Richard Hipp
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

<    1   2   3   4   5   6   7   8   9   10   >