Pouch DB PUT doc insert issue - question

[Dinesh101041]

Issue

i am working on small form in electron and pouch db

when we inserting a data to db , until the nineth doc it inserting perfectly , but on 10 the doc it is inserting and second position of doc instead on inserting into last

images :

form ui

before inserting the 10th doc

After inserting 10 th doc

here attached the js code

// form submit
const form = document.getElementById("form1");
form.addEventListener("submit", dbsubmit);

function dbsubmit(e) {
   e.preventDefault();
   //   getting values from form
   var Sno = document.getElementById("number").value
   var date = document.getElementById("date").value;
   var Time = document.getElementById("time").value;
   var Trip = document.querySelector('input[name="Trip"]:checked').value;
   var TripType = document.querySelector('input[name="Type"]:checked').value;
  


   // assigning form values to db table names
   var doc = {
       _id: Sno,
       Date: date,
       time: Time,
       trip: Trip,
       triptype: TripType,
   };

   // inserting to db
   db.put(doc, function(err, response) {
       if (err) {
           return console.log(err);
       } else {
           console.log("Document created Successfully", response);
           }
   });

}

inserting until nineth 9th doc its perfectly inserting
but when we insert the 10 th doc it is inserting in second position

i debuged , but cannot able to find solution can anyone help me with the solution

Thank you

Info

• Environment: Electron js
• Adapter: leveldb
• Server: PouchDB Server

[ramblin-rose]

What you are observing is correct. This is explained thoroughly in the CouchDB documentation 3.2.2.5. Collation Specification

Comparison of strings is done using ICU which implements the Unicode Collation Algorithm, giving a dictionary sorting of keys. This can give surprising results if you were expecting ASCII ordering.

^{emphasis mine}

A thorough read of that section will provide a solid grasp of the collation rules.

[Dinesh101041]

What you are observing is correct. This is explained thoroughly in the CouchDB documentation 3.2.2.5. Collation Specification

Comparison of strings is done using ICU which implements the Unicode Collation Algorithm, giving a dictionary sorting of keys. This can give surprising results if you were expecting ASCII ordering.

emphasis mine

A thorough read of that section will provide a solid grasp of the collation rules.

any way to solve this i cant able to find the correct way to sort the numbers in correct order can you help me with that

[ramblin-rose]

Best asked on https://stackoverflow.com

edit: However:

find the correct way to sort the numbers

But the field key is not a number type, it is a string type. That should make everything clear.

[Dinesh101041]

Best asked on https://stackoverflow.com

edit: However:

find the correct way to sort the numbers

But the field key is not a number type, it is a string type. That should make everything clear.

want to convert the key from string to int ?

[janl]

In PouchDB, document ids must be strings, they can not be numbers.

In order to do what you want, you need to create a view with a map function that looks like this:

function (doc) {
  emit(Number(doc._id)
}

this will give you a view query result that is sorted by the number value of the document _id