MesaSQLite for working with sqlite3 in Macbook


MesaSQLite is a tool design for sqlite3 in Macbook as phpmyadmin works for mysql. MesaSQLite makes creating, designing, and altering an SQLite3 database easy. We also use it to edit, summarize, and analyze data for ourselves and clients. Although we build new databases most days, we spend more of our time viewing and editing data.MesaSQLite uses the SQLite3 database engine. Here is an overview of MesaSQLite features:
1. Connections
2. Structure
3. Viewing and Editing Content
4. Special Queries
5. Forerign Keys
6. Exporting and Importing Data
Mac OS X 10.2 or later



How to prepare ur Macbook for webdev

Install XAMPP:At first u have to download XAMPP for Mac OS X from this link and install as per their suggestion:
installing XDebug on Mac OS X’s default PHP installation:
1. You are going to need to  download the source code from the XDebug website. (I suggest into your “Downloads” folder to make the rest of the process easier.
2. Unzip the archive from the finder.
3. Open up the Terminal, paste the following command in and hit enter: cd ~/Downloads/xdebug-2.0.3/xdebug-2.0.3/
4. Do the same for this command: phpize
5. This one too: MACOSX_DEPLOYMENT_TARGET=10.5 CFLAGS=”-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe -no-cpp-precomp” CCFLAGS=”-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe” CXXFLAGS=”-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe” LDFLAGS=”-arch ppc -arch ppc64 -arch i386 -arch x86_64 -bind_at_load” ./configure –enable-xdebug
6. And finally this one: make
7. We have just compiled the xdebug module. We now need to copy the compiled file binary file into a place where PHP can find it. From the terminal (again) run the following command: cp modules/ /usr/lib/php/extensions/no-debug-non-zts-20060613/
8. Finally we need to edit the /etc/php.ini file so that PHP is aware of the new module. From the terminal run this command: open /etc/. This will open the /etc folder in the Finder allowing you to right-click on the php.ini file and open it in your preferred text-editor (TextEdit or TextMate for example).
9. At the very bottom of that file add the following:
xdebug.file_link_format = “txmt://open?url=file://%f&line=%l”
10. In the terminal, for the last time (I promise), run the command: apachectl restart or simply restart your computer.

Now for installation test create a PHP script with a pile of errors in it and you should see colourful error messages when run in a browser (as apposed to plain old black and white text). Or you can download something like MacGDBp – a native debugging application for the Mac.

Solve application hanging problem in Macbook

While working suddenly firefox browser became hang. Even there was no way to go to another tab. The program was not responding. So I solved the problem in following ways:
1. Click on Finder icon in taskbar
2. Go to System->applications->Utilities
3. Click on Activity Monitor and select on the tasks which are not responding
4. click ‘Quit process’ and finally close the window.