Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    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/
    ersaurabh101
    @ersaurabh101
    hii, i'll use it and get back, encountered 1 major problem
    after using jsstore i am unable to make production builds
    npm run build --prod
    it gives this error -
    2019-07-26_10h53_59.png
    Ujjwal Gupta
    @ujjwalguptaofficial
    cant help, its an issue with building.
    ersaurabh101
    @ersaurabh101
    i understand, but issue comes when we use jsstore
    after removing issue disappears
    ersaurabh101
    @ersaurabh101
    if i dont make --prod then it opens very slow, please help.
    ersaurabh101
    @ersaurabh101
    hii
    please ping me when you have 5 mins
    will show you the problem i am facing
    KirandeepKaur190
    @KirandeepKaur190
    How to use select and check count in select using jsstore.
    Please help.
    How to combine both in one statement?
    Any example will be helpful.
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi @ersaurabh101 , let's chat in private
    @KirandeepKaur190 , you can use two query for this. Why are you thinking about executing in one query ?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Are you thinking - it will take less time if you will do it in one query ? Let me know.
    KirandeepKaur190
    @KirandeepKaur190
    This is required for my table structure. I want to use following query using jsstore :-
    SELECT USERNAME, COUNT(*) FROM MYTABLE WHERE USERNAME = LOGGEDINUSER.
    How can use this?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Jsstore is an indxeddb wrapper & indexeddb is nosql database . So you cant do something like that
    use select query which will give list of results and then you can get the length for count
    Check this example of your scenario
    var results = select({
        from: MyTable,
        where: {
            userName: some_value
        }
    });
    
    var count = results.length;
    var usersName = results.map((result) => {
        result.userName;
    });
    hope this helps
    nitrid
    @nitrid
    hi
    how to table drop ?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi
    do you want to clear a table or just remove it from db ?
    Ujjwal Gupta
    @ujjwalguptaofficial
    You can clear it & after that its just a container. And if you want to remove it completely , please add an issue & i will take it from there.
    nitrid
    @nitrid
    i just want to remove the table from within the db.
    Ujjwal Gupta
    @ujjwalguptaofficial
    ok, please add an issue on jsstore github page. This functionality is not available right now.
    @/all please upgrade your jsstore version to 3.3.5, there were some critical issue for joins query in previous version.
    wideweide
    @wideweide
    how to select a boolean field, just change to int?
    wideweide
    @wideweide
    Has a sample to filter datatype array?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi @wideweide
    wideweide
    @wideweide
    @ujjwalguptaofficial thanks´╝îand what about array of object?
    table peope:object column such wife,array column like chilren
    {id:1,wife:{name:Lily,age:36},children:[{name:tom,age:4},{name:hellen,age:6}]}
    select from people where wife.name='Lily' ?
    select
    from people where children.name='tom'
    Ujjwal Gupta
    @ujjwalguptaofficial
    also for searching inside an array datatype, you need to enable 'multiEntry'
    wideweide
    @wideweide
    I just not know how to write the where...
    con.select({
    from: 'people',
    where: {
    wife.name: 'Lily',
    children.name:'Tom'
    }
    })
    has some smaple code?
    Ujjwal Gupta
    @ujjwalguptaofficial
    hi, i dont think deep level query is possible
    divide your table into multiple tables and then do a join
    wideweide
    @wideweide
    it is possible...
    I used zangodb before: https://github.com/erikolson186/zangodb
    Just like mangodb ,can use deep level query ,just like nosql style
    Ujjwal Gupta
    @ujjwalguptaofficial
    ohk, need to see if this is possible.
    I see you have added an issue, i will take it from there.