Sign inSign up

eaeoz/rethinkdb-query-app

By eaeoz

•Updated about 2 years ago

rethinkdb query app gui with rethink db

Image
0

110

eaeoz/rethinkdb-query-app repository overview

⁠RethinkDB Query App with RethinkDB
⁠RethinkDB Query App let you update list from text (to select whenever you want to view query result) or let you enter manual query from gui, then you can import as xslx (excel format)
  • Clone Repo

git clone https://github.com/eaeoz/rethinkdb-query-app.git

  • Deploy Compose

docker-compose up -d

  • For access to gui: http://<your-host-ip>:30015
⁠Docker Compose
version: "3.8"

services:
  app:
    image: eaeoz/rethinkdb-query-app:5
    ports:
      - "3000:3000"
    volumes:
      - ./queries.txt:/usr/src/app/queries.txt
    environment:
      - RETHINKDB_HOST=rethinkdb
    depends_on:
      - rethinkdb

  rethinkdb:
    image: eaeoz/rethinkdb:1
    container_name: rethinkdb
    environment:
      - RETHINKDB_PACKAGE_VERSION=2.4.4~0bookworm
      - RETHINKDB_DATA_DIR=/data
      - RETHINKDB_BIND_ALL=true
      # Add any additional performance-related environment variables here
    ports:
      - "28015:28015" # RethinkDB HTTP API
      - "29015:29015" # RethinkDB driver port
      - "30015:8080" # RethinkDB web UI
    volumes:
      - ./data:/data # Bind mount to the local 'data' directory
    deploy:
      resources:
        limits:
          cpus: "0.5" # Limit to 0.5 CPU
          memory: 256M # Limit to 512 MB of memory

⁠---> You can add more queries to queries.txt as same format <---
⁠(don't forget to restart container if new list added)
  • Check for more queries: https://rethinkdb.com/docs/cookbook/javascript/
⁠Example 'queries.txt'
orderBy id
r.db('test').table('test_table').orderBy(r.asc('id'))
value columns only
r.db('test').table('test_table').pluck('value')
value query greater then 100
r.db("test").table("test_table").filter(r.row("value").gt(100))
  • Download windows app to add or view databases (add, sort or view records as well): https://github.com/codehangar/reqlpro/releases

  • Port to set in windows client app: 28015


(id record unique)
add new records to the table using ReQLPro json example:

[
  {
    "id": "3" ,
    "name": "test3" ,
    "value": 102
  },
  {

    "id": "1" ,
    "name": "test1" ,
    "value": 99
  },
  {
    "id": "2" ,
    "name": "test2" ,
    "value": 101
  }
]


or single record:

{
  "id": "1" ,
  "name": "test1" ,
  "value": 99
}

Tag summary

Content type

Image

Digest

sha256:3e91f5f15…

Size

357.1 MB

Last updated

about 2 years ago

docker pull eaeoz/rethinkdb-query-app:5