We've published the beta3 binaries for our 3.11.0 release. I think we're mostly good now for getting 3.11.0 out the door:

• [x] Get signing certificates for Windows (@MKleusberg)
  • Ideally we should have the signing be an automatic part of our nightly build process
  • Certificate has arrived (2019-01-23).
  • Now we just need to figure out how to sign stuff. The Certum smart card reader + bits seem super picky and flaky, and also seem to be windows only. :slightly_frowning_face:
• [x] Double check the status of all languages
  • All languages will need updating again, as new SQLCipher dialog text was added today.
  • The SQLCipher dialog is needed, as that lets us use SQLCipher 4.0.1 which avoids the new Magellan bug.
• [x] Update the strings in the v3.11.x branch again, for the new SQLCipher dialog.
  • Done. 66172ace8e7e19a1f3209c96bb67e7ac99c67f31
• [ ] The new SQLCipher dialog needs translating for all languages.
  • [ ] sqlb_ar_SA.ts
  • [ ] sqlb_cs.ts
  • [x] sqlb_de.ts
  • [x] sqlb_es_ES.ts
  • [ ] sqlb_fr.ts
  • [x] sqlb_it.ts
  • [ ] sqlb_ko_KR.ts
  • [ ] sqlb_pl.ts
  • [x] sqlb_pt_BR.ts
  • [ ] sqlb_ru.ts
  • [ ] sqlb_tr.ts
  • [ ] sqlb_uk_UA.ts
  • [ ] sqlb_zh.ts
  • [ ] sqlb_zh_TW.ts
• [x] Compile the math extension for macOS
  • Done. 7fbd89a59fc07160dca07146448649341f8addbf
• [x] For the Windows installer, should we update the final dialog (which .exe to launch SQLite vs SQLCipher) for the release?
  • Updated enough. We don't really require the dialog offering to launch DB4S, so we'll skip it instead. :smile:
• [x] Use SQLCipher 4.0.1.
  • The SQLCipher 4.x dialog change has been cherry-picked across to the v3.11.x branch
• [x] Fix DBHub.io bug #116, so the DB4S <-> DBHub.io integration works.
  • Without this, people can't update their existing remote databases without renaming them on each save. :frowning:
  • The problem turned out to be the server giving a bad url in a request response, which subsequent requests tried to make use of and then hit problems. It's been fixed server side, but existing databases that have been uploaded via DB4S will probably still need renaming (once) when uploading, so an upload succeeds + they get new (correct) metadata to use for subsequent requests.
• [x] DB4S bug https://github.com/sqlitebrowser/sqlitebrowser/issues/1708 sounds like it could be important to fix first
  • Fixed by @MKleusberg in 03d39bb139ce67da82ac5568f073f58afb9db7d6

Details for the issue

Upon startup, an error message is displayed: The network is not accessible. DB Browser then works correctly.

What did you do?

Installed DB Browser for SQLite-win64.msi The same problem arose with yesterday's (and maybe the day before).

What did you expect to see?

What did you see instead?

Useful extra information

DB4S v3.11.99 (Oct 28 2018) on Windows 10 (10.0) (winnt/10.0.17134) [x86_64] using SQLite Version 3.25.2 and Qt 5.10.1

Details for the issue

• An attempt to open the installed DB Browser for SQLite v.3.9.1 in the Windows XP (32 bit) environment returns error "DB Browser for SQLite.exe is not a valid Win32 application"

Useful extra information

Since the original topic #893 "was locked and limited conversation to collaborators on 27 Feb", but there are still noob users like me and #986 around, that just wish to adopt DB Browser for SQLite 3.9.1 to their beloved Win32 XP machines, hereby I will provide you with easy to understand "entry-level" solutions to this issue.

@h1618

if you are able to operate a hexeditor, just changing offset 0x40 and 0x44 of the sqlitebrowser.exe executable from 0x0006 (Vista) to 0x0005 (XP) is all that's needed

• Unfortunately I couldn't figure out how to perform or calculate location for those manipulations, so this link to the image file with the screenshot of hex-code comparison between unpatched (left) and patched (right) files should give you an idea of what exactly is it there to be changed and where it is located within a hex editor: http://www.hadrurus.com/andiutils/DB4S/SQLite3.9.1HexPatch.jpg

or

@karim

A quick solution is by editing the .exe file using editbin and change the subsystem right after building it.

