Re: [sqlite] column types and constraints

On 6/27/18, Igor Tandetnik wrote: > On 6/27/2018 9:14 PM, Richard Hipp wrote: >> On 6/27/18, Mark Wagner wrote: >>> Thanks for all the good background. FWIW this came up because someone >>> had >>> created a row with something like: (column_name non null)

Re: [sqlite] column types and constraints

n error when I type: CREATE TABLE t1(x NOT NULL); INSERT INTO t1(x) VALUES(NULL); I think something else must be going on. Do you have an exact copy of what "someone" typed? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-

Re: [sqlite] column types and constraints

idely used database engine on the planet and over a trillion SQLite database files got created, and now we need to stick with that original idea lest we cause compatibility issues for all that legacy. -- 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] Performance issue with left join in 3.24 compared with 3.22

https://sqlite.org/src/info/dd568c27). Your work-around is to change the LEFT JOIN into CROSS JOIN, thus forcing the query planner to preserve the same join order as it did before the string reduction optimization. We (the SQLite devs) will take an action to try to improve the query planner so that it p

Re: [sqlite] Unexpected sqlite3_trace_v2 sqlite3_expanded_sql output.

On 6/22/18, Lodewijk Duymaer van Twist wrote: > > Is this normal explaiable behaviour or should I try to provide a repo? > It would be helpful if you could provide a repro. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] A coredump when select with index

Y? > Is there any way to know what happened? > > Thanks. > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > sqlite-users mailing list > sqlite-users@mailing

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

lue. > "sqlite3.c", line 52491: warning: statement not reached > (E_STATEMENT_NOT_REACHED) Line 52491 is "assert(0);" which generates no code unless you compile with -DSQLITE_DEBUG. Once again, I have no explanation for the warning. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Check if the new table has been created

On 6/20/18, Igor Korot wrote: > if( ( res = sqlite3_step( stmt ) ) == SQLITE_OK ) sqlite3_step() returns SQLITE_ROW when it has data, not SQLITE_OK. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] How to use WHERE clause in UPSERT's conflict target

impacts the > statement. As a test, I tried the following: The WHERE clause on the conflict-target is only used for partial indexes. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://m

Re: [sqlite] Check if the new table has been created

ible? > > There is a sqlite3_*_hook() family of functions, but it looks like > they won't help with sqlite_master. > > Is there a different way? Poll the PRAGMA schema_version value and watch for changes. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

cription confirmations, there is now a website to assist you. Do we need any further evidence that the heart of man is deceitful above all things, and desperately wicked? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailin

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

On 6/14/18, Gary R. Schmidt wrote: > > Would you be willing to publish your fix to the mailman list so that > others could make use of it? I don't want help the spammers develop work-arounds. -- D. Richard Hipp d...@sqlite.org ___ sqlite-user

[sqlite] Back on-line. Was: Mailing list shutting down...

On 6/13/18, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now Mailing lists are now back on-line and once again accepting subscriptions. I have implemented

Re: [sqlite] Mailing list shutting down...

here: https://www.fossil-scm.org/fossil/doc/trunk/www/antibot.wiki The key thing is that MailMan is opaque (to me). I cannot add these defenses to MailMan. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] [fossil-users] Mailing list shutting down...

On 6/13/18, Svyatoslav Mishyn wrote: > > Another alternative would be nimforum: > https://github.com/nim-lang/nimforum > It does not appear to have email notification. Unless I overlooked something. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Mailing list shutting down...

ich files to edit. If I understand the problem you reported they > would both fix it. I did just try these. It causes MailMan to fail with an error. Probably the MailMan installation is messed up somehow. I am currently looking at locating and saving off the subscriber lists, then deleting a

Re: [sqlite] Mailing list shutting down...

. Please enlighten me if I am overlooking something. -- 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] Mailing list shutting down...

there any volunteers willing to call me on skype and help set this up? -- 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] Mailing list shutting down...

On 6/13/18, Michael Tiernan wrote: > May I respectfully suggest to everyone that offering solutions, while > valuable and helpful, may not be as valuable as the offer of assistance > to our listmaster. +1 :-) -- D. Richard Hipp d...@s

