navicat mysql databases
Navicat MySQL database tool for Linux (Freeware) 8.0.29
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL. Navicat is easy-to-use and powerful. It supports backup/ restore, import/ export data and synchronize database. more>>
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL.
Major features
- This is an all-inclusive mysql front end provides a powerful graphical interface for databases management and maintenance.
- Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop.
- Navicat supports all verions of MySQL and it lets you convert data to/ from MySQL, synchronizes and backups database in a snap through helpful wizards
- Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer.
- Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries),
printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges - Navicat version 8 supports Code Completion, Form View and email Notification Services, etc.
- Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson,
Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ... - Navicat delivers a personal experience, simplifying the way you work. The program is also available for Windows and Mac OS X.
Navicat MySQL Manager for Linux 8.0.27
MySQL Navicat (MySQL Manager - a GUI for MySQL admin and development) more>> Navicat Manager is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management and maintenance. Easy installation
and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and it lets you convert data to/ from MySQL, synchronizes and backups database in a snap through helpful wizards. Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries),
printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges. Navicat version 8 supports Code Completion, Form View and email Notification Services, etc. Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson,
Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...
Navicat delivers a personal experience, simplifying the way you work. The program is also available for Windows and Mac OS X.<<less
PHP MySQL Database Layer Class 1.03
PHP MySQL Database Layer Class is a php class providing some very useful methods to work with a mySQL database. more>>
Main features:
- connects you to a mySQL host and select a database in a single call (opposed to PHPs native functions which requires two steps)
- has a "query" method that has the same role as PHPs mysql_query but this one will tell you about the affected rows (through the "affectedRows" property) when executing an INSERT, UPDATE, DELETE query and about the found rows (through the "foundRows" property) when executing a SELECT query - the "foundRows" property tells you how many records would the query return if there was no LIMIT applied to it - very useful when creating listing so you dont have to do a query to determine how many records you have in a database and the again a query to show only the records from a page
- has an "escape_string" method that will "mysql_real_escape_string" your string weather the magic_quotes are on or not
- has a "dlookup" method that i am sure you will find VERY useful once you get to know it: it return data from a single table cell based on standard mySQL WHERE criteria - see the manual for detailed info! (yes, it acts exactly like the function with the same name from microsft access)
- provides you with a very useful debug interface which shows you each query your script is running, for how long, the total number of queries made, the total execution time of your queries, errors of your queries and what are the values of $_GET, $_POST, $_COOKIES and $_SERVER superglobal variables. The debug interface is template driven and supports localisation.
- it will notify you if a specific query is executed more than once and will advise you to optimize the script
- you can instruct it to send you an email if a query runs longer then a specified time
- the code is heavily documented so you can easily understand every aspect of it and even maybe use it as a php tutorial
Enhancements:
- the state of $_FILES and $_SESSION superglobals are now also shown in the debug window
- better integration with XTemplate (previously, there was a variable assigned to each entry in the language file now the XTemplates feature to handle arrays is used)
- properties will now have default values in PHP 4
PHP mySQL Database Wrapper Class 1.0.9
PHP mySQL Database Wrapper Class provides a set of methods for interacting with a MySQL database easily and securely. more>>
There are also new methods that greatly simplify the process of executing specific queries like returning specific rows or even single values from specific rows, SUM(), COUNT(), and MAX() queries.
Enhancements:
- The result of select queries can now be cached.
- All records returned by SELECT queries were shown in the debug window, which would crash the script if there were lots of rows.
- The "showMaxRows" allows you to restrict this number.
- A bug when working with queries using replacements and having apostrophes in the replacements was fixed.
- Due to a typographical error, no error message was shown if a database could not be selected.
- New methods were added: "delete", "truncate", "insert", and "update" which are all shorthand for performing the respective SQL tasks.
Media Database 0.1
Media Database is a media database that uses PHP for the GUI and MySQL for data storage. more>>
It has movie, series, and anime listings. Media Database has lending and wishlist capabilities.
Installation:
Unpack mediadb-*.tar.gz to www dir or public_html dir.
Edit config.php, change mysql_user_name, mysql_password and mysql_server_host to match your MySQL database username, password and host.
run url: http://url_to_mediadatabase/install_mediadb.php, and follow the link and log in as admin and make default yourself a user.
*******************************************************************
****** Dont use the admin user for adding films and stuff. ******
*******************************************************************
If there are any problems, please send a short description of where it occurs and the error message to my email addres: marco (at) cakebox (dot) net, marc the topic with [mediadb]: (something you find fitting)
MP3-Database 0.8
MP3-Database is a tool to organize your MP3 collection. more>>
With this information MP3DB creates a database which can be searched for a specific song, artist, or CD.
A GUI makes it easy to use the program. Any title found in the database can easily be added to a playlist or can instantly be played by XMMS.
Main features:
- MySQL (Is needed as database backend)
- Perl5
- Perl Modules:
- Tk
- Tk-MesgBox
- Tk-LabFrame
- Tk-Pane
- DBI
- MP3-Info
- Msql-Mysql-modules
- To play MP3 files the MP3 player XMMS should be installed on your system. MP3-Database can easily be adapted to other MP3 players
Enhancements:
- NEW Data Structure: The MySQL database is much more complex than before. I used 3 Tables for Artists, Albums and Titles to store the data. This ensures that I have no redundancies in the tables. This has also enabled me to store additional fields in the database (for example the date of birth of an artist, or the release year of an album).
- NEW Temporary Database: I added some tables to store all new artists, albums and titles in a temporary database. This enables the user to check the new entries before adding them to the permanent database.
- NEW FEATURES: Additional Artist and Album information can be stored in the database, MP3DB can now create a random playlist and a playlist with the top 20 MP3 titles, MP3DB can show you a statistic how many artists, albums and titles are stored in the database.
IdealMySQL 1.1
IdealMySQL is a PHP class that provides an interface for working with MySQL databases. more>>
The project can connect to a database, execute queries on a database, check variable names for validity, and catch errors and email them to the administrator.
All error messages are stored in a text file that can be easily edited, and the look and feel of the error output to the user is controlled by a style sheet.
DatabaseScripts 0.2
DatabaseScripts is a collection of scripts for general manipulation of the amarok collection database. more>>
Backup Collection:
database will be copied to a directory. This will work for SQLite or MySQL database backends.
Optimise Database:
This script will remove all entries in the database which do not exist in the filesystem.
Navicat MySQL administrator Manager for Linux (Freeware available) 8.0.28
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL. Navicat is easy-to-use and powerful. It supports backup/ restore, import/ export data and synchronize da more>>
Navicat Manager is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management and maintenance. Easy installation
and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and it lets you convert data to/ from MySQL, synchronizes and backups database in a snap through helpful wizards. Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries),
printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges. Navicat version 8 supports Code Completion, Form View and email Notification Services, etc. Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson,
Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...
Navicat delivers a personal experience, simplifying the way you work. The program is also available for Windows and Mac OS X.
License:Freeware
Navicat Manager is an ideal solution for MySQL ... Navicat is the number 1 MySQL database administration shareware in Download.com with overLicense:Freeware
MySQL Abstractor 2.2
MySQL Abstractor package contains PHP classes that implements a MySQL database abstraction layer. more>>
It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.
Large Database Backup 1.0
Large Database Backup is a PHP class can be used to backup large MySQL databases into multiple files. more>>
It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files.
A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.
mysqlApache 1.46
mysqlApache is a MySQL database backend and browser based frontend for managing large numbers of Apache web servers. more>>
It is part of the OpenISP project and works if you like with mysqlBind, mysqlISP, mysqlIPM, and mysqlSendmail.
Our mysqlISP component systems focus is on a very stable telco quality ISP services via static configuration of servers from mySQL, but with mySQL not required to be live.
Database Functions 1.0
Database Functions is a PHP class that can be used to build and execute MySQL database queries. more>>
It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values.
The class can also execute the generated queries and retrieve the SELECT query results into associative arrays.
MySQL wrapped 1.6
MySQL wrapped is a very small collection of classes that hides the MySQL C API. more>>
Examples:
The following example should be linked with the mysqlclient library from the MySQL distribution / build.
#include
#include
#include
#include
#include "Database.h"
#include "Query.h"
int main()
{
Database db("localhost","dbuser","","testdb");
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,First Person)");
q.execute("insert into user values(2,Another Person)");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %sn", num, name.c_str() );
}
q.free_result();
}
Enhancements:
- This release adds methods to access fields by name.
Haskell Database Connectivity 1.1.2.0
Haskell Database Connectivity project provides an abstraction layer between Haskell programs and SQL relational databases. more>>
HDBC is modeled loosely on Perls DBI interface http://search.cpan.org/~timb/DBI/DBI.pm, though it has also been influenced by Pythons DB-API v2, JDBC in Java, and HSQL in Haskell.
HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
Main features:
- Ability to use replacable parameters to let one query be executed multiple times (eliminates the need for an escape function)
- Ability to access returned rows by column number
- Ability to read data from the SQL server on-demand rather than reading the entire result set up front
- HUnit testsuite for each backend driver
- Well-defined standard API and easy backend driver implementation
- Lazy reading of the entire result set (think hGetContents, but for the results of SELECT) (see sFetchAllRows)
- Support for translation between Haskell and SQL types
- Support for querying database server properties
- Add-on package (hdbc-missingh) to integrate with MissingH, providing a database backend for AnyDBM.
- Support for querying metadata such as column names.
- Support for querying additional metadata (column types, etc.)