CVS commit: pkgsrc/databases/sqlitebrowser

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Jul 20 19:11:46 UTC 2020

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

Log Message:
sqlitebrowser: updated to 3.12.0

v3.12.0

All Enhancements
Make use of the enhanced ALTER TABLE features in SQLite 3.25.0
Allow specifying an ON CONFLICT strategy in the Import CSV dialog
Add option to remember last location per action type when saving and loading
Add conditional formats to the Browse Data tab
Show current database action and add a cancel button in status bar
Save read-only state in the project file
Add support for filtering by regular expressions using the /regexp/ syntax
More efficient table editing. When editing the schema, do all changes in one go at the end
Add comment/uncomment feature to the SQL editor
Add option to find and replace in the selection in the SQL editor
Execute SQL statements in a different thread, allowing long-running queries to be cancelled
When editing a cell with a foreign-key, show a list of possible values in a dropdown list
Many small performance improvements
Lots of UI reworking, allowing more flexibility, adding new shortcuts, fixing glitches, and making it more responsive. Some of the new settings are stored in the project file while the handling of 
project files itself is improved too
New Save Project As menu item
Ask the user whether to save modified SQL tabs when closing, add a new button to save changes in all open tabs, prompt to save changes in the project when closing the database or the application
Allow custom display formats
Add new log to the SQL log dock which prints the SQLite error log
New setting allowing to set a dark style using a style-sheet
Add support for sorting by multiple columns in the Browse Data tab and add a button to clear sort orders
Add support for inserting rows into views with appropriate triggers
Enable build against external QCustomPlot
Improved text editor in the Edit Cell dock
New command-line argument for saving settings
Show some information about the selected data when selecting cells in the Browse Data tab
Detect changes in SQL files made by other programs
Add a full find dialog to all text editors
Add constraint editing to the Edit Table dialog
Include a built-in certificate which allows out-of-the-box read-only access to dbhub.io
Support all Unicode quote and escape characters in the Import CSV dialog
Add proxy support to dbhub.io functionality
Add "Browse Table" action to the context menu of the DB Structure dock
Remember read-only flag for recent files list
Extended regular expression support in the find dialogs
Add duplicate tab feature to Execute SQL area
Prompt user for options after dropping files
Allow changing the collation of columns in the Edit Table dialog
Add global filter field to Browse Data tab
Support inline preview of image data in cells
Add move field to top/bottom buttons to Edit Table dialog
Add a find and replace toolbars to the Browse Data tab
Add a toolbar for direct formatting of columns, rows, and single cells in the Browse Data tab
Support custom SQLCipher cipher_plaintext_header_size
Add support for parsing, browsing, and editing tables with GENERATED ALWAYS AS columns
Use the column type affinity for the default text alignment in the Browse Data tab
Resize columns according to contents
Allow opening of URLs or filenames from database cells and add a button to insert a link to the file into the cell
Allow editing of the contents of database cells in external applications
Add support for a secondary Y-axis to the plot area
Drop close buttons on every Execute SQL tab(x)
Show a useful icon in SQL tabs
Open SQL tabs for modifying views and triggers
Fix logo issues
Install the AppStream file to the canonical location
Open a set of SQL-Files
Consistent naming of DB Browser for SQLite
Minor: Change "Filter in all columns" => "Filter in any column"
Avoid unchanged translation of keyboard shortcuts to work around problems
Rearrange preferences database
Use port 443 for DBHub.io traffic, to be more enterprise firewall friendly
Application icon cleanup
Update to Windows Icon Generation script

All Bug fixes
Avoid setting the database dirty with some trailing whitespace and comments
Use native and localised names for shortcuts in the tool-tips
Add macOS .dylib extension to the extension selector dialog
Do not show more than 512 characters in DB Structure tooltips
Load all pending data when select all is requested
Make the Edit Cell Dock to update with the selected cell in SQL results
Fix selecting columns in Browse Data tab instead of sorting them
Fix detection of XML data, some types of text data, and large numbers in the Edit Cell dock
Fix default collations and callbacks when creating a new database
Lots of bug fixes in the SQL parser
Always set sort direction to ascending when sorting a different column
Fix problems with the JSON export
Fix problems after closing a database
Fix syntax highlighting to exactly match the SQLite keywords
Fix deleting from WITHOUT ROWID table
Fix editing data in WITHOUT ROWID tables with multiple primary key columns
Silence some unnecessary warning messages
Fix licence list in dbhub.io push dialog
Fix loading last used settings in the Import CSV dialog
Fix setting last modified date when cloning a dbhub.io database
Fix possible crash when loading a corrupt project file
Include transaction statements in the SQL log
Fixes for editing cells with RTL texts
When updating a field try to respect the affinity data type if possible
Fix value in size column of dbhub.io panel for very large databases
Fix plotting data with NULL values by leaving gaps in the graph
Fix importing CSV files with quote characters and no final line break and with only one column and no final line break
Escape filepath when attaching database
Fix foreign-key editor not working correctly in Edit Table dialog
Fix issues with resizing and with hiding a column
Fix editing in tables with custom display formats
Fix problems with greediness in the DB4S implementation of the SQLite REGEXP operator
Check if some column has a NOT NULL constraint in "Set to NULL"
Fix error indication and savepoint handling after failed statements
Make SQL editor in Edit Table dialog read-only
Fix some problems with view editing in Browse Data tab
Fix handling of databases with a view and a trigger with the same name
Never mark the DB dirty if it is read-only
Fix the recordset numbers in the Browse Data tab
Fix some typos and translation problems
Fix dotenv not working for databases encrypted using SQLCipher 3
Fix dotenv not working when not specifying the plaintext header size
Crash when -t option specifies missing table

Translations
Add Japanese translation
Update Russian translation
Update Chinese translation
Update Polish translation
Update Portuguese translation
Update French translation
Update Spanish translation
Update Turkish translation
Update Italian translation
Update German translation
Update Arabic translation
Update Simplified Chinese translation
Update German translation for v3.12.x
Updates the Brazilian Portuguese files for 3.12.0
Portuguese updates for 3.12
Update Japanese Translation for v3.12.x
Update zh translation


To generate a diff of this commit:
cvs rdiff -u -r1.39 -r1.40 pkgsrc/databases/sqlitebrowser/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/sqlitebrowser/PLIST
cvs rdiff -u -r1.10 -r1.11 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.39 pkgsrc/databases/sqlitebrowser/Makefile:1.40
--- pkgsrc/databases/sqlitebrowser/Makefile:1.39        Tue Jun  2 08:23:32 2020
+++ pkgsrc/databases/sqlitebrowser/Makefile     Mon Jul 20 19:11:46 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.39 2020/06/02 08:23:32 adam Exp $
+# $NetBSD: Makefile,v 1.40 2020/07/20 19:11:46 adam Exp $
 
-DISTNAME=      sqlitebrowser-3.11.2
-PKGREVISION=   7
+DISTNAME=      sqlitebrowser-3.12.0
 CATEGORIES=    databases x11
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=sqlitebrowser/}
 GITHUB_TAG=    v${PKGVERSION_NOREV}

Index: pkgsrc/databases/sqlitebrowser/PLIST
diff -u pkgsrc/databases/sqlitebrowser/PLIST:1.2 pkgsrc/databases/sqlitebrowser/PLIST:1.3
--- pkgsrc/databases/sqlitebrowser/PLIST:1.2    Sat Mar  5 07:45:21 2016
+++ pkgsrc/databases/sqlitebrowser/PLIST        Mon Jul 20 19:11:46 2020
@@ -1,5 +1,5 @@
-@comment $NetBSD: PLIST,v 1.2 2016/03/05 07:45:21 ryoon Exp $
+@comment $NetBSD: PLIST,v 1.3 2020/07/20 19:11:46 adam Exp $
 bin/sqlitebrowser
-share/appdata/sqlitebrowser.desktop.appdata.xml
 share/applications/sqlitebrowser.desktop
 share/icons/hicolor/256x256/apps/sqlitebrowser.png
+share/metainfo/sqlitebrowser.desktop.appdata.xml

Index: pkgsrc/databases/sqlitebrowser/distinfo
diff -u pkgsrc/databases/sqlitebrowser/distinfo:1.10 pkgsrc/databases/sqlitebrowser/distinfo:1.11
--- pkgsrc/databases/sqlitebrowser/distinfo:1.10        Sat Jan 11 12:41:01 2020
+++ pkgsrc/databases/sqlitebrowser/distinfo     Mon Jul 20 19:11:46 2020
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.10 2020/01/11 12:41:01 nros Exp $
+$NetBSD: distinfo,v 1.11 2020/07/20 19:11:46 adam Exp $
 
-SHA1 (sqlitebrowser-3.11.2.tar.gz) = 42003bc5c76e41f6eecc1ac1922f89c3ac46926b
-RMD160 (sqlitebrowser-3.11.2.tar.gz) = 11db118d89ea6c9dc672cb905daeb40270591acb
-SHA512 (sqlitebrowser-3.11.2.tar.gz) = 1b274baca4b059aff5ae879179cbdf9a9d8503ee963d4da8fd2b5fcbd9697bfe5e93f2e5fceb6f0e4ca04d853b10a410ad7e5d0efe8903d13dd6b2542f85eb5a
-Size (sqlitebrowser-3.11.2.tar.gz) = 2530497 bytes
+SHA1 (sqlitebrowser-3.12.0.tar.gz) = 8b0d16be14c77930a92d025c08e8ea4303feab4a
+RMD160 (sqlitebrowser-3.12.0.tar.gz) = 07b7b7bfc8389e8927ba2769c90742bf67bd87ba
+SHA512 (sqlitebrowser-3.12.0.tar.gz) = 4a8150dfb8721a9a8c31b140ee277722319b43da242ada2da22ecc0a6f1bd1e16eef6d1037a33652156094d9c372ccfa9a772c980d3afad9cc7124b4cada01e0
+Size (sqlitebrowser-3.12.0.tar.gz) = 4017370 bytes