Wanted: Software for Developing Front-end Interfaces to (SQL) Databases

Tidge

Trusted Information Resource
Background/Constraints:
  • My business is very comfortable with the use of "modern" SQL databases, accessed via networked software solutions
  • My business will not allow "direct" database entry/manipulation via ad hoc methods, including queries, except by a very small pool of dedicated database admins
  • My business has solutions for general controlled read-only/reporting access of SQL databases
  • My business is in the medical device manufacturing industry, so we have particular needs around "21 CFR Part 11", but these are common concerns like individual assignment of accounts/passwords, audit trails, etc.
  • I envision multiple different databases for different business issues; not all authorized users will have access to (have accounts in) all database. (i.e. there won't be "one big database").
Given that I have acceptable solutions for extracting data from SQL databases, what I am looking for is a development system that will enable my business to do the following:
  • design SQL databases, or otherwise accept/interface with SQL databases that may have been designed by others
  • design interfaces (preferably via a webapp, using a modern browser) that allow for data entry into a SQL database by authorized users (with unique name/passwords) and will inherently generate audit trails (even if I have to design audit trails into an individual database itself, although I'd prefer a more inherent solution) for individual SQL databases
  • allows for management of the authorized users (even if I have to design user management into an individual database, although I'd prefer a more inherent solution) of those individual SQL databases
  • be a commercial solution, but one that doesn't require individual licenses for users to make use of developed solutions. I have zero objection to paying for licenses to develop individual solutions and I can even tolerate maintaining a single general license for specific administrative overhead, its just that once any given solution is developed I have zero desire to pay for individual licenses to use specific solutions that I have developed, validated, and maintain control over.
Database design and maintenance is one of my least favorite jobs, and so I offer my apologies if I'm not being specific enough in describing the problem and anticipated solution. I'm NOT trying to minimize the importance of database engineers or programmers, I simply want to have a common set of development tools for a common set of problems (database entry, authorized user management, record keeping) so that I can address a wide variety of business needs without having to repeatedly re-invent the wheel. I'd like to have a development system that I can train/hire employees to use, just as I can train/hire associates who know how to use other tools.
 

japayson

Involved In Discussions
This is a difficult request with many possibilities. If you run a search for "SQL Front End" on your search engine you will find many links that could lead you in the right direction - (or not, of course). Good luck.
 
Top Bottom