cain's recent timeline updates
cain

cain

V2EX member #347, joined on 2010-05-03 11:14:23 +08:00
电商系统部分模块外包
外包  •  cain  •  Oct 29, 2017  •  Lastly replied by cain
5
腾讯云数据下载
问与答  •  cain  •  Aug 1, 2016
仿一个 http://airware.com/
问与答  •  cain  •  Sep 12, 2014  •  Lastly replied by vibbow
3
iPhone 与未连接无线路由器的设备交互
问与答  •  cain  •  Jul 17, 2014  •  Lastly replied by ipconfiger
2
MBA 为啥关机还会消耗电池
  •  1   
    问与答  •  cain  •  Apr 30, 2014  •  Lastly replied by Coda
    6
    我对 npm 完全无语了
    问与答  •  cain  •  Apr 3, 2014  •  Lastly replied by zhangdawei
    15
    有谁有闲置的60W magsafe么
    二手交易  •  cain  •  Jan 30, 2013
    cain's recent replies
    Mar 13, 2023
    Replied to a topic by Mason2021 程序员 分享: Zed 编辑器邀请链接
    Jul 1, 2020
    Replied to a topic by HanHanNetizen 职场话题 是否有必要去坡县
    Apr 21, 2018
    Replied to a topic by yamyamyuo 求职 想找 Python 的兼职讲师职位
    联系方式?
    Aug 28, 2017
    Replied to a topic by xiaozy 问与答 PHP 按距离分页排序问题
    SELECT
    id, lng, lat,
    (st_distance (point (lng, lat), point({dest_lng}, {dest_lat}) ) / 0.0111) AS distance
    FROM
    locations
    HAVING distance < 50
    ORDER BY distance

    类似这样,使用 mysql 内置 geo spatial functions
    Ref: https://dev.mysql.com/doc/refman/5.6/en/spatial-function-reference.html
    时间统计可以用 window.performance.now() 代替获取时间的方法
    另外说linux丑的都是不懂调教的。。。另外xfce自带的tile window的功能在mac上还要装一个shiftit。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1069 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 22:53 · PVG 06:53 · LAX 15:53 · JFK 18:53
    ♥ Do have faith in what you're doing.