DB Browser 4 SQLite

Our newest stable point release is online: sqlitebrowser.org/blog/version-3… No super critical updates unless you're using DBHub.io anonymously. It's mainly for updating some of the embedded certificates for DBHub.io, as the old ones expired. ;)

@fliedfood Just tried a download and it seems to be working OK for me... We've had no other reports, so hope it was either a temporary thing or resolved now. Are you sure you're connected to the Internet? ;)

@fliedfood Sorry - only just noticed this tweet. Do you still get the timeout? If you ping sqlitebrowser.org, do you get a response?

The website sqlitebrowser.org has moved hosts, so if you notice anything odd, please let us know. 👍

@kacos2000 > even DB Browser for SQLite is struggling The nightly version of DB4S has multi-thread support, so shouldn't lock up the UI as much.

No reported incidents is always a good thing when changing infrastructure. Love it when a plan comes together.

@thismumcancode Nearly a year on, and we hope your database skills have come on leaps and bounds! The beauty with database development is that pretty much every language can talk to a database, and nearly every application uses a database.

#100daysofcode Day2: Started to find my way around DB4S and went over database terminology. The whole data side of Software Development is still pretty new to me so starting from the very basic again.

@j_la28 This tweet is quite old now, but just for future reference, always try the latest nightly version. Both Qt and SQLite get updated frequently, so it could be something to do with those versions on your system?

@sqlitebrowser dbbrowser is crashing on my students running Big Sur on Mac. Any fix?

@synthesize_d Sorting through the .. bad data .. is fun! 👍

🙏 #SQLite #DBBrowser #CoVresearch

@Fon462 @KevinPagano3 They'll be an update that updates that so the update can update.

@KevinPagano3 I always setup window machines to never automatically update.

Note to self, save your SQLite queries when working on them, just lost one after the laptop restarted because of updates :/

@KevinPagano3 @forensicmike1 Have added 'keep stuff forever like Notepad++' to the suggestion list. :)

@forensicmike1 Yeah I have a bunch of untitled stuff there too haha, was only working in DB Browser so didn’t get saved

@KevinPagano3 @forensicmike1 :(

@mouse22_jp Did you try opening the CSV file? That won't work... You need to import /into/ a database, so create a new database first, and import into that. :)

@mouse22_jp You can even do pivot tables in SQLite. antonz.org/sqlite-pivot-t…

@mouse22_jp Good luck!

@mouse22_jp This becomes powerful when you have a weird column you want to sort by. Imagine you have fruits 'apple', 'oranges' and 'bananas' but you want to sort by 'orange', 'banana' then 'apple'. You can't do alphabetically or on the first letter. However, you can create a new column.

@mouse22_jp The _ character matches one character, while the % matches zero or more characters. This is similar to the Windows command-prompt, when you want to show all text files - 'dir *.txt' .. or in Linux, you'd use 'ls *.txt' Here they use the * instead of %, but it's the same practice

@mouse22_jp SQLite has only recently supported RIGHT JOINs and FULL OUTER, I believe. Here's a handy guide of the other joins.

@mouse22_jp This also works for text fields