Skip to content

Instantly share code, notes, and snippets.

View appleboy's full-sized avatar
🔥
On Fire

Bo-Yi Wu appleboy

🔥
On Fire
View GitHub Profile
@tototoshi
tototoshi / rownum.sql
Created December 26, 2012 01:14
Grouped LIMIT in PostgreSQL: show the first N rows for each group
-- http://stackoverflow.com/questions/1124603/grouped-limit-in-postgresql-show-the-first-n-rows-for-each-group
-- http://www.postgresql.jp/document/9.2/html/tutorial-window.html
CREATE TABLE empsalary (
depname varchar(10) not null
, empno integer not null
, salary integer not null
);
INSERT INTO empsalary (depname, empno, salary) VALUES ('develop', 11, 5200);
@cowboy
cowboy / Gruntfile.js
Last active December 10, 2015 15:39
grunt: why you might want to use file src-dest mapping expansions
module.exports = function(grunt) {
// Project configuration.
grunt.initConfig({
minify: {
nofiles: {},
manual: {
files: [
// Why specify all src-dest mappings manually...
{src: 'lib/grunt.js', dest: 'build/grunt.min.js'},
@chilversc
chilversc / gist:5082299
Created March 4, 2013 13:41
Use jquery mobile with requirejs, delay pageinit function until scripts are loaded
<script src="/scripts/require.js" type="text/javascript"></script>
<script type="text/javascript">
requirejs.config({
paths: {
'jquery': 'jquery-1.9.1.min',
'jquery.mobile': 'jquery.mobile-1.3.0.min'
},
shim: {
'jquery.mobile': ['jquery', 'jquery.mobile-config']
}
@davidou123
davidou123 / TaiwanStreetName
Created March 12, 2013 15:21
這是一份台灣街道的資料 內容格式為[排序序號][郵遞區號三碼][縣市][鄉鎮市][路名] 資料來源來自於綠奶茶blog整理(http://milkmidi.blogspot.tw/2012/03/blog-post.html) ------------------------------------------------- 而他的資料來源是從中華郵政api撈出來的 http://www.post.gov.tw/post/internet/f_searchzone/streetNameData.jsp (直接點是無效的, 請用任意程式用 POST傳值) city:臺北市 cityarea:信義區 就會得到該區的街道XML
This file has been truncated, but you can view the full file.
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 建立日期: Mar 12, 2013, 03:16 PM
-- 伺服器版本: 5.0.51
-- PHP 版本: 5.2.6
@miohtama
miohtama / gist:5389146
Created April 15, 2013 15:56
Decoding emails in Python e.g. for GMail and imapclient lib
import email
def get_decoded_email_body(message_body):
""" Decode email body.
Detect character set if the header is not set.
We try to get text/plain, but if there is not one then fallback to text/html.
:param message_body: Raw 7-bit message body input e.g. from imaplib. Double encoded in quoted-printable and latin-1
@algal
algal / nginx-cors.conf
Created April 29, 2013 10:52
nginx configuration for CORS (Cross-Origin Resource Sharing), with an origin whitelist, and HTTP Basic Access authentication allowed
#
# A CORS (Cross-Origin Resouce Sharing) config for nginx
#
# == Purpose
#
# This nginx configuration enables CORS requests in the following way:
# - enables CORS just for origins on a whitelist specified by a regular expression
# - CORS preflight request (OPTIONS) are responded immediately
# - Access-Control-Allow-Credentials=true for GET and POST requests
@maccman
maccman / jquery.onclose.coffee
Last active July 3, 2022 08:17
jQuery plugin to notify users if they close the page, and there are still some Ajax requests pending.
$ = jQuery
TRANSFORM_TYPES = ['PUT', 'POST', 'DELETE']
$.activeTransforms = 0
$(document).ajaxSend (e, xhr, settings) ->
return unless settings.type in TRANSFORM_TYPES
$.activeTransforms += 1
@josephj
josephj / happy-desinger-mini-1.md
Last active December 18, 2015 10:39
於 HappyDesigner Mini #1 分享會

JavaScript 品質工具:CodePaint 與 Plato

介紹協助提昇 F2E Code Style 的兩個工具。

分享者

josephj@faria

問題

@mattetti
mattetti / multipart_upload.go
Last active April 22, 2024 05:24
Example of doing a multipart upload in Go (golang)
package main
import (
"bytes"
"fmt"
"io"
"log"
"mime/multipart"
"net/http"
"os"
@timdream
timdream / gist:5968469
Last active May 25, 2024 16:56
Github 發 Pull Request & 貢獻流程速查

Github 發 Pull Request & 貢獻流程速查

前言

此文目標讀者需先自行學會

  • 開 Github 帳號
  • 會 fork 程式 repository
  • 會在自己的電腦使用命令列 git
  • 會 clone 自己的 repository