Databases are used to store information in an organized manner for easy retrieval, modification and management purposes. As in the case of offices, schools or businesses, almost all kinds of information are stored in databases whose sizes may vary from small to humungous ones.
Management of databases tends to be a difficult and time consuming task. Tools are available in the market that aim at making database management easier and faster. An interface designed to run on SQL databases and aims at optimizing the above said actions, Bear SQL 1.01 is free to download and use and provides a suitable interface to databases using MySQL software written in PHP scripting language. The tool is easy to use and light and acts as a web front end to MySQL
Even users with little or no database skills can make use of Bear SQL and walk away with improved database management and operation functions. The script run by Bear SQL assumes that the MySQL username that is provided has the necessary permissions needed to perform operations on the respective database.
Bear SQL 1.01 has been released to fix issues with the PHP4 scripting version where new updates have not been added.
Some of the features of Bear SQL 1.01 include:
. Provision for the creation, management and deletion of databases along with options for database back up and restoration.
. Ability to manage all the users in the database and the privileges assigned to each user.
. Permission for users to write their own queries which can be saved along with the result.
. All kinds of database management functions including creation, search and drop of tables, renaming of tables, alteration of table structure with options to add, remove, delete records and their properties.
. Addition and drop of keys and indexes is also facilitated.