The current version of sqlitebrowser builds fine for Tumbleweed, but it fails to start at runtime with the following error:
QWidget: Must construct a QApplication before a QWidget
This request fixes that by updating sqlitebrowser to the latest master. We use 3.13.99 as version number as no official release since 3.13.1 (Oct 16, 2024) has been created by the developers.
We also fully switch to Qt6.
Created this request after https://build.opensuse.org/requests/1325665 was declined automatically with the reason that they expect "submission from devel package server:database/sqlitebrowser"
Please note, I have reverted all of the changes in the latest revision of the development package in server:database https://build.opensuse.org/package/show/server:database/sqlitebrowser?rev=48 and based my changes on the previous revision (which is in sync with Factory).
Accepting that request must have been a mistake as the package was completely messed up. Here is a quick overview of what was wrong from my pov:
- Obscure changes in spec file
* Standard copyright notice replaced with users e-mail
* Nonsensical changes to package description
* Hardcoded compiler specification in build section, prone to fail
* Test build activated by default
- Source code of dependencies (nlohmann-json, QHexEdit) copied into repository
- Source code of actual package deleted
- Completely wiped previous changelog
- Completely messed up the description text in sqlitebrowser.1 file
OBS-URL: https://build.opensuse.org/request/show/1325670
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlitebrowser?expand=0&rev=49
- update to version 3.10.1
* Bug fixes
- General
+ cipher: Fix passphrases containing single quotes
+ cipher: Change tab order in encryption dialog
+ Fix typo in Russian translation
+ Pass /norestart to vcredist installer
+ Fix index updating when removing an indexed column from a table
+ Don't automatically commit all changes when editing a table column
+ Make text selectable in Edit dock even if db is opened as read only
+ Add '<>NULL' filter
+ Fix custom type saving when only focus changes for user-entered type
- DBHub.io related
+ dbhub: Tweak certificate UI in the preferences dialog
+ dbhub: Fix progress dialog for very large files
+ dbhub: Remove closing "." from the progress dialog
+ dbhub: Ask user what to do when trying to open an updated database
+ dbhub: Enforce name and commit message length limits in push dialog
+ dbhub: Add tooltip to cog tool button
+ dbhub: Redownload database if local copy has been deleted
+ dbhub: Fix wrong file size being shown for very large files
+ dbhub: Support pushing to different branches than "master"
+ dbhub: Improve file size format
+ dbhub: Optimise code
+ dbhub: Fix branch list in push dialog
OBS-URL: https://build.opensuse.org/request/show/619760
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlitebrowser?expand=0&rev=33
- Correct license
- Use more cmake macros
- Use shared qscintilla library
- update to version 3.10.0
* Highlights
- DBHub.io integration
+ Uploading and downloading of databases works
+ Branching, forking, starring works, as does creating tags and releases
+ There's a 100MB per database limit at the moment though, as it's still in development
+ Backups aren't done on it (yet), so don't use it as your only place for storing important things (!!!)
+ The front page is... not great. We're working on it.
+ Still lots of upcoming stuff needing to be done. An API to query your databases, a cli, merging, discussions/issues
+ Please report bugs, ideas, suggestions (etc) on the dbhub.io repo issue tracker as you find them.
- Many plot improvements (NULL values, progress dialog, remember settings, better colours, and bug fixes)
- Better table editing (foreign key editor, toggling the WITHOUT ROWID flag, temporary tables, ...)
- Better Import CSV dialog. It can now handle multiple CSV files at once
- Improved Index dialog and better index handling in general
- Better handling of virtual tables
- Filter improvements (ranges, NULL search)
- The usual improvements to the grammar parser
* See the full list of changes under
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.10.0
- switch back to cmake build
- use system antlr on openSUSE, the problems seem to be fixed
- unconditionally build with Qt5, Qt4 support has been dropped in
this release
OBS-URL: https://build.opensuse.org/request/show/519688
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlitebrowser?expand=0&rev=9
+ CSV file import and export code has been extensively modified
for better RFC compatibility
+ support for custom collation sequences. This lets people use
SQLite3 databases copied from their Android phone or tablet.
+ several fixes in our SQL grammar parser
+ Make adding new rows less confusing by showing automatically
generated data by default values, triggers or the PK right after
the new row is added
+ Edit Table dialog: Add option for adding a unique constraint to columns
+ UI improvements: Show line numbers in the SQL log
+ Add a database schema pane (can be torn off)
+ Added a Russian translation, fixed German translation
+ new Project files feature, for saving metadata about your SQLite
Database files
+ New: Plotting, a quick and dirty way to draw graphs from your
table data
+ Bi-licensed under MPLv2 and GPLv3
- use cmake now instead of old qmake
- let make install the sqlitebrowser binary
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlitebrowser?expand=0&rev=7
