migrate-mongo is a database migration tool for MongoDB running in Node.js https://github.com/seppevs/migrate-mongo
Hackolade
Hackolade is pioneering the field of data modeling for NoSQL and multi-model databases with its unique ability to represent deeply nested JSON objects in Entity Relationship diagrams. A well-designed, dynamic database schema is like a solid foundation for a house: if you want an application that will scale, perform well, and be able to support …
DBeaver, professional multi-platform database administration tool
Have you ever suffered with lack of database administration tool? Slow web based UI? No same tool for macOS, windows and Linux? No tool at all? DBeaver is free and open source universal database tool for developers and database administrators. Usability is the main goal of the project, program UI is carefully designed and implemented. …
Improve querying speed in MongoDB
DB query speed is slowed down mainly when converting fetched data to MongoDB model format.For example we fetch JSON format data from db and convert it to MongoDB model format by embedding model methods.In order to avoid this and improve querying speed we can use lean function.The format is model.find({…}).lean(), then the result is retrieved …
SQL query performance enhancement
We know that model querying take more time than raw sql querying. Here is some practice with sample test.In sails.js project, we use waterline ORM by default. It’s Node.js ORM but we can bind SQL dbs like MySQL, PostgreSQL. When we tried to execute query using model, it took around 2 seconds to retrieve around …