BLOGS@DiGiTSS

DiGiTSS Team's Programming experience with PHP, MySQL, Ajax, Javascript, jQuery, C# and Microsoft technologies

Posts Tagged Tools

Setting up PHP, MySQL, Apache with most up-to-date WAMP Package

Jan 17

Posted by Dharmavirsinh Jhala in PHP | 2 Comments

WAMP Packages

WAMP Packages

Availability of WAMP packages is not a new story, they are here since the beginning of last decade now. EasyPHP, Wamp, XAMPP and dozens of them. Find comparison of WAMP packages on Wikipedia here.

We are here not to discuss all of them, just top 3 to 5 which are active and we can use them reliably for development or optionally for production purpose or both.

Having WAMP stake up-to-date on production environment is important as we are using open-source technologies and there are few to hundreds of critical to non-critical bugs are being fixed with every new release of the software, and if it's development environment we would like to test new features when they're hot.!

Zend Server, Zend Server Cluster Manager and Zend Server Community Edition:

Zend Server (CE)

Zend Server (CE)

All 3 editions are highly reliable and ready for production usage. I have tried both Zend Server and ZS-Community Edition, Zend Server - Commercial version is pre-tweaked for performance on production environment and Community Edition do not have some of the goodies. But that does not stop you or me from using Zend Server - CE on production. Zend Server comes with beautiful web-panel to administer, control and configure server from the browser itself. We can change PHP and Apache parameters, check server status and even restart service from within browser itself, this feature makes it good choice for remote server administration.

Zend Server - CE is as good for development as it is for production. It comes as Apache and PHP package where MySQL is an optional download during the installation wizard.

The Uniform Server:

The Uniform Server

The Uniform Server

Uniform Server is comparatively new kid on the floor and highly configurable for both development and production use. It comes with system tray using which we can switch Apache and PHP configuration files from development to production or back and forth.

It comes in both VC6 and VC9 binaries for Windows and I must say it's most up-to-date WAMP package so far (I mean next or equal to Zend). Rest of all WAMP packages take week to months to bundle latest version of Apache, PHP or MySQL but I have observed Uniform Server very quick with that. This is main benefit if you are really looking for such option to use on production server.

Installation is simplest - extract and done. Comes with minimum, no big bucket (just 11-13MB in size).

Comes with some handy plug-ins for FTP, Resin, Tomcat etc. It has e-Accelerator packed with it is recommended for production use.

Read the rest of this entry »

Tags: , , , ,

MySQL 5.5.8 – Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn’t have a default value)

Jan 16

Posted by Dharmavirsinh Jhala in MySQL | 4 Comments

MySQL 5.5.8

MySQL 5.5.8

I have just downloaded and setup MySQL 5.5.8 community server for Windows (32bit Installer) from MySQL official downloads. After downloading while I tried connecting it with HeidiSQL 5.x I got following error "Problem while Creating new User (SQL Error (1364): Field 'authentication_string' doesn't have a default value)".

It seems like it's a problem with HeidiSQL-5, probably due to the fact that table schema for mysql.users table might be changed in MySQL 5.5.8. You might see something like following if you're using HeidiSQL-5.

MySQL5.5 > Create User error while using HeidiSQL 5.0

MySQL5.5 > Create User error while using HeidiSQL 5.0

Solution: There are 2 ways to fix the problem:

A) Download HeidiSQL 6.0 and try creating user again. Read the rest of this entry »

Tags: , ,

Facebook launches Registration Tool

Dec 17

Posted by Dharmavirsinh Jhala in News | No Comments

Facebook Developers

Facebook Developers

Facebook - The Social Network launches new Registration tool, which we can embed on our website. This tool will reduce the amount of time taken for website visitors and one can have more sign-ups, registrations or prospects signing in.

This would definitely help many businesses as it would lead to more accurate data for businesses and less keystrokes for users/visitors. Similar to Facebook's Like button we will see lot of implementations of this tool in near future. (it would be in millions soon.. :) )

Read the rest of this entry »

Tags: , , , ,

Acronis Disk Director 11 Home Worked for me..!

Oct 23

Posted by Dharmavirsinh Jhala in Reviews | 2 Comments

Acronis Disk Director Home 11

Acronis Disk Director Home

