CVS commit: pkgsrc/databases/sqlitebrowser

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Jul 25 06:47:24 UTC 2024

Modified Files:
        pkgsrc/databases/sqlitebrowser: Makefile PLIST distinfo

Log Message:
sqlitebrowser: updated to 3.13.0

3.13.0

Added
- **General**
  - Update to SQLite version 3.46.0
  - Integration with [dbhub.io](https://dbhub.io)
  - macOS ARM version
  - Sign Windows builds with [SignPath.io](https://SignPath.io)

- **Appearance and GUI Enhancements**
  - Add .NET DateTime.Ticks to date display format
  - Add a refresh button to the Database Structure tab
  - Add an extra tab for editing check constraints to the Edit Table dialog
  - Add an extra tab for editing foreign keys to the Edit Table dialog
  - Add auto completion for math functions
  - Add Ctrl+Enter as shortcut for executing query
  - Add new menu item to import from CSV data in the system clipboard
  - Add new menu item to show the row counts of all tables
  - Allow users to export or import user-settings file in a GUI environment
  - Add file, line number and function to Error Log
  - Add GUID display format
  - Add iif SQL function to the list of known functions in Execute SQL tab
  - Add new option to freeze columns in the Browse Data tab
  - Allow multiple TableBrowser tabs in the Browse Data tab
  - Bar charts now display labels in x axis when NULL values present
  - Scale large images in ImageViewer to fit the viewport by default
  - Enable HiDPI on all platforms by default
  - Change tabbed table browisng to use docks instead
  - Change mouse cursor to the pointing hand when Ctrl+Shift are pressed
  - Change to 'Preference' expression for consistent
  - Data Browser: avoid showing BLOBs containing unprintable characters as text
  - Data Browser: export query results as JSON
  - Edit Database Cell: fixed potential for data loss and better feedback
  - Edit Table: alternating row colors in tables for better readability
  - Edit Table: Change the key icons from header to tooltips
  - Fix indentation - always use 4 spaces
  - Plot Dock: use more precision for small numbers and less for big numbers
  - Plot: fix selecting points to select corresponding line in table
  - Plot: show x and y values on a tooltip when hovering over the plot
  - Table Browser: "Clear Filters" button to clear the global filter
  - Table Browser: give hint of table sorted or filtered state in the toolbar
  - Table Browser: Support extended selections
  - Add copy column name to table viewer
  - Allow multiple -t/--table parameters on the command line
  - Open recent files in read-only mode using a different shortcut
  - Allow selecting fixed format for big integer numbers
  - Allow the user to change MaxRecentFiles
  - Always load settings for Browse Data tabs
  - Always raise new Data Browser tabs to the foreground

- **SQL Processing**
  - parser: Add support for IS (NOT) DISTINCT FROM expressions
  - Execute SQL: add Ctrl+Shift+T for "Open SQL file(s)"
  - Fall back to asking SQLite when parsing a table schema has failed
  - Update schema after attaching/detaching a database in an Execute SQL tab
  - Also update schema when clicking the Refresh button in Browse Data tab
  - Improvements for working in the SQL Execution area using keyboard
  - When modifying a view use DROP VIEW IF EXISTS instead of just DROP VIEW
  - Add basic support for new RETURNING keyword
  - Change WHERE clauses of queries to use column names instead of indexes
  - DB Schema: drag & drop SELECT queries
  - Export query results as JSON
  - Export SQL: fix quoting of BLOB values and non-printable strings
  - Export SQL: option to keep original CREATE statements
  - Improve support for BLOB columns as primary key
  - Use LIMIT + OFFSET when generating SELECT statements instead

- **Files**
  - Import: Add import-csv option to command line to import CSV files
  - Move recent files items to new submenu and add clear recent file function
  - CLI: Reuse `--table` as table name for a CSV Import
  - CSV Export: binary BLOB to base64
  - CSV Import: fix importing into existing table
  - CSV Import: give option to use system locale conventions
  - Import: allow CSV separator and quote to be passed from command line
  - Import: announce support for CSV files in Desktop file
  - Import: do not remove characters from CSV header fields
  - Import: don't assume an empty file is a text file
  - Import: support importing the single file argument as a CSV file

- **Configuration**
  - New setting for configuring brace matching background
  - New setting for having close button on tabs (default) or not
  - New settings for changing the selection appearance in editors
  - Add the ability to support custom config files

Changed

There have been too many changes since the last full release to list separately.
Important changes are listed in the **Added** section above.

Fixed

There have been too many bug fixes since the last full release to list separately.
Please check out 3.13.0 and let us know if your issue still exists

Removed

- _none_

Translation
- Add Dutch, Indonesian, Swedish translation
- Update Arabic, Brazilian Portuguese, Chinese, French, German, Italian, Japanese, Korean, Polish, Spanish translation


To generate a diff of this commit:
cvs rdiff -u -r1.68 -r1.69 pkgsrc/databases/sqlitebrowser/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/sqlitebrowser/PLIST
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/sqlitebrowser/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlitebrowser/Makefile
diff -u pkgsrc/databases/sqlitebrowser/Makefile:1.68 pkgsrc/databases/sqlitebrowser/Makefile:1.69
--- pkgsrc/databases/sqlitebrowser/Makefile:1.68        Wed May 29 16:31:54 2024
+++ pkgsrc/databases/sqlitebrowser/Makefile     Thu Jul 25 06:47:24 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.68 2024/05/29 16:31:54 adam Exp $
+# $NetBSD: Makefile,v 1.69 2024/07/25 06:47:24 adam Exp $
 
-DISTNAME=      sqlitebrowser-3.12.2
-PKGREVISION=   19
+DISTNAME=      sqlitebrowser-3.13.0
 CATEGORIES=    databases x11
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=sqlitebrowser/}
 GITHUB_TAG=    v${PKGVERSION_NOREV}
@@ -11,12 +10,11 @@ COMMENT=    Qt5 lightweight GUI editor/view
 HOMEPAGE=      https://sqlitebrowser.org/
 LICENSE=       mpl-2.0 OR gnu-gpl-v3
 
-USE_LANGUAGES= c c++
-USE_CMAKE=     yes
-
-USE_CXX_FEATURES+=     c++11
+USE_CXX_FEATURES=      c++14
+USE_LANGUAGES=         c c++
 
 .include "../../databases/sqlite3/buildlink3.mk"
+.include "../../devel/cmake/build.mk"
 .include "../../graphics/hicolor-icon-theme/buildlink3.mk"
 .include "../../sysutils/desktop-file-utils/desktopdb.mk"
 .include "../../x11/qt5-qtbase/buildlink3.mk"

Index: pkgsrc/databases/sqlitebrowser/PLIST
diff -u pkgsrc/databases/sqlitebrowser/PLIST:1.3 pkgsrc/databases/sqlitebrowser/PLIST:1.4
--- pkgsrc/databases/sqlitebrowser/PLIST:1.3    Mon Jul 20 19:11:46 2020
+++ pkgsrc/databases/sqlitebrowser/PLIST        Thu Jul 25 06:47:24 2024
@@ -1,5 +1,6 @@
-@comment $NetBSD: PLIST,v 1.3 2020/07/20 19:11:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2024/07/25 06:47:24 adam Exp $
 bin/sqlitebrowser
 share/applications/sqlitebrowser.desktop
 share/icons/hicolor/256x256/apps/sqlitebrowser.png
+share/icons/hicolor/scalable/apps/sqlitebrowser.svg
 share/metainfo/sqlitebrowser.desktop.appdata.xml

Index: pkgsrc/databases/sqlitebrowser/distinfo
diff -u pkgsrc/databases/sqlitebrowser/distinfo:1.15 pkgsrc/databases/sqlitebrowser/distinfo:1.16
--- pkgsrc/databases/sqlitebrowser/distinfo:1.15        Tue Oct 26 10:10:05 2021
+++ pkgsrc/databases/sqlitebrowser/distinfo     Thu Jul 25 06:47:24 2024
@@ -1,5 +1,6 @@
-$NetBSD: distinfo,v 1.15 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.16 2024/07/25 06:47:24 adam Exp $
 
-BLAKE2s (sqlitebrowser-3.12.2.tar.gz) = 5f6d06306f466691f9fc1e71f7593bf77be517efb20b2c51ae2215885b9d2dfb
-SHA512 (sqlitebrowser-3.12.2.tar.gz) = a6afc0a4286f07adb7038f3a010c93e14204b477bde27b1599c9bfe3390422d3edfaa2a9381b1f13e63a7aaf90e931ee85358eb8b2c15b6ea55818d29c59395f
-Size (sqlitebrowser-3.12.2.tar.gz) = 3990817 bytes
+BLAKE2s (sqlitebrowser-3.13.0.tar.gz) = b6a88926b2e59c1a33721e21206554554aa5921ad76b975f87ed8efb20926e5a
+SHA512 (sqlitebrowser-3.13.0.tar.gz) = 6261043cee7bc5c525b162e0b5d1ac38d380228ffd752e086fecb49c7f50b463a993a6128547d99addb0480ba71e4f6dd3a0c1e412a692ae86b0b183b7379610
+Size (sqlitebrowser-3.13.0.tar.gz) = 4901507 bytes
+SHA1 (patch-CMakeLists.txt) = a656b54c097493929e9dbc74eed57cd6963034d1