core/appview/db/ at 6c6ca65b2e841d28be771b6e3f3dfe281bb6af05 · alice.pds.demo.boltless.dev/core · Tangled

alice.pds.demo.boltless.dev / core

0

This repository has no description

0

core / appview / db

30 files

at 6c6ca65b2e841d28be771b6e3f3dfe281bb6af05

eti appview: persist newsletter signup/dismiss per-user for cross-device hiding 3mo ago

appview: persist newsletter signup/dismiss per-user for cross-device hiding the newsletter widget used only localStorage to remember whether a user had signed up or dismissed it, so the cta kept reappearing whenever a user opened tangled on another device or browser. for logged-in users, store the state in a newsletter_preferences table keyed on did with an enum status ('subscribed' | 'dismissed') and the email they gave us. the home and timeline handlers read this row to decide whether to render the widget, and the server-rendered gfi banner widens when the widget is gone so the grid doesn't leave an empty column. resend stays the source of truth for the mailing list itself (sending, bounces, one-click unsubscribes) — the new table only answers the render-time question 'should this did see the widget right now?', which resend cannot cheaply answer because it's keyed on email rather than did and would add a network hop to every timeline render. anonymous visitors keep the localStorage fallback. the client-side 'already dismissed in a past session' path deliberately only calls hide() (not dismiss()) so that a stale localStorage flag can't clobber a subscribed row set from another device. Signed-off-by: eti <eti@eti.tf>

3 months ago

appview/bsky: init module to fetch and store bsky posts on loadup fetches recent tangled posts for use on landing page Signed-off-by: oppiliappan <me@oppi.li>

6 months ago

collaborators.go

appview/db: introduce GetReposPaginated also reimplement GetRepos in terms of GetReposPaginated Signed-off-by: oppiliappan <me@oppi.li>

4 months ago

appview: persist newsletter signup/dismiss per-user for cross-device hiding the newsletter widget used only localStorage to remember whether a user had signed up or dismissed it, so the cta kept reappearing whenever a user opened tangled on another device or browser. for logged-in users, store the state in a newsletter_preferences table keyed on did with an enum status ('subscribed' | 'dismissed') and the email they gave us. the home and timeline handlers read this row to decide whether to render the widget, and the server-rendered gfi banner widens when the widget is gone so the grid doesn't leave an empty column. resend stays the source of truth for the mailing list itself (sending, bounces, one-click unsubscribes) — the new table only answers the render-time question 'should this did see the widget right now?', which resend cannot cheaply answer because it's keyed on email rather than did and would add a network hop to every timeline render. anonymous visitors keep the localStorage fallback. the client-side 'already dismissed in a past session' path deliberately only calls hide() (not dismiss()) so that a stale localStorage flag can't clobber a subscribed row set from another device. Signed-off-by: eti <eti@eti.tf>

3 months ago

appview: associate users to commits by did Enables commit verification for users using a DID in place of an email address. <https://tangled.org/@tangled.org/core/issues/218> Signed-off-by: tjh <did:plc:65gha4t3avpfpzmvpbwovss7>

10 months ago

appview/db: close rows handles consistently Signed-off-by: Thomas Karpiniec <tkarpiniec@icloud.com>

7 months ago

*: correct typos throughout codebase Fix various misspellings found by the typos tool: - Error messages: Forbiden -> Forbidden, insufficent -> insufficient - Comments and docs: recieve -> receive, acheive -> achieve, etc. - Variable names: Referencs -> References, intialize -> initialize - HTML templates: Unubscribe -> Unsubscribe, explictly -> explicitly - Function names: perferom -> perform Also remove backwards compat code for is_deafult JSON field. Add _typos.toml config for false positives (external APIs, etc.) Signed-off-by: eti <eti@eti.tf>

4 months ago

add in-memory jetstream did filter

1 year ago

orm: extract orm package from appview includes query and migration helpers Signed-off-by: oppiliappan <me@oppi.li>

8 months ago

appview/db: close rows handles consistently Signed-off-by: Thomas Karpiniec <tkarpiniec@icloud.com>

7 months ago

