Skip to content

Instantly share code, notes, and snippets.

Alina GHERMAN veve90

Block or report user

Report or block veve90

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@veve90
veve90 / postgres10
Last active Mar 17, 2019
postgres outils
View postgres10
-- active queries
SELECT datname, pid, state, query, age(clock_timestamp(), query_start) AS age
FROM pg_stat_activity order by age;
-- waiting activities
SELECT * FROM pg_stat_activity WHERE wait_event IS NOT NULL AND backend_type = 'client backend';
-- need vacuum ?
-- https://severalnines.com/blog/why-postgresql-running-slow-tips-tricks-get-source
View docker-compose-drupal-postgres.yml
version: '2'
# Note: use the database service name `db` in the Host IP Address field ...
# Or, `docker container inspect {postgrescontainerid}` to obtain the IP Address needed for completing the Drupal setup screen.
services:
# Postgres
db:
image: postgres:9.6.5-alpine
restart: always
@veve90
veve90 / README.md
Created Feb 1, 2019 — forked from denji/README.md
Simple Sentry docker-compose.yml
View README.md
  1. Download docker-compose.yml to dir named sentry
  2. Change SENTRY_SECRET_KEY to random 32 char string
  3. Run docker-compose up -d
  4. Run docker-compose exec sentry sentry upgrade to setup database and create admin user
  5. (Optional) Run docker-compose exec sentry pip install sentry-slack if you want slack plugin, it can be done later
  6. Run docker-compose restart sentry
  7. Sentry is now running on public port 9000
@veve90
veve90 / gist:3a963f2b4fcc594b0778783cdb130c15
Created Feb 1, 2019 — forked from gblok/gist:ec48dcdea14d1d0f27e843efa80d90fe
Creating postgresql container via docker-compose
View gist:3a963f2b4fcc594b0778783cdb130c15
create folder
1)
mkdir docker-compose-pg
cd docker-compose-pg
2)
vi docker-compose.yml
insert this text:
"
View IOF_dummy
Temps Cycle cuve; 10;50
Temps Cycle P40; 10;60
Temps Cycle P5; 10;40
View MQTT
#Queue
https://www.rabbitmq.com/mqtt.html
#Boket MQTT
Mosquitto MQTT Broker
# Check elements in queue
MQTT Lens (chrome plugin)
@veve90
veve90 / TICK-rasbperryPI
Last active Oct 14, 2018
TICK-rasbperryPI
View TICK-rasbperryPI
### SOURCES #######################################################################"""
# https://www.influxdata.com/blog/running-the-tick-stack-on-a-raspberry-pi/
# https://makemypi.wordpress.com/2018/02/19/iot-with-influxdb-telegraph-and-grafana-on-the-raspberry-pi-3/
# https://thingsmatic.com/2017/03/02/influxdb-and-grafana-for-sensor-time-series/
# https://github.com/opendata-stuttgart/mqtt-stack/blob/master/howto_setup_tick_stack.md
# https://gist.github.com/fragolinux/c9b0025f831d1c9edcdf049d920d34ad
## https://bentek.fr/influxdb-grafana-raspberry-pi/
## http://ticksurraspberrypi3.blogspot.com/
## https://www.influxdata.com/integration/mqtt-monitoring/
## https://github.com/fg2it/grafana-on-raspberry
@veve90
veve90 / rpi3_iot_server.md
Created Oct 13, 2018 — forked from xoseperez/rpi3_iot_server.md
Raspberry Pi 3 with Mosquitto, Node-RED, InfluxDB, Grafana and Nginx (as a reverse proxy)
View rpi3_iot_server.md
View git helper
#create an aliast for squash all commits and use it
git config --global alias.squash-all '!f(){ git reset $(git commit-tree HEAD^{tree} -m "${1:-A new start}");};f'
git squash-all "First commint - one commit"
#add tag
git tag {TAG_NAME}
git push origin {BRANCH_NAME} --tags
# Liste des tags en local:
View docker helper
#start docker daemon (on viperr)
systemctl restart docker
#start bash in docker
docker exec -ti container_name bash
#docker informations
docker -D info
You can’t perform that action at this time.