收录日期:2020/05/27 10:11:21 时间:2009-08-07 16:28:49 标签:database,user-interface,open-source

I'd like to know if there is some open source web front-end for databases. I'd like something where queries can be executed from a web browser, only read-only queries are fine. If possible it would be great to be able to select with a gui the columns that are displayed as the result of the query.

As several people asked me, I use Oracle. I'd prefer open source to be able to customize if needed.

For MySQL, phpMyAdmin is the only open source tool I'm aware of. I'm not sure about other types of databases.

I've used one called myLittleAdmin for SQL Server, but it's a closed-source paid product. Probably not going to be much help there.

MySQL has phpMyAdmin, which is quite good.

For Oracle and SQL Server there's Maestro.

It depends on wich database you are going to use, i have used phpMyAdmin before and it is really nice.

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

We use DBHawk from Datasparc. It has many features such as web based query builder, editor, SQL report builder etc. It is not open source, but Datasparc provides customization based on your needs. We are using it for our support team where we need to access many SQL Server/Oracle databases through a browser.

For a PHP/MySQL standard setup, I've found SQLBuddy to be a great (and free) little utility. It's really simple, has almost no install, and it is friendly to use. phpMyAdmin can be a bit overkill for some people especially if you're just messing around with the database and wanna check if your entries were inserted. Check it out.

Not good for you if you're using Oracle but as well as phpMyAdmin, there is also phpPgAdmin for us folks who use Postgres.