appview: persist newsletter signup/dismiss per-user for cross-device hiding the newsletter widget used only localStorage to remember whether a user had signed up or dismissed it, so the cta kept reappearing whenever a user opened tangled on another device or browser. for logged-in users, store the state in a newsletter_preferences table keyed on did with an enum status ('subscribed' | 'dismissed') and the email they gave us. the home and timeline handlers read this row to decide whether to render the widget, and the server-rendered gfi banner widens when the widget is gone so the grid doesn't leave an empty column. resend stays the source of truth for the mailing list itself (sending, bounces, one-click unsubscribes) — the new table only answers the render-time question 'should this did see the widget right now?', which resend cannot cheaply answer because it's keyed on email rather than did and would add a network hop to every timeline render. anonymous visitors keep the localStorage fallback. the client-side 'already dismissed in a past session' path deliberately only calls hide() (not dismiss()) so that a stale localStorage flag can't clobber a subscribed row set from another device. Signed-off-by: eti <eti@eti.tf>

3 months ago

notifications.go

*: correct typos throughout codebase Fix various misspellings found by the typos tool: - Error messages: Forbiden -> Forbidden, insufficent -> insufficient - Comments and docs: recieve -> receive, acheive -> achieve, etc. - Variable names: Referencs -> References, intialize -> initialize - HTML templates: Unubscribe -> Unsubscribe, explictly -> explicitly - Function names: perferom -> perform Also remove backwards compat code for is_deafult JSON field. Add _typos.toml config for false positives (external APIs, etc.) Signed-off-by: eti <eti@eti.tf>

4 months ago

appview: add repo_did to repos/stars/pipelines tables, update queries Signed-off-by: Lewis <lewis@tangled.org>

5 months ago

appview: allow users to set their preferences for the punchcard being displayed Signed-off-by: Will Andrews <will7989@hotmail.com>

5 months ago

appview,knotserver: pref-handle display + identity ingest Lewis: May this revision serve well! <lewis@tangled.org>

3 months ago

appview: allow pub key name updating from atproto ingestion Signed-off-by: Will Andrews <did:plc:dadhhalkfcq3gucaq25hjqon>

4 months ago

appview/db: update db schemas for new pull model Signed-off-by: oppiliappan <me@oppi.li>

6 months ago

appview/db: fix off-by-1 in punchcard Date.YearDay produces an int in the range 1-365/366 but slices are indexed from 0. Signed-off-by: oppiliappan <me@oppi.li>

7 months ago

appview/db: add util to get reaction counts Signed-off-by: oppiliappan <me@oppi.li>

4 months ago

appview: hide self-referencing backlinks Signed-off-by: Seongmin Lee <git@boltless.me>

4 months ago

registration.go

appview/db: close rows handles consistently Signed-off-by: Thomas Karpiniec <tkarpiniec@icloud.com>

7 months ago

appview/db: update db schemas for new pull model Signed-off-by: oppiliappan <me@oppi.li>

6 months ago

appview/db: allow regenerating invite codes users sometimes want to regenerate invite codes, but signups_inflight never replaces the old value, since the email column has a unique constraint. by using `or replace`, we can update the invite code. this keeps the db in sync with whatever the user sees in their inbox. Signed-off-by: oppiliappan <me@oppi.li>

5 months ago

site_deploys.go

appview/{db,models}: add repo sites and deploys models/queries Signed-off-by: Anirudh Oppiliappan <anirudh@tangled.org>

5 months ago

appview/{db,models}: add repo sites and deploys models/queries Signed-off-by: Anirudh Oppiliappan <anirudh@tangled.org>

5 months ago

appview/db: propagate context through GetSpindles and AddPipelineStatus Update all call sites of db.GetSpindles and db.AddPipelineStatus to pass a context.Context, enabling proper cancellation and timeout propagation to the database layer. Signed-off-by: Matías Insaurralde <matias@insaurral.de>

4 months ago

appview/state: paginate starred repos page in user profiles Signed-off-by: oppiliappan <me@oppi.li>

4 months ago

orm: extract orm package from appview includes query and migration helpers Signed-off-by: oppiliappan <me@oppi.li>

8 months ago

appview/state: paginate starred repos page in user profiles Signed-off-by: oppiliappan <me@oppi.li>

4 months ago

appview/{db,models}: webhook tables and crud ops Signed-off-by: Anirudh Oppiliappan <anirudh@tangled.org>

6 months ago