What are you working on this week? \ stacker news ~meta

pull down to refresh

534 sats \ 18 comments \ @sn 2 Apr meta bot

Calling all stackers!

Leave a comment below to let the SN community know what you're working on this week. It doesn't matter how big or small your project is, or how much progress you've made.

Just share what you're up to, and let the community know if you want any feedback or help.

view all related items

81 sats \ 1 reply \ @south_korea_ln 2 Apr

Trying to finish 2 back-to-back manuscripts with collaborators in Texas. www.overleaf.com has really come a long way for collaborative tex file editing... Gone are the days of duplicate files in Dropbox due to syncing issues.

0 sats \ 0 replies \ @SimpleStacker 23h

Have you tried overleaf GitHub integration? That'd be the next step for me to figure out

55 sats \ 0 replies \ @TNStacker 20h

Over-clocking these bad boys!

67 sats \ 0 replies \ @carter 2 Apr

Got tailscale and ollama setup so I can vpn to a remote llm I control. I plan on adding MCP #931253 server soon as well as a UI

Vibe coded a visualization of the Libertarian Convention Theme fundraiser (It's in Grand Rapids this time) https://lp-theme.puter.site/

65 sats \ 0 replies \ @Car 22h

PlebTV stuff & Startup School 👀

10 sats \ 0 replies \ @mrtali 18h

Taking back an old Newsletter project named "Epilogue". It was meant to be for designers clients but I pivoted to add some orange concepts.

221 sats \ 0 replies \ @ek 2 Apr

horse and gun as wallet badges instead of streaks
wallet prompt on post:

more wallet refactoring as foundation for new wallet flow:

151 sats \ 2 replies \ @k00b 2 Apr

So far I've been doing more admin, code review, and bug fixing things, with the occasional refactor ideation sesh.

This morning, I'm going to vibe code a script to pay our developer bounties using NWC. Then, review code. Then, begin refactoring. It's kind of sad but lately my own development time is kind of the lowest priority thing most days.

0 sats \ 1 reply \ @SimpleStacker 23h

Since you're talking about refactoring, is there a better way to make DB updates than with Prisma migrations?

It can get very hard to follow since tables get defined and redefined in migration files instead of in one place. I checked and Prisma says you can't define a materialized view in the schema, so that's kinda sucky. But even things like custom functions... do they need to be defined in migration files? I may be asking for too much here...

30 sats \ 0 replies \ @k00b 23h

Yep, views and store procedures have to be defined in migrations sadly. sndev psql can help you inspect stuff pretty well though.

stackernews=# \dv
                  List of relations
 Schema |            Name             | Type | Owner 
--------+-----------------------------+------+-------
 public | all_days                    | view | sn
 public | all_months                  | view | sn
 public | days                        | view | sn
 public | hot_score_constants         | view | sn
 public | last_24_hours               | view | sn
 public | today                       | view | sn
 public | zap_rank_constants          | view | sn
 public | zap_rank_personal_constants | view | sn
(8 rows)

stackernews=# \dm
                        List of relations
 Schema |            Name             |       Type        | Owner 
--------+-----------------------------+-------------------+-------
 public | all_days                    | view              | sn
 public | all_months                  | view              | sn
 public | days                        | view              | sn
 public | hot_score_constants         | view              | sn
 public | hot_score_view              | materialized view | sn
 public | item_growth_days            | materialized view | sn
 public | item_growth_hours           | materialized view | sn
 public | item_growth_months          | materialized view | sn
 public | last_24_hours               | view              | sn
 public | reg_growth_days             | materialized view | sn
 public | reg_growth_hours            | materialized view | sn
 public | reg_growth_months           | materialized view | sn
 public | rewards_days                | materialized view | sn
 public | rewards_today               | materialized view | sn
 public | sat_rank_tender_view        | materialized view | sn
 public | sat_rank_wwm_view           | materialized view | sn
 public | spender_growth_days         | materialized view | sn
 public | spender_growth_hours        | materialized view | sn
 public | spender_growth_months       | materialized view | sn
 public | spending_growth_days        | materialized view | sn
 public | spending_growth_hours       | materialized view | sn
 public | spending_growth_months      | materialized view | sn
 public | stackers_growth_days        | materialized view | sn
 public | stackers_growth_hours       | materialized view | sn
 public | stackers_growth_months      | materialized view | sn
 public | stacking_growth_days        | materialized view | sn
 public | stacking_growth_hours       | materialized view | sn
 public | stacking_growth_months      | materialized view | sn
 public | sub_stats_days              | materialized view | sn
 public | sub_stats_hours             | materialized view | sn
 public | sub_stats_months            | materialized view | sn
 public | today                       | view              | sn
 public | user_stats_days             | materialized view | sn
 public | user_stats_hours            | materialized view | sn
 public | user_stats_months           | materialized view | sn
 public | user_values_days            | materialized view | sn
 public | user_values_today           | materialized view | sn
 public | zap_rank_constants          | view              | sn
 public | zap_rank_personal_constants | view              | sn
 public | zap_rank_personal_view      | materialized view | sn
 public | zap_rank_tender_view        | materialized view | sn
 public | zap_rank_wwm_view           | materialized view | sn
(42 rows)

Then, I'll usually just search in primsa for them. I'll be going through and deleting some of these unused views soon. I'll create a doc for them all while I'm doing that.

21 sats \ 0 replies \ @BitcoinIsTheFuture 23h

Time for another round of getting my sats to cold storage and condensing UTXO’s. I also have some on chain sats stuck on Zeus and I think I need to use Sparrow to access them.

0 sats \ 0 replies \ @alt 1h

I built a gaming PC this week. Took me two evenings, including the time needed to troubleshoot some issues with booting it for the first time, and installing the OS.

Having never done it before, I was pleasantly surprised with how straightforward it was.

It is a birthday gift for my fiancée.

0 sats \ 0 replies \ @decent 4h freebie

I've been working on my homelab, trying to build a gitops managed k8s cluster on bare metal. Then self host as much as feasible to achieve a sovereign computing stack.

As of this week the main focus is to get more worker nodes added, and designate a subset to my "test" env.

0 sats \ 0 replies \ @Tuda 9h

Chasing deadlines exhausts me. So I checked out to rest.

0 sats \ 0 replies \ @TheWildHustle 12h

RUNSTR zap.store release and graphene compatibility

0 sats \ 0 replies \ @GCOIN 16h

I am currently involved in three parallel projects, each fueling a different part of my life - professional ambitions, personal growth, and passion for helping others.

Project 1 - Scientist: As a scientist I am focusing on understand a mode of communication between different organs also called inter-organ communication.

Project 2 - Life Beyond striving for a balanced lifestyle with healthy eating and regular exercise. I take a methodical approach to financial management with my partner. We create detailed budgets for every category - clothing, travel, food, healthcare, gifts, amortizations, and more - while setting savings goals. Our strategy includes traditional investments (stocks), fiat money (for daily purpose) and of course bitcoin where we are still learning.

Project 3 - Hobby Financial education, nutrition, and exercise are fundamental to a thriving life, yet many people lack the knowledge to make informed decisions. Unfortunately, they often rely on hearsay rather than dedicating time to self-education. My partner and I are brainstorming ways to bridge this gap-how can we make learning engaging for those who don´t usually read blogs or listen podcasts? We are still refining our approach, but our mission is clear: empower people with essential knowledge to improve their lives.

0 sats \ 0 replies \ @flat24 21h

I continue working just like every week ... in the biggest project that I can ever do.

"Learn about Bitcoin to be able to handle my resources (wealth/energy) without permission and be totally free"

💪🤠⚡🍊

0 sats \ 0 replies \ @ContraMundum5 22h

This week, I’ve been brainstorming ways to make Nostr more engaging for creators and the community. Thinking about how to build fun, competitive events, kind of like #zapathon, but with new twists. Also exploring ways to help creators showcase sneak peeks of their work and get zaps for it.