On [Fri, 10.12.2010 06:17], Richard Hipp wrote:
> On Fri, Dec 10, 2010 at 4:54 AM, Jan wrote:
>
> >
> >
> > Am 08.12.2010 20:44, schrieb Richard Hipp:
> > > Now that foreign key constraints are enforced natively, why would you
> > want
> > > to have a list of them? Why should the foreign_key_lis
On 12/10/10 10:36 AM, "Petite Abeille" wrote:
On Dec 10, 2010, at 12:17 PM, Richard Hipp wrote:
> I relented on this two days ago. See
> http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version
> 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh)
Much excellent
On Dec 10, 2010, at 12:17 PM, Richard Hipp wrote:
> I relented on this two days ago. See
> http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version
> 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh)
Much excellent. Thanks :)
___
Am 10.12.2010 12:17, schrieb Richard Hipp:
> I relented on this two days ago. See
> http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version
> 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh)
That is great! Thanks a lot. Guess you saved many people from a *sig
On Fri, Dec 10, 2010 at 4:54 AM, Jan wrote:
>
>
> Am 08.12.2010 20:44, schrieb Richard Hipp:
> > Now that foreign key constraints are enforced natively, why would you
> want
> > to have a list of them? Why should the foreign_key_list pragma continue
> to
> > consume code space and developer main
Am 08.12.2010 20:44, schrieb Richard Hipp:
> Now that foreign key constraints are enforced natively, why would you want
> to have a list of them? Why should the foreign_key_list pragma continue to
> consume code space and developer maintenance time?
Was this only a rhetorical question?
Or is th
Richard,
On 12/8/10 11:44 AM, "Richard Hipp" wrote:
On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille wrote:
> Hello,
>
> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>
> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>
> Any reason for such deprecation?
>
Now that f
>> The pragma foreign_key_list appears to be deprecated in 3.7.4:
Oh no. That is bad news. Please restore this feature.
> Now that foreign key constraints are enforced natively, why would you want to
> have a list of them? Why should the foreign_key_list pragma continue to
> consume code space
Foreign key information is highly useful in many different ORM systems
in many different languages.
My personal example, the "An ORM for any SQLite database in one line
of code" ORLite module in Perl.
http://search.cpan.org/perldoc?ORLite
It is expected to generate entire class trees for any arb
On Wed, Dec 8, 2010 at 2:44 PM, Richard Hipp wrote:
> On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille
> wrote:
>
>> Hello,
>>
>> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>>
>> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>>
>> Any reason for such deprecation?
>>
On 8 Dec 2010, at 8:03pm, Bogdan Ureche wrote:
> Now that foreign key constraints are enforced natively, why would you want
>
>> to have a list of them? Why should the foreign_key_list pragma continue to
>> consume code space and developer maintenance time?
>
> It would make life easier for de
On 8 December 2010 20:44, Richard Hipp wrote:
> On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille
> wrote:
>
>> Hello,
>>
>> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>>
>> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>>
>> Any reason for such deprecation?
>>
>
> No
That is very bad news ...
My application uses this information e.g. to automatically populate
comboboxes (FKs) etc.
Am 08.12.2010 20:35, schrieb Petite Abeille:
> Hello,
>
> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>
> http://www.sqlite.org/pragma.html#pragma_foreign_key_
On Dec 8, 2010, at 8:44 PM, Richard Hipp wrote:
> Now that foreign key constraints are enforced natively, why would you want
> to have a list of them?
To know what they are. In the same way as there are pragma that list database,
table, column, index, etc...
To paraphrase:
"Now that tables a
Now that foreign key constraints are enforced natively, why would you want
> to have a list of them? Why should the foreign_key_list pragma continue to
> consume code space and developer maintenance time?
>
>
>
It would make life easier for developers of administration tools for SQLite,
for displ
On Dec 8, 2010, at 2:44 PM, Richard Hipp wrote:
> On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille >wrote:
>
>> Hello,
>>
>> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>>
>> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>>
>> Any reason for such deprecation?
>>
>
>
On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille wrote:
> Hello,
>
> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>
> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>
> Any reason for such deprecation?
>
Now that foreign key constraints are enforced natively, why would
Hello,
The pragma foreign_key_list appears to be deprecated in 3.7.4:
http://www.sqlite.org/pragma.html#pragma_foreign_key_list
Any reason for such deprecation?
What's the alternative to that pragma to achieve the same effect?
Thanks in advance.
__
18 matches
Mail list logo
