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-CPAN-SQLite Search CPAN using a SQLite database
0.199_2 devel 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.199Version of this port present on the latest quarterly branch.
Maintainer: eg@fbsd.lt search for ports maintained by this maintainer
Port Added: 2007-04-25 07:51:32
Last Update: 2018-10-06 14:06:45
SVN Revision: 481365
Also Listed In: perl5
License: ART10 GPLv1+
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (28 items)
  1. /usr/local/share/licenses/p5-CPAN-SQLite-0.199_2/catalog.mk
  2. /usr/local/share/licenses/p5-CPAN-SQLite-0.199_2/LICENSE
  3. /usr/local/share/licenses/p5-CPAN-SQLite-0.199_2/ART10
  4. /usr/local/share/licenses/p5-CPAN-SQLite-0.199_2/GPLv1+
  5. bin/cpandb
  6. lib/perl5/site_perl/CPAN/SQLite.pm
  7. lib/perl5/site_perl/CPAN/SQLite/DBI.pm
  8. lib/perl5/site_perl/CPAN/SQLite/DBI/Index.pm
  9. lib/perl5/site_perl/CPAN/SQLite/DBI/Search.pm
  10. lib/perl5/site_perl/CPAN/SQLite/Index.pm
  11. lib/perl5/site_perl/CPAN/SQLite/Info.pm
  12. lib/perl5/site_perl/CPAN/SQLite/META.pm
  13. lib/perl5/site_perl/CPAN/SQLite/Populate.pm
  14. lib/perl5/site_perl/CPAN/SQLite/Search.pm
  15. lib/perl5/site_perl/CPAN/SQLite/State.pm
  16. lib/perl5/site_perl/CPAN/SQLite/Util.pm
  17. lib/perl5/site_perl/man/man1/cpandb.1.gz
  18. lib/perl5/site_perl/man/man3/CPAN::SQLite.3.gz
  19. lib/perl5/site_perl/man/man3/CPAN::SQLite::DBI.3.gz
  20. lib/perl5/site_perl/man/man3/CPAN::SQLite::DBI::Index.3.gz
  21. lib/perl5/site_perl/man/man3/CPAN::SQLite::DBI::Search.3.gz
  22. lib/perl5/site_perl/man/man3/CPAN::SQLite::Index.3.gz
  23. lib/perl5/site_perl/man/man3/CPAN::SQLite::Info.3.gz
  24. lib/perl5/site_perl/man/man3/CPAN::SQLite::META.3.gz
  25. lib/perl5/site_perl/man/man3/CPAN::SQLite::Populate.3.gz
  26. lib/perl5/site_perl/man/man3/CPAN::SQLite::Search.3.gz
  27. lib/perl5/site_perl/man/man3/CPAN::SQLite::State.3.gz
  28. lib/perl5/site_perl/man/man3/CPAN::SQLite::Util.3.gz
Collapse this list.
Dependency lines:
  • p5-CPAN-SQLite>0:devel/p5-CPAN-SQLite
To install the port: cd /usr/ports/devel/p5-CPAN-SQLite/ && make install clean
To add the package: pkg install p5-CPAN-SQLite
PKGNAME: p5-CPAN-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-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  2. p5-File-HomeDir>=0 : devel/p5-File-HomeDir
  3. p5-CPAN-DistnameInfo>=0 : devel/p5-CPAN-DistnameInfo
  4. p5-libwww>=0 : www/p5-libwww
  5. p5-PathTools>=0 : devel/p5-PathTools
  6. perl5>=5.26<5.27 : lang/perl5.26
  7. perl5>=5.26<5.27 : lang/perl5.26
Runtime dependencies:
  1. p5-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  2. p5-File-HomeDir>=0 : devel/p5-File-HomeDir
  3. p5-CPAN-DistnameInfo>=0 : devel/p5-CPAN-DistnameInfo
  4. p5-libwww>=0 : www/p5-libwww
  5. p5-PathTools>=0 : devel/p5-PathTools
  6. perl5>=5.26<5.27 : lang/perl5.26
There are no ports dependent upon this port

Configuration Options

USES:

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

Number of commits found: 25

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
06 Oct 2018 13:06:45
Original commit files touched by this commit  0.199_2
Revision:481365
des search for other commits by this committer
Fix every instance of RUN_DEPENDS:=${BUILD_DEPENDS} in p5 ports, except
for where it resulted in a change in output from build-depends-list or
run-depends-list.

Approved by:	portmgr (adamw)
27 May 2018 20:15:20
Original commit files touched by this commit  0.199_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
08 Oct 2017 07:58:40
Original commit files touched by this commit  0.199_2
Revision:451495
sunpoet search for other commits by this committer
Remove nonexistent LICENSE_FILE

Notified by:	antoine
Approved by:	portmgr (blanket)
15 Sep 2017 08:58:50
Original commit files touched by this commit  0.199_2
Revision:449893
mat search for other commits by this committer
Fix license information for portgs that use "the same license as Perl".

Sponsored by:	Absolight
30 Jun 2017 13:43:58
Original commit files touched by this commit  0.199_2
Revision:444737
sunpoet search for other commits by this committer
Remove Perl core modules

- While I'm here:
  - Add LICENSE
  - Add NO_ARCH
  - Sort PLIST
- Bump PORTREVISION for dependency change

With hat:	perl
01 Apr 2016 14:00:57
Original commit files touched by this commit  0.199_1
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
14 Sep 2015 12:19:50
Original commit files touched by this commit  0.199_1
Revision:396892
mat search for other commits by this committer
Make it so that the default Perl is always called perl5.

