πŸ—„οΈ Database

  • Apache Jena

    Apache Jena Fuseki ./fuseki-server --mem /ds ./fuseki start ./fuseki stop ./fuseki restart Fuseki Docker​ https://jena.apache.org/documentation/fuseki2/fuseki-docker.html https://hub.docker.com/r/stain/jena-fuseki docker pull stain/jena-fuseki docker run -d --name fuseki \ -p 3030:3030 \ -e ADMIN_PASSWORD=admin \ -e TDB=2 \ -e FUSEKI_DATASET_1=mulberrypond \ -v $HOME/fuseki/data:/fuseki \ stain/jena-fuseki If using default dataset, the last prefix is not needed, ‘from dtlab:’ is not needed, either.

  • Neo4j

    neo4j docker docker run \ --name neo4j \ -p7474:7474 -p7687:7687 \ -d \ -v /root/f26/neo4j/data:/data \ -v /root/f26/neo4j/conf:/var/lib/neo4j/conf\ -v /root/f26/neo4j/logs:/logs \ -v /root/f26/neo4j/import:/var/lib/neo4j/import \ -v /root/f26/neo4j/plugins:/plugins \ --env NEO4J_AUTH=none \ neo4j:latest docker run \ --name neo4j \ -p7474:7474 -p7687:7687 \ -d \ -v /root/f26/neo4j/data:/data \ -v /root/f26/neo4j/conf:/var/lib/neo4j/conf\ -v /root/f26/neo4j/logs:/logs \ -v /root/f26/neo4j/import:/var/lib/neo4j/import \ -v /root/f26/neo4j/plugins:/plugins \ --env NEO4J_AUTH=none \ --env='NEO4JLABS_PLUGINS=["n10s"]' \ neo4j:latest docker run \ --name neo4j \ -p7474:7474 -p7687:7687 \ -d \ -v $HOME/neo4j/data:/data \ -v $HOME/neo4j/logs:/logs \ -v $HOME/neo4j/import:/var/lib/neo4j/import \ -v $HOME/neo4j/plugins:/plugins \ --env NEO4J_AUTH=neo4j/mideambt \ neo4j:latest https://neo4j.

  • InfluxDB

    InfluxDB https://docs.influxdata.com/influxdb/v1.8/administration/authentication_and_authorization/ Flux https://docs.influxdata.com/flux/v0.x/get-started/ Queries SQL CREATE USER polyU_HK WITH PASSWORD '***' GRANT READ ON "telegraf" TO "***" SHOW DATABASES USE database SHOW measurements SELECT * FROM measurements create retention policy "rp_f26" on "telegraf" duration 3w replication 1 default drop retention policy "auto_gen" Query the latest record only.

  • MariaDB

    MariaDB on RaspberryPi docker pull tobi312/rpi-mariadb:10.6-alpine docker run --name mariadb -v $(pwd)/mariadb:/var/lib/mysql -p 3306:3306 -e MYSQL_DATABASE=midea -e MYSQL_ROOT_PASSWORD=mypass -d tobi312/rpi-mariadb:10.6-alpine

  • TDengine

    Quick Install on Docker Instruction: https://docs.tdengine.com/get-started/docker/ If Docker is already installed on your computer, pull the latest TDengine Docker container image: docker pull tdengine/tdengine:latest Or the container image of specific version:

  • PostgreSQL

    PostgreSQL & pgAdmin 4 curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add - sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list' sudo apt update sudo apt install pgadmin4 sudo /usr/pgadmin4/bin/setup-web.sh pgagent