Skip to main content

Review old stuff: mongoDB

blockquote


Recently, I revisited old skills, extending to MongoDB. After reinstalling MongoDB, I felt that the website architecture had significantly changed compared to what I saw the last time I created a sample. My old sample project was a record of main characters from the Japanese anime "Demon Slayer." In just four years, from March 2020 to now, there has been a significant change in the website structure, indicating considerable improvements in MongoDB's functionality.


Resource

Some content has been spread out, but I find this arrangement clearer. Below are the resources I briefly looked up:

community version: https://www.mongodb.com/try/download/community-edition

MongoDB shell: https://www.mongodb.com/try/download/shell

Database tools: https://www.mongodb.com/try/download/bi-connector  ( dump, restore, import, export) 

NodeJS reference (developer): https://www.mongodb.com/docs/drivers/node/current/quick-reference/

mongosh manual: https://www.mongodb.com/docs/manual/reference/method/


mongoimport

mongoimport -d dest-db --jsonArray datafile.json

mongosh

Interesting topics covered during the review include:  
Count record:
db.collection.count()
Select some fields and remove _id:
db.collection.find({}, { field_name1: 1,  field_name2: 1,  _id:0 } ) 
Select and/or: (operator)
db.collection.find({field_name1:value1, { $or: [ { field_name2: { $lt: 20 } }, { field_name2: value2 } ] })
Use cursor:
var cursor1 = db.collection.find()
cursor1.next()
cursor1.close()

ExpressJS (NodeJs/JavaScript) 

Doc: 
mozilla: https://developer.mozilla.org/en-US/docs/Learn/Server-side/Express_Nodejs
npm install express
npm install express-generator -g
express project_name --view=jade
cd peoject_name
npm install
SET DEBUG=express-locallibrary-tutorial:* & npm start

# --view=dust|ejs|hbs|hjs|jade|pug|twig|vash 
# npm WARN deprecated mkdirp@0.5.1: ... https://stackoverflow.com/questions/62859986/error-when-install-express-generator-using-npm

mongoose

Docs: 
mongoose: https://mongoosejs.com/docs/index.html
npm: https://www.npmjs.com/package/mongoose

Install:

npm install mongoose --save 

In VS code, the following will be created: 

package.json 
package_lock.json
node_modules


Comments

Popular posts from this blog

Bookmark service (MongoDB & Spring REST) -2/2

    I accidentally deleted my development VM. I got lucky having the habit of taking notes. This blog is useful. Development VM is doom to be lost. Rebuild it waste time, but having a clean slate is refreshing~. What concerns me more is my AWS free quota this month is reaching 85%. The second VM I launched but never being used might be the one to blame. (Of course, my mistake.) I terminated the wrong VM. Now I got Linux 2 built. Great, just threw away everything happened on AMI.  1st layer: Page Page class   Originally, I need to prepare getter/setter for all class properties for Spring. By using lombok, I only need to create constructors. lombok will deal with getter/setter and toString(). But there are chances to call getter/setter, but how? .......Naming convention.... Capitalize the 1st character with the prefix get/set.  Annotation @Data was used on this class.  Repository class Spring Docs: Repository https://docs.spring.io/spring-data/mongodb/docs/3....

gamer's interview

This project simulates a gamer's interview. Based on NodeJS+ ReactJS The setting is interviewing a gamer/journalist what's his/her plan of March 2020? The gamer answers his/her game list in plan, how many reviews on demand and how many hours expected. Games selected for review take 5 hours for each, while others take one. This project is designed to practice render html, jsx, component, props introduced in  https://www.w3schools.com/REACT/default.asp . Also fixed other issues to make it work. When trying to modualize objects and tools, my design developed to separate views and processes. And it is quite similar to the initialized structure NodeJS+ReactJS provided. Furthermore, since include local module files are banned by browsers, use NodeJS service seems to be the best option. view file main process object tool

Comments for my Server/Client Web API samples

        Finally, I finished the comments for python/07 and 09 projects. I almost forgot to put the date on source code which is used to note how long it took me. Not precisely in hours….. I didn’t include source code in my previous post. If choosing code-section for this post…… maybe I want to mark out my comment….. (Really?!)          Once my work was developing websites for enterprises, including ERP, CRM or content sites. The sustainability of network and security are important issues. There are 2 methods for HTML Form submission: GET and POST. Submit via POST is secure, compared to GET which piles parameters on URL. RESTful API is mainly using GET.         Yup, even if you have a certification key, if you put the value on the URL, it is visible data. When writing socket-communication, client-server sockets are a pair; both follow the agreement on commands and structures; and there are countless ports for usa...