#创建一个名为cof的 用户，并设置密码 postgres=# grant all on database db_test to cof; #给cof授权，有操作db_test 库的所有权限 postgres=# postgres=# revoke all on database db_test from cof; #撤销用户权限 postgres=# drop user cof -d db_test #使用cof用户登录pg，连接 db_test这个库 db_test=> #提示符 => 表示普通账号，=#表示管理员账号 db_test=> #提示符=>前的db_test表示当前数据库名 datname from pg_database; #列出所有数据库（标准的sql 语句） datname ----------- postgres template1 template0 db_test postgres=# \l #列出所有数据库（pg内置查询命令）

into version control 1. Application code & dependencies 2. Environment scripts & creation tools 3. DB scripts and reference data 4. Containers 5. Automated tests 6. Project artifacts – documentation configuration files 7. Run automated smoke tests 8. Running test procedures 9. Scripting & automating DB migrations iii. Focus on areas to reduce lead times and handoffs iv. New requirements for the deployment traffic back 2. Database changes a. Create two DB – put one in read only mode, backup & restore to new environment, swing traffic b. Decouple DB changes from application changes i. Make only additive

in our own image, and it is obese"  Modern web hourglass, web tier is now thin, smarts moved to browser Metrics, metrics everywhere (but where the heck do you start?) by Tammy Everts & Cliff Crocker

tk-devel gcc gcc-c++ make patch libffi-devel python- devel \ gdbm-devel xz-devel libpcap-devel db4-devel # tar -xvf Python-3.x.x.tgz #解压源码包 # cd Python-3.x.x ★sqlite3模块 import sqlite3 sqlite_conn = sqlite3.connect('test.db') # 连接数据库文件， 若文件不存在则新建 # 数据库所有数据存储在此文件中，默认数据库名称同文件名（不含.db后 缀） sqlite_cursor = sqlite_conn.cursor() # 创建一个游标，用于执 行sql语句 # 查询是否有名为'tb_test'的表 close() sqlite_conn.commit() # 保存 sqlite_conn.close() # 关闭连接 sqlite_conn2 = sqlite3.connect('test.db') # 连接数据库（此 时数据库文件已存在） sqlite_cursor2 = sqlite_conn2.cursor() # 创建一个游标，用于 执行sql语句 sqlite_cursor2

54:6443 --token abcdef.0123456789abcdef \ --discovery-token-ca-cert-hash sha256:63b5f34842ec20db12f19f6f4ca535b03e498e95842b97b452a04f9dc94b1151 \ --control-plane --cer�ficate-key 9b77643809b70 54:6443 --token abcdef.0123456789abcdef \ --discovery-token-ca-cert-hash sha256:63b5f34842ec20db12f19f6f4ca535b03e498e95842b97b452a04f9dc94b1151 # mkdir ~/.kube # cp /etc/kubernetes/admin.conf

Every technology under the sun  Solaris, Windows, Linux  Apache, IIS, TCServer, etc.  Oracle, DB2, SQL Server  How we got better  We read and we studied.  Created a self-improvement project