Cacher is the code snippet organizer for pro developers

______ JEANSON ANCHETA _______


💻💸 Fresh Logs Pricing 💸💻
🔐 UK Logs / Clean Bank Drops (GBP)
💰 10K GBP = $250
💰 12K GBP = $300
💰 16K GBP = $350
💰 20K GBP = $500
💰 30K GBP = $800

🛡️ Verified • HQ Access • Fast Delivery
💬 DM for escrow or direct 🔥
WESTERN UNION / MONEY GRAM/BANKS LOGINS/BANK TRANFERS/PAYPAL TRANSFERS WORLDWIDE/CASHAPP/ZELLLE/APPLE PAY/SKRILL/VENMO TRANSFER
Telegram:@JeansonCarder     
Group: https://t.me/+2__ynBAtFP00M2Fk                 
Group: https://t.me/+CsF2t7HvV_ljMmU8

# Liquibase HOW TO

## Modify changeset to be ignored by liquibase (if it causes issues)

Update the change set and replace the content with a comment for liquibase to let it pass.

```xml
<changeSet id="ignore-faulty-changeset" author="dev" runOnChange="false">
    <validCheckSum>ANY</validCheckSum>
    <comment>
        This changeset has been retired as the SQL was too demanding for the
        server. The original changeset attempted to move X records to a new
        table but the operation

/**
 * @param {character[]} letters
 * @param {character} target
 * @return {character}
 */
var nextGreatestLetter = function(letters, target) {
    // Binary search boundaries
    let left = 0;
    let right = letters.length - 1;

    // This will store the index of the smallest letter > target
    let answerIndex = -1;

    while (left <= right) {
        // Middle index
        let mid = Math.floor((left + right) / 2);

        // Case 1: letters[mid] is strictly greater than target
        /

def load_custom_css():
    st.markdown("""
        <style>
        /* Main container styling */
        .main {
            padding: 2rem;
        }
        
        /* Header styling */
        .custom-header {
            background: linear-gradient(90deg, #667eea 0%, #764ba2 100%);
            padding: 2rem;
            border-radius: 10px;
            color: white;
            text-align: center;
            margin-bottom: 2rem;
            box-shadow: 0 4px 6px rgba(0, 0, 0,

/**
 * @param {string} source
 * @param {string} target
 * @param {string[]} original
 * @param {string[]} changed
 * @param {number[]} cost
 * @return {number}
 */
var minimumCost = function (source, target, original, changed, cost) {
    // A very large BigInt used to represent "infinity"
    const INF = BigInt("18446744073709551615");

    // Map each unique substring to a numeric ID
    const id = new Map();

    // Track all substring lengths that appear in rules
    const lens = new Set();

// (targetType) value

byte myNewByteValue = (myMinByteValue / 2)

// |  Error:
// |  incompatible types: possible lossy conversion from int to byte
// |  byte myNewByteValue = (myMinByteValue / 2);
// |                         ^----------------^

byte myNewByteValue = (byte) (myMinByteValue / 2)
myNewByteValue ==> -64

EXPLAIN FORMAT=JSON
SELECT
    id,
    status,
    freeRoundFeature
FROM
    AccountFreeSpin
WHERE 1
  AND id IN (1)
--- живой
EXPLAIN ANALYZE
    SELECT
    id,
    status,
    freeRoundFeature
FROM
    AccountFreeSpin
WHERE 1
  AND id IN (1)

<nav class="toc">
<ol class="toc-list">
  <li><a href="#section1" class="link">セクション1</a></li>
  <li><a href="#section2" class="link">セクション2</a></li>
  <li><a href="#section3" class="link">セクション3</a></li>
  <li><a href="#section4" class="link">セクション4</a></li>
</ol>
</nav>

<main>
<section id="section1" class="section">
  <h2>セクション1</h2>
</section>
<section id="section2" class="section">
  <h2>セクション2</h2>
</section>
<section id="section3" class="section">
  <h2>セクション3</h2>
</section>
<section id=

# Load in study data
# -- for creating the 'unlinked' files, general demog checking, and eventually extracting the index date
create table prj20240401_demog(studyid varchar, first_name varchar, middle_initials varchar, last_name varchar, dob varchar, sex varchar, address_1 varchar, suburb varchar, address_3 varchar, postcode varchar, hsn_issued_date varchar);
\copy prj20240401_demog from minehealth.txt delimiter E'\t';
delete from prj20240401_demog where studyid='HSN_NUM';
#244085

# 

For all WACR records in WADLS, Epi have requested a one-off extract of:
-       WACR OID (raw, no encryption needed)
-       LGA (1996, 2001, 2006, 2011, 2016, 2021)
-       SLA (1996, 2001, 2006)
-       SA2 (2011, 2016, 2021)
______________________________________________________________

Total no. of records
>> SELECT COUNT(distinct lpno) AS total_count
FROM cancdata ;
 total_count
-------------
      632419
>>\pset format unaligned
>>\pset footer off
# Copy the required conten

<script>
  require(['//media.weplayed.com/widget/v1/widget.js'], function ($) {

    // 1) Fix: aria-hidden="true" must not be focusable
    function fixAriaHiddenFocusable(root = document) {
      let changed = false;
      root.querySelectorAll('[aria-hidden="true"][tabindex]').forEach(el => {
        const ti = el.getAttribute('tabindex');
        if (ti === '0') {
          el.setAttribute('tabindex', '-1');
          changed = true;
        }
      });
      return changed;
  

# Flux de données dbt — Vue complète

## Schéma global

```
┌─────────────────────────────────────────────────────────────────────────────┐
│                              FICHIERS SOURCE                                │
├─────────────────────────────────────────────────────────────────────────────┤
│                                                                             │
│   seeds/sample_data/              seeds/reference/                          │
│   ├── raw_customers.csv           ├── 

