Re: [sqlite] Sqlite query doesn't run correctly on different databases

on this column). Any ideas what the problem could be? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] FTS4 languageid : not sure I understand this correctly

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] [sqlite-dev] Can I safely use the pragma synchronization = OFF?

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] bug report: out of memory error for most operations on a large database

f 711 1175 g 820 1302 h 974 1354 i 960 1403 j 961 1455 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Running on windows 98

their own OS/2 VFS at run-time, if they so desire. So, to summarize, there will be no built-in win9x support added today. Sorry to disappoint. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] performance regression when using insert or replace

-- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL query

mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some questions about the Lemon parser

? Thanks, -- Maël Nison JS Github hipster, Assistant C++ chez Epitech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Memory / off jornal still causes disc syncs

buy you nothing except lost performance. I think the fsyncs get you Durability. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

[sqlite] Fwd: sqlite3.dll missing, HELP please :)

this problem? I am doing so right now. Thanks a lot, from Caracas, Venezuela :) -- Antonella Pepe antonella.p...@gmail.com +58 414 2905255 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multi thread questions

for first connection after second thread commit transaction? Correct Regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] why i get the value of ROWID is equal to the value of field created as Primary key?

On Wed, Jan 2, 2013 at 2:00 AM, genliu777 doityth...@163.com wrote: is it the meaning of the field created as INTEGER primary is alias to the hidden ROWID field? 3rd paragraph in http://www.sqlite.org/lang_createtable.html#rowid -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] How to verify referential integrity of SQLite database

or not foreign keys are currently enabled or disabled. -- D. Richard Hipp d...@sqlite.org -- D. Richard Hipp d...@sqlite.org -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Write performance question for 3.7.15

close to being production ready at this time. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite - Dropping TEMP table doesn't free allocated memory

-- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] strange behavior with integer with where clause

Best regards, Patrik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] How to verify referential integrity of SQLite database

the foreign key in PRAGMA foreign_key_list(CHILD). If the foreign_key_check pragma returns an empty set, that means that all of the keys are correct. PRAGMA foreign_key_check works regardless of whether or not foreign keys are currently enabled or disabled. -- D. Richard Hipp d...@sqlite.org

[sqlite] SQLite Version 3.7.15.1

the unusual SQL construct necessary to tickle this bug (and most applications don't) then you are perfectly safe staying with whatever prior version of SQLite you are currently using. Nevertheless, upgrading to 3.7.15.1 is recommended. D. Richard Hipp d...@hwaci.com

Re: [sqlite] How to verify referential integrity of SQLite database

). If the foreign_key_check pragma returns an empty set, that means that all of the keys are correct. PRAGMA foreign_key_check works regardless of whether or not foreign keys are currently enabled or disabled. -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] malloc failures on ubuntu

list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multi-column index is not used with IN operator

(1) running ANALYZE or (2) adding a + in front of the Flag column name in the WHERE clause of your query, like this: ... +Flag=1 ... -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] malloc failures on ubuntu

/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The database disk image is malformed

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] sqlite3_wal_checkpoint

iTunes. SQLite is not an application. SQLite is a software component used in millions of independently developed applications. It is one of those millions of applications that is causing the error message you see. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] integrity_check runs out of memory for a not-big-at-all database

@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to verify referential integrity of SQLite database

should not do this? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp d...@sqlite.org wrote: On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) lhask...@bloomberg.net wrote: My suggestion would be to have check_integrity command verify referential integrity as well only if it's executed while

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 4:18 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) lhask...@bloomberg.net wrote: On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp d...@sqlite.org wrote: On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp d...@sqlite.org wrote: On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell

Re: [sqlite] SQLite logo usage

2008 - EESC - USP brunokim...@gmail.com Skype: bkim.cesar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite logo usage

On Mon, Dec 10, 2012 at 9:40 AM, Simon Slavin slav...@bigfraud.org wrote: On 10 Dec 2012, at 2:38pm, Richard Hipp d...@sqlite.org wrote: The SQLite name and the new SQLite Logo are registered trademarks. Let's ask it a different way. If I write something and want to list SQLite as one

Re: [sqlite] SQLite logo usage

. But you are right, there should be. I'll try to add a notice for the next release, coming up in a few days. Bruno Kim Medeiros Cesar Eng. de Computação 2008 - EESC - USP brunokim...@gmail.com Skype: bkim.cesar 2012/12/10 Richard Hipp d...@sqlite.org You are welcomed to use a copy

Re: [sqlite] Tracing latencies

:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] disk image malformed

, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Best practices for Valgrind

