18807 2008-04-29 22:52:20 -0700 Support storing JavaScript objects as BLOB 2023-08-24 03:53:37 -0700 1 1 1 Unclassified WebKit WebCore Misc. 528+ (Nightly build) Mac OS X 10.5 RESOLVED WONTFIX P2 Major --- 0 jayant.b.sai webkit-unassigned annevk ap beidson emacemac7 jayant.b.sai oliver oldest_to_newest 79266 0 jayant.b.sai 2008-04-29 22:52:20 -0700 According to http://www.sqlite.org/datatype3.html, 'BLOB. The value is a blob of data, stored exactly as it was input.'. Currently in WebKit & Safari, the implementation seems to convert the JavaScript object to a string "[object Object]". It would be great if it were possible to store JavaScript objects and JSON objects within the database as BLOB and as objects and not as string representations. Currently, only a string de/serialization would work, but that can be expensive, especially when trying to run Safari on iPhone which has very limited JavaScript execution time. 79267 1 20897 jayant.b.sai 2008-04-29 22:54:26 -0700 Created attachment 20897 Test page A simple test page showing storing an object literal as BLOB. Currently the alert displays the type of data after SELECT as string. 79693 2 ap 2008-05-05 12:02:36 -0700 SQLite documentation is only tangentially related to HTML5 storage, because there are at least two other type systems to consider - first, there is JavaScript, and then, there is DOM. And anyway, BLOB is not magic - it's just a special kind of string suitable for storing large amounts of data. Yet, it does seem a little weird that a function is stringified like "[object Object]" in this test case - e.g. alert(selectData) successfully shows its source, and one could expect the same here. 79849 3 jayant.b.sai 2008-05-07 16:23:50 -0700 Thank you for clarifying about the SQLite & HTML5 storage differences. Do you have any recommendations on how I should store the object, without converting it to a String. In my current app, this conversion takes too long. Or is this a bug which will need to be fixed in WebKit? thanks Jayant (In reply to comment #2) > SQLite documentation is only tangentially related to HTML5 storage, because > there are at least two other type systems to consider - first, there is > JavaScript, and then, there is DOM. And anyway, BLOB is not magic - it's just a > special kind of string suitable for storing large amounts of data. > > Yet, it does seem a little weird that a function is stringified like "[object > Object]" in this test case - e.g. alert(selectData) successfully shows its > source, and one could expect the same here. > 80121 4 ap 2008-05-11 03:37:05 -0700 I don't think there is any way to store an object without turning it into a string. You may want to join WHATWG <http://www.whatwg.org/> and describe your use case in an e-mail to its list for people working on the specification to consider it. Brady, what do you think? Does our implicit stringification appear broken, as I wondered in comment 2? 130373 5 oliver 2009-07-07 22:51:15 -0700 JSON.stringify would appear to accomplish what is being requested here 427034 6 oliver 2011-06-24 12:07:49 -0700 (In reply to comment #5) > JSON.stringify would appear to accomplish what is being requested here As an addendum, our postMesage serialisation is a flat binary storage system that supports avariety of dom objects and allows cyclic graphs, maybe that would be superior? 1973246 7 annevk 2023-08-24 03:53:37 -0700 This should be standardized first as suggested above. But also, as suggested above, there's ample alternatives available. 20897 2008-04-29 22:54:26 -0700 2008-04-29 22:54:26 -0700 Test page dbblob.html text/html 1678 jayant.b.sai PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEvL0VOIiAiaHR0cDov L3d3dy53My5vcmcvVFIvaHRtbDQvc3RyaWN0LmR0ZCI+CjxodG1sPgogIDxoZWFkPgogICAgPHRp dGxlPlN0b3JlIEJsb2IgRGF0YWJhc2U8L3RpdGxlPgogICAgPG1ldGEgaHR0cC1lcXVpdj0iY29u dGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPgogICAgPG1ldGEg bmFtZT0idmlld3BvcnQiIGNvbnRlbnQ9Im1pbmltdW0tc2NhbGU9MS4wLCB3aWR0aD1kZXZpY2Ut d2lkdGgsIG1heGltdW0tc2NhbGU9MSwgdXNlci1zY2FsYWJsZT1ubyI+CgogICAgPHNjcmlwdCB0 eXBlPSJ0ZXh0L2phdmFzY3JpcHQiIGNoYXJzZXQ9InV0Zi04Ij4KICAgICAgdmFyIGRiOwoKICAg ICAgZnVuY3Rpb24gbG9hZCgpIHsKICAgICAgICB2YXIgc2hvcnROYW1lID0gJ2RlbW9kYXRhYmFz ZSc7IAogICAgICAgIHZhciB2ZXJzaW9uID0gJzEuMCc7IAogICAgICAgIHZhciBkaXNwbGF5TmFt ZSA9ICdEZW1vIERhdGFiYXNlJzsgCiAgICAgICAgdmFyIG1heFNpemUgPSA2NTUzNjsgLy8gaW4g Ynl0ZXMgCiAgICAgICAgZGIgPSBvcGVuRGF0YWJhc2Uoc2hvcnROYW1lLCB2ZXJzaW9uLCBkaXNw bGF5TmFtZSwgbWF4U2l6ZSk7CiAgICAgICAgCiAgICAgICAgZGIudHJhbnNhY3Rpb24oCiAgICAg ICAgICBmdW5jdGlvbih0cmFuc2FjdGlvbikgewogICAgICAgICAgICB0cmFuc2FjdGlvbi5leGVj dXRlU3FsKCJEUk9QIFRBQkxFIHRlc3QiLCBbXSwgY3JlYXRlVGFibGUsIGNyZWF0ZVRhYmxlKTsK ICAgICAgICAgIH0KICAgICAgICApOwogICAgICB9CiAgICAgIAogICAgICBmdW5jdGlvbiBjcmVh dGVUYWJsZSh0cmFuc2FjdGlvbiwgcmVzdWx0cykgewogICAgICAgIHRyYW5zYWN0aW9uLmV4ZWN1 dGVTcWwoIkNSRUFURSBUQUJMRSB0ZXN0KGRhdGEgQkxPQik7IiwgW10sIGFkZEJsb2JEYXRhLCBl cnJvckhhbmRsZXIpOwogICAgICB9CiAgICAgIAogICAgICBmdW5jdGlvbiBhZGRCbG9iRGF0YSh0 cmFuc2FjdGlvbiwgcmVzdWx0cykgewogICAgICAgIHZhciBkYXRhID0geyBmb286IkZPTyIsIGJh cjoiQkFSIiB9OwogICAgICAgIHRyYW5zYWN0aW9uLmV4ZWN1dGVTcWwoIklOU0VSVCBJTlRPIHRl c3QgVkFMVUVTICg/KSIsIFtkYXRhXSwgc2VsZWN0RGF0YSwgZXJyb3JIYW5kbGVyKTsKICAgICAg fQogICAgICAKICAgICAgZnVuY3Rpb24gc2VsZWN0RGF0YSh0cmFuc2FjdGlvbiwgcmVzdWx0cykg ewogICAgICAgIHRyYW5zYWN0aW9uLmV4ZWN1dGVTcWwoIlNFTEVDVCBkYXRhIEZST00gdGVzdCIs IFtdLCBzaG93UmVzdWx0LCBlcnJvckhhbmRsZXIpOwogICAgICB9CiAgICAgIAogICAgICBmdW5j dGlvbiBzaG93UmVzdWx0KHRyYW5zYWN0aW9uLCByZXN1bHRzKSB7CiAgICAgICAgdmFyIGRhdGEg PSByZXN1bHRzLnJvd3MuaXRlbSgwKS5kYXRhOwogICAgICAgIGFsZXJ0KGRhdGEgKyAiXG4iICsg dHlwZW9mKGRhdGEpKTsKICAgICAgfQogICAgICAKICAgICAgZnVuY3Rpb24gZXJyb3JIYW5kbGVy KHRyYW5zYWN0aW9uLCBlcnJvcikgewogICAgICAgIGFsZXJ0KCJFUlI6ICIgKyBlcnJvci5tZXNz YWdlKTsKICAgICAgfQogICAgPC9zY3JpcHQ+CgogIDwvaGVhZD4KICA8Ym9keSBvbmxvYWQ9Imxv YWQoKTsiPgogIDwvYm9keT4KPC9odG1sPg==