SQLite database browser and editor

Webmin
1
SYSTEM INFORMATION
OS type and version Debian Linux 13
Webmin version 2.651

Dear All,

would you think it could be possible to add a (web) SQLite browser module like for PostgreSQL and MariaDB ?

at the moment I’m using:

but it’s on python and it’s an additional web server opened on my system for just some checks and edits.

searching on webmin website I found this:

but when I tried to download and check I got 404
maybe it doesn’t exist anymore since it’s 20 years old.

Thanks

2

It’s not 20 years old. Or, at least, it’s not 20 years unmaintained: GitHub - virtualmin/virtualmin-sqlite: Virtualmin plugin to manage SQLite databases · GitHub

Only 6 years since its last update.

However, that was never an SQLite browser and editor. That just allows you to create/delete SQLite databases associated with a user…which is kind of a weird thing to do for SQLite databases, since any app can create an SQLite database without any administrator involvement.

So, it exists, but there’s no reason to use that Virtualmin module.

But, a browser/editor UI would be useful. And it wouldn’t be all that hard to make. I’ll look into it.

3

many thanks,

and sorry for my mistake.

It’s nice you liked my suggestion.

How can I help ?

I’m not a developer, last piece of code on 2000 at the uni, but I read this:

is it feasible to clone an existing module and slowly modify it ?

thanks

4

Of course, that’s how most folks make modules (including us). SQLite is so much simpler than MySQL or PostgreSQL, though, that I’m hesitant to suggest forking either of those. I mean, the SQL stuff and the table display makes sense, but SQLite doesn’t have like 70% of the stuff in the UI for either of the big DBs, so you’d spend more time pruning than adding to.

5

But, when I say I’ll look into it, I mean I’ll probably make something this weekend.

Not to discourage you from tackling it, making modules is fun and you’ll learn stuff, and I’m happy to answer questions when you run into problems.

6

thanks a lot,

then I won’t disturb you anymore for next days.