Re: [sqlite] Mailing list shutting down...

in my past interactions, there was nobody there who was willing to help with spam problems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/

Re: [sqlite] Mailing list shutting down...

olves a different problem from the one we are having. -- 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] Mailing list shutting down...

On 6/13/18, Tim Streater wrote: > Personally I'd be loath to see this list moved to a web page, for > instance. We invite you to submit working code that implements your desired solution. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite

[sqlite] Mailing list shutting down...

individual, apparently to harass them. I have already suspended new subscriptions. Existing subscribers will be able to continue using this list until I come up with a replacement (or a fix to the current problem) but no new subscribers will be accepted. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Possible Input Parser Issue Inf How to convert SQL file into database when a column value is Inf?

On 6/12/18, Keith Medcalf wrote: > > The tip of trunk also does not parse "Inf" or "-Inf" floating point values Maybe use 1e999 and -1e999 instead? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-use

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

On 6/11/18, Lonnie Abelbeck wrote: > >> On Jun 11, 2018, at 7:23 AM, Richard Hipp wrote: >> >> On 6/11/18, Lonnie Abelbeck wrote: >>> >>> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in >>> library >>> file

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

On 6/11/18, Richard Hipp wrote: > On 6/11/18, Lonnie Abelbeck wrote: >> >> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in >> library >> file size? >> > > See Dan's follow-up. Beginning with 3.24.0, the FTS5 and JSON1 > extensions

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

ure to turn off those two features. You ought to be able to do "./configure --disable-fts5 --disable-json1" but those two --disable options appear to be broken in the ./configure script. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Checking for errors in sqlite3_column_*

potentially odd that many other > threads got replies but this didn’t. I clearly need to update the documentation. It is on my to-do list. That will be a big project. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

e only compile time option is -DSQLITE_ENABLE_COLUMN_METADATA > > Ref: > https://github.com/astlinux-project/astlinux/blob/master/package/sqlite/sqlite.mk > > I have looked as Richard's thread "[sqlite] Size of the SQLite library > Richard Hipp", but this seems much more tha

Re: [sqlite] Can't clone SQLite repository

On 6/9/18, Brian Nguyen wrote: > Lately it seems that I can't clone the official SQLite repository Permissions adjusted. Please try again. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] [EXTERNAL] Selecting multiple similar columnname.

does *not* work for ordinary tables. -- 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.org website is now HTTPS-only

docsrc/file/misc/althttpd.c https://www.sqlite.org/docsrc/file/misc/althttpd.md Earlier today, I enhanced althttpd.c with the ability to cause redirects from http: to https:. I enabled that capability on www.sqlite.org as a test. That is the main point of this exercise. -- D. Richard

[sqlite] sqlite.org website is now HTTPS-only

As an experiment, I have reconfigured the sqlite.org website to redirect all HTTP requests over to HTTPS. Let me know if this causes anybody any unnecessary grief. It is easy enough to undo the setting. -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] Trigger behaviour on UPDATE after release 3.24.0

page back to disk if there are actual byte changes. Triggers continue to fire as they always have. There is no change in behavior. This is a performance optimization only. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] Filename encoding on Unix platforms

hat Qt or other libraries expect seems to be irrelevant. Beyond that, I don't really understand what problem you are having??? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/

Re: [sqlite] Size of the SQLite library

ecently been allowing new features to start creeping into the core. Size is still important. But having useful features is important too. I'm continuing to work to find the right balance between these competing goals. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Size of the SQLite library

189 bytes using gcc-7 -Os -m32. -- 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] Size of the SQLite library

s than 500,000 bytes. For this reason, I will probably change the size bullet point to say "less than 500 kibibytes (KiB)" or "less than 0.5 mebibytes (MiB)", as "less than 600KB" does not have quite the same emotional impact. You will notice that the graph linked above

[sqlite] SQLite is a LoC Preferred Format for datasets

Thanks to Simon Willison for pointing out that SQLite is a Preferred Format for datasets according to the US Library of Congress. https://simonwillison.net/2018/May/28/library-of-congress/ -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

[sqlite] Version 3.24.0 feature freeze

