revolunet

await db
    .with("expiration_date", (db) =>
        db
            .selectFrom("missions")
            .select(({ fn }) => ["user_id", fn.max("end").as("expiration")])
            .groupBy("user_id")
    )
    .selectFrom(["users", "expiration_date"])
    .select([
        "users.username",

revolunet

revolunet

{
  "$schema": "https://json-schema.org/draft-07/schema",
  "additionalProperties": {
    "$ref": "#/definitions/mecanismes/valeur"
  },
  "definitions": {
    "mecanismes": {
      "variations": {
        "title": "variations",
        "markdownDescription": "Contient une liste de conditions (si) et leurs conséquences associées (alors), ainsi qu’un cas par défaut (sinon).\n\nPour la première condition vraie dans la liste, on retient la valeur qui lui est associée.\n\nSi aucune condition n’est vraie, alors ce mécanisme renvoie implicitement non.\n\nCe mécanisme peut aussi être utilisé au sein d’un autre mécanisme avec des attributs, tel que produit ou barème.\n\nDoc: https://publi.codes/docs/api/m%C3%A9canismes#variations",

revolunet

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "scalingo.json schema https://doc.scalingo.com/platform/app/app-manifest",
  "description": "Extracted from https://developers.scalingo.com/scalingo-json-schema/",
  "type": "object",
  "additionalProperties": false,
  "properties": {
    "$schema": { "type": "string" },
    "name": {
      "description": "Complete name of the project",

revolunet

#
# https://publi.codes/studio/r%C3%A9sultat#prix%20paquet%3A%20%0A%20%20valeur%3A%2012%0A%20%20unit%C3%A9%3A%20%E2%82%AC%0A%0Aconsommation%20par%20jour%3A%0A%20%20question%3A%20Combien%20de%20cigarettes%20fumez-vous%20par%20jour%20en%20moyenne%20%3F%0A%20%20valeur%3A%208%0A%0Aeconomies%20par%20jour%3A%0A%20%20valeur%3A%20consommation%20par%20jour%20*%20(prix%20paquet%20%2F%2020)%0A%20%20unit%C3%A9%3A%20%E2%82%AC%0A%0Aeconomies%20par%20an%3A%0A%20%20valeur%3A%20economies%20par%20jour%20*%20365%0A%20%20unit%C3%A9%3A%20%E2%82%AC%0A%0Acommentaire%3A%0A%20%20variations%3A%0A%20%20%20%20-%20si%3A%20economies%20par%20an%20%3E%201500%0A%20%20%20%20%20%20alors%3A%20%22'Vous%20pourriez%20vous%20offrir%20un%20beau%20v%C3%A9lo%20%C3%A9l%C3%A9ctrique.'%22%0A%20%20%20%20-%20si%3A%20economies%20par%20an%20%3E%201000%0A%20%20%20%20%20%20alors%3A%20%22'Ca%20fait%20un%20beau%20petit%20voyage%20en%20Italie.'%22%0A%20%20%20%20-%20si%3A%20economies%20par%20an%20%3E%20500%0A%20%20%20%20%20%20alors%3A%20%22'Ca%20fait%20un%20tr%C3%

revolunet

run with docker

create ~/verdaccio/conf/config.yaml from example then:

V_PATH=~/verdaccio; docker run -it --rm --name verdaccio \
  -p 4873:4873 \
  -v $V_PATH/conf:/verdaccio/conf \
  -v $V_PATH/storage:/verdaccio/storage \
 -v $V_PATH/plugins:/verdaccio/plugins \

revolunet

#
# Sometimes openai API hangs and the openai-python lib doesnt make it easy to set timeouts via llamaindex
# This nginx conf lets you pop a nginx cluster that will force to kill long queries
# Llama index for example has good request retry policy so this makes the whole thing faster
#
# Put that file in /etc/nginx/conf.d/default.conf
#
# for ex with docker: `docker run -p 8080:8080 -v $PWD/nginx.conf:/etc/nginx/conf.d/default.conf nginx:alpine3.18`
#
# Add this to your imports:

revolunet

version: '3.7'
services:
  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:7.15.0
    environment:
      - "ES_JAVA_OPTS=-Xms256M -Xmx256M"
      - node.name=elasticsearch
      - cluster.name=docker-cluster
      - cluster.initial_master_nodes=elasticsearch
    ports:

revolunet

# /Users/xxx/Library/Application Support/k9s/hotkey.yml
hotKey:
  # Hitting Shift-0 navigates to your CNPG clusters
  shift-Q:
    shortCut: Shift-Q
    description: Viewing CNPG clusters
    command: postgresql.cnpg.io/v1/clusters

revolunet

#!/bin/bash

#
# request some URL and report HTTP status changes
# ./downtime-monitor.sh https://some.url
#

URL="$1"

INTERVAL=0.1