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
sqlitestudio SQLite database GUI manager
3.2.1.705 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.2.1Version of this port present on the latest quarterly branch.
Maintainer: yuri@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2015-11-21 08:31:08
Last Update: 2020-01-05 17:31:05
SVN Revision: 522164
License: GPLv3
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (28 items)
  1. /usr/local/share/licenses/sqlitestudio-3.2.1.705/catalog.mk
  2. /usr/local/share/licenses/sqlitestudio-3.2.1.705/LICENSE
  3. /usr/local/share/licenses/sqlitestudio-3.2.1.705/GPLv3
  4. bin/SQLiteStudio
  5. bin/sqlitestudio
  6. bin/sqlitestudiocli
  7. lib/libcoreSQLiteStudio.so
  8. lib/libcoreSQLiteStudio.so.1
  9. lib/libcoreSQLiteStudio.so.1.0
  10. lib/libcoreSQLiteStudio.so.1.0.0
  11. lib/libguiSQLiteStudio.so
  12. lib/libguiSQLiteStudio.so.1
  13. lib/libguiSQLiteStudio.so.1.0
  14. lib/libguiSQLiteStudio.so.1.0.0
  15. lib/sqlitestudio/libCsvImport.so
  16. lib/sqlitestudio/libCsvExport.so
  17. lib/sqlitestudio/libDbSqliteCipher.so
  18. lib/sqlitestudio/libHtmlExport.so
  19. lib/sqlitestudio/libJsonExport.so
  20. lib/sqlitestudio/libMultiEditorImage.so
  21. lib/sqlitestudio/libPdfExport.so
  22. lib/sqlitestudio/libPrinting.so
  23. lib/sqlitestudio/libRegExpImport.so
  24. lib/sqlitestudio/libSqlFormatterSimple.so
  25. lib/sqlitestudio/libSqlExport.so
  26. lib/sqlitestudio/libSqlEnterpriseFormatter.so
  27. lib/sqlitestudio/libXmlExport.so
  28. share/icons/hicolor/scalable/apps/SQLiteStudio.svg
Collapse this list.
Dependency lines:
  • sqlitestudio>0:databases/sqlitestudio
  • libcoreSQLiteStudio.so:databases/sqlitestudio
To install the port: cd /usr/ports/databases/sqlitestudio/ && make install clean
To add the package: pkg install sqlitestudio
PKGNAME: sqlitestudio
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. gmake : devel/gmake
  2. xorgproto>=0 : x11/xorgproto
  3. moc : devel/qt5-buildtools
  4. lrelease : devel/qt5-linguisttools
  5. qmake : devel/qt5-qmake
  6. libQt5UiTools.a : devel/qt5-uitools
Runtime dependencies:
  1. libqsqlite.so : databases/qt5-sqldrivers-sqlite3
  2. libQt5UiTools.a : devel/qt5-uitools
Library dependencies:
  1. libGL.so : graphics/mesa-libs
  2. libreadline.so.8 : devel/readline
  3. libsqlite3.so : databases/sqlite3
  4. libQt5Concurrent.so : devel/qt5-concurrent
  5. libQt5Core.so : devel/qt5-core
  6. libQt5Gui.so : x11-toolkits/qt5-gui
  7. libQt5Network.so : net/qt5-network
  8. libQt5PrintSupport.so : print/qt5-printsupport
  9. libQt5Script.so : devel/qt5-script
  10. libQt5Sql.so : databases/qt5-sql
  11. libQt5Svg.so : graphics/qt5-svg
  12. libQt5Widgets.so : x11-toolkits/qt5-widgets
  13. libQt5Xml.so : textproc/qt5-xml
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://codeload.github.com/pawelsalawa/sqlitestudio/tar.gz/3.2.1-705-gaf49fd61?dummy=/

Number of commits found: 27

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
05 Jan 2020 17:31:05
Original commit files touched by this commit  3.2.1.705
Revision:522164
yuri search for other commits by this committer
databases/sqlitestudio: Update 3.2.1 -> 3.2.1-705

