JQL ⚙️

It combines SQL's speed and JSON's flexibility.

SQL + JSON = JQL ⚙️

All JQL tables have two columns, Key and Value, value is json.

📚 Examples

✏️ Write

jql("my_database.db").write("eikosa.books.literature.dosteyovsky","")

Value is:

{
    "books": {
        "literature": {
            "dosteyovsky": ""
        }
    }
}

jql("my_database.db").write("eikosa.books.literature.tolstoy","")

Returns:

{
    "books": {
        "literature": {
            "dosteyovsky": "",
            "tolstoy": ""
        }
    }
}

📖 Read

jql("my_database.db").read("eikosa.books.literature")

Returns:

{'dosteyovsky': ''}

🗑 Delete Path Element

jql("my_database.db").del("eikosa.books.literature.tolstoy")

Before:

{
    "books": {
        "literature": {
            "dosteyovsky": "",
            "tolstoy": ""
        }
    }
}

After:

{
    "books": {
        "literature": {
            "dosteyovsky": ""
        }
    }
}

jql("my_database.db").del("eikosa.books.literature")

Before:

{
    "books": {
        "literature": {
            "dosteyovsky": "",
            "tolstoy": ""
        }
    }
}

After:

{
    "books": {}
}

💥 Delete Value

jql("my_database.db").delete_key("eikosa")