# Article Archive

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

## October 2016

## 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

## March 2014

## August 2012

## July 2012

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

## October 2011

## September 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

## 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