| 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
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.
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
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.
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.
thanks a lot,
then I won’t disturb you anymore for next days.
Hello,
hope you’re doing well and had nice time.
I’m just writing to keep the topic opened.
waiting to hear from you.
Thanks,
Bye
Thanks for the reminder.
The more I think on it, the more…not complicated…but, different from Mariadb/PostgreSQL it seems. SQLite doesn’t run as root. It doesn’t run at all, actually, it’s a file and bindings to interact with that file (that also happens to have a CLI that can work with that file, as well). It’s not a service, it doesn’t need root (so it could be a Usermin module).
Ideally, a Webmin module would use the Perl bindings for SQLite to interact with the file, but I wouldn’t want to add a dependency to the Webmin package for that, though maybe a suggests level dep would be fine. And, ideally, you’d have a database file with WAL enabled so Webmin/Usermin doesn’t lock your tables while interacting with it (but there’s no way for me to enforce that; Write-Ahead Logging). It could use the sqlite3 command to interact with the DB, but that feels sub-optimal.
Anyway, I’ll try to give it a look when I’ve got a little free time (and I’ll try to remember I said that).
Hello,
hope you all doing well.
any help needed ?
or news ?
just to keep this thread active
Bye
Perhaps make it as per phpmyadmin as the built in mysql product isn’t great to interrogate with. Hints:
Also: consistent look, feel and functionality between the 3 SQL platforms.
I started looking into creating an SQLite module but never finished it.
After your message yesterday I looked into it quite a lot further. Perhaps soon we will all have an SQLite database browser and editor. 
@Ilia = machine 
Compliment accepted! 
@Jamie, alright, the new Webmin SQLite module has been fully tested and checked in. If you have any questions or suggestions, please open an issue in GitHub, and I’ll get to it quickly.
The new Webmin SQLite module can be installed now from the new repository under the package name webmin-sqlite.
I’d recommend running tests with the latest Development build of Webmin.
This is what it looks like with the latest version of the redesigned Gray Theme:
Oh that’s cool! Will this be a core Webmin module?
Should we consider granting it to Virtualmin users, with appropriate ACLs of course.
Yes, after I address the malicious link race vulnerability, we can.
And, for now it’s only in full Webmin version, not in the core for which you’d need to install it separately.
Stupid question, what does these refere too:
Are you referring to the different version VM7 and VM8 repos? If so, which is the full and which is the core?
really thanks,
much appreciated.
you’re great, better than AI-dev-agents.
just one question, will it be included in next webmin release, right ?
I can wait, but do you know if I can download it separately in advance ?
just to test it.
Thanks again,
Bye
See these docs:
Thank you for your kind words!
Yes, it will be included in the Webmin full package. And if you installed Virtualmin recently and are using the new modular Webmin/Virtualmin repo, then you’d have to install it using the package manager with the webmin-sqlite package name.
You could likely install it from download.webmin.dev. However, if you don’t feel comfortable with this, it’s better to wait for the next Webmin release.
Fixed now at last! It’s complex.
Also done! Take a look please!
