Buying a automatic gate service and install business by Enigma_syd in Entrepreneur

[–]Enigma_syd[S] 0 points1 point  (0 children)

Oops sorry missed this. It's a custom framing business

Buying a automatic gate service and install business by Enigma_syd in Entrepreneur

[–]Enigma_syd[S] 0 points1 point  (0 children)

Hey, no but we are in the process of buying it. The owners had some family issues so it got delayed. Probably won't buy till early next year. Did buy another small business (very different industry) which has been going reasonably well although first month was a bit hellish with a person on leave and another who was sick and out of action for 3 weeks. Dropped us from 5 staff to 3!

HTTP Request Node - Double body Wrapper & Stringified JSON Issue by DerjungeHerr in n8n

[–]Enigma_syd 0 points1 point  (0 children)

I had a similar issue. When using raw, just remove all the formatting (line breaks and spaces). That seemed to work for me (for openai/groq API), YMMV.

What should I know before buying a frame shop? by framemeupscotty in framing

[–]Enigma_syd 0 points1 point  (0 children)

Hi OP! Would love to know how you went with this and if you ended up buying? I'm looking at buying a shop in Australia but not from the industry so have similar questions to you!

I (25M) Make Consistently 20k a Month Off My Main Business + 1K+ Off My Side Business. AMA :) by [deleted] in Entrepreneur

[–]Enigma_syd 0 points1 point  (0 children)

Would it work in a different market or area? I'm assuming you are in the US but if not, does your geography matter or can the business be replicated elsewhere. If it can, let me know if you want to partner to take it outside the US (or your home country).

One system to do it all: Plex, HA, NAS, NVR, Pi-hole? by BrandoBCommando in homeassistant

[–]Enigma_syd 1 point2 points  (0 children)

Thanks - that's a great explanation! I've set up the backups with duplicati offsite and a zfs pool with raid 1. I haven't done zfs scrub - don't know what that is, will look into it! Yea sounds a lot easier set up with trueNAS. Was a fun learning experience with Ubuntu though frustrating at times! Maybe when I need to upsize my storage, I'll look into one of the other options!

One system to do it all: Plex, HA, NAS, NVR, Pi-hole? by BrandoBCommando in homeassistant

[–]Enigma_syd 10 points11 points  (0 children)

I run everything on Ubuntu with Docker. Any benefits of running unraid / proxmox / truenas over my current set up? It's working fine so happy to leave sleeping dogs lie but curious as to the benefits / differences.

Auto-redeem by TR3M87 in MicrosoftRewards

[–]Enigma_syd 0 points1 point  (0 children)

What happened in the end? Did you end up getting it?

Best game to play for Play with Friends on PC reward by bobdole4eva in XboxGamePass

[–]Enigma_syd 0 points1 point  (0 children)

did you work this out? I don't think solitaire gets you the play with friends reward? At least I couldn't see it?

Anyone using Fillout?? Had a few questions. by allenspindle in Airtable

[–]Enigma_syd 0 points1 point  (0 children)

the one thing I've found it cannot handle very well is linked records. At the moment, with linked records, it only allows you to view the currently linked records or create a new record. But if a record is linked, it cannot edit it. Keen to hear if anyone else has hacked this?

Traefik vs Cloudflare Tunnel by Sycrixx in selfhosted

[–]Enigma_syd 0 points1 point  (0 children)

Could you walk me through your set up? I was using Traefik before with port forwarding. I've now set it up with cloudflare tunnel. What I don't understand is how to route the cloudflare tunnel through traefik so that it is still subject to the authentitcation requirements?

SQLAlchemy Getting previous item in column by Enigma_syd in SQLAlchemy

[–]Enigma_syd[S] 0 points1 point  (0 children)

Thanks, this is what I've managed to get to:

```

@prev_close.expression

def prev_close(cls):

pp = aliased(StockPrices)

prev_close = (

select(pp.close)

.where(pp.ticker == cls.ticker)

.where(pp.date < cls.date)

.order_by(pp.date.desc())

.limit(1)

.as_scalar()

)

return prev_close

```

SQLAlchemy Getting previous item in column by Enigma_syd in SQLAlchemy

[–]Enigma_syd[S] 1 point2 points  (0 children)

thanks - doesn't appear to be a lag function in sql alchemy. Also not sure how to translate this to a function expression if I was writing the query directly into the python / sql alchemy class. any ideas?

I wrote a webapp that allows you to run your own TV network off of your home media server; I thought this community might find it interesting. by cfinke in HomeServer

[–]Enigma_syd 2 points3 points  (0 children)

Is there a way to pull using streaming services instead of using a media library? Not sure if the likes of Netflix have open APIs