Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Mar 31 17:43
    B-bit-maker closed #2171
  • Mar 31 17:43
    B-bit-maker commented #2171
  • Mar 31 17:24
    mgrojo commented #2171
  • Mar 31 17:19
    mgrojo labeled #2171
  • Mar 31 17:01
    B-bit-maker edited #2171
  • Mar 31 17:01
    B-bit-maker edited #2171
  • Mar 31 14:41
    B-bit-maker opened #2171
  • Mar 29 11:20
    justinclift unlabeled #2164
  • Mar 29 11:19
    justinclift closed #2164
  • Mar 29 11:19
    justinclift commented #2164
  • Mar 29 11:05
    chrisjlocke labeled #2164
  • Mar 29 11:04
    chrisjlocke commented #2164
  • Mar 29 11:04
    chrisjlocke commented #2164
  • Mar 29 00:51
    justinclift commented #2170
  • Mar 28 21:35
    siegrist809 opened #2170
  • Mar 26 21:50
    mnmkng commented #2107
  • Mar 26 19:13
    mgrojo commented #2142
  • Mar 26 05:31
    tomlagier commented #2142
  • Mar 25 22:28
    djedi commented #1982
  • Mar 25 03:26
    justinclift closed #2157
Arunprasath
@csearun
Sqlite Bulk insert datatable in C# ?
Justin Clift
@justinclift
@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
@h2ad2
Don't know if this is the place to ask, but here goes: I'm running DBBrowser Version 3.11.2 on Windows10 and regular expressions apparently don't work on it. Why?
Karim ElDeeb
@karim
@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.
h2ad2
@h2ad2
@karim Weird. It works now. I had picked the example from the Wiki and worked it around a bit, but that didn't work. Thanks for verifying!
Karim ElDeeb
@karim
No problem, I'm glad it is working for you now. :)
Jon
@IGTHORN
Hi. Is there a way to enter a sqlcipher password that contains unprintable characters and newlines? (i.e. it's just random binary data that doesn't copy paste very nicely into the password box)
Karim ElDeeb
@karim

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

Jon
@IGTHORN
@karim Thanks, I updated to the latest version and then I see the options you've mentioned. Thank you!
Karim ElDeeb
@karim
You are welcome. :)
matanster
@matanster
Hey there, can I get a nightly build (or the latest version) on Ubuntu, without having it run over my installed stable version?
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/
BTW this is a phenomenal tool, very stable and usable.
arronlacey
@arronlacey
Can the portable version generate entity relationship diagrams?
Justin Clift
@justinclift
@arronlacey Not yet. It's something we've begun experimenting with in the development source code, but it's not yet very fully featured and hasn't made it's way into any of our proper releases. Yet. ;)
@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. :)
matanster
@matanster
@justinclift thanks a lot for your kind message!
Justin Clift
@justinclift
@matanster You're welcome. :)
Scott Furry
@scottfurry
Going through over a news feeds yesterday lead to a link: https://www.froglogic.com/squish/
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?
Justin Clift
@justinclift
Interesting. Haven't come across an OSS equivalent before, but then again... I haven't really looked. ;)
Scott Furry
@scottfurry
@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.
Justin Clift
@justinclift
Yep, agreed. :)
IoTFier
@IoTFier
Hi @justinclift , @scottfurry -is there any plan to support creating of the Views in SqliteBrowser tool ?
Justin Clift
@justinclift
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/
Scott Furry
@scottfurry
views are a "different kettle of fish". IIRC, views in sqlite are "read-only". Would need to play with the sqlite command line to see how it gets done.
Justin Clift
@justinclift
Yeah, could be. I'm more used to the PG way doing them, and don't tend to use them much myself.
Scott Furry
@scottfurry
And with a full-blown RDBMS, you have the added complexity of triggers and scripting/macros...and...and...
Justin Clift
@justinclift
;)
Scott Furry
@scottfurry
yeah. netbeans is at 11.3 - version candidate #1 \o/ progress!
Safa Alfulaij
@SafaAlfulaij
Hi guys. I was trying to use the CLI of SQDB on Windows, but it closes once I use "-h"/"--help"
closes = crashes?
Using nightly
Justin Clift
@justinclift
Ouch. Sounds like there's more stuff to investigate for the upcoming release. :(
Martin Kleusberg
@MKleusberg
"-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?
Safa Alfulaij
@SafaAlfulaij
I was just questioning if it closes normally or crashes as I don't know
btw what is "Browsables"
Does it show even
Safa Alfulaij
@SafaAlfulaij
btw
There are still many strings that needs fixing
And much more needs deletion (most of Whats This strings)
Even the language could be enhanced
(noting that I'm not a native English speaker)
Joshua Taillon
@jat255
For a given database, is there a way to define a default view in DB Browser for SQLite?
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
Karim ElDeeb
@karim
@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.
Joshua Taillon
@jat255
@karim perfect! exactly what I was looking for. thank you!
Karim ElDeeb
@karim
You are welcome. :)
Scott Furry
@scottfurry
@justinclift - you're going to drag me into using rust - I just know it... :wink:
Scott Furry
@scottfurry