notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)Want a good monitor light? See my photosAll times are UTC		 Ukraine

Newsfeed changes

The news feed page[s] were not laid out well. Two pages, disjointed information, hard to figure out how to use the optional parameters...

Thankfully, someone told me.

The new page is ready for your review. Please compare these two:

You may also be interested in the Github issue.
Port details
py-aiosql Simple SQL in Python
13.3 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 11.0Version of this port present on the latest quarterly branch.
Maintainer: nivit@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-08-08 15:33:12
Last Update: 2025-03-12 17:57:37
Commit Hash: eec9587
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
Also Listed In: python
License: BSD2CLAUSE
WWW:
https://pypi.org/project/aiosql/
Description:
SQL is code. Write it, version control it, comment it, and run it using files. Writing your SQL code in Python programs as strings doesn't allow you to easily reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize your SQL statements in .sql files, load them into your python application as methods to call without losing the ability to use them as you would any other SQL file.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}aiosql>0:databases/py-aiosql@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-aiosql/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-aiosql
  • pkg install py311-aiosql
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-aiosql listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-aiosql
Package flavors (<flavor>: <package>)
  • py311: py311-aiosql
distinfo:
TIMESTAMP = 1741801942 SHA256 (aiosql-13.3.tar.gz) = 22f587522426106a45683ce206cddd1357dfea65487c88ae9dbf8cb2dc138f10 SIZE (aiosql-13.3.tar.gz) = 74957
Packages (timestamps in pop-ups are UTC):
py311-aiosql
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest13.313.3-13.313.3---
FreeBSD:13:quarterly13.313.3-11.013.3---
FreeBSD:14:latest13.313.3-13.313.3---
FreeBSD:14:quarterly11.013.3-11.013.3---
FreeBSD:15:latest13.313.3n/a13.3n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools-scm>=6.4 : devel/py-setuptools-scm@py311
  2. py311-setuptools>=42 : devel/py-setuptools@py311
  3. py311-wheel>=0.44.0 : devel/py-wheel@py311
  4. python3.11 : lang/python311
  5. py311-build>=0 : devel/py-build@py311
  6. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. python3.11 : lang/python311
This port is required by:
for Run
  1. misc/py-oterm
Configuration Options:
No options to configure
Options name:
databases_py-aiosql
USES:
python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/a/aiosql/
  2. https://pypi.org/packages/source/a/aiosql/
Collapse this list.

Number of commits found: 4

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
13.3
12 Mar 2025 17:57:37
commit hash: eec95871b08b19c5325eb7750ed7ddc79e96d597commit hash: eec95871b08b19c5325eb7750ed7ddc79e96d597commit hash: eec95871b08b19c5325eb7750ed7ddc79e96d597commit hash: eec95871b08b19c5325eb7750ed7ddc79e96d597 files touched by this commit		 Nicola Vitale (nivit) search for other commits by this committer 
databases/py-aiosql: Update to 13.3

Release changes:	https://github.com/nackjicholson/aiosql/releases/tag/13.3
Reported by:	portscout!
11.0
05 Sep 2024 06:18:34
commit hash: 0002d9e6731dddc7ecfcac6abe2d0f775f3ee154commit hash: 0002d9e6731dddc7ecfcac6abe2d0f775f3ee154commit hash: 0002d9e6731dddc7ecfcac6abe2d0f775f3ee154commit hash: 0002d9e6731dddc7ecfcac6abe2d0f775f3ee154 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/py-aiosql: Add NO_ARCH

Approved by:	portmgr (blanket)
11.0
18 Aug 2024 08:25:55
commit hash: 1d0704c74c3ccde73ee1108204c50fc694ed992acommit hash: 1d0704c74c3ccde73ee1108204c50fc694ed992acommit hash: 1d0704c74c3ccde73ee1108204c50fc694ed992acommit hash: 1d0704c74c3ccde73ee1108204c50fc694ed992a files touched by this commit		 Nicola Vitale (nivit) search for other commits by this committer 
databases/py-aiosql: Update to 11.0

Release
changes:	https://nackjicholson.github.io/aiosql/versions.html#on-2024-08-17
Reported by:	portscout
10.4
08 Aug 2024 15:31:51
commit hash: 9eb654981e811e75b0d120acbbce5f8a892ddb62commit hash: 9eb654981e811e75b0d120acbbce5f8a892ddb62commit hash: 9eb654981e811e75b0d120acbbce5f8a892ddb62commit hash: 9eb654981e811e75b0d120acbbce5f8a892ddb62 files touched by this commit		 Nicola Vitale (nivit) search for other commits by this committer 
databases/py-aiosql: Add new port

SQL is code. Write it, version control it, comment it, and run it using files.
Writing your SQL code in Python programs as strings doesn't allow you to easily
reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize
your SQL statements in .sql files, load them into your python application as
methods to call without losing the ability to use them as you would any other
SQL file.

https://pypi.org/project/aiosql/

Number of commits found: 4
Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
chromiumApr 15
perl5-develApr 15
perl5.38Apr 15
perl5.40Apr 15
ungoogled-chromiumApr 15
gogsApr 14
firefoxApr 13
firefoxApr 13
firefox-esrApr 13
thunderbirdApr 13
thunderbirdApr 13
jenkinsApr 11
jenkins-ltsApr 11
gitlabApr 10
expat2Apr 09

33 vulnerabilities affecting 346 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-04-15 11:03:49 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33271
Broken 126
Deprecated 286
Ignore 242
Forbidden 1
Restricted 2
No CDROM 1
Vulnerable 27
Expired 34
Set to expire 243
Interactive 0
new 24 hours 1
new 48 hours5
new 7 days16
new fortnight29
new month88
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.