<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[小小程序猿]]></title><description><![CDATA[人的精力是有限的]]></description><link>https://blog.youkuaiyun.com/coolwxb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; coolwxb]]></copyright><item><title><![CDATA[Postgresql wal 归档文件处理]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/103729189</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/103729189</guid><author>coolwxb</author><pubDate>Fri, 27 Dec 2019 11:33:42 +0800</pubDate><description><![CDATA[数据库采用主从备份方式进行搭建，未及时清理归档，归档文件夹目录不断增大，撑爆整个磁盘。
所谓WAL日志归档，其实就是把在线的WAL日志备份出来。

wal_level='replica'

# - Archiving -

archive_mode = on               # enables archiving; off, on, or always
                ...]]></description><category></category></item><item><title><![CDATA[PostGresql 常用操作]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/103728412</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/103728412</guid><author>coolwxb</author><pubDate>Fri, 27 Dec 2019 10:54:10 +0800</pubDate><description><![CDATA[删除重复字段数据
ctid： 表示数据记录的物理行当信息，指的是 一条记录位于哪个数据块的哪个位移上面。 跟oracle中伪列 rowid 的意义一样的；只是形式不一样。
如果email字段重复，可利用ctid 进行删除
DELETE FROM user_accounts USING user_accounts ua2
WHERE user_accounts.email = ua2.email A...]]></description><category></category></item><item><title><![CDATA[Postgis 数据库坐标系偏移转换]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/102509735</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/102509735</guid><author>coolwxb</author><pubDate>Fri, 11 Oct 2019 20:36:14 +0800</pubDate><description><![CDATA[Postgis 数据库坐标系偏移转换
直接动态生成新字段
Github: https://github.com/FreeGIS/Postgis_Coordinate_Transform

支持WGS84与bd-09,gcj-02坐标系，百度经纬度与百度墨卡托之间互转。
支持点线面多点多线多面的复杂图形批量转换。
支持对整个表批处理转换。

约束：

要求转换的表是基于PostGIS创建的空间关系表...]]></description><category></category></item><item><title><![CDATA[Docker中Hadoop集群环境搭建]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/90796104</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/90796104</guid><author>coolwxb</author><pubDate>Tue, 04 Jun 2019 18:23:56 +0800</pubDate><description><![CDATA[使用腾讯云主机，docker构建集群测试环境。
环境
1、操作系统： CentOS 7.2 64位
网路设置




hostname
IP




cluster-master
172.18.0.2


cluster-slave1
172.18.0.3


cluster-slave2
172.18.0.4


cluster-slave3
172.18.0.5


Docker 安装
cur...]]></description><category></category></item><item><title><![CDATA[拦截UIViewController的popViewController事件]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/53886796</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/53886796</guid><author>coolwxb</author><pubDate>Mon, 26 Dec 2016 15:53:19 +0800</pubDate><description><![CDATA[实现拦截UIViewController的pop操作有两种方式：
自定义实现返回按钮，即设置UIBarButtonItem来实现自定义的返回操作。
创建UINavigatonController的Category，来定制navigationBar: shouldPopItem:的逻辑。
UIViewController+BackButtonHandler.h：#import <UIKit/UIKit]]></description><category></category></item><item><title><![CDATA[沙盒SandBox]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/53813945</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/53813945</guid><author>coolwxb</author><pubDate>Thu, 22 Dec 2016 14:33:46 +0800</pubDate><description><![CDATA[每个App都有自己的沙盒，也就是一个存储空间。App之间没有权限访问对方的沙盒资源。沙盒的目录下有三个文件夹：Documents、Library、temp目录结构 
* Documents：用于存储用户数据，iTunes备份和恢复的时候会包括此目录，所以，苹果建议将程序中建立的或在程序中浏览到的文件数据保存在该目录下。 
* Documents/Inbox:主要用来存放其他程序请求当前程序打开的文件]]></description><category></category></item><item><title><![CDATA[Images.xcassets不能获取图片路径]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/53517942</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/53517942</guid><author>coolwxb</author><pubDate>Thu, 08 Dec 2016 14:39:47 +0800</pubDate><description><![CDATA[原文地址：http://www.jianshu.com/p/5358f587af38Images.xcassets在app打包后，以Assets.car文件的形式出现在bundle中。其作用在于：
  自动识别@2x，@3x图片，对内容相同但分辨率不同的图片统一管理。 
  可以对图片进行剪裁和拉伸处理。 
  UIImage从bundle中加载图片资源
注意 
Images.xcassets中的图]]></description><category></category></item><item><title><![CDATA[js与native交互]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/53434794</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/53434794</guid><author>coolwxb</author><pubDate>Fri, 02 Dec 2016 15:03:11 +0800</pubDate><description><![CDATA[UIWebView WKWebView js调用]]></description><category></category></item><item><title><![CDATA[Sqlite 存储自定义对象]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/52059068</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/52059068</guid><author>coolwxb</author><pubDate>Thu, 28 Jul 2016 21:01:43 +0800</pubDate><description><![CDATA[在iOS中如果想保存自定义对象，要让自定义对象实现NSCoding接口并实现方法-(id)initWithCoder:(NSCoder *)coder和-(void)encodeWithCoder:(NSCoder *)coder;

@interface RegUserInfo : NSObject    
@property (nonatomic, strong) NSString *site]]></description><category></category></item><item><title><![CDATA[Mac下查看端口占用]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/52002976</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/52002976</guid><author>coolwxb</author><pubDate>Sat, 23 Jul 2016 10:43:02 +0800</pubDate><description><![CDATA[netstat命令


netstat -an | grep 端口号


lsof命令


lsof -i:端口号]]></description><category></category></item><item><title><![CDATA[iOS角度与弧度转换]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/52002962</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/52002962</guid><author>coolwxb</author><pubDate>Sat, 23 Jul 2016 10:41:25 +0800</pubDate><description><![CDATA[在iOS中图片的旋转单位为弧度而不是角度，所以经常会在两者之间进行转换


弧度转角度


#define RADIANS_TO_DEGREES(radians) ((radians) * (180.0 / M_PI))



角度转弧度


#define DEGREES_TO_RADIANS(angle) ((angle) / 180.0 * M_PI)


摘自：角度与弧度的转换


角度弧]]></description><category></category></item><item><title><![CDATA[JokeClient-Swift 仿写学习]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/52002926</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/52002926</guid><author>coolwxb</author><pubDate>Sat, 23 Jul 2016 10:36:32 +0800</pubDate><description><![CDATA[required init?(coder aDecoder: NSCoder) 可失败构造器


在init关键字后面添加问号(init?)。 
可失败构造器会创建一个类型为自身类型的可选类型的对象。你通过return nil语句来表明可失败构造器在何种情况下应该“失败”。


struct Animal {
    let species: String
    init?(species: S]]></description><category></category></item><item><title><![CDATA[SDWebImage添加header]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50822119</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50822119</guid><author>coolwxb</author><pubDate>Mon, 07 Mar 2016 20:37:24 +0800</pubDate><description><![CDATA[title: SDWebImage添加header
date: 2016-03-07 17:32:57
tags: SDWebImage
categories: IOS

keywords: SDWebImage,header

服务端采用阿里OSS设置了图片的访问限制，需要在请求图片的路径中添加自定义header：Refer:xxxxxxx，所以需要设置SDWebImage的配置

SDWebI]]></description><category></category></item><item><title><![CDATA[四叉树算法]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807529</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807529</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:25:19 +0800</pubDate><description><![CDATA[title: 四叉树算法
date: 2016-1-11 15:10
categories: IOS

tags: 算法

小小程序猿
我的博客：http://daycoding.com 

转载：http://blog.youkuaiyun.com/zhanxinhang/article/details/6706217

高德iOS聚合实例

高德Android聚合实例

四叉树或四元树也被称为Q树（Q-T]]></description><category></category></item><item><title><![CDATA[Masonry 使用复习总结]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807526</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807526</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:24:55 +0800</pubDate><description><![CDATA[title: Masonry 使用复习总结
date: 2015-08-23 11:07:53
categories: IOS

tags: Masonry

小小程序猿
我的博客：http://daycoding.com 


为了解决ios 原生写约束太痛苦这个问题
github：Masonry



安装

使用Pod组织安装masonry

platform :ios, '6.0'
pod]]></description><category></category></item><item><title><![CDATA[AFNetWorking同步方法]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807520</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807520</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:24:22 +0800</pubDate><description><![CDATA[title: AFNetWorking同步方法
date: 2015-11-14 11:05:30
categories: IOS

tags: afnetworking

小小程序猿
我的博客：http://daycoding.com 

AFNetWoring 同步方法的使用：

NSURL* url = [[NSURL alloc] initWithString:[HOST stringBy]]></description><category></category></item><item><title><![CDATA[guava使用]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807519</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807519</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:24:03 +0800</pubDate><description><![CDATA[title: guava使用
date: 2015-08-24 19:59:08
categories: ANDROID

tags: guava

小小程序猿
我的博客：http://daycoding.com]]></description><category></category></item><item><title><![CDATA[FastJson 解析报错deserializer error]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807516</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807516</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:23:49 +0800</pubDate><description><![CDATA[title: FastJson 解析报错deserializer error
date: 2015-08-24 19:59:08
categories: ANDROID

tags: fastjson

小小程序猿
我的博客：http://daycoding.com 

junit 测试解析json数据报错  



com.alibaba.fastjson.JSONException: crea]]></description><category></category></item><item><title><![CDATA[fmdb使用遇到的问题]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807514</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807514</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:23:37 +0800</pubDate><description><![CDATA[title: FMDB 相关知识
date: 2015-11-20 14:50
categories: IOS

tags: FMDB

小小程序猿
我的博客：http://daycoding.com 

fmdb保存blob类型数据

NSData* data = [NSKeyedArchiver archivedDataWithRootObject:task.img_ids];




fmd]]></description><category></category></item><item><title><![CDATA[Masonary]]></title><link>https://blog.youkuaiyun.com/coolwxb/article/details/50807512</link><guid>https://blog.youkuaiyun.com/coolwxb/article/details/50807512</guid><author>coolwxb</author><pubDate>Sat, 05 Mar 2016 10:23:23 +0800</pubDate><description><![CDATA[title: Masonry技巧
date: 2016-1-23 17:40
categories: IOS

tags: Masonry

小小程序猿
我的博客：http://daycoding.com 

Masonry调试

    //you can attach debug keys to views like so:
//    greenView.mas_key = @"greenV]]></description><category></category></item></channel></rss>