/lists.whatwg.org/pipermail/whatwg-whatwg.org/2007-October/055105.html

https://github.com/whatwg/whatwg.org · HTML · 80 lines · 69 code · 4 blank · 7 comment · 0 complexity · 22d5c70ff7404f6f0319925a6f7461c8 MD5 · raw file 

    

  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    2. 

  2. <HTML>
    3. 

  3.  <HEAD>
    4. 

  4.    <TITLE> [whatwg] SQL API + access to tables
    5. 

  5.    </TITLE>
    6. 

  6.    <LINK REL="Index" HREF="index.html" >
    7. 

  7.    <LINK REL="made" HREF="mailto:whatwg%40lists.whatwg.org?Subject=Re%3A%20%5Bwhatwg%5D%20SQL%20API%20%2B%20access%20to%20tables&In-Reply-To=%3C696e4b7c0710192008q25c3c250v74d8d57d562087%40mail.gmail.com%3E">
    8. 

  8.    <META NAME="robots" CONTENT="index,nofollow">
    9. 

  9.    <style type="text/css">
    10. 

  10.        pre {
    11. 

  11.            white-space: pre-wrap;       /* css-2.1, curent FF, Opera, Safari */
    12. 

  12.            }
    13. 

  13.    </style>
    14. 

  14.    <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
    15. 

  15.    <LINK REL="Previous"  HREF="055104.html">
    16. 

  16.    <LINK REL="Next"  HREF="055106.html">
    17. 

  17.  </HEAD>
    18. 

  18.  <BODY BGCOLOR="#ffffff">
    19. 

  19.    <H1>[whatwg] SQL API + access to tables</H1>
    20. 

  20. <!--htdig_noindex-->
    21. 

  21.     <B>Scott Hess</B> 
    22. 

  22.     <A HREF="mailto:whatwg%40lists.whatwg.org?Subject=Re%3A%20%5Bwhatwg%5D%20SQL%20API%20%2B%20access%20to%20tables&In-Reply-To=%3C696e4b7c0710192008q25c3c250v74d8d57d562087%40mail.gmail.com%3E"
    23. 

  23.        TITLE="[whatwg] SQL API + access to tables">shess at google.com
    24. 

  24.        </A><BR>
    25. 

  25.     <I>Fri Oct 19 20:08:17 PDT 2007</I>
    26. 

  26.     <P><UL>
    27. 

  27.         <LI>Previous message: <A HREF="055104.html">[whatwg] SQL API + access to tables
    28. 

  28. </A></li>
    29. 

  29.         <LI>Next message: <A HREF="055106.html">[whatwg] SQL API + access to tables
    30. 

  30. </A></li>
    31. 

  31.          <LI> <B>Messages sorted by:</B> 
    32. 

  32.               <a href="date.html#55105">[ date ]</a>
    33. 

  33.               <a href="thread.html#55105">[ thread ]</a>
    34. 

  34.               <a href="subject.html#55105">[ subject ]</a>
    35. 

  35.               <a href="author.html#55105">[ author ]</a>
    36. 

  36.          </LI>
    37. 

  37.        </UL>
    38. 

  38.     <HR>  
    39. 

  39. <!--/htdig_noindex-->
    40. 

  40. <!--beginarticle-->
    41. 

  41. <PRE>On 10/19/07, Brady Eidson &lt;<A HREF="http://lists.whatwg.org/listinfo.cgi/whatwg-whatwg.org">beidson at apple.com</A>&gt; wrote:
    42. 

  42. &gt;<i> There is no standard way in SQL that I know of to get the list of
    43. 

  43. </I>&gt;<i> tables in a database.
    44. 

  44. </I>&gt;<i>
    45. 

  45. </I>&gt;<i> In SQLite you can enumerate tables out of sqlite_master, but that
    46. 

  46. </I>&gt;<i> should not be encouraged.
    47. 

  47. </I>&gt;<i>
    48. 

  48. </I>&gt;<i> What are people's thoughts about adding this to the API?
    49. 

  49. </I>
    50. 

  50. This seems way beyond where this spec should go.  If SQLite doesn't
    51. 

  51. have a way to enumerate tables which can be encouraged, a way should
    52. 

  52. be added to SQLite (I've considered building some introspection
    53. 

  53. virtual tables for this kind of thing).
    54. 

  54. 

  55. -scott
    56. 

  56. 

  57. </PRE>
    58. 

  58. 

  59. <!--endarticle-->
    60. 

  60. <!--htdig_noindex-->
    61. 

  61.     <HR>
    62. 

  62.     <P><UL>
    63. 

  63.         <!--threads-->
    64. 

  64. 	<LI>Previous message: <A HREF="055104.html">[whatwg] SQL API + access to tables
    65. 

  65. </A></li>
    66. 

  66. 	<LI>Next message: <A HREF="055106.html">[whatwg] SQL API + access to tables
    67. 

  67. </A></li>
    68. 

  68.          <LI> <B>Messages sorted by:</B> 
    69. 

  69.               <a href="date.html#55105">[ date ]</a>
    70. 

  70.               <a href="thread.html#55105">[ thread ]</a>
    71. 

  71.               <a href="subject.html#55105">[ subject ]</a>
    72. 

  72.               <a href="author.html#55105">[ author ]</a>
    73. 

  73.          </LI>
    74. 

  74.        </UL>
    75. 

  75. 

  76. <hr>
    77. 

  77. <a href="http://lists.whatwg.org/listinfo.cgi/whatwg-whatwg.org">More information about the whatwg
    78. 

  78. mailing list</a><br>
    79. 

  79. <!--/htdig_noindex-->
    80. 

  80. </body></html>
    81.