langchain-google-el-carro 0.2.0

Known Limitations

• The library supports El Carro Operator for Oracle 18c and higher versions.

• By default the library uses thin mode. for Oracle connectivity, to use thick mode please follow the corresponding section..

• To use VARCHAR2 datatype of size more than 4000 please change the parameter MAX_STRING_SIZE. in the Oracle instance.

Quick Start

pip install virtualenv
virtualenv <your-env>
source <your-env>/bin/activate
<your-env>/bin/pip install langchain-google-el-carro

pip install virtualenv
virtualenv <your-env>
<your-env>\Scripts\activate
<your-env>\Scripts\pip.exe install langchain-google-el-carro

from langchain_google_el_carro import ElCarroEngine
from langchain_google_el_carro.loader import \
    ElCarroLoader, ElCarroDocumentSaver

elcarro_engine = ElCarroEngine.from_instance(
    "Your El Carro endpoint hostname", # e.g. 127.0.0.1
    "Your El Carro endpoint port", # e.g. 3307
    "Your PDB name",  # e.g. PDB1
    "Your DB user",
    "Your DB password",
)
loader = ElCarroLoader(
    elcarro_engine,
    table_name="my-table-name"
)
docs = loader.lazy_load()

Chat Message History Usage

Use ChatMessageHistory to store messages and provide conversation history to LLMs.

from langchain_google_el_carro import ElCarroEngine
from langchain_google_el_carro.chat_message_history import \
    ElCarroChatMessageHistory

elcarro_engine = ElCarroEngine.from_instance(
    "Your El Carro endpoint hostname", # e.g. 127.0.0.1
    "Your El Carro endpoint port", # e.g. 3307
    "Your PDB name",  # e.g. PDB1
    "Your DB user",
    "Your DB password",
)
history = ElCarroChatMessageHistory(
    elcarro_engine=elcarro_engine,
    table_name="my-message-store",
    session_id="my-session_id"
)

See the full Chat Message History tutorial.

Oracle Thick Mode Connectivity

Thick mode connectivity requires you to install the Oracle Client libraries and pass thick_mode=True to ElCarroEngine. Follow these sections of the oracledb installation guide:

• Oracle Instant Client Zip Files

• Oracle Instant Client RPMs

Example for Linux x64, glibc 2.14+:

wget https://download.oracle.com/otn_software/linux/instantclient/2113000/instantclient-basic-linux.x64-21.13.0.0.0dbru.zip -O /tmp/drv.zip
rm -fr /tmp/instantclient_21_13/; unzip /tmp/drv.zip -d /tmp
export LD_LIBRARY_PATH=/tmp/instantclient_21_13/:$LD_LIBRARY_PATH

License

Apache 2.0 - See LICENSE for more information.

Disclaimer

This is not an officially supported Google product.