Sébastien Vanvelthem belgattitude

## how-to-docker-mssql-docker-compose.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                belgattitude
                / how-to-docker-mssql-docker-compose.md
            
            
              Last active
              January 9, 2025 10:10
            
              
                Example of mssql/server:2022-CU16-ubuntu-22.04 docker compose with healthcheck
              
          
    Docker mssql server

Features


 Recent mssql server version (server:2022-CU16-ubuntu-22.04 with mysql-tools-18)
 Healthcheck

Requirements


 Docker engine > 2.7


## typescript-issue-with-async-discriminated-union.ts
import type { Compilable, InferResult, Kysely } from 'kysely';

type QueryResultSuccess<T> = {
  success: true;
  data: T;
};
type QueryResultError = {
  success: false;
  errorMsg: string;
};

## pnpm-vs-yarn-on-vercel.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                belgattitude
                / pnpm-vs-yarn-on-vercel.md
            
            
              Last active
              October 10, 2022 21:29
            
          
    Comparison


Yarn 4.0.0-rc.23: 2+ minutes (constant yarn cache is preserved between lock changes: cache saved in .next/cache/yarn)
Pnpm 7.13.x: 4+ mins (cold cache) / 3+ minutes (warm cache)

Deploy size


PS: add NEXT_DEBUG_FUNCTION_SIZE=1 in the vercel envs/


## ci-pnpm-install.md

      
              1 file
            
          
              6 forks
            
          
                14 comments
              
            
              30 stars
            
          
                belgattitude
                / ci-pnpm-install.md
            
            
              Last active
              November 1, 2024 19:25
            
              
                Composite github action to improve CI time with pnpm
              
          
    Why

Although @setup/node as a built-in cache option, it  lacks an opportunity regarding cache persistence. Depending on usage, the action below might give you faster installs and potentially reduce carbon emissions (♻️🌳❤️).
Requirements

pnpm v7 or v8 (not using pnpm ? see the corresponding yarn action gist)
Bench


## ci-yarn-install.md

      
              1 file
            
          
              7 forks
            
          
                48 comments
              
            
              60 stars
            
          
                belgattitude
                / ci-yarn-install.md
            
            
              Last active
              January 6, 2025 15:22
            
              
                Composite github action to improve CI time with yarn 3+ / node-modules linker.
              
          
    Why

Although @setup/node as a built-in cache option, it  lacks an opportunity regarding cache persistence. Depending on usage, the action below might give you faster installs and potentially reduce carbon emissions (♻️🌳❤️).
Requirements

Yarn 3+/4+ with nodeLinker: node-modules. (Not using yarn ? see the corresponding pnpm 7/8+ action gist)
Structure


## benchmark-package-managers.md

      
              1 file
            
          
              1 fork
            
          
                0 comments
              
            
              2 stars
            
          
                belgattitude
                / benchmark-package-managers.md
            
            
              Last active
              June 20, 2023 11:19
            
              
                Package managers comparison from the CI time perspective
              
          
    Benchmark

TLDR

On a (cached) github action. pnpm7 ±50s (244Mb store cache) / yarn4-nm ±75s (190Mb yarn install cache)
Intro

Tests made with pnpm 7+ and yarn 4.0.0rc (node-modules/pnp) based on https://github.com/belgattitude/nextjs-monorepo-example. Tests have been made in a way to evaluate CI performance. There's other perf bench: pnpm or yarn. Conclusions are pretty similar. This benchmark helped to create this yarn install composite action

  
## hubspot-meeting-case-study.md

      
              1 file
            
          
              0 forks
            
          
                1 comment
              
            
              0 stars
            
          
                belgattitude
                / hubspot-meeting-case-study.md
            
            
              Last active
              June 7, 2022 09:27
            
          
    Hubspot Embed Case-Study

Original issue in https://github.com/sortlist/sortlist/issues/18791 and some requirements in https://docs.google.com/spreadsheets/d/1HzL-Swnh0qLOB-vLWDeHQtyJMpkCF7RvFWTaBU0U4Xo/.
Motives


Make advising calls details available on Hubspot.
Integrate Hubspot Schedule Meetings in our advisor (schedule meetings will handle confirmations, reschedule...)


## random-test-of-peer-deps.md

      
              1 file
            
          
              2 forks
            
          
                0 comments
              
            
              1 star
            
          
                belgattitude
                / random-test-of-peer-deps.md
            
            
              Last active
              February 12, 2023 15:41
            
          
    peer-deps

Support for peerDependencies and peerDependenciesMeta.optional seems consistent
for Yarn 1/2/3, PNPM 6 and NPM 8.
Exception: NPM v7 always install the peerDependencies, which has the consequence to download
deps that might not be needed (the --legacy-peer-deps can help).

See https://github.com/npm/rfcs/blob/main/implemented/0025-install-peer-deps.md


## machine.js

  // Available variables:
  // - Machine
  // - interpret
  // - assign
  // - send
  // - sendParent
  // - spawn
  // - raise
  // - actions

## install_phpexcel_php73.sh
#!/bin/bash
#
# Example script to install LibXL, ilia/php_excel on PHP 7.3 (ondrej/ppa)
#
# Usage:
#   > sudo ./install_phpexcel_php73.sh
#   > sudo service php7.3-fpm reload (if using fpm)
#
# Requirements:
#   - Tested with Ubuntu 64bits (14.04, 16.04+)
	import type { Compilable, InferResult, Kysely } from 'kysely';

	type QueryResultSuccess<T> = {
	success: true;
	data: T;
	};
	type QueryResultError = {
	success: false;
	errorMsg: string;
	};

	// Available variables:
	// - Machine
	// - interpret
	// - assign
	// - send
	// - sendParent
	// - spawn
	// - raise
	// - actions
	#!/bin/bash
	#
	# Example script to install LibXL, ilia/php_excel on PHP 7.3 (ondrej/ppa)
	#
	# Usage:
	# > sudo ./install_phpexcel_php73.sh
	# > sudo service php7.3-fpm reload (if using fpm)
	#
	# Requirements:
	# - Tested with Ubuntu 64bits (14.04, 16.04+)