August, 2018

Sunday’s are for schemacrawling

Sunday’s are for schemacrawling

I love looking at database schema diagrams – and last Sunday I came across Schemacrawler. Getting it up and running all went pretty smoothly. I downloaded the zip file from here You also need to install GrahpViz. References: http://www.schemacrawler.com/diagramming.html Output your database schema To output a pdf of the schema:

To output a png of the schema:

A rainy saturday spent with SQLite

A rainy saturday spent with SQLite

I’d been meaning to get my mits on SQLite for some time and finally found a good project to do so. Installing SQLite I’m on ubuntu so the following got things sorted for me:

I then noticed I was getting the following 

I needed to install the following as per this post and restart my web server

Check SQLite is installed

Finally, some working php code While I won’t share my production code with you, here’s what I can share References: https://www.tutorialspoint.com/sqlite/sqlite_php.htm https://www.digitalocean.com/community/tutorials/how-and-when-to-use-sqlite As per the tutorial above, I created the WINES table and populated it:…

Last run to Savanakhet

Last run to Savanakhet

Is there anything worse than traveling when sick? Yes – being in Laos and not being able to imbibe the glorious local beer on offer there. And so it was when I had another early morning departure from Don Meung, flying into Ubon Ratchatani under cloudy skies. I took the Nok Air ‘fly and ride’ service and traveled to Mukdahan by van along with one other passenger – luxury! From the Ploy Palace hotel I grabbed a quick energy drink which I chugged in the back of a tuk-tuk bound for the Friendship Bridge II before crossing the border into…

Long Gone – Remembering Oz

Long Gone – Remembering Oz

Bizarre travel plans are dancing lessons from God. Wow – four years have passed since I was last in Australia. With some cash in my pocket (how times have changed!) I took my new bride Down Under to visit my homeland. It was a long (5 weeks) and expensive trip, but she got to see a fair bit in her first visit. Our overall itinerary went something like this: Bangkok to Darwin via Singapore.  SQ975 and SQ5203. (Arrived 28 June, 2018). Stayed 2 nights at The Cav and 4 nights at Palm City Resort Darwin to Sydney (3 July, 2014)…