Cacher is the code snippet organizer for pro developers

WITH date_range AS (
    SELECT DATE '2026-08-01' AS start_date,
           DATE '2026-08-31' AS end_date
),

base AS (
    SELECT
        rl.id AS refer_id,
        rl.base_entity_id,
        m.first_name AS patient_name,
        m.patient_phone_number AS mobile_number,
        TRIM(TO_CHAR(rl.date_created, 'Month')) AS month,
        DATE(rl.date_created) AS refer_date,
        rl.date_created,

        CASE
            WHEN rl.provider_id = 'FA_Threads_Palashbari_3' THEN 'Sham

WITH
-- ============================================================
-- CHANGE THE REPORT DATE RANGE HERE ONLY -- everything below
-- (Part A and Part B) reads from this single place.
-- ============================================================
date_range AS (
    SELECT
        DATE '2026-06-01' AS start_date,
        DATE '2026-08-31' AS end_date
),

anc_dedup AS (
    SELECT base_entity_id, MIN(date_created) AS anc_date
    FROM report.anc_register
    GROUP BY base_entity_id

WITH
-- ============================================================
-- CHANGE THE REPORT DATE RANGE HERE ONLY -- applies to BOTH
-- the referral side and the service side.
-- ============================================================
date_range AS (
    SELECT DATE '2026-08-01' AS start_date,
           DATE '2026-08-31' AS end_date
),

-- ============================================================
-- REFERRAL SIDE
-- ============================================================

WITH
date_range AS (
    SELECT DATE '2026-09-01' AS start_date,
           DATE '2026-09-30' AS end_date
),

referral_events AS (
    SELECT
        rl.base_entity_id,
        DATE(rl.date_created) AS refer_date
    FROM report.refer_list rl
    WHERE rl.provider_id IN (
            'FA_Threads_Palashbari_3','FA_Threads_Palashbari_4','FA_Threads_Palashbari_5',
            'FA_Threads_Ashulia_1','FA_Threads_Ashulia_3','FA_Threads_Ashulia_4',
            'FA_Threads_Ashulia_5','FA_Threads_Palashb

/**
 * @param {string} s
 * @param {string[][]} knowledge
 * @return {string}
 */
var evaluate = function(s, knowledge) {
    // Convert knowledge into a Map:
    // [["name", "bob"], ["age", "two"]]
    // becomes:
    // name -> bob
    // age  -> two
    const map = new Map(knowledge);

    const result = [];
    let i = 0;

    while (i < s.length) {

        // If we find an opening bracket,
        // we need to extract the key inside it.
        if (s[i] === "(") {
            let j = i +

add_filter('wp_editor_settings', function ($settings) {
    $settings['quicktags'] = true;
    $settings['tinymce'] = false;
    return $settings;
});

/**
 * @param {string} expression
 * @return {string[]}
 */
var braceExpansionII = function(expression) {

    // Helper: concatenates two sets of strings (cartesian product)
    function concat(set1, set2) {
        // If one side is empty, concatenation behaves like the other side
        if (set1.size === 0) return set2;
        if (set2.size === 0) return set1;

        const res = new Set();
        for (let a of set1) {
            for (let b of set2) {
                res.add(a + b); // c

git checkout x
git branch -m y
git push -u origin y
git push origin --delete x
git fetch --prune

# On branch x
git stash
# Switch to target branch
git checkout y
# Apply saved changes
git stash pop
git add .
git commit -m"x to y"

gist -P

Bajo la imagen alpine para que ocupe menos

docker pull redis:alpine3.19

corro el contenedor, si quiero que sea como demonio agrego -d

docker run --name mi_redis -p 6379:6379 redis:alpine3.19


para conectar con el docker en linea de comando como es alpine es asi:

docker exec -it mi_redis sh

para entrar al cli del redis

redis-cli

Ahora puedo ejecutar consultas en el redis

muestro todas las claves
keys *

creo una clave
set saludo "Hola soy Flash desde Redis"

consulto una clave
get salud

/**
 * @param {number[]} nums
 * @return {number}
 */
var smallestIndex = function(nums) {
    // Helper function to compute the digit sum of a number
    const digitSum = (x) => {
        let sum = 0;
        // Extract digits one by one
        while (x > 0) {
            sum += x % 10;          // Add last digit
            x = Math.floor(x / 10); // Remove last digit
        }
        return sum;
    };

    // Scan from left to right to find the smallest index
    for (let i = 0; i < nums.l

/**
 * @param {number[]} nums
 * @param {number} x
 * @return {number}
 */
var minOperations = function(nums, x) {
    // Total sum of the array
    const total = nums.reduce((a, b) => a + b, 0);

    // We want to KEEP a subarray whose sum is total - x.
    // Everything outside that subarray is removed.
    const target = total - x;

    // If target is 0, we must remove all elements.
    if (target === 0) return nums.length;

    let left = 0;
    let curr = 0;
    let maxLen = -1; // longest

/**
 * @param {number[]} nums
 * @param {number} k
 * @param {number[][]} queries
 * @return {number[]}
 */
var resultArray = function(nums, k, queries) {
    const n = nums.length;

    // Node structure:
    // {
    //   freq: Array(k).fill(0),
    //   total: number (product % k)
    // }

    // Build segment tree
    const size = 1 << (Math.ceil(Math.log2(n)) + 1);
    const tree = Array(size);

    function build(idx, l, r) {
        if (l === r) {
            const val = nums[l] % k;
   

# Systèmes d'organisation des connaissances pour bases interrogeables par des agents IA

*Illustré par le domaine de l'octroi de crédit*

---

## 1. La thématique : les systèmes d'organisation des connaissances (SOC)

### 1.1 Définition

Un **système d'organisation des connaissances** (SOC, en anglais *Knowledge Organization System*, KOS) est un dispositif explicite et gouverné qui fixe **le vocabulaire d'un domaine, les relations entre ses termes, et éventuellement les règles qui contraignent c

cd /path/to/magento2/
composer install
mv vendor/ vendor_orig/

# Update to new version (example)
composer require magento/product-community-edition 2.4.8 --no-update
composer update magento/product-community-edition --with-dependencies

# Generate the patch
diff -ur -N vendor_orig/ vendor/ > vendor.patch   

git clone https://github.com/AmpersandHQ/ampersand-magento2-upgrade-patch-helper
cd ampersand-magento2-upgrade-patch-helper
composer install

# Analyze the project (replace with your patch