Dependency Management Data can now use sql-studio for database browsing

Featured image for sharing metadata for article

As noted in Dependency Management Data's web application can now be deployed as a single static binary, Dependency Management Data's web application has recently added a lightweight embedded web browser to enable running as a single static binary.

Last week I learned about sql-studio from Laravel News on my Google News feed and have really been enjoying using it, and enjoying the UI design as well as the database visualisation and the fact it can be deployed as a single static binary.

I've been working with upstream to add support for running it behind a reverse proxy with the intent of being able to run it with dependency-management-data.

As of today's v0.98.0 release, it's now possible to do that πŸš€

For instance, this is what the overview page looks like against the example database:

The sql-studio overview page, showing some insights into the database - 23 tables, 23 indexes, 0 views, 0 triggers, ~160K rows in one of the tables, with the next largest table being ~30K rows

I'm working with upstream in terms of running on musl-based systems like Alpine Linux and in distroless images, so until those are complete, the example web app won't have an example of sql-studio.

I'm looking forward to using it, and hopefully making it available as a good option for lightweight deployments, although note that it's a bit heavier on the frontend, requiring client-side Javascript, so may not suit every deployment model.

Written by Jamie Tanna's profile image Jamie Tanna on , and last updated on .

Content for this article is shared under the terms of the Creative Commons Attribution Non Commercial Share Alike 4.0 International, and code is shared under the Apache License 2.0.

#dependency-management-data #sql.

This post was filed under articles.

Interactions with this post

Interactions with this post

Below you can find the interactions that this page has had using WebMention.

Have you written a response to this post? Let me know the URL:

Do you not have a website set up with WebMention capabilities? You can use Comment Parade.