Re: [sqlite] sqlite journal file question

. They are independent of the byte-order and word-size of the machine they were created on. -- 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] unreached code in sqlite3.c?

Dan is right. I think I'd calling this a clang bug. On Feb 12, 2015 9:06 AM, Dan Kennedy danielk1...@gmail.com wrote: On 02/12/2015 09:02 PM, Jens Miltner wrote: Hi, I'm getting the following two warnings when compiling sqlite3.c with the latest clang tools: sqlite3.c:116769:39:

Re: [sqlite] sqlite3 mailing list broken

much easier, as I nearly gave up trying to report this issue out of frustration. Thanks in advance Cal [2]: https://github.com/husio/python-sqlite3-backup [3]: http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py On Thu, Feb 12, 2015 at 12:53 PM, Richard Hipp d...@sqlite.org

Re: [sqlite] binding multiple values in a query

patching source or implementing a virtual table). That virtual table you mentioned is implemented at https://www.sqlite.org/src/artifact/9dc57417fb65bc78 (for integer values, at least). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

/artifact/0396f220561f -- 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] ordinary CTE containing sum()

of aggregate: sum(). Possibly fixed on trunk now. Please test and confirm. -- 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] why does the recursive example sort alphabetically

expected to need to change the query to have ORDER BY 2 DESC, org.name for it to work, but it works anyway. Thanks! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Encoding question

be able to understand it otherwise, and would have rejected it, so it never would have made it into the sqlite_master table. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Performance increase between 3.7 and 3.8

: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] Encoding question

are also automatic. -- 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] expected performance of selecting large numbers of records

: http://www2.sqlite.org/ http://www3.sqlite.org/ -- 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] Partial indexes not working for me

an IS NULL constraint with an index unless you have first run ANALYZE. It might also require compiling with SQLITE_ENABLE_STAT4. The usual case with partial indexes is WHERE field IS NOT NULL --- with a NOT. You are taking partial indexes into an area for which they were not optimized. -- D. Richard

Re: [sqlite] Best Practice for read-only access

--but I'm worried that it would increase memory usage considerably. I vote for #2. Measure the memory usage if that is a concern. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Truncation of floating point numbers in SQLite?

. That round-trip would change -0.0 into +0.0. -- 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] database disk image is malformed error occurs more

___ 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

Re: [sqlite] database disk image is malformed error occurs more frequently...?

___ 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/sqlite

Re: [sqlite] fuzzer-generated apparent ASAN violation (oob read)

___ 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

Re: [sqlite] sqlite3 very slow even after creating without rowid

-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] Buffered stderr on Windows (Take 2)

://www.sqlite.org/src/info/2a9ea9b4a7d6 -- 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] Streaming group by in union of already sorted tables

job of handling your query in future releases. Thanks for posting. -- 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] Report a warning bug about Lemon parser

/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] crash in sqlite3MatchSpanName

___ 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] Huge WAL log

/wal.html#bigwal Let me know if that helps. Note that I have only quickly read over my writing so there is a high probability of typos, which I will be happy to correct when brought to my attention. The problem was definitely in indexes. Simply the larger is the index table -- D. Richard Hipp

Re: [sqlite] Shell tool question

. It uses a new stack frame for each level of recursion. So if you create a recursion loop, you'll overflow the stack and segfault. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

to create a table with sub minute access for 100-500 million . How do we create the indexes ? Any other performance incentives. Some say we should buy/use Oracle but I just am holding onto sqlite3 assuming it would help me solve our problem. Regards, Navin -- D. Richard Hipp d

Re: [sqlite] ORDER BY and LIMIT regression

query on 3.8.6, 3.8.7.4, and 3.8.8. All three give the same answer for me. Dan did likewise with the same results, and in addition ran the test under valgrind with no warnings issued. Unable to recreate the problem. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] ORDER BY and LIMIT regression

Ignore my previous email on this subject. We are able to get different results from 3.8.6 and 3.8.8. Unclear yet if the one or the other is incorrect. On 1/19/15, Richard Hipp d...@sqlite.org wrote: On 1/19/15, Angelo Mottola a.mott...@converge.it wrote: Hello, I have a regression to report

Re: [sqlite] ORDER BY and LIMIT regression

. Adding or removing a single column of result gives the correct answer. -- 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] ORDER BY and LIMIT regression

On 1/19/15, Simon Slavin slav...@bigfraud.org wrote: On 19 Jan 2015, at 3:10pm, Richard Hipp d...@sqlite.org wrote: It is a very complex problem. In particular, the sample query works fine as long as the number of columns in the result set is not exactly 60. Adding or removing a single

Re: [sqlite] ORDER BY and LIMIT regression

fixed. We are running another release cycle now. SQLite version 3.8.8.1 should be out sometime tomorrow, assuming everything goes well. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Fsync or fdatasync performs slowly

mode in SQLite. -- 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] Database corrupted 28 billion bytes

