[PR #7165] [CLOSED] 🧪 Experimenting with absurder sql #32906

Closed
opened 2026-04-18 08:52:30 -05:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/actualbudget/actual/pull/7165
Author: @MikesGlitch
Created: 3/9/2026
Status: Closed

Base: masterHead: experiment-absurder-sql


📝 Commits (2)

  • 8d5f807 experimenting with absurder sql
  • f76ff67 remove dead code, shared array buffer etc

📊 Changes

10 files changed (+71 additions, -173 deletions)

View changed files

📝 packages/desktop-client/src/browser-preload.browser.js (+2 -8)
📝 packages/desktop-client/src/browser-server.js (+0 -12)
📝 packages/desktop-client/src/budgetfiles/budgetfilesSlice.ts (+0 -3)
📝 packages/desktop-client/src/components/FatalError.tsx (+0 -72)
📝 packages/loot-core/bin/build-browser (+1 -0)
📝 packages/loot-core/package.json (+1 -1)
📝 packages/loot-core/src/platform/server/fs/index.ts (+38 -43)
📝 packages/loot-core/src/platform/server/sqlite/index.ts (+1 -17)
📝 packages/loot-core/src/server/polyfills.ts (+20 -0)
📝 yarn.lock (+8 -17)

📄 Description

Description

Still a few problems with it, but we can't use it anyway due to the licensing restrictions.

Testing

Checklist

  • Release notes added (see link above)
  • No obvious regressions in affected areas
  • Self-review has been performed - I understand what each change in the code does and why it is needed

Bundle Stats

Bundle Files count Total bundle size % Changed
desktop-client 27 → 26 14.91 MB → 14.89 MB (-19.07 kB) -0.12%
loot-core 1 5.83 MB → 7.64 MB (+1.81 MB) +31.08%
api 1 4.44 MB → 4.44 MB (+385 B) +0.01%
View detailed bundle stats

desktop-client

Total

Files count Total bundle size % Changed
27 → 26 14.91 MB → 14.89 MB (-19.07 kB) -0.12%
Changeset
File Δ Size
src/budgetfiles/budgetfilesSlice.ts 📉 -99 B (-0.82%) 11.83 kB → 11.73 kB
src/browser-preload.browser.js 📉 -210 B (-4.55%) 4.51 kB → 4.31 kB
src/components/FatalError.tsx 📉 -3.78 kB (-33.57%) 11.25 kB → 7.47 kB
node_modules/absurd-sql/dist/indexeddb-main-thread-worker-e59fee74.js 🔥 -12.94 kB (-100%) 12.94 kB → 0 B
node_modules/absurd-sql/dist/indexeddb-main-thread.js 🔥 -2.05 kB (-100%) 2.05 kB → 0 B
View detailed bundle breakdown

Added
No assets were added

Removed

Asset File Size % Changed
static/js/indexeddb-main-thread-worker-e59fee74.js 12.94 kB → 0 B (-12.94 kB) -100%

Bigger
No assets were bigger

Smaller

Asset File Size % Changed
static/js/index.js 9.56 MB → 9.56 MB (-6.13 kB) -0.06%

Unchanged

Asset File Size % Changed
static/js/workbox-window.prod.es5.js 5.64 kB 0%
static/js/ca.js 187.93 kB 0%
static/js/da.js 106.2 kB 0%
static/js/de.js 179.89 kB 0%
static/js/en-GB.js 7.18 kB 0%
static/js/en.js 170.42 kB 0%
static/js/es.js 174.37 kB 0%
static/js/fr.js 179.41 kB 0%
static/js/it.js 170.98 kB 0%
static/js/nb-NO.js 156.8 kB 0%
static/js/nl.js 113.06 kB 0%
static/js/pl.js 89.65 kB 0%
static/js/pt-BR.js 182.89 kB 0%
static/js/th.js 181.58 kB 0%
static/js/uk.js 215.35 kB 0%
static/js/resize-observer.js 18.37 kB 0%
static/js/BackgroundImage.js 120.54 kB 0%
static/js/ReportRouter.js 1.16 MB 0%
static/js/narrow.js 638.11 kB 0%
static/js/TransactionList.js 106.48 kB 0%
static/js/wide.js 164.15 kB 0%
static/js/AppliedFilters.js 9.71 kB 0%
static/js/usePayeeRuleCounts.js 11.57 kB 0%
static/js/useTransactionBatchActions.js 13.23 kB 0%
static/js/FormulaEditor.js 1.04 MB 0%

loot-core

Total

Files count Total bundle size % Changed
1 5.83 MB → 7.64 MB (+1.81 MB) +31.08%
Changeset
File Δ Size
node_modules/@npiesco/absurder-sql/pkg/absurder_sql.js 🆕 +1.85 MB 0 B → 1.85 MB
home/runner/work/actual/actual/packages/loot-core/src/server/polyfills.ts 📈 +465 B (+80.31%) 579 B → 1.02 kB
home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/index.ts 📉 -240 B (-5.79%) 4.05 kB → 3.81 kB
home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/index.ts 📉 -615 B (-6.90%) 8.71 kB → 8.1 kB
node_modules/absurd-sql/dist/indexeddb-backend.js 🔥 -30.67 kB (-100%) 30.67 kB → 0 B
node_modules/absurd-sql/dist/index.js 🔥 -6.32 kB (-100%) 6.32 kB → 0 B
View detailed bundle breakdown

Added

Asset File Size % Changed
kcab.worker.BQyszGx-.js 0 B → 7.64 MB (+7.64 MB) -

Removed

Asset File Size % Changed
kcab.worker.BD1H2IcY.js 5.83 MB → 0 B (-5.83 MB) -100%

Bigger
No assets were bigger

Smaller
No assets were smaller

Unchanged
No assets were unchanged


api

Total

Files count Total bundle size % Changed
1 4.44 MB → 4.44 MB (+385 B) +0.01%
Changeset
File Δ Size
src/server/polyfills.ts 📈 +385 B (+77.46%) 497 B → 882 B
View detailed bundle breakdown

Added
No assets were added

Removed
No assets were removed

Bigger

Asset File Size % Changed
bundle.api.js 4.44 MB → 4.44 MB (+385 B) +0.01%

Smaller
No assets were smaller

Unchanged
No assets were unchanged


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/actualbudget/actual/pull/7165 **Author:** [@MikesGlitch](https://github.com/MikesGlitch) **Created:** 3/9/2026 **Status:** ❌ Closed **Base:** `master` ← **Head:** `experiment-absurder-sql` --- ### 📝 Commits (2) - [`8d5f807`](https://github.com/actualbudget/actual/commit/8d5f8072e9428a63b4dae9f3d9a4f2552ee7592d) experimenting with absurder sql - [`f76ff67`](https://github.com/actualbudget/actual/commit/f76ff67dea5f306d0b0a7ac0064be18f03e03a57) remove dead code, shared array buffer etc ### 📊 Changes **10 files changed** (+71 additions, -173 deletions) <details> <summary>View changed files</summary> 📝 `packages/desktop-client/src/browser-preload.browser.js` (+2 -8) 📝 `packages/desktop-client/src/browser-server.js` (+0 -12) 📝 `packages/desktop-client/src/budgetfiles/budgetfilesSlice.ts` (+0 -3) 📝 `packages/desktop-client/src/components/FatalError.tsx` (+0 -72) 📝 `packages/loot-core/bin/build-browser` (+1 -0) 📝 `packages/loot-core/package.json` (+1 -1) 📝 `packages/loot-core/src/platform/server/fs/index.ts` (+38 -43) 📝 `packages/loot-core/src/platform/server/sqlite/index.ts` (+1 -17) 📝 `packages/loot-core/src/server/polyfills.ts` (+20 -0) 📝 `yarn.lock` (+8 -17) </details> ### 📄 Description <!-- Thank you for submitting a pull request! Make sure to follow the instructions to write release notes for your PR — it should only take a minute or two: https://github.com/actualbudget/docs#writing-good-release-notes. Try running yarn generate:release-notes *before* pushing your PR for an interactive experience. --> ## Description <!-- What does this PR do? Why is it needed? Please give context on the "why?": why do we need this change? What problem is it solving for you?--> Still a few problems with it, but we can't use it anyway due to the licensing restrictions. ## Related issue(s) <!-- e.g. Fixes #123, Relates to #456 --> ## Testing <!-- What did you test? How can we reproduce the issue you are fixing or how can we test the feature you built? --> ## Checklist - [ ] Release notes added (see link above) - [ ] No obvious regressions in affected areas - [ ] Self-review has been performed - I understand what each change in the code does and why it is needed <!--- actual-bot-sections ---> <!--- bundlestats-action-comment key:combined start ---> ### Bundle Stats Bundle | Files count | Total bundle size | % Changed ------ | ----------- | ----------------- | --------- desktop-client | 27 → 26 | 14.91 MB → 14.89 MB (-19.07 kB) | -0.12% loot-core | 1 | 5.83 MB → 7.64 MB (+1.81 MB) | +31.08% api | 1 | 4.44 MB → 4.44 MB (+385 B) | +0.01% <details> <summary>View detailed bundle stats</summary> #### desktop-client **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 27 → 26 | 14.91 MB → 14.89 MB (-19.07 kB) | -0.12% <details> <summary>Changeset</summary> File | Δ | Size ---- | - | ---- `src/budgetfiles/budgetfilesSlice.ts` | 📉 -99 B (-0.82%) | 11.83 kB → 11.73 kB `src/browser-preload.browser.js` | 📉 -210 B (-4.55%) | 4.51 kB → 4.31 kB `src/components/FatalError.tsx` | 📉 -3.78 kB (-33.57%) | 11.25 kB → 7.47 kB `node_modules/absurd-sql/dist/indexeddb-main-thread-worker-e59fee74.js` | 🔥 -12.94 kB (-100%) | 12.94 kB → 0 B `node_modules/absurd-sql/dist/indexeddb-main-thread.js` | 🔥 -2.05 kB (-100%) | 2.05 kB → 0 B </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** Asset | File Size | % Changed ----- | --------- | --------- static/js/indexeddb-main-thread-worker-e59fee74.js | 12.94 kB → 0 B (-12.94 kB) | -100% **Bigger** No assets were bigger **Smaller** Asset | File Size | % Changed ----- | --------- | --------- static/js/index.js | 9.56 MB → 9.56 MB (-6.13 kB) | -0.06% **Unchanged** Asset | File Size | % Changed ----- | --------- | --------- static/js/workbox-window.prod.es5.js | 5.64 kB | 0% static/js/ca.js | 187.93 kB | 0% static/js/da.js | 106.2 kB | 0% static/js/de.js | 179.89 kB | 0% static/js/en-GB.js | 7.18 kB | 0% static/js/en.js | 170.42 kB | 0% static/js/es.js | 174.37 kB | 0% static/js/fr.js | 179.41 kB | 0% static/js/it.js | 170.98 kB | 0% static/js/nb-NO.js | 156.8 kB | 0% static/js/nl.js | 113.06 kB | 0% static/js/pl.js | 89.65 kB | 0% static/js/pt-BR.js | 182.89 kB | 0% static/js/th.js | 181.58 kB | 0% static/js/uk.js | 215.35 kB | 0% static/js/resize-observer.js | 18.37 kB | 0% static/js/BackgroundImage.js | 120.54 kB | 0% static/js/ReportRouter.js | 1.16 MB | 0% static/js/narrow.js | 638.11 kB | 0% static/js/TransactionList.js | 106.48 kB | 0% static/js/wide.js | 164.15 kB | 0% static/js/AppliedFilters.js | 9.71 kB | 0% static/js/usePayeeRuleCounts.js | 11.57 kB | 0% static/js/useTransactionBatchActions.js | 13.23 kB | 0% static/js/FormulaEditor.js | 1.04 MB | 0% </div> </details> --- #### loot-core **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 1 | 5.83 MB → 7.64 MB (+1.81 MB) | +31.08% <details> <summary>Changeset</summary> File | Δ | Size ---- | - | ---- `node_modules/@npiesco/absurder-sql/pkg/absurder_sql.js` | 🆕 +1.85 MB | 0 B → 1.85 MB `home/runner/work/actual/actual/packages/loot-core/src/server/polyfills.ts` | 📈 +465 B (+80.31%) | 579 B → 1.02 kB `home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/index.ts` | 📉 -240 B (-5.79%) | 4.05 kB → 3.81 kB `home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/index.ts` | 📉 -615 B (-6.90%) | 8.71 kB → 8.1 kB `node_modules/absurd-sql/dist/indexeddb-backend.js` | 🔥 -30.67 kB (-100%) | 30.67 kB → 0 B `node_modules/absurd-sql/dist/index.js` | 🔥 -6.32 kB (-100%) | 6.32 kB → 0 B </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** Asset | File Size | % Changed ----- | --------- | --------- kcab.worker.BQyszGx-.js | 0 B → 7.64 MB (+7.64 MB) | - **Removed** Asset | File Size | % Changed ----- | --------- | --------- kcab.worker.BD1H2IcY.js | 5.83 MB → 0 B (-5.83 MB) | -100% **Bigger** No assets were bigger **Smaller** No assets were smaller **Unchanged** No assets were unchanged </div> </details> --- #### api **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 1 | 4.44 MB → 4.44 MB (+385 B) | +0.01% <details> <summary>Changeset</summary> File | Δ | Size ---- | - | ---- `src/server/polyfills.ts` | 📈 +385 B (+77.46%) | 497 B → 882 B </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** No assets were removed **Bigger** Asset | File Size | % Changed ----- | --------- | --------- bundle.api.js | 4.44 MB → 4.44 MB (+385 B) | +0.01% **Smaller** No assets were smaller **Unchanged** No assets were unchanged </div> </details> </details> <!--- bundlestats-action-comment key:combined end ---> --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-04-18 08:52:30 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#32906