Blog

  • From Database Table to Layout

    September 20, 2011

    One of my current projects is learning how to write a good web application. For the past week or so, I’ve been focused on the back-end (i.e. the server and database programming), but now I’m at the point where it’s time to think of the front end. (more…)

    Read more
    DSri Seah
  • PSEC: Designing HTML/CSS Widgets

    September 20, 2011

    Now that I have some rudimentary SQL stuff going on in my WP theme, it’s time to get back to the front-end. My goal is to have a new home page for my web browser with all my tasks listed on it. This is a start.

    I’ve partially-modeled what a task looks like in the database schema. What does it look like on the screen? Time to do a bit of design. Continue on via the design process journal

    Read more
    DSri Seah
  • PSEC: Creating MySQL Tables in WordPress

    September 19, 2011

    SUMMARY: A first stab at establishing a workable database schema for storing tasks. Learned how to use WordPress’ dbDelta() function to create and modify tables in the database. Figured out the basic SQL statements to create tables with the appropriate data types and indexes. (more…)

    Read more
    DSri Seah
  • SQL Crash Course

    September 19, 2011

    SUMMARY: Reviewing basic SQL by datatypes and built-in functions. Groking joins, indexes, normalization, and syntax. Wrapped head around how a database is implemented and how it’s used. (more…)

    Read more
    DSri Seah
  • 30 Seconds to Anything

    September 19, 2011

    Editor’s note: In honor of TALK LIKE A PIRATE DAY, today’s post has been pirate-speaked!

    One o’ me productivity-killin’ attitudes be th’ great loathin’ I be havin’ fer physically fetchin’ things. If I I dasn’t be havin’ th’ pair o’ scissors / socks / wrench / gadget I need ready, then I lose momentum an’ focus. One o’ th’ most difficult things fer me t’ do be t’ mail a physical package, as ‘t requires so much fetchin’ that I nereget around t’ doin’ ‘t. I finally mailed a package t’ Dad, fer example, an’ ‘t tookst me about…goodness, about six moons. Embarrassin’!

    Wi’ me recent thoughts on maintainin’ a positive attitude, however, I`ve been timing how long things take. That turns th’ chore into an experiment, which transform a chore into a quantifiable datapoint. As I wrote recently on me Facebook Page a wee tides ago, I be surprised at how wee time ‘t tookst t’ do two annoyin’ tasks: filin’ bill statements an’ shreddin’ checks. I let these pile up sometimes fer moons, but when timed ‘t tookst less than two minutes per task.

    This mornin’ I be sittin’ down at th’ dinin’ room table t’ fiddle wi’ somethin’, an’ noticed that th’ table needed t’ be wiped. That required: PAPER TOWEL an’ WINDEX. I also reckoned I needed PAIR O’ SCISSORS from downstairs an’ WALLET from upstairs. I felt th’ familiar inner groan an’ urge t’ go do somethin’ else, but instead I started countin’ seconds in me hade. I sailed’ upstairs an’ downstairs an’ then t’ th’ galley, an’ th’ average time be under 30 seconds. Jus’ about anythin’ in th’ house be accessible t’ me, gi’en that I know ‘ere ’tis, in about 30 seconds. Which makes me feel silly an’ dumb fer bein’ such a baby about fetchin’ things, but lookin’ fore I can be seein’ much more fetchin’ in me future :)

    Read more
    DSri Seah