Check out this SlideShare Presentation:
Using Technology to GROW your business
View more documents from Aaron Schaap.
16.12.09
15.12.09
Building customer loyalty programs
Check out this SlideShare Presentation:
Building customer loyalty programs
View more presentations from smittal.
4.11.09
MySQL Admin and Development Tools
Below are some of the most useful and most popular MySQL Admin and Development Tools for Mac, Windows and Linux, for beginners and for professionals. Among other tools phpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro. Please let us know if some useful MySQL-tool is missing in the list by commenting upon this article.
MySQL Workbench (Win, Linux, Mac)
MySQL Workbench
This application is a fully featured visual database design package that includes database design, modeling, creation and maintenance bundled into a single environment for the MySQL database system. The free version is the Community Edition, which is loaded with features that will meet almost all your requirements. If you feel adventurous you could always go for the commercial version (Standard Edition).
This application is a fully featured visual database design package that includes database design, modeling, creation and maintenance bundled into a single environment for the MySQL database system. The free version is the Community Edition, which is loaded with features that will meet almost all your requirements. If you feel adventurous you could always go for the commercial version (Standard Edition).
- Help and Support
MySQL Workbench Help - Download
Select your download version
HeidiSQL – MySQL made easy (Win, Linux)
Heidi SQL
Heidi SQL is lightweight and fast with a flexible interface, it allows you to browse and edit your databases databases, manage tables, view and edit records, manage user-privileges, import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts, and all this from an intuitive Windows interface.
Heidi SQL is lightweight and fast with a flexible interface, it allows you to browse and edit your databases databases, manage tables, view and edit records, manage user-privileges, import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts, and all this from an intuitive Windows interface.
- Help and Support
Heidi SQL Forums - Download
jHeidi Alpha 4 download
You can also download a small app for the iPhone called jHeidi Mobi, whicht is the only application to offer Oracle and MySQL access in a mobile application. jHeidi Mobi Download Page
Aqua Data Studio (Win, Linux, OS X, Solaris)
Aqua Data Studio
This complete IDE, has four major areas of functionality: Database query and administration tools; a suite of compare tools for databases, source control and file systems; integrated source control client for Subversion (SVN) and CVS; and a powerful database modeler. The Studio has a single consistent interface to all major relational databases, this allows the developer to simultaneously tackle several tasks from within a single application.
This complete IDE, has four major areas of functionality: Database query and administration tools; a suite of compare tools for databases, source control and file systems; integrated source control client for Subversion (SVN) and CVS; and a powerful database modeler. The Studio has a single consistent interface to all major relational databases, this allows the developer to simultaneously tackle several tasks from within a single application.
- Help and Support
Aqua Data Studio Support - Download
Aqua Data Studio Downloads Page
phpMyAdmin
phpMyAdmin
This very popular, feature rich and easy to use free tool, written in PHP (obviusly), has been built to handle the full administration of MySQL. It can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage users and permissions, and manage keys on fields. A nice feature from this legendary tool is that you can download and change the theme (not exactly a monumental feature, but a unique feature), download themes here: phpMyAdmin Themes (remember themes are version specific).
This very popular, feature rich and easy to use free tool, written in PHP (obviusly), has been built to handle the full administration of MySQL. It can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage users and permissions, and manage keys on fields. A nice feature from this legendary tool is that you can download and change the theme (not exactly a monumental feature, but a unique feature), download themes here: phpMyAdmin Themes (remember themes are version specific).
- Help and Support
phpMyAdmin Support - Docs
phpMyAdmin Docs - Download
phpMyAdmin Downloads Page
SQLyog MySQL GUI (Win)
SQLyog
SQLyog is another popular SQL management tool that has a couple of useful features such as visual schema designer, visual query builder, intelligent code completion and a data / structure synchronization. It support HTTP / HTTPs / SSH tunneling and SSL connections. You can also specify a job manager, define a scheduled database backup and use a notification service to be reminded when some jobs are finished. There is a free Community version and a commercial Enterprise edition. You may also use MONyog, a MySQL Monitor and Advisor.
SQLyog is another popular SQL management tool that has a couple of useful features such as visual schema designer, visual query builder, intelligent code completion and a data / structure synchronization. It support HTTP / HTTPs / SSH tunneling and SSL connections. You can also specify a job manager, define a scheduled database backup and use a notification service to be reminded when some jobs are finished. There is a free Community version and a commercial Enterprise edition. You may also use MONyog, a MySQL Monitor and Advisor.
- Help and Support
SQLyog Forum - FAQ
SQLyog FAQ - Download
SQLyog Downloads Page
MySQL-Front (Win)
MYSQL Front
This graphical GUI for the MySQL database, is a “real” application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML. Response is immediate, as there is no delay of reloading HTML-pages. If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise, only one small script needs to be installed on the publishing website. Login information are stored on your hard disk, so you no longer have to log on to different web interfaces.
This graphical GUI for the MySQL database, is a “real” application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML. Response is immediate, as there is no delay of reloading HTML-pages. If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise, only one small script needs to be installed on the publishing website. Login information are stored on your hard disk, so you no longer have to log on to different web interfaces.
- Help and Support
MYSQL Front Forum - Download
MYSQL Front Downloads Page
Sequel Pro (Mac OS X)
Sequel Pro
This MAC OSX database management app gives you direct access to your MySQL databases on local and remote servers with support for importing and exporting data from popular files including SQL, CSV and XML. Sequel Pro started as a fork of the open source CocoaMySQL project. It is the self proclaimed “Best Looking MySQL Database Management App for the Mac OS X“, going by the screenshot below they wouldn’t be wrong, it is sleek and cool.
This MAC OSX database management app gives you direct access to your MySQL databases on local and remote servers with support for importing and exporting data from popular files including SQL, CSV and XML. Sequel Pro started as a fork of the open source CocoaMySQL project. It is the self proclaimed “Best Looking MySQL Database Management App for the Mac OS X“, going by the screenshot below they wouldn’t be wrong, it is sleek and cool.
- Help and Support
Sequel Pro Support - Download
Sequel Pro Downloads Page
SQL Buddy (Web-App)
SQL Buddy
This cool lightweight ajax powered database management tool is amazing. It is very, very easy to install, unzip the folder to your server and thats it. As for upgrading, delete the older version and replace with the new version, simple. Being powered by Ajax, it is browser friendly so you can use normal browsing actions like “bookmark”, “back” and “refresh”. There is also a useful range of keyboard shortcuts, which you can view here: SQL Buddy Keyboard Shortcuts.
This cool lightweight ajax powered database management tool is amazing. It is very, very easy to install, unzip the folder to your server and thats it. As for upgrading, delete the older version and replace with the new version, simple. Being powered by Ajax, it is browser friendly so you can use normal browsing actions like “bookmark”, “back” and “refresh”. There is also a useful range of keyboard shortcuts, which you can view here: SQL Buddy Keyboard Shortcuts.
- Help and Support
SQL Buddy Support - Download
SQL Buddy Downloads Page
EMS SQL Manager (Win)
EMS SQL Manager
EMS SQL Manager is a fairly high performance tool for database administration and development. Features include MySQL triggers, views, stored procedures and functions, InnoDB foreign keys, it allows you to create/edit all MySQL database objects, design databases visually, run SQL scripts, import and export database data, manage users and their privileges and has many other useful features. There is a commercial version, but download the free version, its fairly powerful and offers plenty of features.
EMS SQL Manager is a fairly high performance tool for database administration and development. Features include MySQL triggers, views, stored procedures and functions, InnoDB foreign keys, it allows you to create/edit all MySQL database objects, design databases visually, run SQL scripts, import and export database data, manage users and their privileges and has many other useful features. There is a commercial version, but download the free version, its fairly powerful and offers plenty of features.
- Help and Support
EMS SQL Manager Support - Download
EMS SQL Manager Downloads Page
Navicat Lite MySQL Admin Tool (Win, OS X, Linux)
Navicat Lite MySQL Admin Tool
Navicat is a fast, reliable and popular (millions of downloads) Database Administration tool purpose-built for simplifying database management and reducing administrative costs. Designed to meet the needs of database administrators, developers, and small and medium businesses, Navicat is built with an intuitive GUI which lets you create, organize, access and share information in a secure and easy way. Navicat Lite is available as a free download only for non-commercial customers.
Navicat is a fast, reliable and popular (millions of downloads) Database Administration tool purpose-built for simplifying database management and reducing administrative costs. Designed to meet the needs of database administrators, developers, and small and medium businesses, Navicat is built with an intuitive GUI which lets you create, organize, access and share information in a secure and easy way. Navicat Lite is available as a free download only for non-commercial customers.
- Help and Support
Navicat Support - Download
Navicat Downloads Page
DreamCoder for MySQL (Win)
DreamCoder for MySQL
DreamCoder works with all MySQL versions from 3.23 to 6.0 and it supports all MySQL features including tables, views, procedures, functions, triggers, InnoDB Tables, foreign keys , UDFS, BLOB Types, etc. It also includes the most advanced options for data manipulation, build queries visually, execute queries, script execution, reports generation, database monitoring and export and import data to/from most popular file formats. DreamCoder for MySQL is easy to use for the novice MySQL user and is powerful enough for any expert user.
DreamCoder works with all MySQL versions from 3.23 to 6.0 and it supports all MySQL features including tables, views, procedures, functions, triggers, InnoDB Tables, foreign keys , UDFS, BLOB Types, etc. It also includes the most advanced options for data manipulation, build queries visually, execute queries, script execution, reports generation, database monitoring and export and import data to/from most popular file formats. DreamCoder for MySQL is easy to use for the novice MySQL user and is powerful enough for any expert user.
- Help and Support
DreamCoder Support - Download
DreamCoder Downloads Page
Toad MySQL (Win)
Toad MySQL
Toad for MySQL is a database development and administration tool that provides productivity features for rapidly creating and executing queries and managing complex database systems. It provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database. Changes to the interface recently has been the the introduction of the “Tabbed Document Interface”, this means you can view a fully maximized window without the need for you to constantly resize, arrange, or tile the windows.
Toad for MySQL is a database development and administration tool that provides productivity features for rapidly creating and executing queries and managing complex database systems. It provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database. Changes to the interface recently has been the the introduction of the “Tabbed Document Interface”, this means you can view a fully maximized window without the need for you to constantly resize, arrange, or tile the windows.
- Help and Support
Toad MySQL Support - Download
Toad MySQL Downloads Page
DB Tools Manager Professional (Win)
DB Tools Manager Professional
DBManager is a fairly powerful application data management data management. With builtin support for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines, making it one of the most advanced database application. The free edition (Standard Edition) has a minimun set of features that makes it ideal for new database users to perform basic database management, you can use this for non commercial use.
DBManager is a fairly powerful application data management data management. With builtin support for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines, making it one of the most advanced database application. The free edition (Standard Edition) has a minimun set of features that makes it ideal for new database users to perform basic database management, you can use this for non commercial use.
- Help and Support
DB Tools Manager Forum - Download
DB Tools Manager Downloads Page
MyCon – MySQL GUI (Win)
MyCon – MySQL GUI
MyCon is an extremely powerful windows based graphical user interface, MySQL GUI, for administering and working with MySQL server databases. This easy to use MySQL GUI front-end client includes all the functionality and tools you will need to be productive in MySQL as a DBA, developer, manager, report writer or a general end-user.
MyCon is an extremely powerful windows based graphical user interface, MySQL GUI, for administering and working with MySQL server databases. This easy to use MySQL GUI front-end client includes all the functionality and tools you will need to be productive in MySQL as a DBA, developer, manager, report writer or a general end-user.
- Help and Support
MyCon – MySQL GUI Forum - Download
Free MyCon Downloads Page
MyDB Studio (Win)
MyDB Studio
MyDB Studio is a complete collection of powerful tools for MySQL Server administration. MyDB Studio (freeware) is designed for MySQL developers and administrators to rapidly manage, create and execute queries and develop SQL and Php code more efficiently. Keep an eye out for the upcoming Adobe Air version of MyDB Studio, that will be cool.
MyDB Studio is a complete collection of powerful tools for MySQL Server administration. MyDB Studio (freeware) is designed for MySQL developers and administrators to rapidly manage, create and execute queries and develop SQL and Php code more efficiently. Keep an eye out for the upcoming Adobe Air version of MyDB Studio, that will be cool.
- Help and Support
MyDB Studio FAQ - Download
MyDB Studio Downloads Page
MySQL Sidu (Win)
MySQL Sidu
MySQL Sidu is a FREE MySQL client that works via your web browser, it is simple, intuitive and an easy database tool to use. Sidu is not as powerful as other similiar tools but packs enough punch to merit its place in this list, its features may be limited but it does do exactly what the name says (Sidu stands for Select Insert Delete Update).
You can also use a Firefox Extension in conjunction with Sidu that enables you to insert data from text fields & textareas in a webpage. View the details here: Firefox addon for MySQL Sidu.
MySQL Sidu is a FREE MySQL client that works via your web browser, it is simple, intuitive and an easy database tool to use. Sidu is not as powerful as other similiar tools but packs enough punch to merit its place in this list, its features may be limited but it does do exactly what the name says (Sidu stands for Select Insert Delete Update).
You can also use a Firefox Extension in conjunction with Sidu that enables you to insert data from text fields & textareas in a webpage. View the details here: Firefox addon for MySQL Sidu.
- Help and Support
MySQL Sidu Support - Download
MySQL Sidu Downloads Page
apache friends – xampp (Win, Mac, Linux, Solaris)
apache friends – xampp
It’s not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. It is really very easy to install and to use – just download, extract and start.
It’s not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. It is really very easy to install and to use – just download, extract and start.
- Help and Support
xampp Support - Download
xampp Downloads Page
Retrieved from http://www.smashingmagazine.com 11/03/09
15.10.09
The Cloud Without the Airfare - Peter Coffee 10.09.09
I spend a lot of time on airplanes, en route to give conference keynotes and other such briefings, most of which are centered on the question of "What's this cloud computing thing and what will it do for me?"
21.9.09
Open Source Blogging Tools
Check out this SlideShare Presentation:
Open Source Blogging Tools
View more presentations from Michelle Murrain.
18.7.09
Programming Beyond Basics: Rapid application development (RAD)
Rapid application development (RAD) refers to a type of software development life cycle which uses minimal planning in favor of rapid prototyping. The "planning" of software written in RAD is interleaved with writing the software itself. The lack of extensive pre-planning generally allowed software to be written much faster, and makes it more flexible to change in requirement.
RAD calls for the interactive use of structured techniques and prototyping to define user's requirements and design the final system. Using structured techniques the developer first builds preliminary data models and business process models of the business requirements. Prototyping then helps the analyst and users to verify those requirements and to formally refine the data and process models. The cycle of models, then prototypes, then models, then prototypes and so forth on, ultimately results in a combined business requirements and technical design statement to be used for constructing new systems.[1]
RAD approaches may entail compromises in functionality and performance in exchange for enabling faster development and facilitating application maintenance.
Web Based Rapid Development Application Tool
- Active Agenda's code generator is a RAD development framework using XML specification files and the PHP development language.
- Alpha Five is a commercial RAD development environment for both client and web-server based database driven applications. This tool is typically classified with commercial packages such as Microsoft Access and FileMaker.
- BFC is a RAD framework for both client and server-side development in the .NET environment.
- CakePHP is a RAD development framework using the PHP development language.
- CodeCharge Studio is a visual RAD development environment for web-based database driven application development. CodeCharge Studio places emphasis on code generation technology to provide ASP.NET, PHP, JSP, Servlets, ColdFusion and Perl language support.
- Zend Framework is an open source, object-oriented web application framework licensed under the New BSD License.
- Django is an open source web application framework, written in Python, which loosely follows the model-view-controller design pattern
- IBM Rational Business Developer Extension is a cross-platform, Rapid Application Development IDE for creating enterprise and web applications and services for Windows, Linux, Unix (Solaris, HPUX, AIX), System z and System i
- GForge Advanced Server a full software development process platform for complete project management and collaboration tool suite with tracking plug-ins for Eclipse IDE as well asMicrosoft Visual Studio and other related tools were added to increase developer functionality.
- LibreSource
- NConstruct is Windows and Web rapid enterprise application development tool and environment for .NET framework.
- nuBuilder is an open source browser based database development tool which stores all forms, reports, data and any custom code in MySQL and displays the content dynamically.
- Oracle Application Development Framework uses Oracle's JDeveloper a FREE IDE that supports ADF's J2EE based framework.
- Panther (and its open source version POSSL) is a cross-platform (Windows, Unix, Linux; TUI, GUI, Web), cross-database RAD toolset for development of C/S and n-tier database oriented applications.
- Ruby on Rails sponsored by 37signals
- SednaSpace is a browser based Rapid Application Development tool, that generates code in technologies like AJAX, C#, VB.Net, Java and many other.
- Symfony
- Thoroughbred T-WEB is a Web RAD tool
- Web2py is a RAD framework for web-based database driven applications with key features including in-browser coding support, admin/design interface, DAL (database abstraction layer), and translation support.
- WebDev
- Wavemaker Visual Ajax Studio is an open-source, browser-based IDE based on Dojo, Spring and Hibernate.
- Visual WebGui Visual WebGui (VWG) is an open-source rapid application development (RAD) framework for AJAX & Silverlight GUIs. The platform presents a new approach to applying desktop usability to the web by viewing it as an extension to a desktop rather than web
- cakeApp an online rapid development tool with WYSIWYG SQL editor and framework based on CakePHP.
http://en.wikipedia.org/ - Retrieved on 18 July 2009
12.7.09
Programming Beyond Basics: PHP
What is PHP ?
PHP is a server-side scripting language for creating dynamic Web pages. PHP's programming syntax is very similar to that of Perl. Because of its elegant design, PHP makes it easy for anyone to learn. It is significantly easier than comparable Perl or ASP Code. Unlike other scripting languages, PHP supports the most common databases like Oracle, Sybase and MySQL. It is also possible to integrate external libraries to generate PDF documents or parsing XML PHP is an open-source language and is supported by a large groups of delvelopers. The code is downloadable from php.net.
Rasmus Lerdorf, who wrote the originalCommon Gateway Interface binaries, andAndi Gutmans and Zeev Suraski, who rewrote the parser that formed PHP 3 While PHP was originally created by Rasmus Lerdorf in 1995, the main implementation of PHP is now produced by The PHP Group and serves as the de factostandard for PHP as there is no formal specification. PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) due to restrictions on the use of the term PHP
What is MySQL ?
MySQL is a relational database management system. It is a Open Source SQL database provided by MySQL AB. MySQL is very fast, reliable, and easy to use. It also has a very practical set of features developed in very close cooperation with our users. MySQL was originally developed to handle very large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Though under constant development, MySQL today offers a rich and very useful set of functions. The connectivity, speed, and security make MySQL highly suited for accessing databases on the Internet.
PHP Main Development Sites
PHP: Hypertext Preprocessor Home Page PHP is a server-side HTML embedded scripting language. It provides web developers with a full suite of tools for building dynamic websites: native APIs to Apache and other web servers; easy access to MySQL, Sybase, Oracle, and other databases; IMAP; LDAP; HTTP headers and cookies. This site is the official home of PHP4.
Zend A bottom-up rewrite of the PHP scripting engine. It features a modular architecture, vastly improved performance, and greater scalability.
International PHP Magazine Web-based magazine for Web professionals focused on PHP based development. News, online articles, book reviews, forum.
Quality Assurance Team Voulonteer coders dedicated to providing coders with quality assurance.
Codewalkers A community site dedicated to PHP and SQL. Includes user submitted code, tutorials and forums.
PHP Freaks A community designed to assist developers with PHP and MySQL related information. Includes tips, tutorials, forums, articles, code examples and manuals.
PHP Everywhere Articles on PHP on Windows and Linux. Also compares PHP to ASP, Cold Fusion and Perl.
PHP News by CodingTheWeb.com PHP development news, tutorials, technical articles and HOWTOs. This is the definitive news source for PHP. Updated hourly.
PHPMac.com A site dedicated to PHP programmers that use the Mac OS. In particular Apple's new OS X unix system.
Devshed - Searching with PHP and ht://Dig Adds search capabilities to site using the popular open source tools PHP3 and ht://Dig.
Wrox Resource Center PHP support and resource forums run by programmers for programmers, provided by Wrox Press.
Core PHP Programming Home page for the first book about PHP
Club of the Developers This is a site of programmer's group united by a desire to develop PHP technologies in Internet.
ThePHPGuy PHP, MySQL and Apache articles, tutorials, guides. Also features daily updated developer news as well as a monthly developer newsletter packed with PHP programming tips and tricks.
Recent Releases
PHP 5.0.0 PHP5 has finially been released. This is the first full version of PHP5 with all the new features.... www.php.net
PHP 4.3.8 This release is made in response to several security issues that have been discovered since the 4.3.7 release.... www.php.net
Apache 2.0.50 This version of Apache is principally a bug fix release. In particular it addresses two security vulnerabilities: a remotely triggered memory leak and a mod_ssl buffer overflow... httpd.apache.org
PHP 5 RC3 The third (and hopefully final) Release Candidate of PHP 5 is now available! This mostly bug fix release improves PHP 5's stability and irons out some of the remaining issues... www.php.net
2009 PHP TestFest PHP 5.3.0 Released!
PHP 5.3.0RC4 Release Announcements
PHP 5.2.10RC2 and PHP 5.3.0RC3 Release Announcements
TestFest 2009 PHP 5.3.0RC2 Release Announcement
PHP 5.2.9-2 (Windows) released
Google Summer of Code 2009 PHP 5.3.0RC1
Release Announcement 5.2.9-1 (for Windows) released
PHP 5.2.9 Released! Windows PECL binaries
PHP 5.2.7 has been removed from distribution
Retrieved on 11 July 2009
/http://en.wikipedia.org/wiki/PHP
Subscribe to:
Comments (Atom)