I will like to know if watermelonDB is perfect to our NodeJS project about watermelondb

[primus11]

It is hard to say without bigger picture especially in regard to local server (and what it is even supposed to do) if this is most suited but it is possible.

There is info in regard to id columns here:

• Override id
• Local vs Remote IDs
• Override entity ID generator

[KrisLau]

For the id, some of my backend tables have the ID as a numerical number but the sync to the backend is completely controlled by you so you could just parse the int from the string passed by WatermelonDB (similar situation: #1793) or alternatively you could just create a separate id column of a numeric type (something like db_id) and ignore the watermelonDB generated id when querying on the frontend (downside is it would render the watermelon id field a redundant useless field tho).

As for whether it's a good fit for your project I think no one can really answer that other than you but you could probably test using the popular frameworks on a mini copy of your db to see which works best for you and your team. Other option is probably expo's sqlite package.