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

[whatwg] SQL API + access to tables

From: Aaron Boodman <aa@google.com>
Date: Sat, 20 Oct 2007 19:44:47 -0700
Message-ID: <278fd46c0710201944i545c8a4esecffc7b0a0543107@mail.gmail.com>
On 10/19/07, Brady Eidson <beidson at apple.com> wrote:
> In fact, we plan to disallow access to the
> sqlite_master table because there's no reason the client *should* be
> able to access such an implementation specific field that has nothing
> to do with "client side database storage"

Not really my business, but this seems like a bad idea. Applications
built on top of WebKit with SQLite are already tightly coupled to the
SQLite dialect. If such applications wanted to port to another
database engine, accessing sqlite_master would be the least of their
problems. SQLite's datatypes, for example, are different than those in
other database implementations.

Being able to introspect the database is a valuable feature. Sure it
is not best-practice, but in some cases, such as tools, it can be

- a
Received on Saturday, 20 October 2007 19:44:47 UTC

This archive was generated by hypermail 2.4.0 : Wednesday, 22 January 2020 16:58:58 UTC