GMOã¯ã©ã¦ãALTUS(ã¢ã«ã¿ã¹)ã¨å¥ç´ãã¦ãéçºããDjangoã¢ããªã±ã¼ã·ã§ã³ã Nginx + uWSGI + MySQL + Python3 ã®ç°å¢ã«ãããã¤ããã®ã§ãå®è¡ããæä½ãåå¿é²ã¨ãã¦æ®ãããã¨æãã¾ããåãªã使¥ã¡ã¢ãªã®ã§ãå¿ ããããã¹ããã©ã¯ãã£ã¹ã§ã¯ãªããã¨ã«ã注æä¸ãããééããä¸è¶³ãããã°é æ ®ãªããææä¸ããï¼ç¬ï¼ éç¨ç°å¢ ã¾ããWSGI(Web Server Gateway Interface)ã¨ã¯ãPythonã§è¨è¿°ããã¢ããªã±ã¼ã·ã§ã³ã¨Webãµã¼ãã¼ã®éã®æ¨æºã¤ã³ã¿ã¼ãã§ã¼ã¹(PEP333)ã§ãuWSGIã¯WSGI仿§ã«å¾ã£ãWebã¢ããªã±ã¼ã·ã§ã³ãåãããã¨ãã§ããWebãµã¼ãã¼ãæãã¾ãã Djangoã§ä½æããã¢Webããªã±ã¼ã·ã§ã³ã¯WSGIã§åä½ããããã«è¨è¨ãã¦ãã¦ãæ§ã ãªæ§æã§éç¨ã§ããã®ã§ãããä»åã¯Pycon2015ã®Yuri Umez
ããæè¿é ã«èª¿æ»ä¾é ¼ãå¤ãã£ãã®ã§ãããªã®ã§èª¿æ»å ±åããªã©ãããããã¦ããã¾ããããçµæ§ä¸è¬çãªè©±é¡ã ã£ãã®ã§å°ãããã§ã御裾åããªã©ãã¦ã¿ããã¨æ³ãã¾ãã æ¢åµãæ®æ®µã¯çé¢ç®ã«èª¿æ»æ´»åããã¦ãããã¨ããçããã«å¯¾ãã¦è¦ãããããããªã®ã主ããç®çã§ããã¾ããç¡è«ã¨ãããå½ç¶ã®æ§ã«å§æ¯ã§ããã¾ãããã å æ¥ããã½ããã¦ã§ã¢ã»ã©ã¤ã»ã³ã¹ãã«ã¤ãã¦ã®è³ªåãããã¾ããã*1 質åå 容ã¯ã (1) LGPLã©ã¤ã»ã³ã¹ã®ã©ã¤ãã©ãªãæ¹é ãã¦è²©å£²ãããã¨ã£ã¦å¯è½ã§ããï¼ (2) å¯è½ãªå ´åã®å¶éã£ã¦ããã¾ããï¼ï¼ãã¨ãã°ã½ã¼ã¹ãå ¬éããªãã¦ã¯ãããªãã¨ãï¼ ä¸è¨ã®å¦ãã質åãæç¢ºãªã®ã§ããã®ã¿ã«çµããã¨ã¨ãã¾ããã調æ»å¯¾è±¡ã¯ããLGPLã®æ¹å¤ã¨é å¸ã ã«é¢ããå¶éãç¦æ¢äºé ãªã©ã 以ä¸ã調æ»å 容ã§ãã 0. This Document ç°¡æã§ã¯ããã¾ããã質åã«è©²å½ããäºé ã調ã¹ã¦ã¿ã¾ããããåèã¾ã§
ä¸è¨ã®ãããªã·ã¹ãã ã§ããã©ã¼ãã³ã¹ãè¯ãã㪠SQLite ã使ç¨äºå®ã§ããããã£ã¨éããã®ãç¡ãã確èªã®ããä»ã®ãã¼ã¿ãã¼ã¹ã®ããã©ã¼ãã³ã¹ãè¨æ¸¬ãã¦ã¿ã¾ãããSQL å©ç¨åæã§ãããNoSQL ãå§åçãªæ§è½ãåºãå ´åã¯æ¤è¨ããå¿ è¦ãããã®ã§ KVS ã確èªãã¾ããã ãã¼ã¿ä»¶æ°ã¯ 1 åä»¶ç¨åº¦ãJDBC SQL å©ç¨å¯è½ INSERTãUPDATE ã¯ããã SELECT ã¯ä¸»ãã¼ã¢ã¯ã»ã¹æ§è½ãéè¦ å°æ¥ã¹ã±ã¼ã«ã¢ã¦ãã®ããã®åæ£ã¯ããããããã¹ã¿ã³ãã¢ãã³ã§é ãã®ã¯ã ã ãã¼ã¿ãã¼ã¹ã®ããã©ã¼ãã³ã¹æ¯è¼ è¨æ¸¬ãããã¼ã¿ãã¼ã¹ ãã¼ã¿ãã¼ã¹å ã¿ã¤ã å½¢æ è©å¤ è¨æ¸¬ã«ã¤ãã¦ã®åè SQLite RDB çµã¿è¾¼ã¿ â»2 ããã¡ããAndroidæ¨æº JDBCæä½ â»1 H2 RDB çµã¿è¾¼ã¿ â»2 çµã¿è¾¼ã¿æé JDBCæä½ â»1 Derby RDB çµã¿è¾¼ã¿ â»2 Javaæ¨æºã§
æ¦è¦ ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ï¼relational databaseï¼ã¨ã¯ããã¼ã¿ãã¼ã¹ã®æ§é ã®ä¸ã¤ã§ãä¸ä»¶ã®ãã¼ã¿ãè¤æ°ã®å±æ§ã®å¤ã®çµã¨ãã¦è¡¨ç¾ããçµãåæãããã¨ã§ãã¼ã¿ãæ ¼ç´ãã¦ããæ¹å¼ã屿§ãåãçµãè¡ã¨ãã表(ãã¼ãã«)ã®å½¢ã§ç¤ºããããã¨ãå¤ããæãæ®åãã¦ããæ¹å¼ã§ãåã«ãã¼ã¿ãã¼ã¹ã¨ãã£ãå ´åã¯ãããæããã¨ãå¤ãã ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ã¢ãã«ï¼é¢ä¿ãã¼ã¿ã¢ãã«ï¼ã¨å¼ã°ããæ°å¦çãªã¢ãã«ã«åºã¥ãã¦ãã¼ã¿ãç§©åºç«ã¦ã¦æ ¼ç´ãããã¼ã¿éåã§ãããä¸ä»¶ã®ç»é²åä½ã¯è¤æ°ã®å±æ§ï¼attributeï¼ã®çµï¼tupleï¼ã§ãåã屿§ãæã¤çµãä½ä»¶ãéãããã¼ã¿ã®éåä½ããªã¬ã¼ã·ã§ã³ï¼é¢ä¿ï¼ã¨ããã ããã¯å®éã«ã¯ç¸¦æ¨ªã«é ç®ã並ãã 表ï¼ãã¼ãã«ï¼ã®å½¢ã§æ´çãããããªã¬ã¼ã·ã§ã³ã表ã«ç¸å½ãã屿§ã縦æ¹åã«ä¸¦ãã åï¼columnï¼ãçµã横æ¹åã«ä¸¦ãã è¡ï¼rowï¼ã¨ãã¦è¡¨ããã·ã¹ãã ã«ãã£ã¦ã¯è¡
é¢ä¿ã¢ãã«ã¯ãIBMã®ã¨ãã¬ã¼ã»Fã»ã³ãããèæ¡ã[2]ãç¾å¨ãã£ã¨ãåºãç¨ãããããã¼ã¿ã¢ãã«ã§ããããã¼ã¿ãã¼ã¹ã®å©ç¨è ã¯ãã¯ã¨ãªï¼åãæãï¼ããã¼ã¿ãã¼ã¹ã«ä¸ãããã¼ã¿ãæ¤ç´¢ãããã夿´ãããã¨ãã§ããã ãã¼ã¿ã¯è¡¨ã«ä¼¼ãæ§é ã§ç®¡çãããããé¢ä¿ï¼ãªã¬ã¼ã·ã§ã³ï¼ã¨å¼ã¶æ¦å¿µã§ã¢ãã«åããããé¢ä¿ï¼ãªã¬ã¼ã·ã§ã³ï¼ã¯çµï¼ã¿ãã«ã表ã«ãããè¡ã«ç¸å½ããï¼ã屿§ï¼ã¢ããªãã¥ã¼ãã表ã«ãããåã«ç¸å½ããï¼ãå®ç¾©åï¼ãã¡ã¤ã³ï¼ãåè£ãã¼ï¼ä¸»ãã¼ï¼ãå¤é¨ãã¼ãªã©ã«ãã£ã¦æ§æããããSQLãªã©ã«ä»£è¡¨ããããã¼ã¿ãã¼ã¹è¨èªï¼åãåããè¨èªï¼ãç¨ãã¦ãé¢ä¿ã«å¯¾ãã¦å¶éã»å°å½±ã»çµåã»åã»å·®ã»äº¤ãããªã©ã®é¢ä¿ä»£æ°æ¼ç®ï¼éåæ¼ç®ãå«ãï¼ãªããé¢ä¿è«çæ¼ç®ãè¡ããã¨ã§çµæãåãåºãã é¢ä¿ãè¤æ°æã¤ãã¨ãå¯è½ã§ãäºããé¢é£ããããã¨ãå¯è½ã§ããã ä¾ãã°ããé£åãæ±ãï¼æ¶ç©ºã®ï¼é信販売ä¼ç¤¾ã«ããã顧客管çãã¼ã¿ã
vagrantã§ubuntuã«å ¥ã£ã¦ãMySQLãæ¥æ¬èªæååããã¦ããã®ã§ãã®å¯¾å¿ã boxãã¡ã¤ã«ã¯ãã¡ããå©ç¨ãã¾ããã r8/vagrant-lamp ã¾ãç¾å¨ã®æåã»ãããç¢ºèª //mysqlãã°ã¤ã³ % mysql -u root -p mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database
Introduction The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that describes a Linux operating system, with an Nginx web server. The backend data is stored in MySQL and the dynamic processing is handled by PHP. In this guide, we will demonstrate how to install a LEMP stack on an Ubuntu 14.04 server. The Ubuntu opera
AWS ããã¸ã¡ã³ãã³ã³ã½ã¼ã«ã§æ°åã¯ãªãã¯ããã®ã¿ã§ãæ¬çªç°å¢ã§ããã«ä½¿ãã MySQL ãã¼ã¿ãã¼ã¹ãæ°åã§èµ·åãã¦æ¥ç¶ãã¾ããAmazon RDS for MySQL ã®ãã¼ã¿ãã¼ã¹ã¤ã³ã¹ã¿ã³ã¹ã¯äºåã«è¨å®ããã鏿ãããµã¼ãã¼ã¿ã¤ãã«åããã¦ãã©ã¡ã¼ã¿ã¨è¨å®ã決ãããã¦ãã¾ãããã¼ã¿ãã¼ã¹ãã©ã¡ã¼ã¿ã°ã«ã¼ãã§ã¯ãMySQL ãã¼ã¿ãã¼ã¹ã®è©³ç´°ãªç®¡çã¨å¾®èª¿æ´ãå¯è½ã§ãã ãã¼ã¿ãã¼ã¹ã®æ´æ°ãå¿ è¦ãªå ´åãAmazon RDS ãã«ã¼/ã°ãªã¼ã³ãããã¤ã¯ãããå®å ¨ã«ãããã·ã³ãã«ã«ãããéãæ´æ°ã§ããããã«è¨è¨ããã¦ãã¾ãã Amazon RDS ã§ã¯ãMySQL ãã¼ã¿ãã¼ã¹åãã« SSD ãã¼ã¹ã®ã¹ãã¬ã¼ã¸ãªãã·ã§ã³ã 2 ã¤ããã¾ããæ±ç¨ã¹ãã¬ã¼ã¸ã¯ãå°è¦æ¨¡ã¾ãã¯ä¸è¦æ¨¡ã®ã¯ã¼ã¯ãã¼ãåãã§ã³ã¹ãå¹çã®è¯ãã¹ãã¬ã¼ã¸ã§ããé«ããã©ã¼ãã³ã¹ã® OLTP ã¢ããªã±ã¼ã·ã§ã³ç¨ã¨ãã¦ãããã
MYSQLã®æ£è¦è¡¨ç¾ã«ããç½®æã«ã¤ã㦠<dammy>ââ</dammy> ã¨ããå¤ã <dammy>ÃÃ</dammy> ã«å¤æãããã¨èãã¦ãã¾ãã ââã®ãªãã«ã¯ãã©ããªå¤ãå ¥ã£ã¦ãããåããã¾ããã æ£è¦è¡¨ç¾ã使ãã°ãç½®æã§ããã¨æãã®ã§ããã ï¼ï¼¹ï¼³ï¼±ï¼¬ã§ã®ï¼³ï¼±ï¼¬ãæãã¦ãã ããã
mysqlã¯æ£è¦è¡¨ç¾ã®REGEXP颿°ãç½®æã®REPLACE颿°ãããããåæã«ä½¿ããªãã ãªã®ã§PHPãçµã¿åããã¦å©ç¨ããæ¹æ³ãåãã æ¬¡ã®PHPã¹ã¯ãªããã§ã¯ãfield1 ã«å ¥ã£ã¦ããæååããï¼ãã§çµãã£ã¦ããå ´åã«ããã®é¨åã ããåé¤ãã¦ããã âââââââââââââââââââââââââ <?php $pattern = âï¼$â; //æ£è¦è¡¨ç¾ã®ãã¿ã¼ã³ //mysqlã®æ£è¦è¡¨ç¾ã使ã£ã¦UPDATEã®å¯¾è±¡ã«ãªãã¬ã³ã¼ããåãåºãã $sql = âSELECT field1 FROM table1 WHERE field1 REGEXP ââ . $pattern . âââ; $result = mysql_query($sql) or die(mysql_error()); //sqlãå®è¡ //å ¨ã¦å±é while ($item = mysql_fetch_ar
SELECTãDELETEãã¾ã㯠BIGINT ãªã©ã®ç¹å®ã®èªã¯ããã¼ãã«åãã«ã©ã åãªã©ã®èå¥åã¨ãã¦ä½¿ç¨ããããã«äºç´ããã¦ãããç¹å¥ãªåãæ±ããå¿ è¦ã«ãªãã¾ããããã¯ãçµã¿è¾¼ã¿é¢æ°ã®ååã«ãå½ã¦ã¯ã¾ãå ´åãããã¾ãã ã»ã¯ã·ã§ã³9.2ãã¹ãã¼ããªãã¸ã§ã¯ãåãã§èª¬æãã¦ããããã«ãäºç´èªã¯ãå¼ç¨ç¬¦ã§å²ã¾ãã¦ããå ´åãèå¥åã¨ãã¦è¨±å¯ããã¾ãã mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... near 'interval (begin INT, end INT)' mysql> CREATE TABLE `interval` (begin INT, end INT); Query OK, 0 rows affe
MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full DatabaseHere is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup files.  The backup script handles innodb and myisam tables separately. You have to set the follow
A bash script to backup mysql databases, with separate schema and plain-text dump files (INSERT commands) for each database. Makes it easy to restore individual databases or copy them into dev/test servers. Keeps 30 days worth of backups in separate YYYY-MM-DD directories. Also dumps the mysql grants to a separate file âmysql-grants.txtâ, and creates a sometimes conveniently useful âmysql-create-d
MySQLã®ããã¯ã¢ãããè¡ãã«ã¯ã大ãã mysqlhotcopy ãä½¿ãæ¹æ³ã¨ mysqldump ãä½¿ãæ¹æ³ãããã¾ãã mysqlhotcopy ã¯ãã¼ãã«ãããã¯ãã¦ãã¼ã¿ãã¼ã¹ã®ãã¡ã¤ã«ããããã£ã¬ã¯ããªããã®ã¾ã¾ã³ãã¼ããæ¹æ³ã§ãã ãã ããMyISAM 㨠ARCHIVE ãã¼ãã«ã§ã®ã¿å©ç¨å¯è½ãªã®ã§InnoDBã使ã£ã¦ãããã¼ãã«ã¯ããã¯ã¢ããä¸å¯è½ã§ãã mysqldump ã¯ãã¼ã¿ãã¼ã¹ã®å 容ãSQLãã¡ã¤ã«ã«åºåããæ¹æ³ã§ãã mysqldumpã«ããããã¯ã¢ããã¯ã³ã¹ããé«ãã復å ã«ãæéãããããããªã®ã§ãInnoDB以å¤ã使ã£ã¦ããå ´åã§åããµã¼ãã§å¾©å ããå ´åã¯mysqlhotcopyã使ã£ãã»ããããããããã¾ããã ãã ãããã¯ã¢ãããã¡ã¤ã«ã®æ±ããããã¯mysqldumpã«å©ããããã¨æãã¾ãã(ããã¹ãã¨ãã£ã¿ã§ä¸èº«ç¢ºèªã§ãã¾ãããã) ãã¦ãä»å
ï¼è¨äºãé·ãããã®ã§åç·¨ã»ä¸ç·¨ã»å¾ç·¨ã«åãã¾ããï¼ åãããããªã¹ãã©ãããããªã¨ãããã£ãããªãã§ãããå æ¥Webãµã¼ãã¹ãå ¬éãã¾ããã ãã£ããã«ãªã£ãã®ã¯ãã®è¨äºã§ãã èªåã§WEBãµã¼ãã¹ãä½ãããã¨æã£ã¦ãã人㸠http://anond.hatelabo.jp/20101203150748 ãããªäºã§ãããè¯ããªãã¨æã£ã¦ããã¨ãä»ã«ããã£ã¦ããæ¹ãã¡ããã¾ããã ãã£ã2æ¥ã§è£½ä½ãããWebãµã¼ãã¹ããé¨å±æããã£ã¦ï¼ http://matome.naver.jp/odai/2131952812556433001 WEBãµã¤ããçºæ³¨ãã¦ã¿ãã http://anond.hatelabo.jp/20120318122617 Rails3 㨠jQuery ã§ãçé¢ç®ã«ãªã·ã£ã¬ãªã¨ããµã¤ããã¤ãã£ã¦ã¿ã¾ãã - h300 http://d.hatena.ne.jp/inouet
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}