Skip to main content

Web Development Dilemma - Part 2

Recently, I got a Job to build an ERP Application (More like Accounting Package with CRM). I started planning for the Application. I had some experience with Tally.ERP 9 and knew a bit about Accounting too. Once again I chose Wordpress Platform for the application development, as I was more comfortable with it. Application was to have multiple advanced features along with some of smart automated data sensing and processing, and selective data push (Semi-Automated) to Tally for Accounting Purpose. The application was to run in a LAN Environment and was connected with the Customer's Website to retrieve Customer Order submitted on the website (Customized Shopping Cart) for further processing. 

I could develop fast in Wordpress, I was familiar with the system and environment. But due to multiple distractions, and tedious job (I hadn't anticipated lengthy coding and timing involved), the project had to be scrapped by the customer. The customer was gracious enough to forgive me, but I couldn't forgive myself for failing on a project. He instead asked me to compensate him by optimizing his business processes and give him better solutions. 

Continuing with the thought: Though the ERP project was scrapped, I have decided to build another one on the learning from my past experience, and failures. An Accounting System which will be easy to learn, easy to use and can be a good cost-effective solution for SMBs.

What I learnt from my Past Failure:
  1. If you take too long to release a product, you will lose control over it and your interest in developing it will diminish. Release as soon as possible.
  2. Project Management is very Important. I have no Project Management or Time Management experience, and I wish to learn it and implement in my future projects to keep it on time.
  3. Project Cost and Time Estimation. I never did it. Simply, I never knew and gave it much thought, and I am regretting now.
  4. Project Scope, Definition, Planning. Heck, I never did any documentation. All I did was back on the envelop(Not literally. Adhoc planning on loose paper sheets) drawing, doodling, and some scribbling. Proper Project Definition, and Planning is very important, you can never succeed without proper planning and documentation (except for some very small projects).
Actually there are more lessons, but these are primary. I failed, because I did not plan. I failed, because I did not have much time. I failed because of my poor judgement of time estimation. I failed, because I did not have proper guidance. I failed, because I did not have proper training. I failed, because I did not give much attention to details. 

What to do? I was always hungry. I was always short on fund. I was always involved in small projects, and always under super tight schedule to deliver those (3 month's work in one month). I never got enough time to plan for things. 

Thanks to my intuition, my ability to visualize what I am going to create even before I could create, and thanks to Dr. Hrishikesh Ingle's influence on me for lateral thinking I have survived this long.

Still, I had failed! I failed for so many reasons, but I am upbeat about it. Because, I am learning my lessons here. I am getting opportunity to learn from my failures and another chance to getting my acts together. I am excited, I have so much to learn and put into practice, and most importantly, discipline myself, which my father and my teachers were unable to. 

Weird huh? Happy about disciplining myself? Actually I am. As I know now what can I achieve through discipline. I wish, I weren't a brute, Only If I had paid heed to my father's advice, I would have been able to enjoy life, instead of poring over books late at night. But hey! This is life! You fall, you get up, learn from your mistakes, then fall again, learn to walk... learn to run... and if you are upto it... perhaps you can even fly. And I wish I could fly!

Coming back to my decision of Developing an Accounting System with CRM for SMBs. My friends and my business Partner (My Brother) asked me, why do I need to develop another Accounting System when the market is already saturated with so many Applications? Even I asked myself, whether undertaking such a big project is feasible? Would I be able to devout as much time as It may require? Why cannot I use any existing Open Source Accounting Application? There were and still there are so many questions I need to answer before I can commit to this big project. One of the serious question though is selection of technology and methodology.

Since I cannot afford to hire any experienced programmer to do the job, and I do not have enough patience to teach a fresher and then see him vanish with my source code. I had thought about making this an Open Source, but then decided against it, as I wish to let the application mature before turning it open-source for further marination/seasoning. Plus, I wish to make it a commercial venture, though I am yet to find any VC, and like I said, my project planning skill is zero for making any good impressionable presentation to VCs.

So, I have only one option left - Agile Methodology. I build it quick, release it, and let the market capture it. If need be, do some marketing push. Initially, I will make it free for anyone to use and let the product develop itself(We will be coding) from the user's need/perspective/input. I have given myself Just three months to do the initial release.

But, what about technology? Which one should I use? My plan is to make this a SAAS Application (Mobile Friendly). I do not have enough money to pay to Microsoft, so .Net is out. Never Wanted to learn more JAVA, had enough in my classroom. No more Wordpress. ROR and Django are much better option. 

What do I hear??? Meteor/AngularJS? Yeah, I had always wanted to learn and try Node.js. 

Or, Should I stick to PHP - Zend/CakePHP/Symfony*/lavarel? Twitter Bootstrap or Foundation Framework??? What about Google App Engine? MySQL or PostgreSQL or MongoDB?

So much to choose from, no wonder I am getting a headache just by keeping track of all these. Though, I would really like to try ROR and Django, I would also like to cut on the learning curve by going along with PHP. Like I had mentioned earlier, This time, I will plan ahead before jumping right into coding and designing. I am going to spend more time on Proper Planning and Documentation, do some solid feasibility study, defining Minimum requirement for launching my Application, and create milestone/timeline for further development. This time, I would do it right. 

But what would I do about the combination of technology??? I am always willing to learn. I would again go through learning process to get my skills right. If I choose PHP, I would definitely like to go with Symfony as I have heard so much about it. However, in order to use it I must learn more on PHP OOP programming. This time I would also involve my brother cum my business partner to help me in every aspect of this application. He is learning PHP right now, furiously typing on his keyboard, soaking all the fun that comes with Programming and the feeling of creating something new.

Innovation is the key, but I believe in 'First Replicate, then Innovate', or 'First Repeat, then Defeat'. I need to build my project reports, need to find the best technology combination, need to get my act right, need to discipline myself, need to find a good server, build application, find testing customer, build some more, find paying customer. Uh! So much to do and so little time. Wish my 10 months old daughter could code? Nah! I would definitely inspire her, not push her. Her mum must learn programming though, She had been helping me some graphics work and CSS. Wish I knew how to turn her away from stupid Indian Serials and get her to sit on another terminal beside me and code furiously.

Comments

Popular posts from this blog

Installing Oracle 9i on RHEL5. (x86)

I must warn you that this article is as it is. It worked when I was installing the combo - a long time ago. I am not sure about the links available in this article. I am not maintaining this article anymore, (other than sprucing it up a bit for better reading). I am completely out of touch with RHEL or Oracle for that matter. Still, dont lose your heart yet. I am sure, with proper searching using the big brother - Google, you will find lots of more information relating to your work to help you finish what you are doing. Foreword Recently I joined Sqlstar International for my Oracle DBA course. Everything was going smooth. I completed my SQL Fundamentals with Oracle installed on Windows in my pc. But when classes started for DBA Fundamentals 1 I was at loss, as in my institute oracle was installed on Redhat Linux platform. I could have done all the solution of the text on windows but I decided to configure my own Linux box and install oracle on it to simulate the class environment.

Datatables and Wordpress Integration problem solved.

Note: Download a working demo plugin from this project's github repository . Like other wordpress developers, I had also faced the problem of integrating datatable (server side processing) with wordpress. I tried every tips, tricks and multiple ways to solve the problem, but couldn't do it. My ajaxified functions of the wordpress simple dint work. I din't have much time and had to finish a small project on time. So, I decided to skip it and go through the developer's way : the plugin developer had suggested and implemented. I dropped the required php file with some related modifications and called the url of the php file in the datatable options in my project. It worked after few small hiccups. I wasn't satisfied though, as i wanted the wordpress centric solution, instead of using some drop-in file to complement the functionality. I had vowed to look after this problem whenever I could get some time. (You may visit the url http://www.bearinghouse.net/orde

Starting up and stopping Oracle Listener and iSqlPlus

Starting up and stopping Oracle's Listner Service and httpd service for iSqlPlus. I know it's a lame, but what the heck. Someone may be benefitted. In the last post I installed Oracle 9i on RHEL5. But my Oracle agent dint startup. Which mean I have to startup and stop aforementioned services manually till I could configure the Agent.  Well the commands are quite simple. To startup Oracle's Listner Service - $lsnrctl start To Stop the listner- $lsnrctl stop To start the httpd server for iSqlPlus -  $ORACLE_HOME/Apache/Apache/bin/apachectl start To stop the httpd server for iSqlPlus -  $ORACLE_HOME/Apache/Apache/bin/apachectl stop I have made two shell-script for these operation, just to ease my finger from over-typing. These files and their contents are: isqlplusstart.sh #[Content] lsnrctl start ORACLE_HOME/Apache/Apache/bin/apachectl start #[End Content] and isqlplusstop.sh #[Content] lsnrctl stop ORACLE_HOME/Apache/Apache/bin/apachectl stop #[End Content] I made them execu