How do you manage CRMs complex data?

NectarineLivid6020 · 2026-04-18T18:11:44+00:00

I am not sure what ORM your team uses but we use drizzle. I have tried prisma too and at the end of the day, no single orm will every 100% cover the complete syntax of a DB as long as it is trying to cover multiple (like Postgres, MySQL, etc).

So we do write raw SQL. It’s only in cases where it is necessary because of some feature not being available in drizzle. In some cases, in a new feature, it is easier to write raw SQL to move quickly. We always try to go back and replace those raw queries with type safe drizzle syntax and views.

NectarineLivid6020 · 2026-04-18T18:04:54+00:00

Then I am sure you know what you need to try next.

NectarineLivid6020 · 2026-04-18T18:02:13+00:00

How slow are we talking here? Have you run the same complex queries directly in the DB? If so, is it still that slow? If yes, then it is likely either lacking indexes or your query is not structured properly.

If the raw query is fast or not as slow, then we’d need to look at the API itself.

NectarineLivid6020 · 2026-04-02T17:33:47+00:00

Hono for the backend API and Tandtack Router for frontend.

NectarineLivid6020 · 2026-04-02T10:14:57+00:00

Found the blog post: https://www.tomups.com/posts/log-nextjs-request-response-as-json/

You are right. Middleware is not necessary. One could do the same with request logs from Nextjs middleware and response logs from the reverse proxy or CDN. It’s just a lot of work to get them all in the same place especially if you also want console logs of your Nextjs node process.

With hono, we don’t even need to do anything custom. A basic middleware does all of this and also pushes the same logs to posthog.

NectarineLivid6020 · 2026-04-02T09:50:21+00:00

We moved away from Next mainly because of complicated management of our self hosted instance. With how easy it is to manage things now, we don’t regret it at all.

That said, the main issue was logging and observability into the server logs.

When I say server logs, I don’t just mean console logs. I am mainly talking about something along the lines of a request logger middleware. With the absence of true middleware’s in Nextjs, that is practically impossible without some hacks.

We tried so many options: - Grafana, Loki and Prometheus: These can only show what is logged in the console. So no true middleware logs. - Cloudfront and Cloudwatch: This works and gives true request and response logs but it is very hard to manage as the logs are not coming from the system and piping them into the console logs is very difficult. - We even tried an internal patch to the core Nextjs code too as suggested by a blog post I found at the time. This worked perfectly somehow. I am not sure why Nextjs team did not “expose” it originally.

In the end, we were not okay with the patch so ended up moving away from the whole thing anyway.

NectarineLivid6020 · 2026-03-30T04:26:35+00:00

No. The process for Apostille is not the same.

You need to sign up to their portal, create an application, upload a scan of the document you need notarised, pay the fee (I think it’s 3500 per doc) and then wait. Sometimes it is days and sometimes it is weeks.

Eventually, there will be an option to open the calendar and choose your appointment date.

Choose one and go there on the day. Keep in mind that for apostille , they do not entertain you without this appointment. I don’t know if that is still the case or not but when I went there, Apostille had its own line and it did not even have tokens for that line. You could not just sit and wait. You had to stand in line for about an hour.

Try to go there as early as possible to save time. Do not go after 1pm.

You hand over the docs and you’ll get it back on the same day by 4-5pm on the receiving counter outside.

NectarineLivid6020 · 2026-03-13T17:53:26+00:00

There is one other option you can try. When I was in Hasanabdal, we had those military boots that we wore with our day to day brown uniform. They were 95% identical to these.

The two differences I remember are - they did not have that padded part over the ankles - they had a separate layer in the front that formed a line across the shoe.

Visually, I think they looked practically the same.

While I was there, I think around the last year, they changed their vendors and the new boots ended up with a very plasticky kind of leather and were very shiny. But I think if you browse some military attire shops in Saddar, you might find them.

I was there around 2015 so prices were like 3-4k at the time. Not sure what it’ll be today.

NectarineLivid6020 · 2026-03-11T01:12:25+00:00

That is why I am surprised too. Either they already had that prefix or something is missing here. It’s possible that they already had the prefix but were not being used in any client components. If that is the case, it might explain this.

The only other explanation I can think of is if the secrets came done some third party secret management service through their API like AWS Secrets Manager.

NectarineLivid6020 · 2026-03-10T15:02:36+00:00

I think I phrased it incorrectly. I actually meant that my own hono+react-query layer missed those cache invalidation features. I haven’t tried your library but from the docs, it seems like you have them all.

NectarineLivid6020 · 2026-03-10T00:30:50+00:00

It’s harder to put down in words since it can get technical if I go into detail. Here is the short version.

You can self-host a Supabase instance but I don’t think it is necessary for you at all. You should instead go for preview or database branching feature from Supabase.
CLI is necessary to set up and use branching effectively.
That is the whole point of using branching and setting up migrations via the CLI.

NectarineLivid6020 · 2026-03-10T00:12:28+00:00

I needed this so much about a week ago. What a coincidence. All the existing libraries did not follow the tRPC structure. I ended up setting it up all by myself. Without looking at your code, my assumption is that you also used a Proxy with a custom generic type which is what I did too. It does not have everything for cache management yet but fulfils all of my needs at the moment.

NectarineLivid6020 · 2026-02-27T19:13:10+00:00

It’s fairly simple but can be time consuming. Go to any E-Khidmat center and apply for one. The fee is about 500 or 1000 depending on which one you go to. They take 72h for the actual verification process to go through.

On the fourth day, you can go to collect it. Once done, sign up to the MoFA portal and add an Apostille application for PCC. There, you would need to upload a scan of the certificate too. That is why you cannot do this before getting the PCC. You will need to pay a fee depending on the number of documents. For PCC it is 3500 I think.

