wkt blog

  • About
  • About

Month: April 2019

frp内网穿透加nginx 反向代理

by admin/April 27, 2019May 25, 2019/其他

目的: 将站点部署到外网无法访问的树莓派中. 部署wordpress 可使用 lnmp 部署, 也可以使用 docker, 树莓派3B+不支持原版的 mysql docker 镜像. 故本次镜像使用: hypriot/rpi-mysql. docker-compose 文件为: version: ‘3.3’ services: wordpress: depends_on: – db image: wordpress:latest volumes: – /home/xxx/files/wwwroot/xxx:/var/www/html ports: – “81:80” restart: always environment: WORDPRESS_DB_HOST: db:3306 WORDPRESS_DB_USER: wordpress WORDPRESS_DB_PASSWORD: xxx […]

树莓派(Raspbian)安装docker-compose

by admin/April 19, 2019/其他

依照官网提供的方法https://docs.docker.com/compose/install/, 会下载一个404的页面到/usr/local/bin下, 原因是系统不主流导致sudo curl -L “https://github.com/docker/compose/releases/download/1.24.0/docker-compose-$(uname -s)-$(uname -m)” -o /usr/local/bin/docker-compose指向了不存在的路径. 安装方法 sudo pip install docker-compose 但是直接pip会提示缺少依赖导致错误: File “/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py”, line 1145, in build_and_install self.run_setup(setup_script, setup_base, args) File “/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py”, line 1133, in run_setup raise DistutilsError(“Setup script exited with %s” % (v.args[0],)) distutils.errors.DistutilsError: […]

postgrepsql 添加自增列

by admin/April 17, 2019May 7, 2019/其他

表中已有数据, 需要填充: 如果没有id字段 alter table bandwidth_day_use add id serial not null; 如果有id字段 PostgreSQL中让主键自增长可先建立一个对应表的sequence CREATE SEQUENCE test_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 其中START是从数字几开始,INCREMENT BY是一次增长几个数字,NO MINVALUE是没有最小值,NO MAXVALUE是没有最大值; 然后修改表id字段 alter table test alter column id set […]

sqlalchemy 打印真实sql

by admin/April 17, 2019April 17, 2019/其他

print(q.statement.compile(compile_kwargs={“literal_binds”: True}))

postgresql修改插入数据id的起始值

by admin/April 2, 2019/其他

比如修改表company的id自增从422开始 select setval(‘company_id_seq’, 422, true)

Recent Posts

  • docker编译arm python
  • Create a virtual serial port that relays data over ssh
  • 在ssh服务器上创建代理, 使所有流量经过ssh客户端
  • linux:将目录里的软连接替换为原始文件
  • IntelliJ Idea: How to open project from the network share

Archives

  • July 2022
  • December 2021
  • September 2021
  • July 2021
  • June 2021
  • December 2020
  • November 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018
  • September 2018
  • August 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • June 2017
  • May 2017
  • April 2017
  • April 2016

友情链接

  • Harttle
  • 张俊杰的微博客
  • 蔣振飞的博客
  • 饲养员的窝
Proudly powered by WordPress | Theme: ShowMe by NEThemes.