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
sqlitebrowser Visual tool to manage SQLite databases
3.11.2_2 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 3.11.2Version of this port present on the latest quarterly branch.
Maintainer: lbartoletti@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2015-01-05 18:21:52
Last Update: 2020-04-11 06:04:41
SVN Revision: 531396

People watching this port, also watch: python, unoconv, py36-pycparser, sysinfo

License: MPL20 GPLv3
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (9 items)
  1. @desktop-file-utils
  2. /usr/local/share/licenses/sqlitebrowser-3.11.2_2/catalog.mk
  3. /usr/local/share/licenses/sqlitebrowser-3.11.2_2/LICENSE
  4. /usr/local/share/licenses/sqlitebrowser-3.11.2_2/MPL20
  5. /usr/local/share/licenses/sqlitebrowser-3.11.2_2/GPLv3
  6. bin/sqlitebrowser
  7. share/appdata/sqlitebrowser.desktop.appdata.xml
  8. share/applications/sqlitebrowser.desktop
  9. share/icons/hicolor/256x256/apps/sqlitebrowser.png
Collapse this list.
Dependency lines:
  • sqlitebrowser>0:databases/sqlitebrowser
To install the port: cd /usr/ports/databases/sqlitebrowser/ && make install clean
To add the package: pkg install sqlitebrowser
PKGNAME: sqlitebrowser
Flavors: there is no flavor information for this port.
distinfo:
Packages:
sqlitebrowser
ABIlatestquarterly
FreeBSD:11:aarch643.10.1_23.11.2_1
FreeBSD:11:amd643.11.2_23.11.2_1
FreeBSD:11:i3863.11.2_23.11.2_1
FreeBSD:12:aarch643.10.1_23.11.2_1
FreeBSD:12:amd643.11.2_23.11.2_1
FreeBSD:12:i3863.11.2_23.11.2_1
FreeBSD:13:aarch643.11.2_2-
FreeBSD:13:amd643.11.2_2-
FreeBSD:13:i3863.11.2_2-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. libantlr.a : devel/antlr
  2. cmake : devel/cmake
  3. ninja : devel/ninja
  4. update-desktop-database : devel/desktop-file-utils
  5. gtk-update-icon-cache : graphics/gtk-update-icon-cache
  6. moc : devel/qt5-buildtools
  7. lrelease : devel/qt5-linguisttools
  8. qmake : devel/qt5-qmake
Runtime dependencies:
  1. update-desktop-database : devel/desktop-file-utils
  2. gtk-update-icon-cache : graphics/gtk-update-icon-cache
Library dependencies:
  1. libqscintilla2_qt5.so : devel/qscintilla2-qt5
  2. libatk-1.0.so : accessibility/atk
  3. libgdk_pixbuf-2.0.so : graphics/gdk-pixbuf2
  4. libglib-2.0.so : devel/glib20
  5. libintl.so : devel/gettext-runtime
  6. libpango-1.0.so : x11-toolkits/pango
  7. libsqlite3.so : databases/sqlite3
  8. libQt5Concurrent.so : devel/qt5-concurrent
  9. libQt5Core.so : devel/qt5-core
  10. libQt5Gui.so : x11-toolkits/qt5-gui
  11. libQt5Network.so : net/qt5-network
  12. libQt5PrintSupport.so : print/qt5-printsupport
  13. libQt5Test.so : devel/qt5-testlib
  14. libQt5Widgets.so : x11-toolkits/qt5-widgets
  15. libQt5Xml.so : textproc/qt5-xml
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://codeload.github.com/sqlitebrowser/sqlitebrowser/tar.gz/v3.11.2?dummy=/
Port Moves

Number of commits found: 25

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
11 Apr 2020 05:04:41
Original commit files touched by this commit  3.11.2_2
Revision:531396
lbartoletti search for other commits by this committer
Update py-sip to 4.19.21 and qscintilla2 to 2.11.4

  - Update py-sip to 4.19.21
  - Update qscintilla2 to 2.11.4
  - Replace MASTER_SITE_RIVERBANK with https versions
  - Replace QSCI2_DISTNAME to match with the new one

PR:		245308
Approved by:	tcberner (mentor)
Exp-run by:	antoine
14 Jan 2020 21:45:15
Original commit files touched by this commit  3.11.2_1
Revision:523070
lbartoletti search for other commits by this committer
Change my mail address to lbartoletti@FreeBSD.org

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D23169
26 Jul 2019 20:46:57
Original commit files touched by this commit  3.11.2_1
Revision:507372
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
09 May 2019 14:57:55
Original commit files touched by this commit  3.11.2
Revision:501104
swills search for other commits by this committer
databases/sqlitebrowser: update to 3.11.2

