[B! json] somemoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

somemo id:somemo

jsonã«é–¢ã™ã‚‹somemoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

pg_nosql_benchmark - æ—¥ã€…ã®è¨˜éŒ² åˆ¥é¤¨
æ˜¨å¹´ã€PostgreSQL 9.4-betaãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é ƒã‹ã‚‰ã€ãªã‚“ã¨ãªãJSONBåž‹ã‚’è¿½ã£ã¦ããŸã‚ã‘ã§ã™ãŒã€æœ€è¿‘ã¯ãƒ©ã‚¤ãƒãƒ«(?)ã§ã‚ã‚‹Mongo DBã¨ã®æ¯”è¼ƒãªã‚“ã‹ã‚‚ã‚„ã£ã¦ã¾ã—ã¦ã€ä»Šæ—¥ã¯ã¡ã‚‡ã£ã¨ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§æ€§èƒ½ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã—ãŸã‚ˆã£ã¨ã€‚ pg_nosql_benchmark ã“ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã€æ˜¨å¹´ã«EnterpriseDBç¤¾ãŒGithubä¸Šã§å…¬é–‹ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ã™ã€‚ GitHub - EnterpriseDB/pg_nosql_benchmark: A tool which can be used to benchmark PostgreSQL (JSONB) and Mongo DB (BSON) ã§ã€ã“ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã‚’å…¬é–‹ã—ã¦ã‚‹ã‚ã‘ã§ã™ãŒã€ãƒ›ãƒ³ãƒˆã«ãã‚“ãªã«å·®ãŒã‚ã‚‹ã®ã‹ã¨ã€è‹¥å¹²ç–‘å•ã¯æŒã£ã¦ã„ãŸã‚ã‘ã§ã™ã€‚ ãªã®ã§ã€ä»¶æ•°çš„ã«ã¯å°ã‚¹ã‚±ãƒ¼ãƒ«ã§ã¯ã‚ã‚‹ã‘ã©ã€æ‰‹å…ƒã«ã‚ã‚‹VMç’°å¢ƒã§ã‚‚ã€ã“ã®ãƒ™ãƒ³
somemo 2015/01/25
mongodb

postgresql

JSON
ãƒªãƒ³ã‚¯
PHPã®JSONã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—
(Last Updated On: 2023å¹´12æœˆ8æ—¥) è¿½è¨˜ï¼šæœ€è¿‘ã®OWASPã‚¬ã‚¤ãƒ‰ã®æ›´æ–°ã§JavaScriptæ–‡å—åˆ—ã¯Unicodeã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã§å®‰å…¨æ€§ã‚’ç¢ºä¿ã™ã‚‹ã‚ˆã†å¤‰æ›´ã•ã‚Œã¾ã—ãŸã€‚å…ƒã€…ã“ã®ãƒ–ãƒã‚°ã§ã‚‚Unicodeã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã®ã¾ã¾åˆ©ç”¨ã™ã‚‹ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ä»–ã®è¨€èªžã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯Unicodeã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚’åˆ©ç”¨ã—ã¾ã—ã‚‡ã†ã€‚PHPã‚‚ASCIIé ˜åŸŸã®æ–‡å—ã‚’Unicodeã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ã‚ˆã†ã«ã—ãŸæ–¹ãŒè‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ã“ã‚Œã¯ææ¡ˆã—ã¦å®Ÿç¾ã™ã‚‹ã‚ˆã†ã«åŠªåŠ›ã—ã¾ã™ã€‚ JSONã¯JavaScriptã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚„é…åˆ—ã‚’è¡¨ç¾ã™ã‚‹æ–¹å¼ã§RFC 4627ã§å®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ¡ãƒ‡ã‚£ã‚¢ã‚¿ã‚¤ãƒ—ã¯application/jsonã€ãƒ•ã‚¡ã‚¤ãƒ«æ‹¡å¼µåã¯jsonã¨å®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ PHPã«JSONå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ã«å¤‰æ›ã™ã‚‹json_encodeé–¢æ•°ã¨json_decodeé–¢æ•°ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ JSONé–¢æ•°ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹
somemo 2014/04/30
PHP

