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
sqlite-ext-spellfix Search large vocabulary for close matches for SQLite
3.8.11.1_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 3.8.11.1Version of this port present on the latest quarterly branch.
Maintainer: yuri@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-05-06 14:59:45
Last Update: 2019-11-17 09:39:56
SVN Revision: 517810
License: PD
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (4 items)
  1. libexec/sqlite-ext/libspellfix.so
  2. /usr/local/share/licenses/sqlite-ext-spellfix-3.8.11.1_1/catalog.mk
  3. /usr/local/share/licenses/sqlite-ext-spellfix-3.8.11.1_1/LICENSE
  4. /usr/local/share/licenses/sqlite-ext-spellfix-3.8.11.1_1/PD
Collapse this list.
Dependency lines:
  • sqlite-ext-spellfix>0:databases/sqlite-ext-spellfix
To install the port: cd /usr/ports/databases/sqlite-ext-spellfix/ && make install clean
To add the package: pkg install sqlite-ext-spellfix
PKGNAME: sqlite-ext-spellfix
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.
Library dependencies:
  1. libsqlite3.so : databases/sqlite3
There are no ports dependent upon this port

Configuration Options

USES:

pkg-message:
If installing:
Master Sites:
  1. http://www2.sqlite.org/2015/
  2. http://www3.sqlite.org/2015/
  3. https://www.sqlite.org/2015/

Number of commits found: 5

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
17 Nov 2019 09:39:56
Original commit files touched by this commit  3.8.11.1_1
Revision:517810
amdmi3 search for other commits by this committer
- Simplify LICENSE
- Switch to USES=localbase (and fix PREFIX vs. LOCALBASE misuse)
- Unsilence build and installation
- User proper command for library installation
- Respect LDFLAGS
- Update WWW

Approved by:	portmgr blanket
13 Aug 2019 16:01:59
Original commit files touched by this commit  3.8.11.1_1
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
10 Jun 2018 04:41:38
Original commit files touched by this commit  3.8.11.1_1
Revision:472112
yuri search for other commits by this committer
databases/sqlite-ext-spellfix: Remove USE_LDCONFIG

SQLite extensions are loaded with the full path to the shared library.
25 Feb 2018 00:40:37
Original commit files touched by this commit  3.8.11.1
Revision:462887
yuri search for other commits by this committer
Replaced my old rawbw.com maintainer's address with yuri@FreeBSD.org

98 ports are affected.

Approved by:	tcberner (mentor, implicit)
06 May 2016 14:59:36
Original commit files touched by this commit  3.8.11.1
Revision:414708
pi search for other commits by this committer
New port: databases/sqlite-ext-spellfix

This module implements the spellfix1 VIRTUAL TABLE that can be used
to search a large vocabulary for close matches using Levenshtein distance.

Virtual table:

  spellfix1

Functions:

  editdist, editdist3, spellfix1_translit, spellfix1_phonehash,
  spellfix1_scriptcode

WWW: http://www.sqlite.org/spellfix1.html

PR:		203217
Submitted by:	Yuri <yuri@rawbw.com>

Number of commits found: 5

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
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
libsshFeb 02
mariadb-connector-cFeb 02

14 vulnerabilities affecting 178 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-02-14 01:16:43


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38478
Broken 681
Deprecated 243
Ignore 950
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 23
Expired 5
Set to expire 215
Interactive 0
new 24 hours 3
new 48 hours3
new 7 days27
new fortnight87
new month334

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