The core functionality of a messaging system in an application is to send notifications/messages to a user or a set of users.Our system also allows one to send messages to a user group.Adminer is available for My SQL, Postgre SQL, SQLite, MS SQL, Oracle, Firebird, Simple DB, Elasticsearch and Mongo DB.
User groups can obviously be formed on some parameters like access privileges, geographical location of users, etc.
This system allows receivers to respond to the messages.
Do you hate starting on a new project and having to try to figure out someone else's idea of a database?
Or are you in QA and the developers expect you to understand all the relationships in their schema? Schema Spy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.
The differences between vendors have been isolated to configuration files and are extremely limited. Schema Spy is now in O' Reilly's Java Power Tools book Generate either higher or lower-quality diagrams.
Various installations of Graphviz (depending on OS and/or version) will default to generating either higher or lower quality images.It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.Graphvis is not required to view the output generated by Schema Spy, but the option).Schema Spy uses JDBC's database metadata extraction services to gather the majority of its information, but has to make vendor-specific SQL queries to gather some information such as the SQL associated with a view and the details of check constraints. Note that this was run against an extremely limited schema so it doesn't show the full power of the tool. If you're more comfortable with the point-and-click approach then try out Joachim Uhl's Schema Spy GUI.Adminer (formerly php Min Admin) is a full-featured database management tool written in PHP.