I’m trying to find a good web-based solution for our team to work with our database. We need something that’s easy for non-tech folks to use, not just for admins.
Here’s what we’re looking for:
Works with MySQL or PostgreSQL
Lets us manage contacts and orders
Simple enough for regular staff to use
Ability to make custom forms (kind of like Microsoft Access)
LDAP login would be great, but not a must-have
I’ve looked at stuff like phpMyAdmin, but it’s too complex for our needs. Other options I found just show tables without letting us build custom views.
Has anyone found a tool that fits the bill? If not, I guess we’ll have to use OpenOffice Base or code something ourselves in PHP.
Have you looked into nocodb? it’s an open-source airtable alternative that can connect to mysql and postgres. Pretty user-friendly interface, custom forms, and views. not sure about LDAP but it mite be worth exploring. curious wat others think about it for your use case?
I’d recommend considering Metabase for your needs. It’s a powerful yet user-friendly tool that connects to both MySQL and PostgreSQL. While it’s primarily for data visualization, it also offers basic data management capabilities.
Metabase provides an intuitive interface for creating custom queries and dashboards, which could serve as your custom forms and views. It’s designed for non-technical users, allowing them to explore data without writing SQL.
Although it doesn’t have built-in LDAP support, there are ways to integrate it. The community edition is free and open-source, so you can try it out without commitment.
It might not tick all your boxes, but it could be a good compromise between ease of use and functionality for your team.
hey ryan, have u checked out airtable? its not exactly a database tool but kinda like a spreadsheet on steroids. u can make custom forms and views, plus its super user-friendly. might be worth a look if u want something simple for non-techies. not sure about LDAP tho