Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Just wanted to share my experience as it might be relevant. We have (tried) to develop an iPad based web app that needs to store 1000's of images and files (such as presentations and word documents)</p> <p>A mock up on Windows (Safari 4 &amp; 5) can import images encoded as base64 into a Web SQL database (blob field) and displaying them using a db callback to set the source of image tags like <code>src="data:image/jpeg;base64,...base65encimagedata..."</code></p> <p>Other files (doc, ppt, pdf) had to be uploaded using the offline cache / manifest. Even though we can get them into a database as base64, there was no way to view them.</p> <p>Now the problem... Desktop Safari lets you create a large SQL database (I did 1 Gig imported 3000 images.) and has not imposed a known limit on the offline cache.</p> <p>However on the iPad things are less useful because I cannot create a database more then 50Mb, plus the 5Mb cache limit.</p> <p>Some alternatives (I have not tried them yet) have been:</p> <ol> <li>Try Opera Mini (or other available browsers) on the iPad </li> <li>I know Google Chrome (which uses webkit) has a limit on its SQL database size, but you can 'patch it' ( <a href="https://groups.google.com/a/chromium.org/group/chromium-html5/browse_thread/thread/8672b2e0cd69a9f7/ebf17070d32c1168?lnk=gst&amp;q=database+size#ebf17070d32c1168" rel="noreferrer">https://groups.google.com/a/chromium.org/group/chromium-html5/browse_thread/thread/8672b2e0cd69a9f7/ebf17070d32c1168?lnk=gst&amp;q=database+size#ebf17070d32c1168</a>) with some SQL to increase its size. Maybe this can be done on the iPad somehow.</li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POUsing HTML5 web database to store files for offline access
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USYi Jiang
    1. USGary
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsing HTML5 web database to store files for offline access
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIn summary, it's not possible (at least currently). For my particular project it's looking like writing a thin app around an UIWebView that pulls the content to the iPad's file system then displays it.
      singulars
      1. PO
      1. USandybee
 

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