The NetBSD Project

CVS log for pkgsrc/databases/sqlitebrowser/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / sqlitebrowser

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.4: download - view: text, markup, annotated - select for diffs
Thu Jul 25 06:47:24 2024 UTC (2 years, 3 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base, pkgsrc-2026Q3, pkgsrc-2026Q2-base, pkgsrc-2026Q2, pkgsrc-2026Q1-base, pkgsrc-2026Q1, pkgsrc-2025Q4-base, pkgsrc-2025Q4, pkgsrc-2025Q3-base, pkgsrc-2025Q3, pkgsrc-2025Q2-base, pkgsrc-2025Q2, pkgsrc-2025Q1-base, pkgsrc-2025Q1, pkgsrc-2024Q4-base, pkgsrc-2024Q4, pkgsrc-2024Q3-base, pkgsrc-2024Q3, HEAD
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +2 -1 lines
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

Revision 1.3: download - view: text, markup, annotated - select for diffs
Mon Jul 20 19:11:46 2020 UTC (6 years, 3 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q2-base, pkgsrc-2024Q2, pkgsrc-2024Q1-base, pkgsrc-2024Q1, pkgsrc-2023Q4-base, pkgsrc-2023Q4, pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4, pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +2 -2 lines
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

Revision 1.2: download - view: text, markup, annotated - select for diffs
Sat Mar 5 07:45:21 2016 UTC (10 years, 8 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3, pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3, pkgsrc-2018Q2-base, pkgsrc-2018Q2, pkgsrc-2018Q1-base, pkgsrc-2018Q1, pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2, pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +3 -0 lines
Update to 3.8.0

* Change LICENSE since 3.1.0

Changelog:
* Support SQLite 3.9.2
* Support Qt5
* Many improvements and bugfixes

Revision 1.1.1.1 (vendor branch): download - view: text, markup, annotated - select for diffs
Sun May 25 08:04:44 2008 UTC (18 years, 5 months ago) by adam
Branches: TNF
CVS tags: pkgsrc-base, pkgsrc-2015Q4-base, pkgsrc-2015Q4, pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2, pkgsrc-2014Q1-base, pkgsrc-2014Q1, pkgsrc-2013Q4-base, pkgsrc-2013Q4, pkgsrc-2013Q3-base, pkgsrc-2013Q3, pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2013Q1-base, pkgsrc-2013Q1, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2012Q3-base, pkgsrc-2012Q3, pkgsrc-2012Q2-base, pkgsrc-2012Q2, pkgsrc-2012Q1-base, pkgsrc-2012Q1, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q3-base, pkgsrc-2011Q3, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2011Q1-base, pkgsrc-2011Q1, pkgsrc-2010Q4-base, pkgsrc-2010Q4, pkgsrc-2010Q3-base, pkgsrc-2010Q3, pkgsrc-2010Q2-base, pkgsrc-2010Q2, pkgsrc-2010Q1-base, pkgsrc-2010Q1, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2009Q3-base, pkgsrc-2009Q3, pkgsrc-2009Q2-base, pkgsrc-2009Q2, pkgsrc-2009Q1-base, pkgsrc-2009Q1, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper, cube-native-xorg-base, cube-native-xorg
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +0 -0 lines
SQLite Database Browser is a freeware, public domain, open source
visual tool used to create, design and edit database files compatible
with SQLite. It is meant to be used for users and developers that
want to create databases, edit and search data using a familiar
spreadsheet-like interface, without the need to learn complicated
SQL commands.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Sun May 25 08:04:44 2008 UTC (18 years, 5 months ago) by adam
Branches: MAIN
Initial revision

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>