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
p5-Class-DBI-SQLite Extension to Class::DBI for sqlite
0.11_2 databases on this many watch lists=3 search for ports that depend on this port Find issues related to this port Report an issue related to this port 0.11Version of this port present on the latest quarterly branch.
Maintainer: perl@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2003-07-22 14:41:19
Last Update: 2018-07-09 09:40:18
SVN Revision: 474242
Also Listed In: perl5
License: not specified in port
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (2 items)
  1. lib/perl5/site_perl/Class/DBI/SQLite.pm
  2. lib/perl5/site_perl/man/man3/Class::DBI::SQLite.3.gz
Collapse this list.
Dependency lines:
  • p5-Class-DBI-SQLite>0:databases/p5-Class-DBI-SQLite
To install the port: cd /usr/ports/databases/p5-Class-DBI-SQLite/ && make install clean
To add the package: pkg install p5-Class-DBI-SQLite
PKGNAME: p5-Class-DBI-SQLite
Flavors: there is no flavor information for this port.
distinfo:

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. p5-Ima-DBI>=0 : databases/p5-Ima-DBI
  2. p5-Class-DBI>=0 : databases/p5-Class-DBI
  3. p5-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  4. p5-SQL-Statement>=0 : databases/p5-SQL-Statement
  5. p5-Clone>=0 : devel/p5-Clone
  6. perl5>=5.26<5.27 : lang/perl5.26
  7. perl5>=5.26<5.27 : lang/perl5.26
Runtime dependencies:
  1. p5-Ima-DBI>=0 : databases/p5-Ima-DBI
  2. p5-Class-DBI>=0 : databases/p5-Class-DBI
  3. p5-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  4. p5-SQL-Statement>=0 : databases/p5-SQL-Statement
  5. p5-Clone>=0 : devel/p5-Clone
  6. perl5>=5.26<5.27 : lang/perl5.26
This port is required by:
for Build
  1. lang/p5-JSAN
  2. www/p5-Catalyst-Enzyme
for Run
  1. lang/p5-JSAN
  2. www/p5-Catalyst-Enzyme

Configuration Options

USES:

Master Sites:
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/modules/by-module/Class/
  2. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/Class/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module/Class/
  5. ftp://ftp.kddlabs.co.jp/lang/perl/CPAN/modules/by-module/Class/
  6. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/modules/by-module/Class/
  7. http://backpan.perl.org/modules/by-module/Class/
  8. http://ftp.twaren.net/Unix/Lang/CPAN/modules/by-module/Class/
  9. http://www.cpan.dk/modules/by-module/Class/
  10. https://cpan.metacpan.org/modules/by-module/
  11. https://cpan.metacpan.org/modules/by-module/Class/
  12. https://ftp.jaist.ac.jp/pub/CPAN/modules/by-module/Class/
  13. https://www.cpan.org/modules/by-module/Class/

Number of commits found: 32

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
09 Jul 2018 08:40:18
Original commit files touched by this commit  0.11_2
Revision:474242  Sanity Test Failure
mat search for other commits by this committer
Remove all := from BUILD_DEPENDS, here are never needed.

While there, cleanup, and sort depends.

When build and run dependencies are the same, there are three ways to
avoid duplicating the list while not adding the framework added
BUILD_DEPENDS to the RUN_DEPENDS.  In order of preference, they are:

1) use RUN_DEPENDS to set BUILD_DEPENDS:

BUILD_DEPENDS=	${RUN_DEPENDS}
RUN_DEPENDS=	foo:bar/baz

2) create another variable and use it:

MY_DEPENDS= foo:bar/baz
BUILD_DEPENDS=	${MY_DEPENDS}
RUN_DEPENDS=	${MY_DEPENDS}

3) use BUILD_DEPENDS to set RUN_DEPENDS and force evaluation:

BUILD_DEPENDS=	foo:bar/baz
RUN_DEPENDS:=	${BUILD_DEPENDS}

Sponsored by:	Absolight
27 May 2018 20:15:20
Original commit files touched by this commit  0.11_2
Revision:470993
sunpoet search for other commits by this committer
Update WWW

search.cpan.org is shutting down.
It will redirect to metacpan.org after June 25, 2018.

With hat:	perl
01 Apr 2016 14:00:57
Original commit files touched by this commit  0.11_2
Revision:412346
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
12 Mar 2015 23:00:03
Original commit files touched by this commit  0.11_2
Revision:381151
adamw search for other commits by this committer
Some OCD cleanups on some of the perl@ ports.

- Remove dependencies in core
- Put testing depends in TEST_DEPENDS
- Remove unnecessary bsd.port.options.mk inclusions
- Remove checks for Perl versions that no longer exist in the ports tree
- Sort plists, some of which were so jumbled that I have to assume
  the plist was randomized before committing

A lot of the plist changes in this commit are moving PERL5_MAN3 after
SITE_PERL. It's repo churn now, but it makes updating the ports later
far easier.
26 Nov 2014 13:08:38
Original commit files touched by this commit  0.11_2
Revision:373448
mat search for other commits by this committer
Change the way Perl modules are installed, update the default Perl to 5.18.

Before, we had:

  site_perl :           lib/perl5/site_perl/5.18
  site_perl/perl_arch : lib/perl5/site_perl/5.18/mach
  perl_man3 :           lib/perl5/5.18/man/man3

Now we have:

  site_perl : lib/perl5/site_perl
  site_arch : lib/perl5/site_perl/mach/5.18
  perl_man3 : lib/perl5/site_perl/man/man3

