DB Browser 4 SQLite

Open Source cross platform SQLite GUI (using Qt)

[DB Browser 4 SQLite @sqlitebrowser]

Our newest stable point release is online:
https://t.co/nwUn3D2zdT

No super critical updates unless you're using https://t.co/fDY4JsVoda anonymously. It's mainly for updating some of the embedded certificates for https://t.co/fDY4JsVoda, as the old ones expired. ;)

[DB Browser 4 SQLite @sqlitebrowser]

@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? ;)

[DB Browser 4 SQLite @sqlitebrowser]

The website https://t.co/zgJ57oBMOt has moved hosts, so if you notice anything odd, please let us know. 👍

[DB Browser 4 SQLite @sqlitebrowser]

@fliedfood Sorry - only just noticed this tweet.
Do you still get the timeout?
If you ping https://t.co/zgJ57oBMOt, do you get a response?

[DB Browser 4 SQLite @sqlitebrowser]

@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.

[DB Browser 4 SQLite @sqlitebrowser]

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

[DB Browser 4 SQLite @sqlitebrowser]

@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.

[DB Browser 4 SQLite @sqlitebrowser]

@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?

[DB Browser 4 SQLite @sqlitebrowser]

@clockwork353

[DB Browser 4 SQLite @sqlitebrowser]

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

[DB Browser 4 SQLite @sqlitebrowser]

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

[DB Browser 4 SQLite @sqlitebrowser]

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

[DB Browser 4 SQLite @sqlitebrowser]

@KevinPagano3 @forensicmike1 :(

[DB Browser 4 SQLite @sqlitebrowser]

@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. :)

[DB Browser 4 SQLite @sqlitebrowser]

@mouse22_jp You can even do pivot tables in SQLite.

https://t.co/eoiRNTfDUX

[DB Browser 4 SQLite @sqlitebrowser]

@mouse22_jp Good luck!

[DB Browser 4 SQLite @sqlitebrowser]

@mouse22_jp

[DB Browser 4 SQLite @sqlitebrowser]

@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.

[DB Browser 4 SQLite @sqlitebrowser]

@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

[DB Browser 4 SQLite @sqlitebrowser]

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

[DB Browser 4 SQLite @sqlitebrowser]

@mouse22_jp This also works for text fields