Using a Docker container with a volume to persist the data held in a Postgresql database created via a YML file and docker-compose. If you want to share your Python/SQL project then this makes it much easier for others to use your code (and database) - They won't have to install a database (eg Postgresql).
A tour of the project with some tips and an overview of ini, yml, pytest with fixtures, and how you can create the tables and database from .sql files specified within the yml file.
🔗 https://docs.docker.com/compose/
🔗 Postgresql : • EBAY API + Python Tutorial
If you want a fast VPS server with Python installed check out :
🌏 https://webdock.io/en?maff=wdaff--170
Please clone it and try it out.
You'll need to install docker and psycopg2-binary as well.
pip install psycopg2-binary
- chapters -
00:00 Intro
02:46 docker compose
08:59 volumes
14:44 remove the container and volume
22:39 path to ini file
25:16 review the python code
------------------------------------------------------
🔗 https://github.com/RGGH/postgresql-py...
🔥 Project structure :
└── app
├── app
│ ├── app1.py
│ ├── app2.py
│ ├── database.ini
│ ├── db_con.py
│ ├── docker-compose.yml
│ ├── __init__.py
│ ├── postgres-data
│ ├──
│ │
│ └── sql
│ ├── create_tables.sql
│ └── fill_tables.sql
🔴🔴🔴 Proxies for Web Scraping 🔴🔴🔴
=================================================
If you need a good, easy to use proxy, I was recommended this one, and having used ScraperAPI for a while I can vouch for them. If you were going to sign up anyway, then maybe you would be kind enough to use the link and the coupon code below?
You can also do a full working trial first as well, (unlike some other companies). The trial doesn't ask for any payment details either so all good! 👍
🌏 10% off ScraperAPI : https://www.scraperapi.com?fpr=ken49
◼️ Coupon Code: DRPI10
(You can also get started with 1000 free API calls. No credit card required.)
Thumbs up yeah? (cos Algos..)
-------------------------------------------------------------------------
You can buy bitcoin here 👍👍👍
🌏 https://www.swanbitcoin.com/python360
+ get $10 in BTC when you join Swan !!
--------------------------------------------------------------------------
👍 Become a patron 👍
🌏 / drpi
Buy Dr Pi a coffee (or Tea)
☕ https://www.buymeacoffee.com/DrPi
#docker-python #postgresql-python #python
Смотрите видео Python Postgresql Docker | Python code to add and delete from database онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Python 360 27 Июнь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 2,791 раз и оно понравилось 31 посетителям.