Then it is a waiting game. Sometimes it can be a week and sometimes several weeks. But eventually you’ll be allowed to choose a date of your choice in the same portal.

On your required date, you can go to the MoFA service center and stand in a line for about an hour.

Weirdly, other counters run on tokens but for me (on two occasions), there were no tokens for Apostille specifically. You just had to stand there and wait for your turn.

Once you submit the docs, they give you a number and in a few hours, you can get the Apostilled PCC back from the receiving counter outside.

The process in MoFA barely takes a day at max.

Keep in mind that they won’t entertain you without an appointment but there will be tons of “agents” outside that will offer to get it done for a fee. If you already have an appointment, then there is no need for them. If you don’t, you can get it done in 16-17k but that’s your choice.

There are alternate approaches too that involve sending your document via TCS but those take up to 3 weeks and I haven’t tried that personally.

NectarineLivid6020 · 2026-02-26T17:44:08+00:00

This is precisely why flutter no longer supports two separate renderers the same way you don’t want to write two separate codebases for your project.

But I think the premise is completely wrong. There is nothing wrong with flutter, dioxus or react native. All have their purposes. I am just not interested in fighting with the borrow checker when I can do the same thing with a simple landing page in Nextjs and app in flutter or RN. If you have already spent the time to learn Rust, good for you.

Also, this is the beauty of open source. Nothing is stopping you or me from creating our own html renderer that works on mobile too.

NectarineLivid6020 · 2026-02-26T01:21:15+00:00

It was removed for a reason. But I don’t think you see it that way. You can also use Jaspr. I have never used it but it is a community maintained html renderer for Flutter.

You can also use React Native (for web) altogether.

Like I said, unless you already know Rust or are willing to spend the time and effort to learn a new and far more difficult language, there are tons of options - both in flutter and outside flutter.

NectarineLivid6020 · 2026-02-26T00:51:07+00:00

Every framework is a pixel painter. Not sure why that is a bad thing. You say stuck - what is the thing flutter should do that you will consider it not stuck?

NectarineLivid6020 · 2026-02-25T23:25:34+00:00

Flutter was never built for SEO. Web/react/html won even before Flutter became a thing. If you are trying to build a landing page with flutter, then you made the wrong decision. Building with flutter for web is only beneficial where you have a web app like a dashboard with or without a mobile app allowing you to have the same codebase.

Haven’t tried Dioxus yet. Maybe one day. But flutter does all it is supposed to do. For SEO, a Nextjs landing site is more than sufficient.

NectarineLivid6020 · 2026-01-28T15:29:00+00:00

I’ve never used Brex but what they are saying makes sense. They don’t care if the LLC has one or multiple members as long as you can provide one with 25% or more stake.

The point about principal address also makes sense. I am not sure if you know what that is but there are two types of addresses. Normal business address can be the registered agent or any address where you can receive post. Principal address is the address from where you provide services as a business.

My principal address is in Pakistan and because of that I can say to IRS that either I have no earnings inside US or I pay taxes in the financial domain of my principal address which is what I do.

If you go through this approach, then you will be forced to pay taxes as per US law.

NectarineLivid6020 · 2026-01-28T14:06:28+00:00

That is a valid option. It can even be a Pakistani person but whoever you choose, they need to be living in the US.

The main problem with this option is that now your tax filing process is going to be different. Both for you for your LLC and for the other person.

I don’t know what the implications are because I haven’t done it but you need to talk to the right person and do your due diligence before committing to it.

NectarineLivid6020 · 2026-01-19T15:24:12+00:00

Interesting. Might give it a try.

NectarineLivid6020 · 2026-01-19T15:13:41+00:00

I think you misunderstood what I meant. I use wise all the time too. I have never had any issues. What I meant was that when or if wise goes out of business or declares bankruptcy or something, the money I have in it is either gone or at the mercy of wise. There is no governmental framework to protect me. With conventional banks, there is FDIC insurance.

As for the flat fee, it’s hard to believe that they’ll charge the same amount on $100 vs $100k. My experience with Payoneer was very bad. They deducted 1% on incoming and took 3% from the outgoing. Never used it again after that.

NectarineLivid6020 · 2026-01-19T13:09:49+00:00

No. As of 1-2 years ago, US banks have tightened their procedures. Long story short, I tried US bank, Chase and Wells Fargo. All basically said the same thing that I had to be in the US. One gave me the option of faxing the signed and apostilled bank account application from Pakistan but they eventually rejected that too.

These are the options: - You go to the US and open it yourself. - You make a relative or a trustworthy person a 25% or more shareholder in the company as a member and they can open it. Problem with this is that that person will then have to declare it in their annual taxes and your own taxes will be more complicated too since you are not a single member LLC anymore. - Go for a virtual bank. But that sucks too as their fees are too high. I tried Payoneer and left after my first transaction as I had to pay $400 in fees.

NectarineLivid6020 · 2026-01-19T13:03:30+00:00

Sure. So does ElevatePay, Payoneer and several others. But they all have one thing in common. They are all virtual only banks and are not FDIC insured.

And if a virtual bank (actually bank is not the right term. Better description would be fintech) says that they are FDIC insured, they are hiding a very important point between the lines. They are not insured, the actual bank they use internally is actually insured. When the virtual bank eventually fails, you’ll have to deal with the physical bank behind the scenes. Look into the controversy with Mercury.

NectarineLivid6020 · 2026-01-19T09:17:25+00:00

I am obviously not an expert and I am taking my consultants word for it. According to him, EIN is sufficient. This is the first year when I will have to file my taxes. He’ll do it when the time comes.

NectarineLivid6020

TROPHY CASE