| id | rethinkdb |
|---|---|
| title | RethinkDB |
ToolJet can connect to RethinkDB databases to read and write data. For more info visit this Rethink Docs.
To establish a connection with the RethinkDB data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page through the ToolJet dashboard.
ToolJet requires the following to connect to a RethinkDB data source:
- Database
- Host
- Username
- Password
- Port
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/connection.png" 聽alt="RethinkDB Connection Page" />
- Click on + Add button of the query manager at the bottom panel of the editor.
- Select the RethinkDB data source added in the previous step.
- Select the desired operation.
- Click on the Preview button to preview the output or Click on the Run button to trigger the query.
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/operations.png" 聽alt="RethinkDB Connection Page" />
- Create database
- Create table
- Delete database
- Delete table
- List all database
- List all table
- List all documents
- Insert document
- Retrieve document by key
- Update document using ID
- Update all documents
- Delete document using ID
- Delete all documents
:::info NOTE: The name field in all operations is the database name if not given will take the default database used for the connection. :::
Creates a new database in RethinkDB.
- Database Name
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/create-db.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Creates a new table in a specified database.
- Database Name
- Tablename
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/create-table.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Deletes an existing database in RethinkDB.
- Database Name
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/delete-db.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Deletes a table from a specified database.
- Database Name
- Tablename
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/delete-table.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Lists all available databases.
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/list-database.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Lists all tables in a specified database.
- Database Name
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/list-table.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Retrieves all documents from a specified table.
- Database Name
- Tablename
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/list-docs.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Inserts a new document into a specified table.
- Database Name
- Tablename
- Data
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/insert-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
{
聽 "name": "John Doe",
聽 "age": 30
}Fetches a document from a specified table by its key.
- Database Name
- Tablename
- Primary key
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/retrieve-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Updates a specific document in a table using its ID.
- Database Name
- Tablename
- Primary key
- Data
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/update-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
{
聽 "age": 31
}Updates all documents in a specified table.
- Database Name
- Tablename
- Data
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/update-all-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
{
聽 "verified": true
}Deletes a specific document in a table using its ID.
- Database Name
- Tablename
- Primary key
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/delete-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>
Deletes all documents from a specified table.
- Database Name
- Tablename
<img className="screenshot-full" src="https://github.com/img/datasource-reference/rethink/delete-all-doc.png" 聽alt="RethinkDB Create Database Operation" style={{marginBottom:'15px'}}/>