is troubling. A VACUUM should clear the problem. But I wish I understood how the problem arose in the first place -- 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 tool bug summary

does not work. using | to shortcut and doesn't work. Thanks for the excellent summary. But what about this case: .once '| sqlite3 new.db' .dump -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Best Practice: Storing Dates

* FROM data WHERE julianday(tstr) BETWEEN julianday(tbegstr) AND julianday(tendstr); This is also fast: SELECT * FROM data WHERE tstr BETWEEN tbegstr AND tendstr; And it works just as well if dates are in the ISO8601 format. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlite3 tool bug

in shell.c since 3.8.6. We are on 3.8.8. Why not upgrade? -- 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] sqlite3 tool bug

to binary mode: OK. Dave, please try this patch at let us know if it works better for you: https://www.sqlite.org/src/info/80541e8b94b7 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Database corrupted 28 billion bytes

/Database-corrupted-28-billion-bytes-tp80048.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

Re: [sqlite] Database corrupted 28 billion bytes

. 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] LIKE vs GLOB vs MATCH vs REGEXP

___ 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] LIKE vs GLOB vs MATCH vs REGEXP

? They are aliases for one another. Syntactic sugar. You can see this by using EXPLAIN: .explain EXPLAIN SELECT * FROM sqlite_master WHERE name LIKE 'abc%'; EXPLAIN SELECT * FROM sqlite_master WHERE like('abc%',name); Both generate identical bytecode. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Database corrupted 28 billion bytes

be interesting to you. -- 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] Database corrupted 28 billion bytes

: sqlite3_analyzer bigdb.db3 analysis.txt start analysis.txt -- 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] sqlite3 tool bug

... ___ 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] Client/Server Best Practices

, in isolation, unaffected. --jkl ___ 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] Increase page_size on existing db with data and WAL

the page size, then change back to WAL mode. -- 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] sqlite3 tool bug

command-line shell doing some character translations in the pipe, rather than just shipping the bytes through the pipe unaltered. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] sqlite3 tool bug

means the pipe method shouldn't ever be used on windows. Not, at least, when your database contains string data with unusual characters that Windows feels like it should translate for you... -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] damaged database recovery

... ___ 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] damaged database recovery

/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] using a hex integer as input to DateTime

- VSC processing made easy On 8 January 2015 at 00:33, Richard Hipp d...@sqlite.org wrote: On 1/7/15, Paul Sanderson sandersonforens...@gmail.com wrote: Evening all I dont think this can be done, but would love to be corrected. I have a column with integer dates stored in hex format so

Re: [sqlite] Best Practice: Storing Dates

and which often do not sort in time order. -- 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] Huge WAL log

-- 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] Huge WAL log

On 1/14/15, Jan Slodicka j...@resco.net wrote: Richard Hipp-3 wrote No other active readers or writers. Are you sure? Writers for sure. As far readers are concerned, the things are too complex to make an absolute statement. (I shall check once more.) However, I can add a few observations

Re: [sqlite] database is locked

-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] database is locked

. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 14, 2015 12:50 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database is locked On 1/14/15, Roman Fleysher roman.fleys

Re: [sqlite] database is locked

lock and must rebuild the database? Probably you can just restart the NFS lock manager. Rebuilding the database seems a bit extreme. Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d

Re: [sqlite] aggregate functions with DISTINCT

other SQL database engines that allow multi-argument aggregate functions? What do those systems do? -- 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] Error in amalgamated file

? and the ORDER, for readability. But the fact that the space was omitted is benign. -- 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] xBestIndex/XFilter and virtual tables

, please contact the sender and delete the material from any computer. ___ 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] xBestIndex/XFilter and virtual tables

[].argvIndex = 1 then i should expect a list of values (42 and 24) in argv[0]. xFilter will be called multiple times, once for each value in the RHS of the IN operator. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite 3.8.8 expected in January

omission? Yes, it was a compile-time omission. I have uploaded a new DLL that includes the loadable extension interface. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] aggregate functions with DISTINCT

but only to realise that the data being concatenated also might contain one or more commas. SELECT group_concat(x,'+') FROM (SELECT DISTINCT a+b AS x FROM tab ORDER BY 1); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Segfault with Evolution and patched SQLite 3.8.7.4 (was: Bus error with Evolution 3.12.9 and SQLite 3.8.7.4)

[1] https://packages.debian.org/corekeeper [2] https://www.sqlite.org/src/info/776648412c30dce206f1024ff849c2cb025bb006 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] SQLite 3.8.8 expected in January

On 1/9/15, Dominique Devienne ddevie...@gmail.com wrote: On Fri, Jan 9, 2015 at 6:23 PM, Richard Hipp d...@sqlite.org wrote: We hope to release SQLite version 3.8.8 sometime later this month (January). A change-log is available at https://www.sqlite.org/draft/releaselog/current.html Could

[sqlite] SQLite 3.8.8 expected in January