PR:		237789
Submitted by:	lbartoletti <lbartoletti@tuxfamily.org> (maintainer)
08 Mar 2019 21:59:00
Original commit files touched by this commit  3.11.1
Revision:495080
swills search for other commits by this committer
databases/sqlitebrowser: update to 3.11.1

PR:		236146
Submitted by:	lbartoletti <lbartoletti@tuxfamily.org> (maintainer)
16 Jan 2019 11:13:45
Original commit files touched by this commit  3.10.1_3
Revision:490472
tijl search for other commits by this committer
Fix Qt5 symbol version scripts to put the catch-all clause first.  When
a symbol matches multiple clauses the last one takes precedence.  If the
catch-all is last it captures everything.  In the case of Qt5 libraries
this caused all symbols to have a Qt_5 label while some should have
Qt_5_PRIVATE_API.  This only affects lld because GNU ld always gives the
catch-all lowest priority.

Older versions of Qt5Webengine exported some memory allocation symbols from
the bundled Chromium.  Version 5.9 stopped exporting these [1] but the
symbols were kept as weak wrappers for the standard allocation functions to
maintain binary compatibility. [2][3]  The problem is that the call to the
standard function in these weak wrappers is only resolved to the standard
function if there's a call to this standard function in other parts of
Qt5Webengine, because only then is there a non-weak symbol that takes
precedence over the weak one.  If there's no such non-weak symbol the call
(Only the first 15 lines of the commit message are shown above View all of this commit message)
23 Dec 2018 17:07:47
Original commit files touched by this commit  3.10.1_2
Revision:488226
linimon search for other commits by this committer
This port needs USES=compiler:c++11-lang and #include <strings.h> in
src/grammar/Sqlite3Lexer.hpp to build on GCC-based architectures.

While here, add USES=gnome.

PR:		234206
Submitted by:	Piotr Kubaj
Approved by:	maintainer
28 Jun 2018 17:39:55
Original commit files touched by this commit  3.10.1_2
Revision:473503
tcberner search for other commits by this committer
Replace bsd.qt.mk by Uses/qt.mk and Uses/qt-dist.mk

From now on, ports that depend on Qt4 will have to set
	USES=		qt:4
	USE_QT=		foo bar
ports depending on Qt5 will use
	USES=		qt:5
	USE_QT=		foo bar

PR:		229225
Exp-run by:	antoine
Reviewed by:	mat
Approved by:	portmgr (antoine)
Differential Revision:	-https://reviews.freebsd.org/D15540
29 Apr 2018 16:19:44
Original commit files touched by this commit  3.10.1_2
Revision:468632
tcberner search for other commits by this committer
Update the QScintilla2 ports to 2.10.4
06 Apr 2018 12:09:21
Original commit files touched by this commit  3.10.1_1
Revision:466639
adridg search for other commits by this committer
The find module for QScintilla included with sqlitebrowser has never worked
(well) on FreeBSD. Then the port used en embedded copy of QScintilla.
Switch to using the system QScintilla.

This change is triggered by CMake 3.11, which tried to build the embedded
QScintilla slightly differently. That fails because there are header
files declaring enum { SCI_CANREDO = 2016 } *and also* header files
that #define SCI_CANREDO 2016; the include order is very fragile.

Also reported upstream.

Reviewed by:	lbartoletti_tuxfamily (maintainer)
Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D14930
08 Feb 2018 20:27:29
Original commit files touched by this commit  3.10.1
Revision:461266
dbaio search for other commits by this committer
databases/sqlitebrowser: Update to 3.10.1

Changes:	https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.10.1

PR:		225711
Submitted by:	lbartoletti@tuxfamily.org (maintainer)
21 Aug 2017 20:22:25
Original commit files touched by this commit  3.10.0
Revision:448488
swills search for other commits by this committer
databases/sqlitebrowser: update to 3.10.0; remove sqlitebrowser-qt5

Since QT4 is dropped, sqlitebrowser-qt5 is now sqlitebrowser.

PR:		221699
Submitted by:	lbartoletti <lbartoletti@tuxfamily.org> (maintainer)
04 Oct 2016 19:35:08
Original commit files touched by this commit  3.9.1
Revision:423292
madpilot search for other commits by this committer
Update sqlitebrowser to 3.9.1

PR:		213174
Submitted by:	lbartoletti at tuxfamily.org (maintainer)
01 Oct 2016 01:05:15
Original commit files touched by this commit  3.9.0
Revision:423030
rm search for other commits by this committer
databases/sqlitebrowser: update to 3.9.0

