TGTGInsightinteligencia telegramLIVE / telegram public index
← Python Academy

TGINSIGHT SIMILAR POSTS

Buscar contenido similar

Canal fuente @python_academy · Post #2097 · 20 jul

Управление базой данных в Python с Alembic и SQLAlchemy Сегодня мы поговорим о том, как можно эффективно управлять структурой вашей базы данных в Python с использованием библиотек Alembic и SQLAlchemy. Эта связка инструментов позволяет легко мигрировать схему базы данных, управлять версиями и обеспечивает удобный способ разработки и поддержки приложений. Что такое Alembic и SQLAlchemy? SQLAlchemy - это мощная библиотека для работы с базами данных в Python. Она предоставляет ORM (Object-Relational Mapping), что делает работу с базой данных более Pythonic. Вы можете определять модели данных, выполнять запросы и манипулировать данными, используя чистый Python. Alembic - это инструмент для управления миграциями базы данных. Он позволяет создавать и применять миграции для изменения структуры базы данных, такие как создание таблиц, добавление столбцов или изменение индексов. Пример использования Alembic и SQLAlchemy: 1. Установка библиотек: pip install sqlalchemy alembic 2. Инициализация Alembic: alembic init my_migration 3. Определение моделей данных в SQLAlchemy: from sqlalchemy import create_engine, Column, Integer, String from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) 4. Создание миграции: alembic revision --autogenerate -m "Create user table" 5. Применение миграции: alembic upgrade head Теперь вы можете легко управлять структурой базы данных, создавать новые миграции и применять их, чтобы обновить вашу базу данных. Полезные ссылки: - SQLAlchemy: https://www.sqlalchemy.org/ - Alembic: https://alembic.sqlalchemy.org/ #python#sqlalchemy#alembic#базаданных#миграции

Resultados

1,009 posts similares encontrados

Búsqueda global general

Am Neumarkt 😱

@amneumarkt · Post #406 · 15/09/2022, 15:16

#python Faster conda https://www.anaconda.com/blog/a-faster-conda-for-a-growing-community

Hashtags

Am Neumarkt 😱

@amneumarkt · Post #381 · 21/07/2022, 21:04

#python Guidelines for research coding. It is not the highest standard but is easy to follow. https://goodresearch.dev/

Hashtags

Am Neumarkt 😱

@amneumarkt · Post #356 · 14/05/2022, 11:46

#python This post is a retro on how I learned Python. Disclaimer: I can not claim that I am a master of Python. This post is a retrospective of how I learned Python in different stages. I started using Python back in 2012. Before this, I was mostly a Matlab/C user. Python is easy to get started, yet it is hard to master. People coming from other languages can easily make it work but will write some "disgusting" python code. And this is because Python people talk about "pythonic" all the time. Instead of being an actual style guide, it is rather a philosophy of styles. When we get started, we are most likely not interested in [PEP8](https://peps.python.org/pep-0008/) and [PEP257](https://peps.python.org/pep-0257/). Instead, we focus on making things work. After some lectures from the university (or whatever sources), we started to get some sense of styles. Following these lectures, people will probably write code and use Python in some projects. Then we began to realize that Python is strange, sometimes even doesn't make sense. Then we started leaning about the philosophy behind it. At some point, we will get some peer reviews and probably fight against each other on some philosophies we accumulated throughout the years. The attached drawing (in comments) somehow captures this path that I went through. It is not a monotonic path of any sort. This path is most likely to be permutation invariant and cyclic. But the bottom line is that mastering Python requires a lot of struggle, fights, and relearning. And one of the most effective methods is peer review, just as in any other learning task in our life. Peer review makes us think, and it is very important to find some good reviewers. Don't just stay in a silo and admire our own code. To me, the whole journey helped me building one of the most important philosophies of my life: embrace open source and collaborate.

Hashtags

Am Neumarkt 😱

@amneumarkt · Post #349 · 03/05/2022, 06:12

#python Anaconda open sourced this... I have no idea what this is for... https://github.com/pyscript/pyscript

Hashtags

Am Neumarkt 😱

@amneumarkt · Post #322 · 03/03/2022, 07:29

