I'm looking to implement SQL functionality directly on a web page and wonder if there are suitable editors available. Specifically, I want a SQL editor that allows users to perform DDL and DML commands online, without relying on traditional database management tools like pgAdmin or dBeaver. Are there any libraries or tools that can help me achieve this?
4 Answers
Are you asking for a web-based SQL admin client? If so, what kind of database are you using? Knowing if it's client-side or server-side might help narrow down the options you need for your app.
You might want to check out pglite.dev—it's a web-based tool that could fit your needs!
Have you considered using PHPmyAdmin? It's still a solid option for SQL management, though it’s not the newest tool out there.
Thanks for the suggestions! I’m excited to see what's out there.
It's for integrating an SQL editor that lets users run queries on already connected databases. I really need functionality similar to what pgAdmin or dBeaver provide.