Modules without any .so will be installed at the same place regardless of the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
20 Oct 2014 10:41:13
Original commit files touched by this commit  0.11_1
Revision:371255
bapt search for other commits by this committer
Cleanup plist
03 Jul 2014 21:48:44
Original commit files touched by this commit  0.11_1
Revision:360463  Sanity Test Failure
adamw search for other commits by this committer
Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations.
03 Nov 2013 06:53:55
Original commit files touched by this commit  0.11_1
Revision:332592
vanilla search for other commits by this committer
Support STAGEDIR.
22 Oct 2013 16:57:45
Original commit files touched by this commit  0.11_1
Revision:331301
mat search for other commits by this committer
Try and be consistent with what commands are silent and not in *install.

- MKDIR is silent
- ECHO is silent
- INSTALL_* are not silent
- CP/FIND/... are not silent

I fixed a few PORTDOCS misusage, I'll do a second pass.

With Hat:	perl@
22 Sep 2013 18:05:05
Original commit files touched by this commit  0.11_1
Revision:327888
bapt search for other commits by this committer
Fix NO_STAGE attribution
20 Sep 2013 16:13:49
Original commit files touched by this commit  0.11_1
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)
02 Aug 2013 18:52:11
Original commit files touched by this commit  0.11_1
Revision:324174
mat search for other commits by this committer
- Convert to new perl framework
- Trim Makefile header
- Remove MAKE_JOBS_SAFE=yes, it's the default.
10 Jun 2012 18:42:48
Original commit files touched by this commit  0.11_1

swills search for other commits by this committer
- Convert all remaining instances of BUILD_DEPENDS=${RUN_DEPENDS} or
  RUN_DEPENDS=${BUILD_DEPENDS} to use := which portlint has warned
  about for a while.

PR:             ports/168208
Approved by:    portmgr (miwi)
03 Jun 2012 18:57:30
Original commit files touched by this commit  0.11_1

crees search for other commits by this committer
SITE_PERL --> package dependencies, chunks 2-3

Submitted by:   az
20 Mar 2011 12:54:45
Original commit files touched by this commit  0.11_1

miwi search for other commits by this committer
- Get Rid MD5 support
24 Sep 2010 02:03:44
Original commit files touched by this commit  0.11_1

pgollucci search for other commits by this committer
- only 13% of the p5- ports embed @comment $FreeBSD$:
  so standarize and remove it

With Hat:   perl@
21 Dec 2009 14:08:55
Original commit files touched by this commit  0.11_1

kuriyama search for other commits by this committer
- Remove dependency which is included in perl-5.8.
16 Aug 2009 09:55:32
Original commit files touched by this commit  0.11

linimon search for other commits by this committer
Reset mat@FreeBSD.org due to maintainer-timeouts and no response to email.

Hat:            portmgr
31 Aug 2007 13:37:23
Original commit files touched by this commit  0.11

mat search for other commits by this committer
Use the CPAN site macro.
Use DISTVERSION in place of DISTNAME where possible.
Remove perl 5.005 shims.
22 Jan 2006 01:29:10
Original commit files touched by this commit  0.11

edwin search for other commits by this committer
Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

Approved by:    krion@
PR:             ports/88711 (related)
15 Nov 2005 11:05:53
Original commit files touched by this commit  0.11

mat search for other commits by this committer
Update to 0.11
19 Sep 2005 10:22:19
Original commit files touched by this commit  0.10

fjoe search for other commits by this committer
Fix typo in IGNORE message: "Intall" -> "Install"
29 Aug 2005 15:48:13
Original commit files touched by this commit  0.10

mat search for other commits by this committer
Update to 0.10
20 Apr 2005 13:43:18
Original commit files touched by this commit  0.09

mat search for other commits by this committer
Update to 0.09
Require perl 5.6
18 Mar 2005 16:18:01
Original commit files touched by this commit  0.08

mat search for other commits by this committer
Update to 0.08
28 Jan 2005 12:52:35
Original commit files touched by this commit  0.07

mat search for other commits by this committer
Update to 0.07
Add docs
19 Oct 2004 13:32:05
Original commit files touched by this commit  0.06

mat search for other commits by this committer
Update to 0.06
19 Mar 2004 13:12:36
Original commit files touched by this commit  0.04

mat search for other commits by this committer
Update to 0.04
06 Feb 2004 13:28:10
Original commit files touched by this commit  0.03

mat search for other commits by this committer
Update to 0.03
29 Jan 2004 13:37:55
Original commit files touched by this commit  0.02

mat search for other commits by this committer
Add SIZE field
16 Aug 2003 09:13:44
Original commit files touched by this commit  0.02

mat search for other commits by this committer
Update my ports to use my @FreeBSD.org address

Approved by:    demon (mentor)
22 Jul 2003 14:40:11
Original commit files touched by this commit  0.02

krion search for other commits by this committer
New port databases/p5-Class-DBI-SQLite

Class::DBI::SQLite is an extension to Class::DBI for
DBD::SQLite, which allows you to populate auto incremented row
id after insert.

PR:             54749
Submitted by:   Mathieu Arnold <m@absolight.net>
Approved by:    fjoe (mentor)

Number of commits found: 32

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
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
giteaJan 18
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

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

* - modified, not new

All vulnerabilities

Last updated:
2020-01-20 11:08:01


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38452
Broken 687
Deprecated 693
Ignore 961
Forbidden 3
Restricted 152
No CDROM 72
Vulnerable 26
Expired 2
Set to expire 665
Interactive 0
new 24 hours 7
new 48 hours8
new 7 days48
new fortnight87
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.