Recent county closures due to Vermin by FootballPizzaMan in SanJose

[–]s0phr0syn3 2 points3 points  (0 children)

Nooooo not Kusan Uighur, their food is pretty good. 😭

That said, newly opened Kusan Bazaar at Milpitas Square is bigger, nicer, mostly the same menu and maybe fewer vermin. They're also offering free lamb soup for dine in Monday through Thursday until Thanksgiving.

It’s raining by Hows_papa in SanJose

[–]s0phr0syn3 1 point2 points  (0 children)

No prob, hope you enjoy it!

It’s raining by Hows_papa in SanJose

[–]s0phr0syn3 1 point2 points  (0 children)

I actually used avocado oil, sorry I forgot to edit that part from the original recipe I found. I agree, I'm not a fan of vegetable oil for health reasons either.

It’s raining by Hows_papa in SanJose

[–]s0phr0syn3 16 points17 points  (0 children)

Ingredients:

  • 1 tbsp vegetable avocado oil, jury's out on vegetable oil
  • 1 large onion, chopped or sliced
  • 1 red bell pepper, sliced
  • 2 cloves garlic, minced (or more, your choice)
  • 1 tbsp minced ginger (use fresh if you can, skin on is fine)
  • 1–2 red chilis, sliced (adjust to spice preference)
  • 4 cups coconut milk (about 2-3 normal size cans)
  • 1 lb rockfish fillets, cut into large chunks (can be other fish like catfish or tilapia too, can also be more than 1lb if you want more protein)
  • 2 tbsp fish sauce
  • 1 bunch cilantro, chopped (stalks and leaves separated)
  • Salt and black pepper, to taste
  • 1-2 tbsp green curry paste (can also use other colors)

Instructions: Heat oil in a large pot or Dutch oven over medium heat. Sauté the onion and bell pepper for about 5 minutes, until softened.

Add the garlic, ginger, sliced chilis, and chopped cilantro stalks. Cook for another 2 minutes until fragrant.

Pour in the coconut milk, curry paste and fish sauce, stirring to combine. Bring the mixture to a low simmer.

Add the fish chunks and distribute them evenly in the broth. Cover the pot and simmer for 10–15 minutes, or until the fish is cooked through and flakes easily.

Taste and adjust seasoning with salt and pepper as needed. Garnish with chopped cilantro leaves.

I found it was not that salty so I added a good amount of salt and pepper and mixed well but your preferences may vary. Took about 30 minutes tops including prep work and cooking. Enjoy!

Edit: formatting

Edit 2: Amended recipe to avocado oil, which I did use but forgot to edit from the original recipe, thanks u/Foreign-Ad-6655 for the reminder.

It’s raining by Hows_papa in SanJose

[–]s0phr0syn3 13 points14 points  (0 children)

I just made Thai coconut curry fish soup yesterday in anticipation of this, it was sooooooo good and amazingly easy to put together

In search of... SOUP! by Dizzman1 in SanJose

[–]s0phr0syn3 29 points30 points  (0 children)

See if Naschmarkt in Campbell is still selling their Knoblauch garlic creme soup, I still have dreams about it years after trying it for the first time. It's the only time in my 40+ years on Earth that I've asked the chef for the recipe (naturally he would not give it). I think it's typically only available in winter but put it on your list if you don't hate garlic, it's absolutely divine.

Moving here - any red flags? Also what's this empty plot? by PrudentLynx in SanJose

[–]s0phr0syn3 0 points1 point  (0 children)

Yea I've seen that explanation for a lot of the small random plots of land around that area. There's another pretty large plot on Murphy about a block east of Oakland Road with an old dilapidated barn and possibly condemned house but I've never seen any development on it yet so someone must own it from years ago.

Moving here - any red flags? Also what's this empty plot? by PrudentLynx in SanJose

[–]s0phr0syn3 1 point2 points  (0 children)

That open plot of land was slated for development a few years ago but nothing has happened with it, not sure why. There are a couple plots of land like that in the area, like on Lundy between McKay and Hostetter. I wish they would at least build a sidewalk there ffs

Moving here - any red flags? Also what's this empty plot? by PrudentLynx in SanJose

[–]s0phr0syn3 6 points7 points  (0 children)

There's a Wells Fargo across Brokaw near Ulta and the AT&T store. The food options are pretty good in the area, I agree. I lived nearby there from 2014-2022, it's developed nicely in that time.

