Merging two MySql tables

torbjornzetterlund MySQL Tricks Tags: ,

How to merge two MySql tables that have the same structure and were the primary keys of the two tables will clash. One option is: INSERT IGNORE INTO table_1 SELECT * FROM table_2;   which allows those rows in table_1 to supersede those in table_2 that have a matching primary key, while still inserting rows… continue reading »

Useful mysql to remove / in a db column

torbjornzetterlund MySQL Tricks

Here is a handy sql statement for removing a trailing ‘/’ in the column url [callout_box] UPDATE websites SET url = LEFT(url, LENGTH(url) – 1) WHERE RIGHT(url, 1) = ‘/’ [/callout_box]

Using a database table and Google’s Visualization Geo API in CodeIgniter

torbjornzetterlund Web Applications, Web Development Tips Tags: , ,

Want to use Google’s Visualization GEO API with CodeIgniter, her To simply put it they wanted to: The controller The model The view Pass it to Google’s Visualization into a data table Create a map based on that data. Now the example given is great, however it doesn’t jive well when you want to add in a… continue reading »

Complete your PaaS Ecosystems with CloudFlare

torbjornzetterlund Ways to run your web application, Web Applications Tags: , , , ,

To complete your PaaS setup, you would need to add a CDN and DNS hosting to complete your setup. The company that can help you with CDN and to manage your DNS are CloudFlare. CloudFlare is a service that does one thing: make websites better. With a single change to DNS, sites are instantly protected… continue reading »

GreenQloud – 100% Green Cloud Services

torbjornzetterlund Ways to run your web application, Web Applications, Web Development Tips Tags: , , , , , ,

In 2007, Gartner reported that the IT industry was responsible for approximately 2% of global green house gas emissions– equivalent to the aviation industry at the time. Since then the number of data centers worldwide has surpassed 500,000. This massive and growing need for energy is contributing, in a big way, to the global carbon… continue reading »

The cloud services explained

torbjornzetterlund Ways to run your web application, Web Applications, Web Development Tips Tags: , , , , , , , , ,

Cloud computing is the use of computing resources (hardware and software) that are delivered as a service over a network (typically the Internet). The name comes from the use of a cloud-shaped symbol as an abstraction for the complex infrastructure it contains in system diagrams. Cloud computing entrusts remote services with a user’s data, software and computation. You are probably already using cloud-based… continue reading »

Pick your own cloud with Appfog

torbjornzetterlund Ways to run your web application, Web Applications, Website Performance Tags: , , , , , , , ,

Want to focus your application development on the web application and not getting down with infrastructure issues, then you should seriously look for a Platform as a service provider.  Simply write the code of your core application, run a command or two and you a have a fully working and scalable application available online. We… continue reading »

The Evolution of Website Development

torbjornzetterlund Web Development Tips Tags:

WEB 2.0 Design Standards Over the last few years we have seen the control in website development shift from programmers to graphic designers. This was a necessary step in the evolution of the industry simply because more companies are seeing the value in maintaining a solid corporate branding throughout all of their marketing pieces. This… continue reading »