作者： admin

系统为B/S模式（Browser/Server，浏览器/服务器模式），
后端采用Java语言，基于 J2EE 标准，Spring 框架，
前端采用Vue框架, 生成基于 HTML,CSS和JavaScript语言的Web标准页面,
通过REST式风格的 WebService 方式, 以JSON为数据格式 与后端进行交互，

查看所有表及备注

WITH T2 AS(
SELECT relname AS c_table_name, CAST(obj_description(relfilenode,'pg_class') AS VARCHAR) AS c_comment
FROM pg_class
)
SELECT tableowner AS t_owner,schemaname AS t_schema,tablename AS t_name,T2.*
FROM pg_tables AS T1
LEFT JOIN T2 ON T2.c_table_name = T1.tablename
WHERE T1.tablename NOT LIKE 'pg_%'
AND T1.schemaname IN ('schema_xxxx','schema_xxxx','schema_xxxx')


PostgreSQL 创建类似 MySQL 自增主键

-- CREATE SEQUENCE sys_user_userid_seq INCREMENT 1 START 100 MINVALUE 100 MAXVALUE 99999999 CACHE 1;
alter table sys_user alter column user_id set default nextval('sys_user_userid_seq');


PostgreSQL 返回其参数中第一个非空表达式 COALESCE
select COALESCE(null,null,’0′)

string_agg
select string_agg(col,',') ,cola from table_a group by cola


SELECT * FROM table01 WHERE col01= ANY(STRING_TO_ARRAY('aaaa,sss,bbb',','))


mac 终端下，执行以下命令，即可安装brew：
/usr/bin/ruby -e “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)”

参考
https://github.com/conda-forge/miniforge/#download
https://github.com/apple/tensorflow_macos/releases/tag/v0.1alpha1
https://claytonpilat.medium.com/tutorial-tensorflow-on-an-m1-mac-using-jupyter-notebooks-and-miniforge-dbb0ef67bf90

brew 提示错误 fatal: Could not resolve HEAD to a revision 
解决方式参考：
git -C $(brew --repository homebrew/core) checkout master
git -C $(brew --repository homebrew/core) reset --hard HEAD.

1. 安装docker

1.1 下载,打开,拖到 Application

MacM1# softwareupdate –install-rosetta
https://docs.docker.com/desktop/mac/apple-silicon/

1.2 [Google] docker for mac更换国内镜像源

https://blog.csdn.net/w605283073/article/details/105061455
https://docker.mirrors.ustc.edu.cn
https://hub-mirror.c.163.com

1.3 【Docker】
MacM1# docker run -d –privileged=true –name=armpy37_v2 -it arm64v8/python:3.7-bullseye bash

#docker虚拟机内运行
armpy37#

cp -a /etc/apt/sources.list /etc/apt/sources.list.bak
sed -i “s@http://ftp.debian.org@https://repo.huaweicloud.com@g” /etc/apt/sources.list
sed -i “s@http://deb.debian.org@https://repo.huaweicloud.com@g” /etc/apt/sources.list
sed -i “s@http://security.debian.org@https://repo.huaweicloud.com@g” /etc/apt/sources.list

apt-get update
apt-get install -y apt-transport-https ca-certificates
apt-get install -y python3-tables-dbg python3-tables-lib
apt-get install -y r-bioc-hdf5array r-bioc-rhdf5 r-bioc-rhdf5filters r-bioc-rhdf5lib
apt-get install -y r-cran-hdf5 r-cran-hdf5r vitables libhdf5-dev libhdf5-103 hdf5-tools h5utils hdf5-helpers
apt-get install -y xmpi openmpi-bin libxmpi4-dev mpi-default-dev libhdf5-openmpi-dev libhdf5-mpi-dev
apt-get install -y cmake

pip config set global.index-url https://repo.huaweicloud.com/repository/pypi/simple
pip config set global.trusted-host repo.huaweicloud.com

pip install stable-baselines
pip install versioned-hdf5

