Scenario: Broadband modem and primary router located on 1st floor. PC and network printer on 1st floor connected to primary router. Ethernet cable from LAN port 4 of primary router laid from 1st floor to 2nd floor and connected to a Mac on the 2nd floor. Additional cable needed on 2nd floor for a new …
Continue reading “Adding a secondary router with Wi-Fi and staying on the same subnet”
Reference: http://stackoverflow.com/questions/3164505/mysql-insert-record-if-not-exists-in-table/#3164741 Supposing we have a database table named distributor and we wish to insert a record only if there is no existing record with the same name and country code. The table only has a PRIMARY key but no UNIQUE index on (name, country_code) – think “legacy” and “no privileges to modify database” 😛 …
Continue reading “Insert record only if it does not exist in table without unique index”
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 …
