20 Eylül 2013 Cuma

List of Foreign Keys in Mysql

Following sql shows list of foreing keys in Mysql. You may require this information for foreign key manipulations, such as dropping a foreign key.

use INFORMATION_SCHEMA;

select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE where
TABLE_NAME = '<table>';

You may require this information for foreign key manipulations, such as dropping a foreign key.

Resource: http://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column 

1 Eylül 2013 Pazar

My First Open Source Contribution

I have just completed my first open-source contribution to gwt-bootstrap project. The code updates are merged to master branch!

https://github.com/gwtbootstrap/gwt-bootstrap/pull/425

This is my first contribution to a widely used and known project. Previously, I had published several open-source projects which are not active now.

Learn JBoss Forge

Video: Forge New Ground in Rapid Enterprise Software Development
http://www.youtube.com/watch?v=Clso5vtKu9k

Learn GWT


Login Security
https://code.google.com/p/google-web-toolkit-incubator/wiki/LoginSecurityFAQ: Describe how to log in, store data in a secure fashion in the server, stay logged in, make auto complete feautre

Advanced:
Best Practices For Architecting Your GWT App
http://www.google.com/intl/tr/events/io/2009/sessions/GoogleWebToolkitBestPractices.html: Describes history handling, event bus, MVP architecture, unit testing of GWT applications

Learn Bootstrap