notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
py-sqlparse Non-validating SQL parser for Python
0.3.0_1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port 0.3.0Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2011-06-25 09:39:38
Last Update: 2019-04-10 07:18:32
SVN Revision: 498530
Also Listed In: python
License: BSD3CLAUSE
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py36-sqlparse>0:databases/py-sqlparse
Conflicts:
CONFLICTS_INSTALL:
  • py36-sqlparse020
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port: cd /usr/ports/databases/py-sqlparse/ && make install clean
To add the package: pkg install py36-sqlparse
PKGNAME: py36-sqlparse
Package flavors (<flavor>: <package>)
  • py36: py36-sqlparse
  • py27: py27-sqlparse
distinfo:

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py36-setuptools>0 : devel/py-setuptools@py36
  2. python3.6 : lang/python36
Runtime dependencies:
  1. py36-setuptools>0 : devel/py-setuptools@py36
  2. python3.6 : lang/python36
This port is required by:
for Build
  1. misc/py-glance
for Run
  1. databases/py-mycli
  2. databases/py-pgcli
  3. databases/py-pgspecial
  4. databases/py-sqlalchemy-migrate
  5. misc/py-glance
  6. www/py-dj21-django-debug-toolbar
  7. www/py-dj22-django-debug-toolbar
Expand this list (11 items / 4 hidden)
  1. www/py-django-debug-toolbar
  2. www/py-django22
  3. www/py-django30
  4. Collapse this list.

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. emulators/py-nova*
  2. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options

USES:

Master Sites:
  1. https://files.pythonhosted.org/packages/source/s/sqlparse/
  2. https://pypi.org/packages/source/s/sqlparse/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2017-11-30
    Affects: */py*
    Author: mat@FreeBSD.org
    Reason: 
      Ports using Python via USES=python are now flavored.  All the py3-* ports
      have been removed and folded into their py-* master ports.
    
      People using Poudriere 3.2+ and binary packages do not have to do anything.
    
      For other people, to build the Python 3.6 version of, for example,
      databases/py-gdbm, you need to run:
    
        # make FLAVOR=py36 install
    
    

Number of commits found: 16

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
10 Apr 2019 06:18:32
Original commit files touched by this commit  0.3.0_1
Revision:498530
antoine search for other commits by this committer
Bump a few PORTREVISIONs after r498529

With hat:	portmgr
12 Mar 2019 18:09:48
Original commit files touched by this commit  0.3.0
Revision:495481
sunpoet search for other commits by this committer
Update to 0.3.0

Changes:	https://github.com/andialbrecht/sqlparse/blob/master/CHANGELOG
28 Feb 2019 21:35:13
Original commit files touched by this commit  0.2.4
Revision:494194
sunpoet search for other commits by this committer
Update CONFLICTS_INSTALL
25 Apr 2018 16:42:38
Original commit files touched by this commit  0.2.4
Revision:468282
amdmi3 search for other commits by this committer
Switch all pypi.python.org WWWs to a new PyPi home pypi.org where
they now redirect to anyway. All new urls checked to return 200,
I've fixed a couple of them in the process.

Approved by:	portmgr blanket, mat
13 Dec 2017 20:49:59
Original commit files touched by this commit  0.2.4
Revision:456244
sunpoet search for other commits by this committer
Add CONFLICTS_INSTALL
28 Sep 2017 10:40:47
Original commit files touched by this commit  0.2.4
Revision:450818
sunpoet search for other commits by this committer
Update to 0.2.4

- Add LICENSE_FILE

Changes:	https://github.com/andialbrecht/sqlparse/blob/master/CHANGELOG
02 Mar 2017 17:59:22
Original commit files touched by this commit  0.2.3
Revision:435258
sunpoet search for other commits by this committer
Update to 0.2.3

Changes:	https://github.com/andialbrecht/sqlparse/blob/master/CHANGELOG
03 Dec 2016 08:31:42
Original commit files touched by this commit  0.2.2_1
Revision:427600
sunpoet search for other commits by this committer
- Allow concurrent installation (USE_PYTHON=concurrent)
- Bump PORTREVISION for package change
19 Nov 2016 17:07:38
Original commit files touched by this commit  0.2.2
Revision:426458
sunpoet search for other commits by this committer
- Update to 0.2.2
- Add PyPI as primary WWW

Changes:	https://github.com/andialbrecht/sqlparse/blob/master/CHANGELOG
05 Nov 2016 18:00:57
Original commit files touched by this commit  0.2.0
Revision:425411
sunpoet search for other commits by this committer
- Update to 0.2.0
- Add NO_ARCH
- Take maintainership

Changes:	https://github.com/andialbrecht/sqlparse/blob/master/CHANGELOG
Differential Revision:	https://reviews.freebsd.org/D8414
Approved by:	wg (maintainer)
19 May 2016 10:21:25
Original commit files touched by this commit  0.1.16
Revision:415498
amdmi3 search for other commits by this committer
- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket
11 Oct 2015 08:56:09
Original commit files touched by this commit  0.1.16
Revision:399081
pi search for other commits by this committer
databases/py-sqlparse: 0.1.2 -> 0.1.16

Changes: Lots.
  https://github.com/andialbrecht/sqlparse/blob/master/CHANGES

PR:		198683
Submitted by:	wg
19 Oct 2014 08:50:18
Original commit files touched by this commit  0.1.2_1
Revision:371173
mva search for other commits by this committer
- Convert ports from databases/ and deskutils/ to new USES=python

Approved by:	portmgr (implicit)
15 Apr 2014 15:29:48
Original commit files touched by this commit  0.1.2_1
Revision:351343
swills search for other commits by this committer
- Stage [1]
- Add LICENSE [1]
- Pet portlint [1]
- Avoid deprecated USE_PYDISTUTILS=easy_install
- Switch to automatic PLIST
- Bump PORTREVISION due to package change

PR:		ports/188622 [1]
Submitted by:	Bartek Rutkowski <ports@robakdesign.com> [1]
Approved by:	portmgr@ (blanket)
20 Sep 2013 16:13:49
Original commit files touched by this commit  0.1.2
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
25 Jun 2011 09:39:15
Original commit files touched by this commit  0.1.2

miwi search for other commits by this committer
sqlparse is a non-validating SQL parser module.
It provides support for parsing, splitting and formatting SQL statements.

WWW: http://code.google.com/p/python-sqlparse/

PR:             ports/156828
Submitted by:   Roland van Laar <roland at micite.net>

Number of commits found: 16

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?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
drm-current-kmodJan 15
drm-devel-kmodJan 15
drm-fbsd11.2-kmodJan 15
drm-fbsd12.0-kmodJan 15
mariadb101-serverJan 15
mariadb102-serverJan 15
mariadb103-serverJan 15
mariadb104-serverJan 15
mariadb55-serverJan 15
mysql56-serverJan 15
mysql57-serverJan 15
mysql80-serverJan 15
percona55-serverJan 15
percona56-serverJan 15
percona57-serverJan 15

8 vulnerabilities affecting 131 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-01-15 20:24:12


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38405
Broken 688
Deprecated 693
Ignore 963
Forbidden 3
Restricted 152
No CDROM 72
Vulnerable 26
Expired 3
Set to expire 665
Interactive 0
new 24 hours 15
new 48 hours24
new 7 days41
new fortnight84
new month198

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.