Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

in about 5 milliseconds. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Optimization opportunity

e next release. Your beta-testing is important - Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Optimization opportunity

the view means that a transformation such as you suggest will give a different (and incorrect) answer. This is just one of many examples of the subtle pitfalls involved in trying to convert a LEFT JOIN into a form that can make better use of indexes. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Authorizer bypass "vulnerability"

users from access sensitive data, such as user passwords. Hence: https://www.fossil-scm.org/fossil/artifact/ee53ffbf762?ln=161-232 Background: The sqlite3_set_authorizer() interface was first added for CVSTrac (http://www.cvstrac.org). The Fossil report logic was copied from CVSTrac. -- D. Richard Hi

Re: [sqlite] Authorizer bypass "vulnerability"

ck for "main" or some other name. I do not consider this to be a serious issue - certainly not worth adding a new API or adding a new branch in a critical path that will slow down the code in the common case. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Ambiguity in 'pragma page_size' docs

tion and make sure the flag parameter is SQLITE_OPEN_READWRITE or SQLITE_OPEN_READONLY and that it does not include the SQLITE_OPEN_CREATE bit. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] Ambiguity in 'pragma page_size' docs

; check that the db file is missing or empty before opening it, I suppose.) > The implication *should* be that you *never* change the page size. SQLite will pick a good page size for you automatically, which works in 99.99% of all cases. In the exceptional c

Re: [sqlite] Which pragmas are persistent?

t; —Jens > > [1]: http://www.sqlite.org/pragma.html > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Select Statement returning incorrect information

ume_Information; And in particular, does it show that some of the VI_File_Len values are text? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_step and ORDER BY random() question.

similar wrapper of your own concoction) to load all query results into memory prior to starting the UPDATEs. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What does SQLITE_IOERR_VNODE mean?

y a dispatch vnode source event" but I do not understand what that means. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_step and ORDER BY random() question.

n index. But if batch_id and due_datetime are both NOT NULL and unique, then the third ORDER BY term will be ignored, and the UNIQUE index will be used to order the output. And in that case, if any of your worker threads modify the batch_id or due_datetime fields, then there could be issues. A safe work-a

Re: [sqlite] json() number value parsing

On 4/10/17, Richard Hipp <d...@sqlite.org> wrote: > SQLite returns true from json_valid() for the following cases which > should allegedly be false: > > n_multidigit_number_then_00.json > n_string_unescaped_newline.json > n_string_unescaped_tab.json > The sec

Re: [sqlite] json() number value parsing

s SELECT name FROM files WHERE name LIKE 'i_%' AND json_valid(readfile(name)) NOT IN (0,1); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Another .DUMP issue with v 3.18.0

, so the command is invalid. > > Simon. > _______ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Another .DUMP issue with v 3.18.0

x values('1')" > sql .dump xxx.db | sql > I'm unable to repro. Please send the database file via private email. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Crash while rollback database in journal_mode=DELETE

the email address that is associated with your SEE license. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fossil error: Table plink has no column named baseid

On 4/6/17, Domingo Alvarez Duarte <mingo...@gmail.com> wrote: > > How could we clone/sync a fossil repository with "n" depth commits ? > Can't be done right now. And because of the way propagating tags are handled, doing so would be tricky. But we have thought about i

Re: [sqlite] Fossil error: Table plink has no column named baseid

(19502, 28178, 1, 2456451.609110463, NULL); > > I was expecting that fossil would detect and update the schema by itself. > > Cheers ! > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglist

Re: [sqlite] Continuous recovery of journal

-shm files sitting around. If you are cool with that, no need to call sqlite3_close(). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Testing sqlite db to see if exists & ready

, perhaps millions, of applications, so they are all there for the long haul. Especially "PRAGMA user_version" you can count on being there. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mai

Re: [sqlite] Expression Indexes - can I project the expression value from the index?

On 4/5/17, Deon Brewis <de...@outlook.com> wrote: > Hi, > > Just following up - is this tracked somewhere in a feature/bug database? > We are aware of the feature request and discussed it internally just yesterday. It is non-trivial to implement. -- D. Richard Hi

Re: [sqlite] Incompatibility into configure.ac

