Tuesday, August 5, 2008

MYSQL B!!! (Bug / Behaviour)


Well i got an error in mysql for which i banged my head for full 2 days and figured out it was a small change(I knw every bugs ends the ame way.. :)).Well , i didnt find any forum that explains about the bug and its solution.

Query: Select * from where tot = tot1
BUG: Unknown column "tot1" in where clause.

SOLUTION: Select * from where tot = 'tot1'

If the value of the tot1 is TOT it works fine if it is any thing other than that it gives an error. I could never figure why it acts so weird, Well if any1 knows the solution lets me know and simple image has been attached for the results.

Sunday, June 22, 2008

I-phone Versus Laptop with Citrix Virtual desktop

Just imagine using i-phone instead of laptop. Things would be more simpler!!!! So for those outraged with the Windows XP "running" on a "slow" processor like iPhone's, I say - you can all relax, the actual processing was done on a back-end virtual desktop and remotely delivered via Citrix XenDesktop.

Tuesday, June 17, 2008

WEB 2.0Ooooh

One bad thing about web is you read about one version which took more than years of time by more than a million researchers... in a mins time you come to see web 3.0.Well we will talk about WEB 3.0 in next post but for now just 2.0

Web 2.0 is a base on the web 1.0 with the same networking techniques giving more enhancements to the user interaction with the net. Web 2.0 sites often feature a rich, user-friendly interface based on below tags. Any internet applications made using the concept of web 2.0 are called RIA.

Rich internet applications techniques such as AJAX, Adobe Flash, Flex, JavaFX, Curl and Silverlight have evolved that have the potential to improve the user-experience in browser-based applications. Specialized protocols such as FOAF and XFN (I have never gone through this protocols, but I have given links below.) extend the functionality of sites or permit end-users to interact without centralized websites.

http://en.wikipedia.org/wiki/FOAF_%28software%29

http://en.wikipedia.org/wiki/XHTML_Friends_Network

ADOBE AIR: I was in air at ninth cloud when i read about this.Dont miss the e-bay application.Its amazing.Best part of it is the response facts are similar to javascript and very fast than cache implementation.These applications are created as on-line application but there basic uses are for desktop deployment.

http://en.wikipedia.org/wiki/Adobe_Integrated_Runtime#Applications

ADOBE FLEX: FLEX in simple wrds HTML + FLASH. being from the networking back ground I was not very much impressed with this outcome as it turns a web application very heavy n slow to handle but advantageous is the look-n-feel u get from this, it make's the user crazy about the site.Check out lee burner site. You will stick to that site more than a day..It’s an SDK to develop WEB2.0 with all the rich contexts. In context of web1.0 he can match html as flex pages and java script which dynamic content as coldfusion ability from ADOBE

http://en.wikipedia.org/wiki/Adobe_Flex

MICROSOFT SILVER LIGHT: This not a framework rather it’s a browser plugin.Its just a sibling of Adobe flash with more good performance techniques. Worst part of it is it does not support any OS based browsers especially safari and other Linux based browsers. So it is also called browser-unsafe plug-in.

http://en.wikipedia.org/wiki/Microsoft_Silverlight

JAVAFX: This is my favorite... :)

It is a RIA frame work with similar to flex but performance was its very good than flex as they should be accessible by mobile applications that is using JAVAME.

If anyone wants to know internal content of any above applications .This site below is very good and informative

http://www.devx.com/RichInternetApps/Article/35208/1954?pf=true

There are few more like CURL, open lazzalo..You may think who is she to give her comments.Well these are just my comments.Do drop in your comments in the comments column.

Monday, May 26, 2008

AM I FAR?

VNC akka virtual network computing. Do you feel your far from your computer. just relax at your lappi and use technology .VNC server is basically remote computing .IT is not heavy like any refelction or Hummpi. Above that is is inbuilt in my fav OS linux esp fedora.... :)

Here is the awesome link which explains about VNC and gives how to set it up?

http://fedoranews.org/tchung/vnc/

Tuesday, May 20, 2008

DUMP MYSQL

OOoops!!!! did i say something wrong. Mysql is the best SQL database with lot of inbuilt functions, not just leaving you to the drag and drop stuff put encourages you to use your very own brain and come with queries!!! well thsi blog is not about to encourage and to pomp and show about mysql but this is where i will say how to take backup of your mysql database.

LINUX BASED USERS:
The most common use of mysqldump is probably for making a backup of an entire database:

shell> mysqldump --opt db_name > backup-file.sql

You can read the dump file back into the server like this:

shell> mysql db_name < backup-file.sql

Or like this:

shell> mysql -e "source /path-to-backup/backup-file.sql" db_name

mysqldump is also very useful for populating databases by copying data
from one MySQL server to another:

shell> mysqldump --opt db_name | mysql --host=remote_host -C db_name

It is possible to dump several databases with one command:

shell> mysqldump --databases db_name1 [db_name2 ...] > my_databases.sql

If you want to dump all databases, use the --all-databases option:

shell> mysqldump --all-databases > all_databases.sql

oKE OKE YOUR AN WINDOWS USER:

"C:\Program Files\MySQL\MySQL Server 5.0\bin"\mysqldump -uBackup -pBackup %db% >c:\backup\%db%.sql