- Most Recent | Since 2004
- List View
- Archive
- September 20, 2011
From Database Table to Layout
September 20, 2011Read moreOne 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…)
- September 20, 2011
PSEC: Designing HTML/CSS Widgets
September 20, 2011Read moreNow 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
- September 19, 2011
PSEC: Creating MySQL Tables in WordPress
September 19, 2011Read moreSUMMARY: 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…) - September 19, 2011
SQL Crash Course
September 19, 2011Read moreSUMMARY: 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…)
- September 19, 2011
30 Seconds to Anything
September 19, 2011Read moreEditor’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 :)