se scripts explicitly invoke bash, using a shebang or whatever. > The deeper issue is that I do not have access to a machine that lacks bash on which to test the modifications.... -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Vacuum results in larger database after running pragma integrity_check

On 4/4/17, Richard Hipp <d...@sqlite.org> wrote: > On 4/4/17, Ben Newberg <ben.newb...@gmail.com> wrote: >> I've noticed with 3.18.0 that it's possible to make a database increase >> in >> size after running pragma integrity_check (which returns "ok"

Re: [sqlite] Vacuum results in larger database after running pragma integrity_check

d to this check-in: https://www.sqlite.org/src/timeline?c=aa02bd Still do not understand how a (read-only) integrity_check might affect a subsequent VACUUM operation, however. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-user

Re: [sqlite] Vacuum results in larger database after running pragma integrity_check

)); > CREATE TABLE bids_dates (report_id integer primary key, date text, current > integer check (current in (0, 1))); > CREATE INDEX idx_price_id ON bids_list (price_id); > /* No STAT tables available */ > > Is the pragma fixing something in the index perhaps? > __

Re: [sqlite] Incompatibility into configure.ac

hell (bash)? Bash has been with us now for like three decades, right? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Get notified as soon as it's save to modify a db after sqlite3_update_hook() was triggered

into SQLite. But you can add one by putting a wrapper around sqlite3_step(). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Release 3.18.0

uld be a no-op. Read the go-bys - you should run "PRAGMA optimize" after running many queries. I will fix the harmless warning in the next release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqli

Re: [sqlite] 3.18 Problem

On 4/2/17, Simon Slavin <slav...@bigfraud.org> wrote: > >> On 3 Apr 2017, at 2:11am, David Burgess <dburg...@gmail.com> wrote: >> >> (I guess I should re-check >> to see if that has changed since 3.7) > > Yep. Many speedups in recent versions of SQLi

Re: [sqlite] Continuous recovery of journal

a checkpoint are kind of unrelated things and I don't see why one should imply the other. But if the OP want a recovery operation to always checkpoint, that is really easy to implement in the application. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mail

Re: [sqlite] Continuous recovery of journal

ner by running "PRAGMA wal_checkpoint". -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Continuous recovery of journal

On 4/1/17, J Decker <d3c...@gmail.com> wrote: > On Sat, Apr 1, 2017 at 2:38 AM, Richard Hipp <d...@sqlite.org> wrote: > >> On 4/1/17, J Decker <d3c...@gmail.com> wrote: >> > I get this ... from sqlite error log callback >> > >> > Sqlite3 Err

Re: [sqlite] Get size of blob

www.sqlite.org/src/artifact/f1acf5744ce?ln=2675-2680 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Continuous recovery of journal

cially if it > segfaults). This is because the previous process to access the database did not call sqlite3_close() prior to exiting, and so the WAL file was not cleaned up properly. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] regression: SQLite 3.18.0 - editline configure no longer working

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

Re: [sqlite] need help to implement a VTAB on a already sorted table

e the XXX value to be passed into xFilter, then sets idxNum or idxStr to tell xFilter what algorithm to use. xFilter will use the idxNum or idxStr values to recognize that it should jump immediately to rep=XXX. I'll see if I can work up some examples of this later toda

Re: [sqlite] core using sqlite 3.17.0 on solaris

per Clemens' suggestion. https://www.sqlite.org/src/artifact/de2ec4fe?ln=485 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] core using sqlite 3.17.0 on solaris

On 3/30/17, Clemens Ladisch <clem...@ladisch.de> wrote: > Richard Hipp wrote: >> #ifdef sqlite3Parser_ENGINEALWAYSONSTACK >> - unsigned char zSpace[sizeof(yyParser)]; /* Space for parser engine >> object */ >> + /* Space to hold the Lemon-generated Parser obje

Re: [sqlite] unlock_notify missing from Tcl interface writeup

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

Re: [sqlite] core using sqlite 3.17.0 on solaris

terrupted = 0; } pParse->rc = SQLITE_OK; pParse->zTail = zSql; assert( pzErrMsg!=0 ); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Questions on big blobs and blob I/O

