sqlitebrowser/sqlitebrowser

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

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

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

Where communities thrive

People

Repo info

Activity