Re: [sqlite] Result set column names

ts.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users It's stated here, at least: <https://www.sqlite.org/c3ref/column_name.html> -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Upgrading from version 3.6.16 to 3.30.1

ite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Search <https://sqlite.org/changes.html> for the words "incompatible" and "legacy", for a start, and review the version history in general.

Re: [sqlite] Test failures on GPFS

on of those test >failures? WAL mode does not work over the network, so the test failures are presumably to be expected. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

On February 1, 2020 10:03:28 a.m. EST, Peng Yu wrote: >But it doesn't explain what is "the temp database". Is it an actual >database file? Or it is just a in-memory database? It depends. See <https://sqlite.org/pragma.html#pragma_temp_store> for details ans links

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

It's a pretty common pattern. Sure, queries that are likely to use very >large IN groups ought to be using carray or intarray but not everyone >knows they exist :) Not everyone has access to carrays and intarrays, either, such as PHP users like myself. -- J. King _

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

; + str.replace("'", "''") + "'" Same here, for what it's worth. Since SQLite also has a 1M byte statement length limit I had my application embed terms once an IN() expression exceeded a certain number of terms, but used parameters always

Re: [sqlite] WITHOUT ROWID tables

@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users CREATE TABLE t( c TEXT DEFAULT 'WITHOUT ROWID' -- this comment mentions something about WITHOUT ROWID ); Contrived, no question, but possible. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

On March 12, 2020 8:06:47 p.m. EDT, Petite Abeille wrote: > >Also, would it be possible to actually mark such emails to include >proper List Header Fields, e.g.: I had the same thought, but would that really be appropriate? Unless you could post to it like a list, anyway. --

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

or UI feedback, and it surprises me continually. So far the SQLite forum seems fine enough to me (though I would have definitely preferred the mailing list continue), and definitely better than Discourse. To each their own, though! -- J. King __

<    1   2