DB Browser for SQLite v3.13.1 #3775

justinclift · 2024-10-16T08:42:55Z

justinclift
Oct 16, 2024
Maintainer

This is a new release with several improvements over the v3.13.0 release from three months ago. 🚀

As a special mention, SQLean has a new time extension! Check out the following link for more information: https://github.com/nalgeon/sqlean/blob/main/docs/time.md

Thanks to everyone for being part of our Community!

Changelog

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 ([Bug]: Missing icons in the menu. #3693, 027c6a8)
Pragma names and values can now be translated (Marked QLabel and ComboBox texts as translatable in 'Edit Pragma' QTabWidget #3697, bf62f3a, ad00ad4)
Remove trailing characters when copying a single cell ([Bug]: Data copied from table cell contains extra end of line character #3735, 20f481a)
Update AppImage binary to use the latest SQLCipher library ([Bug]: CREATE TABLE with STRICT raises syntax error #3744, 21ba2d0)
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 (Message "The database is currently busy" displayed when opening file from project #2567, [Bug]: IntelliSense not working #3706)
- 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 (Cell editor doesn't treat INTEGER, NUMERIC inputs right for INSERT or UPDATE #1952, 1ebe7bf)
Global
- Fix "Argument Missing" error in Korean translation ([Bug]: When you start the program, an error message appears. #3635, [Bug]: Error on startup in some language settings #3692, cd518de)
- Fix an issue that caused apps to crash on some older versions of macOS (Unable to run v3.13.0 builds on macOS 10.13 - 'quit unexpectedly' error message displayed #3691)
- Fix an issue when freezing after stopping a pragma (Fix freeze/deadlock after aborted pragma #3742, 15a9620)
- Fix an issue with outputting the wrong version on macOS
- Troubleshooting poor HiDPI support on Windows ([Bug]: Tiny icons for UI elements in 3.13.0-rc1 on Windows #3684)
- Troubleshoot SQL queries containing VACUUM that run incorrectly ([Bug]: Erroneous execution of queries containing VACUUM #3723, 51784aa)
MainWindow
- Fix an issue when selecting queries containing multi-byte strings (Chinese and Japanese comment text affects the execution of SQL statements #3731, f89097c)
TableBrowser
- Fix a bug where the first row was not adjusted ([Bug]: Adjust rows to contents not affecting first row #3767, ad690e7)
etc
- Fix misleading links to Qt license information (8361aa5)
- Replace 'http' with 'https' in the 'AboutDialog' and 'MainWindow' (9832a52)
- Translation
  - German (Update German translation #3749, 8e38bf0)
  - Indonesian (Update Indonesian translation for v3.13.1 #3756, 6100595)
  - Japanese (Japanese Translation v3.13.1-rc2 #3755, e0f6aea)
  - Korean (7bbfcf9)
  - Simplified Chinese (sqlb_zh Translation v3.13.1-rc2 #3761, 9eb0a5a)
  - Spanish (ac33918)

Dependent library version information for each OS

-	Qt	SQLCipher	SQLite	SQLean
AppImage	5.15.13	4.5.6	3.46.1	Not applicable
macOS	5.15.13	4.6.1	Not applicable	0.27.1
Windows	5.15.2	4.6.1	3.46.1	0.27.1

SHA256SUMS

DB.Browser.for.SQLite-v3.13.1-win32.msi
- e0b9f86d3da4d8d800e144295487e43de306c1bd27f14dccfe41e904736f25f7
DB.Browser.for.SQLite-v3.13.1-win32.zip
- 917ad2fa8d36e3bfa3fc85b11a34a8c18d189fbc2289f5a0d3bf41de8a288edc
DB.Browser.for.SQLite-v3.13.1-win64.msi
- d023d54b3a5db10c7e896089bb3dbe6e7f4bc4eaa9bbecb34ca414be5970f688
DB.Browser.for.SQLite-v3.13.1-win64.zip
- 22375e275ec42d96de1d3b8e9ea4ed86d2a3505c4d0ffcbd1af67aa4003e5e4d
DB.Browser.for.SQLite-v3.13.1-x86.64.AppImage
- d6563c5c211a73192da96e3bb11a3bf83a2f3164aa4db83482c0aecf8b751b77
DB.Browser.for.SQLite-v3.13.1.dmg
- a641cfbfcc2ce609f07de44a35134dab53485ecc18e6d9afa297b514d74bd75e

This discussion was created from the release DB Browser for SQLite v3.13.1.

moppman · 2024-10-17T09:24:31Z

moppman
Oct 17, 2024

Just a heads-up: this release breaks AppImages on Debian Stable because 4d530dc drew in a libfuse2t64 dependency which is not avaiblable on Debian Stable.

I don't think this necessarily warrants a proper bug report because Debian users can just use the version from the official Debian repo.
Just thought I'd share here instead.

4 replies

justinclift Oct 17, 2024
Maintainer Author

Thanks for letting us know @moppman. That commit jumped the GitHub Actions builder from Ubuntu LTS 20.04 to 24.04.

We could probably check if Ubuntu LTS 22.04 (the one in between) would get things working again or not. If it does, we could make a 2nd version of the AppImage with that fix. 😄

FriedrichFroebel Oct 17, 2024
Maintainer

Adding on this, switching to Ubuntu 24.04 as the AppImage base has broken support for Ubuntu 22.04 as well:

me@localhost:~/Downloads$ ./DB.Browser.for.SQLite-v3.13.1-x86.64.AppImage 
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_DB.BrozwLGOh/AppRun.wrapped)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libm.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/AppRun.wrapped)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/AppRun.wrapped)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libm.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libsqlcipher.so.1)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libsqlcipher.so.1)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libQt5Network.so.5)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libQt5Gui.so.5)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libcrypto.so.3)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libgssapi_krb5.so.2)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libicui18n.so.74)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libm.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libicui18n.so.74)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libm.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libicuuc.so.74)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libicuuc.so.74)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libglib-2.0.so.0)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libkrb5.so.3)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libk5crypto.so.3)
/tmp/.mount_DB.BrozwLGOh/AppRun.wrapped: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /tmp/.mount_DB.BrozwLGOh/usr/bin/../lib/libkrb5support.so.0)