nd go right to the page at the end that contains your ID. Key points are that this optimization does not work every time and will fall back to walking the list if it fails, and it never works unless auto_vacuum is turned on. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] VT table behavior change between 3.10 and 3.17

advantageous to keep the number of open cursors to a minimum. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use of sqlite3_bind_int() vs sqlite3_bind_int64()

lloc64() and sqlite3_realloc64() and sqlite3_column_int64(), etc. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BLOB sizes beyond 2GB?

commodate anything larger than that. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Syntax. table-function-name vs table-naming-function-name

t; function? > The easiest way for me to answer this is to ask you to provide a sample implementation. After you've work on the problem for a while, I think you will begin to understand why it is not possible. I can't seem to come up with words to help make that realization any easier. -

Re: [sqlite] Drop view ?automatically? when its associated table is dropped?

ror checking, optimization, and code generation phases. It is this parse tree that you want to see, right? And that is the same parse tree that is frequently modified in order to accomplish new features and optimizations, and which we are therefore unwilling to make available in a standard

Re: [sqlite] Drop view ?automatically? when its associated table is dropped?

t not be helpful. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] json_patch(): null not removed with 2nd beta for SQLite 3.18.0.

On 3/24/17, Ralf Junker <ralfjun...@gmx.de> wrote: > On 24.03.2017 00:50, Richard Hipp wrote: > >> This second beta adds a new SQL function: json_patch(). See >> https://www.sqlite.org/draft/json1.html#jpatch for details. > > json_patch() fails to produce the expect

[sqlite] Second beta for SQLite 3.18.0.

in reporting issues or concerns. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Memoization in sqlite json1 functions

r are you just assuming that because the implementation parses the JSON anew each time it see it that it must therefore be inefficient? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Still running 3.7.x. Was: RIGHT JOIN! still not supported?

On 3/23/17, Hick Gunter <h...@scigames.at> wrote: > I am still runnning SQLIte > 3.7.14.1 Why? 3.17.0 is backwards compatible, fixes obscure bugs, has many new features, and runs twice as fast. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Drop view “automatically” when its associated table is dropped?

ations would not want the VIEW to be dropped automatically. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] First beta for SQLite 3.18.0.

On 3/20/17, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Mar 2017, at 2:13pm, Richard Hipp <d...@sqlite.org> wrote: > >> All other corrections implemented. > > Check "alway" on the current mask sentence again. No correction shown when > I re

Re: [sqlite] First beta for SQLite 3.18.0.

Or this feature may never be implemented :-) All other corrections implemented. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] First beta for SQLite 3.18.0.

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

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

nk user defined TCL byte code could be executed > directly instead of having to statically link the TCL byte code engine > again and again for each extension binary. Being a TCL extension does not imply that the TCL byte code engine is already linked in. -- D

Re: [sqlite] reset after failed step

On 3/17/17, Jan Danielsson <jan.m.daniels...@gmail.com> wrote: > >I.e. reset should only be run on ROW and DONE. On step error, the > statement's state is reset implicitly by sqlite3_step()? No. Always run sqlite3_reset(). -- D. Richard Hipp

Re: [sqlite] Compressed schema in memory?

upt in the eyes of older versions of SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compressed schema in memory?

On 3/16/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > In sqlite_master I see quite a lot of "sql_autoindex" indexes. Do > these auto indexes consume the same RAM as explicit indexes? Yes. Those indexes are implementing UNIQUE constraints. -- D. Richar

Re: [sqlite] Compressed schema in memory?

re concise specification for internal > use, then less memory should be consumed. The schema is stored as a parse tree. But it still needs to store the names of objects (triggers, indexes, tables, columns) in order to look them up by name in response to various SQL

Re: [sqlite] Compressed schema in memory?

racters? That isn't a lot of space, but it is a start. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compressed schema in memory?

On 3/16/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > > The schema (already stripped to remove white space and comments) for > our database has reached 664K Yikes. That's about 10x or 20x what we typically see. Are you able to share your schema with us? -- D.

Re: [sqlite] Unable to clone fossil repo

