SQL and datetime from unix (epoch) time
from here: SQLite SELECT datetime(MyColumn, “unixepoch”, “localtime”) FROM MyTable MySQL SELECT from_unixtime(MyColumn) FROM MyTable
Archive of entries posted by user
Virtual Box – Shared folders on Ubuntu Guest
Well, the first thing to make sure is that Guest Additions are correctly installed. For example, on Ubuntu 16.04 guest on VirtualBox 5.0.32 r112930 I received a message that the kernel headers were not found (even though they did exist). This was fixed with: sudo apt-get install dkms Next problem was constantly receiving a protocol …
Continue reading ‘Virtual Box – Shared folders on Ubuntu Guest’ »
Creating an iOS push certificate PEM file
in the Apple developer console: Create a development iOS certificate of type “APNs Development iOS” – this is a certificate used to connect between your entity that sends the push (e.g a php script on a server or some other app) and the APN development (sandbox) gateway that delivers the push to the remove iOS …
Continue reading ‘Creating an iOS push certificate PEM file’ »
Quick ReactJS native environment setup on OS/X
First, install XCode Also install brew (brew.sh) Then, from the command line brew install node brew install watchman npm install -g react-native-cli to generate a new project, from the command line react-native init myproj The above will create a basic React native template (it can take a few minutes, lots of megabytes involved…). When complete …
Continue reading ‘Quick ReactJS native environment setup on OS/X’ »
Ubuntu 14.04 not seeing Wifi Networks
I installed a fresh Ubuntu 14.04 on an old MacAir (how to do that is explained here) and took me hours to get it to see the Wifi networks. There were many suggestions on many sites but the solution that finally worked for me was Hadaka’s answer from ubuntuforums Just for information, check your pci …
DNS not resolving on Ubuntu 14.04 server
This article exaplains how it is done for Ubuntu 12.04 Basically, just add your list of DNS name servers for eth0 in the /etc/network/interfaces file: dns-nameservers X.X.X.X Y.Y.Y.Y Z.Z.Z.Z and don’t forget to sudo ifdown eth0 && sudo ifup eth0
Cordova – update all plugins in project
A quick hack to update all the Cordova plugins used in a Cordova project. Next hack will be updating all Cordova platforms… From the Cordova project run the following (unix shell required): cordova plugins | grep -Eo ‘^[^ ]+’ | while read line do echo "cordova plugin remove $line" echo "cordova …
Continue reading ‘Cordova – update all plugins in project’ »
Generating call graphs with Doxygen
Obviously you should first download and install Doxygen Next, you should download and install Graphviz which will install the dot tool in a nutshell, you create the documentation by running: doxygen my_conf_file Where my_conf_file contains all the required parameters for the generated documentation. If you use the doxygen wizard from the UI, a configuration file …
Adding user on MySQL
This will be put here until I create a page of all those things that should be put on one cheat sheet… CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; FLUSH PRIVILEGES;
Delacorte Numbers
There really isn’t such a mathematical term – it was introduced at the latest Al Zimmermann’s Programming Contests and is defined in the contest rules (at azpcs.net – site should be back up around mid December January, a replacement is currently up at trdb.org ). As I’m participating in this contest and have created some …