ts/324/index). The release will occur when this checklist goes all-green. -- 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] Database file with a nonstandard sqlite_seuence schema causes crash.

b > SQLite version 3.24.0 2018-05-18 17:58:33 > Enter ".help" for usage hints. > sqlite> INSERT INTO ttt(data) VALUES('xx'); > -- 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] ALTER TABLE

ime. What kind of MODIFY COLUMN changes do you have in mind? -- 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] LIMIT with OFFSET is not working in android platform

= -O0 > > LOCAL_CPPFLAGS += -O0 Looks like you have found a bug in clang. I recommend updating to the latest version of the compiler that you can get your hands on, and see if that doesn't fix the problem. Running SQLite with compiler optimizations off will make it slower. -- D

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

CREATE TABLE ttt(id INTEGER PRIMARY KEY AUTOINCREMENT, data TEXT); > sqlite> .exit > > C:\test>sqlite3 test.db > SQLite version 3.24.0 2018-05-18 17:58:33 > Enter ".help" for usage hints. > sqlite> INSERT INTO ttt(data) VALUES('xx'); > -- D. Richard Hipp d.

Re: [sqlite] Is VACUUM ANALYZE removed?

t anything following the VACUUM was a syntax error, but the engine did not enforce that restriction. That bug was fixed in 3.15.0. Beginning with 3.15.0, if anything comes after the VACUUM verb, it must be the name one of the ATTACH-ed databases that is to be vacuumed. --

Re: [sqlite] Open and query sqlite db in a buffer

3_open(":memory:", ) and then do the sqlite3_deserialize(). -- 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] LIMIT with OFFSET is not working in android platform

gt; there any difference in compiling sqlite using gradle and via ndk-build via > terminal ? Try building with compiler optimizations disabled (-O0) and see if that makes a difference. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Thoughts about the sqlite3IntFloatCompare function from the vdbeaux.c file.

g r to y, so the condition on line 15 would be unnecessary. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.o

Re: [sqlite] After update from 3.20 to 3.23 alter table throws error for boolean with default value FALSE

eding to put it in quotes? There was a bug in an historical version of SQLite. We have to continue to support that buggy behavior. Otherwise, if you try to open a legacy database file with a newer version of SQLite it might report the legacy database is "corrupt".

Re: [sqlite] After update from 3.20 to 3.23 alter table throws error for boolean with default value FALSE

e to function as they always have. There are about 1 trillion SQLite database files in circulation. For that reason, we work very hard to avoid causing problem for those legacy database files as we enhance SQLite, or as we fix historical bugs. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] www3.sqlite.org ssl certificate expired

tart the webserver to get it to recognize the new cert, and that was not automatic. -- 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] LIMIT with OFFSET is not working in android platform

On 5/16/18, Sathish Kumar <connect.s...@gmail.com> wrote: > Samsung S9 device with Android 8.0 What output do you see from the following commands: SELECT sqlite_source_id(); PRAGMA compile_options; -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] LIMIT with OFFSET is not working in android platform

On 5/16/18, Sathish Kumar <connect.s...@gmail.com> wrote: > I just skipped those statements in mail, but i inserted 7 rows. Please send *exactly* the sequence of commands that you think are producing an incorrect answer. Please leave nothing to chance, or to interpretation. -- D. Ric

Re: [sqlite] query planning - covering indices

nce of the first index. A better approach here would be to make the PRIMARY KEY a true PRIMARY KEY, and not just an alias for a UNIQUE constraint, but adding WITHOUT ROWID to the end of the CREATE TABLE statement. The PRIMARY KEY on a WITHOUT ROWID table is always a covering index (even though the EX

Re: [sqlite] LIMIT with OFFSET is not working in android platform

(name) values('a'); > sqlite> select count(*) from test; > 7 How is it that you have 7 rows in the table after only doing 2 INSERTs? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mai

Re: [sqlite] Weird query plan when sorting by a joined column

n > which is why I kept the statistics in the example SQL. Can you please send the output of ".fullschema" so that I can try to reproduce your problem? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-use

Re: [sqlite] LIMIT with OFFSET is not working in android platform

> 6. > > [ Actual Result ] : It always returns rows starting from index 2, even > though it had enough rows in the table. (Please see the below example, it > has all the informations). Unable to reproduce the problem. The example text came through garble

Re: [sqlite] Stored Procedures

rements. Where there any actual measurements in the Mozilla article? It is quite old and I haven't read it in years, but I don't recall there being any. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.

Re: [sqlite] Stored Procedures

nfs.html -- 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] Multi threaded readers on memory sqlite cannot scale

