sqlite_functions

Build

mkdir build
cd build
cmake -DCMAKE_BUILD_TYPE:STRING=Debug|Release ../sqlite_functions
make -j`nproc`

Examples

Distance

# First = Munich, Second = Berlin
SELECT DISTANCE(48.1375, 11.575, 52.5167, 13.3833) AS distance;
# distance = 504.100899610028

Transliteration

# Katakana
SELECT TRANSLITERATION('パイナップル') AS transliterated;
# transliterated = painappuru

Phone Book

# SQL DATA
# name
# Игорь Фёдорович Стравинский # Igor' Fëdorovič Stravinskij
# 宮崎 駿 # Hayao Miyazaki
# 艾未未 # Ai Weiwei
# 오미주 # Sandra Oh
# パイナップル # Painappuro
# Albert Einstein # Albert Einstein
# Zebra # Zebra
# Without TRANSLITERATION
SELECT name FROM phone_book ORDER BY LOWER(name);
# Albert Einstein # Albert Einstein
# Zebra # Zebra
# Игорь Фёдорович Стравинский # Igor' Fëdorovič Stravinskij
# パイナップル # Painappuro
# 宮崎 駿 # Hayao Miyazaki
# 艾未未 # Ai Weiwei
# 오미주 # Sandra Oh
# With TRANSLITERATION
SELECT name FROM phone_book ORDER BY LOWER(TRANSLITERATION(name));
# 艾未未 # Ai Weiwei
# Albert Einstein # Albert Einstein
# 宮崎 駿 # Hayao Miyazaki
# Игорь Фёдорович Стравинский # Igor' Fëdorovič Stravinskij
# 오미주 # Sandra Oh
# パイナップル # Painappuro
# Zebra # Zebra

Helper

Functions

Function Extensions