以前學習 Ruby on Rails 建立 CRUD app時，學習過一點 SQL 的用法。 覺得 SQL 之類的 Relational database 很不錯，唯一不好的是有時侯復雜一點的relationship 需要許多中間層來建立關係。對 app 的 performance 和指令建設會傷一點腦細胞。 現時雲服務當道，現時許多公司已把它們 database 轉換到 NoSQL。 NoSQL 的全稱是 Not Only SQL，也可以理解非關係型的資料庫，是一種新型的革命式的資料庫設計方式，不過它不是為了取代傳統的關係型資料庫而被設計的，它們分別代表了不同的資料庫設計思路。 MongoDB是一種面向文檔的數據庫管理系統，用C++等語言撰寫而成，以解決應用程序開發社區中的大量現實問題。 MongoDB社區版是免費的，所以是非常用家友好。 https://upload.wikimedia.org/wikipedia/commons/thumb/0/00/Mongodb.png/1200px-Mongodb.png 所以對 MongoDB 這類 noSQL 有了興趣，想落手了解一下，寫個手記日後翻閱。 | 對比 | MySQL | MongoDB | |----------|:-------------:|:------:| | 1. 名字起源 | 來自女兒的名字 | 來自 humongous | | 2. 架構 | 使用 Table/Row/Column | 使用 Collection/Document | | 3. Schema 設定 | 需要指定 table 的 schema | collection 的每個 document 的 schema 可以自由修改 | | 4. Join 支持 | 支援 join | 沒有 join | | 5. 語言 | 使用 SQL 語言 | 使用類似 JavaScript 的函式 | Cheers!
| author | nuagnorab |
|---|---|
| permlink | hivesnap-mongodb-001 |
| category | hive-105017 |
| json_metadata | {"app":"peakd/2020.06.2","format":"markdown","tags":["cn","cn-reader","cn-curation","build-it","palnet","neoxian"],"image":["https://upload.wikimedia.org/wikipedia/commons/thumb/0/00/Mongodb.png/1200px-Mongodb.png"]} |
| created | 2020-06-28 14:03:42 |
| last_update | 2020-06-28 14:03:42 |
| depth | 0 |
| children | 0 |
| last_payout | 2020-07-05 14:03:42 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 4.542 HBD |
| curator_payout_value | 4.175 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 856 |
| author_reputation | 125,097,310,898,849 |
| root_title | "HiveSnap - MongoDB 學習手記 001" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 98,223,668 |
| net_rshares | 24,738,405,194,259 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| wongshiying | 0 | 7,264,794,334 | 83.85% | ||
| tensaix2j | 0 | 3,451,954,096 | 83.85% | ||
| sweetsssj | 0 | 12,949,761,771,374 | 33% | ||
| cnfund | 0 | 152,420,262,045 | 83.85% | ||
| justyy | 0 | 728,378,481,744 | 83.85% | ||
| btshuang | 0 | 3,195,059,637 | 83.85% | ||
| devilwsy | 0 | 2,905,685,011 | 83.85% | ||
| janiceting | 0 | 2,908,467,612 | 83.85% | ||
| htliao | 0 | 9,757,442,967 | 10% | ||
| susanlo | 0 | 12,667,946,515 | 70% | ||
| cryptoemperor | 0 | 7,937,928,763 | 20% | ||
| mys | 0 | 27,941,217,412 | 8.38% | ||
| guyverckw | 0 | 169,686,701,265 | 83.85% | ||
| nanosesame | 0 | 243,437,461,580 | 80% | ||
| cpyjeffrey | 0 | 6,675,411,423 | 100% | ||
| yvonnetse | 0 | 15,059,594,470 | 20% | ||
| kenchung | 0 | 2,813,835,280 | 100% | ||
| pakyeechan | 0 | 6,281,571,990 | 50% | ||
| jeffreytong | 0 | 2,534,928,531 | 100% | ||
| johnliao | 0 | 1,753,921,140 | 100% | ||
| helloworld123 | 0 | 902,352,551 | 100% | ||
| nuagnorab | 0 | 359,119,872,764 | 83.85% | ||
| kitcat | 0 | 201,780,577,269 | 100% | ||
| victorier | 0 | 65,108,603,778 | 40% | ||
| linuslee0216 | 0 | 60,014,971,080 | 83.85% | ||
| wilkinshui | 0 | 119,467,903,160 | 83.85% | ||
| carobetc | 0 | 4,104,287,453 | 100% | ||
| thomaskikansha | 0 | 28,008,212,197 | 100% | ||
| chingyi | 0 | 4,505,757,237 | 100% | ||
| mrjt | 0 | 573,357,787 | 100% | ||
| aaronli | 0 | 108,864,290,750 | 83.85% | ||
| marylaw | 0 | 4,730,760,606 | 83.85% | ||
| jenthedreamer | 0 | 1,667,900,903 | 100% | ||
| shenchensucc | 0 | 46,693,756,812 | 83.85% | ||
| pyc1512 | 0 | 31,372,365 | 100% | ||
| vincentttw | 0 | 127,451,043 | 100% | ||
| krischy | 0 | 30,169,576,276 | 67.08% | ||
| claratze | 0 | 0 | 100% | ||
| jacklcp | 0 | 619,471,168 | 100% | ||
| biuiam | 0 | 4,847,060,211 | 83.85% | ||
| whd | 0 | 9,894,823,979 | 8.38% | ||
| kristytyxd | 0 | 1,066,824,746 | 100% | ||
| bobowyeahxd | 0 | 257,674,772 | 100% | ||
| colinct | 0 | 949,862,191 | 100% | ||
| davidmendel | 0 | 8,734,345,263 | 67.08% | ||
| rafalski | 0 | 1,090,703,406 | 8.38% | ||
| mrpointp | 0 | 61,184,604,946 | 83.85% | ||
| mcw | 0 | 1,714,537,277 | 100% | ||
| sanzo | 0 | 509,573,483 | 100% | ||
| mygod | 0 | 3,190,383,659 | 83.85% | ||
| yuwineryyuvia | 0 | 12,222,830,066 | 100% | ||
| boooster | 0 | 14,291,826 | 100% | ||
| eason1117 | 0 | 0 | 100% | ||
| votebooster | 0 | 0 | 100% | ||
| shirlam | 0 | 48,737,088,639 | 100% | ||
| everrich | 0 | 8,129,133,115 | 83.85% | ||
| mellissaying | 0 | 223,134,258 | 100% | ||
| syh7758520 | 0 | 22,618,569,437 | 83.85% | ||
| kona | 0 | 15,438,540,028 | 50% | ||
| diaohuijun | 0 | 5,832,410,309 | 83.85% | ||
| nicolemoker | 0 | 53,723,648,909 | 67.08% | ||
| windtalker | 0 | 695,051,497 | 83.85% | ||
| interactive | 0 | 1,006,132,975 | 20% | ||
| shihabieee | 0 | 1,737,465,306 | 16.5% | ||
| john811 | 0 | 4,914,569,496 | 100% | ||
| spaminator | 0 | -12,220,278,035 | -0.5% | ||
| mrspointm | 0 | 73,696,962,526 | 83.85% | ||
| liumei | 0 | 10,849,182,108 | 83.85% | ||
| deskart | 0 | 2,058,135,473 | 100% | ||
| waiyee422 | 0 | 7,708,361,454 | 83.85% | ||
| fbslo | 0 | 3,016,438,847 | 4.19% | ||
| sportyfree | 0 | 2,498,890,746 | 100% | ||
| arronli | 0 | 77,971,377 | 100% | ||
| goodboyphilip | 0 | 71,951,193,000 | 100% | ||
| rosatravels | 0 | 516,607,241,029 | 83.85% | ||
| connieleung | 0 | 450,870,465 | 100% | ||
| minloulou | 0 | 15,262,906,302 | 83.85% | ||
| jsquare | 0 | 636,041,471,225 | 38% | ||
| vincentyip | 0 | 365,505,850 | 100% | ||
| gladyslui | 0 | 14,633,213,366 | 100% | ||
| jychbetter | 0 | 6,875,522,312 | 83.85% | ||
| winniex | 0 | 60,844,013,984 | 83.85% | ||
| kawing | 0 | 0 | 100% | ||
| jianan | 0 | 2,816,756,949 | 83.85% | ||
| sosoo | 0 | 1,867,625,910 | 100% | ||
| nuv | 0 | 1,641,414,443 | 100% | ||
| terencetze | 0 | 0 | 100% | ||
| windowglass | 0 | 3,494,541,240 | 83.85% | ||
| zmx | 0 | 11,096,284,435 | 83.85% | ||
| cosetteee | 0 | 1,283,035,821 | 100% | ||
| nileelily | 0 | 5,305,006,073 | 83.85% | ||
| michelleluilui | 0 | 9,941,654,132 | 100% | ||
| stephenma26 | 0 | 0 | 100% | ||
| jacktan | 0 | 2,482,665,343 | 41.92% | ||
| angelina6688 | 0 | 3,885,700,021 | 83.85% | ||
| hkfund | 0 | 1,488,795,950,878 | 100% | ||
| cheva | 0 | 17,475,223,730 | 83.85% | ||
| hkupvotebot | 0 | 1,748,659,760 | 50% | ||
| fun2learn | 0 | 5,321,686,250 | 3% | ||
| maiyude | 0 | 2,803,789,330 | 83.85% | ||
| wilhb81 | 0 | 316,463,007,452 | 83.85% | ||
| emmali | 0 | 12,546,958,883 | 83.85% | ||
| kirato | 0 | 144,372,802,297 | 83.85% | ||
| sweetdisaster | 0 | 1,238,741,889 | 100% | ||
| nostalgic1212 | 0 | 69,379,155,344 | 83.85% | ||
| shentrading | 0 | 24,622,931,686 | 83.85% | ||
| also.einstein | 0 | 6,757,880,915 | 83.85% | ||
| g9g | 0 | 18,361,655,540 | 100% | ||
| fishbb | 0 | 1,654,297,128 | 41.92% | ||
| ericet | 0 | 59,057,640,027 | 83.85% | ||
| beleg | 0 | 3,711,975,735 | 8.38% | ||
| aellly | 0 | 171,051,046,860 | 83.85% | ||
| huangzuomin | 0 | 11,856,485,330 | 83.85% | ||
| liewsc | 0 | 2,501,437,827 | 41.92% | ||
| tanzy | 0 | 1,174,268,907 | 41.92% | ||
| herstory | 0 | 9,323,084,688 | 100% | ||
| fishdd | 0 | 1,617,538,820 | 41.92% | ||
| andrewma | 0 | 19,739,592,419 | 83.85% | ||
| eviacha | 0 | 532,905,104 | 100% | ||
| xiaoliang | 0 | 132,141,973,117 | 83.85% | ||
| i-d | 0 | 1,131,230,361,117 | 83.85% | ||
| honoru | 0 | 379,668,723,027 | 83.85% | ||
| satoshihk | 0 | 5,605,786,248 | 100% | ||
| hmayak | 0 | 19,786,228,472 | 83.85% | ||
| fishlucy | 0 | 13,830,469,641 | 50% | ||
| hkphotography | 0 | 2,505,605,020 | 83.85% | ||
| pgr | 0 | 662,693,116 | 41.92% | ||
| ronbong | 0 | 2,801,426,012 | 83.85% | ||
| robertyan | 0 | 13,741,400,104 | 83.85% | ||
| xiaoyuanwmm | 0 | 4,012,577,781 | 83.85% | ||
| kidsreturn | 0 | 4,497,811,510 | 83.85% | ||
| tydebbie | 0 | 6,499,256,128 | 41.92% | ||
| moneybaby | 0 | 29,365,074,690 | 83.85% | ||
| ybeyond | 0 | 4,111,733,258 | 83.85% | ||
| team-cn | 0 | 276,358,287,804 | 83.85% | ||
| wanggang | 0 | 29,664,735,051 | 16.77% | ||
| chick-fil-a | 0 | 2,845,876,105 | 83.85% | ||
| redlobster | 0 | 2,850,296,561 | 83.85% | ||
| fiveguys | 0 | 1,572,180,115 | 83.85% | ||
| marcoy2j | 0 | 2,530,753,265 | 83.85% | ||
| tiffany4ever | 0 | 5,467,519,481 | 83.85% | ||
| bonefish | 0 | 2,840,785,465 | 83.85% | ||
| chilis | 0 | 2,862,527,390 | 83.85% | ||
| olive-garden | 0 | 1,517,336,640 | 83.85% | ||
| shine.wong | 0 | 3,145,996,404 | 83.85% | ||
| shuxuan | 0 | 2,879,016,708 | 83.85% | ||
| julian2013 | 0 | 84,487,042,461 | 83.85% | ||
| melaniewang | 0 | 13,984,272,454 | 83.85% | ||
| teamcn-news | 0 | 1,520,512,195 | 83.85% | ||
| wenxuecity | 0 | 2,084,162,994 | 83.85% | ||
| mitbbs | 0 | 2,852,530,729 | 83.85% | ||
| gorbisan | 0 | 9,184,766,037 | 6.28% | ||
| artsymelanie | 0 | 47,249,065,423 | 83.85% | ||
| isaandrich | 0 | 10,382,235,088 | 75% | ||
| slientstorm | 0 | 8,416,294,257 | 83.85% | ||
| laissez-faire | 0 | 50,203,862 | 100% | ||
| pet.society | 0 | 146,065,416,534 | 83.85% | ||
| canna-collective | 0 | 59,292,009,601 | 30% | ||
| minminlou | 0 | 1,391,615,853 | 62.88% | ||
| annepink | 0 | 136,147,765,521 | 83.85% | ||
| cherryzz | 0 | 264,796,548,037 | 83.85% | ||
| photo-baby | 0 | 146,598,551 | 100% | ||
| jamebanfield | 0 | 61,261,548 | 100% | ||
| conada | 0 | 65,227,063 | 100% | ||
| overthewall | 0 | 22,174,771 | 100% | ||
| kawaiv | 0 | 0 | 100% | ||
| alexstand | 0 | 0 | 100% | ||
| ali-oli | 0 | 146,569,512 | 100% | ||
| teamcn-shop | 0 | 25,249,347,496 | 83.85% | ||
| yanyanbebe | 0 | 7,657,771,147 | 83.85% | ||
| vkwong | 0 | 261,531,163 | 100% | ||
| kelvinzhang | 0 | 4,725,068,919 | 83.85% | ||
| starrouge | 0 | 838,694,835 | 41.92% | ||
| wherein | 0 | 24,791,196,403 | 3% | ||
| catarafa | 0 | 2,007,543,194 | 100% | ||
| zerofive | 0 | 1,609,259,788 | 83.85% | ||
| cryptoast | 0 | 86,605,440 | 20% | ||
| melodyzhou | 0 | 986,548,727 | 83.85% | ||
| honey00 | 0 | 584,543,278 | 83.85% | ||
| cryptoast.bounty | 0 | 0 | 100% | ||
| rafaeleff15 | 0 | 1,789,008,214 | 100% | ||
| ahua | 0 | 1,834,460,133 | 83.85% | ||
| morningshine | 0 | 186,270,694,117 | 83.85% | ||
| gainsomeweight | 0 | 0 | 100% | ||
| cnstm | 0 | 8,747,970,136 | 3% | ||
| steemitportugal | 0 | 1,174,568,490 | 1% | ||
| cn-activity | 0 | 6,439,415,770 | 83.85% | ||
| gear.nsnow | 0 | 486,345,262 | 41.92% | ||
| davidchen | 0 | 60,602,425,303 | 83.85% | ||
| moneybabe | 0 | 319,340,201 | 100% | ||
| devyleona | 0 | 25,350,171,199 | 83.85% | ||
| yanhan | 0 | 33,856,164,406 | 83.85% | ||
| walker886 | 0 | 31,953,796 | 83.85% | ||
| foodiecouple | 0 | 6,125,512,997 | 83.85% | ||
| m18207319997 | 0 | 12,228,125,331 | 83.85% | ||
| lovelemon | 0 | 16,406,519,008 | 83.85% | ||
| theinspiration | 0 | 533,246,904 | 100% | ||
| cn-hello | 0 | 2,406,308,526 | 83.85% | ||
| m18773975030 | 0 | 194,086,383 | 100% | ||
| mylord1992 | 0 | 6,511,715,777 | 83.85% | ||
| icecoffee | 0 | 750,395,269 | 83.85% | ||
| kgame | 0 | 2,910,445,353 | 83.85% | ||
| hertz300 | 0 | 247,028,516,884 | 83.85% | ||
| koei | 0 | 1,960,807,697 | 83.85% | ||
| we-are-palcoin | 0 | 0 | 9.45% | ||
| jimhawkins | 0 | 0 | 1% | ||
| nympheas | 0 | 15,483,336,765 | 67.08% | ||
| aaronli.sct | 0 | 729,480,337 | 10% | ||
| steem-drivers | 0 | 1,713,312,822 | 83.85% | ||
| sumd | 0 | 666,865,774 | 83.85% | ||
| xiaoq.sports | 0 | 6,694,628,640 | 83.85% | ||
| hykwf678233 | 0 | 30,536,733,438 | 83.85% | ||
| atyh | 0 | 4,172,907,524 | 83.85% | ||
| thranax | 0 | 5,743,035,997 | 3% | ||
| ericetchen | 0 | 1,545,197,761 | 83.85% | ||
| stevewu | 0 | 3,942,584,190 | 83.85% | ||
| kristinasiu | 0 | 1,591,652,038 | 83.85% | ||
| trevorlp97 | 0 | 9,260,800,291 | 83.85% | ||
| trevormomo | 0 | 1,868,749,160 | 83.85% | ||
| annzhao | 0 | 14,727,389,809 | 83.85% | ||
| cherrylp147 | 0 | 602,962,405 | 83.85% | ||
| tonimontana.neo | 0 | 0 | 0.25% | ||
| cn-trail | 0 | 657,872,202 | 83.85% | ||
| cryptowesearch | 0 | 12,227,017 | 100% | ||
| chris55 | 0 | 715,938,926 | 83.85% | ||
| ladyalkaid | 0 | 1,355,630,287 | 83.85% | ||
| lnakuma | 0 | 10,440,864,027 | 83.85% | ||
| ibutterfly | 0 | 998,934,978 | 83.85% | ||
| lukgot | 0 | 3,878,042,391 | 100% | ||
| aagod | 0 | 3,877,670,949 | 100% | ||
| toni.pal | 0 | 0 | 1.54% | ||
| rkogod | 0 | 3,874,937,481 | 100% | ||
| wiggod | 0 | 3,869,113,268 | 100% | ||
| huiwilkins | 0 | 3,869,714,013 | 100% | ||
| huiwilkins2 | 0 | 3,870,982,660 | 100% | ||
| kengod | 0 | 3,870,962,477 | 100% | ||
| biugod | 0 | 3,865,957,703 | 100% | ||
| hunggod | 0 | 3,869,979,353 | 100% | ||
| llgod | 0 | 3,864,659,811 | 100% | ||
| aaken | 0 | 3,866,562,705 | 100% | ||
| aarko | 0 | 3,866,496,603 | 100% | ||
| kenchung1 | 0 | 29,341,825,441 | 83.85% | ||
| kenchung2 | 0 | 1,883,321,156 | 100% | ||
| kenchung3 | 0 | 1,883,513,371 | 100% | ||
| kenchung4 | 0 | 1,881,874,516 | 100% | ||
| kenchung5 | 0 | 1,881,380,012 | 100% | ||
| kenchung6 | 0 | 1,880,242,290 | 100% | ||
| kenchung7 | 0 | 1,880,327,591 | 100% | ||
| kenchung9 | 0 | 1,880,728,057 | 100% | ||
| kenchung10 | 0 | 1,881,125,748 | 100% | ||
| steem.buzz | 0 | 2,073,401,715 | 83.85% | ||
| catanknight | 0 | 2,320,764,121 | 83.85% | ||
| littleksroad | 0 | 242,421,221,320 | 83.85% | ||
| dryuen | 0 | 541,454,935 | 83.85% | ||
| curation.bot | 0 | 0 | 0.09% | ||
| kikoxixi | 0 | 21,911,670,605 | 83.85% | ||
| jywahaha | 0 | 748,690,353,086 | 83.85% | ||
| musiccccat | 0 | 413,430,130,583 | 83.85% | ||
| alwaysthinking | 0 | 12,839,267,899 | 83.85% | ||
| xiaomalailiao | 0 | 12,382,028,857 | 83.85% | ||
| weiweilove | 0 | 2,696,193,510 | 83.85% |
hiveblocks