gt; SQLite won't copy data but use provided buffer so you won't have N > copies of databse. +1 This seems like the best solution proposed so far. I wish I had been the one to think of it :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Again sqlite repository servers out of sync ?

th a version that did not have SSL built-in so the syncs started failing. Fixed now. -- 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] Web hosting and perl DBD::SQLite?

On 5/11/18, Jim Dodgen <j...@dodgen.us> wrote: > Any VPSes you suggest? Linode.com -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listin

Re: [sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

nd/or correlated subqueries. -- 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] fail building snapshot 201805081303

On 5/11/18, Charles Leifer <colei...@gmail.com> wrote: > Try specifying "-lm" flag to include math library. The configure script does that automatically. https://www.sqlite.org/src/artifact/5f6cf281ae675685?ln=121 -- D. Richard H

Re: [sqlite] fail building snapshot 201805081303

icci (FI) Italy > > *direct phone:* +39 055 735 0230 *| Fax:* +39 055 735 6235 > > *web site:* www.powersoft.it <http://www.powersoft.it> > > Green Audio Power > > ___ > sqlite-users mailing l

Re: [sqlite] Typo in documentation for .sha3sum CLI command

"sha3-255" should be "sha3-256". The command recognizes the latter but not > the former. > > Best, > Aaron > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org

Re: [sqlite] '.open' without args crashes shell

__ > 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] 3.24 draft - upsert

ot failed, add the special > "excluded." table qualifier to the column name." > > Why using 'excluded' wording for this? Because that is what PostgreSQL does. I also thought that "new" would have been a better choice, but they

[sqlite] Enhanced command-line shells for SQLite. Was: Stored Procedures

ne applications in the same way. I eagerly wait to see what y'all come up with! -- 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] Stored Procedures

all have to work out the operating themselves (some of them perhaps incorrectly). The usual way of handling that in SQLite is to store a script in a text column someplace, then execute them as needed. SQLite began life as a TCL extension, and so naturally TCL scripts work ver

Re: [sqlite] Question about sqlite3_prepare vs sqlite3_prepare_v2

> > Thanks so much for the wonderful library. > > Charlie > _______ > 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] About storage of large amounts of image data

rvades the code. Changing the compile-time option will get you as far as 2GB. After that, code changes (and associated slowdowns for people who use more reasonably-sized rows) will be needed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

"unable to open > database file". The argument to sqlite3_open() need to be UTF-8. What encoding are you using? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] About storage of large amounts of image data

. Short answer: Faster with SQLite. However, as the size of the image increases, the filesystem gets faster than SQLite. (Conversely, for smaller blobs, SQLite is much faster and more efficient than the filesystem.) So performance will depend to some extent on the size of your images.

[sqlite] Lots of enhancements coming to version 3.24.0 - please test

applications is greatly appreciated. Please consider downloading the latest pre-release snapshot (https://www.sqlite.org/download.html) and giving it a whirl. Report any problems or concerns to this mailing list, or directly to me. Thanks. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite3 fossil repository problem solved

On 5/8/18, Domingo Alvarez Duarte <mingo...@gmail.com> wrote: > > Still it seems that there is more than one fossil server and they seem > to lag from the main one. > There are three. They sync with each other hourly, via cron job. -- D. Richard Hi

Re: [sqlite] This list is getting spammed again

On 5/8/18, John Long <codeb...@inbox.lv> wrote: > > So I guess it is up to all the list owners to obfuscate posters' email > addresses appropriately? We tried that once before. People hated it. The consensus at that time was that people would rather just deal with the spam. --

Re: [sqlite] Fossil Delta Compression in SqLite

s > > _______ > 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] possible bug affecting 3.22 and 3.23 - load_extension()

