# SQLiteEntityStore

> **Class** in `langchain_classic`

📖 [View in docs](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore)

SQLite-backed Entity store with safe query construction.

## Signature

```python
SQLiteEntityStore(
    self,
    session_id: str = 'default',
    db_file: str = 'entities.db',
    table_name: str = 'memory_store',
    *args: Any = (),
    **kwargs: Any = {},
)
```

## Parameters

| Name | Type | Required | Description |
|------|------|----------|-------------|
| `session_id` | `str` | No | Unique identifier for the session. (default: `'default'`) |
| `db_file` | `str` | No | Path to the SQLite database file. (default: `'entities.db'`) |
| `table_name` | `str` | No | Name of the table to store entities. (default: `'memory_store'`) |
| `*args` | `Any` | No | Additional positional arguments. (default: `()`) |
| `**kwargs` | `Any` | No | Additional keyword arguments. (default: `{}`) |

## Extends

- `BaseEntityStore`

## Constructors

```python
__init__(
    self,
    session_id: str = 'default',
    db_file: str = 'entities.db',
    table_name: str = 'memory_store',
    *args: Any = (),
    **kwargs: Any = {},
)
```

| Name | Type |
|------|------|
| `session_id` | `str` |
| `db_file` | `str` |
| `table_name` | `str` |


## Properties

- `session_id`
- `table_name`
- `conn`
- `model_config`
- `full_table_name`

## Methods

- [`get()`](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore/get)
- [`set()`](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore/set)
- [`delete()`](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore/delete)
- [`exists()`](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore/exists)
- [`clear()`](https://reference.langchain.com/python/langchain-classic/memory/entity/SQLiteEntityStore/clear)

## ⚠️ Deprecated

Deprecated since version 0.3.1.

---

[View source on GitHub](https://github.com/langchain-ai/langchain/blob/51e954877efd2d2c3c5bf09364dcfec8794eadb0/libs/langchain/langchain_classic/memory/entity.py#L335)