How do you open files?

[sjlongland]

Hi,

I used to use sqlite-manager years ago with an earlier version of Firefox, there used to be a menu item to open an external SQLite3 file. It worked great, and was one of the best front-ends for manipulating SQLite3 files. At the time, it was perfect for my needs.

Today, I tried installing the extension… I struggled to find where to open the file. If I point Firefox at the file, it offers to download it. The documentation I've seen vaguely talks about "dragging and dropping" files… I have no idea how I'm supposed to do that… I can see the file in the output of ls on my terminal, but obviously attempting to "drag" this will do nothing but highlight the text on the terminal session for copying later, it does not do anything to the file.

For sure, there's a lot of features described, but I'd expect feature #1 is the ability to open a file like it used to.

Is there something I've missed?

[arrghh1]

It's not the same product as 'sqlite-manager' for firefox! This is more like a jupyter notebook for sqlite. It is not a generic GUI for sqlite (ie. you can't browse the tables without writing SQL)

But I agree, the file open mechanism is not intuitive. The menu on the top left, which says "drop database" is confusing for people that know sql, as drop database means delete....

perhaps "Drag and drop database to open".

[sjlongland]

@arrghh1 Errm… then why does https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/ link to https://add0n.com/sqlite-manager.html which down the bottom of the page takes you to https://github.com/lunu-bounir/sqlite-manager/

SQLite Manager may not be a generic GUI, but it came pretty damn close, allowing you to import and export tables as CSV, update tables as easily as a spreadsheet, add and remove columns, all sorts of operations. It'd be truly sad if it's lost all those features too.

[arrghh1]

The one that I think you're thinking of was this one: https://addons.thunderbird.net/en-us/firefox/addon/sqlite-manager/?src=cb-dl-popular
Built by @lazierthanthou .... and sadly hasn't been updated for new versions of firefox. A tool I've personally found useful in filling this gap, is DBeaver: https://dbeaver.io/download/