• I didn't want to seek and install all of Microsoft Visual Studio, so for this method you should go to: http://www.hadrurus.com/andiutils/DB4S/EditBinPack.rar and download:

1. EditBinPack.rar

Then extract all files contained in EditBinPack.rar archive to the folder with the installed DB Browser for SQLite (in Windows XP usually at C:\Program Files\DB Browser for SQLite) on your PC. Now [Start] > [Run] > {type} CMD > [OK] > {type} CD\ {Enter} > {type} CD PROGRAM FILES\DB BROWSER FOR SQLITE {Enter} and finally {type}:

EDITBIN DBBROW~1.EXE /SUBSYSTEM:WINDOWS,5.01 /OSVERSION:5.1 {Enter}

After that manipulation is done, check your "DB Browser for SQLite.exe" for runnability, and if all is OK, you're set to use program as usual.

At last, just like me, enjoy latest DB Browser for SQLite v.3.9.1 on your Windows XP!

P.S. I could provide here a link to the patched file itself, and this way it would be even easier to just substitute one file with another, but I am not sure whether I am allowed to do so here.

I'm opening this issue because:

• [x] DB4S is crashing
• [ ] DB4S has a bug
• [ ] DB4S needs a feature
• [x] DB4S has another problem

I'm using DB4S on:

• [x] Windows: (XP Prof SP3 version: 5.1)
• [ ] Linux: ( distro: ___ )
• [ ] Mac OS: ( version: ___ )
• [ ] Other: ___

I'm using DB4S version:

• [x] 3.9.1
• [ ] 3.9.0
• [ ] Other: ___

I have also:

