Skip to content

Latest commit

 

History

History
197 lines (128 loc) · 5.05 KB

remote-querying.md

File metadata and controls

197 lines (128 loc) · 5.05 KB

Remote Querying

TT-NN Visualizer includes the option to remotely query reports instead of syncing them to the local machine.

Requirements

glibc=>2.28.0 (`ldd --version`)
sqlite3=>3.38.0 (`sqlite3 --version`)

If your machine already has SQLite3 installed you can simply use the path provided by the command which sqlite3.

If you do not have SQLite3 installed you can download the SQLite3 binary, extract it and use the path. For instance:

/home/user/bin/sqlite3

Installing SQLite 3.38 on Ubuntu 18.04 and 20.04

This guide provides two methods for installing SQLite 3.38 on Ubuntu 18.04 and 20.04, depending on the version available in the official repository.

Option 1: Install from Official Repository

  1. Update the Package List Update your system’s package list to check for the latest versions.

    sudo apt-get update

  2. Install SQLite Install the latest version of SQLite available in the repository.

    sudo apt-get install -y sqlite3

  3. Verify the Installed Version Confirm the installed version of SQLite meets the 3.38 requirement.

    sqlite3 --version
    • If the installed version is 3.38 or higher, your setup is complete.
    • If the installed version is older than 3.38, proceed to Option 2 to download a pre-compiled binary or Option 3 to build from source.

Option 2: Downloading SQLite Binary on a Remote Linux Machine

This guide provides instructions for downloading the SQLite binary on a remote Linux machine. The instructions include determining your operating system architecture and using wget or curl to download the appropriate binary.

Step 1: Determine System Architecture

First, determine the architecture of your Linux system. This is important to ensure you download the correct SQLite binary.

uname -m
  • x86_64 indicates a 64-bit architecture.
  • i386 or i686 indicates a 32-bit architecture.
  • aarch64 indicates a 64-bit ARM architecture.

Step 2: Download the SQLite Binary

Visit the SQLite Download Page to find the latest version. Copy the link for the appropriate precompiled binary for your architecture.

Example Download Using wget

Replace <url> with the URL of the SQLite binary, e.g. https://sqlite.org/2024/sqlite-tools-linux-x64-3470000.zip

wget <url> -O sqlite3.tar.gz
Example Download Using curl

Replace <url> with the URL of the SQLite binary:

curl -o sqlite3.tar.gz <url>

Step 3: Extract the SQLite Binary

Once downloaded, extract the binary:

tar -xzf sqlite3.tar.gz

This will create a folder with the SQLite binary inside. You can move it to a directory in your home folder to avoid needing root permissions:

mv sqlite3 ~/bin/

Make sure the bin directory exists and add it to your PATH if not already done:

mkdir -p ~/bin
echo 'export PATH="$HOME/bin:$PATH"' >> ~/.bashrc
source ~/.bashrc

Step 4: Verify the Installation

After the binary is moved and made executable, verify that SQLite is properly installed:

sqlite3 --version

This command should output the version of SQLite, confirming the installation was successful.

Troubleshooting

  • If wget or curl is not installed, you can install them using your system's package manager (e.g., sudo apt-get install wget for Debian-based systems). If you do not have sudo permissions, consider asking your system administrator.

  • Ensure that the ~/bin directory is included in your PATH by running:

    echo $PATH

  • If sqlite3 is not found, ensure you have reloaded your .bashrc file with source ~/.bashrc.

Option 3: Build from Source (If Official Repository Version Is Outdated)

If your system’s apt-get package does not include SQLite 3.38 or later, follow these steps to install it from source.

Step 1: Update and Install Build Dependencies

sudo apt-get update
sudo apt-get install -y build-essential wget libreadline-dev

Step 2: Download SQLite 3.38 Source Code

  1. Navigate to a Download Directory Move to a directory where you’d like to download the source code.

    cd /tmp

  2. Download the SQLite 3.38 Source Code Fetch the source code for SQLite 3.38.

    wget https://www.sqlite.org/2022/sqlite-autoconf-3380000.tar.gz

  3. Extract the Tar File Unpack the downloaded source archive.

    tar -xzf sqlite-autoconf-3380000.tar.gz
cd sqlite-autoconf-3380000

Step 3: Compile and Install SQLite

  1. Configure the Build Prepare the build environment.

    ./configure --prefix=/usr/local

  2. Compile SQLite Build SQLite from the source code.

    make

  3. Install SQLite Install the compiled program.

    sudo make install

Step 4: Verify the Installed Version

Finally, confirm the installation of SQLite 3.38.

sqlite3 --version

You should now have SQLite 3.38 installed on your system.