I'm looking to incorporate SQL functionality directly into a web application. I want to allow users to execute SQL commands—like DDL and DML—without relying on traditional database management tools such as pgAdmin or dBeaver. Are there any libraries or editors that can help me achieve this directly in a web interface?
4 Answers
PHPmyAdmin might still be a viable option for some, even if it feels a bit dated!
You might want to check out pglite.dev. It’s a web-based SQL editor that might fit your needs.
Could you tell us what you mean by "running SQL in web"? Are you trying to develop a web-based client that connects to an existing database? It'll help more if you specify the database you're working with. Are you needing this for server-side or client-side operations? What sort of data are you handling? Let’s get some details to find the best solution for you!
Also, don’t forget about Javascript libraries like SQL.js which allow executing SQL queries in the browser using IndexedDB.
I'm looking to integrate a SQL editor for users to run queries on connected databases. I need something akin to what pgAdmin or dBeaver offers.