design for budgets
After a few months of dual booting Windows XP and SuSE Linux 10.2, and feeling rather bifurcated by the workflow, I've finally hit upon my perfect setup.
I love smooth workflows, efficient practices and logical progressions. Before I worked with Drupal I'd gotten my workflow highly refined.
- define/clarify site needs and functionality (work with client, share proposals, present wire frames)
- produce a workable, extendable data model (usually in the form of a relational database)
- code business logic (usually a PHP app)
- design interface and presentation layer (XHTML and CSS)
- test and debug
- reiterate back through this process as necessary for maturity
I'd looked for an equivalent to Find and Replace to use within SQL statements in MySQL for a while, and it wasn't until a few months ago that I came across the replace() string function. For whatever reason, I didn't find mention of this function or its application as easily as I would have liked, so perhaps this post will help the next guy or gal become aware of it.
Having to traverse file system paths repeatedly (a common task facing web developers) is the virtual equivalent of lugging sacks of groceries up flights of stairs.
The scenario is this: a client emails a file ("Post this PDF on our site."). You choose to save the file and a dialog box opens either in My Documents or the last location you saved a file in this manner - perhaps another client's folder. So you start clicking. Let's go back to C:, then to "Program Files", to "Apache Group", then to "Apache 2" and ... so on ... and finally to "site-documents."