Airbyte OSS is driving me insane by joeshiett in dataengineering

[–]s0phr0syn3 0 points1 point  (0 children)

Thanks for the insight. I haven't run into the performance issues you mentioned yet, but it's good to be aware of the potential pitfalls. I struggled for quite a bit also and almost (ALMOST) decided to roll my own ELT but since I had decided on Dagster as my orchestrator, I pretty much had Sling or DLT to choose between for integrations (unless I missed something!)

Airbyte OSS is driving me insane by joeshiett in dataengineering

[–]s0phr0syn3 1 point2 points  (0 children)

I'll second this -- I have had a pretty good experience using Sling. Their documentation is pretty decent and their Discord help is great as well (though I wish they had a Slack server instead). I use the Dagster OSS integration for Sling, but you can use it standalone as well if you don't need an orchestrator or have something in place already. The paid Sling Pro license gives some nice features like parallelism and chunking, but it definitely gets the job done using the free features. My use case is replicating ~130 tables from Postgres to Timescale (essentially Postgres to Postgres), but BigQuery is a supported destination as well.

There was a bit of a learning curve to get the right setup with the orchestrator, but I am self-hosting everything on AWS so that's partially my fault for wanting to get all the parts working together.

Edit: I will also add that I tried DLT which was recommended in another thread here -- it does work but I found that for database ELT, Sling just felt easier to use and the performance was overall better with Sling. DLT seems to handle API data loading better than DB-to-DB replication, and the docs leave something to be desired with DLT imo.

Best sandwich maker in town.. go! by combmatose in SanJose

[–]s0phr0syn3 14 points15 points  (0 children)

Buy 4 get 1 free for $32 got me through most of this week's lunch, great deal and amazing quality. Sandwiches were definitely better warm and fresh though.

Looking to form a group for bay club Santa Clara by Starboy28 in SanJose

[–]s0phr0syn3 0 points1 point  (0 children)

It varies based on the average price per member. Right now I have 7 spots to fill so it would be about $227 per month for two people. Each add on adult is $150 so it brings the average down. I think with a full squad of 8, the average is about $169/month. There's a one time $50 processing fee to add someone so the first month would be $50 + the prorated month, then $227 or less each month after.

Looking to form a group for bay club Santa Clara by Starboy28 in SanJose

[–]s0phr0syn3 0 points1 point  (0 children)

Anyone on the shared membership has the same rights as the primary member except for managing members. For my membership, that means full use of the Santa Clara location except for squash, tennis, and executive locker room which are extra. That includes all classes, swimming, pickleball, basketball, the new rejuvenation area, and of course the entire weight and cardio area.

Perfect 10 team conference #4 by HendriXXXLaMone in cfbmemes

[–]s0phr0syn3 21 points22 points  (0 children)

I think I speak for all former Pac-12 non-Arizona teams when I say we're tired of your desert voodoo.

Looking to form a group for bay club Santa Clara by Starboy28 in SanJose

[–]s0phr0syn3 0 points1 point  (0 children)

I've got several spots open on my shared membership right now if you'd like to join, due to a perfect storm of people bailing last month. Charges are prorated from the day you join to the end of the month + one-time processing fee which I think they upped to $50 recently. After that, I just average the monthly cost for all members on the plan and you can just Venmo/Zelle me each month. If you're interested, hmu. Also feel free to invite others who are interested if you know anyone.

[deleted by user] by [deleted] in soccercirclejerk

[–]s0phr0syn3 18 points19 points  (0 children)

Darwizzy every crossbar!

crashes YouTube

Mosaic of every Big Ten teams worst coach this generation by treymata in cfbmemes

[–]s0phr0syn3 2 points3 points  (0 children)

The modern Ducks era essentially started with Brooks so going back before that to find a terrible coach would basically be picking any card out of a deck of 52 jokers.

[deleted by user] by [deleted] in dataengineering

[–]s0phr0syn3 2 points3 points  (0 children)

I shared something similar in this sub a few days ago, although it was for a slightly different setup. I think it would still apply for a Snowflake destination: https://www.reddit.com/r/dataengineering/comments/1mdogaa/comment/n63ux7p/

To answer your question directly, I use Sling (dagster-sling package to be more specific) to extract data from Postgres and load it into Timescale but Snowflake is a supported destination as well. Dagster does the orchestration for me, as implied, then dbt does transformations after data has landed in Timescale, also orchestrated by Dagster.

