Re: [sqlite] please remove me from this mailing list

Mike, look at the footer of every message to the list including yours. Click the link http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users in that footer; the "listinfo" part might have been a clue. The resulting page has a field you enter your email address in to unsubscribe

Re: [sqlite] please remove me from this mailing list

or tell me how to remove myself On Sat Jun 17 2017 14:04:02 GMT-0500 (Eastern Standard Time), Mike Henry wrote: thanks ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote: > > *) don't appear to be able to keep key in system-provided secure > device/enclave; In their defense, I think this is out-of-scope for a cross-platform db encryption library, as there are so many different APIs for

[sqlite] please remove me from this mailing list

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

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 6/17/2017 10:36 AM, Robert M. Münch wrote: To get a traditional VIEW on this, we want to transpose the data, or create a pivot of it. Here is a pretty simple structure of such a VIEW for the first three columns: For the first three (or any fixed N) columns, yes. But I thought you wanted a

Re: [sqlite] Session Extension & ALTER TABLE handling

On 06/17/2017 08:55 PM, Robert M. Münch wrote: On 17 Jun 2017, at 13:36, Dan Kennedy wrote: I think that changed for ALTER TABLE ADD COLUMN in 3.17.0. As of 3.17, if the changeset contains fewer columns than the database tables it is being applied to, trailing columns are populated with

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 17 Jun 2017, at 14:25, Igor Tandetnik wrote: > By the same token, I don't believe such a query exists. Hi, I think such a query exists, here we go: Columns are: col_id, value, rec_id col-1 1 1 col-1 2 2 col-1 3 3 col-1 4 4 col-1 5 5 col-1 6 6

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Jens Alfke writes: >> And any non-opensource crypto should be taken with triple caution. Or >> even opensource, but not widely-used or otherwise not known to be >> carefully peer-reviewed (FWIW, I looked at e.g. wxsqlite crypto code, it >> looks not exactly promising too). > >

Re: [sqlite] Session Extension & ALTER TABLE handling

On 17 Jun 2017, at 13:36, Dan Kennedy wrote: > I think that changed for ALTER TABLE ADD COLUMN in 3.17.0. As of 3.17, if the > changeset contains fewer columns than the database tables it is being applied > to, trailing columns are populated with their default values. Hi, I tried this but get

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

what does this error mean and how can I fix it?java.sql.SQLException: opening db: './MHDB.db': open failed: EROFS (Read-only file system) On Sat Jun 17 2017 07:17:30 GMT-0500 (Eastern Standard Time), Robert M. Münch wrote: On 17 Jun 2017, at 14:10, Igor Tandetnik

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 6/17/2017 8:17 AM, Robert M. Münch wrote: On 17 Jun 2017, at 14:10, Igor Tandetnik wrote: I don't think so. The number and names of columns in the view are determined at the time CREATE VIEW statement is executed. That won't be a problem as we can update the VIEWs. The question is, how

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 17 Jun 2017, at 14:10, Igor Tandetnik wrote: > I don't think so. The number and names of columns in the view are determined > at the time CREATE VIEW statement is executed. That won't be a problem as we can update the VIEWs. The question is, how does a query look like that transposes the

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 17 Jun 2017, at 9:57, Wout Mertens wrote: > And another option of course is to store all those extra columns as JSON, > which you can query with the JSON1 extension. You can even index on the > extracted values. That's a very interesting idea. I'm going to check it out. So, the idea would be

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 17 Jun 2017, at 9:53, Wout Mertens wrote: > Could you not combine the data on the app side? We are currently holding all data on the app side and want to get it into SQLite to make use of it's querying features. So, that would be a step back. -- Robert M. Münch, CEO M: +41 79 65 11 49 6

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

On 6/17/2017 1:59 AM, Robert M. Münch wrote: Hi, suppose I store my data like this: Table A: table, column, data Now I want to create a VIEW named A.table, with columns A.column and rows A.data Is that possible? I don't think so. The number and names of columns in the view are determined at

Re: [sqlite] Session Extension & ALTER TABLE handling

On 06/17/2017 12:56 PM, Robert M. Münch wrote: Hi, if the DB scheme was changed with ATLER TABLE (like adding a column to a table) it's no longer possible to apply a changeset from before this ALTER TABLE change. I think that changed for ALTER TABLE ADD COLUMN in 3.17.0. As of 3.17, if the

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

And another option of course is to store all those extra columns as JSON, which you can query with the JSON1 extension. You can even index on the extracted values. On Sat, 17 Jun 2017, 9:53 AM Wout Mertens, wrote: > Could you not combine the data on the app side? > > On

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

Could you not combine the data on the app side? On Sat, 17 Jun 2017, 9:15 AM J Decker, wrote: > Probably need to use some CTE expressions to tackle that. > > https://sqlite.org/lang_with.html > > On Fri, Jun 16, 2017 at 10:59 PM, Robert M. Münch < >

Re: [sqlite] Using key/value idea to store data & creating normal table VIEW?

Probably need to use some CTE expressions to tackle that. https://sqlite.org/lang_with.html On Fri, Jun 16, 2017 at 10:59 PM, Robert M. Münch < robert.mue...@saphirion.com> wrote: > Hi, suppose I store my data like this: > > Table A: table, column, data > > Now I want to create a VIEW named