rxliuli

"id","name","screen_name","avatar_image_url","is_blue_verified","community_role","privacy_protected","verification_verified","verification_verified_type"
"1479550299815645185","Stanley","Stanleysobest","https://pbs.twimg.com/profile_images/1730639637599883265/KDOrRfwl_normal.jpg","true","Admin","false","false",
"1383049594586624000","Louis Wei","nuture9709917","https://pbs.twimg.com/profile_images/1917144351458885632/1yvIakbQ_normal.jpg","false","Member","false","false",
"1786129630560468993","Chen Even","ChenEven173750","https://pbs.twimg.com/profile_images/1786129732159094784/Pl0swkfF_normal.png","false","Member","true","false",
"1721899115410542592","jaychan","jaychan07","https://pbs.twimg.com/profile_images/1922074241023000576/4VL_UdLw_normal.jpg","false","Member","false","false",
"1875093124722429952","SAM","quan_gui1201","https://pbs.twimg.com/profile_images/1930568650395967488/nhEyD82X_normal.jpg","false","Member","false","false",

rxliuli

// ===== 配置区:只需要改城市名 =====
const CITY_NAME = "杭州"
// ================================

const geoReq = new Request(
  `https://geocoding-api.open-meteo.com/v1/search?name=${encodeURIComponent(CITY_NAME)}&count=1&language=zh`
)
const geoData = await geoReq.loadJSON()
const LATITUDE  = geoData.results[0].latitude
const LONGITUDE = geoData.results[0].longitude

rxliuli

diff --git a/dist/sql-wasm-browser.js b/dist/sql-wasm-browser.js
new file mode 100644
index 0000000000000000000000000000000000000000..09b6e78d66345db0a6bc402b7039c10bbc7bf793
--- /dev/null
+++ b/dist/sql-wasm-browser.js
@@ -0,0 +1,181 @@
+
+// We are modularizing this manually because the current modularize setting in Emscripten has some issues:
+// https://github.com/kripken/emscripten/issues/5820
+// In addition, When you use emcc's modularization, it still expects to export a global object called `Module`,

rxliuli

id,name,screen_name,avatar_image_url,is_blue_verified,community_role,privacy_protected,verification_verified,verification_verified_type
1207019158791229440,鸟哥 | 蓝鸟会🕊️,NFTCPS,https://pbs.twimg.com/profile_images/1917439913320144897/yRxYCX7V_normal.jpg,true,Admin,false,false,
1608329485689962497,A老花|Bird🕊️,ALaoHua_Web3,https://pbs.twimg.com/profile_images/2012017640332763136/wFLVdcIQ_normal.jpg,true,Member,false,false,
1769570625126109184,y,Gamefi888,https://pbs.twimg.com/profile_images/1776939359104794624/42ViDs0W_normal.jpg,false,Member,false,false,
1724715280205836288,Akiii | 🐬 🦅,Guomin184935,https://pbs.twimg.com/profile_images/2014319827398316032/QmAgJ7hc_normal.jpg,true,Member,false,false,
1884981760481751040,Web3菜菜子| bird🕊 | MemeMax ⚡️|🐬 TermMax,jiucaicai250131,https://pbs.twimg.com/profile_images/1983761143840808960/k6iqSQKm_normal.jpg,true,Member,false,false,
1789628636603224064,Jimmy Lin,JimmyLin_Crypto,https://pbs.twimg.com/profile_images/1908925397942890496/cVqQbhrF_normal.jpg,true,Member,false,fals

rxliuli

// ==UserScript==
// @name         Clean Reddit Share Link
// @namespace    http://rxliuli.com
// @version      0.1.0
// @description  Auto clean Reddit share link tracking parameters
// @author       rxliuli
// @match        https://www.reddit.com/*
// @match        https://old.reddit.com/*
// @grant        none
// ==/UserScript==

rxliuli

MLP in VSCode

1. Install Extension: https://marketplace.visualstudio.com/items?itemName=shalldie.background
2. Change your VSCode settings
3. Restart VSCode

rxliuli

// ==UserScript==
// @name         YouTube Music Background Play
// @namespace    https://rxliuli.com
// @version      0.1.1
// @description  Keep YouTube Music playing in background
// @match        https://music.youtube.com/*
// @sandbox      DOM
// @grant        none
// @run-at       document-start
// ==/UserScript==

rxliuli

Extracting Large ZIP Files with Directory Structure in Web

Background

I initially noticed a Reddit post from someone seeking a Firefox extension that could extract ZIP files [^1]. Curious about this need, I discovered the author was using a restricted computer environment that prevented installation of local programs. This prompted me to examine existing online decompression tools, only to find that the top five online extraction tools failed to fully support:

1. Decompressing large ZIP files (tens of gigabytes)
2. Preserving directory structures when extracting folders

The video below demonstrates the performance of current online tools:

rxliuli

Converting Chrome Extensions to Safari

Origin https://rxliuli.com/blog/convert-chrome-extension-to-safari

Background

I recently attempted to convert a Chrome extension to Safari—something I had postponed due to Xcode's poor development experience. This article documents the conversion process for Redirector, which is already available on Chrome/Firefox/Edge, into my first Safari extension on the App Store.

Conversion Process

rxliuli

Svelte5: A Less Favorable Vue3

Background

Svelte5 was released in October last year, touted as the best version of Svelte to date. The team was particularly proud of "runes," a reactive state system built on proxies. However, after experiencing Vue3's Composition API and SolidJS signals, I didn't feel particularly excited. This blog outlines specific issues encountered when using Svelte5 in real projects. If you're a Svelte5 enthusiast, you might want to stop reading now.

Runes Only Work in Svelte Components or .svelte.ts Files

When trying to write hooks with runes similar to React/Vue, like useCounter: