Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Aug 23 14:31

    deepsidhu1313 on continuous

    (compare)

  • Aug 23 14:31

    deepsidhu1313 on continuous

    (compare)

  • Aug 23 14:12

    MKleusberg on master

    Restore status bar calculations… (compare)

  • Aug 23 13:33

    deepsidhu1313 on continuous

    (compare)

  • Aug 23 13:33

    deepsidhu1313 on continuous

    (compare)

  • Aug 23 13:14

    MKleusberg on master

    Make new TableBrowser class a b… Fix collation combo box for new… (compare)

  • Aug 23 05:33
    SilvioGrosso commented #1962
  • Aug 22 18:51
    SilvioGrosso edited #1976
  • Aug 22 18:35
    SilvioGrosso edited #1976
  • Aug 22 18:31
    SilvioGrosso opened #1976
  • Aug 22 07:49
    BoniuNIU commented #1975
  • Aug 22 07:47
    BoniuNIU commented #1975
  • Aug 22 07:23
    chrisjlocke commented #1975
  • Aug 22 07:22
    justinclift commented #1962
  • Aug 22 07:22
    chrisjlocke commented #1962
  • Aug 22 06:54
    justinclift labeled #1975
  • Aug 22 06:54
    justinclift commented #1975
  • Aug 22 03:39
    BoniuNIU opened #1975
  • Aug 22 01:45
    BoniuNIU closed #1974
  • Aug 22 01:43
    BoniuNIU edited #1974
Scott Furry
@scottfurry
itchka - no. The .gitignore can be manually over-ridden, as was done in this case. See this commit: sqlitebrowser/sqlitebrowser@543b98e
The actual changes to cmake to better detect QScintilla were made in this commit: sqlitebrowser/sqlitebrowser@b4af221
Again, the .gitignore was manually suppressed to pull these changes into the tree. The usage of the .gitignore in this case is, IIRC, to prevent other non-project or unrelated CMake files for being mistakenly incorporated.
The commit for QScintilla goes under the assumption that if you want to build against the external QScintilla, then that library is installed in a Qt5 location known to the operating system and/or CMake.
Thus the tweak. Detect QT5 first and then use those paths to also detect QScintilla.
Justin Clift
@justinclift
You two are really getting the hang of things. It's good. :)
Scott Furry
@scottfurry
Justin Clift
@justinclift
Heh Heh Heh.
justin-feist
@justin-feist
Hey all. I see documentation for a Command Line Interface. It refers to a sqlitebrowser executable. I don't see that executable in the installation folder. How can I use DB Browser from the command line?
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. :)