W3C home > Mailing lists > Public > whatwg@whatwg.org > October 2007

[whatwg] SQL API + access to tables

From: Leons Petrazickis <leons.petrazickis@gmail.com>
Date: Sat, 20 Oct 2007 12:29:24 -0400
Message-ID: <5b04ec2d0710200929k545a69f3s48be68c92fd07150@mail.gmail.com>
You need the ability to list tables for integration with tools such as
Firebug. Apple is adding table introspection to Safari's equivalent of
Firebug. How should Firebug or some other third-party tool achieve it?

Regards,

Leons Petrazickis
http://lpetr.org/blog/


On 10/20/07, K?i?tof ?elechovski <giecrilj at stegny.2a.pl> wrote:
> To achieve what?  To make spying and breaking easier?  The developer should
> know the structure of the database in advance; making such guesswork in
> production code on the end user's machine is at least inappropriate.
> Also, if we agreed to that, this would be a workaround for a supposed
> deficiency of SQL.  But the SQL committee does not recognize it as a
> deficiency; otherwise it would have been fixed by now.
> Best regards,
> Chris
>
> -----Original Message-----
> From: whatwg-bounces at lists.whatwg.org
> [mailto:whatwg-bounces at lists.whatwg.org] On Behalf Of Brady Eidson
> Sent: Saturday, October 20, 2007 3:14 AM
> To: WHATWG Mailing List
> Subject: [whatwg] SQL API + access to tables
>
> There is no standard way in SQL that I know of to get the list of
> tables in a database.
>
> In SQLite you can enumerate tables out of sqlite_master, but that
> should not be encouraged.
>
> What are people's thoughts about adding this to the API?
>
> ~Brady
>
>
>
Received on Saturday, 20 October 2007 09:29:24 UTC

This archive was generated by hypermail 2.3.1 : Monday, 13 April 2015 23:08:37 UTC