ããŒã³ãŒã ããŒã¿ããŒã¹ ãœãããŠã§ã¢ã¯ãåŸæ¥ã®ã³ãŒãã SQL ã¯ãšãªãèšè¿°ããå¿ èŠãªããããŒã¿ããŒã¹ã®äœæã管çãå©çšã容æã«ããããšãç®çãšãããœãããŠã§ã¢éçºã«ãããçŸä»£ã®ãã©ãã€ã ã§ããè€éãªããŒã¿ããŒã¹æäœãæœè±¡åããŠç°¡çŽ åããããã«èšèšãããå€ãã®ã¡ãœãããšããŒã«ãã«ãã»ã«åããŠãããããããŒã¿ããŒã¹ã®åŠçãæ°äž»åããã æè¡è 以å€ã®ãŠãŒã¶ãŒã§ã ããŒã¿ããŒã¹ ã·ã¹ãã ãæäœããã³ä¿å®ã§ããããã«ãªããŸãã
äž»ãªæ©èœ:
ããžã¥ã¢ã« ã€ã³ã¿ãŒãã§ã€ã¹: ã°ã©ãã£ã«ã« ãŠãŒã¶ãŒ ã€ã³ã¿ãŒãã§ã€ã¹ (GUI) ãæ¡çšãããŠãŒã¶ãŒãçŽæçãªdrag-and-dropæäœãéããŠããŒã¿ããŒã¹ ã¹ããŒããšå¯Ÿè©±ããé¢ä¿ãäœæããããŒã¿ã管çã§ããããã«ããŸãããŠãŒã¶ãŒã¯ãããŒãã«ããã£ãŒã«ãããªã¬ãŒã·ã§ã³ã·ãããèŠèŠçã«äœæããããžãã¹ ããžãã¯ãå®çŸ©ããããšãã§ããŸãã
ã¹ã±ãŒã©ããªãã£: éèŠã®å€åã«å¿ããŠå¹ççã«ã¹ã±ãŒãªã³ã°ãããšã³ã¿ãŒãã©ã€ãºããã³é«è² è·ã®ãŠãŒã¹ã±ãŒã¹ãšã®ããã©ãŒãã³ã¹ã®äºææ§ãå®èšŒããŸããããã¯ãæå 端ã®ã³ã³ãã€ã«æžã¿ãµãŒã㌠ã¢ããªã±ãŒã·ã§ã³ãéããŠå®çŸã§ããŸãã
çµ±åãšçžäºéçšæ§: Webãã¢ãã€ã«ãããã¯ãšã³ã ã·ã¹ãã ãªã©ã®ããŸããŸãªã¢ããªã±ãŒã·ã§ã³ãšã®ã·ãŒã ã¬ã¹ãªçµ±åã Postgresql ãªã©ã®æšæºããŒã¿ããŒã¹ ãšã³ãžã³ãšã®äºææ§ãæäŸããæ¢åã®ãã¯ãããžãŒ ã¹ã¿ãã¯ãšã®çžäºéçšæ§ãå¯èœã«ããŸãã
èªåçæ: ã¢ããªã±ãŒã·ã§ã³ãããã¥ã¡ã³ããç§»è¡ã¹ã¯ãªãããèªåçã«çæããåžå Žæå ¥ãŸã§ã®æéãå€§å¹ ã«ççž®ããŸãã
ã¡ã³ããã³ã¹ãšæŽæ°: ãµãŒããŒäž»å°ã®ã¢ãããŒããæ¡çšãããŠãŒã¶ãŒã¯ããŒãžã§ã³ãåéä¿¡ããããšãªãã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ã® UIãããžãã¯ãAPI ããŒãæŽæ°ã§ããŸããèŠä»¶ã®å€æŽæã«ã¢ããªã±ãŒã·ã§ã³ãæåããåçæããããšã§ãæè¡çè² åµãæé€ããŸãã
æ¥çã§ã®å¿çš:
äžå°äŒæ¥ããå€§äŒæ¥ãŸã§: ã³ãŒãäžèŠã®ããŒã¿ããŒã¹ ãœãããŠã§ã¢ã¯ãããããèŠæš¡ã®çµç¹ã«äŸ¡å€ããããããããŸããŸãªæè¡çå°éç¥èãæã€ãŠãŒã¶ãŒãããŒã¿ããŒã¹ãèšèšãå±éã管çã§ããããã«ããããšã§ã€ãããŒã·ã§ã³ãä¿é²ããŸãã
E ã³ããŒã¹ ãã©ãããã©ãŒã : ãªã³ã©ã€ã³å°å£²ã«äŒŽã倧éã®ååŒéãšè€éãããµããŒãããå¹ççãªã«ã¿ãã°ç®¡çãåšåº«è¿œè·¡ã顧客ããŒã¿åæãå¯èœã«ããŸãã
ãã«ã¹ã±ã¢ ã·ã¹ãã : å®å šã§æ©æãªããŒã¿ããŒã¹ ã·ã¹ãã ãéããŠãæ£è æ å ±ã®ç®¡çãäºçŽã®ã¹ã±ãžã¥ãŒã«èšå®ãããã³æ³èŠå¶ãžã®æºæ ã容æã«ããŸãã
äž»èŠãªãã©ãããã©ãŒã ã®äŸ - AppMaster:
ããŒã³ãŒã ããŒã¿ããŒã¹ ãœãããŠã§ã¢ã®æ³šç®ãã¹ãäŸã® 1 ã€ã¯ãããã¯ãšã³ããWebãããã³ã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ãäœæããããã«èšèšããã匷å㪠ããŒã³ãŒã ããŒã«ã§ ããAppMasterã§ããç«¶åä»ç€Ÿãšäžç·ãç»ãåºç¯ãªæ©èœãæäŸããŠããã顧客ã¯ããžã¥ã¢ã«ãª BP ãã¶ã€ããŒãREST APIãããã³ WSS ãšã³ããã€ã³ããéããŠããŒã¿ ã¢ãã« (ããŒã¿ããŒã¹ ã¹ããŒã) ãšããžãã¹ ããžãã¯ãäœæã§ããŸãã AppMasterãã©ãããã©ãŒã ã¯ãPostgresql ãšäºææ§ã®ããããŒã¿ããŒã¹ããã©ã€ã㪠ããŒã¿ããŒã¹ãšããŠäœ¿çšã§ãããšã³ã¿ãŒãã©ã€ãºããã³é«è² è·ã®ãŠãŒã¹ã±ãŒã¹åãã®æ¡åŒµæ§ã瀺ããŸãã AppMaster ãå®è¡å¯èœãã¡ã€ã«ããœãŒã¹ ã³ãŒããå«ãã¢ããªã±ãŒã·ã§ã³ã 30 ç§ä»¥å ã«çæã§ããæ©èœã«ãããã¢ããªã±ãŒã·ã§ã³éçºã«é©åœããããããã¢ããªã±ãŒã·ã§ã³éçºã 10 åé«éåãã3 åã®ã³ã¹ãå¹çãé«ããŸããããã«ã AppMasterå æ¬çãªãœãããŠã§ã¢éçºãžã®åãçµã¿ãåæ ããŠãSwagger (ãªãŒãã³ API) ããã¥ã¡ã³ããšããŒã¿ããŒã¹ ã¹ããŒãç§»è¡ã¹ã¯ãªãããèªåçã«çæããŸãã
ããŒã³ãŒã ããŒã¿ããŒã¹ ãœãããŠã§ã¢ã¯ãIT ç°å¢ã«ãããå€é©ã®äžæ©ãäœçŸããåå ¥éå£ãæã¡ç Žããæ°æä»£ã®ã€ãããŒã·ã§ã³ãè§£ãæŸã¡ãŸããåŸæ¥ã®ããã°ã©ããè¶ ããŠããŒã¿ããŒã¹ãæäœããã³æŽ»çšããèœåãæ¡åŒµãããããå¹ åºããŠãŒã¶ãŒãææçŸ©ãªããŒã¿ããŒã¹å¯Ÿè©±ã«åå ã§ããããã«ãªããŸãã
AppMasterã®ãããªãã©ãããã©ãŒã ã¯ãããŒã³ãŒã ããŒã¿ããŒã¹ ãœãããŠã§ã¢ãæ¥çã«ããããå¹çæ§ãã¹ã±ãŒã©ããªãã£ãæè»æ§ãäœçŸããçŸä»£ã®æ©æãªããžãã¹ã®ããŒãºã«å¿ãããã©ãã€ã ã·ããããããããŸããããŒã³ãŒã ããŒã¿ããŒã¹ ãœãããŠã§ã¢ã®å©çšã¯ãããžã¿ã«æä»£ã®åŒ·åãªããŒã«ãšããŠã®å¯èœæ§ãåæ ããŠãããŸããŸãªåéã«æ¡å€§ãããšäºæž¬ãããŠããŸãã