Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-18 Thread Simon Slavin
On 18 Jun 2013, at 9:39pm, Stephen Chrzanowski wrote: > Just out of curiosity, either by including it as another SQLite built in > table, or, a user added table after the fact, couldn't a relationship be > built between the new table and a comment, or a field in a table and > comment be made?

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-18 Thread Stephen Chrzanowski
Just out of curiosity, either by including it as another SQLite built in table, or, a user added table after the fact, couldn't a relationship be built between the new table and a comment, or a field in a table and comment be made? So for example (A very VERY loose example) create table sqlite_c

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-18 Thread Klaas V
Dear fellow users and managers of SQLite, Alexey Pechnikov wrote: >Bad idea. The schema definition can't be modified! In fact it's possible if you use the writable schema pragma http://www.sqlite.org/pragma.html#pragma_writable_schema An application could drop all applicable `ls -l` and `id -P`

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-18 Thread Alexey Pechnikov
Hello! > Roman Fleysher Mon, 17 Jun 2013 09:14:59 -0700 > ... However, I do not understand why new > functionality of SQLite is needed. Why can't the mapper use a special table of > three columns (I will use example from Alexey): We can replace the "drop column" functionality by easy SQL script

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-17 Thread Petite Abeille
On Jun 17, 2013, at 6:14 PM, Roman Fleysher wrote: > Dear SQLiters, First thing first… don't hijack a thread… instead start a new one, with a new subject. > Can someone recommend an ORM? No. > What are the pros and cons of using them? http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-17 Thread Roman Fleysher
__ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Alexey Pechnikov [pechni...@mobigroup.ru] Sent: Friday, June 14, 2013 12:47 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Feature request: add support for COMMENT statement Hello!

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-15 Thread Alexey Pechnikov
Hello! > Suppose you have it. What would you do with it? > What's the use case? > --> Igor Tandetnik The COMMENTs can be used to store any information for interchanging with application and external systems. As example, ORM (object relational mappers) may need some additional metainfo for all m

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Roger
] Feature request: add support for COMMENT statement Alexey Pechnikov wrote: It's very important to have place to store table metainformation. In all common DBMSs we can use TABLE/COLUMN COMMENT as meta description of table but SQLite doesn't support it. SQLite saves comments in table/

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Igor Tandetnik
On 6/14/2013 10:17 AM, Finn Wilcox wrote: Yes but it is defined once-per-file instead of once-per-table. "we've found that the use of a single place to store our version number makes the checking much easier." -- Igor Tandetnik ___ sqlite-users mai

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Dave Wellman
-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch Sent: 14 June 2013 15:21 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Feature request: add support for COMMENT statement Alexey Pechnikov wrote: > It's very important to have place to store table metainformation. In > all comm

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Clemens Ladisch
Alexey Pechnikov wrote: > It's very important to have place to store table metainformation. In all > common DBMSs we can use TABLE/COLUMN COMMENT as meta description of table > but SQLite doesn't support it. SQLite saves comments in table/view/index/trigger definitions: sqlite> create table t(x /

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Finn Wilcox
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/06/2013 15:03, Igor Tandetnik wrote: > On 6/14/2013 9:59 AM, Dave Wellman wrote: >> We use a COMMENT to store information about the version of our >> tables that are in place on the customer system. > > PRAGMA user_version is intended for this v

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Igor Tandetnik
On 6/14/2013 9:59 AM, Dave Wellman wrote: We use a COMMENT to store information about the version of our tables that are in place on the customer system. PRAGMA user_version is intended for this very purpose. -- Igor Tandetnik ___ sqlite-users mailin

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Dave Wellman
3917021 Registered in England and Wales. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: 14 June 2013 14:37 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Feature request: add support for COMMENT stateme

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Igor Tandetnik
On 6/13/2013 10:23 AM, Alexey Pechnikov wrote: It's very important to have place to store table metainformation. You are the first person in years who asked for it, so it's probably not *that* important. In all common DBMSs we can use TABLE/COLUMN COMMENT as meta description of table but SQ

[sqlite] Feature request: add support for COMMENT statement

2013-06-14 Thread Alexey Pechnikov
Hello! It's very important to have place to store table metainformation. In all common DBMSs we can use TABLE/COLUMN COMMENT as meta description of table but SQLite doesn't support it. COMMENTs are supported from very old to new PostgreSQL: http://www.postgresql.org/docs/7.1/static/sql-comment.ht