Databases
StackOverflow2013
Postsdbo
POTitanium SQLite: Database pseudo array
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTitanium SQLite: Database pseudo array
    primarykey
    data
    text
    <p>I have a working app that needs to store up to 4 matrixes of integer data per record. I'm not sure how to get there with Titanium and SQlite.</p> <p>A record will contain at least 1 but up to 4 matrixes of integers:</p> <p>The matrix size is variable, each matrix consists of:</p> <p>1 - 20 rows with 3 columns per row</p> <p>OR</p> <p>1 - 20 rows with 6 columns per row</p> <p>The matrix structure will be identical for each record, i.e. 3 3x20 matrixes in a record or 4 6x10 matrixes in a record. At this point my app starts, allows the user to choose the matrix parameters then accepts the data entry to fill in the matrix values. The matrixes are actually an JS array of arrays. How can I store an array of arrays and read it back in when I need to?</p> <p>Edit: Let me see if I can clarify...</p> <p>The app I'm working on is a scorecard for archery tournaments, similar in concept to a scorecard in golf. In archery you shoot for a set number of ends with a set number of arrows shot per end. The app asks for the number of ends (up to 20) and the number of arrows shot per end (3 or 6). After each shot the archer enters the score (an integer value). so for argument's sake say we're scoring for three ends with three arrows per end. We might see something like this:</p> <pre><code>arrow scores 8 8 9 (end 1) 7 9 10 (end 2) 9 9 10 (end 3) </code></pre> <p>There's my matrix that I need to save for this individual record. However, the next tournament I need to score may have a different number of ends and arrows:</p> <pre><code>arrow scores 7 8 9 10 10 10 (end 1) 10 9 9 7 8 10 (end 2) 9 6 6 6 9 9 (end 3) 7 8 6 7 8 8 (end 4) 10 10 9 8 8 8 (end 5) </code></pre> <p>Let's simplify and say that I want to store the scorecard for one archer per record. I already have my data entry and score tabulation working. I just don't understand the best way to store matrices as illustrated above. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJocala
    1. USJocala
    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
    1. VO
      singulars
      1. POTitanium SQLite: Database pseudo array
      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