./databases/sqlitebrowser, Qt5 lightweight GUI editor/viewer for SQLite Databases

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 3.13.1nb3, Package name: sqlitebrowser-3.13.1nb3, Maintainer: pkgsrc-users

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.


Required to run:
[graphics/hicolor-icon-theme] [x11/qt5-qttools] [x11/qt5-qtbase] [x11/qt5-qscintilla]

Required to build:
[pkgtools/x11-links] [x11/xcb-proto] [x11/xorgproto]

Master sites:

Filesize: 4807.707 KB

Version history: (Expand)


CVS history: (Expand)


   2024-11-14 23:22:33 by Thomas Klausner | Files touched by this commit (2429)
Log message:
*: recursive bump for icu 76 shlib major version bump
   2024-11-01 13:55:19 by Thomas Klausner | Files touched by this commit (2426)
Log message:
*: revbump for icu downgrade
   2024-11-01 01:54:33 by Thomas Klausner | Files touched by this commit (2427)
Log message:
*: recursive bump for icu 76.1 shlib bump
   2024-10-25 13:52:36 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
sqlitebrowser: updated to 3.13.1

DB Browser for SQLite v3.13.1

Added

Add links to the wiki as help for many dialogs (7af1256, b5abc86)

Changed

Change the default to install a shortcut to the Start menu when installing on \ 
Windows (623bec6)
Improve icon image for links in 'Help' menu
Pragma names and values can now be translated
Remove trailing characters when copying a single cell
Update AppImage binary to use the latest SQLCipher library
When editing the DB cells, expanded queries with parameters are included in the \ 
SQL Log (ac3209f)

Fixed

ExtendedTableWidget

Fix an issue that prevented autocomplete from working in some race conditions
Use Tab to close autocomplete popup and move to next item (3aff8c9)
Troubleshoot 'Copy as SQL' action on a cell results in string being copied

Global

Fix "Argument Missing" error in Korean translation
Fix an issue that caused apps to crash on some older versions of macOS
Fix an issue when freezing after stopping a pragma
Fix an issue with outputting the wrong version on macOS
Troubleshooting poor HiDPI support on Windows
Troubleshoot SQL queries containing VACUUM that run incorrectly

MainWindow

Fix an issue when selecting queries containing multi-byte strings

TableBrowser

Fix a bug where the first row was not adjusted

etc

Fix misleading links to Qt license information (8361aa5)
Replace 'http' with 'https' in the 'AboutDialog' and 'MainWindow' (9832a52)
Translation
German
Indonesian
Japanese
Korean (7bbfcf9)
Simplified Chinese
Spanish
   2024-07-30 05:32:36 by Adam Ciarcinski | Files touched by this commit (1)
Log message:
sqlitebrowser: add missing patch
   2024-07-25 08:47:24 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
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
   2024-05-29 18:35:19 by Adam Ciarcinski | Files touched by this commit (1929) | Package updated
Log message:
revbump after icu and protobuf updates
   2024-04-06 10:07:18 by Thomas Klausner | Files touched by this commit (1490)
Log message:
* recursive bump for libxkbcommon 1.7.0

Marc Baudoin reported problems with using old binary packages
with the new libkxbcommon, so force everything to 1.7.0