UPDATE - October 2016 / new project

Been a while since my last post on this blog. Fact is - I haven't been doing much programming lately but am about to undertake a large project on information management and employing advanced and logical data systems to support and in some cases, automate and even drive decision making and workflows in a very complex, global, real world process that generates about 50,000 distinct pieces of non-electronic outputs every year.

More on this to follow in the coming days.

MySQL foreign key constraints

Below are explanations for MySQL's foreign key constraints:

1. ON DELETE RESTRICT

This means that a given parent row cannot be deleted if a child row referencing to it exists. It can be deleted only if there are no referencing child rows.

Modern database systems make this clause redundant as this would be default behavior of any foreign key. I am not sure which versions of MySQL include this as default, still wouldn't hurt keeping this clause.

2. ON DELETE CASCADE

ON DELETE CASCADE means that if a given parent row is deleted then all referencing child rows will also be deleted.

3. ON DELETE SET NULL

ON DELETE SET NULL means that if a given parent row is deleted then all referencing child rows will be set to NULL.

4.  ON DELETE NO ACTION

Same as ON DELETE RESTRICT, that is, a given parent row cannot be deleted if a child row referencing to it exists.

ASP.NET on a Macintosh

Greetings all,

This has been a question running through many minds, can one do ASP.NET programming on a Mac. Well I have just tried it out and it works!

So far, I tried only basic scripts and these executed perfectly on my MacBook Pro. Can't wait to dive deep into it!

Stay tuned for updates...

Moved to Thailand -- Internet!?

Greetings fellow programmers and computer people!

I have recently moved to Thailand and found a new place to stay, now only thing remaining before I can start churning out one line of code after another and sharing it with the wider world outside my MacBook (x2) and MacBook Pro is getting the wire to the outside world -- yes, I am talking about Internet!

My apartment has free wireless for its residents but the speed is terrible, now I am trying to get a line of my own -- easier said than done -- in fact the problem is finding a good source of information, there are many many websites, unfortunately all in Thai.

So, now being the the helpful kind I am  (yeah right!!!), I am sharing unofficial Google Translation translated versions of pages that I found helpful, also included are the URLs of the pages and the Thai versions as they appear on these pages.

Please note that I take no responsibility for the text underneath, I have simply copy pasted the Thai version and the version translated by Google Translation (Link to translation), page version as of 19 June 2012, 09:45 local Thai time.

Mi-Fi (from TrueCorp)

URL: http://www3.truecorp.co.th/trueonline/product/detail/61/Mi_Fi

Specifications:   - รองรับการแชร์อินเตอร์เน็ตแบบ Wi-Fi,   เข้าใช้งานได้พร้อมกัน 5 เครื่อง - รองรับเครือข่าย 3G/HSPDA คลื่นความถี่   850/1900/2100 MHz - รองรับความเร็วสูงสุด 7.2 Mbps   (Download) และ 5.7 Mbps (Upload) - หน้าจอแสดงผล OLED แบตเตอรี่   1500 mA, ใช้งานได้นาน 4 ชม.

- Support for shared Internet access Wi-Fi,. Access 5 computers at once.  - Support for network 3G/HSPDA spectrum. 850/1900/2100 MHz. - Supports a maximum speed of 7.2 Mbps. (Download) and 5.7 Mbps (Upload).  - OLED screen displays the battery. 1500 mA, up to 4 hour

Search engine optmization for Cultures-Connect

Search engine optimization for Cultures Connect (www.cultures-connect.net) is a project that I have just taken up, it involves comprehensive search engine optimization and promotion of the website. In addition to employing traditional SEO techniques, customized content is also being developed for the website.

Cultures-connect is an initiative of two social and cultural anthropologists and it is conceived as a platform for exchanging ideas and networking individuals interested in inter-cultural encounters. It also aims to promote cultural exchanges on a high level. The specialties of the institution involve organizing specialized travel, launching social projects and anthropological research.

Personally, while working on this project, I have found that it is engaged in wonderful work in remote Himalayan communities, I encourage you to visit their website, not only to see my work, but more to see their work and be inspired by them.