Development discussion for DB Browser for SQLite (previously SQLite Browser)
@csearun Not sure personally. C# isn't something I've ever touched. As a thought, it's probably better to ask in an issue on our GitHub repo (https://github.com/sqlitebrowser/sqlitebrowser), as some of the people there use C# and are helpful. :)
@h2ad2 They do work. Just tested it now to confirm. Can you post your SQL query? Also check the wiki (https://github.com/sqlitebrowser/sqlitebrowser/wiki/Regular-Expressions) to learn more and see an example.
@IGTHORN There are two modes for entering password in an encrypted database; passphrase and raw key. What you are looking for is Raw Key mode (https://github.com/sqlitebrowser/sqlitebrowser/wiki/Encrypted-Databases#what-are-raw-keys).
When creating a password for your database, there is a small listbox next to the password editbox. Change it from Passphrase (the default) to Raw key. When entering a raw key you have to prefix the password with 0x. For example to set your password as a newline (\n) make it 0x0A.
I would like to have a version that has the dark theme mode in it, for sustained work at night time (pun not intended).
https://sqlitebrowser.org/blog/dark-theme-support-in-our-nightly-builds/
https://sqlitebrowser.org/blog/dark-theme-support-in-our-nightly-builds/
BTW this is a phenomenal tool, very stable and usable.
@matanster ... sorry for the month long delay. Looks like none of the development team have been checking our Gitter for a while. ;)
@matanster If you're still interested in this, it's probably best to ask that in a GitHub issue, so the whole team sees it. The team member who set up the Ubuntu builds would likely be the one to answer. :)
Link is to a Qt UI tester. Nice idea but the catch is that it is a "paid" or "subscribe" application. Anyone know of an open source alternative?
@justinclift - I had to throw it out there. My impression watching bug reports pile into my inbox is that a lot of "troubles" could be weeded out with some automated testing. This would be more than the travis and other testing just building, but execution of the binary looking for problems. Having a testing scheme of both SQL handling as well as GUI, IMHOAE, would greatly increase reliability.
Hmmm, we already have support for views to some level. That being said, I personally haven't done anything with views (in SQLite) for ages, so not sure if we're supporting their creation yet, or just handling existing views ok (eg manually created ones in SQL tab).
Prob best to just download a nightly build and see if creation works for you. :)
https://nightlies.sqlitebrowser.org/latest/
Prob best to just download a nightly build and see if creation works for you. :)
https://nightlies.sqlitebrowser.org/latest/
closes = crashes?
Using nightly
"-h"/"--help" should print some text to the console output, then close. If I remember correctly we had reports that on Windows outputting to the console doesn't work as expected. So how sure are you that it crashes? Or could it be the case that it just quits as expected but fails to print anything to the console before that?
btw what is "Browsables"
Does it show even
Even the language could be enhanced
(noting that I'm not a native English speaker)
everytime I open one db I use, I have to switch tables, and then sort by a column
just wondering if there's anyway to make that default for that file
@jat255 What you are looking for is Project Files (https://github.com/sqlitebrowser/sqlitebrowser/wiki/Project-Files). When you create, and save, a project file it will remember the last tab you were on, the current table, columns size/sort, and many more.