On 3/16/17, Richard Hipp <d...@sqlite.org> wrote: > > As of 2017-03-12, you need Fossil 2.0 or later. What does "fossil -v" > say for you? > I gave you the wrong command. "fossil version", not "fossil -v". What do

Re: [sqlite] Unable to clone fossil repo

sil clone http://www.sqlite.org/cgi/src sqlite.fossil As of 2017-03-12, you need Fossil 2.0 or later. What does "fossil -v" say for you? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:

Re: [sqlite] last_insert_rowid and FTS in 3.17

apshot at https://www.sqlite.org/download.html and let us know whether or not it fixes your problem. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A CTE to count the records (rows) for each table

e" ANALYZE may land on trunk within the next release or two. So, no, I would not trust the sqlite_stat1 data if you need an accurate count. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

mory temporarily while the CREATE TABLE statement is being parsed when the connection is first opened, but they are not held in memory long-term. The text of the CREATE TABLE is freed as soon as the schema parse completes. So there is no extra long-term memory usage. -- D. Richard Hipp d...@sq

Re: [sqlite] A CTE to count the records (rows) for each table

or example: SELECT name, eval(printf('SELECT count(*) FROM "%w"',name)) FROM sqlite_master WHERE type='table' AND coalesce(rootpage,0)>0; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-

Re: [sqlite] [sqlite-dev] End-of-line characters in the output of ".dump"

On 3/11/17, James K. Lowden <jklow...@schemamania.org> wrote: > On Sat, 11 Mar 2017 08:50:49 -0500 > Richard Hipp <d...@sqlite.org> wrote: > >> The SQLite CLI could be improved to be cleaner about this, but it >> depends on external utilities such as readline() or

Re: [sqlite] SQLIte crash in sqlite3_db_release_memory

sequent releases. Version 3.17.0 use less than half the CPU cycles as 3.7.10 and is completely backwards compatible. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] More built-in functions for basic math

il Timeline) The SQLite developers have a private chatroom on which this topic is being discussed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Aggregate and Scalar functions with the same name

ered is >> showing up -- so which one shows up is scalar/aggregate is determined by >> which one was defined last). >> >> When I asked you about this you said that I simply need to register the >> function twice, once as an aggregate function and once as a scaler >> function

Re: [sqlite] More built-in functions for basic math

three.c extensions on top of the similar extensions that are built into the shell. Nothing about the shell code has to change. What part of that is not working for you? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] sqlite3 feature or regression

e loop over UPDATEs. If you add "ORDER BY +rowid" to the query, that forces the query to run to completion first and then go through the sorter, before you get any results back, which solves the problem. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Wrong date with release 3.16.1

On 3/8/17, Pieter Parmentier <pieterparment...@hotmail.com> wrote: > > It's something really little, but on the newspage , the date for release > 3.16.1 is wrong. > Fixed now. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-

Re: [sqlite] Why isn't my time formatting working?

formatted: > > select strftime('%d/%m/%Y %H:%M:%S', '03/07/2017 13:06:03') SQLite uses ISO-8601 dates: YYYY-MM-DD -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.o

Re: [sqlite] sqlite3 feature or regression

so that I could debug a Ruby script. That might take a few hours, or a few days. Why are you wanting me to work so hard at this? Wouldn't it be a lot easier if you just tell us what you think the problem is, in words? -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Incorrect SEARCH link on "c3ref" page

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

Re: [sqlite] SQLite 3.18.0 pre-release snapshot

On 3/7/17, Olivier Mascia <o...@integral.be> wrote: >> Le 7 mars 2017 à 04:13, Richard Hipp <d...@sqlite.org> a écrit : >> >> the database connection remembers (in RAM) specifically which >> tables and indexes it has considered for use and will only run ANALY

Re: [sqlite] SQLite 3.18.0 pre-release snapshot

On 3/6/17, jose isaias cabrera <jic...@barrioinvi.net> wrote: > > Richard Hipp wrote... > >>Have you ever wondered when you should run ANALYZE on an SQLite >>database? It is tricky to figure out when that is appropriate. The > Thanks for this. I actually run thi

Re: [sqlite] Need some help running sqlite3 command line

