# Article Archive

Below you can find an archive of articles, written for www.xarg.org.

## July 2021

## February 2019

## January 2019

## July 2018

## April 2018

## February 2018

## January 2018

## December 2017

## August 2017

## July 2017

- Operate a Syma S107G Remote Control Helicopter with an Arduino
- How to map a Square to a Circle
- Using Gamepads in JavaScript via node.js
- Set up Internet Sharing on Mac OSX using Command Line Tools

## June 2017

## December 2016

## November 2016

## October 2016

- Derivation of Pagination Calculation
- Calculate the intersection point of two Lines
- Calculate the Tangent Line of a Circle

## July 2016

- How to write a PHP Daemon
- Calculate the intersection area of two circles
- Improving Interval Conditions
- Calculate the intersection points of two Circles
- Store a tag-cloud in MySQL
- Simultaneously set and delete bit flags in a database
- Using GPS with node.js and JavaScript
- Calculate the argmin of the sum of absolute values
- Complex numbers in JavaScript

## June 2016

- Cracking Apple Interview Question
- The log-sum-exp trick in Machine Learning
- Importing entire Wikipedia into MySQL
- Calculate the sum of divisors
- Forcing Garbage Collection in node.js and JavaScript
- NEO6MV2 GPS Module with Raspberry PI
- NEO6MV2 GPS Module with Arduino

## April 2016

## June 2014

## March 2014

- Set Excel columnWidth Property in Points with VBA
- DIY Ohmmeter to Measure Resistor values with Arduino
- Rational numbers in JavaScript
- JavaScript Bit Array

## August 2012

## July 2012

- Optimal index size for variable text in MySQL
- Statistical functions in MySQL
- MySQL Infusion UDF for statistical analysis

## June 2012

## October 2011

## September 2011

## July 2011

## June 2011

## January 2011

- Find friends of friends using MySQL
- Create a simple and small GIF with PHP
- Is it possible to avoid query parsing inside of MySQL?

## November 2010

## September 2010

## July 2010

## June 2010

- Combine CSS and JavaScript with lighttpd
- Optimized way of getting subqueries at once using JSON
- Design a developer friendly web
- Is an angle between two other angles?
- Disable ON UPDATE CURRENT_TIMESTAMP in MySQL
- Analyze online behavior with MySQL and PHP

## May 2010

## April 2010

- Optimizing integer multiplication
- Dynamic thumbnail generation on the static server
- Calculate date ratios
- Write data asynchronously to MySQL

## March 2010

## February 2010

- My very first Chrome experiment
- Reduce the length of a line segment by a certain amount
- PHP twitter API

## December 2009

- MySQL Wishlist
- Sorted Array to MySQL
- Fulltext GEO Search with MySQL
- Handy PHP classes
- Debian lighttpd startup script
- Field size as power of two
- Age calculation with MySQL
- My way
- People near you with MySQL
- PHP Enhancement
- Store small numbers in big numbers