wget https://repo.rock-chips.com/pypi/simple/tensorflow/tensorflow-1.14.0-cp37-none-linux_aarch64.whl
pip install tensorflow-1.14.0-cp37-none-linux_aarch64.whl

cd /usr/local/lib/python3.7/site-packages/tensorflow/contrib/ && cp __init__.py __init__.py.backup
sed -i ‘s/if os.name/#if os.name/g’ /usr/local/lib/python3.7/site-packages/tensorflow/contrib/__init__.py
sed -i ‘s/from tensorflow.contrib import cloud/#from tensorflow.contrib import cloud/g’ /usr/local/lib/python3.7/site-packages/tensorflow/contrib/__init__.py

cd /dev/shm/ && wget https://apnode.win/cd/TestFPS.zip
cd /dev/shm/ && unzip TestFPS.zip && python TestFPS.PY

 
brew install fftw
brew install openblas
OPENBLAS=”$(brew –prefix openblas)” pip install numpy pandas
$ brew install python@3.9
$ brew install openblas
$ OPENBLAS=”$(brew –prefix openblas)” MACOSX_DEPLOYMENT_TARGET=11.1 python3 -m pip install cython –no-use-pep517
$ OPENBLAS=”$(brew –prefix openblas)” MACOSX_DEPLOYMENT_TARGET=11.1 python3 -m pip install numpy –no-use-pep517
$ OPENBLAS=”$(brew –prefix openblas)” MACOSX_DEPLOYMENT_TARGET=11.1 python3 -m pip install pandas –no-use-pep517
$ OPENBLAS=”$(brew –prefix openblas)” MACOSX_DEPLOYMENT_TARGET=11.1 python3 -m pip install pybind11 –no-use-pep517
$ OPENBLAS=”$(brew –prefix openblas)” MACOSX_DEPLOYMENT_TARGET=11.1 python3 -m pip install scipy –no-use-pep517
$ brew install libjpeg zlib
$ python3 -m pip install pillow
$ python3 -m pip install matplotlib
OPENBLAS=”$(brew –prefix openblas)” pip install numpy
 
OPENBLAS=”$(brew –prefix openblas)” pip install scipy

brew install pkg-config
brew install openblas gfortran
brew install hdf5
export OPENBLAS=/opt/homebrew/opt/openblas/lib/

https://stackoverflow.com/questions/65745683/how-to-install-scipy-on-apple-silicon-arm-m1

pip config set global.index-url https://repo.huaweicloud.com/repository/pypi/simple
pip config set global.extra-index-url https://repo.rock-chips.com/pypi/simple

arch -x86_64 /bin/bash -c “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)”

docker run –runtime=nvidia –rm nvidia/cuda:9.0-base nvidia-smi

==============================
https://developer.nvidia.com/cuda-toolkit-archive
https://developer.nvidia.com/rdp/cudnn-archive
参考：
https://www.jianshu.com/p/0b2c094724a0
https://github.com/NVIDIA/nvidia-docker/wiki/nvidia-docker
https://nvidia.github.io/nvidia-docker/

https://www.jianshu.com/p/f25ccedb996e
https://blog.csdn.net/submarineas/article/details/108477031

gym stable_baselines tensorflow 1.14

pip install stable_baselines

参考：
https://cloud.tencent.com/developer/article/1465684
https://github.com/linlinjava/litemall
https://gitee.com/xiandafu/springboot-plus
https://gitee.com/jishenghua/JSH_ERP
https://gitee.com/shownsheep/taotao-shop
https://gitee.com/mumu-osc/NiceFish
https://gitee.com/catshen/zscat_sw
https://github.com/lenve/VBlog
https://gitee.com/52itstyle/spring-boot-seckill
https://gitee.com/52itstyle/spring-boot-pay
https://github.com/lenve/vhr

https://gitee.com/BuLaoRen/beauty_ssm

教材项目
https://gitee.com/ityouknow/spring-boot-examples.git
https://gitee.com/baomidou/dynamic-datasource-spring-boot-starter.git