Shopify is an e-commerce platform that enables individuals and businesses to create online stores. It started its work in 2006 but now it is great system with expressive functionality. Cataloges, blogs, hundreds of apps, large theme store, access to PayPal and excellent documentation and community for all these things. But it is better to try once then to hear for thousand times. So let us start…
Author: admin
Backup of MySQL database with a PHP script
Sometimes you need to make a mysqldump backup without having SSH access or PHPMyAdmin. It can be done with PHP by means of SHOW TABLES/SHOW CREATE TABLE mysql queries. Below is an improved solution proposed here. Improvements: [list style=”upper-alpha tick”] [list_item]Got rid of memory_limit – writing to file on every iteration[/list_item] [list_item]gzip support – you don’t have to download huge uncompressed .sql[/list_item] [list_item]PHP notice fixed[/list_item]…
Using ZF for uploading PDF to Google Docs API 3.0
Zend Framework has many methods for working with Google Apps Platform in Zend_Gdata module. But has no method for uploading pdf file to new Google Docs API 3.0. So we created simple ZF class for uploading pdf to Google Docs
Zend_Gdata ACL patched framework version
While working on a task connected with updating ACL I found an interesting article and a patch there that adds ACL functionality to Zend_Gdata classes. As it might be inconvenient for some people (especially Windows users) to checkout specific revision and then patch it, I’m publishing here a patched version of ZF trunk rev. 24409 + ACL patch from rojakcoder.
iptables port forwarding with SNAT and DNAT
Assume we have a web server having node.js (or any other client-server software) installed behind a load balancer and teh web server has only internal IP address. We need to allow clients to connect to node.js. So we need to do port forwarding with iptables from load balancer’s 8000 to web server’s 8000. So the ideal model will look like on the figure below.