Re: [sqlite] sqlite4 completion status

2014-01-05 Thread Dan Kennedy
On 01/06/2014 02:27 PM, big stone wrote: Hello, Is there a completion status for the sqlite4 project somewhere ? An estimate Year/Quarter for a first downloadable version ? Currently there is not. Dan. ___ sqlite-users mailing list

[sqlite] sqlite4 completion status

2014-01-05 Thread big stone
Hello, Is there a completion status for the sqlite4 project somewhere ? An estimate Year/Quarter for a first downloadable version ? I don't find that information in http://sqlite.org/src4/doc/trunk/www/index.wiki Regards, ___ sqlite-users mailing list

Re: [sqlite] sqlite3session_changeset API oddity

2014-01-05 Thread Dan Kennedy
On 01/05/2014 11:23 PM, Marco Bambini wrote: I am using sqlite3_changeset API to add undo/redo capabilities to an app. I record sqlite operations and I store all of them in a sqlite3_session object. When I need to UNDO an operation I simply do something like: rc =

Re: [sqlite] RFE: Rename Column

2014-01-05 Thread Simon Slavin
On 5 Jan 2014, at 6:41pm, Petite Abeille wrote: > On Jan 5, 2014, at 6:56 PM, Igor Tandetnik wrote: > >> On 1/4/2014 7:15 PM, Elrond wrote: >>> Short: Could you implement alter table rename column? >> >> The problem would be, what to do with all

Re: [sqlite] RFE: Rename Column

2014-01-05 Thread Igor Tandetnik
On 1/5/2014 1:41 PM, Petite Abeille wrote: On Jan 5, 2014, at 6:56 PM, Igor Tandetnik wrote: On 1/4/2014 7:15 PM, Elrond wrote: Short: Could you implement alter table rename column? The problem would be, what to do with all the indexes, triggers, views and foreign keys

Re: [sqlite] RFE: Rename Column

2014-01-05 Thread Petite Abeille
On Jan 5, 2014, at 6:56 PM, Igor Tandetnik wrote: > On 1/4/2014 7:15 PM, Elrond wrote: >> Short: Could you implement alter table rename column? > > The problem would be, what to do with all the indexes, triggers, views and > foreign keys that reference that column? Sure,

Re: [sqlite] RFE: Rename Column

2014-01-05 Thread Igor Tandetnik
On 1/4/2014 7:15 PM, Elrond wrote: Short: Could you implement alter table rename column? The problem would be, what to do with all the indexes, triggers, views and foreign keys that reference that column? SQLite stores database schema as text, in the form of CREATE... statements. I suspect

[sqlite] RFE: Rename Column

2014-01-05 Thread Elrond
Hi everybody, Short: Could you implement alter table rename column? I know that sqlite does only support a limited subset of SQL. Some subsets have only been added lately, like foreign keys, and can be disabled at compile time to safe space. Renaming a table is already supported, which is

[sqlite] sqlite3session_changeset API oddity

2014-01-05 Thread Marco Bambini
I am using sqlite3_changeset API to add undo/redo capabilities to an app. I record sqlite operations and I store all of them in a sqlite3_session object. When I need to UNDO an operation I simply do something like: rc = sqlite3session_changeset(session, , ); rc =