However, they reaapear in queries when I close the app, either forcefully or suddenly.
One theory I am working with is, I didnt mark the id of each record as primary. I didnt do this at first because the schema complains that the id must be a string. I came from a more traditional mysql backgroud where ids are always integers. So I omitted. I just remembered now. Do you think this could have been the course?
.save() only works for new, temporary documents
Hi, I can't sort the items in a collection, I tried several methods without success. Maybe someone can help me. I use RxDB with Electron and websql adapter.
First I tried the method proposed in the RxDB documentation.
That's my request.
playersCollection.find()
.sort('lastName')
.exec()
.then(function (players) {
console.log(players);
});
̀For this request, I have this error message :
WebSQL threw an error Error: SQLITE_ERROR: too many SQL variables
I also tried the method proposed by pouch db.
playersCollection.find({
selector: {
'lastName': {$gte: null}
},
sort: ['lastName']
})
.exec()
.then(function (players) {
console.log(players);
});In this case, I have this error:
Uncaught (in promise) Error: unknown operator "lastName" - should be one of $eq, $lte, $lt, $gt, $gte, $exists, $ne, $in, $nin, $size, $mod, $regex, $elemMatch, $type, $allMatch or $all
In this two case, if I remove sort condition, the collection is returned fine. Of course, the "lastName" property is defined in my collection schema like :"properties": {
"lastName": {
"type": "string"
},
...
}
Thanks for your help.
@pubkey thanks for your answer. Indeed, I probably made a mistake in my second example because this request works fine.
playersCollection.pouch.find({
selector: {
'lastName': {$gte: null}
},
sort: ['lastName']
})
.then(function (players) {
console.log(players);
});However, I don't understand why my first request didn't work. Did I forget something?
I can't explain it. I'll get back to you if the problem recurs or if I find the cause.
Thank you very much anyway.
_id: { type: "string", primary: true }. I generate the uuid via uuidv4(req.email) using the uuid npm package.
const foundItem = await userCollection.findOne({
_id: {
$eq: req.id
}
})
Hello, I'm very new to RxDB. I'm using RxDB with react-native and Typescript. I have some questions if someone can help. I'm using the pouchdb adapter with react-native-sqlite.
1) I have about 4000 documents that i need to bulk insert / update. I'm currently using the pouch.bulkDocs function because atomicUpsert is super slow. My understanding is that this function will keep inserting documents even if they have the same id. Is there a way to only keep the latest document data?
2) I'm confused about creating queries. Should I look at the pouchDB documentation or at the cloudant/mango repo? I'm trying to combine a where() with a sort() and a limit() but it won't run as it is too complex. If I remove sort() it runs fine.
3) Are there any performance documentation / tips? I'm seeing some small delays that are not visible for example with redux, so I might be doing something wrong.
4) Is the schema necessary or I can use RxDB without a schema? If it's not necessary what features do I lose without it? I'm still not very experienced with the schema so some things are more hard than they should. For example Documentation says I can define Indexes for string, integer, number but I get an error for any type except string.
Thanks
1) You should use the bulk-methods for writing that many documents. RxDB also has a
bulkInsert(). The upsert function will overwrite existing documents with the same primary key2) I never had this problem. If you can reproduce it, you should create an issue. If it is also not working with pouchdb, create an issue there because it must be fixed there.
3) There are some performance-tips for pouchdb that also apply to rxdb https://pouchdb.com/2015/09/01/pouchdb-4.0.1-gotta-go-fast.html
4) yes you need a schema. Most configuration and optimisations that come from RxDB rely on having a schema. If creating these indexes does not work, please make an issue with some code to reproduce it
Hi again, I noticed in the documentation this part:
Please always ensure that your pouchdb adapter-version is the same as pouchdb-core in the rxdb package.json. Otherwise you might have strange problems
I noticed that RxDB is using version 7.0.0 of pouchdb-find but 7.1.1 pouchdb-core. I updated the library depencency but it didn't fix my issues. Then I also noticed that the pouchdb adapter (which is at version 2.0.0) has also a dependency on version 7.0.0 of websql-core.
Could this version difference create the issues? If yes, I can try to fork the pouchdb adapter and try to update its dependencies.
bulkUpdate method in near future? Or is there any other plugin/fork with this function? I have built my reactive application on RxDB (with no prior experience) and now I'm facing performance issues during document updates - update about 100 documents in 2 collections takes about 5 secs and the time is increasing with number of document revisions...