Web application development References
ISO-639-1
Official languages of the United Nations
- Arabic
- Chinese (Mandarin)
- English
- French
- Russian
- Spanish
CLDR
Unicode Common Locale Data Repository터미널 한글 설정
windows cmd - chcp 65001
linux shell - export LC_ALL=ko_KR.UTF-8구글 맵스 지도 검색
https://maps.google.com/?q=이름@위도,경도구글 정의 검색
define:somethingProtocol SPDY
http://www.chromium.org/spdyMongoDB
사용자추가 스키마생성 DB삭제
mongod 를 기동할 때는 --auth 옵션을 추가해야 함
mongoDB는 system영역 내에서 admin이라는 DB관리를 위한 스키마를 가짐
>use admin // admin DB 사용
>db.addUser('name','pswd') // 사용자 추가
>use newDB => 해당 디비가 없으면, 새로운 디비를 생성함
mysql의 스키마 생성과 같음
>db.collectionName.drop() => 해당 collection을 삭제함
mysql의 DROP TABLE과 같음Mongodb eclipse
log path configuration
"C:\data\mongodb-xxxxxxxxx\bin\mongod" --service --logpath c:\data\test.logimport
mongoimport --host localhost --db myapp_development --collection my_collection --type csv --file C:\dev\data\test.csv --headerline --upsertregex
mongodb regex = '^[work|accus*|planet]'
MongoDB can only use indexes on Regular Expression searches that are front (^) anchored.
RegEx searches that front-anchor and then use a wildcard query like .* will use the index for as much of the un-wildcarded area as it can before scanning --- i.e., ^foo.* will run a partial scan.Mysql
mysql backup and restore
mysqldump -uUSER -pPASSWORD -hHOST DB > ./filename.sql
mysql -uUSER -pPASSWORD -hHOST DB < ./filename.sql
MySQL index
What should be indexed?
–All attributes where you JOIN
–All attributes where you filter (WHERE)
–All attributes where you ORDER or GROUP BY
–All attributes where you want to do an Index Scaninstead of a Table scan.
–NOT on attributes with an evenly distributed lowcardinality.
•How should be indexed?
–Indexes can only be used from left to right.
–Keep them short.
–Compound indexes: INDEX(a, b).
–Prefixed indexes: INDEX(a, b(10)).
–Do not function-cover indexed attributeshttp://www.scribd.com/doc/80792061/MySQL-Performance-Tuning
MySQL Date and Time Functions
Mysql 동일 테이블에서 여러 필드 값의 합 쿼리
//쿼리1 보다 쿼리2가 두 배 이상 빠르다. 단, 하나의 칼럼 갯수를 구할 땐 where절과 count(*)를 쓰는 것이 더 빠르다.
//쿼리1
select sum(cnt) from (
select count(*) as cnt from `my_table` WHERE `field_x` =1
union all
select count(*) as cnt from `my_table` WHERE `field_y` =1
union all
select count(*) as cnt from `my_table` WHERE `field_z` =1
) as cnt_all
//쿼리2
SELECT
(SUM(IF(`field_x` = 1,1,0)) +
SUM(IF(`field_y` = 1,1,0)) +
SUM(IF(`field_z` = 1,1,0))) as cnt_all
FROM `my_table`
WHERE 1firefox - keyword.url
http://www.google.co.kr/search?num=50&hl=ko&lr=&newwindow=1&tbo=1&as_qdr=all&aq=f&aqi=&aql=&oq=&gs_rfai=&ie=UTF-8&oe=UTF-8&sourceid=navclient&gfns=1&q=리눅스 crontab
crontab -lCSS FONT BASE-64
/* Fonts as files */
@font-face {
font-family: 'MyFontFamily';
src: url('myfont-webfont.eot?') format('eot'),
url('myfont-webfont.woff') format('woff'),
url('myfont-webfont.ttf') format('truetype'),
url('myfont-webfont.svg#svgFontName') format('svg');
}
/* Fonts as data uris */
@font-face {
font-family: 'MyFontFamily';
src: url('myfont-webfont.eot?') format('embedded-opentype');
}
@font-face {
font-family: 'MyFontFamily';
url(data:font/truetype;charset=utf-8;base64,BASE64_ENCODED_DATA_HERE) format('truetype'),
url(data:font/woff;charset=utf-8;base64,BASE64_ENCODED_DATA_HERE) format('woff'),
url('myfont-webfont.svg#svgFontName') format('svg');
}CSS Sticky windows
.outer {
width:200px;
height:600px;
background-color:red;
margin:0 auto;
}
.inner {
width:50px;
border:1px solid white;
position:fixed;
}
Insert the word (image) into the alt text of an image that hasn’t loaded In Firefox
img:after { content:" (image)"; }
img::after { content:" (image)"; } /* New CSS3 standard notation */FYI
References and Articles
빠른 웹 개발
도구
출처
- 직접 작성
- google 검색
by 月風