• [x] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
• [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

We are in the process of releasing our next stable version (3.12.0) of 'DB Browser for SQLite' with many new features and corrections.

Once again we kindly ask our users to help us in making DB4S better by translating it to their languages or updating the translation of the last release (when available).

The *.ts files are already updated on the master branch, and we are not going to modify the strings unless needed to include some correction.

You can read brief indications here about how to do it. I'll be happy to assist you in the process, in case you had any doubt.

I'll ping here all the translators who have helped us in the past, so they get a notification. Please, report back if you want to help again. When there are more than one volunteers, they can share out the work and/or review each other translations. Happy translation!

lang | complete | translators -- | -- | -- ar_SA |

Source string changes after translation started:

• 1d1afaad218dfea9d9cdcf83821b3c5b33963ebb
• https://github.com/sqlitebrowser/sqlitebrowser/commit/fe88463cbad5476ca6555759eb70dee430d89f63#diff-1c0b64226a129d35f02dc0049484cd6b
• https://github.com/sqlitebrowser/sqlitebrowser/commit/498efd7a5c0ceb43ebcf1233bee4609a201f0e40#diff-8b5b29ce11f2efcd1c93eb6cdf67ce89
• 39047109a65e325c1a2135a85a372efaa315316d
• https://github.com/sqlitebrowser/sqlitebrowser/commit/498efd7a5c0ceb43ebcf1233bee4609a201f0e40#diff-8b5b29ce11f2efcd1c93eb6cdf67ce89
• https://github.com/sqlitebrowser/sqlitebrowser/commit/29db270e809980d3a36ee6c30fd30bd12a5a5cd7

When we're near the final release build, we should check this list of "source string changes ..." in case some languages need those done.

Details for the issue

What did you do?

I Tried to Create a Table into a writable database (not readable, all i did is create a database, tried to create a table using the browser and a error which isn't supposed to throw), but it doesn't work

What did you expect to see?

The Table Created without any issues!

What did you see instead?

Useful extra information

The database isn't read only, but i get the error read only for some reason, however temporary table works and anything else, but not creating table, i even tried creating a table in Execute SQL Section but still gives same error:

attempt to write a readonly database: CREATE TABLE `FWGR` (
	`Field1GER`	INTEGER,
	`REG`	INTEGER
);

(this was a testing one btw, so i can see if it gives error in any other databases) and as i said, the database isn't Read Only (i tried reinstalling DB4S too, but no luck on reinstalling, still same stuff!) Also the issue seems to occurred since yesterday i tried it, the last couple of months or something, create table worked perfectly fine, when yeah, this started now! and as i said, temporary table and anything else such as inserting works!

What operating system are you using?

• [x] Windows: ( version: 10 Pro)
• [ ] Linux: ( distro: ___ )
• [ ] Mac OS: ( version: ___ )
• [ ] Other: ___

What is your DB4S version?

• [x] 3.11.0-alpha1 or 3.11.0-beta*
• [x] 3.10.1
• [x] Other: Latest Nightly Version

Did you also

• [x] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
• [x] Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

I can't seem to figure out how to open an encrypted sqlite database? If this is not currently possible, I think it would be an appropriate enhancement.

Thanks!

Dark theme in OSX breaks look&feel.

White text boxes also have white text in them, making the app basically unusable.

Details for the issue

What did you do?

Installed & ran app for first time

What did you expect to see?

The screenshot on https://sqlitebrowser.org/

What did you see instead?

Useful extra information

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

• [ ] Windows: ( version: ___ )
• [ ] Linux: ( distro: ___ )
• [x] Mac OS: ( _version: 10.14.3)
• [ ] Other: ___

What is your DB4S version?

• [x] 3.11.1
• [ ] 3.11.0
• [ ] 3.10.1
• [ ] Other: ___

Did you also

• [x] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
• [x] Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

Details for the issue

When running SQLiteBrowser (now renamed to DB Browser for SQLite) on macOS Sierra beta, because the app is unsigned, it can not find its preferences file and as such, the colors in the data browser tab are all black, meaning black text on black background. Even if you change them, while they will work for that session, closing and reopening the app resets all of your settings.

My suspicion is this has to do with the new way macOS Sierra handles unsigned applications. It stores them in a 'random, secure' portion on disk, not simply the application folder even though it looks like that's where it is. This is part of their new security. My guess is this is the cause of the app not being able to find the preferences.

That said, even if the preference file isn't found, the defaults should not be black on black. At least set them to black on white, possibly making nulls gray on white.

All of the above is also pure speculation and I could be completely wrong, but I am not seeing this behavior on earlier versions of OS X, including El Capitan, only macOS Sierra.

Useful extra information

I'm opening this issue because:

• [ ] DB4S is crashing
• [x] DB4S has a bug
• [ ] DB4S needs a feature
• [ ] DB4S has another problem

I'm using DB4S on:

• [ ] Windows
• [ ] Linux: ( distro: ___ )
• [x] Mac OS
• [ ] Other: ___

I'm using DB4S version:

• [x] 3.9.0 beta1
• [x] 3.8.0
• [ ] Other: ___

I have also:

• [ ] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
• [ ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

Some background info here, skip over to get to the problem.

-------Before yelling at me, please understand the new 3.x versions of sql arent compatible with my mac version 10.6.8 for some reason. I have no programming experience, but i have used this program before to edit some integers for an iphone app a few years ago, however it isnt working now, even with the same app, the same software, and the same .db file.

Here is why i am confused as to why i cant use the updated 3.0 https://github.com/sqlitebrowser/sqlitebrowser "OSX 10.6 (Snow Leopard) - 10.10 (Yosemite) are tested and known to work" yet it doesnt.--------

end BG info

So, i have a file "Cashe.db" that has integers in it that i want to modify, that should be in a table. So i >file>openDatabase>Cashe.db and nothing shows up. it's blank. on the top bar it says as follows "SQLite Database Browser - /Users/me/Desktop/Cashe/db". I assume this means that the file is open, but not loaded, perhaps due to an encryption? I tried using other .db editors but they dont get me to the table due to one reason or another, again, because of the possible encryption.

• [x] #1756 - Enable 'Edit Database Cell' when view is editable
• [x] #1758 - DB browser crashes when I try to attach additional database to current one
• [x] #1764 - CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction
• [x] #1772 - Cell edit window considers binary data to be text/numeric if first byte is in ascii range
• [x] #1774 - Crashes when browsing a empty view with view editing enabled
• [x] #1777 - Trying to save after successfull import fails
• [x] #1799 - Attach encrypted database results in Out of Memory Error
• [x] #1814 - File is not a database
• [x] #1829 - Can't remove password from an encrypted database any more
• [x] 1a59c8cbda47684dfc0b55283fc6fdb396adc832 - grammar: Fix keywords as table name and keywords as column name
• [x] Include SQLite 3.27.2 instead of SQLite 3.27.1
• [x] Include SQLCipher 4.1.0 instead of 4.0.1
• [x] Updated translation strings
  • #1600 - Korean
  • #1830 - Brazilian Portuguese
  • #1833 - Italian
  • e2ad5459d569801f9a635391f774e81ca1009e85 - German

Hello all, I am having a 16 column,150 million row 27 gb csv dataset.Its very raw(unclean) and it has to be cleaned before performing any analytics on it. To clean,pandas is not facilitating me(memory error)So i went to SQL server but there its a whole other shebang(transaction log outgrowth etc.) i have finally come to sqllite.i have downloaded the sqllite,sqllite studio and db browser for sqllit.I need to clean the data(many update and delete statements) and then keep the data ready for integration with powerbi.after struggling for almost 50-single handed man hours on trying to clean this, i am on the verge of giving up.But if anyone here could tell me that sqllite can handle it or if there are any specific ways/tricks for sqllite to handle such big datasets.pls tell me

my ultimate aim is to: 1.clean this 2.integrate to powerbi

pls help thanks

What did you do?

Added an extension via preferences > extensions

Seems like same issue as #1290

What did you expect to see?

Extension loads successfully

What did you see instead?

Error loading extension: dlopen(my_extension.dylib.dylib, 10): image not found)

DB4S Version

3.12.2

What OS are you seeing the problem on?

MacOS

OS version

Big Sur 11.6.1

Relevant log output

No response

Prevention against duplicate issues

• [X] I have searched for similar issues

Describe the new feature

I just detected that you can activate 'Show images in cell' in Preferences/Data Browser which works great. (issue #2000). My main issue is that the image in the cell is not scaled to the width of the column automatically . Changing the column width should adapt the image in the cell and also the row height if 'Adjust rows to content' is active. Maybe if 'Adjust rows to content' is not active then the image should fit into the current column width and row height (even if the created thumbnail would be quite small it would be better than just displaying a small part of the image). There could be an additional switch in the preferences to handle this feature.

Does this feature exist in another product or project? Please provide a link

No response

Do you have a screenshot? Please add screenshots to help explain your idea.

No response

Describe the new feature

Hello, I have a SQLite db with multiple tables and each one of them has his own function to insert data into it. I want to create a new table which get all those table into one table to export it all as Excel file. Is there any way to sample all columns from tables into one big table? I have tried to use INSERT OR REPLACE, but it did not work for me. thanks

Does this feature exist in another product or project? Please provide a link

No response

Do you have a screenshot? Please add screenshots to help explain your idea.

No response

Details for the issue

What did you do?

I connected the SQLite file on my java project but why can it not find it? It said "No suitable driver found on jdvc.slite".

What did you expect to see?

I expect it to connect easily.

What did you see instead?

error

Useful extra information

DB4S v3.12.2 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.22621) [x86_64] using SQLite Version 3.35.5 and Qt 5.12.8

What did you do?

I created a simple database with an integer primary key and a few text columns, one of them not nullable. The primary key values are manually generated, so records can be entered out of order.

Then I entered a new record with key 1 in the table like a spreadsheet and saved it. Then I entered a new record with key 0 as above and saved it.

Next I sorted the 2 rows by clicking on the primary key column header.

The attached zip file contains the database files:

ColumnContentErased.zip

What did you expect to see?

I expect to see that there are 2 records in the database with values as entered.

What did you see instead?

For an unknown reason, in browse mode, content of all columns except the integer primary key is erased for a new record. With erased I mean that nullable columns are null, and other columns that are not nullable contain empty strings.

This appears to happen on insert of new rows.

It does not become visible immediately but after sorting of the view.

I could not believe this at first because I have other databases on the same computer that work fine. So I checked the file system. The file system looks sound. I did a check disk and I made a full backup which ran without errors.

I tried it again with a new database. Same problem. I can work around the problem as follows:

I enter a new record with the primary key only and save it. Then I re-order it and back into the natural order. Which means that I have to search for my new record in the table which is easy because it is basically blank.

Then I update that record which avoids the data loss.

I suspect that the software is confused by the fact that I enter the rows out of primary key order, and that because of it, due to its initial default ordering, it loses my data entry even while I save the record. Still the data is shown because the GUI is stale at that point. But when I re-order the rows then I see that the data was not actually saved, only the primary key.

DB4S Version

3.12.2

What OS are you seeing the problem on?

Windows

OS version

Windows 7

Relevant log output

I do not know how to get any log output at all because I have never seen a console or log file.

Prevention against duplicate issues

• [X] I have searched for similar issues