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.0.0.RELEASE/reference/html/#m

Built LAMP on AWS AMI, and update/install Python3.6, pip v20, Apache wsgi and Flask

I got one half day free and I spent it on building a LAMP on AWS AMI. I also wanted to squeeze Flask into Apache. So I also install/update Python 3.6, pip V.20.1, Apache wsgi and Flask. I wrapped up progress for now before I forgot all resources.    On AWS marketplace, everyone can pay for a good suit such as Django. I’m not interested in content creation unless there are interesting topics to resolve. I don’t know what left to do if I bought a solution; and I may get annoyed like everyone else if the solution causes more problems. To build on my own is more realistic and practical. Installing a LAMP (Linux, Apache, MySQL, PHP) was smooth while following AWS tutorial. Tutorial: Install a LAMP Web Server with the Amazon Linux AMI https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html To build Flask is absolutely a different thing….  still failed before I fell asleep... If I choose AWS EC2 Ubuntu instance, most tutorials are based on this Linux version. Unfortunately I oft

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 usage. Plain text on the message of socket communication usually wouldn’t be