techfounder
Blog about web development and Internet entrepreneurship
Writing specifications for web applications
In: Lionite| Web development
3 Jul 2009Specifications are an integral part of any web project (or any software project for that matter). Writing good specifications will improve the probability of success for a given project by a great deal.
Read the rest of this entry »
Multiple row operations in MySQL / PHP
In: MySQL| PHP| Web development
14 May 2009Multiple row operations are in common use in a normalized application databases as one database entity is often linked to multiple sub-entities (for example a user and his tags). By row operations I'm referring to write queries, namely UPDATE and INSERT queries (DELETE is less interesting so I'll leave it out for now).
Too often I've seen such queries ran in long loops one at a time, which is very bad for performance (as I will show here) and sometimes equally bad for integrity (if the process is interrupted). So what are the alternatives?
Read the rest of this entry »
- (11) Comments
- Tags: insert, multiple rows, MySQL, on duplicate key, update
Finding your web business model
6 May 2009The web as a commercial venue has changed and evolved much in the relatively short time since its inception. As the medium and technology evolved, more and more "real-world" business models became viable for web products.
Despite this, the application of those business models in the web arena is still very much experimental, and it's often hard for web businesses to find and implement a model that works well for them.
Read the rest of this entry »
For a long time, we've been feverishly developing beautiful sites for others while our own site was left to rot in mediocrity for lack of time. Now, finally, we've taken the time to properly redesign and relaunch our portfolio website, at http://www.lionite.com:
Conveying value to clients
In: Business Development| Lionite| Web development| techfounder
5 Apr 2009Preface: This article was written mostly half a year ago, as I was wrapping up an intense period of freelancing and sub-contracting. It is less relevant for me now, as I'm now an equal partner in a small web firm and my freelancing days are beyond me - however, I thought it might be a good read.
About this blog
Eran Galperin is an Internet entrepreneur and head of development @ Lionite.
In this Blog he writes about Internet ventures and web development.
Categories
- Business Development (6)
- Interesting (6)
- Lionite (6)
- Open Source (13)
- techfounder (12)
- The Webs (10)
- Web development (47)
- CSS (5)
- Javascript (13)
- MySQL (6)
- PHP (25)
- UI (6)
- thomas: hi i have 3 tables like a ,b c where a contains employee detail , b contains details of item con [...]
- Glaubensfragen « bohuco.net: [...] Blog-Eintrag “Common misconceptions in web application development” beleuchtet einige imme [...]
- Eran Galperin: Plain SQL :) of course, I make sure to properly filter and escape user input [...]
- Arik Fraimovich: @Eran & @George - thank you for the information. Going to rewrite some queries now :) @Eran - [...]
- George: @Arik Fraimovich: REPLACE and ON DUPLICATE KEY UPDATE are actually quite different. REPLACE actually [...]
- Writing specifications for web applications
- Multiple row operations in MySQL / PHP
- Finding your web business model
- Lionite relaunched! time to kick back… and work some more
- Conveying value to clients
- Selecting closest values in MySQL
- Zend Framework certification
- If you like t-shirts, check this out
- OO PHP templating
- Making web-pages go faster using PHP