ããŒã¿ ã¢ããªã³ã°ã®ã³ã³ããã¹ãã§ã¯ãããŒã¿åã¯ãç¹å®ã®èŠçŽ ã屿§ããŸãã¯å€æ°ãããŒã¿ããŒã¹ãŸãã¯ã³ã³ãã¥ãŒãã£ã³ã°ç°å¢ã§ä¿æãŸãã¯ä¿åã§ããããŒã¿ã®ã¿ã€ããå®çŸ©ããéèŠãªæŠå¿µã§ããããŒã¿åã¯ãããŒã¿ããŒã¹ ã¹ããŒãã®äœæãå¶çŽã®ç¢ºç«ãã¢ããªã±ãŒã·ã§ã³å šäœã§ã®ããŒã¿ã®äžè²«æ§ãšæŽåæ§ã®ç¢ºä¿ã®ããã®æ§æèŠçŽ ã§ãããããããŒã¿ ã¢ããªã³ã°ã«ãããŠéèŠãªåœ¹å²ãæãããŸããããŒã¿ ã¢ããªã³ã°ã¯AppMasterãã©ãããã©ãŒã ã®éèŠãªåŽé¢ã§ãããå ç¢ãªããã¯ãšã³ããWebãããã³ã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ãæ§ç¯ããããã®ããŒã¿ ã¢ãã«ãèŠèŠçã«äœæã§ããããã«ãªããŸãã
ããŒã¿åã¯ãããŸããŸãªããŒã¿èŠçŽ ã«æ§é ãšç·šæãæäŸããããå¹ççãªããŒã¿ããŒã¹ç®¡çãšã¯ãšãªã®æé©åã«ã€ãªãããããäžå¯æ¬ ã§ããããŒã¿ ã¿ã€ãã¯ããŒã¿ ã¢ããªã³ã°ã®åºæ¬ã§ãããREST API ã®å ¥åºåãã©ã¡ãŒã¿ãŒã®æ§é åããGo (golang)ãVue3ãKotlinã SwiftUIãªã©ã®ããã°ã©ãã³ã°èšèªã§ã®ããŒã¿ã®åé¡ãªã©ããœãããŠã§ã¢éçºã®ä»ã®é åã§ãé »ç¹ã«å©çšãããŸãã
ããŒã¿åã¯ã¹ã«ã©ãŒãŸãã¯ã³ã³ããžããã«ããããšãã§ããŸããã¹ã«ã©ãŒ ããŒã¿åã¯ããã¹ããæ°å€ãæ¥ä»ãªã©ã®åäžã®å€ã衚ããŸãããè€åããŒã¿åã¯è€æ°ã®å€ãã«ãã»ã«åããä»ã®ããŒã¿åã§æ§æããããšãã§ããŸãã
ããŒã¿ ã¢ããªã³ã°ã§äžè¬çã«äœ¿çšãããããŒã¿åã«ã¯æ¬¡ã®ãããªãã®ããããŸãã
- ããã¹ã: æåãæ°åãèšå·ãªã©ã®äžé£ã®è±æ°åã衚ããŸããäŸã«ã¯ãVARCHARãCHARãTEXT ãªã©ããããŸãã
- æ°å€: æŽæ°ãæµ®åå°æ°ç¹æ°ãªã©ãããŸããŸãªåœ¢åŒã§æ°å€ã衚ããŸããäŸã«ã¯ãINTEGERãFLOATãDECIMALãREAL ãªã©ããããŸãã
- æ¥ä»ãšæå»: ããŸããŸãªã¬ãã«ã®ç²ŸåºŠã§æå»ãšæ¥ä»ã®å€ã衚ããŸããäŸã«ã¯ãDATEãTIMEãTIMESTAMP ãªã©ããããŸãã
- ããŒã«å€: ãã€ããªå€ãã€ãŸã true ãŸã㯠false ã衚ããŸãã
- ãã€ããª: ãã€ã㪠ããŒã¿ (ã€ãŸãããã€ãã®ã·ãŒã±ã³ã¹) ã衚ããŸããäŸãšããŠã¯ãBLOB ã BYTEA ãªã©ããããŸãã
è€åããŒã¿åã«ã¯æ¬¡ã®ãã®ãå«ãŸããŸãã
- é å: å ±éã®ããŒã¿åãæã€èŠçŽ ã®é åºä»ããããã³ã¬ã¯ã·ã§ã³ã衚ããŸããäŸã«ã¯ãPostgreSQL ã® ARRAY ãå«ãŸããŸãã
- JSON: è€éãªããŒã¿æ§é ãæ ŒçŽã§ãã軜éã®ããŒã¿äº€æåœ¢åŒã§ãã JavaScript Object Notation ã衚ããŸããäŸã«ã¯ãPostgreSQL ã® JSON ãš JSONB ãå«ãŸããŸãã
- 幟äœåŠç: ç¹ãç·ãå€è§åœ¢ãããã³ãããã®é¢ä¿ãªã©ã®å¹ŸäœåŠçããã³ç©ºéããŒã¿ã衚ããŸããäŸãšããŠã¯ãPostgreSQL ã® POINTãLINEãPOLYGON ãªã©ããããŸãã
AppMasterãã©ãããã©ãŒã ã®ããŒã¿ ã¢ããªã³ã°ã«ã¯ãããŒãã«ã®åãšå±æ§ã®å®çŸ©ãããããžãã¹ ããã»ã¹ã API endpointsã®å ¥åºåãã©ã¡ãŒã¿ãŒã®æå®ã«è³ããŸã§ãããããåŽé¢ã§ããŒã¿åã®äœ¿çšãå«ãŸããŸãããã®ããã AppMasterãã©ãããã©ãŒã ãæå€§éã«æŽ»çšããã¢ããªã±ãŒã·ã§ã³ã®æé©ãªããã©ãŒãã³ã¹ãéæããã«ã¯ãããŒã¿åããã£ãããšçè§£ããããšãäžå¯æ¬ ã§ãã
ããŒã¿åã®æ©èœã掻çšããããšã§ã AppMaster䜿çšãããšããŠãŒã¶ãŒã¯åªããã¹ã±ãŒã©ããªãã£ã埩å åãã»ãã¥ãªãã£ãèªãã¢ããªã±ãŒã·ã§ã³ãäœæã§ããŸããããã«ããã®ãã©ãããã©ãŒã ã¯ãªãŒãã³æšæº (OpenAPI ãããŒã¿ããŒã¹ ã¹ããŒãç§»è¡ã¹ã¯ãªãããªã©) ã«æºæ ããŠãããããæ¢åã®ã€ã³ãã©ã¹ãã©ã¯ãã£ãšã®ã¹ã ãŒãºãªçµ±åãšããã©ã€ã㪠ããŒã¿ ã¹ãã¬ãŒãžãšããŠã® PostgreSQL äºæããŒã¿ããŒã¹ãšã®äºææ§ãä¿èšŒãããŸãã
ããã«ã AppMaster㯠10 åã®é床㧠3 åã® 1 ã®ã³ã¹ãã§ãæè¡çè² åµãè² ãããšãªãã¢ããªã±ãŒã·ã§ã³ãçæã§ãããããããããèŠæš¡ã®äŒæ¥ã«ãšã£ãŠé åçãªææ¡ãšãªããŸãã AppMasterã®èŠèŠçã«èšèšãããããžãã¹ ããã»ã¹ã¯ãããŒã¿åãå©çšããŠè«ççã§ãšã©ãŒã®ãªããããŒãæ§ç¯ããããã«ãã£ãŠé«å質ã®ãœãããŠã§ã¢ ãœãªã¥ãŒã·ã§ã³ãä¿èšŒããŸãã
çµè«ãšããŠãããŒã¿ ã¿ã€ãã¯ããŒã¿ ã¢ããªã³ã°ã®åºç€ã圢æãããœãããŠã§ã¢éçºã«ã¯äžå¯æ¬ ã§ãããããã¯ãã¢ããªã±ãŒã·ã§ã³å ã§åŠçããã³åæãããããŒã¿ã«æ§é ãç·šæãããã³æŽåæ§ãæäŸããããã«ååšããŸãã AppMaster ãData Types ã®æ©èœãæå€§éã«æŽ»çšããå人ã®éçºè ããæ¬æ ŒçãªäŒæ¥ã«è³ããŸã§ãå¹ åºããŠãŒã¶ãŒ ããŒãºã«å¿ããæå 端ã®ããã¯ãšã³ããWebãããã³ã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ãéçºããããã®åºç€ãšããŠäœ¿çšããŸãã ã