{"id":1462,"date":"2013-06-29T11:12:02","date_gmt":"2013-06-29T02:12:02","guid":{"rendered":"http:\/\/je1sgh.dyndns.info\/?page_id=1462"},"modified":"2013-06-29T11:12:02","modified_gmt":"2013-06-29T02:12:02","slug":"qso-database-powered-by-mysql-perl","status":"publish","type":"page","link":"https:\/\/je1sgh.mydns.jp\/?page_id=1462","title":{"rendered":"QSO Database Powered by MySQL + Perl"},"content":{"rendered":"<h2><strong>\u516c\u958b\u3057\u3066\u3044\u308b\u30b9\u30af\u30ea\u30d7\u30c8\uff08\u30bd\u30fc\u30b9\uff09<\/strong><\/h2>\n<ul>\n<li>MySQL\/qsoman<\/li>\n<\/ul>\n<h2><strong>\u95a2\u9023\u30da\u30fc\u30b8<\/strong><\/h2>\n<ul>\n<li>QSODatabase\/QSLMan\u3000QSL\u30de\u30cd\u30fc\u30b8\u30e1\u30f3\u30c8<\/li>\n<li>QSODatabase\/QSLMan\/Print\u3000\u5370\u5237<\/li>\n<\/ul>\n<ul>\n<li>Activity\u3000\u5b66\u5712\u30cf\u30e0\u30af\u30e9\u30d6\u306e\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u30fc\u30b3\u30f3\u30c6\u30b9\u30c8\u306e\u305f\u3081\u306e\u30ed\u30b0\u96c6\u8a08<\/li>\n<\/ul>\n<p><strong>\u3053\u306e\u30da\u30fc\u30b8\u306f\u30d1\u30b9\u3057\u3066\u5927\u4e08\u592b\u3067\u3059\u2192\u300cMySQL\u306b\u3088\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u7bc9\u300d\u3078<\/strong><\/p>\n<div>\n<ul>\n<li>\u6982\u5ff5<\/li>\n<li>Database\u69cb\u7bc9\u306b\u7740\u624b<\/li>\n<li>\u554f\u984c\u70b9<\/li>\n<li>\u95a2\u9023\u30da\u30fc\u30b8<\/li>\n<\/ul>\n<\/div>\n<h2 id=\"content_1_0\">\u6982\u5ff5 \u2020<\/h2>\n<p>\u958b\u5c40\u3057\u305f\u306e\u306f1972\u5e74\u3067\uff0c1975\u5e74\u4ee5\u964d\u306eQSO\uff08\u4ea4\u4fe1\uff09\u306e\u30c7\u30fc\u30bf\u306f\uff0c\u4f55\u3089\u304b\u306e\u5f62\u3067\u96fb\u5b50\u5316\u3055\u308c\u3066\u3044\u307e\u3059\uff08\u5f8c\u306b\u958b\u5c40\u4ee5\u6765\u306e\u30c7\u30fc\u30bf\u3092\u5168\u90e8\u96fb\u5b50\u5316\uff09\uff0e\u3053\u308c\u3092\u5168\u3066MySQL\u306b\u653e\u308a\u8fbc\u3093\u3067\u3057\u307e\u304a\u3046\u3068\u3044\u3046\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3059\uff0e2002\u5e74\u306e\u8da3\u5473\u306e\u76ee\u6a19\u3068\u3057\u307e\u3057\u305f\uff0e<\/p>\n<p>\u2192 \u7d4c\u7def\u30fb\u7406\u5ff5\u306a\u3069(\u3069\u3046\u3067\u3082\u3044\u3044\u8a71^^;)<\/p>\n<div>\u2191<\/div>\n<h2 id=\"content_1_1\">Database\u69cb\u7bc9\u306b\u7740\u624b \u2020<\/h2>\n<p>\u3044\u308d\u3044\u308d\u7d4c\u7def\u304c\u3042\u308a\u307e\u3057\u305f\u304c\uff0c\u81ea\u4f5c\u306eQSL\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u30bd\u30d5\u30c8\u958b\u767a\u306f\uff0c1990\u5e74\u9803\u3067\u4e00\u6642\u3068\u3093\u632b\u3057\u307e\u3057\u305f\uff0e<\/p>\n<p>\u3053\u306e\u3042\u3068\uff0c1998\u5e74\u304b\u3089\u306f\uff0c\u5b66\u5712\u90fd\u5e02\u30cf\u30e0\u30af\u30e9\u30d6\u306e\u30e1\u30f3\u30d0\u30fc\u306e\u304a\u3072\u3068\u308aJH3GBD\u5800\u91ce\u3055\u3093\u304c\u958b\u767a\u3055\u308c\u3066\u3044\u308bLog200\u3092\u30e1\u30a4\u30f3\u3068\u3057\u3066\uff0c\u30b3\u30f3\u30c6\u30b9\u30c8\u3067\u306f\u3068\u304d\u3069\u304dZLog\u3082\u4f7f\u3063\u3066\u3044\u307e\u3059\uff0e\u4ea4\u4fe1\u30c7\u30fc\u30bf\u306f\u5168\u3066Micro$oft Excel\u306b\u53d6\u308a\u8fbc\u3093\u3067\uff0cAccess\u3067QSL\u30ab\u30fc\u30c9\u3092\u5370\u5237\u3057\u3066\u3044\u307e\u3057\u305f\uff0e<\/p>\n<dl>\n<dt>2008-9-22\u6ce8<\/dt>\n<dd>2008\u5e749\u6708\u304b\u3089\u306f\uff0cExcel\uff0cAccess\u306e\u4f7f\u7528\u306f\u5168\u5ec3\u3057\uff0cOpenOffice(NeoOffice)\u3067\u51e6\u7406\u3057\u3066\u3044\u307e\u3059\uff0e<\/dd>\n<\/dl>\n<dl>\n<dt>2008-11-18\u6ce8<\/dt>\n<dd>2008\u5e7411\u6708\u306e\u6bb5\u968e\u3067\uff0cAccess, OpenOffice Base\u3068\u3044\u3063\u305f\uff0c\u3044\u308f\u3086\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u306e\u4f7f\u7528\u306f\u5168\u5ec3\u3057\uff0cPerl\u30b9\u30af\u30ea\u30d7\u30c8\u3068UNIX\u306e\u6a19\u6e96\u7684\u306a\u30c4\u30fc\u30eb\u3067\u5b8c\u7d50\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\uff0e<\/dd>\n<\/dl>\n<div>\u2191<\/div>\n<h2 id=\"content_1_2\">\u554f\u984c\u70b9 \u2020<\/h2>\n<p>\u73fe\u72b6\u3067\u306e\u6700\u5927\u306e\u554f\u984c\u70b9\u306f\uff0cLog200\u4ee5 \u524d\u306e\u30c7\u30fc\u30bf\u304c\uff0c\u8d85\u30d5\u30ec\u30ad\u30b7\u30d6\u30eb\u53ef\u5909\u9577\u30ec\u30b3\u30fc\u30c9\u5f62\u5f0f\uff08SGH\u5f62\u5f0f\uff09\u3092\u53d6\u3063\u3066\u3044\u308b\u3053\u3068\u3067\u3059\uff0eFM-7\u6642\u4ee3\uff0c\u306a\u306b\u3057\u308d300kB\u306e\u30d5\u30ed\u30c3\u30d4\u30fc\u30c9\u30e9\u30a4\u30d6\u3057\u304b\u306a\u304b\u3063 \u305f\u306e\u3067\uff0c\u3068\u306b\u304b\u304f\u30c7\u30fc\u30bf\u9577\u3092\u77ed\u304f\u3059\u308b\u4e8b\u306b\u91cd\u70b9\u3092\u7f6e\u3044\u305f\u305f\u3081\u3067\u3059\uff0e\u307e\u305f\uff0c\u901a\u5e38\u306e\u4ea4\u4fe1\u3068\u30b3\u30f3\u30c6\u30b9\u30c8\u3067\u306f\uff0c\u30c7\u30fc\u30bf\u5f62\u5f0f\u304c\u5168\u304f\u7570\u306a\u308a\u307e\u3059^^;<\/p>\n<p>\u3053\u306e\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f(parse)\u306f\uff0c\u306a\u304b\u306a\u304b\u5927\u5909\u3067\u3059\u304c\uff0c\u3053\u308c\u3092\u304b\u3064\u3066\u306f\uff0cF-Basic\u3084C\u3067\u3084\u3063\u3066\u3044\u305f\u308f\u3051\u3067\uff0c\u82e5\u3044\u9803\u306f\u81ea\u5206\u3067\u3082\u30d1\u30ef\u30fc\u304c\u3042\u3063\u305f\u306e\u3060\u306a\u3042\u3068\u611f\u5fc3\u3057\u3066\u3044\u307e\u3059\uff0e<\/p>\n<p><em>\uff3b\u3053\u3053\u307e\u30672002\/1\/6\uff3d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u516c\u958b\u3057\u3066\u3044\u308b\u30b9\u30af\u30ea\u30d7\u30c8\uff08\u30bd\u30fc\u30b9\uff09 MySQL\/qsoman \u95a2\u9023\u30da\u30fc\u30b8 QSODatabase\/QSLMan\u3000QSL\u30de\u30cd\u30fc\u30b8\u30e1\u30f3\u30c8 QSODatabase\/QSLMan\/Print\u3000\u5370\u5237 Activity\u3000\u5b66\u5712\u30cf\u30e0\u30af\u30e9\u30d6\u306e\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u30fc\u30b3\u30f3\u30c6\u30b9\u30c8\u306e\u305f\u3081\u306e\u30ed\u30b0\u96c6\u8a08 \u3053\u306e\u30da\u30fc\u30b8\u306f\u30d1\u30b9\u3057\u3066\u5927\u4e08\u592b\u3067\u3059\u2192\u300cMySQL\u306b\u3088\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u7bc9\u300d\u3078 \u6982\u5ff5 Database\u69cb\u7bc9\u306b\u7740\u624b \u554f\u984c\u70b9 \u95a2\u9023\u30da\u30fc\u30b8 \u6982\u5ff5 \u2020 \u958b\u5c40\u3057\u305f\u306e\u306f1972\u5e74\u3067\uff0c1975\u5e74\u4ee5\u964d\u306eQSO\uff08\u4ea4\u4fe1\uff09\u306e\u30c7\u30fc\u30bf\u306f\uff0c\u4f55\u3089\u304b\u306e\u5f62\u3067\u96fb\u5b50\u5316\u3055\u308c\u3066\u3044\u307e\u3059\uff08\u5f8c\u306b\u958b\u5c40\u4ee5\u6765\u306e\u30c7\u30fc\u30bf\u3092\u5168\u90e8\u96fb\u5b50\u5316\uff09\uff0e\u3053\u308c\u3092\u5168\u3066MySQL\u306b\u653e\u308a\u8fbc\u3093\u3067\u3057\u307e\u304a\u3046\u3068\u3044\u3046\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3059\uff0e2002\u5e74\u306e\u8da3\u5473\u306e\u76ee\u6a19\u3068\u3057\u307e\u3057\u305f\uff0e \u2192 \u7d4c\u7def\u30fb\u7406\u5ff5\u306a\u3069(\u3069\u3046\u3067\u3082\u3044\u3044\u8a71^^;) \u2191 Database\u69cb\u7bc9\u306b\u7740\u624b \u2020 \u3044\u308d\u3044\u308d\u7d4c\u7def\u304c\u3042\u308a\u307e\u3057\u305f\u304c\uff0c\u81ea\u4f5c\u306eQSL\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u30bd\u30d5\u30c8\u958b\u767a\u306f\uff0c1990\u5e74\u9803\u3067\u4e00\u6642\u3068\u3093\u632b\u3057\u307e\u3057\u305f\uff0e \u3053\u306e\u3042\u3068\uff0c1998\u5e74\u304b\u3089\u306f\uff0c\u5b66\u5712\u90fd\u5e02\u30cf\u30e0\u30af\u30e9\u30d6\u306e\u30e1\u30f3\u30d0\u30fc\u306e\u304a\u3072\u3068\u308aJH3GBD\u5800\u91ce\u3055\u3093\u304c\u958b\u767a\u3055\u308c\u3066\u3044\u308bLog200\u3092\u30e1\u30a4\u30f3\u3068\u3057\u3066\uff0c\u30b3\u30f3\u30c6\u30b9\u30c8\u3067\u306f\u3068\u304d\u3069\u304dZLog\u3082\u4f7f\u3063\u3066\u3044\u307e\u3059\uff0e\u4ea4\u4fe1\u30c7\u30fc\u30bf\u306f\u5168\u3066Micro$oft Excel\u306b\u53d6\u308a\u8fbc\u3093\u3067\uff0cAccess\u3067QSL\u30ab\u30fc\u30c9\u3092\u5370\u5237\u3057\u3066\u3044\u307e\u3057\u305f\uff0e 2008-9-22\u6ce8 2008\u5e749\u6708\u304b\u3089\u306f\uff0cExcel\uff0cAccess\u306e\u4f7f\u7528\u306f\u5168\u5ec3\u3057\uff0cOpenOffice(NeoOffice)\u3067\u51e6\u7406\u3057\u3066\u3044\u307e\u3059\uff0e 2008-11-18\u6ce8 2008\u5e7411\u6708\u306e\u6bb5\u968e\u3067\uff0cAccess, OpenOffice Base\u3068\u3044\u3063\u305f\uff0c\u3044\u308f\u3086\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u306e\u4f7f\u7528\u306f\u5168\u5ec3\u3057\uff0cPerl\u30b9\u30af\u30ea\u30d7\u30c8\u3068UNIX\u306e\u6a19\u6e96\u7684\u306a\u30c4\u30fc\u30eb\u3067\u5b8c\u7d50\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\uff0e \u2191 \u554f\u984c\u70b9 \u2020 \u73fe\u72b6\u3067\u306e\u6700\u5927\u306e\u554f\u984c\u70b9\u306f\uff0cLog200\u4ee5 \u524d\u306e\u30c7\u30fc\u30bf\u304c\uff0c\u8d85\u30d5\u30ec\u30ad\u30b7\u30d6\u30eb\u53ef\u5909\u9577\u30ec\u30b3\u30fc\u30c9\u5f62\u5f0f\uff08SGH\u5f62\u5f0f\uff09\u3092\u53d6\u3063\u3066\u3044\u308b\u3053\u3068\u3067\u3059\uff0eFM-7\u6642\u4ee3\uff0c\u306a\u306b\u3057\u308d300kB\u306e\u30d5\u30ed\u30c3\u30d4\u30fc\u30c9\u30e9\u30a4\u30d6\u3057\u304b\u306a\u304b\u3063 \u305f\u306e\u3067\uff0c\u3068\u306b\u304b\u304f\u30c7\u30fc\u30bf\u9577\u3092\u77ed\u304f\u3059\u308b\u4e8b\u306b\u91cd\u70b9\u3092\u7f6e\u3044\u305f\u305f\u3081\u3067\u3059\uff0e\u307e\u305f\uff0c\u901a\u5e38\u306e\u4ea4\u4fe1\u3068\u30b3\u30f3\u30c6\u30b9\u30c8\u3067\u306f\uff0c\u30c7\u30fc\u30bf\u5f62\u5f0f\u304c\u5168\u304f\u7570\u306a\u308a\u307e\u3059^^; \u3053\u306e\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f(parse)\u306f\uff0c\u306a\u304b\u306a\u304b\u5927\u5909\u3067\u3059\u304c\uff0c\u3053\u308c\u3092\u304b\u3064\u3066\u306f\uff0cF-Basic\u3084C\u3067\u3084\u3063\u3066\u3044\u305f\u308f\u3051\u3067\uff0c\u82e5\u3044\u9803\u306f\u81ea\u5206\u3067\u3082\u30d1\u30ef\u30fc\u304c\u3042\u3063\u305f\u306e\u3060\u306a\u3042\u3068\u611f\u5fc3\u3057\u3066\u3044\u307e\u3059\uff0e \uff3b\u3053\u3053\u307e\u30672002\/1\/6\uff3d<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1110,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-1462","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1462"}],"version-history":[{"count":0,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1462\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1110"}],"wp:attachment":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}