Hey everyone! I’m trying to find a good web-based solution for our team to handle contacts and orders in our database. We’re using MySQL or PostgreSQL on the server side.
I’ve been looking around for free or open-source options, but I’m not having much luck. Most of what I’ve found are either admin tools or frameworks that just display tables without letting us build custom apps.
What I really want is something that lets us create forms similar to Microsoft Access. It would be great if it had user authentication too, maybe through LDAP.
Has anyone come across anything like this? If not, I guess I’ll have to use OpenOffice Base with JDBC or code it myself in PHP.
Any ideas or recommendations would be super helpful. Thanks!
have you looked into phpmyadmin? its pretty popular for managing mysql databases thru a web interface. not sure about postgresql tho. it might not be as fancy as access for making forms, but its free and gets the job done. what kinda custom apps are u trying to build exactly? might help narrow down the options
I’ve faced a similar challenge in my previous role, and we ended up using SuiteCRM. It’s an open-source solution that offers a web-based interface for managing contacts and orders. While it’s primarily a CRM, it’s highly customizable and can be adapted to various database management needs.
SuiteCRM supports both MySQL and PostgreSQL, has user authentication (including LDAP integration), and allows for creating custom forms and modules. It’s not exactly like Microsoft Access, but it provides a lot of flexibility for building custom applications on top of your database.
If you’re comfortable with some development work, you might also want to look into Django or Ruby on Rails. These frameworks offer robust admin interfaces out of the box and can be extended to create more complex, custom applications. They have a steeper learning curve but provide more control over the final product.
hey, check out nocodb. its like airtable but open source. works with mysql and postgres. u can make custom forms and views, plus it has user auth. might be what ur looking for. its pretty new tho, so maybe not as polished as some other options. worth a shot imo