json
ãƒªãƒ³ã‚¯
[PHP] PHPã®json_encodeã§ã€ç©ºã®é…åˆ—ã¨ç©ºã®é€£æƒ³é…åˆ—ã‚’åŒºåˆ¥ã™ã‚‹ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ - ï¼Šã€Œãµã£ã‹ã¤ã®ã˜ã‚…ã‚‚ã‚“ãŒã¡ãŒã„ã¾ã™ã€‚ã€withã¬ã“
<?php $json = array( 'dict' => (object)array(), 'list' => array(), ); //{"dict":{},"list":[]} echo json_encode($json); ããã£ã¦ã‚‚è¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸãŒ monmonã•ã‚“ã®è§£æ³•ã‚’ id:tomi-ru ã•ã‚“ãŒæ”¹å–„ã—ãŸã€‚
somemo 2014/03/28
php

json
ãƒªãƒ³ã‚¯
JSON Schemaã¨PHP
ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™ºè¡¨ã—ã¦ãã¾ã—ãŸã€‚Engine Yardã•ã¾ã€ã„ã¤ã‚‚ä¼šå ´æä¾›ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ( ç¬¬72å›ž PHPå‹‰å¼·ä¼š@æ±äº¬ : ATND ) JSON Schemaã¨ã„ã†ã‚‚ã®ãŒã‚ã£ã¦ã€ã™ã’ãƒ¼å¿œç”¨ç¯„å›²ãŒåºƒãã¦ã€ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ãªã‚‰å¤§ä½“ã“ã‚Œã ã‘ã§å‡ºæ¥ã¾ã™ã‚ˆãƒ¼ã¨ã„ã†å†…å®¹ã§ã—ãŸã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ã¡ã‚‡ã£ã¨ãƒã‚¿ã«èµ°ã£ã¦ã¾ã™ãŒã€æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ã¯å‰²ã¨æœ¬æ°—ã§ã™ã€‚ã€ŒJSON Schemaã¯JSONã®ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ãŸã‚ã®ã‚‚ã®ã€ã¨ä¸€èˆ¬ã«ã¯å®šç¾©ã•ã‚Œã¦ã„ã¾ã™ãŒã€JSONäº’æ›ã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’æŒã£ã¦ã„ã‚‹å‹•çš„åž‹ä»˜ãè¨€èªžã«ãŠã„ã¦ã¯ã€JSON Schemaã§è¨€èªžãƒã‚¤ãƒ†ã‚£ãƒ–ã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ãŒå…¨ã¦ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã§ãã¦ã—ã¾ã†ã®ã§ã™ã€‚ JSON Schemaã¯ã„ã¾ã²ã¨ã¤æµè¡Œã£ã¦ãªã„æ°—ã‚‚ã—ã¾ã™ãŒã€æ§‹é€ ãã®ã‚‚ã®ã®ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã«ä¸»çœ¼ã‚’ç½®ã„ã¦ã„ãŸã‚Šã€è¨€èªžã‚’è¶…ãˆã¦ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ãƒ«ãƒ¼ãƒ«ã‚’å…±æœ‰ã§ããŸã‚Šã€çµæ§‹ãŠã‚‚ã—ã‚ã„ã“ã¨ãŒã§ãã‚‹ã®ã§ã€ä½¿ã£ã¦ã¿
somemo 2013/10/29
json

