Databases
StackOverflow2013
Postsdbo
POJavascript JSON data manipulation library
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJavascript JSON data manipulation library
    primarykey
    data
    text
    <p>I'm currently working on a project where I'm dealing with a fair amount of JSON data being transmitted backwards and forwards and stored by the browser as lists of javascript objects. For example:</p> <pre><code>person: { // Primary Key key: "id", // The actual records table: { "1": {id: 1, name: "John", surname: "Smith", age: 26}, "2": {id: 2, name: "Mary", surname: "Brown", age: 19}, // etc.. }, indexes: { // Arrays of pointers to records defined above "name": [ {id: 89, name: "Aaron", surname: "Jones", age: 42}, // etc.. ] } </code></pre> <p>I'm finding myself coding all sorts of indexing and sorting algorithms to efficiently manipulate this data and I'm starting to think that this kind of thing must have been done before.</p> <p>I have experience of using the <a href="http://www.lib.virginia.edu/scripts/yui_ext-1.0.1/docs/output/Ext.data.Store.html" rel="noreferrer">Ext.data.Store</a> and <a href="http://www.lib.virginia.edu/scripts/yui_ext-1.0.1/docs/output/Ext.data.Record.html" rel="noreferrer">Ext.data.Record</a> objects for performing this kind of data manipulation, but I think they are overly complex for junior developers and the project I'm working on is a small mobile application where we cant afford to have a 300K+ library added just for the sake of it, so I need something really minimal.</p> <p>Any ideas if there is a Javascript JSON manipulation framework that has the following:</p> <ol> <li>Can <strong>store</strong>, </li> <li><strong>retrieve</strong>,</li> <li><strong>sort</strong>,</li> <li>and <strong>iterate through</strong> JSON data, </li> <li>with a <strong>clean API</strong>, </li> <li><strong>minimal performance drag</strong> (Mobiles dont have a lot of computing power) </li> <li>and a <strong>small payload that is ideally &lt;10K?</strong></li> </ol> <p>I might be asking for too much, but hopefully someone's used something like this... The kind of thing I'm looking for the is <strong>the JSON equivalent of jQuery</strong>, maybe its not so outlandish.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSteven de Salas
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJavascript JSON data manipulation library
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POJavascript JSON data manipulation library
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJavascript JSON data manipulation library
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload