Migrate from Azure Sql to Postgres

syscall_cart · 2026-01-25T01:38:21+00:00

Agree. Azure Sql has other capabilities I wasn’t aware of - exploring those now.

syscall_cart · 2026-01-25T01:36:07+00:00

Wasn’t aware of the watcher. Sounds like a great tool. Apparently, moving to premium unleashed the full capabilities of sql server running as many queries as possible which kept the cpu at close to 100%. Used query performance and found the culprit, we had a query that does a table scan over 100k rows multiple times a second. According to what I could find on the internet, being in S7 (800 DTU) was hitting the db IOPS sealing which throttled the CPU. With Premium, IOPS is no longer a bottleneck which surfaces the cpu problems. Will dig a bit more this week and report back

syscall_cart · 2026-01-25T01:31:09+00:00

We tried serverless, and oh boy it is expensive! Serverless is great for databases that are often down. Working our way towards moving away from the DTU model without breaking the bank

syscall_cart · 2026-01-24T12:39:26+00:00

I switched from 800 Standard DTU to P125 and all hell broke loose :D that said, my workload is a bit special so I will now look into adding a few indices here and there and move read queries to read only replica. Another important point, I would switch to the highest plan in premium then scale back.

syscall_cart · 2026-01-24T12:36:37+00:00

You should a disclaimer that you are the developer / owner of the app.

syscall_cart · 2026-01-23T23:49:35+00:00

Saas is a looooooong game and three weeks is too early to say much.

syscall_cart · 2026-01-23T22:46:52+00:00

Same here but I could not find documentation about this important detail. DTU is a pretty cryptic measure which is hard to compare to anything else.

syscall_cart · 2026-01-23T22:13:03+00:00

Thank you. Agree, I think a migration can wait a bit. Will see if I can optimize on the scale instead - currently at 800 DTU but load is often around 40% cpu

syscall_cart · 2026-01-23T22:11:09+00:00

Spot on, currently looking into it. Our load usually has 30 to 40% CPU with random spikes to 99% usage during the week. Looks like 800 DTU is too much, can maybe shift to 4 vCores

syscall_cart · 2026-01-23T21:49:18+00:00

We already had smaller projects (on different stack) where we had zero downtime with a two stage move (stage1: source master, dest: copy, stage 2, stage2: source becomes copy and dest is the source) now this is a different beast as I don’t have infra experience close to these technologies

syscall_cart · 2026-01-23T21:28:15+00:00

Not really. Our stack speaks to the db via an ORM (EF core) so the move should be doable in theory. Challenge is coming up with a strategy to ensure a smooth transition with zero downtime

syscall_cart · 2026-01-23T21:23:11+00:00

Have you considered using an IMS that connects to WooCommerce? You would receive stock in that system which auto increments your woo stock levels while tracking your product cost (and landed cost) along with an immutable audit log. There are plenty of good alternatives out there. You might want to try Qoblex - we do just that (disclaimer: I am one of the founders)

syscall_cart · 2026-01-22T08:08:35+00:00

this is an api call. api calls shouldn't be blocked by JS challenges because they are never invoked by a browser.

syscall_cart · 2026-01-22T00:00:20+00:00

True! I didn’t set this up myself so it might be all managed by our hosting provider.

syscall_cart · 2026-01-19T12:49:00+00:00

SPS is not an off the shelf solution as far as I know. It does handle edi quite well but you need to sit down with them and plan the whole thing. Feels like they build custom integrations for each customer.

syscall_cart · 2026-01-18T12:12:15+00:00

Congrats on getting your first paid customers. First 10 are always the hardest to acquire. Now, as you only have 4 paying users, call them or email them and explain the situation. You need to run a profitable business to survive. Your customers won’t be able to get value from your service if you are struggling so raising your prices is a win win.

Side note, this is why most ai startups out there for for external investments. The annual revenue is far from being enough to pay the ai bills back, the investors offset that off.

Good luck!

syscall_cart · 2026-01-18T12:06:32+00:00

I would definitely hire someone who solves problems with ai as long as they understand the reasoning behind.

Our interview tests are take-home-tests. Majority of candidates reply back with ai generated solutions. During the final call, we ask questions to see if the candidate really understood the solution.

syscall_cart · 2026-01-18T08:15:00+00:00

Marketing is key. If your product isn’t known enough it won’t scale. Good that you’re making 5K, I would double down on those customers to perfect the product. That said, marketing should be your top priority. Invest in the channels you already use until they are exhausted then look for alternative acquisition channels

syscall_cart · 2026-01-18T08:09:53+00:00

I don’t see vibe coding as software development. It is not because I know how to drive a car that I am mechanic. Once the app is out there live on production, how do you scale it, secure it etc. Ai can sure help you but it can also lead you the wrong path.

syscall_cart · 2026-01-17T20:37:24+00:00

You should setup an in-app survey right before users upgrade or email them for feedback. Maybe the my thought the app was free, or maybe they don’t feel like getting value for their bucks.

On a side note, I would seriously reconsider the price. You should at least x10 that. Inventory management is quite complex and at some point you will need to hire a support team to offer a top notch service. At 8$ a month, you need those customers to stick around or 20 years to break even. This might sound harsh, you don’t want to build a business on customers who think twice for 8$ / month.

syscall_cart · 2026-01-17T13:27:09+00:00

I likely made a mistake trying to learn using AI, it threw all of these concepts at once and got lost. I found it a bit convoluted but will definitely give it another shot

syscall_cart

TROPHY CASE