Ideally we would generate compatible builds until regular Ubuntu support ends, which is April 2025 for Ubuntu 20.04 for example: https://endoflife.date/ubuntu

lucydodo Oct 17, 2024
Maintainer

Hi, I'm the author of that commit. I apologize for the inconvenience, this side-effect is something I hadn't thought of.
I'll try to fix it by the end of the week and deploy the new AppImage: #3781

lucydodo Oct 18, 2024
Maintainer

Thank you for reporting this. We have released a new v2 version with this issue fixed: https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.13.1

Confirmed working on Ubuntu 20.04.6.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

DB Browser for SQLite v3.13.1 #3775

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 1 comment 4 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

DB Browser for SQLite v3.13.1 #3775

Uh oh!

Uh oh!

justinclift Oct 16, 2024 Maintainer

Changelog

Added

Changed

Fixed

Dependent library version information for each OS

SHA256SUMS

Replies: 1 comment · 4 replies

Uh oh!

moppman Oct 17, 2024

Uh oh!

justinclift Oct 17, 2024 Maintainer Author

Uh oh!

FriedrichFroebel Oct 17, 2024 Maintainer

Uh oh!

Uh oh!

lucydodo Oct 17, 2024 Maintainer

Uh oh!

lucydodo Oct 18, 2024 Maintainer

justinclift
Oct 16, 2024
Maintainer

Replies: 1 comment 4 replies

moppman
Oct 17, 2024

justinclift Oct 17, 2024
Maintainer Author

FriedrichFroebel Oct 17, 2024
Maintainer

lucydodo Oct 17, 2024
Maintainer

lucydodo Oct 18, 2024
Maintainer