2015. 11. 27. 17:26ㆍ서버 프로그래밍
Chatting.ziphttps://nodejs.org/en/
https://www.mongodb.org/
http://www.eclipse.org/
http://www.oracle.com/index.html
http://developers.daum.net/
https://apis.daum.net/shopping/search?apikey={apikey}&q=신학기 가방&result=20&pageno=3&output=json&sort=min_price
http://developer.naver.com/
http://openapi.naver.com/search?key={apikey}&query=벤허&display=10&start=1&target=movie
https://dev.twitter.com/
Consumer Key (API Key)
Consumer Secret (API Secret)
Access Token
Access Token Secret
-------------------------------------------------------------------
http://www.mysql.com/
MySQL community server 다운로드 및 설치
MySQL 5.7 Command Line Client-Unicode 접속
암호 입력
-------------------------------------------------------------------
create database test;
use test;
mysql> create table wordcounts(
-> id INT AUTO_INCREMENT PRIMARY KEY,
-> word VARCHAR(100) NOT NULL,
-> count INT DEFAULT 0);
Query OK, 0 rows affected (0.07 sec)
mysql> describe wordcounts;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| word | varchar(100) | NO | | NULL | |
| count | int(11) | YES | | 0 | |
+-------+--------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)
map = function () {
var res=this.text.split(" ");
for(var i in res) {
key = {word:res[i]};
value = {count:1};
emit(key,value);
reduce = function (key,values){
var totalcount = 0;
for (var i in values) {
totalcount = values[i].count+totalcount;
}
return {count:totalcount};
}
-------------------------------------------------------------------
https://github.com/dmajkic/redis/downloads
redis-2.4.5-win32-win64.zip
-------------------------------------------------------------------
mysql> create database moviest;
Query OK, 1 row affected (0.00 sec)
mysql> use moviest;
Database changed
mysql> create table movie(
-> movie_id INT AUTO_INCREMENT PRIMARY KEY,
-> title VARCHAR(100) NOT NULL,
-> director VARCHAR(50),
-> year INT DEFAULT 2000);
Query OK, 0 rows affected (0.06 sec)
mysql> describe movie;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| movie_id | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | NULL | |
| director | varchar(50) | YES | | NULL | |
| year | int(11) | YES | | 2000 | |
+----------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> insert into movie(title,director,year) values("아바타","제임스카메론",2009);
Query OK, 1 row affected (0.02 sec)
mysql> insert into movie(title,director,year) values("스타워즈","조지루카스",1977);
Query OK, 1 row affected (0.00 sec)
mysql> select * from movie;
+----------+--------------+--------------------+------+
| movie_id | title | director | year |
+----------+--------------+--------------------+------+
| 1 | 스타워즈 | 조지루카스 | 1977 |
| 2 | 아바타 | 제임스카메론 | 2009 |
+----------+--------------+--------------------+------+
2 rows in set (0.00 sec)