snapshots and precompiled Windows DLLs can be found at https://www.sqlite.org/download.html -- 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] a couple of crashing bugs from a fuzzer

/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 problem possible bug

to your programming language, not in SQLite itself. -- 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 bug: it's ESCAPE not EXCEPT that limit LIKE optimisation

fixed. See https://www.sqlite.org/docsrc/info/1e0e7c930074 for the check-in. This change will appear in the next release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Index rownum

) time. That would have made things like count(*) much faster too. But doing this also increases insertion and deletion cost, so I decided against doing it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] using a hex integer as input to DateTime

. 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] Time Zone Conversions

.nabble.com/Time-Zone-Conversions-tp79849.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] sqlite3_bind_text and strings that look like numbers

/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 login password

is coming from third-party software. 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

Re: [sqlite] Bus error with Evolution 3.12.9 and SQLite 3.8.7.4

, other than the updated SQLite3 library I run on a clean Jessie. Our latest theory is that the problem only arises when /var/tmp runs out of space. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Bus error with Evolution 3.12.9 and SQLite 3.8.7.4

position in the stack trace and I'd like to look closer. -- 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] Client/Server Best Practices

. ___ 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

Re: [sqlite] FTS4 Problem

! ___ 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

Re: [sqlite] Abnormal memory usage when removing rows within nested transaction from a table, referenced by another table via FK,

); // Do not leave database file behind. unlink(database_file); return 0; } ___ 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] Feature Request - RowCount

, Ryan ___ 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

Re: [sqlite] Feature Request - RowCount

No. The fastest is to do count(*). -- D. Richard Hipp Sent from phone - Excuse brevity On Dec 13, 2014 11:13 AM, Jim Callahan jim.callahan.orla...@gmail.com wrote: So, if I understand the discussion the fastest way to get a count from the command line interface (CLI) is to count the rows

Re: [sqlite] How to speed up database open

-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 speed up database open

SQLITE_ENABLE_STAT4. You will still probably get good query plans, but the startup time should be reduced. -- 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] Select count(*)

On Thu, Dec 11, 2014 at 11:27 AM, Dominique Devienne ddevie...@gmail.com wrote: So why couldn't sqlite using the PK index to reduce the IO when doing a select count(*) from t_with_non_int_pk, to avoid scanning the table? It does. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlar

that, and I'm sure it's probably platform defined anyway. So does the latest commit fix the problem? -- 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] Bugreport - slowdown in sqlite after the ANALYZE statement

- ___ 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] sqlite bugreport : unique index causes valid updates to fail

. Cheers, Gwendal Roué ___ 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] [SQLite]Ba​sic query

.c 32 2371518 sqlite3-all.c 151707 706855 5388171 total Include all these files in your project, but compile against just sqlite3-all.c. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Table names length and content

start with sqlite but otherwise, there are no other restrictions that I recall. -- 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] Table names length and content

of that does not mean that you *should* use it. I'm worried about what you are contemplating, Jose. I think you would be better off to use a short and simple lower-case ASCII table name. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] database is locked for SQLITE_BUSY

. https://www.sqlite.org/rescode.html#busy -- 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] trying to store a file as a blob. caught on syntax...

-line shell, then you can add that function as a loadable extension (https://www.sqlite.org/loadext.html). The source code is at https://www.sqlite.org/src/artifact/d4171c815d6543a9edef8308aab2951413cd8d0f -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Bug report: USBAN failure

/0d04f380e1bd17104b3cf76b64d0cfc79a726606 for the change. -- 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: USBAN failure

On Tue, Dec 2, 2014 at 8:53 AM, Dominique Devienne ddevie...@gmail.com wrote: On Tue, Dec 2, 2014 at 2:47 PM, Richard Hipp d...@sqlite.org wrote: On Mon, Dec 1, 2014 at 5:46 PM, Hadley Wickham h.wick...@gmail.com wrote: [...] has started running all R packages with USBAN. This reveals

Re: [sqlite] appending the output of a query

-Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made easy ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp

Re: [sqlite] Much unused space in sqlite3 database when using blobs

blob = 49870) there are 72.5% of unused bytes on overflow pages. Why? ___ 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] Read overflow in CREATE VIRTUAL TABLE query (formerly Corrupting pointers to the lookaside smallacator)

in the test harness only understands fts3. So I believe Dan's test case is correct as written. -- 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] Recursive SQL query does not use expected index

___ 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

Re: [sqlite] PRAGMA reverse_unordered_selects and CTEs

On Fri, Nov 21, 2014 at 5:58 AM, snowbiwan snowbiwanjaak...@gmail.com wrote: If this is not a bug, then this behaviour should be mentioned on either the Pragma, or WITH Clause documentation pages. Not a bug. https://www.sqlite.org/docsrc/info/3d72482e471 -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Insert Hindi Language

-- 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] Why is a b-tree sort required for this query?

://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

  1   2   3   4   5   6   7   8   9   10   >