#python I find poetry a great tool to manage Python requirements. I used to manage Python requirements using requirements.txt(environment.yaml) and install them using pip(conda). The thing is, in this stack, we have to pin the version ranges manually. It is quite tedious, and we easily run into version problems for a large project. Poetry is the savior here. When developing a package, we add some initial dependencies to the pyproject.yaml, a PEP standard. Whenever a new package is needed, we run poetry add package-name. Poetry tries to figure out the compatible versions. A lock file for the dependencies with restricted versions will be created or updated. To recreate an identical python environment, we only need to run poetry install. There's one drawback and may be quite painful at some point. Recreating the lock file for dependencies is extremely slow when the complexity grows in the requirements. But this is not a problem if poetry but rather constraints from pypi. One solution to this problem is to use cache. https://python-poetry.org/

Hashtags

Am Neumarkt 😱

@amneumarkt · Post #311 · 17/01/2022, 21:15

#python I thought it was a trivial talk in the beginning. But I quickly realized that I may know every each piece of the code mentioned in the video but the philosophy is what makes it exciting. He talked about some fundamental ideas of Python, e.g., protocols. After watching this video, an idea came to me. Pytorch lightning has implanted a lot of hooks in a very pythonic way. This is what makes pytorch lightning easy to use. (So if you do a lot of machine learning experiments, pytorch lightning is worth a try.) https://youtu.be/cKPlPJyQrt4

Hashtags

Linuxgram 🐧

@linuxgram · Post #18747 · 11/05/2026, 14:45

📰 Feature freeze for Python 3.15 as first beta released JIT compiler much improved, but no reinstatement for leaky incremental garbage collector. 🔗 Source: https://www.theregister.com/devops/2026/05/11/feature-freeze-for-python-315-as-first-beta-released/5237934 #python

Hashtags

Linuxgram 🐧

@linuxgram · Post #18631 · 30/04/2026, 15:35

📰 New Python Backdoor Uses Tunneling Service to Steal Browser and Cloud Credentials Cybersecurity researchers have disclosed details of a stealthy Python-based backdoor framework called DEEP#DOOR that comes with capabilities to establish persistent access and harvest a wide range of sensitive information from compromised hosts."The intrusion chain begins with execution of a batch script ('install_obf.bat') that disables Windows security controls, dynamically extracts an. 🔗 Source: https://thehackernews.com/2026/04/new-python-backdoor-uses-tunneling.html #python

Hashtags

Linuxgram 🐧

@linuxgram · Post #18589 · 27/04/2026, 17:17

📰 PyPI package with 1.1M monthly downloads hacked to push infostealer An attacker pushed a malicious version of the popular elementary-data package Python Package Index (PyPI) to steal sensitive developer data and cryptocurrency wallets. 🔗 Source: https://www.bleepingcomputer.com/news/security/pypi-package-with-11m-monthly-downloads-hacked-to-push-infostealer/ #python

Hashtags

Yiove 资讯频道

@yiovenews · Post #8709 · 12/10/2022, 16:37

#Python crawlTelegraph 【简介】:一个批量爬取 Telegra.ph 中图片的程序 【起因】: 因为看到一个COSER挺漂亮的,所以想下载她的资源。但是呢,找是找到了,只不过是放在Telegraph中的。这如果是一张一张下吧,效率特别低。要是用浏览器插件吧,我又不太乐意。 所以就自己动手用Python写了一个爬虫。 【查看详情】:https://www.skyqian.com/archives/crawlTelegraph.html

Hashtags

Yiove 资讯频道

@yiovenews · Post #8707 · 11/10/2022, 15:43

#Python 写了一个【阅读书源校验工具】 【查看详情】:https://www.qian.blue/archives/verifyBookSource.html

Hashtags

Repositorio data science

@repo_science · Post #4106 · 25/04/2024, 00:44

#Python 🖥 Curso de Python de 16 días ----- Main channel: @repo_science Coupons: @freecoupons_reposcience -----

Hashtags

12•••5•••89101112•••15•••20•••25•••30•••35•••40•••45•••50•••55•••60•••65•••70•••75•••80•••8485