pg-cache 0.1.1

A caching package with both synchronous and asynchronous support for PostgreSQL.

PgCache

PgCache is a synchronous caching library based on PostgreSQL, using SQLAlchemy for database operations.

Installation

First, ensure you have installed the required dependencies:

pip install sqlalchemy psycopg2

Usage

Initializing the Cache

import logging
from pg_cache.sync_cache import PgCache  # Assuming the synchronous version class file is sync_cache.py

DATABASE_URL = "postgresql://username:password@localhost:5432/dbname"


def main():
    cache = PgCache(DATABASE_URL, "cache_table", log_level=logging.ERROR)

    # Initialize the database
    cache.init_db()

    # Set cache
    cache.set("test_key", {"foo": "bar"}, expire_after_seconds=60)
    print("Set cache entry")

    # Get cache
    value = cache.get("test_key")
    print(f"Got cache entry: {value}")

    # Delete cache
    cache.delete("test_key")
    print("Deleted cache entry")

    # Get deleted cache
    value = cache.get("test_key")
    print(f"Got cache entry after deletion: {value}")


if __name__ == "__main__":
    main()

Method Descriptions

__init__(self, db_url: str, table_name: str, log_level: int = logging.ERROR)

Initialize a PgCache instance.

• db_url: Database connection string.
• table_name: Name of the cache table.
• log_level: Log level, default is logging.ERROR.

init_db(self) -> None

Initialize the database and create the cache table.

set(self, key: str, value: Any, expire_after_seconds: int = 86400) -> None

Set a cache entry.

• key: Cache key.
• value: Cache value, can be any type of data.
• expire_after_seconds: Cache expiration time in seconds, default is 86400 seconds (1 day).

set_bulk(self, entries: List[Dict[str, Any]], expire_after_seconds: int = 86400) -> None

Set multiple cache entries in bulk.

• entries: List of multiple cache entries, each entry is a dictionary containing key and value.
• expire_after_seconds: Cache expiration time in seconds, default is 86400 seconds (1 day).

get(self, key: str) -> Optional[Any]

Get a cache entry.

• key: Cache key.
• Return value: Cache value, if the cache entry does not exist or has expired, returns None.

delete(self, key: str) -> None

Delete a cache entry.

• key: Cache key.

flushdb(self) -> None

Clear all cache entries.

export_to_file(self, file_path: str) -> None

Export cache entries to a file.

• file_path: Path to the export file.

import_from_file(self, file_path: str) -> None

Import cache entries from a file.

• file_path: Path to the import file.

Example

Here is a complete example demonstrating how to use the PgCache class:

import logging
from pg_cache.sync_cache import PgCache  # Assuming the synchronous version class file is sync_cache.py

DATABASE_URL = "postgresql://username:password@localhost:5432/dbname"


def main():
    cache = PgCache(DATABASE_URL, "cache_table", log_level=logging.ERROR)

    # Initialize the database
    cache.init_db()

    # Set cache
    cache.set("test_key", {"foo": "bar"}, expire_after_seconds=60)
    print("Set cache entry")

    # Get cache
    value = cache.get("test_key")
    print(f"Got cache entry: {value}")

    # Delete cache
    cache.delete("test_key")
    print("Deleted cache entry")

    # Get deleted cache
    value = cache.get("test_key")
    print(f"Got cache entry after deletion: {value}")


if __name__ == "__main__":
    main()

License

This project is licensed under the MIT License.