Avatar 💻

recca0120 Tech Notes

Software Developer / Tech Notes

  1. Home
  2. Archives
  3. Categories
  4. Tags
  5. Search
  6. About
    1. Dark Mode

Archives

2026 77
2024 3
2023 11
2022 13
2020 15
More

Categories

PHP Laravel Testing DevOps Frontend AI Database Tools Python DevTools

Tags

Testing Laravel Php Claude Code Typescript Ai-Agent JavaScript Python PHPUnit Sqlite Composer Ai Linux Prompt-Caching Vitest AWS Blade Cloudflare Developer-Tools Devops
Featured image of post Query SQLite on GitHub Pages with sql.js-httpvfs
Frontend Database

Query SQLite on GitHub Pages with sql.js-httpvfs

Use sql.js-httpvfs to query SQLite databases hosted on static sites via HTTP Range Requests — no need to download the entire database file.

2026 年 3 月 7 日
正體中文
Sql.js Sqlite JavaScript WebAssembly
Featured image of post Browser Storage Comparison: sql.js vs IndexedDB vs localStorage
Frontend Database

Browser Storage Comparison: sql.js vs IndexedDB vs localStorage

Compare browser-side storage solutions including sql.js, IndexedDB, and localStorage by capacity, query capabilities, performance, and use cases.

2026 年 3 月 6 日
正體中文
Sql.js Sqlite IndexedDB JavaScript
Featured image of post sql.js + IndexedDB: Building an Offline-First Web App
Frontend Database

sql.js + IndexedDB: Building an Offline-First Web App

Persist sql.js SQLite databases in the browser using IndexedDB to build offline-first web applications that work without a backend.

2026 年 3 月 5 日
正體中文
Sql.js Sqlite IndexedDB JavaScript
Featured image of post Run SQLite in the Browser with sql.js: A Complete Guide from Install to CRUD
Frontend Database

Run SQLite in the Browser with sql.js: A Complete Guide from Install to CRUD

Learn how to use sql.js to run SQLite entirely in the browser — from installation and initialization to CRUD operations, import/export, and Web Workers.

2026 年 3 月 4 日
正體中文
Sql.js Sqlite JavaScript WebAssembly
Featured image of post LiVue: Use Vue 3 Directives in Laravel Blade Templates
Laravel Frontend

LiVue: Use Vue 3 Directives in Laravel Blade Templates

LiVue lets you write Vue 3 directives in Blade templates without APIs or .vue files, merging Livewire server-driven architecture with the Vue ecosystem.

2026 年 3 月 3 日
正體中文
Laravel Vue.js Blade Alpine.js LiVue
Featured image of post msw-fetch-mock: Undici-Style Fetch Mocking for MSW
Testing Frontend

msw-fetch-mock: Undici-Style Fetch Mocking for MSW

Compare msw-fetch-mock, MSW, nock, fetch-mock, and 3 other HTTP mocking libraries — with architecture analysis and concrete use-case recommendations for each.

2026 年 3 月 3 日
正體中文
Testing MSW JavaScript
Featured image of post VS Code PHPUnit & Pest Test Explorer: Setup Guide
Testing PHP

VS Code PHPUnit & Pest Test Explorer: Setup Guide

Set up PHPUnit & Pest Test Explorer in VS Code with Docker Compose, Laravel Sail, SSH remotes, and Xdebug debugging. Supports PHPUnit 7–12 and Pest 1–4.

2026 年 3 月 3 日
正體中文
PHPUnit Pest VS Code Docker Testing
Featured image of post PHP CSV: Convert Scientific Notation Back to Decimal
PHP

PHP CSV: Convert Scientific Notation Back to Decimal

Excel exports small decimals as 8.90E-05 scientific notation in CSV, breaking bcmul. Use sprintf with dynamic precision from the exponent to restore any float.

2024 年 7 月 16 日
正體中文
Php
Featured image of post 3 Ways to Eliminate Duplicate HTML Blocks in Blade Templates
Laravel PHP

3 Ways to Eliminate Duplicate HTML Blocks in Blade Templates

When Blade templates have repeating HTML, choose from @include, Component, or ob_start. ob_start is the only option that requires no additional template files.

2024 年 5 月 7 日
正體中文
Laravel Blade
Featured image of post Alpine.js Plugin for Laravel AJAX Validation Errors
Frontend Laravel

Alpine.js Plugin for Laravel AJAX Validation Errors

Build an Alpine.js errors plugin that mirrors the Laravel MessageBag API, so 422 AJAX validation errors display just as easily as the @error directive.

2024 年 4 月 19 日
正體中文
Alpine.js Laravel JavaScript Validation
1 4 5 6 7 8 9 10 11 12
© 2020 - 2026 recca0120 Tech Notes
recca0120 on GitHub
Built with Hugo
Theme Stack designed by Jimmy