sqlitebrowser/sqlitebrowser

Development discussion for DB Browser for SQLite (previously SQLite Browser)

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

not like this hasn't happened to anyone who codes: https://www.reddit.com/r/ProgrammerHumor/comments/bvjyaj/when_everything_falls_apart/

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?

Scott Furry

@scottfurry

nv - https://github.com/sqlitebrowser/sqlitebrowser/wiki/Command-Line-Interface

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

Where communities thrive

People

Repo info

Activity