TheCra1gster | The Cra1gster

Happy New Beer

January 23, 2019
By: TheCra1gster

Looks like we all made it safely to 2019. Hope you had a great Xmas (there I said it – No ‘Happy Holidays’ here my friend.) We decided on a quiet one this time around and headed to the Aussie bar on Sukhumvit Soi 11 for a good time and were not disappointed. Their free BBQ really hit the spot and the drinks were reasonably priced although I’m pretty sure we were over budget when the evening finally wrapped up 🙁 Dragged a few Darwinites along after we bumped into them a week or so earlier at ‘The Clubhouse’ on…

Burger quest: Cast Iron Burgerhaus

December 5, 2018
By: TheCra1gster

A few Saturdays back, the wife dragged me to Ari, a part of Bangkok I had yet to explore. I was happy to wander around while she joined the throngs of women in combat at a shoe sale. Found a great little juice bar where I knocked off a fresh veggie juice for THB 50 – a bargain! Then out of the corner of my eye, I spotted a burger joint, named Cast Iron Burgerhaus. I checked the opening times and being a courteous lad, waited until I collected the wife before heading back there for lunch. Good move! The…

Burger quest: Bad Burger BKK

December 2, 2018
By: TheCra1gster

The quest has begun – to find the best burger in Bangkok. One mandatory stop is Bad Burger BKK, located in a just off Sukhumvit between sois 18 and 20. We hit the place on hump day which also turned out to be Ladies night – 199 THB craft beer pints. Good vibe and a decent crowd in for a Wednesday. We lingered around for close to 3 hours, drank our weight in beer, and were the only ones left by 9.30 PM, before stumbling out to find a taxi home. The beers I opted to get my drinking shoes…

The sun sets on Shashin

November 12, 2018
By: TheCra1gster

It appears the popular Shashin WordPress plugin is no more. Although its developer Mike Toppa stopped supporting the plugin a number of years ago, it has now been pulled from the WP plugin repository and usage documentation seems to have disappeared. No surprise really, as Google has been slowly but surely killing the integration with Picasa after launching Google Photos (Google acquired Picasa in 2004). I’ve blogged about Picasa pain before. https://www.craigamos.rocks/picasa-pain-persisits/ https://www.craigamos.rocks/google-photos/ Additionally, the Picasa desktop application no longer works. Where does that leave the existing user base? The plugin still works for existing Google albums, at least. You…

Red letter day, black heart

September 19, 2018
By: TheCra1gster

How the fuck did i forget about this track. Played the shit out it it back in the day.

Tuning fpm-php: Not for the faint of heart

September 11, 2018
By: TheCra1gster

Another tech Sunday – they never get old 🙂 This is a somewhat long and boring post. More of a tech journal entry. But who knows, maybe someone else will find it interesting. First let’s backtrack a little – what is CGI you ask? source: https://www.irt.org/articles/js184/ An acronym for Common Gateway Interface, CGI was the first implementation of a server-side ‘gateway’ where http could interact with external applications such as databases. Although CGI is language agnostic, typically PERL scripts were used. CGI is rarely used today due to inherent security vulnerabilities. Then there’s fastcgi And then there’s php-fpm (FastCGI process…

Sunday’s are for schemacrawling

August 28, 2018
By: TheCra1gster

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:

 bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db
 -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=pdf

1 2	bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=pdf

To output a png of the schema:

bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db
 -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=png -outputfile=mydb.png

1 2	bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=png -outputfile=mydb.png

A rainy saturday spent with SQLite

August 25, 2018
By: TheCra1gster

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:

 sudo apt-get install sqlite3 libsqlite3-dev

1	sudo apt-get install sqlite3 libsqlite3-dev

I then noticed I was getting the following

 PHP Fatal error:  Class 'SQLite3' not found in /var/www/html/wordpress/testdb.php on line 2

1	PHP Fatal error: Class 'SQLite3' not found in /var/www/html/wordpress/testdb.php on line 2

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

sudo apt-get install php5-sqlite

1	sudo apt-get install php5-sqlite

Check SQLite is installed

php -i|grep sqlite
/etc/php5/cli/conf.d/20-pdo_sqlite.ini,
/etc/php5/cli/conf.d/20-sqlite3.ini,
PDO drivers => mysql, sqlite
pdo_sqlite
sqlite3
sqlite3.extension_dir => no value => no value

1

2

3

4

5

6

7

php -i|grep sqlite

/etc/php5/cli/conf.d/20-pdo_sqlite.ini,

/etc/php5/cli/conf.d/20-sqlite3.ini,

PDO drivers => mysql, sqlite

pdo_sqlite

sqlite3

sqlite3.extension_dir => no value => no value

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

August 25, 2018
By: TheCra1gster

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

August 5, 2018
By: TheCra1gster

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)…

Our trips together

The Serious Stuff

The Ramble

Posts by: TheCra1gster