# DuckDB CLI — Cheatsheet inspection

## Ouvrir une base

```bash
duckdb dev.duckdb
```

## Schemas

```sql
-- Lister tous les schemas
SELECT * FROM duckdb_schemas();

-- Filtrer les schemas utilisateur (non internes)
SELECT schema_name FROM duckdb_schemas() WHERE internal = false;

-- Schema courant
SELECT current_schema();

-- Changer de schema
USE main_raw_dev;
```

## Tables

```sql
-- Lister toutes les tables (tous schemas)
SHOW ALL TABLES;

-- Lister les tables du schema courant
SHOW TABLE

# クロスサイトコンバージョン計測（img ピクセル方式）

サイトA（送客元）からサイトB（送客先）への遷移を計測する汎用的な手法。
CMS や特定のサービスに依存しない、ピュア HTML + JavaScript で実現できるアプローチ。

---

## 前提

- サイトA とサイトB は異なるドメインで運用されている
- サイトB には複数の流入経路があり、サイトA 経由のユーザーのみを識別・計測したい
- サイトA 側に計測データを受け取る API エンドポイントが存在する

---

## 手順概要

### 1. サイトA → サイトB へのパラメータ付き遷移

サイトA からサイトB への遷移リンクに、一意の識別子をパラメータとして付与する。

```
https://siteb.hoge?id=fuga123
```

この識別子（以下 `click_id`）により、サイトB 側で「サイトA 経由の流入である」と判定できる。

### 2. サイトB 側で URL パラメータを Cookie に保存

サイトB の LP（ランディングページ）で、URL パラメータか

# dbt seed — Guide pédagogique

## Ce que `dbt seed` fait

1. **Parse** les fichiers YAML pour connaître la configuration (schema, types, colonnes)
2. **Pour chaque fichier CSV** dans `seeds/` :
   - Supprime la table si elle existe (DROP)
   - Crée la table avec les types définis (CREATE)
   - Insère les données du CSV (INSERT)

## Ce que `dbt seed` ne fait PAS

| Action | Commande |
|--------|----------|
| Exécuter les models | `dbt run` |
| Exécuter les tests | `dbt test` |
| Compiler le SQL 

# Cascade de configuration dbt

## Principe

dbt applique les configurations par héritage : le niveau le plus spécifique gagne toujours.

## Niveaux de priorité

```
┌─────────────────────────────────────────────────────────────┐
│  1. config() dans le fichier SQL        ← Plus spécifique   │
├─────────────────────────────────────────────────────────────┤
│  2. Fichier YAML (_seeds.yml, _models.yml)                  │
├─────────────────────────────────────────────────────────────┤
│  3. dbt_proj