locked
Listview from Indexeddb RRS feed

All replies

  • If you have a database too big for indexedDB you can store it on a web service.

    You may also consider this: http://timheuer.com/blog/archive/2012/05/20/using-sqlite-in-metro-style-app.aspx

    -Jeff


    Jeff Sanders (MSFT)

    Monday, June 4, 2012 1:07 PM
    Moderator
  • Or use this production ready SQLite wrapper: https://github.com/doo/SQLite3-WinRT

    Listview data source adaptors are currently developed and will be available at the same location later this year.

    Feel free to create a datasource yourself and file a pull request on github :)

    On the other hand, what is considered to be "too big for indexedDB", Jeff?

    Monday, June 4, 2012 1:41 PM
  • Thanks Jeff. Confused a little. I want my app to work completely offline.

    I heard Microsoft is moving away from SQLite. As Phil put it, what is considered to be "too big for indexedDB"?

     
    Wednesday, June 6, 2012 5:42 AM
  • hehe, MSFT was never on SQLite. What they have on the Windows Phone Env is a small version of the MS SQL Server. No such thing on the Windows 8 desktop though, which was kind of surprising to me too in the beginning.

    I then experimented a bit with indexed DB and skipped it, since it could not handle nested indexes (properties of objects stored in the DB) at that time (February). Have never again looked into it but the question remains: How performant is indexdb really?

    Wednesday, June 6, 2012 6:20 AM
  • Hi Ner,

    We all hear things (voices in our heads... bad music).  Did you see any documentation on this? 

    Tim has a blog entry on using SQLLite in C#.  I have not tried in javascript yet (and likely will not have time before next week).

    http://timheuer.com/blog/archive/2012/06/05/howto-video-using-sqlite-in-metro-style-app.aspx

    http://timheuer.com/blog/archive/2012/05/20/using-sqlite-in-metro-style-app.aspx

    As to what is too big for indexedDB.  You will need to do some testing and it will depend on how you use the DB.  It is basically a flat file so you will lose some of the advantages of a 'real' database.  I would say if you are going over 200 MB of storage you should consider something like SQLLite.

    -Jeff


    Jeff Sanders (MSFT)

    Wednesday, June 6, 2012 12:01 PM
    Moderator
  • Hi Phil,

    Valid question on how performant indexeddb is.  I have not seen any measurements but it would be good to see that vs SQL lite and others.  Also see Tim's blogs I referenced above for SQL Lite info.

    -Jeff


    Jeff Sanders (MSFT)

    Wednesday, June 6, 2012 12:03 PM
    Moderator
  • Sorry Jeff if I was wrong about SQLite and thanks for the storage size guidance.

    I shall experiment with both SQLite and Indexeddb. I would like to know if creating a custom data source adapter is the best way to make a listview from SQLite or Indexeddb?

    Thursday, June 7, 2012 8:18 PM