On 3/6/17, Jacob Sylvia <jacob.syl...@gmail.com> wrote: > > How can I check if that support is compiled in? > The readfile() SQL function was add to the command-line shell in SQLite version 3.8.6 released on 2014-08-15. -- D. Richard Hipp

Re: [sqlite] SQLite 3.18.0 pre-release snapshot

than the stated default of 14 (0x0e). Default mask changed to 0xfffe, which allows for up to 14 new default-on optimizations and up to 48 new default-off optimizations. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlit

Re: [sqlite] sqlite3 feature or regression

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

Re: [sqlite] sqlite3_set_last_insert_rowid()

gt; popping them each time you enter or exit a trigger ? Correct -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 3.18.0 pre-release snapshot

n will give an error the first time you try to "fossil update" after SHA3 content is added. See https://www.fossil-scm.org/fossil/doc/trunk/www/hashpolicy.wiki fpr additional information. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Minor doc patches

On 3/6/17, Kim Gräsman <kim.gras...@gmail.com> wrote: > Hi all, > > I'm reading the documentation on memory > (https://www.sqlite.org/malloc.html) again and stumbled on some typos: Thanks. Fixed now. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Multiple tables or not

e first 3 columns and the second table has the rest of the columns. > Would that make reading the smaller table with only the 3 columns > noticably faster (due to less page faults/etc.)? > Yes, possibly so. I don't know by how much, but it does make since that queries would be fas

[sqlite] Fossil version 2.0

before. All legacy URLs (even those involving SHA1 hash names) continue to work without change. If you only access Fossil through the web interface, no action is necessary. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] 'start of day' modifier and Julian day timestring

On 3/2/17, Mark Brand <mabr...@mabrand.nl> wrote: > I am wondering why the 'start of day' and 'start of year' modifiers > don't seem to work on Julian day timestrings. https://www.sqlite.org/src/timeline?y=ci=081dbcfb Tnx for the bug report. -- D. Richard Hipp d..

Re: [sqlite] Strange - query returned duplicates, issue fixed after executing 'VACUUM'

ent but it does not match its table (it has extra rows and/or is missing rows) then VACUUM won't fix it. REINDEX does rebuild the indexes from scratch. If the problem is just indexes that are missing entries or have extra entries, REINDEX will fix it. -- D. Richard Hipp

Re: [sqlite] foreign key cardinality

On 2/27/17, James K. Lowden <jklow...@schemamania.org> wrote: > SQLite requires that foreign keys refer to primary > keys. No it doesn't. Where did you get that impression? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] No way to check for CHECK constraint violations a posteriori

n go back and figure out which constraint and which row is at fault using ordinary queries. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] No way to check for CHECK constraint violations a posteriori

they should have been. But that is water under the bridge now. If we change it, it will likely break a bunch of legacy programs. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] No way to check for CHECK constraint violations a posteriori

On 2/22/17, Dominique Devienne <ddevie...@gmail.com> wrote: > Neither {{pragma integrity_check}} nor {{pragma foreign_check_check}} > checks CHECK constraints. That is now fixed on a branch. I am still testing the changes prior to merging onto trunk. -- D. Richard Hipp d..

Re: [sqlite] Magic self-healing database!

d not match and rolled back the transaction containing the error (and all subsequent transactions, if any) thus fixing the problem. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Linux top command and sqlite

ord of the year: *kakistocracy* > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] error 6410 after upgrade to 3.17.0 on android

ould says "TEMP_STORE=3" if the makefile is working correctly. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Checking gcc/clang compiler version (was: OS X/Xcode build error: use of unknown builtin)

hat I need to go back and implement a rather more complicated set of #ifdefs to work around the issues with clang. I do intend to do that for the 3.18.0 release. In the meantime, several downstreams needed a quick and low-risk fix which the https://www.sqlite.org/src/info/810d29320b853b3a check-in provides.

Re: [sqlite] Decrypt .db file

sible passwords. The whole point of encryption is to prevent people from accessing the file who do not know that password. If there were a easy way to recover the password, then it wouldn't be "encryption". -- D. Richard Hipp d...@sqlite.org ___

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