Problem: Find key-value pairs separated by : but ignore escaped colons, i.e. \:. Solution: Negative lookbehinds – see Regex Tutorial – Lookaheads and Lookbehinds. “Positive” means “must match”, “Negative” means “must not match”. Over here, we are “looking behind” the backslash to ensure that a colon is not matched. Single match in a string: <?php …
This executes a shell command in Scala and returns the actual server IP instead of 127.0.0.1 or the domain name of the host. #| is used to simulate piping of commands. Process and Seq are used for awk as $NF will lead to compilation errors otherwise. The actual shell command is: ip route get 8.8.8.8 …
Continue reading “Get port and actual server IP in Scala or Play Framework 2.x”
For future reference…after spending quite some time figuring it out 😛 package models; import com.avaje.ebean.Model; import com.avaje.ebean.Query; import play.Logger; import play.data.validation.Constraints; import java.util.Date; import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = “my_table”) public class MyModel extends Model { @Id public Long id; @Column(name = “name”) public String name; @Constraints.Required @Column(name …
Continue reading “Using COALESCE and logging SQL string in Play Framework 2.x”
Have you ever come across an Excel spreadsheet where the serial numbers are not in sequence? Well I have 😛 It’s not as simple as putting 1 in cell A1, =A1+1 in cell A2, and copying the formula to the subsequent cells. Sometimes you may insert/delete a row, move some rows, insert section headers and …
Correct me if I’m wrong, but I’m going to start off this post with this assumption: the usual working hours for a typical office job is 9am to 6pm, with an hour of lunch break in between. The start and end times may vary, but it’s still 8 working hours plus 1 hour lunch. The …
Continue reading “Is There Value in Meetups and Conferences?”
Was reminded of Paul Graham’s 2009 blog post “Maker’s Schedule, Manager’s Schedule” recently. The article sums up why programmers dislike meetings and if I may add, anything that disrupts their intense train of thought while programming – phone calls, incoming Skype chats, reports, etc. Before I blabber on, let’s play a simple game to help …
Was preparing my personal budget Excel workbook for next year. It contains a Summary worksheet and a worksheet for each month of the year. Copied this year’s workbook, renamed it and thought there must be a better way to clear the month worksheets and set recurring expenses. So I wrote 3 Excel VBA procedures (1 …
Continue reading “Clear worksheets and set rows using Excel VBA macros”
Writing this down after almost pulling my hair out in grappling with the correct syntax as it has been a long while since I coded macros in Excel. To start dabbling with macros in Excel 2013, go to File > Options > Customize Ribbon and tick the checkbox for the Developer tab on the right …
This is a follow-up to Part 1: Creating the app. Forgot to mention that the app was made for iPhone only and not an universal app. I did not want to grapple with sizing on the iPad and besides, we don’t usually carry around iPads during evangelism unlike our phones. This post will talk about …
Continue reading “My 1st app – Part 2: Testing and submitting the app”
Submitted my app to Apple for review a few days ago (Tue 01 Dec 2015). It was programmed in Swift 2.0 using Xcode 7.1.1 on a 12-inch MacBook running OS X El Capitan (version 10.11.1). This post is to chronicle my journey, thought process and workflow, for future reference and in the hope that it …