- update to 3.9.0
- update maintainer's email
- pet portlint

PR:		212395
Submitted by:	 lbartoletti <lbartoletti@tuxfamily.org> (maintainer)
13 Sep 2016 20:06:28
Original commit files touched by this commit  3.8.0_1
Revision:422073
tcberner search for other commits by this committer
Add new port databases/sqlitebrowser-qt5 as slaveport of databases/sqlitebrowser

Add a new port databases/sqlitebrowser-qt5 as slaveport of the existing
databases/sqlitebrowser.

PR:             211217
Reviewed by:    mat
Approved by:    rakuco (mentor)
Differential Revision:  https://reviews.freebsd.org/D7253
08 Jun 2016 05:37:39
Original commit files touched by this commit  3.8.0
Revision:416531
pi search for other commits by this committer
databases/sqlitebrowser: remove wrongly used PLIST_SUB from pkg-plist

PR:		210116
Submitted by:	Tobias C.Berner <tcberner@gmail.com>
25 Apr 2016 16:13:39
Original commit files touched by this commit  3.8.0
Revision:414014
mat search for other commits by this committer
Remove USE_SQLITE from bsd.databases.mk, replaced by USES=sqlite.

While there replace USE_SQLITE=x by USES=sqlite:x.

PR:		208971
Submitted by:	mat
Exp-run by:	antoine
With hat:	portmgr
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D5951
04 Mar 2016 16:11:45
Original commit files touched by this commit  3.8.0
Revision:410131
rakuco search for other commits by this committer
Update to 3.8.0.

PR:		207499
Submitted by:	coder@tuxfamily.org (maintainer)
21 Nov 2015 03:35:01
Original commit files touched by this commit  3.7.0
Revision:402132
pi search for other commits by this committer
databases/sqlitebrowser: 3.6.0 -> 3.7.0

Changes:
  https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.7.0

PR:		204300
Submitted by:	yuri@rawbw.com
Approved by:	coder@tuxfamily.org (maintainer)
12 Aug 2015 00:10:35
Original commit files touched by this commit  3.6.0_1
Revision:393992
pgollucci search for other commits by this committer
databases/sqlitebrowser: modernize, fix dependencies

- Replace USE_QT4=linguist_build with USE_QT4=linguisttools_build.
- Add missed corelib and network components into USE_QT4.
- Regenerate patches.
- Bump PORTREVISION

PR:                  201648
Submitted by:        s3erios@gmail.com
Approved by:         maintainer timeout (coder@tuxfamily.org ; 25 days)
11 May 2015 13:00:52
Original commit files touched by this commit  3.6.0
Revision:386078
culot search for other commits by this committer
- Update to 3.6.0

PR:		199795
Submitted by:	Jungleboogie0@gmail.com, coder@tuxfamily.org
Approved by:	coder@tuxfamily.org (maintainer)
Changes:	https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.6.0
06 May 2015 15:16:54
Original commit files touched by this commit  3.5.1
Revision:385521
mat search for other commits by this committer
Update ports in the [bcd]* categories to not use GH_COMMIT.

With minor cleanups to make things simpler.

With hat:	portmgr
Sponsored by:	Absolight
10 Feb 2015 21:15:51
Original commit files touched by this commit  3.5.1
Revision:378802
madpilot search for other commits by this committer
Update to 3.5.1.

PR:		197474
Submitted by:	coder@tuxfamily.org (maintainer)
06 Feb 2015 13:29:26
Original commit files touched by this commit  3.5.0
Revision:378535
madpilot search for other commits by this committer
Update to 3.5.0.

PR:		197253
Submitted by:	coder@tuxfamily.org (maintainer)
05 Jan 2015 18:21:39
Original commit files touched by this commit  3.4.0
Revision:376335
pi search for other commits by this committer
New port: databases/sqlitebrowser

DB Browser for SQLite is a light GUI editor for SQLite databases,
built on top of Qt. The main goal of the project is to allow
non-technical users to create, modify and edit SQLite databases
using a set of wizards and a spreadsheet-like interface.

This project has previous been known as "SQLite Browser" and "Database
Browser for SQLite". "DB Browser for SQLite" will hopefully be the
name that sticks. :)

WWW: http://sqlitebrowser.org/

PR:		196365
Submitted by:	coder@tuxfamily.org

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
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

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

* - modified, not new

All vulnerabilities

Last updated:
2020-05-25 19:05:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39457
Broken 80
Deprecated 625
Ignore 370
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 19
Set to expire 580
Interactive 0
new 24 hours 6
new 48 hours9
new 7 days42
new fortnight85
new month245

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