DBA Blogs
to_char a big number insert into database become scientific notation
Explain plan estimate vs actual
Embedding Machine Learning Models in the Oracle Database: Create an ONNX model
This post is the first of a three-part series where I’m going to show you how to use pre-configured […]
The post Embedding Machine Learning Models in the Oracle Database: Create an ONNX model appeared first on DBASolved.
Video on Client Side Failover in RAC
Catastrophic Database Failure -- Deletion of Control and Redo Files
Is 'SELECT * FROM :TABLE_NAME;' available?
Is fragmentation an issue ?
Does Migrating 4k Tablespace block size to 8k database cause performance impact ?
Restore from Archivelog only
Returning data in EXECUTE IMMEDIATE with dynamic values in USING clause
19c doesn't allow truncation of data that is longer in length of column's char(40) definition
AnythingLLM - Any LLM, Any Document, Full Control, Full Privacy, Local, Secure
This video shows how to locally install AnythingLLM to privately and securly and remotely run any LLM with any RAG document. It all runs locally with zero required internet connectivity.
Oracle to Power BI
Compiling Java class
How to Install OpenDevin Locally
This is a step by step easy tutorial to locally install OpenDevin which is an open-source project aiming to replicate Devin, an autonomous AI software engineer who is capable of executing complex engineering tasks and collaborating actively with users on software development projects.
Commands Used:
Pre-requisites:
Update OS:
sudo apt-get update
Install git:
sudo apt-get install git
Install Nodejs:
sudo apt-get install nodejs
Install npm:
sudo apt install npm
Install Rust:
curl --proto '=https' --tlsv1.3 https://sh.rustup.rs -sSf | sh
Install docker:
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
# Add the repository to Apt sources:
echo \
"deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
$(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \
sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
Install conda:
wget https://repo.anaconda.com/archive/Anaconda3-2022.05-Linux-x86_64.sh
bash Anaconda3-2022.05-Linux-x86_64.sh
Install uvicorn:
sudo apt install uvicorn
Backend Commands:
git clone https://github.com/OpenDevin/OpenDevin.git
cd OpenDevin
conda create -n opendevin python=3.11
conda activate opendevin
docker ps
docker pull ghcr.io/opendevin/sandbox
which python
python --version
/home/ubuntu/anaconda3/envs/opendevin/bin/python -m pip install pipenv
/home/ubuntu/anaconda3/envs/opendevin/bin/python -m pipenv install -v
/home/ubuntu/anaconda3/envs/opendevin/bin/python -m pipenv shell
uvicorn opendevin.server.listen:app --port 3000
Frontend Commands:
python -m pipenv requirements > requirements.txt && python -m pip install -r requirements.txt
PYTHONPATH=`pwd` /home/ubuntu/anaconda3/envs/opendevin/bin/python opendevin/main.py -d ./workspace/ -i 100 -t "Write a bash script that prints 'hello world'"