php
ãƒªãƒ³ã‚¯
jqã‚³ãƒžãƒ³ãƒ‰ãŒå®Ÿã¯é«˜æ€§èƒ½ã™ãŽã¦ãƒ“ãƒ“ãƒƒãŸè©±
GWãŒå§‹ã¾ã‚Šã¾ã—ãŸãŒã€éŽŒå€‰ã®GWã¯è¦³å…‰å®¢å¤šã™ãŽã¦é€†ã«ä½æ°‘ã¯ã’ã‚“ãªã‚Šã—ã¦å¤–ã«å‡ºãªããªã‚‹æ„Ÿã˜ã§ã™ã€‚ã¨ã¯ã„ãˆè·¯åœ°ã¾ã§è¦³å…‰å®¢ãŒæ”»ã‚è¾¼ã‚“ã§ãã‚‹ã“ã¨ã¯å°‘ãªã„ã®ã§ã€è·¯åœ°ã‚’æ•£æ©ã™ã‚‹åˆ†ã«ã¯å¤©æ°—ãŒã‚ˆãã¦ã„ã„æ„Ÿã˜ã§ã™ãã€‚ã¡ãªã¿ã«äººåŠ›è»Šã®ãŠã«ãƒ¼ã•ã‚“ã¯ãã†ã„ã†å‘³ã®ã‚ã‚‹è·¯åœ°ã‚’çŸ¥ã‚Šå°½ãã—ã¦ã„ã‚‹ã®ã§äººåŠ›è»Šã§ç§»å‹•ã™ã‚‹ã®ã¯ãã“ãã“ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™(ã¼ãã¯ä¹—ã£ãŸã“ã¨ãªã„ã‘ã©ã€Œã“ã‚“ãªã¨ã“ã‚ã‚‚é€šã‚‹ã‚“ã !ã€ã£ã¦ã¨ã“ã‚ã§è¦‹ã‹ã‘ãŸã‚Šã—ã¾ã™)ã€‚ ã•ã¦ã€jqã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ jq jq is a lightweight and flexible command-line JSON processor. ã¨æ›¸ã„ã¦ã‚ã‚‹ã¨ãŠã‚Šã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§JSONã‚’æ‰±ã†ã“ã¨ãŒã§ãã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ã§ã€ä»Šã¾ã•ã«ä»•äº‹ã§å·¨å¤§JSONã¨æˆ¦ã†ã“ã¨ãŒå¤šãã€ã“ã®ã‚³ãƒžãƒ³ãƒ‰ãŒå¤§æ´»èºã§ã™ã€‚ ã¨ã¯ã„ãˆã€ã¼ãã®ä½¿ã„æ–¹ã¨ã—ã¦ã¯ã€Œå·¨å¤§JSONã‚’ã‚ãƒ¬ã‚¤ã«æ•´å½¢ã—ã¦è¡¨ç¤ºã™ã‚‹ã€ã¨ã„
somemo 2013/06/16
json
ãƒªãƒ³ã‚¯
Amon2ã¨JSONã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ - tokuhirom's blog
[1]http://d.hatena.ne.jp/ockeghem/20110907/p1[2]http://www.atmarkit.co.jp/fcoding/articles/webapp/05/webapp05a.html[3] http://msdn.microsoft.com/ja-jp/asp.net/ff713315[4] http://labs.cybozu.co.jp/blog/kazuho/archives/2007/01/cross-site_including.phpã‚ãŸã‚Šã‚’ã‚ˆã‚“ã§ã€JSON ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ã¤ã„ã¦ã‹ã‚“ãŒãˆã¦ã¿ãŸã€‚ ã“ã“ã§ã€æœ‰åŠ¹ã¨ã•ã‚Œã¦ã„ã‚‹å¯¾ç–ã®ã†ã¡ while(1); ã‚’å…ˆé ã«ä»˜ä¸Žã™ã‚‹POST ã§ã™ã¹ã¦å‡¦ç†ã™ã‚‹ã¨ã„ã£ãŸã‚ãŸã‚Šã¯ã€RESTful ã§ãªã„ã—ã€BK æ„ŸãŒã²ã©ã„ã¨ã„ã†ã‹æœ¬è³ªçš„ã§ã¯ãªã„ã®ã§ã§ãã‚‹ã ã‘ã‚„ã‚ŠãŸããªã„ã€‚ ã¾ãŸã€Amon2 ã§ã¯äº’æ›
somemo 2013/02/14
json

javascript