The project moved to GitHub.
05 Jan 2020 10:26:04
Original commit files touched by this commit  3.2.1_8
Revision:522132
antoine search for other commits by this committer
Mark a few ports broken (unfetchable)
19 Aug 2019 20:32:18
Original commit files touched by this commit  3.2.1_8
Revision:509313
yuri search for other commits by this committer
databases/sqlitestudio: Fix symlink
19 Aug 2019 20:31:05
Original commit files touched by this commit  3.2.1_7
Revision:509312
yuri search for other commits by this committer
databases/sqlitestudio: add the lowercase link to the executable for convenience

Reported by:	John L. Males <jlmales@gmail.com> (user; via e-mail)
19 Aug 2019 20:14:00
Original commit files touched by this commit  3.2.1_6
Revision:509308
yuri search for other commits by this committer
databases/sqlitestudio: Add the .desktop file and the icon.

Caveat: the icon isn't displayed in xfce's Applications menu, see
https://bugzilla.xfce.org/show_bug.cgi?id=15855

Requested by:	John L. Males <jlmales@gmail.com> (user; reported/requested via
e-mail)
26 Jul 2019 20:46:57
Original commit files touched by this commit  3.2.1_5
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 Apr 2019 14:04:50
Original commit files touched by this commit  3.2.1_4
Revision:498476
sunpoet search for other commits by this committer
Update devel/readline to 8.0

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://tiswww.case.edu/php/chet/readline/CHANGES
PR:		236156
Exp-run by:	antoine
16 Jan 2019 11:13:45
Original commit files touched by this commit  3.2.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)
12 Dec 2018 01:35:36
Original commit files touched by this commit  3.2.1_2
Revision:487272
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

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, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
29 Jul 2018 22:18:46
Original commit files touched by this commit  3.2.1_1
Revision:475857
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
in the ports tree (via Mk/bsd.default-versions.mk and lang/gcc) which
has now moved from GCC 6 to GCC 7 by default.

This includes ports
 - featuring USE_GCC=yes or USE_GCC=any,
 - featuring USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and those
 - with USES=compiler specifying one of openmp, nestedfct, c11, c++0x,
   c++11-lib, c++11-lang, c++14-lang, c++17-lang, or gcc-c++11-lib.

PR:		222542
27 Jul 2018 23:30:22
Original commit files touched by this commit  3.2.1
Revision:475475
yuri search for other commits by this committer
databases/sqlitestudio: Update 3.2.0 -> 3.2.1

This is a bugfix release.

Changelog:
https://sqlitestudio.pl/index.rvt?act=changelog

Reported by:	portscout
26 Jul 2018 19:00:19
Original commit files touched by this commit  3.2.0
Revision:475394
yuri search for other commits by this committer
databases/sqlitestudio: Update 3.1.1 -> 3.2.0

Changelog:
https://sqlitestudio.pl/index.rvt?act=changelog

Port changes:
* Use DISTVERSION
* Update LICENSE_FILE
* Add options group
* Simplify option handling such that the plugins list is in only one place
* New plugin was added: MultiEditorImage
* Remove USE_LDCONFIG, not needed
28 Jun 2018 17:39:55
Original commit files touched by this commit  3.1.1_5
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
19 Feb 2018 16:20:43
Original commit files touched by this commit  3.1.1_5
Revision:462333
mat search for other commits by this committer
Don't abuse opt_VARS to add to USES.

Sponsored by:	Absolight
27 Nov 2017 17:14:43
Original commit files touched by this commit  3.1.1_5
Revision:454970
yuri search for other commits by this committer
databases/sqlitestudio: Unbroke the build by including QVariant where it was
missing

