---
title: "Quick start"
url: "https://docs.yugabyte.com/stable/quick-start/linux/"
---

# Quick start

Get started using YugabyteDB in less than five minutes on Linux.

Get started in less than 5 minutes in the cloud or on your desktop

- [![Cloud Icon](/icons/cloud.svg) Use a cloud cluster](/stable/quick-start-yugabytedb-managed/)
- [![Server Icon](/icons/database.svg) Use a local cluster](/stable/quick-start/macos/)

The local cluster setup on a single host is intended for development and learning. For production deployment, performance benchmarking, or deploying a true multi-node on multi-host setup, see [Deploy YugabyteDB](/stable/deploy/ "Deploy YugabyteDB").

- [macOS](/stable/quick-start/macos/)
- [Linux](/stable/quick-start/linux/)
- [Docker](/stable/quick-start/docker/)
- [Kubernetes](/stable/quick-start/kubernetes/)

## Prerequisites

Before installing YugabyteDB, ensure that you have the following available:

- One of the [supported operating systems](/stable/reference/configuration/operating-systems/ "supported operating systems").
- Python 3.11. To check the version, execute the following command:
  
  ```sh
  python --version
  ```
  
  Starting from Ubuntu 20.04, `python` is no longer available. To fix this, run `sudo apt install python-is-python3`.
- `wget` or `curl`.
  
  The instructions use the `wget` command to download files. If you prefer to use `curl`, you can replace `wget` with `curl -LO`.
  
  To install `wget`:
  
  - On CentOS, run `yum install wget`
  - On Ubuntu, run `apt install wget`
  
  To install `curl`:
  
  - On CentOS, run `yum install curl`
  - On Ubuntu, run `apt install curl`

### ulimits

