Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Dec 04 12:13
    fernandreu commented #1229
  • Dec 04 11:32
    justinclift commented #1229
  • Dec 03 22:57
    fernandreu commented #1229
  • Dec 03 01:36
    justinclift commented #2057
  • Dec 03 01:36
    justinclift closed #2057
  • Dec 03 01:35
    justinclift commented #2057
  • Dec 02 02:46
    bernd-wechner commented #1646
  • Dec 01 20:53
    hwiesmann commented #2057
  • Dec 01 15:19
    T1mL3arn commented #2052
  • Dec 01 14:52
    MKleusberg commented #2057
  • Dec 01 14:25
    MKleusberg commented #2052
  • Nov 30 19:02
    karim commented #1968
  • Nov 30 14:33
    skys215 commented #2055
  • Nov 30 13:27
    hwiesmann opened #2057
  • Nov 30 12:33
    karim commented #1930
  • Nov 29 20:17
    chrisjlocke commented #2055
  • Nov 29 17:15
    justinclift commented #2055
  • Nov 29 13:48
    sky5walk commented #2056
  • Nov 29 10:59
    justinclift commented #2056
  • Nov 29 10:58
    justinclift commented #2056
Scott Furry
@scottfurry
justin-feist - url you're looking at that says that?
If it's the same url - that is the ability to open or do some actions from command line but will still start the gui(If I'm reading this properly).
justin-feist
@justin-feist
That's the URL, yes. It refers to "sqlitebrowser" but I don't see it on my system.
Ok, I was hoping for a completely command-line interface
Scott Furry
@scottfurry
if building from source - the executable is in the src directory.
check that. It would be in the root project directory.
justin-feist
@justin-feist
Will do. Thanks for the advice. I'll look into building from source in the next few days. Appreciate the help!
Scott Furry
@scottfurry
Check the github page. You may not have to build if a pre-built is available for your system
justin-feist
@justin-feist
Yeah, looking at the various zip files for Windows, both release and nightlies, and not seeing it
Scott Furry
@scottfurry
Download zip. Expand. Execute "sqlitebrowser"
justin-feist
@justin-feist

:D Sorry, don't mean to be dense, but going here:
https://nightlies.sqlitebrowser.org/latest/

The zip files don't have that executable. It's ok...

Scott Furry
@scottfurry
what platform?
msi is a windows installer. zip file is just that - executable in zip archive. dmg is mac osx disk image.
If Linux, there are options depending on distribution.
justin-feist
@justin-feist
Yes, got all that. :) I'm on Windows 10 64-bit. Neither DB.Browser.for.SQLite-win32.zip , nor DB.Browser.for.SQLite-win64.zip contain the executable mentioned in the command-line documentation
The other binaries in that directory are either Windows installers (msi) or macOS images
The installers for Windows do not contain the "sqlitebrowser" executable either
Justin Clift
@justinclift
Ahhh.
This is one of those slightly weird things, that's somewhat legacy. The "sqlitebrowser" in this case is the "DB Browser for SQLite.exe" file.
It's just the project used to be called "SQLite Browser" as it's official name. So the matching executable was called "sqlitebrowser". And "sqlitebrowser.exe" on Windows.
When we changed the name, finally settling on "DB Browser for SQLite" (it turns out most of the other options are already taken)... having an executable name with spaces in it "DB Browser for SQLite" is a bad idea.
So, for *nix based systems we keep with "sqlitebrowser" as the executable name. And on Windows, where most people launch it via a shortcut anyway, we renamed it.
Does that help? :smile:
justin-feist
@justin-feist

Sorry! I went away for a few days. Thanks for the info, but I'm not sure it supports what I'm looking for. What I'm looking for is a command-line way to interact with SQLCipher encrypted databases. I tried substituting "DB Browser for SQLite.exe" for "sqlitebrowser" but it opens the UI and prompts for the encryption key. I was looking for a way to do this in an automated, non-human involved, way.

Thanks so much for your time helping! Much appreciated

Justin Clift
@justinclift
Ahhhh. SQLCipher itself includes a replacement for the SQLite cli utility. In theory, you should be able to use that.
You might need to compile itself yourself though.
IoTFier
@IoTFier
Hi @justinclift , @scottfurry - how are you? Is there a link for free ODBC driver for Sqlite v3+?
Justin Clift
@justinclift
@IoTFier This is the standard one isn't it? http://www.ch-werner.de/sqliteodbc/
Pretty sure I looked at that a few years ago for um... using with LibreOffice or similar, and it worked ok then.
Seems to support both SQLite 2 and SQLite 3, so sounds like the right kind of thing. :)
IoTFier
@IoTFier
@justinclift thank you
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. :)