Eduard-gan

# How to migrate Django from SQLite to PostgreSQL

Dump existing data with currens Sqlite db configured:
```
./manage.py dumpdata > dump.json
```

Switch DATABASE configuration in settings.py to Postgres backend.

Make sure you can connect on PostgreSQL. Then:

Eduard-gan

ngrok - Публикация локального сервиса в интернет. Мощнейшая фича для быстрого тестирования.

Eduard-gan

docker run -d --name=bind --publish=0.0.0.0:53:53/udp --publish=0.0.0.0:10000:10000 --env='ROOT_PASSWORD=aa' sameersbn/bind:latest
login on https://127.0.0.1:10000(docker hosy-system) with login root password aa
go to "Servers" -> "BIND DNS server"
create zone for overriding with "create master zone" for example "tyr66.ru"
go to zone and add sone hosts to resolve
dont forget to apply changes with "Apply conwiguration" round arrows in right-top corner on screen with all zones.
test on docker host system: host tyr66.ru 192.168.1.7(external ip address of docker-host-system)

Eduard-gan

*.pyc
*.sqlite
*.sqlite3
*.sql
*.db
*.gz
*.orig
*.dump
media/
.ropeproject/

Eduard-gan

14 7,12,17,21 * * * /home/workupdater/.pyenv/versions/workupdater/bin/python /home/workupdater/www/Zarplata_vacancies_update.py > /dev/null 2>&1

Eduard-gan

version: '2'
services:
  test:
    image: debian:stable
    env_file:
     - ./vars
    stdin_open: true  # Аналог docker run -i. Это оставляет контэйнер запущенным в бэкграунде
    tty: true   # Аналог docker run -t. Это оставляет контэйнер запущенным в бэкграунде

Eduard-gan

...

+

export PATH="$HOME/.pyenv/bin:$PATH"    
eval "$(pyenv init -)"
eval "$(pyenv virtualenv-init -)"

Eduard-gan

deb [arch=amd64] https://download.docker.com/linux/debian stretch stable

Eduard-gan

sudo mount -t vboxsf share_name /home/your_user/Desktop/host

Eduard-gan

export PATH="${HOME}/.local/bin:$PATH"