Author Archive

07
May

SharDB, HyperDB and Multi-DB = Part 2

Part 1 is here.   HyperDB   HyperDB plugin is the implementation of replication property of WP Hyperdb. HyperDB plugin requires a master DB and a number of slaves are connected to master DB. Read and/or write permissions can be assigned to each databases. In this setup, the slaves have the same data, and act as fail over and load distribution nodes. If a database fails or if HyperDB cannot find something on a database, it auotmatically switches to another slave.   The

22
Jan

SharDB, HyperDB and Multi-DB = Part 1

The Problem   As part of the WordPress Multi-Site Installation which involved more than 600,000 blogs, the biggest problem was that mySQL installation cannot support so many tables required for as many blogs. The filesystem was the real bottleneck here as there is a limit to the number of subdirectories that can be formed and mySQL will cross this if we create 600k blogs as each blog requires 9 tables.   Solution   The solution is very obvious, to split the blogs into multiple databases. We

05
Dec

BTW Dive Services

BTW Dive Services

  Multiple projects in progress, for BTWDive.com:       An on line CRM, invoicing and work order solution: Porting a VB 6 desktop application to an on line PHP based application. Magento eCommerce Web site.   Technology: Magento, PHP, VB6, mySQL. HTML5, CSS3, Responsive  

05
Dec

App Us Ltd

App Us Ltd

Worked on multiple projects for App Us Ltd, New Zealand:   TagBook: An Android and PHP project for Livestock Farm management Spindle7: A complicated integration of multiple services via their APIs: Facebook, Twitter, Google Analytics, Xero, ZenDesk, FreshBooks, MailChimp, Adwords   Technology: Android, PHP, MySQL, SOAP, Swipe HQ Payment Gateway, REST, JSON, Web Services, API Integration Deliverables: Test Plan, Test Strategy, Test Cases, Traceability Matrix, Test Execution, Reporting (Weekly/Daily)

21
Nov

ZenDesk API Integration to get ticket details daily

Aim: To get count of tickets for every day.   User flow and implementation:   Step 1: Authorization as per https://support.zendesk.com/entries/24458591-Using-OAuth-authentication-with-your-application   Redirect the user to the authorization page in ZenDesk Get authorized using the access token.   Step 2: Get count of tickets created for a particular date.   curl Call:   curlWrap($zendfetchmail, $zendfetchkey, $zendfetchurl, "/api/v2/search.json?query=created>$dayin", null, "GET"); Note: curlWrap is a curl function which gives the response output. It passes the parameters of <mail_id>,<API key>, <app_url>,<request url>.   <request url> specifies our request. If we want to request

07
Oct

John Lentini, iGoogleFriendly.com

Great to work with! Congenial, respectful, attentive, proactive, good english.

05
Oct

Xero API Integration to get Total Sales

Aim: A tool where multiple Xero Account users can add their Xero Accounts easily and can get daily statistics from Xero and store it locally for further analysis..   Links: http://developer.xero.com/documentation/getting-started/public-applications/   User flow and implementation: A button called “Connect to Xero” to start the process of integrating a user xero account. If the user clicks on this button, it redirects to Xero and asks the user to login if the user does not have an existing Xero

21
May

XML formatting using xmllint

XMLs can come in varying shapes and sizes and often we encounter XMLs which are not formatted and hence not easy on the eye. We used to write emacs macros to format these ugly ones, but not any more. Because xml lint is here and is so easy to use in Ubuntu.   xmllint is pre-installed in Ubuntu. To make a good looking and readable XML, use: xmllint -format ugly.xml -output pretty.xml Just used it to read a one line, pretty huge XML file

05
Nov

Optical Character Recognition (OCR) is a widely used technology for extracting text from the scanned or camera images containing text.   One of our clients gave as a challenging task to see if we can improve the Tesseract Output somehow. They have been using Tesseract, but not with a satisfying performance or output. The challenge was to see if we can somehow improve the performance. After the steps outlined below, we were able to improve the accuracy by 52%.     This technology

05
Nov

Comparing different OCR packages

Optical Character Recognition (OCR) is a widely used technology for extracting text from the scanned or camera images containing text. There are different types of Open source and Commercial OCR Software. In this article, We will compare between the best of the available OCR software in the Open source and Commercial.     A general Comparison between different OCR software is given in this wiki article. But There is no sample data on the OCR efficiency.