This week Monday late evening I came to know that my hard-drive has encountered some problem which was working well till last Sunday evening somehow. What all I remember which might have caused this could be my successful experiment to shift one of my extended partition to primary partition to increase the primary partition size. That time I have just Googled-up to find out a free-software to help me out for that. I Googled-up and found Partition Wizard Home Edition Free which can do the job for me. Not to say I had partitioned my 400GB partition into 8 partitions and just with the help of Partition Wizard HE - Free I pumped 50GB more into my primary partition C-Drive. Which was okay for several days but after few days I got dumped.

My partition-table was corrupted and while booted Monday I came to know that no other drive except C -Drive was visible. I was 99% sure that I will get my data back but was just looking for the Right-Tool to do that. After downloading several tools and tried all of them but not much luck. I was ready to spend some dollars but could not find the right tool. My old favorite PC Inspector File Recovery was not able to help either. Then one of my colleague Girish Parmar suggested me to use Acronis for the job. I knew that Acronis is there and I have used it few years back in the time of Partition Quest Magic 8 but it was history now.

I have downloaded Acronis Disk Directory 11 Home and initially I thought it won't work. But then I got another HD plugged in took a risk to Initialize my old HD again and after that tried using Acronis Recovery Expert again and w0000t! it just worked for me. I was able to recover all my partitions in several trials in two go. Read the rest of this entry »

Tags: , , ,

HeidiSQL 5.1 – good has got better

Jul 5

Posted by Dharmavirsinh Jhala in MySQL | 4 Comments

HeidiSQL

HeidiSQL

HeidiSQL has been excellent SQL Administration and Development tool so far for me. HeidiSQL has active development team which keeps adding new feature and upgrading and correcting bugs to get us the great tool for MySQL development.

I have been using HeidiSQL since more than three and half years now and I am really happy with it. I must say that we work with heavy database consisting of more than 400 tables and database size exceeding few GBs but HeidiSQL has never let us down. I have tried loading my development database with phpMyAdmin and SQL Buddy both but they just failed to load such a large database with few hundreds of tables..! But with HeidiSQL I never had any problem except I got some crashing sometime in newer 5.x version but I am sure all such things will be fixed in coming builds. I am not telling that there are no other good tools are available in the market but HeidiSQL is in premium open-source tool at free of cost. I remember I had written a post on HeidiSQL 4.x more than a year ago and today we are up with HeidiSQL 5.1. Read the rest of this entry »

Tags: , ,

NetBeans 6.8 is out

Dec 14

Posted by Dharmavirsinh Jhala in News, Software | No Comments

NetBeans 6.8

NetBeans 6.8

NetBeans 6.8 is released last week on December 10, 2009 and it is on the door with many new exciting features. I am developing Web Applications with PHP, XML, Javascript, HTML and it has been great experience using NetBeans. Other than NetBeans I am using Eclipse for some of the projects and NotePad++ and EditPlus are handy for some quick-fixes where you don't need to open up or create a new Project.

EditPlus was my first Editor when I started my career and after that Eclipse PDT and later NetBeans has taken their place. For majority of projects I am using NetBeans while for some specific projects where goodness of some great Eclipse Plug-in drags me towards it. For anything quick I have always EditPlus on hand, which is really handy if you want to see some formatted code on your Windows Servers. The beauty of EditPlus is it's very light-weight (only 1.3MB) and damn fast. Though it is not Free you can use it for evaluation period as long as you wish if you can click "I Agree" at start-up.

One of my most most favorite feature of NetBeans is Quick File Search through File/Project Navigator Pane. It is the most beautiful feature..it's so coool one can't live without it once we get used to it. You don't need to type through live Windows file-listing, it just opens up tiny search control just as you start typing and it stays with character you input even after you pause for few seconds. I think this feature should be there in every IDE.
Read the rest of this entry »

Tags: , , ,

HeidiSQL 4.0 RC1 released

Jan 10

Posted by Dharmavirsinh Jhala in MySQL | 1 Comment

I am not sure how many MySQL developers are using HeidiSQL for development but I am sure those who are using it will be fan of some of it's features.!

I have been using HeidiSQL tool for my php/mySQL development for a while now. (more than a year and half..!). Before few months I have upgraded to newer version of HeidiSQL which is 4.1 RC1. It has got quite new and exciting features, looks and skins are improved. Read the rest of this entry »

Tags: , ,

Paying the bills.!