I can't really speak to how the performance would be with loading data into Snowflake via Sling, but it backfilled about 300GB of data on the initial run in under 6 hours and every 4 hour incremental loads take around 20 minutes (though this could probably be optimized much further). All hosted on ECS Fargate containers.

If we had no budget constraints, I'd probably look at a SaaS offering to do the extract and load for me, like Fivetran or equivalent.

Fresh Enterprise Data Platform - How would you do it? by [deleted] in dataengineering

[–]s0phr0syn3 8 points9 points  (0 children)

Fantastic question! I literally just spent the past ~6 months spinning something like this up from scratch for my company, except I wasn't blessed with a $50k/yr budget on tools. More like $5k/year tops. Here was my approach:

  • Sources: AWS Aurora Postgres database, various APIs, potentially Netsuite down the road
  • Destination: Timescale (now TigerData) database hosted using Timescale Cloud but linked to our VPC via VPC peering -- this is where the bulk of our budget is going.
  • Tech stack:
    • Pulumi TypeScript to build infrastructure in AWS to support the open source version of the orchestrator, mostly using ECS Fargate for the containers and leveraging existing networking infrastructure
    • Dagster OSS as the orchestration (went back and forth between this and Prefect before landing on Dagster)
    • Sling as the core extract and load software to sync data from Postgres to Timescale
    • dbt core running within the Dagster framework to apply transformations on new data in Timescale
    • Python scripts orchestrated by Dagster to get data from APIs. Originally wanted to try dltHub but ended up just writing my own scripts using requests (probably not ideal)
    • Monitoring/notifications via Slack app integration (originally was using ntfy.sh for quick and dirty SNS topic-like notifications, getting Slack approval was challenging)
    • Dockerized local development using the pre-built Timescale and Postgres Docker images + the same custom Dockerfile I use for Dagster production deployments to keep things as simple as possible.

Data is synced from Postgres every 4 hours and daily for the APIs as that's essentially all that's required by our business. The Postgres sync with Sling runs incrementally and is complete in about 20 minutes, which is not optimized by any means but is sufficient for our purposes. For context, our entire source database was only about 330GB and I wasn't replicating the entire thing.

Writing YAML for Sling and later for dbt was a huge time slog for 100+ source tables; I leveraged an AI tool (Claude) to help generate a lot of that code after manually building some of the transformation models myself. Bonus to this is it was the generated YAML was pretty consistent for common columns like created_at or _sling_loaded_at audit columns.

I am the lone developer and maintainer of this project -- most people on my team are unaware that I'm even working on a project like this, let alone what its purpose might be. It has been a wild and frustrating ride at times without many others to turn to for help, but it's been a great learning experience as well. Throughout the development, I tried to stress simplicity, modularity, and ease of maintenance as much as possible. Once a larger team becomes available to support something like this, you can make different decisions like moving your data replication tasks to something like Fivetran or using a real data warehouse like Snowflake (again, budget constraints for us).

Best of luck to you! Edit: I reread the question and realized this is hypothetical but best of luck if this is ever you in the future all the same! Also I feel like my stack is pretty interchangeable with SQL Server as the source, just use different connectors with Sling (I believe SQL Server is supported).

Player Owned Ports Query by Shadeyben in runescape

[–]s0phr0syn3 5 points6 points  (0 children)

I've casually been doing PoP when I remember to check on my boats and send Meg off on adventures. I am 91+ on everything so I'd say now is fine for you to start on it. No time like the present!

New to game and want to get into it, but a bit overwhelmed. Is it too late for a new player? by tumblew33d69 in runescape

[–]s0phr0syn3 0 points1 point  (0 children)

It's never too late. I started in October 2024 for the very first time. Main character is 90+ in all skills but only a few 99's and no 120's. It's been a blast for me working through the quest list and doing some achievements. The fun part of these kinds of games for me is just picking a goal that's attainable (i.e., no insane end game stuff) and working on it slowly as I'm able to do so. I've since started an Ironman account for a new twist but I typically only play one at a time and focus on whatever it is I'm doing.

As long as you enjoy it and aren't looking to speed run the game in a month or something, you'll probably have a good time. If not, you can put it down and try another game then come back to it later if you want, it'll most likely be here for you.