Skip to content

Instantly share code, notes, and snippets.

View k4kabirmalik's full-sized avatar
💭
I may be slow to respond.

Kabir Malik k4kabirmalik

💭
I may be slow to respond.
1 follower · 0 following
View GitHub Profile
@k4kabirmalik
k4kabirmalik / CurrencyMeta.sql
Last active September 11, 2025 13:06
List of all currency with country, currency name, ISO codes, symbols, symbol position, layout direction in SQL format
CREATE TABLE CurrencyMeta (
Country TEXT NOT NULL,
CurrencyName TEXT NOT NULL,
ISOCodeAlpha2 CHAR(2) NOT NULL,
ISOCodeAlpha3 CHAR(3) NOT NULL,
Symbol TEXT,
SymbolPosition TEXT CHECK (SymbolPosition IN ('prefix', 'postfix')) DEFAULT 'prefix',
LayoutDirection TEXT CHECK (LayoutDirection IN ('LTR', 'RTL')) DEFAULT 'LTR',
DecimalPlaces INTEGER DEFAULT 2,
@k4kabirmalik
k4kabirmalik / currencies.json
Last active September 11, 2025 10:48
List of all currency with country, currency name, ISO codes, symbols, symbol position, layout direction, decimal places in JSON format
{
"currencies": [
{
"country": "Afghanistan",
"currencyName": "Afghani",
"isoCodeAlpha2": "AF",
"isoCodeAlpha3": "AFN",
"symbol": "؋",
"symbolPosition": "prefix",
"layoutDirection": "RTL",
@k4kabirmalik
k4kabirmalik / CountryPhone.json
Last active June 6, 2026 23:49
List of all the country with name, iso codes and phone code in JSON format
{
"phoneCodes": [
{
"country": "Afghanistan",
"isoCodeAlpha2": "AF",
"isoCodeAlpha3": "AFN",
"phoneCode": "+93"
},
{
"country": "Albania",
@k4kabirmalik
k4kabirmalik / CountryPhone.sql
Created June 6, 2026 23:51
List of all the country with name, iso codes and phone code in SQL format
-- Create table for country phone codes
CREATE TABLE CountryPhone (
Country TEXT NOT NULL,
ISOCodeAlpha2 CHAR(2) NOT NULL,
ISOCodeAlpha3 CHAR(3) NOT NULL,
PhoneCode TEXT NOT NULL,
UNIQUE (Country, ISOCodeAlpha3)
);
-- Insert all phone code records