Because each tablet maps to its own file, you can create a very large number of files in the current shell by experimenting with several hundred tables and several tablets per table. You need to [configure ulimit values](/stable/deploy/manual-deployment/system-config/#set-ulimits "configure ulimit values").

## Download

YugabyteDB supports both x86 and ARM (aarch64) CPU architectures. Download packages ending in `x86_64.tar.gz` to run on x86, and packages ending in `aarch64.tar.gz` to run on ARM.

Download and extract YugabyteDB as follows:

- x86
- ARM

```sh
wget https://software.yugabyte.com/releases/2026.1.2.0/yugabyte-2026.1.2.0-b137-linux-x86_64.tar.gz
echo "$(curl -L https://software.yugabyte.com/releases/2026.1.2.0/yugabyte-2026.1.2.0-b137-linux-x86_64-tar.gz.sha) *yugabyte-2026.1.2.0-b137-linux-x86_64.tar.gz" | shasum --check && \
tar xvfz yugabyte-2026.1.2.0-b137-linux-x86_64.tar.gz && cd yugabyte-2026.1.2.0/
```

```sh
wget https://software.yugabyte.com/releases/2026.1.2.0/yugabyte-2026.1.2.0-b137-el8-aarch64.tar.gz
echo "$(curl -L https://software.yugabyte.com/releases/2026.1.2.0/yugabyte-2026.1.2.0-b137-el8-aarch64-tar.gz.sha) *yugabyte-2026.1.2.0-b137-el8-aarch64.tar.gz" | shasum --check && \
tar xvfz yugabyte-2026.1.2.0-b137-el8-aarch64.tar.gz && cd yugabyte-2026.1.2.0/
```

### Configure

To configure YugabyteDB, run the following shell script:

```sh
./bin/post_install.sh
```

## Create a local cluster

Use the [yugabyted](/stable/reference/configuration/yugabyted/ "yugabyted") utility to create and manage universes.

To create a single-node local cluster with a replication factor (RF) of 1, run the following command:

```sh
./bin/yugabyted start --advertise_address 127.0.0.1
```

Note: By default, yugabyted on Linux-based machines binds to the internal IP address. If it fails to do so, set the --advertise\_address flag.

Expect an output similar to the following:

```output
+----------------------------------------------------------------------------------------------------------+
|                                                yugabyted                                                 |
+----------------------------------------------------------------------------------------------------------+
| Status              : Running.                                                                           |
| Replication Factor  : 1                                                                                  |
| YugabyteDB UI       : http://127.0.0.1:15433                                                             |
| JDBC                : jdbc:postgresql://127.0.0.1:5433/yugabyte?user=yugabyte&password=yugabyte          |
| YSQL                : bin/ysqlsh   -U yugabyte -d yugabyte                                               |
| YCQL                : bin/ycqlsh   -u cassandra                                                          |
| Data Dir            : /Users/myuser/var/data                                                             |
| Log Dir             : /Users/myuser/var/logs                                                             |
| Universe UUID       : 41e54e9f-6f2f-4a46-befe-e0cd65d3056a                                               |
+----------------------------------------------------------------------------------------------------------+
```

After the cluster has been created, clients can connect to the YSQL and YCQL APIs at `http://localhost:5433` and `http://localhost:9042` respectively. You can also check `~/var/data` to see the data directory and `~/var/logs` to see the logs directory.

Execute the following command to check the cluster status at any time:

```sh
./bin/yugabyted status
```

### Connect to the database

Using the YugabyteDB SQL shell, [ysqlsh](/stable/api/ysqlsh/ "ysqlsh"), you can connect to your cluster and interact with it using distributed SQL. ysqlsh is installed with YugabyteDB and is located in the bin directory of the YugabyteDB home directory.

(If you have previously installed YugabyteDB version 2.8 or later and created a cluster on the same computer, you may need to [upgrade the YSQL system catalog](/stable/manage/upgrade-deployment/#2-upgrade-the-ysql-system-catalog "upgrade the YSQL system catalog") to run the latest features.)

To open the YSQL shell, run ysqlsh:

```sh
./bin/ysqlsh
```

```output
ysqlsh (15.2-YB-2026.1.2.0-b0)
Type "help" for help.

yugabyte=#
```

To load sample data and explore an example using ysqlsh, follow the instructions in [Install the Retail Analytics sample database](/stable/develop/sample-data/retail-analytics/#install-the-retail-analytics-sample-database "Install the Retail Analytics sample database").

### Monitor your cluster

When you start a cluster using yugabyted, you can monitor the cluster using the YugabyteDB UI, available at [http://127.0.0.1:15433](http://127.0.0.1:15433 "http://127.0.0.1:15433").

![YugabyteDB UI Cluster Overview](/images/quick_start/quick-start-ui-overview.png "YugabyteDB UI Cluster Overview")

The YugabyteDB UI provides cluster status, node information, performance metrics, and more.

## Build an application

Applications connect to and interact with YugabyteDB using API client libraries (also known as client drivers). This section shows how to connect applications to your cluster using your favorite programming language.

### Choose your language

Choose the language you want to use to build your application.

- Java
- Go
- Python
- Node.js
- C
- C++
- C#
- Ruby
- Rust
- PHP

The [Java application](https://github.com/yugabyte/yugabyte-simple-java-app "Java application") connects to a YugabyteDB cluster using the topology-aware [Yugabyte JDBC driver](/stable/develop/drivers-orms/java/ "Yugabyte JDBC driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Java.

The application requires the following:

- Java Development Kit (JDK) 1.8, or later, is installed. JDK installers for Linux and macOS can be downloaded from [Oracle](http://jdk.java.net/ "Oracle"), [Adoptium (OpenJDK)](https://adoptium.net/ "Adoptium (OpenJDK)"), or [Azul Systems (OpenJDK)](https://www.azul.com/downloads/?package=jdk "Azul Systems (OpenJDK)"). Homebrew users on macOS can install using `brew install openjdk`.
- [Apache Maven](https://maven.apache.org/index.html "Apache Maven") 3.3 or later.

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-java-app.git && cd yugabyte-simple-java-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `app.properties` file located in the application `src/main/resources/` folder.
   - Set the following configuration parameters:
     
     - **host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **database** - the name of the database you are connecting to (the default is `yugabyte`).
     - **dbUser** and **dbPassword** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **sslMode** - the SSL mode to use; use `verify-full`.
     - **sslRootCert** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Build the application.
   
   ```sh
   $ mvn clean package
   ```
4. Start the application.
   
   ```sh
   $ java -cp target/yugabyte-simple-java-app-1.0-SNAPSHOT.jar SampleApp
   ```

If you are running the application on a free or single node cluster, the driver displays a warning that the load balance failed and will fall back to a regular connection.

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created DemoAccount table.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000

>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Java application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/java/cloud-ysql-yb-jdbc/#explore-the-application-logic "Explore the application logic")

The [Go application](https://github.com/yugabyte/yugabyte-simple-go-app "Go application") connects to a YugabyteDB cluster using the [Go PostgreSQL driver](/stable/develop/drivers-orms/go/ "Go PostgreSQL driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Go.

The application requires the following:

- [Go](https://go.dev/dl/ "Go") (tested with version 1.17.6).

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-go-app.git && cd yugabyte-simple-go-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.go` file.
   - Set the following configuration parameter constants:
     
     - **host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **dbName** - the name of the database you are connecting to (the default is `yugabyte`).
     - **dbUser** and **dbPassword** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **sslMode** - the SSL mode to use; use `verify-full`.
     - **sslRootCert** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Initialize the `GO111MODULE` variable.
   
   ```sh
   $ export GO111MODULE=auto
   ```
4. Import the Go PostgreSQL driver.
   
   ```sh
   $ go get github.com/lib/pq
   ```
5. Start the application.
   
   ```sh
   $ go run sample-app.go
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Go application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/go/cloud-ysql-go/#explore-the-application-logic "Explore the application logic")

The [Python application](https://github.com/yugabyte/yugabyte-simple-python-app "Python application") connects to a YugabyteDB cluster using the [Python psycopg2 PostgreSQL database adapter](/stable/develop/drivers-orms/python/ "Python psycopg2 PostgreSQL database adapter") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Python.

The application requires the following:

- Python 3.6 or later (Python 3.9.7 or later if running macOS on Apple silicon).

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-python-app.git && cd yugabyte-simple-python-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.py` file.
   - Set the following configuration parameter constants:
     
     - **host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **dbName** - the name of the database you are connecting to (the default is `yugabyte`).
     - **dbUser** and **dbPassword** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **sslMode** - the SSL mode to use; use `verify-full`.
     - **sslRootCert** - the full path to the YugabyteDB Aeon cluster CA certificate.
   - Save the file.
3. Install psycopg2 PostgreSQL database adapter.
   
   ```sh
   $ pip3 install psycopg2-binary
   ```
4. Start the application.
   
   ```sh
   $ python3 sample-app.py
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Python application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/python/cloud-ysql-python/#explore-the-application-logic "Explore the application logic")

The [Node.js application](https://github.com/yugabyte/yugabyte-simple-node-app "Node.js application") connects to a YugabyteDB cluster using the [node-postgres driver](/stable/develop/drivers-orms/nodejs/ "node-postgres driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Node.js.

The application requires the following:

- The latest version of [Node.js](https://nodejs.org/en/download/ "Node.js").

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-node-app.git && cd yugabyte-simple-node-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.js` file.
   - Set the following configuration parameter constants:
     
     - **host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **database** - the name of the database you are connecting to (the default is `yugabyte`).
     - **user** and **password** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **ssl** - To enable `verify-ca` SSL mode, the `rejectUnauthorized` property is set to `true` to require root certificate chain validation; replace `path_to_your_root_certificate` with the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Install the node-postgres module.
   
   ```sh
   npm install pg
   ```
4. Install the [async](https://github.com/caolan/async "async") utility:
   
   ```sh
   npm install --save async
   ```
5. Start the application.
   
   ```sh
   $ node sample-app.js
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Node.js application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/nodejs/cloud-ysql-node/#explore-the-application-logic "Explore the application logic")

The [C application](https://github.com/yugabyte/yugabyte-simple-c-app "C application") connects to a YugabyteDB cluster using the [libpq driver](/stable/develop/drivers-orms/ysql-client-drivers/#libpq "libpq driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in C.

The application requires the following:

- 32-bit (x86) or 64-bit (x64) architecture machine. (Use [Rosetta](https://support.apple.com/en-us/HT211861 "Rosetta") to build and run on Apple silicon.)
- gcc 4.1.2 or later, or clang 3.4 or later installed.
- OpenSSL 1.1.1 or later (used by libpq to establish secure SSL connections).
- [libpq](/stable/develop/drivers-orms/ysql-client-drivers/#libpq "libpq"). Homebrew users on macOS can install using `brew install libpq`. You can download the PostgreSQL binaries and source from [PostgreSQL Downloads](https://www.postgresql.org/download/ "PostgreSQL Downloads").

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-c-app.git && cd yugabyte-simple-c-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.c` file.
   - Set the following configuration-related macros:
     
     - **HOST** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **PORT** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **DB\_NAME** - the name of the database you are connecting to (the default is `yugabyte`).
     - **USER** and **PASSWORD** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **SSL\_MODE** - the SSL mode to use; use `verify-full`.
     - **SSL\_ROOT\_CERT** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Build the application with gcc or clang.
   
   ```sh
   gcc sample-app.c -o sample-app -I<path-to-libpq>/libpq/include -L<path-to-libpq>/libpq/lib -lpq
   ```
4. Replace `<path-to-libpq>` with the path to the libpq installation; for example, `/usr/local/opt`.
5. Start the application.
   
   ```sh
   $ ./sample-app
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic C application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/c/cloud-ysql-c/#explore-the-application-logic "Explore the application logic")

The [C++ application](https://github.com/yugabyte/yugabyte-simple-cpp-app "C++ application") connects to a YugabyteDB cluster using the [libpqxx driver](/stable/develop/drivers-orms/ysql-client-drivers/#libpqxx "libpqxx driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in C++.

The application requires the following:

- 32-bit (x86) or 64-bit (x64) architecture machine. (Use [Rosetta](https://support.apple.com/en-us/HT211861 "Rosetta") to build and run on Apple silicon.)
- gcc 4.1.2 or later, or clang 3.4 or later installed.
- OpenSSL 1.1.1 or later (used by libpq and libpqxx to establish secure SSL connections).
- [libpq](/stable/develop/drivers-orms/ysql-client-drivers/#libpq "libpq"). Homebrew users on macOS can install using `brew install libpq`. You can download the PostgreSQL binaries and source from [PostgreSQL Downloads](https://www.postgresql.org/download/ "PostgreSQL Downloads").
- [libpqxx](/stable/develop/drivers-orms/ysql-client-drivers/#libpqxx "libpqxx"). Homebrew users on macOS can install using `brew install libpqxx`. To build the driver yourself, refer to [Building libpqxx](https://github.com/jtv/libpqxx#building-libpqxx "Building libpqxx").

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-cpp-app.git && cd yugabyte-simple-cpp-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.cpp` file.
   - Set the following configuration-related constants:
     
     - **HOST** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **PORT** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **DB\_NAME** - the name of the database you are connecting to (the default is `yugabyte`).
     - **USER** and **PASSWORD** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **SSL\_MODE** - the SSL mode to use; use `verify-full`.
     - **SSL\_ROOT\_CERT** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Build the application with gcc or clang.
   
   ```sh
   g++ -std=c++17 sample-app.cpp -o sample-app -lpqxx -lpq \
   -I<path-to-libpq>/libpq/include -I<path-to-libpqxx>/libpqxx/include \
   -L<path-to-libpq>/libpq/lib -L<path-to-libpqxx>/libpqxx/lib
   ```
4. Replace `<path-to-libpq>` with the path to the libpq installation, and `<path-to-libpqxx>` with the path to the libpqxx installation; for example, `/usr/local/opt`.
5. Start the application.
   
   ```sh
   $ ./sample-app
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic C++ application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/cpp/cloud-ysql-cpp/#explore-the-application-logic "Explore the application logic")

The [C# application](https://github.com/yugabyte/yugabyte-simple-csharp-app "C# application") connects to a YugabyteDB cluster using the [Npgsql driver](/stable/develop/drivers-orms/csharp/ "Npgsql driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in C#.

The application requires the following:

- [.NET 6.0 SDK](https://dotnet.microsoft.com/en-us/download ".NET 6.0 SDK") or later.

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-csharp-app.git && cd yugabyte-simple-csharp-app
   ```
   
   The `yugabyte-simple-csharp-app.csproj` file includes the following package reference to include the driver:
   
   ```cpp
   <PackageReference Include="npgsql" Version="6.0.3" />
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.cs` file.
   - Set the following configuration-related parameters:
     
     - **urlBuilder.Host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **urlBuilder.Port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **urlBuilder.Database** - the name of the database you are connecting to (the default is `yugabyte`).
     - **urlBuilder.Username** and **urlBuilder.Password** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **urlBuilder.SslMode** - the SSL mode to use; use `SslMode.VerifyFull`.
     - **urlBuilder.RootCertificate** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Build and run the application.
   
   ```sh
   dotnet run
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic C# application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/csharp/cloud-ysql-csharp/#explore-the-application-logic "Explore the application logic")

The [Ruby application](https://github.com/yugabyte/yugabyte-simple-ruby-app "Ruby application") connects to a YugabyteDB cluster using the [Ruby Pg driver](/stable/develop/drivers-orms/ruby/ruby-pg/ "Ruby Pg driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Ruby.

The application requires the following:

- Ruby 3.1 or later.
- OpenSSL 1.1.1 or later (used by libpq and pg to establish secure SSL connections).
- [libpq](/stable/develop/drivers-orms/ysql-client-drivers/#libpq "libpq"). Homebrew users on macOS can install using `brew install libpq`. You can download the PostgreSQL binaries and source from [PostgreSQL Downloads](https://www.postgresql.org/download/ "PostgreSQL Downloads").
- [Ruby pg](/stable/develop/drivers-orms/ruby/ruby-pg/ "Ruby pg"). To install Ruby pg, run the following command:
  
  ```sh
  gem install pg -- --with-pg-include=<path-to-libpq>/libpq/include --with-pg-lib=<path-to-libpq>/libpq/lib
  ```
  
  Replace `<path-to-libpq>` with the path to the libpq installation; for example, `/usr/local/opt`.

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-ruby-app.git && cd yugabyte-simple-ruby-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.rb` file.
   - Set the following configuration-related parameters:
     
     - **host** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **port** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **dbname** - the name of the database you are connecting to (the default is `yugabyte`).
     - **user** and **password** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **sslmode** - the SSL mode to use; use `verify-full`.
     - **sslrootcert** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Make the application file executable.
   
   ```sh
   chmod +x sample-app.rb
   ```
4. Run the application.
   
   ```sh
   $ ./sample-app.rb
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Ruby application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/ruby/cloud-ysql-ruby/#explore-the-application-logic "Explore the application logic")

The [Rust application](https://github.com/yugabyte/yugabyte-simple-rust-app "Rust application") connects to a YugabyteDB cluster using the [Rust-Postgres driver](/stable/develop/drivers-orms/rust/yb-rust-postgres/ "Rust-Postgres driver") and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in Rust.

The application requires the following:

- [Rust](https://www.rust-lang.org/tools/install "Rust") development environment. The sample application was created for Rust 1.58 but should work for earlier and later versions.

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-rust-app.git && cd yugabyte-simple-rust-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.rs` file in the `src` directory.
   - Set the following configuration-related constants:
     
     - **HOST** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **PORT** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **DB\_NAME** - the name of the database you are connecting to (the default is `yugabyte`).
     - **USER** and **PASSWORD** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **SSL\_MODE** - the SSL mode to use; use `SslMode::Require`.
     - **SSL\_ROOT\_CERT** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Build and run the application.
   
   ```sh
   $ cargo run
   ```

The driver is included in the dependencies list of the `Cargo.toml` file and installed automatically the first time you run the application.

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic Rust application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/rust/cloud-ysql-rust/#explore-the-application-logic "Explore the application logic")

The [PHP application](https://github.com/yugabyte/yugabyte-simple-php-app "PHP application") connects to a YugabyteDB cluster using the [php-pgsql](/stable/develop/drivers-orms/php/ysql/ "php-pgsql") driver and performs basic SQL operations. Use the application as a template to get started with YugabyteDB in PHP.

The application requires the following:

- PHP runtime. The sample application was created using PHP 8.1 but should work with earlier and later versions. Homebrew users on macOS can install PHP using `brew install php`.
- [php-pgsql driver](/stable/develop/drivers-orms/php/ysql/ "php-pgsql driver").
  
  - On macOS, Homebrew automatically installs the driver with `brew install php`.
  - Ubuntu users can install the driver using the `sudo apt-get install php-pgsql` command.
  - CentOS users can install the driver using the `sudo yum install php-pgsql` command.

To build and run the application, do the following:

1. Clone the sample application to your computer:
   
   ```sh
   git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-php-app.git && cd yugabyte-simple-php-app
   ```
2. Provide connection parameters.
   
   (You can skip this step and use the defaults if your cluster is running locally and listening on 127.0.0.1:5433.)
   
   The application needs to establish a connection to the YugabyteDB cluster. To do this:
   
   - Open the `sample-app.php` file.
   - Set the following configuration-related constants:
     
     - **HOST** - the host name of your YugabyteDB cluster. For local clusters, use the default (127.0.0.1). For YugabyteDB Aeon, select your cluster on the **Clusters** page, and click **Settings**. The host is displayed under **Connection Parameters**.
     - **PORT** - the port number for the driver to use (the default YugabyteDB YSQL port is 5433).
     - **DB\_NAME** - the name of the database to connect to (the default is `yugabyte`).
     - **USER** and **PASSWORD** - the username and password for the YugabyteDB database. For local clusters, use the defaults (`yugabyte`). For YugabyteDB Aeon, use the credentials in the credentials file you downloaded.
   - YugabyteDB Aeon [requires SSL connections](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/#ssl-modes-in-ysql "requires SSL connections"), so you need to set the following additional parameters:
     
     - **SSL\_MODE** - the SSL mode to use; use `verify-full`.
     - **SSL\_ROOT\_CERT** - the full path to the YugabyteDB Aeon [cluster CA certificate](/stable/yugabyte-cloud/cloud-secure-clusters/cloud-authentication/ "cluster CA certificate").
   - Save the file.
3. Run the application.
   
   ```sh
   $ php sample-app.php
   ```

You should see output similar to the following:

```output
>>>> Successfully connected to YugabyteDB!
>>>> Successfully created table DemoAccount.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 10000
name = John, age = 28, country = Canada, balance = 9000
>>>> Transferred 800 between accounts.
>>>> Selecting accounts:
name = Jessica, age = 28, country = USA, balance = 9200
name = John, age = 28, country = Canada, balance = 9800
```

You have successfully executed a basic PHP application that works with YugabyteDB.

[Explore the application logic](/stable/develop/tutorials/build-apps/php/cloud-ysql-php/#explore-the-application-logic "Explore the application logic")

## Migrate from PostgreSQL

[YugabyteDB Voyager](/stable/yugabyte-voyager/ "YugabyteDB Voyager") simplifies moving applications from traditional RDBMS platforms to YugabyteDB. While YugabyteDB Voyager handles migration logistics, its primary value is modernizing your database architecture for cloud-native scale and performance.

Voyager creates an end-to-end modernization workflow by analyzing multiple signals across your source database and application, including schema layout, IOPS and table/index access patterns, column count and row size, query plan efficiency, potential performance bottlenecks, extensions, and more.

Key capabilities:

- Schema modernization: Evaluates and transforms features, data types, query constructs, and PL/pgSQL objects for optimal distributed database performance
- Sizing recommendations: Provides accurate infrastructure sizing estimates
- Performance analysis: Delivers workload analysis, optimization recommendations, and inefficiency identification
- Migration planning: Estimates migration timeline for confident, predictable execution

For more information, refer to [YugabyteDB Voyager](/stable/yugabyte-voyager/ "YugabyteDB Voyager").

## Next steps

- [Explore YugabyteDB](/stable/explore/ "Explore YugabyteDB")
- [Develop for YugabyteDB](/stable/develop/ "Develop for YugabyteDB")