为自己快速写博客开发的yami程序初稿基本完成了。需要打成jar通过命令行快速调用。具体可看Readme。 项目地址：https://github.com/lihongzheshuai/yami 搜了一下Gradle 打包executable jar的方法，确实如一个文章里所说，网上都会提到一个plugin，但是他试了却不好用，他好奇到底是谁转载谁的。 其实我也先试用了那个plugi...

用Hue管理Hadoop、HBase等集群环境。 参考官方文档： http://gethue.com/how-to-configure-hue-in-your-hadoop-cluster/ http://gethue.com/start-developing-hue-on-a-mac-in-a-few-minutes/ 我下载的是Hue的离线包并且有Java环境，所以St...

老版本的MacPorts在EI Capitan下有兼容性问题。今天运行报错如下： Error: Current platform “darwin 15” does not match expected platform “darwin 14” Error: If you upgraded your OS, please follow the migration instruction...

There are two sorted arrays nums1 and nums2 of size m and n respectively. Find the median of the two sorted arrays. The overall run time complexity should be O(log (m+n)). package com.coderli.leet...

Given a string, find the length of the longest substring without repeating characters. For example, the longest substring without repeating letters for “abcabcbb” is “abc”, which the length is 3. F...

You are given two linked lists representing two non-negative numbers. The digits are stored in reverse order and each of their nodes contain a single digit. Add the two numbers and return it as a l...

Given an array of integers, find two numbers such that they add up to a specific target number. The function twoSum should return indices of the two numbers such that they add up to the target, whe...

索引类型 - B-tree，Hash, GiST, SP-GiST, GIN。默认是B-tree B-tree - 适合处理等值和范围查询。支持的操作符： <, <=, =, >=, >, in, between， is null, is not null。 like和~ 操作支持从前匹配，如：foo% 、^foo。 B-tree也可用于获取排序后的数据，虽然效率...

numeric - 可以存储非常大数据，并且可存储高精度数据。numeric（precision, scale）例如：23.5141 precision=6, scale=4 可存储NaN值，代表not-a-number。在Postgresql中NaN和NaN数值是相等的，并且大于其他任何值。 serial - 用于自增字段。相当于： CREATE SEQUENCE tablename_...

记录阅读中在意的点 ###字段约束： check、notnull、unique、primary key、reference 外键必须关联primary key 或者unique字段。这两种字段都带索引。 exclude约束？？？ ###系统列 oid、tableoid、xmin、cmin、xmax、cmax、ctid。都是32位的字段。 ###schema（架构） 类似操作系统中的...