# deeplearningnote

**Repository Path**: zhaozzlab/deeplearningnote

## Basic Information

- **Project Name**: deeplearningnote
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: BSD-3-Clause
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-01-22
- **Last Updated**: 2021-03-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# deeplearningnote
## postgressql 数据库的使用
```sh
启动服务postgressql
sudo /etc/init.d/postgresql restart
```
```
$ sudo su - postgres
$ psql
postgres=# CREATE USER yy WITH PASSWORD 'yy';
CREATE ROLE
postgres=# CREATE DATABASE blogbase;
CREATE DATABASE
postgres=# GRANT ALL PRIVILEGES ON DATABASE blogbase to yy;
GRANT
修改用户密码

alter user 用户名 with password '新密码';
ALTER ROLE
登录数据库

psql -U yy -d blogbase -h 127.0.0.1
-U:指定用户，-d:指定数据库，-h:指定服务器,如有端口用 -p 指定

执行上述命令后，如果出现例如 "Password for user yy: " 这样的语句让输入密码，输入密码后即登录成功

重命名数据库

alter database blogbase rename to blogbase1;
服务

# 查看状态
sudo /etc/init.d/postgresql status

# 启动
sudo /etc/init.d/postgresql start

# 停止
sudo /etc/init.d/postgresql stop

# 重启
sudo /etc/init.d/postgresql restart

```

## docker 使用
```
sudo NV_GPU=0,1 nvidia-docker run -it -e NVIDIA_DRIVER_CAPABILITIES=compute,utility,video --name decode -v /host:/container nvidiavideodecode
sudo  NV_GPU=0,1 nvidia-docker run -it -e NVIDIA_DRIVER_CAPABILITIES=compute,utility,video --name test0306 -v /firedetect/test0306:/raid -p  9100:9100 caai "/bin/bash"
```

## 服务器部署
```
watch -n 1 nvidia-smi #实时监控显卡是使用情况

apt install docker
apt install docker.io
apt-get update
apt-get install -y nvidia-docker2

```

## 测试端口
```python
#server
import socket,time
serversocket = socket.socket(socket.AF_INET,socket.SOCK_STREAM)
serversocket.bind(('',8345))
serversocket.listen(5)
while(True):
    (clientsocket,address)=serversocket.accept()
    data = clientsocket.recv(4096)
    print("the send data is",data)
    clientsocket.send(b"hello")
    clientsocket.close()

```
```python
#client
import socket,time,sys
sock = socket.socket(socket.AF_INET,socket.SOCK_STREAM)
sock.connect((sys.argv[1],8345))
sock.send(b'yy')
message=sock.recv(4096)
print(message)
sock.close()


```


###postgressql笔记
```python
import psycopg2
conn = psycopg2.connect(database="caaidb", user="caai", password="caai123456", host="127.0.0.1", port="5432")

print("Opened database successfully")
cur = conn.cursor()
cur.execute('''CREATE TABLE COMPANY
                (ID        TEXT, 
                Time TEXT, 
                Event TEXT, 
                ImagePath TEXT, 
                ImageID TEXT, 
                ChnID TEXT, 
               Info TEXT 
               );
                
                ''')
print("Table created successfully")

conn.commit()
conn.close()

```


```sql
su - postgres
su -postgres
psql



create user ysr superuser password '123456';
CREATE DATABASE runoobdb;
```