- Move Perl's man1 files along with its man3 files.
- Move where Perl installs its modules man1 pages.
- Convert the ports installing man1 pages.
- Make different Perl versions installable at the same time.
  Though you should note that only the default version can be used to
  install Perl modules, and the non default Perl versions cannot use the
  modules installed via ports if they contain .so as they are installed
  in a version specific directory.

Reviewed by:	bapt (the Mk bits)
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D3542
02 Mar 2015 23:21:08
Original commit files touched by this commit  0.199_1
Revision:380304
bapt search for other commits by this committer
Remove Author from pkg-descr and white space fixes
26 Nov 2014 13:08:38
Original commit files touched by this commit  0.199_1
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)
27 Oct 2014 10:55:59
Original commit files touched by this commit  0.199
Revision:371547
bapt search for other commits by this committer
Cleanup plist
05 Feb 2014 14:37:25
Original commit files touched by this commit  0.199
Revision:342714
ehaupt search for other commits by this committer
Support staging.
20 Sep 2013 17:13:47
Original commit files touched by this commit  0.199
Revision:327724
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
devel part 3)
09 Sep 2013 08:21:32
Original commit files touched by this commit  0.199
Revision:326784
az search for other commits by this committer
- convert to the new perl5 framework
- trim Makefile header

Approved by:	portmgr (bapt@, blanket)
30 Jun 2012 14:07:27
Original commit files touched by this commit  0.199

az search for other commits by this committer
- Remove SITE_PERL from *_DEPENDS

Approved by: portmgr@ (bapt@)
21 Jan 2012 17:40:15
Original commit files touched by this commit  0.199

eadler search for other commits by this committer
At the moment 1385 ports use BUILD_DEPENDS= ${RUN_DEPENDS} and 450
ports use BUILD_DEPENDS:= ${RUN_DEPENDS}. This patch fixes ports that are
currently broken. This is a temporary measure until we organically stop using
:= or someone(s) spend a lot of time changing all the ports over.

Explicit duplication > := > = and this just moves ports one step to the left

Approved by:    portmgr
17 Sep 2011 06:49:29
Original commit files touched by this commit  0.199

sunpoet search for other commits by this committer
- Change PERL_CONFIGURE to "yes" for all values less than or equal to 5.8.0+

With hat:       perl
20 Jun 2011 08:36:20
Original commit files touched by this commit  0.199

az search for other commits by this committer
- Replace ../../authors in MASTER_SITE_SUBDIR with CPAN:CPANID macro.
  See http://wiki.freebsd.org/Perl for details.
- Change maintainership from ports@ to perl@ for ports in this changeset.
- Remove MD5 checksum
22 Aug 2010 19:05:29
Original commit files touched by this commit  0.199

pgollucci search for other commits by this committer
- Update to 1.99
- Set PKGNAMEPREFIX

PR:             ports/147364
Submitted by:   pgollucci (myself)
Reviewed by:    az
Approved by:    Edmondas Girkantas <eg@fbsd.lt> (maintainer)
23 Sep 2009 14:01:59
Original commit files touched by this commit  0.198

miwi search for other commits by this committer
- Update to 0.198

PR:             139026
Submitted by:   Edmondas Girkantas <eg@fbsd.lt> (maintainer)
Feature safe:   yes
02 Aug 2009 21:12:19
Original commit files touched by this commit  0.197

linimon search for other commits by this committer
Over to new volunteer.
02 Aug 2009 07:10:42
Original commit files touched by this commit  0.197

linimon search for other commits by this committer
Reset maintainer per his request in private email.

Hat:            portmgr
05 Apr 2009 10:46:09
Original commit files touched by this commit  0.197

dhn search for other commits by this committer
- Update to 0.197

PR:             ports/132941
Submitted by:   Edmondas Girkantas <eg@fbsd.lt>
Approved by:    maintainer timeout (two weeks), miwi (mentor)
16 Feb 2008 23:52:27
Original commit files touched by this commit  0.19

miwi search for other commits by this committer
- Update to 0.19

PR:             120394
Submitted by:   Felippe de Meirelles Motta <lippemail@gmail.com>
Approved by:    maintainer
08 Sep 2007 00:56:04
Original commit files touched by this commit  0.1

linimon search for other commits by this committer
Welcome bsd.perl.mk.  Add support for constructs such as USE_PERL5=5.8.0+.
Drop support for antique perl.

Work done by:   gabor
Sponsored by:   Google Summer of Code 2007
Hat:            portmgr
25 Apr 2007 07:50:30
Original commit files touched by this commit  0.1

clsung search for other commits by this committer
Add p5-CPAN-SQLite 0.1, search CPAN using a SQLite database.

PR:             ports/107723
Submitted by:   Christopher Boumenot <boumenot at gmail.com>

Number of commits found: 25

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
weechatFeb 21
webkit2-gtk3Feb 19
dovecotFeb 13
gitlab-ceFeb 13
grub2-bhyveFeb 12
libexifFeb 11
linux-flashplayerFeb 11
nginxFeb 09
nginx-develFeb 09
ksh93Feb 07
ksh93-develFeb 07
clamavFeb 05
py-django111Feb 04
py-django22Feb 04
py-django30Feb 04

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

* - modified, not new

All vulnerabilities

Last updated:
2020-02-23 08:59:33


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38437
Broken 645
Deprecated 418
Ignore 916
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 23
Expired 4
Set to expire 390
Interactive 0
new 24 hours 2
new 48 hours12
new 7 days24
new fortnight52
new month313

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