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

[whatwg] SQL API + access to tables

From: Timothy Hatcher <timothy@apple.com>
Date: Fri, 19 Oct 2007 21:33:18 -0700
Message-ID: <52479A69-9C93-4C78-B7AA-DAC07C36EEC5@apple.com>
It isn't that useful to get the table list, only for introspection  
would you need it. Most users of the API will know the schema of the  
database, and know the table names they need. It would be useful if  
the SQL back-end did not support CREATE TABLE IF NOT EXISTS. But users  
can just blinding try to create a table and look for any errors about  
it already existing in that case.

Regarding introspection, it would have helped us write the Web  
Inspector feature. We ended up making a special call to get the table  
names.

On Oct 19, 2007, at 6:13 PM, Brady Eidson wrote:

> 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

? Timothy Hatcher


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.whatwg.org/pipermail/whatwg-whatwg.org/attachments/20071019/1938e0d5/attachment.htm>
Received on Friday, 19 October 2007 21:33:18 UTC

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