Red letter day, black heart
How the fuck did i forget about this track. Played the shit out it it back in the day.
Posts by: TheCra1gster
Tuning fpm-php: Not for the faint of heart
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
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:
|
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:
|
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
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:
|
1 |
sudo apt-get install sqlite3 libsqlite3-dev |
I then noticed I was getting the following
|
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
|
1 |
sudo apt-get install php5-sqlite |
Check SQLite is installed
|
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
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
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)…
Beer porn: A pilgrimage to Plzeň
There’s an old Czech joke which goes something like this: A kid walks into a bar and asks for a beer. The bartender says “wouldn’t you rather have a lemonade?” “Yeah”, the kid replies, “but I’m three crowns short” Welcome to the Czech Republic – the country where beer costs less than water. A few months back I needed to get out of Thailand for a while. The heat, the wife, and the bad beer had all conspired to plunge me into the depths of despair – it was time to escape long enough to clear my head. Being a…
Happy Hour Whores
We’ve discovered a nice little roof-top bar close to the crib. No, I won’t share the location with you as I want to keep it all to myself for the next few months (along with all the Chinese tourists, of course!) Their 2 for 1 drink deal includes a couple of local beers and some cocktails, so we tucked into Heineken for 60 odd baht a glass and Long Island Iced Teas for 120. Don’t forget the ++ (10% service charge and 7% VAT) which adds nearly 20% to the bill – don’t tip as you are already paying one!…
Praise the Lord – A weekend escape to Ban Chang
The only upside to us now having a car is weekend getaways have become a thing. A good thing. Last weekend we headed to Ban Chang, a few hours drive south-east of Bangkok. Having booked into the Lord Nelson Hotel, we wasted no time in heading for the bar after checking-in. It’s a great little hotel, with a beaut ocean-front bar. Somehow the beers taste a little better when looking out at the ocean on a sunny afternoon. I’m not sure why. Probably because relaxation had taken hold. After a kick-ass English breakfast on Saturday morning, we headed to Khao…
Soaking up the last few days in the Czech Republic
Back in Bangkok for a week, I’ve had some time to reflect on my time away. It was a good trip, nice to escape the heat of Thailand but I’m glad to be home, and I really missed the wife. More than I thought I would. Item THB EUR Flights 37,500 1,002 Travel Insurance 970 26 Trains & Buses 1,084 29 Food & Drink 22,400 600 Accommodation 11,855 317 Total THB 73,809 EUR 1,974 I managed to keep costs under control and came back with € 175 which was converted to much needed Thai Baht. All up I spent just…