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?
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
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`
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
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+
__
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!
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
] 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/
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
-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
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 /
-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
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
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
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
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
16 matches
Mail list logo