____ > 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] Fossil Delta Compression in SqLite

it without being bound by > the BSD license? Does it matter whether the code is public domain or two-clause BSD? There are no restrictions on its use in either case, are there? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sq

Re: [sqlite] Row count of a partial index ?

ot; > clause is on the index has some race conditions attached. Solvable... but if > there is a direct way, I'd prefer that. Otherwise no big deal. There is some unsupported trickery involving SQLITE_TESTCTRL_IMPOSTER, but extracting the WHERE clause from the sqlite_master table seems safer

Re: [sqlite] Memory leak in csv.c virtual table module

732e2=102-106 > > Hence no file open, no file handle, no buffer freed, memory leak. > > Ralf > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/

Re: [sqlite] 'replace ... do update...' crash

_ > 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] UPSERT available in pre-release

.com/fwlink/?LinkId=550986> for Windows > 10 > > > > > From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf > of Richard Hipp <d...@sqlite.org> > Sent: Thursday, April 19, 2018 6:29:55 PM > To: G

Re: [sqlite] UPSERT available in pre-release

hat's a good testing idea. Thank you. I will make a similar change and investigate the cause of the slowdown, and hopefully fix 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] UPSERT available in pre-release

On 4/19/18, Petite Abeille <petite.abei...@gmail.com> wrote: > > >> On Apr 19, 2018, at 12:29 PM, Richard Hipp <d...@sqlite.org> wrote: >> >> The latest pre-release snapshot [1] > > Link missing? [1] https://sqlite.org/download.html > >> cont

[sqlite] UPSERT available in pre-release

The latest pre-release snapshot [1] contains support for UPSERT following the PostgreSQL syntax. The documentation is still pending. Nevertheless, early feedback is welcomed. You can respond either to this mailing list, or directly to me. -- D. Richard Hipp d...@sqlite.org

[sqlite] JDBC driver experience

for avoiding problems in this driver? -- 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] Are you getting spam when you post to sqlite-users ?

the spam, because all my email goes through the machine doing the blocking - sqlite.org. Unfortunately, the email for the other 2000+ people on this mail list goes through different servers which are not blocking the misbehaving IP address, and so they are sti

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

Can you forward at least the header to me, please? On 4/18/18, David Raymond <david.raym...@tomtom.com> wrote: > Just got my first one after my last post. > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behal

Re: [sqlite] crash dropping table

rom z; > drop x; << crashes here Can you send in a reproducible test case? -- 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] Any operation to trigger osMunmap?

n nFetchOut back to 0 but I do not know > what operation may trigger that. I think sqlite3_close() or pragma mmap_size are the only ways to do that. Note that the PSS increase is not actually a memory leak. That it is reported as a leak is a issue in Mem-Anal

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

eted range of IP addresses. -- 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] Changes on sqlite3 parser and why not ?

vide an example? -- 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] Are you getting spam when you post to sqlite-users ?

..@gmail.com, but then they turn around and send spam replies using w...@evil.com, how am I suppose to make the connection between these two addresses? I can set the list serve to obscure sender emails. We tried that once before, you might recall, and it did not go well. -- D. Richard Hipp d..

Re: [sqlite] kooky thought: a vm-only build (for embedded). feasible?

al table in the database file. The application would then use a special API that would deserialize a prepared statement (identified by a well-known integer) then bind parameters and run it. So much has changed in the SQLite bytecode engine since then that there is basically zero chance that SSE

Re: [sqlite] what sqlite3_memory_used mean？？

can"t understand why > > what sqlite3_memory_used mean ? > > > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > sqlite-users mailing list > sqlite-users@mailingli

Re: [sqlite] Documentation Typo : https://sqlite.org/optoverview.html section 15

__ > 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] SELECT with CASE

able which is equal to the date('now') then it should return the > date('now','+1 day'). ... COALESCE((SELECT thedate FROM dates WHERE thedate==date('now')), date('now','+1 day')) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sq

Re: [sqlite] memory leak?

to the operating system. Usually free() will keep that memory around to be reused for the next malloc() request. I think you are seeing the memory that free() has kept back for reuse. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sq

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