Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>Is it possible to get all the entries "where category = 'Science'", without creating an index on category?</p> </blockquote> <p>Yes: just iterate through the entire object store and manually look for objects with that category. Even if you write some convenience function to do this easily, it'll still be pretty slow compared to using an index. So in practice, you would want to use an index there.</p> <blockquote> <p>Is it possible to get all the entries "where category = 'Science' AND author = 'Albert Einstein'"?</p> </blockquote> <p>Yes, you can use a "compound index" as is described in <a href="https://stackoverflow.com/questions/12084177/in-indexeddb-is-there-a-way-to-make-a-sorted-compound-query">this question here</a>. However, the big caveat is that it's not supported in IE10. If that is a problem for your application, then you can only index on individual fields. For any other constraints besides one indexed field, you'll have to iterate through all the results and manually compare. There are various libraries built on top of IndexedDB that aim to make this easier, but I haven't used any of them so I can't help you there. Either way, it's going to be pretty slow if you can't use compound indexes.</p> <blockquote> <p>Is it possible to get all the entries that contain the word "Lorem" is the content field?</p> </blockquote> <p>You might be noticing a pattern here... Yes: just iterate through the entire object store and manually look for objects with "Lorem" in the content field. There is no special support built in for full text searching. Theoretically one could imagine a full text search API built on top of IndexedDB (just keep track of all the words), but I'm not sure if anyone has built that yet (and if they have built it, I'm not sure how performance would be).</p> <blockquote> <p>Or should I use a different database for these kinds of queries</p> </blockquote> <p>If you need to do a lot of queries like this (or, God forbid, even more complex queries) and you have the option of using a different database, then use a different database. But you might not have that option, depending on what you're trying to accomplish.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I think in "IndexedDB"?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USdumbmatter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I think in "IndexedDB"?
      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. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMy goal was to create a client-side offline app (for personal use so browser compatibility is not an issue), but LocalStorage is too simple, IndexedDB is a pain in the a** to use, and WebSQL doesn't seem to be the ideal solution. Anyway, thank you very much for your answer, it really helped me to understand the philosophy of IndexedDB.
      singulars
      1. PO
      1. USJMaylin
 

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