ç§ã¯ãåå¿è
ã® Web ããã¯ãšã³ãéçºè
ã« SQL ã®ç¥èãå¿
èŠãªã®ãããããšã ORM ã§ãã¹ãŠãã§ããã®ãã«ã€ããŠãã³ãã¥ããã£ã® XNUMX ã€ã§ããäžåºŠè°è«ããåŸãã°ã¬ãã³ã·ã³ãã®å
¬åŒã®ã¿ã€ãã«ã«èŸŒããããå®åçãªåããèªåããŸããã ORM ã SQL ã ãã§ã¯ãªããããå°ãåºãç¯å²ã§çããæ¢ãããšã«ããŸãããåºæ¬çã«ã¯ãçŸåšäžå
éçºè·ã®é¢æ¥ã«èšã人ã
ã誰ãªã®ããã©ã®ãããªæŽå²ãæã¡ãã©ã®ãããªäžçã«ããã®ããäœç³»åããŠã¿ãããšã«ããŸãããã«äœãã§ããã äžè¬çã«ãç§ã«ã¯æèŠããããŸããããããã¯å人çãªæ¡çšçµéšã«ãã£ãŠåœ¢æããããã®ã§ãããæããã«å°å
åžå Žã«åãããŠèª¿æŽãããŸããã å
šäœçã«é¢çœããªããŸããã ãããç§ãã¡ãèŠã€ãããã®ã§ãã
äžçã®éçºè 人å£
äœããã®æ¹æ³ã§ãã®è³ªåã«ã¢ãããŒãããããã«ãç§ã¯ãçŸåšäžçäžã«éçºè
ãäœäººããã®ãããããŠãã®äººå£ãæéã®çµéãšãšãã«ã©ã®ããã«å€åããŠããã®ãã«ã€ããŠã®ããŒã¿ãæ€çŽ¢ããããšããå§ããããšã«ããŸããã
ããŸããŸãªæ
å ±æºã«ããæšå®ã§ã¯ããã®æ°ã¯ 12 äžäººãã 30 äžäººã®ç¯å²ã«ãããŸãã ã«ç«ã¡å¯ãããšã«ããŸãã
SlashData ã«ãããšã2018 幎ã®ç¬¬ 18.9 ååæã«ã¯äžçã«çŽ 12.9 äžäººã®éçºè ãããããã®ãã¡ 6 äžäººãããã®éçºè ãã€ãŸãããã°ã©ãã³ã°ã§çèšãç«ãŠãŠããŸãã çŸåšããã®éçºè ã§ã¯ãªã人ã¯ãããã°ã©ãã³ã°ã趣å³ã§ãã人ãããã³çŸåšå°éã®å匷ãããŠãã人 (ããŸããŸãªåŠçãç¬åŠ) ã§ãã ã€ãŸããç§ãèå³ãæã£ãŠããã°ã«ãŒãã®èŠæš¡ãã€ãŸã XNUMX äžäººã«ã€ããŠã®ãã³ããããã«ãããŸãã æ£çŽã«èšããšãããã¯äºæ³ä»¥äžã§ããã
ç§ã«ãšã£ãŠ 2017 çªç®ã«é©ããã®ã¯ãããã°ã©ããŒã®æ°ã®å¢å çã§ãã2018 幎ã®ç¬¬ 14.7 ååæãã 18.9 幎ã®ç¬¬ 21 ååæã«ãããŠããã®æ°ã¯ 2018 äžäººããåè¿°ã® 5 äžäººã«å¢å ãã20 幎ã«ã¯ XNUMX% å¢å ããŸããã ããã°ã©ããŒã®æ°ã®å¢å çãæšå®ããããã«æ±ããããããæ¯å¹Žãããã«å¢å ããªããã幎éçŽ XNUMX% ã§ãããšçããŸãã ãããŠããã§ã¯ããããXNUMXïŒ ãããããšãå€æããŸããã
ããã«ãSlashData ã¯ã人å£ã 2030 幎ãŸã§ã« 45 äžäººã«éãããšäºæž¬ããŠããŸãã ããã幎é 8% ã§ã¯ãªã 20% 匷ã®æé·ãæå³ããŠããããšã¯å®¹æã«ç解ã§ããŸãããã€ã³ã¿ãŒãããã®æ®åç (çŸåšå
šäžçã§çŽ 57%) ãèæ
®ãã調æŽã«èšåããŠããŸãã
äžè¬çã«ãããã°ã©ãã¯éèŠãé«ãŸã£ãŠãããããã©ãèããŠãããããããã§ãããã ããŠãéèŠã«ã€ããŠã
äœãæ±ããããŠããã®ã§ããããïŒ
éèŠãèŠç©ããããã«ãHackerRank ããŒã¿ã䜿çšããŸããã
ããã°ã©ãã³ã°èšèªã«é¢ããŠèšãã°ãã³ã³ãã¥ãŒã¿ãŒ ããŒããŠã§ã¢ãé€ãã»ãŒãã¹ãŠã®æ¥çã§æãéèŠãé«ãã®ã¯ JavaScriptãPythonãJava ã§ãã åŸè ã®å ŽåãæãéèŠãé«ãã®ã¯ C/C++ ã§ãããããã¯åœç¶ã®ããšã§ãããããŒããŠã§ã¢ ãããžã§ã¯ãã«ã¯äŸç¶ãšããŠãªãœãŒã¹ã®åŒ·åºŠãšã察å¿ãããœãããŠã§ã¢ã®ããã©ãŒãã³ã¹ã«å¯ŸããèŠä»¶ããããŸãã
ãã¬ãŒã ã¯ãŒã¯ã«é¢ããŠã¯ãAngularJSãNode.jsãReact ã®éèŠãæãé«ããéèŠãšäŸçµŠã®ã®ã£ãããæã倧ãããªã£ãŠããŸããããã¯ãJavaScript ãšã³ã·ã¹ãã ã®å€åã®ã¹ããŒãã«ãã£ãŠèª¬æãããŠããããã§ãã ãäŸçµŠã¯ãã§ã«éèŠãäžåã£ãŠããŸãã
ã³ã³ããã³ã·ãŒã®èŠ³ç¹ããèŠããšãéçšäž»ã¯äž»ã«åè£è
ã«åé¡è§£æ±ºã¹ãã«ãæåŸ
ããŸãã éçšäž»ã®çŽ 95% ããããã®ã¹ãã«ãéèŠã§ãããšè¿°ã¹ãŠããŸãã ããã°ã©ãã³ã°èšèªèœå㯠56% 㧠XNUMX äœã§ãã ã¡ãªã¿ã«ãã¢ã«ãŽãªãºã ãããŒã¿æ§é ããã®ä»ã®ã³ã³ãã¥ãŒã¿ãµã€ãšã³ã¹ã«é¢ããåºç€çãªç¥èã¯ãã¢ã³ã±ãŒãã«ãªãã£ããããããã¯å€§èŠæš¡ã«åŠè¡çãªç¥èãå¿
èŠãšãããªããªã£ããã®ã©ã¡ããã§ãå
šãç·ããããŸããã
ããŒã¿ããŒã¹èšèšã¯ãåŸæ¥å¡æ° 23.2 人æªæºã®äŒæ¥ã® 100%ãåŸæ¥å¡æ° 18.8 人以äžã®äŒæ¥ã® 1000% ã§å¿ èŠãšãããŠããŸãã ã¯ããORM ãš SQL ã«é¢ãããã®ã®ããã§ãã ç§ã®è«ççãªèª¬æã¯ã倧äŒæ¥ã«ã¯ãã®åŽé¢ãæ åœããå°ä»»ã®åœ¹å²ãæ ã DBA ãååšãããããéçºè ã®èŠä»¶ãç·©åããããæ©ãéçšã§ãããšããããšã§ãã ããããã·ã¹ãã ãã¶ã€ã³ã§ã¯ãã®éã§ãå°èŠæš¡ãªãã®ã§ã¯ 37.0%ã倧èŠæš¡ãªãã®ã§ã¯ 44.1% ãšãªã£ãŠããŸãã 倧èŠæš¡ãªäŒæ¥ã«ã¯å°ä»»ã®ã¢ãŒããã¯ããå¿ èŠã§ããããã«èŠããŸããããããããçæãããã·ã¹ãã ã®æ°ãã«ããŒã§ããªãã ããããããŸããã ãããã¯ãåãåºæ¬çãªã¢ã«ãŽãªãºã ãšããŒã¿æ§é ãã·ã¹ãã èšèšã«çµã¿èŸŒããšãããå°ãæ確ã«ãªããŸãã
äžå°äŒæ¥ã§ã¯ãåè¿°ã®ã·ã¹ãã èšèšãããããããã¬ãŒã ã¯ãŒã¯ã®ç¿ç床ãå¿ èŠã§ãããããããã¹ã¿ãŒãã¢ããã«ãšã£ãŠã¯äœãšãæ©èœãã補åãã§ããã ãæ©ãçºå£²ããããšãéèŠã§ããããããŠææ¥ã¯ææ¥ã«ãªãããšãããã£ããã³ã®çµè«ãå°ãåºãããšãã§ããŸãã
åŠçã¯äœãåŠã¶ã®ã§ãããã?
ããã§ã¯å¥ã®ããŒã¿ã«äŸåããŸãã
äœããã®åœ¢ã§ããã°ã©ãã³ã°ãå€§åŠ (ã³ã³ãã¥ãŒã¿ ãµã€ãšã³ã¹å°æ»ã®ããšã§ã) ã§æããããŠããã«ããããããã調æ»å¯Ÿè±¡è
ã®åæ°ä»¥äžãç¬åŠãè¡ã£ãŠãããšçããããšãèæ
®ããããšãéèŠã§ãã
çŸä»£ã®åŠç㯠YouTube ããåŠã¶ããšã奜ã¿ãŸããã幎é ã®éçºè ã¯ãã¥ãŒããªã¢ã«ãæžç±ã«é Œã£ãŠããŸãã ã©ã¡ãã StackOverflow ãç©æ¥µçã«äœ¿çšããŠããŸãã ããã¯ãZ äžä»£ã«ãšã£ãŠãããªã銎æã¿ã®ããã¡ãã£ã¢ ãã£ãã«ã§ããã®ã«å¯ŸããY äžä»£ã®ä»£è¡šè ã¯ãŸã ããã¬ãŒã®ããªãæ代ã«ãããšããäºå®ã«ãããã®ã ãšç§ã¯èããŠããŸãã
圌ãã¯éçšäž»ãæ±ããŠãããã®ãã€ãŸã JavaScriptãJavaãPython ãæããŠããŸãã C/C++ãç¥ã£ãŠãããšã®ããšã§ãããããã¯ãããããããã®èšèªã倧åŠã§ã®æè²ã«äœ¿çšãããŠããããã ãšæãããŸãã 圌ã㯠JS ãã¬ãŒã ã¯ãŒã¯ãæããŠããŸãããéèŠãäŸçµŠãå€§å¹ ã«äžåã£ãŠãããããæåã®å°±è·åŸãç©æ¥µçã«åŠç¿ããŠããããã§ãã
äžè¬çã«ãäºæ³ã©ããã圌ãã¯éèŠã®ãããã®ãæããŸãã
åŠçã¯æåã®ä»äºããå°éçãªæé·ãæåŸ ããã¯ãŒã¯ã©ã€ã ãã©ã³ã¹ã XNUMX çªç®ïŒåœã«ãã£ãŠã¯ XNUMX çªç®ïŒãèå³æ·±ãä»äºã XNUMX çªç®ã«ãªããŸãã
ããã°ã©ãã³ã°èšèªãšãœãããŠã§ã¢ã®çš®é¡å¥ã®éçºè
人å£ã®åæ
Web ã¢ããªã±ãŒã·ã§ã³ã¯æšå® 16.9 äžäººã®éçºè
ãæãã第 13.6 äœãšãªã£ãŠããŸãã ãŸããŸãSlashDataã§ãã 次ã«ããã¯ãšã³ã ãµãŒãã¹ (13.1 äžä»¶)ãã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ (12.3 äžä»¶)ããã¹ã¯ããã (XNUMX äžä»¶) ã§ãã AR/VR ããã³ IoT ã»ã¯ã¿ãŒã¯åŸã
ã«äººæ°ãé«ãŸã£ãŠãããAI/ML/ããŒã¿ ãµã€ãšã³ã¹ã¯éå» XNUMX 幎éã§å€§å¹
ã«æé·ããŸããã
JavaScript ã¯æãæ¥éã«æé·ããŠããããã®ã³ãã¥ããã£ã¯ãã§ã«æ倧ã§ããã2018 幎ã ã㧠2.5 äžäººå¢å ããŠããŸãã 圌ãã¯ãIoT ã ML ã®åéã§ããããæžã蟌ãããšããŠããŸãã
Python ã¯ãäŒçµ±çã«åŸæãšãã ML ã®äººæ°ã®é«ãŸããšãèšèªã®åŠç¿ã®å®¹æããšå©äŸ¿æ§ã«ããã2018 幎㫠2.2 äžäººå¢å ããŸããã
JavaãC/C++ãC# ã¯ãéçºè å šäœã®äººå£ãããé ãããŒã¹ã§æé·ããŠããŸãã çŸåšã§ã¯ã人ã ãæåã«éžæããããã°ã©ãã³ã°èšèªã¯ã»ãšãã©ãããŸããã ããã§ã®éçºè ã«å¯ŸããéèŠã¯ãå€ããå°ãªããäŸçµŠãšãã©ã³ã¹ãåããŠããŸãã Android ããªãã£ãã Java ã®æé·ã¯ããã«é ãã£ããšæããŸãã
PHP 㯠32 çªç®ã«äººæ°ã®ãã Web ã¢ããªã±ãŒã·ã§ã³ ããã°ã©ãã³ã°èšèªã§ããããããå€§å¹ ã«æé·ããŠããŸã (2018 幎ã«ã¯ 5.9%)ã ãã®ã³ãã¥ããã£ã«ã¯ XNUMX äžäººã®éçºè ããããšæšå®ãããŠããŸãã PHP ã®è©å€ã¯äºæ¥µåããŠããŸãããåŠç¿ã¯éåžžã«ç°¡åã§ãåºã䜿çšãããŠããŸãã
以åã®äžä»£ãšæ¯ã¹ãŠãä»æ¥ã®è¥ãåéšè ã¯ã©ã®ããã«å匷ããŠããŸãã?
åã³HackerRankããŒã¿ã çŸåš 38 ïœ 53 æ³ã®äººã¯ãæåã®ãããžã§ã¯ããšããŠã²ãŒã ãæããŠããŸãã
ã¡ãªã¿ã«ãç§ã®æåã®å€ããå°ãªããå®çšçãªãããžã§ã¯ãã¯ãç¡å¶éã®ãã£ãŒã«ãã§é£ç¶ããŠæ倧 15 åã®ãäžç®äžŠã¹ãã§ãã£ãããšã確èªããŸããXNUMX çªç®ã®ãããžã§ã¯ã㯠XNUMX 人ã®ã²ãŒã ã§ããã
çŸä»£ã®åå¿è ããã°ã©ã㌠(21 æ³ãŸã§) ã¯ãæåã®ãããžã§ã¯ããšããŠé»åãš Web ãµã€ããäœæããŸãã
X äžä»£ã®ä»£è¡šè ã®ãã¡ãã»ãŒåæ°ã 16 æ³ä»¥åã«ã³ãŒããæžãå§ããå€ã㯠5 æ³ãã 10 æ³ãŸã§ã«ã³ãŒããæžãå§ããŸãã (äž»ã«çŸåš 35 æ³ãã 45 æ³ã®é)ã ãã®çç±ã¯å€ããå°ãªããæããã§ããæ å ±æºãã»ãšãã©ãªãã£ããããããã°ã©ããŒã«ãªãã«ã¯æ¬æ°ã§ãããæãŸãªããã°ãªãããæ¬åœã«ãããæãã 人ã¯æ©ãããããã°ã©ãã³ã°ãå§ããŸããã ããã»ã©æãã§ããªãã£ã人ãã¡ã¯ãä»ã§ã¯å¥ã®è·æ¥ã«å°±ããŠããå¯èœæ§ãé«ãããã瀟äŒåŠã®å šäœåã¯ãŸãã«ãããšåãã§ãã
ä»æ¥ã®è¥ãåè£è
ã®ãã¡ã20 æ³ãŸã§ã«ããã°ã©ãã³ã°ãå§ãã人㯠16% ã®ã¿ã§ã倧å㯠16 æ³ãã 20 æ³ã®éã§ãã ããããåŠç¿è
ã«ãšã£ãŠãã¯ããã«ç°¡åã«ãªããããã¢ã¯ã»ã¹ãããããªããŸããã
æèŠ
ä»æ¥ãåå¿è ã® Web ããã¯ãšã³ãéçºè ã« SQL ãå¿ èŠãã©ãããšãã質åã«å¯Ÿããå ·äœçãªçãã¯ãŸã èŠã€ãããŸããããçŸä»£ã®ããã°ã©ããŒéå£ã«ã€ããŠã®ç§ã®èãã¯ä¿®æ£ãããŸããã
次äžä»£ã®éçºè ã¯æ®éã®äººã ã§ãããããæå³ã§ä»¥åã®éçºè ã«äŒŒãŠããŸãããäœå® åé¡ã¯åœŒããå°ç¡ãã«ããã ãã§ãã 圌ãã¯éçšäž»ã«ãã£ãŠçã¿åºãããéèŠãæºãããŸãã ãã䟿å©ãªããŒã«ããã¬ãŒã ã¯ãŒã¯ã®ãããã§ãããã«çµæãåºããããã«ãªãããã®è·æ¥ã«å°±ãæ·å± ã¯äœããªããŸããã çŸåšãããã°ã©ããŒã«ãªã人ãå¢ããŠããŸããããžã¿ã«äžä»£ (Z äžä»£) ã¯ãçãŸãããšããããã¯ãããžãŒã®äžã§çããŠããŸããã圌ãã«ãšã£ãŠãããã°ã©ããŒã¯ä»ã®è·æ¥ãšæ¯ã¹ãŠãéè²ãªããäžè¬çãªè·æ¥ã§ãã
L1 ãã£ãã·ã¥ã®ã¬ã€ãã³ã·ãçŽ 4 ãµã€ã¯ã«ã§ããããšãããã³ãã£ãã·ã¥ ã©ã€ã³ãäžå¿ èŠã«ã¯ã©ãã·ã¥ãããªãæ¹ãããããšãç¥ã£ãŠãã人ã ã¯ãç·äººå£ãµã€ãºã«å ããå²åãå°ãããªãã€ã€ãããŸãã ãã ããä»äºã®ç²åŸã«ã€ããŠå¿é ããå¿ èŠã¯ãããŸãããçµå±ã®ãšãããäŸç¶ãšããŠå¿ èŠãšãããã¬ãã«ã®äœããã®ãæžããªããã°ãªããŸããã åæ§ã«ãã·ã¹ãã èšèšã«é¢ããæ·±ãåºç€ç¥èãæã¡ããããè¡ã¿ã©ãã®å®æŠã§ç²åŸãããã 貚ç©ã«ã«ãã«åŸãã ãã§ã¯ãªã人ããå¿é ããå¿ èŠã¯ãããŸããã ãªããªããããŒã ã«ã¯ãã³ãŒããæžãã ããããã¬ãŒã ã¯ãŒã¯ãã䜿ãã ãããã§ãã人ãå¢ããã ãããããäœå¹Žãç®çããªãéãããèãé£ãèŠçãé¿ãããããã«ã¯ããã®ãããªäººã ãã§ãã©ã³ã¹ããšãå¿ èŠãããããã§ããã ã
ãœããã¹ãã«ã¯ãæãŸããã«ããŽãªãŒããå¿ é ã®ã«ããŽãªãŒãžãšåŸã ã«ç§»è¡ãã€ã€ãããŸãïŒããã確èªããããã®å®¢èŠ³çãªããŒã¿ã¯ãããŸããããã å®éã«èŠ³å¯ããã ãã§ãïŒã ããã°ã©ããŒã®æ°ã¯å¢å ããŠãããçŽæ¥çãŸãã¯éæ¥çãªå¶åŸ¡ãéããŠå šå¡ãçµæãéæããããæ瀺ãããå¿ èŠãããããããããŸãã«ãœãã ã¹ãã«ãå¿ èŠãšããããã®ã§ãã
ãIT ã«åå ¥ããšããã®ã¯ãããã°ã©ããŒã®åå ¥ãåçã®ãé ITãã¹ãã·ã£ãªã¹ãã®åå ¥ãšå€§ããç°ãªãå°åã«ç¹æã®ãå°æ¹ç¹æã®è©±ã§ããããã«ç§ã«ã¯æããŸãã ç§ãäœãã§ãããã³ã¹ã¯ã§ã¯ãããã¯äžè¬çã«å€§è¡éåã§ããã誰ããåæããITã«å ¥ãæ¹æ³ã«é¢ããæ°ããã³ãŒã¹ã®åºåãæ¯æ¥ç®ã«ããæž æäŒç€Ÿã¯ããã°ã©ããŒãã¿ãŒã²ããã«ããã®åçã®ã³ãŒããããããŸããïŒããšããã¡ãã»ãŒãžãéããŸããã ã€ãŸããã¢ããŒãã®æé€ãããªããŠã倧äžå€«ã§ããç§ãã¡ããã¹ãŠå¯Ÿå¿ããŸããã ã€ã³ãã®äžéšã§ãåæ§ã®ããšãèµ·ããŠããããã ã ããã蚌æããããŒã¿ããããŸããã
äžè¬ã«ãç§ã®æèŠã§ã¯ãããã°ã©ããŒã®äººå£ãè ãããã®ã¯äœããããŸããã æ¥äžã¯æ¬ç©ã®ããã°ã©ããŒãèŠã€ããããšãã§ããªãããåè£è ã¯ãäœãç¥ããªããããšãéåžžã«å€ããšããäºå®ã«ã€ããŠããããã¹ãããŠãæå³ããããŸããã 圌ãã¯ãæ¬ç©ã®ããã°ã©ãããšåããããè³¢ããŠæèœã§ããããããã以äžã«è³¢ããŠæèœã§ãããæ¥éã«æé·ããåžå Žãå¿ èŠãšããç¥èãç²åŸããã ãã§ããŸã å¿ èŠã®ãªããã®ã¯åŸåãã«ããæ£ããå©çããããããªãã§ããããä»ã 圌ãã¯ãŸã åŠã³ããã®ã§ãå¿ èŠãªãšãã«åŠã³ãŸãã ããããã誰ãããããå®è¡ã§ããããã§ã¯ãããŸãããã誰ãããããå¿ èŠãšããããã§ããããŸãããè¿ãå°æ¥ãåžå Žã¯ãäœããã®ãã¬ãŒã ã¯ãŒã¯ã䜿çšããŠå¥ã®ã¢ããªã±ãŒã·ã§ã³ã®ã³ã³ã»ãããçŽ æ©ãçµã¿ç«ãŠãããšãã§ãã人ãç°¡åã«åãå ¥ããã§ãããã
ç»é²ãŠãŒã¶ãŒã®ã¿ãã¢ã³ã±ãŒãã«åå ã§ããŸãã
Web ããã¯ãšã³ããŒã®é¢æ¥ã«ã¯ SQL ã®ç¥èãå¿ èŠã§ãã?
-
ã¯ããä»äºã§å¿ èŠãªã®ã§èŠæ±ããŸã
-
ã¯ããä»äºã§ã¯ã»ãšãã©å¿ èŠãããŸããããå¿ èŠã§ãã
-
ããããå¿ èŠãããŸãããNoSQL ããããŸã
-
ããããå¿ èŠãããŸãããORM ããã¹ãŠè¡ããŸã
320 人ã®ãŠãŒã¶ãŒãæ祚ããŸããã 230åã®ãŠãŒã¶ãŒãæ£æš©ããã
åºæïŒ habr.com