self-contained-runnable-python-package-template
psycopg2
Our great sponsors
self-contained-runnable-python-package-template | psycopg2 | |
---|---|---|
3 | 19 | |
18 | 3,209 | |
- | 1.7% | |
0.0 | 6.8 | |
over 1 year ago | about 23 hours ago | |
Python | C | |
GNU General Public License v3.0 only | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
self-contained-runnable-python-package-template
-
Underappreciated Challenges with Python Packaging
The approach I prefer is to not mess with setuptools etc at all in the first place, and simply make a nice executable package.
e.g. https://github.com/tpapastylianou/self-contained-runnable-py...
-
How to create a Python package in 2022
The title should be: How to create a "Python DISTRIBUTION package".
The term "python package" means something entirely different (or at the very least is ambiguous in a pypi/distribution context).
To add to the confusion, creating a totally normal, runnable python package in a manner that makes it completely self-contained such that it can be "distributed" in a standalone manner, while still being a totally normal boring python package, is also totally possible (if not preferred, in my view).
Shameless plug: https://github.com/tpapastylianou/self-contained-runnable-py...
-
Show HN: Hatch 1.0.0 – Modern, extensible Python project management
Shameless plug: I use my own template, which organises things as runnable projects.
https://github.com/tpapastylianou/self-contained-runnable-py...
It serves my purposes very well (which is creating projects that represent standalone experiments).
Sharing in case someone else here finds it useful.
More recently I've modified this a bit to also generate nice html reports straight from the __main__.py file, independently of the underlying python code, and use this as lab books (where each lab book contains a single analysis and its report). I'll upload this template separately when I find the time.
psycopg2
-
Can I learn Python while practicing writing queries for SQL simultaneously? I've recently completed learning SQL and trying to get better at it.
You can practice both by using https://www.psycopg.org from your Python code to communicate with your database. When I wanted to practice some SQL, that's what I did (we use psycopg at work, so that's what I practiced with, making a dream journal thingy for myself that was better than just noting stuff in a notepad because I could then look up e.g. what other stuff was correlated with Y, how many times I dreamed of X, etc. etc.)
-
Installing psycopg2==2.8.6 throws an error
But seems like it should work with Django 3, which you have specified https://github.com/psycopg/psycopg2/issues/1293
-
Uploading CSVs to a SQL table using Python
If you're using Postgres for your SQL, look at the "copy' method of the psycopg module (see https://www.psycopg.org/articles/2020/11/15/psycopg3-copy/) . It's much faster than INSERTs in my experience (YMMV).
-
Underappreciated Challenges with Python Packaging
Back when I used Psycopg2, there was no -binary package, so you'd get libpq set up similarly to pg-native. Docs say:
> The binary package is a practical choice for development and testing but in production it is advised to use the package built from sources.
Relevant GitHub discussion: https://github.com/psycopg/psycopg2/issues/674
I dunno, this seems worse to me.
-
Integrate PostgreSQL Database In Python - A Hands-On Guide
Just go to the more easily readable docs here. I’m sorry, but the linked article is terrible.
-
Has anyone made the switch from developing in Windows to macOS? Any general or specific advice about the switch?
psycopg2-binary. See https://github.com/psycopg/psycopg2/issues/1286.
-
Dockerize a Django, React, and Postgres application with docker and docker-compose | by Anjal Bam
psycopg2-binary, PostgreSQL Database adapter for python.
-
My Cookiecutter Django Setup
... # psycopg2==2.9.3 # https://github.com/psycopg/psycopg2 ...
-
Why "import blescan as blescan"?
I sometimes do this in testing. For example, consider the library used to communicate with a Postgres database, psycopg.
- Engineers complaining about Docker for Mac?
What are some alternatives?
hatch - Modern, extensible Python project management
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
Nuitka - Nuitka is a Python compiler written in Python. It's fully compatible with Python 2.6, 2.7, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, 3.10, and 3.11. You feed it your Python app, it does a lot of clever things, and spits out an executable or extension module.
queries - PostgreSQL database access simplified
Poetry - Python packaging and dependency management made easy
SQLAlchemy - The Database Toolkit for Python
pip-audit - Audits Python environments, requirements files and dependency trees for known security vulnerabilities, and can automatically fix them
PostgreSQL - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
tox-poetry-installer - A plugin for Tox that lets you install test environment dependencies from the Poetry lockfile
txpostgres - Twisted wrapper for asynchronous PostgreSQL connections
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
Python PG Extras - Python PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.