


Simplã¯ãPostgreSQLå°çšã«æ§ç¯ããããã¹ã¯ãããããŒã¿ããŒã¹ãã©ãŠã¶ã§ããæ¥ç¶æååã1å以å ã«ã¯ãªãŒã³ã§ãã©ãŠãžã³ã°å¯èœãªã€ã³ã¿ãŒãã§ãŒã¹ã«å€æããŸããèšå®ãŠã£ã¶ãŒããè€éãªã»ããã¢ããã¯äžèŠãããŒã¹ãããŠæ¥ç¶ããããŒã¿ã®æ¢çŽ¢ãå§ããã ãã§ããæ±ãã«ãããšã³ã¿ãŒãã©ã€ãºããŒã«ãããŸãå¥ã®ã«ã¹ã¿ã 管çããã«ãç¶æããæéããã®ããããããªä»£æ¿ææ®µã§ãã
PostgreSQLã®æ¥ç¶æååãããŒã¹ãããã ãã§ãSimplãæ®ããåŠçããŸããè³æ Œæ å ±ã¯AES-256ã§æå·åããæ¥ç¶ããã¹ãããã¹ããŒãïŒããŒãã«ãã«ã©ã ããªã¬ãŒã·ã§ã³ã·ãããããŒã¿åïŒãèªåæ€åºããŸããã»ããã¢ãããŠã£ã¶ãŒããèšå®ãã¡ã€ã«ã¯äžèŠã§ãã
ãã©ãŠãžã³ã°äžã«å€éšããŒãèªç¶ã«èŸ¿ããŸããé¢é£ã¬ã³ãŒããã¯ãªãã¯ããŠç§»åããã³ã³ããã¹ãã倱ãããšãªãããŒãã«éãç§»åã§ããŸããçã®SQLçµåãšæ Œéããã®ã§ã¯ãªããæŽçãããã°ã©ããæ¢çŽ¢ããŠãããããªæèŠã§ãã
SQLãäžè¡ãæžããã«è€éãªã¯ãšãªãæ§ç¯ã§ããŸããåãèªèãããã£ã«ã¿ãŒã¯ãããã¹ããæ°å€ãæ¥ä»ãããŒã«å€ãªã©ã«å¯Ÿå¿ãã¯ãšãªèšèªã®ç²ŸåºŠããæ§æã®ãªãŒããŒããããªãã§å®çŸããŸãã
詳现ãã¥ãŒã§åã ã®ãã£ãŒã«ããçŽæ¥ç·šéã§ããŸããååºæã®å ¥åã¯ãæ¥ä»ãJSONãªã©ã®ããŒã¿åãæ£ããåŠçããŸããã¬ã³ãŒããçŽ æ©ãä¿®æ£ããããšãã«å€§ããªéããçãã现ãããªãããéèŠãªæ©èœã§ãã
ãããªãã®è³æ Œæ å ±ãç§ãã¡ã®ãµãŒããŒã«è§Šããããšã¯æ±ºããŠãããŸãããããªãã®ããŒã¿ã¯ãããã¹ãå Žæãã€ãŸãããªãã®ãã·ã³ã«çãŸããŸããã
Simplã¯ãã¹ã¯ãããã¢ããªãšããŠåäœãããããããŒã¿ããŒã¹ã®è³æ Œæ å ±ã¯ããŒã«ã«ã«ä¿åãããããã€ã¹äžã§æå·åãããŸããã¯ãšãªã¯ã³ã³ãã¥ãŒã¿ããããŒã¿ããŒã¹ãžçŽæ¥éä¿¡ãããŸãããããã·ãµãŒããŒãäžéæ¥è ãå€éšã€ã³ãã©ãééããããŒã¿ã¯äžåãããŸããããããã¯ã·ã§ã³ããŒã¿ã«æ¥ç¶ããããŒã«ãšããŠã¯ãæå³ã®ããã»ãã¥ãªãã£äœå¶ã§ãã
PostgreSQLã䜿çšããŠãããã»ããã¢ãããéãã䜿ãå¿å°ãè¯ãããã©ã€ãã·ãŒãå°éããããŒã¿ããŒã¹ãã©ãŠã¶ããæ¢ãã®æ¹ãäžåºŠè³Œå ¥ããã ãã§ïŒç涯ã¢ã¯ã»ã¹$49ïŒãç¡å¶éã®æ¥ç¶ãã¹ããŒãæ¢çŽ¢ãã«ã¹ã¿ã ã«ã©ã ã¬ã€ã¢ãŠããåªå ãµããŒããå©çšã§ããŸããé«é¡ãªã·ãŒãåäœã®ããŒã«ããèªåã§ç®¡çããã«ãç¶æããããšã«ããããããŠãããªããSimplã¯æ€èšãã䟡å€ããããŸãã
æ€èšãã¹ãä»ã®ããŒã«
Loading commentsâŠ
ã¡ãŒã«ãŒ
mocha_byte
ãŠã§ããµã€ããèŠã
simpl.sh
ãããžã§ã¯ãæ å ±
補åããŒã¯ãŒã
å®çžŸ