Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi
    ersaurabh101
    @ersaurabh101
    Hello
    Ujjwal Gupta
    @ujjwalguptaofficial
    What do you mean by user a and user b - do you mean two different device ?
    ersaurabh101
    @ersaurabh101
    no same device, i am checking it on pc
    one thing works for user A but not for user B
    If you want me to show you this strange problem on team viewer or anydesk
    Ujjwal Gupta
    @ujjwalguptaofficial
    have you tried using idbstudio for debugging ?
    ersaurabh101
    @ersaurabh101
    there is no need for that
    command is working fine for user A in page 1 and page 2
    But for user B, it is working in page1 aswell but not in "page2"
    for user B in page 2 it says error type: table_not_exist, remember same command works on page 1 for this same user
    Ujjwal Gupta
    @ujjwalguptaofficial
    what api ?
    select ?
    ersaurabh101
    @ersaurabh101
    yes
    with where
    u want to see on teamviewer
    ?
    Ujjwal Gupta
    @ujjwalguptaofficial
    let's talk private
    ersaurabh101
    @ersaurabh101
    @ujjwalguptaofficial ok
    Rumpelstinsk
    @Rumpelstinsk
    Hi, i'm having some trouble to execute a remove action if there is a boolean column on "where clause". Is it an open bug?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi
    indexeddb does not allow to filter on boolean column
    Rumpelstinsk
    @Rumpelstinsk
    Oks. I will change all the booleans for numbers then
    thanks for the help
    Efrat Messer
    @Efke
    Hello, How can I 'order by' more than one column in a select?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi Efrat
    Ujjwal Gupta
    @ujjwalguptaofficial
    Please add an issue. Currently multiple order by is not supported.
    Efrat Messer
    @Efke
    Thank you :)
    ersaurabh101
    @ersaurabh101
    Problem - Database doesnt get deleted using the command - connection.dropdb().then --
    Explanation - It works fine if no service is fetching the data in table, if any service is inserting the data and at that time we try to drop db then it kind of gets corrupted, in this case, tables are not completely dropped, its data is deleted or some fields are dropped
    Please help in achieving the same in right manner.
    ersaurabh101
    @ersaurabh101
    • if any service [checking update from table] is simply running and at that time i press logout button [ on pressing i wanna delete db], it gets corrupted
    Ujjwal Gupta
    @ujjwalguptaofficial
    If you can provide me something reproducable, i can look. May be a demo or a link to ur project.
    ersaurabh101
    @ersaurabh101
    hii ujjwal, on further investigation, if i can kill ongoing request queue in db and then execute db deletion, it will work. Can you navigate me to a script which stops / kills all ongoing requestQueue
    So its like if there are ongoing requestQueue and we try to delete db, it gets corrupted. We must stop them and then delete. Hope this helps
    Ujjwal Gupta
    @ujjwalguptaofficial
    you have called those api, which means you want to execute it. So its like anti pattern approach.
    and most important thing - when you are logging out, you dont need to drop the db. You can just remove all data from table using clear api. http://jsstore.net/tutorial/clear/
    ersaurabh101
    @ersaurabh101
    alright, noted. Working on this, will let you know soon, thanks
    ersaurabh101
    @ersaurabh101
    tested,actually in background app (services) checks for new messages, so even after clearing data it is still inserting, need to stop ongoing Queue if any, is there any way
    Ujjwal Gupta
    @ujjwalguptaofficial
    i m sorry but this is not possible. You have the full control over the api call, you need to change your app in such a way that it wont insert data when logging out . I mean something which will tell background app to not insert data.
    ersaurabh101
    @ersaurabh101
    exactly, this is what i want to do, if there is ingoing queue while logging out, i want to stop that queue or wait to logout till that queue is completed and deleted by me.
    Ujjwal Gupta
    @ujjwalguptaofficial
    ok cool, i got you. I will create an api which will let you know whether requestQueue is empty or not.
    Better if you can add an issue on github. Thanks.
    ersaurabh101
    @ersaurabh101
    i will add it, hope you can provide the solution soon as my app is all set
    Ujjwal Gupta
    @ujjwalguptaofficial
    sure

    since you are in hurry, so here is a hack -

    var isNoRequest =  con.requestQueue_.length===0;

    here con is the connection

    you can wrap the above code in a setTimeOut with some time & check. Hope this will help you.

    ersaurabh101
    @ersaurabh101
    i'll try and get back
    Ujjwal Gupta
    @ujjwalguptaofficial
    @ersaurabh101 - i have added events functionality now. Using the event you can know when there is no request. Take a look at doc - http://jsstore.net/tutorial/event/