speich
.net
Why I love PhpStorm: SQL GROUP BY handling
Here’s another post from my series why I love JetBrains PhpStorm. This is a SQL query, where I have I list of column names. The IDE not only marks the columns missing in the GROUP BY clause as errors, it also offers an option to fix it for you by adding them to the GROUP …
Continue reading “Why I love PhpStorm: SQL GROUP BY handling”
Share VPN connection of Windows host with VirtualBox guest
Sharing the VPN connection of your host in VirtualBox works fine with NAT, but not with host only mode. The solution I found on morales-rodriguez.net is simple. Open an admin console on your windows7 host and execute the following: $ VBoxManage list vms Note that uuid or name in parenthesis of your VM and then: …
Continue reading “Share VPN connection of Windows host with VirtualBox guest”
How to auto mount your VirtualBox shared folder to /var/www/
You need to have the Guest Additions installed first, then you can setup a shared folder in the settings, let’s say Websites and mount it to /var/www/html/. Then, inside the virtual machine, add that shared folder Websites to the fstab by adding the line Websites /var/www/html vboxsf rw,uid=33,gid=33 0 0 and giving the right permissions. …
Continue reading “How to auto mount your VirtualBox shared folder to /var/www/”
Setup Lightning to work with Google Calendar
Quick installation guide to setup your Google Calendar in Thunderbird 31.2 with the Lightning Calendar Addon 3.3.1. You don’t even need to install the ‘Provider for Google Calendar’: Create a new calendar by right clicking on the calendar pane, then select ‘On the Network’ Select ‘CalDav’ as you remote calendar format and put the following …
Continue reading “Setup Lightning to work with Google Calendar”
CSS Quick Tip: Line Breaks in Flexbox Multi-line mode
Took my quite a while to find this, because it’s hardly mentioned anywhere except as a note on the Mozilla Developer Network: When you are using a flexbox layout in multi-line mode (e.g. the ‘flex-wrap’ property is set to wrap), you can force flex items to start on a new line by setting the ‘page-break-before’ …
Continue reading “CSS Quick Tip: Line Breaks in Flexbox Multi-line mode”
Best Vector Format to Import/Export in LibreOffice
Quip tip: When creating illustrations with LibreOffice Draw I found the format “Star View Metafile (SVM)” to be the best choice for re-import in LibreOffice Writer.
List of Bird Species from Trip up to Rewa Head
Last year I traveled up to the Rewa River Head in Guyana. On the month long journey I was able to identify the following 104 bird species with the help of our guides:
Power off your SONOS Bridge
If you want to be able to turn off the power of your SONOS components without any hiccups when turning them back on later (e.g. prevent multiple use of the same IP in your local network), it seems advisable to reserve their IP addresses on your router. This is important especially in the case of …
Footwear for the jungle
When planing my trip to Guayana I was wondering what kind of shoes to bring in addition to my Teva Sandals. After reading through numerous blog posts and watching some videos including the excellent one by junglecrafty on Jungle Boots, I decided to buy OTB’s JungleLite Boots.