Storage

  • Revision slug: Talk:Storage
  • Revision title: Storage
  • Revision id: 134135
  • Created:
  • Creator: Gary.johnson.53
  • Is current revision? No
  • Comment

Revision Content

With regards to the way the results from queries are returned, wouldn't it be better (and more logical) to mimmick the PHP way of doing this, whereby results are stored in a 2D array/object which is returned? This is, at least, the way I would expect the behaviour to be in JavaScript, rather than a more iterative approach.

I'm also not really sure what the benefit is to having several APIs for running queries. This makes it extremely difficult to create (for example) an SQLite console window in XULRunner, which was a recent experiment of mine. Is it plausible in any way to have a generic "run query and get results, if any" API as a replacement for or in addition to the current APIs?

--BenBasson 15:37, 2 August 2006 (PDT)

Do we need mozIStorageDataSet.idl anymore?

I saw mosIStorageDataSet.idl in the Firefox 2.0 beta 1 source. As far as I can see that interface is not used. Should it be dropped?

-- LeRoyK 14 August 2006

Maybe

The two previous questions are related. I think mozIStorageDataSet was there for returning a big array. It's currently unused, but perhaps we should add this capability. I'm not totally sure what Vlad had in mind for this.

-- Brett Wilson 15 August 2006

Closing Open connection

I don't see a close method to close database connection in mozIStorageConnection interface. Is statement.reset() enough for freeing up the connection ?

-- Saravana 02 December 2006

I do not see many examples

This is a nice "Song Play List" example

I uploaded an annotated example to with all files zipped in TTRW2.zip It is a "Hello World" for extension developers new to MOZSTORAGE Gary.johnson.53 17 April 2007

Revision Source

<p>With regards to the way the results from queries are returned, wouldn't it be better (and more logical) to mimmick the PHP way of doing this, whereby results are stored in a 2D array/object which is returned? This is, at least, the way I would expect the behaviour to be in JavaScript, rather than a more iterative approach.
</p><p>I'm also not really sure what the benefit is to having several APIs for running queries. This makes it extremely difficult to create (for example) an SQLite console window in XULRunner, which was a recent experiment of mine. Is it plausible in any way to have a generic "run query and get results, if any" API as a replacement for or in addition to the current APIs?
</p><p>--<a href="User:BenBasson">BenBasson</a> 15:37, 2 August 2006 (PDT)
</p>
<h3 name="Do_we_need_mozIStorageDataSet.idl_anymore.3F"> Do we need mozIStorageDataSet.idl anymore? </h3>
<p>I saw mosIStorageDataSet.idl in the Firefox 2.0 beta 1 source. As far as I can see  that interface is not used. Should it be dropped?
</p><p>-- LeRoyK 14 August 2006
</p>
<h3 name="Maybe"> Maybe </h3>
<p>The two previous questions are related. I think mozIStorageDataSet was there for returning a big array. It's currently unused, but perhaps we should add this capability. I'm not totally sure what Vlad had in mind for this.
</p><p>-- Brett Wilson 15 August 2006
</p>
<h3 name="Closing_Open_connection"> Closing Open connection </h3>
<p>I don't see a close method to close database connection in mozIStorageConnection interface. Is statement.reset() enough for freeing up the connection ?
</p><p>-- Saravana 02 December 2006
</p>
<h3 name="I_do_not_see_many_examples"> I do not see many examples </h3>
<p><a class="external" href="http://simon-cozens.org/programmer/articles/xul-storage.pod">This is a nice "Song Play List" example</a>
</p><p>I uploaded an annotated example to with all files zipped in TTRW2.zip
It is a "Hello World" for extension developers new to MOZSTORAGE
Gary.johnson.53 17 April 2007
</p>
Revert to this revision