Approved by:	tcberner (mentor), mat
Differential Revision:	https://reviews.freebsd.org/D13203
10 Sep 2017 20:55:39
Original commit files touched by this commit  3.1.1_4
Revision:449591
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
(via Mk/bsd.default-versions.mk and lang/gcc) which has moved from
GCC 5.4 to GCC 6.4 under most circumstances.

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, c++11-lib, c++11-lang,
   c++14-lang, c++0x, c11, or gcc-c++11-lib.

PR:		219275
27 Jun 2017 13:46:53
Original commit files touched by this commit  3.1.1_3
Revision:444463
sunpoet search for other commits by this committer
Update devel/readline to 7.0 patch 3

- Bump PORTREVISION for shlib change

Changes:	https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES
		https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html
		https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html
Differential Revision:	https://reviews.freebsd.org/D11172
PR:		219947
Exp-run by:	antoine
23 May 2017 05:03:16
Original commit files touched by this commit  3.1.1_2
Revision:441503
rezny search for other commits by this committer
Revision bump of all ports with USE_GL after consolidation of mesa-libs

Approved by:	swills (mentor)
Differential Revision:	https://reviews.freebsd.org/D10845
01 Apr 2017 15:23:32
Original commit files touched by this commit  3.1.1_1
Revision:437439
gerald search for other commits by this committer
Bump PORTREVISIONs for ports depending on the canonical version of GCC and
lang/gcc which have moved from GCC 4.9.4 to GCC 5.4 (at least under some
circumstances such as versions of FreeBSD or platforms).

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using using Mk/bsd.octave.mk which in turn has USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c++11-lib, c++14-lang,
   c++11-lang, c++0x, c11, or gcc-c++11-lib.

PR:		216707
21 Dec 2016 06:20:20
Original commit files touched by this commit  3.1.1
Revision:429043
wen search for other commits by this committer
- Update to 3.1.1
- Update pkg-descr

PR:		214181
Submitted by:	yuri@rawbw.com(maintainer)
21 Jun 2016 23:33:22
Original commit files touched by this commit  3.1.0
Revision:417290
madpilot search for other commits by this committer
Update to 3.1.0

PR:		210427
Submitted by:	yuri@rawbw.com (maintainer)
25 Apr 2016 16:13:39
Original commit files touched by this commit  3.0.7
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
01 Apr 2016 14:00:57
Original commit files touched by this commit  3.0.7
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
08 Feb 2016 19:20:55
Original commit files touched by this commit  3.0.7
Revision:408505
marino search for other commits by this committer
databases/sqlitestudio: document ncurses requirement (USES+=ncurses)

Also link with ncurses, not curses.

approved by:	infrastructure blanket
21 Jan 2016 11:02:04
Original commit files touched by this commit  3.0.7
Revision:406847
rakuco search for other commits by this committer
Add a few patches to fix the build with the upcoming Qt 5.5.1.

Several places were using QDataStream without including the proper headers.
These fixes are not enough: the ports needs to explicitly depend on more Qt
components, but we are still working on that and may end up creating a new,
smaller port out of devel/qt5-designer.
08 Dec 2015 17:51:19
Original commit files touched by this commit  3.0.7
Revision:403322
miwi search for other commits by this committer
- Update to 3.0.7

PR:		204909
Submitted by:	maintainer
Approved by:	mat (mentor)
Differential Revision:	https://reviews.freebsd.org/D4344
21 Nov 2015 08:31:00
Original commit files touched by this commit  3.0.6
Revision:402142
pi search for other commits by this committer
New port: databases/sqlitestudio

SQLiteStudio is a SQLite database manager with the following features:
* Intuitive interface
* Powerful, yet light and fast
* Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON)
* Importing data from various formats (CSV, custom text files)
* Numerous small additions, like formatting code, history of queries executed
  in editor windows, on-the-fly syntax checking, and more
* Unicode support
* Configurable colors, fonts and shortcuts

WWW: http://sqlitestudio.pl/

PR:		204294
Submitted by:	yuri@rawbw.com

Number of commits found: 27

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.