security
ãƒªãƒ³ã‚¯
PHPã®ã‚¤ã‚¿ã„å…¥é–€æ›¸ã‚’èªã‚“ã§Ajaxã®XSSã«ã¤ã„ã¦æ¤œè¨Žã—ãŸ(3)ï½žJSONç‰ã®æƒ³å®šå¤–èªã¿å‡ºã—ã«ã‚ˆã‚‹æ”»æ’ƒï½ž - ockeghem(å¾³ä¸¸æµ©)ã®æ—¥è¨˜
æ˜¨æ—¥ã®æ—¥è¨˜ã®ç¶šãã§ã€Ajaxã«å›ºæœ‰ãªã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å•é¡Œã«ã¤ã„ã¦æ¤œè¨Žã—ã¾ã™ã€‚ä»Šå›žã¯JSONç‰ã®æƒ³å®šå¤–èªã¿å‡ºã—ã«ã‚ˆã‚‹æ”»æ’ƒã§ã™ã€‚ã“ã‚Œã‚‰æ”»æ’ƒæ‰‹æ³•ã¯æœ¬æ¥ãƒ–ãƒ©ã‚¦ã‚¶å´ã§å¯¾å¿œã™ã¹ãã‚‚ã®ã§ã€ã‚„ã‚€ã‚’å¾—ãšWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§å¯¾å¿œã™ã‚‹ä¸Šã§ã€ã¾ã å®šç•ªã¨ãªã‚‹å¯¾ç–ãŒãªã„ã‚ˆã†ã«æ€ãˆã¾ã™ã€‚ã“ã®ãŸã‚ã€è¤‡æ•°ã®å€™è£œã‚’ç¤ºã™ã‚‹ã“ã¨ã§è°è«–ã®ãã£ã‹ã‘ã«ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã€ä½œã‚ŠãªãŒã‚‰åŸºç¤Žã‹ã‚‰å¦ã¶PHPã«ã‚ˆã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¥é–€XAMPP/jQuery/HTML5ã§ä½œã‚‹ã‚¤ãƒžãƒ‰ã‚ã®Weã‹ã‚‰ã€Ajaxã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¦‚å¿µå›³ã‚’å¼•ç”¨ã—ã¾ã™ï¼ˆåŒæ›¸P20ã®å›³1-23ï¼‰ã€‚ å‰å›žã€å‰ã€…å›žã¯ã€(5)ã®HTTPãƒ¬ã‚¹ãƒãƒ³ã‚¹ã®å‰å¾Œã§ã€JSONç‰ã®ãƒ‡ãƒ¼ã‚¿ä½œæˆï¼ˆã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ï¼‰ã«èµ·å› ã™ã‚‹evalã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ã€(5)ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’å—ã‘å–ã£ãŸå¾Œã®HTMLãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°ã®éš›ã®XSSã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ãŸã€‚ ã—ã‹ã—ã€å•é¡Œã¯ã“ã‚Œã ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚æ£å¸¸
somemo 2013/02/14
ajax

json

security

javascript
ãƒªãƒ³ã‚¯
Googleã®JSON(ãƒ¢ãƒ‰ã‚)ã®å…ˆé ã«while(1); ãŒã¤ãç†ç”± - è‘‰ã£ã±æ—¥è¨˜
ãªãœGoogleã¯JSONã®å…ˆé ã« while(1); ã‚’ã¤ã‘ã‚‹ã®ã‹ #JavaScript #HTML #Ajax #StackOverflow - Qiita ã“ã‚Œã¯ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ãƒªã‚¯ã‚¨ã‚¹ãƒˆãƒ»ãƒ•ã‚©ãƒ¼ã‚¸ã‚§ãƒªå¯¾ç–ã€‚é•ã†ã‚ˆï¼å…¨ç„¶é•ã†ã‚ˆï¼ æ”»æ’ƒè€…ã®ä½œæˆã—ãŸç½ ãƒšãƒ¼ã‚¸ã«ã¦JSONã‚’<script src="target.json">ã¿ãŸã„ã«èªã¿è¾¼ã‚“ã§ã€ã‚´ãƒ‹ãƒ§ã‚´ãƒ‹ãƒ§ã‚„ã‚‹ã“ã¨ã§JSONå†…ã®æ©Ÿå¯†æƒ…å ±ã«æ”»æ’ƒè€…ãŒã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ã¨ã„ã†ã®ã¯åˆã£ã¦ã‚‹ã‘ã©ã€ãã‚Œã‚’ã€Œã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ãƒªã‚¯ã‚¨ã‚¹ãƒˆãƒ»ãƒ•ã‚©ãƒ¼ã‚¸ã‚§ãƒªã€ã¨ã¯è¨€ã‚ãªã„ã€‚ç„¡ç†ã«ä½•ã‹åå‰ã‚’ã¤ã‘ã¦å‘¼ã¶ã¨ã™ã‚Œã°ã€ã€ŒJSON Hijackingã€ã¨ã„ã†ä¿—ç§°ã‚„ã€ã‚ã‚‹ã„ã¯å˜ç´”ã«ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆã§ã®æƒ…å ±æ¼ãˆã„ã€ç¨‹åº¦ã§ã™ã‹ãã€‚ ã¡ãªã¿ã«ã€Arrayã‚³ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ã‚„Objectã§ã®ã‚¢ã‚¯ã‚»ã‚µã‚’å®šç¾©ã—ã¦JSONã‚’JSã¨ã—ã¦èªã¿è¾¼ã‚“ã§å†…éƒ¨ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ‰‹æ³•ã¯ã€ç¾åœ¨ã®ã¨ã“ã‚å…¬ã«ã•ã‚Œã¦ã„ã‚‹ã¨ã“ã‚ã§ã¯å¤
somemo 2013/02/14
json

security

javascript

ajax
ãƒªãƒ³ã‚¯
1