. The reports from valgrind indicate that Midori is leaking SQLite resources, by not finalizing all prepared statements, closing all database connections, or something like that. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

[sqlite] SQLite not working on windows. Fwd: download

go to you webpage I do not know what to download as there are so many links and versions! Can you send a link so that I can download the latest version. We have Microsoft Office on our computer. Best regards, Lisa Jalmander -- D. Richard Hipp d...@sqlite.org

[sqlite] Another example of windows users needing help. Fwd: sqlite.dll

...@hwaci.com ** Dear Sirs I am asked to download a file/program sqlite.dll to my computer to make it run better. How do I do that? I tried to do it from your download side but I got a file sqlite3.dll is that the right one? Sincerely yours Åke Halvarson -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

will be happy to look into the situation for you, and perhaps open a ticket. But, unfortunately, a single unreproducible segfault with a stacktrace that includes SQLite routines does not constitute evidence of an SQLite malfunction. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Tracing latencies

to use some low level tools would be appreciated, Regards Keith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Async IO in SQLite 3.7.15

patches that you want us to put in, we'll be glad to do that. Ralf On 03.12.2012 21:25, Richard Hipp wrote: We want 3.7.15 to be a good release, so please do have a look at the amalgamation snapshot described in the previous email (and copied below) if you have not done so already, and let

Re: [sqlite] Async IO in SQLite 3.7.15

On Tue, Dec 4, 2012 at 4:20 PM, Ralf Junker ralfjun...@gmx.de wrote: On 04.12.2012 22:14, Richard Hipp wrote: Does this also mean that it will no longer be working with SQLite 3.7.15? Is it just deprecated for new development? Or has something else changed that I should take care

Re: [sqlite] Tracing latencies

issue. For one of the UPDATE SQLs, it is updating a table with only 1 record in it. And this takes 350ms... Can you provide specifics: The schema and the UPDATE statement? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Invalid Code gemerated for Virtual Table Join with OR clause

so could be a breach of confidence. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] PHP ODBC Question

please notify the St. Claire Regional Helpdesk by telephone at 606-783-6565. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Please test the latest SQLite snapshot

of unanticipated problems, the 3.7.15 release will come out one week from Wednesday. On Fri, Nov 9, 2012 at 7:50 PM, Richard Hipp d...@sqlite.org wrote: Please test the latest snapshot of SQLite in your applications and report any performance regressions to this mailing list, or directly to me at d

Re: [sqlite] Persistence of -wal and -shm

open. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] WAL and updates

might want to consider doing checkpoints more frequently to prevent the WAL file from growing so large. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please help. Read only process being blocked by writer process.

What am i doing wrong? Any suggestions? Thank you, Alejandro ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Please help. Read only process being blocked by writer process.

. The solution there is to not hold read transactions open indefinitely. Call sqlite3_reset() when you are done with a statement so that its implied read transaction will close. Thank you for your quick answer. On Wed, Nov 28, 2012 at 9:52 AM, Richard Hipp d...@sqlite.org wrote: PRAGMA

Re: [sqlite] Please help. Read only process being blocked by writer process.

are done reading and then write. And that further incoming readers would wait for those 5 seconds. And i was expecting not to really wait, as the commit should be pretty quick, right? I'm puzzled. On Wed, Nov 28, 2012 at 10:01 AM, Richard Hipp d...@sqlite.org wrote: On Wed, Nov 28, 2012

Re: [sqlite] Sqlite and TCL on linux

/Sqlite-and-TCL-on-linux-tp65742.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Please help. Read only process being blocked by writer process.

and then overwrite the old b-tree page with the parent page. If the writer were part way through this sequence when the reader comes along, the reader would see corrupt data, since the btree structure would be only partially updated and hence not well-formed. On Wed, Nov 28, 2012 at 11:20 AM, Richard Hipp d

Re: [sqlite] sqlite3_changes and sqlite3_/extended_/errcode would benefit greatly of being available in stmt-specific variants!?

to check errcode or/and pick up the number of changed rows right after sqlite3_step() so why design for putting expensive-enough complexity on the user when there's no need for it? Thank you and with warm regards, Mikael -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] WAL and updates

/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] documentation inconsistency

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] WAL and updates

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] hfs+ on bootcamp - database malformed?

sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] malformed database schema

. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Minor documentation error

-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] added new db with other journal mode. Any issue?

list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Please test the latest SQLite snapshot

/Eating_your_own_dog_food) But we still need your help to test the latest SQLite enhancements in as many applications as possible. Thanks -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Required help on Sqlite+TCL -testsuit

mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

[sqlite] Anybody using REGEXP in the ICU extension?

of the input, unless the ^ prefix and/or $ suffix are used. ICU experts: The fix we want to make is to use uregex_find() instead of uregex_matches(). Will any legacy code break if we fix the ICU REGEXP operator to do what programmers normally expect? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Problem with create … from … order by on largish data

/releaselog/3_7_15.html -Tod On Nov 3, 2012, at 3:18 PM, Tod Olson t...@uchicago.edu wrote: On Nov 3, 2012, at 7:32 AM, Richard Hipp d...@sqlite.org wrote: On Fri, Nov 2, 2012 at 6:44 PM, Tod Olson t...@uchicago.edu wrote: I'm having a problem with a create … from … order

Re: [sqlite] light weight write barriers

. - Ted ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Win RT/WP8 support

://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with create … from … order by on largish data

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] /tmp

On Sat, Nov 3, 2012 at 8:56 AM, Ivan Shmakov oneing...@gmail.com wrote: Richard Hipp writes: On Fri, Nov 2, 2012 at 6:44 PM, Tod Olson wrote: […] This is fine on small data, but when I load 1.8GB of data (8.8 million rows) the second CREATE fails, reporting a disk I/O error. You

Re: [sqlite] light weight write barriers

/ __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] Compiling SQLite3 with MSVC 2010

:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 with MSVC 2010

On Fri, Nov 2, 2012 at 7:25 PM, Igor Korot ikoro...@gmail.com wrote: Richard, On Fri, Nov 2, 2012 at 4:14 PM, Richard Hipp d...@sqlite.org wrote: On Fri, Nov 2, 2012 at 7:05 PM, Igor Korot ikoro...@gmail.com wrote: Hi, ALL, Is anybody trying to compile SQLite with MSVC 2010

Re: [sqlite] natrual join (not natural)

a natrual join b; The natrual became an alias for table a. As if you had written: SELECT * FROM a AS natrual JOIN b; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] natrual join (not natural)

__**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Union all writting on /var/tmp

On Tue, Oct 30, 2012 at 7:39 AM, Eleytherios Stamatogiannakis est...@gmail.com wrote: Mr. Hipp please excuse my attitude on my first email All is forgotten. Thank you for bringing this optimization opportunity to our attention! -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Union all patch, preliminary tests

/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

On Mon, Oct 29, 2012 at 5:58 AM, David Barrett dbarr...@expensify.comwrote: On Mon, Oct 29, 2012 at 2:16 AM, Richard Hipp d...@sqlite.org wrote: It sounds like you are pushing SQLite well beyond what it was intended to do. Remember the motto: SQLite is not intended to replace Oracle

Re: [sqlite] Union all writting on /var/tmp

sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

and slows down the INSERT. In practice, though, fragmentation can still occur. Depending on your workload. In WAL mode, a VACUUM can be ongoing while there are other readers. This will lead to a *-wal file that is as big or bigger than the original database, however. -- D. Richard Hipp d

Re: [sqlite] Union all writting on /var/tmp

. __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Bug report concerning the juliandate function

never 30 days. Regards, Kagan Kayal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] segfault in 3.7.13 (and older) with UNION ALL

sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem: Index not used with ORDER BY on view

cannot think of an instance where that optimization would lead to incorrect results. On the other hand, I might be overlooking some pathological case where this proposed optimization leads to an incorrect result. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Permalink to latest amalgamation

'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Permalink to latest amalgamation

-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] datetime, its customary column affinity, and storage class info

what's the storage class of a given element of data? Thanks! ---John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] CREATE TABLE parsing error

-- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] xColumn called twice for a value

:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Resolving Database locking issues in a multi-user environment

backups. Many thanks, Magos ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] several links of www.sqlite.org point to draft pages

-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Find first non-NULL values of several columns

not always be so. Indeed, this will change in version 3.7.15 with the addition of a new optimization that will scan covering indices instead of the original table, when a covering index is available. You can try it out by downloading and compiling the tip of trunk, if you like. -- D. Richard Hipp d

Re: [sqlite] escape sequences for GLOB

://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] transaction commit is successful despite I/O error

(and indeed the entire database) has disappeared. I guess we could return SQLITE_CORRUPT. Would that somehow be more useful to the application? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Processing time of a transaction

://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lemon: Non-terminal destructors and cleanup

/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] subscribe to mailing list

/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: Out-Of-Memory error when doing DELETE from a table with 150 million records

/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<    7   8   9   10   11   12   13   14   15   16   >