theanirudh

He means that they moved from AWS to Planetscale and yes it handles much larger DBs.

Their databases are hosted on AWS and GCP so latency isn't much of an issue. They also have AWS Private Link and if configured it won't go over the internet.

The issues weren't PlanetScale related. We use Hasura and when we did the cutover, we connected to the DB via PGBouncer and some features don't work right. Started seeing a lot of errors so paged them and they helped out. We were connecting directly to PG previously but when we cutover we missed that.

We just migrated to PlanetScale Postgres Metal over the weekend. We are already seeing major query improvements. The migration was pretty smooth. Post-migration we hit a few issues (turned out it wasn't an issue with PlanetScale), and the PlanetScale team jumped in immediately to help us out, even on a Saturday morning so support's been amazing.

The Insights tab also surfaced missing indexes we added, which sped things up further. Early days, but so far so good.

This used to be the case when the platforms were much younger and new features were introduced every year. But I would say it’s mostly stabilized now. React native had day 1 support for Liquid Glass and new AI APIs introduced on iOS 26.

In English, silence is transcribed to "Please like and subscribe"

I see benchmarks against Aurora, but I’m curious to see how this compares to Aurora Optimized reads which caches data in a local NVMe SSD. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...

Seems like a lot of extra work in cases where we change the scoring mechanism, we will then have to invalidate the existing entries, recalculate and write it out again compared to just having an endpoint that will take all previous lessons and generate the next lessons on demand.

How do sync engines address issues where we need something to be more dynamic? Currently I'm building a language learning app and we need to display your "learning path" - what lessons you have finished and what are your next lessons. The next lessons aren't fixed/same for everyone. It will change depending on how the score of completed lessons. Is any query language dynamic enough to support use cases like this? Or is it expected to recalculate the next lessons whenever the user completes a lesson and write it out to a table which can then be queried easily?

Do they find ARC AGI also tough due to the same reason? I’ve seen some examples where the input was ASCII art versions of the actual image.

I wonder if the reason the models have problem with this is that their tokens aren't the same as our characters. It's like asking someone who can speak English (but doesn't know how to read) how many R's are there in strawberry. They are fluent in English audio tokens, but not written tokens.

Yes, it is. Try setting font-thicken = true https://ghostty.org/docs/config/reference#font-thicken

I wonder if they considered https://tigerbeetle.com

I might beat that for this batch! This will be my 8th application. 2 for my previous company, and 6 with my current startup and co founders.

Related: AnswerOverflow makes Discord messages searchable on Google/ other search engines. It’s open source.

https://www.answeroverflow.com/

Yes, the egress fees on base backups alone were higher than the cost of the DB VMs. If we replicate the WAL also, it would be way higher. In the post, the example DB was 4.3 GB, but the WAL created was 77 GB.

Don't remember the size, but the disk we were using had the highest IOPS available on Google Cloud. That was one of the reason why we had restore from GCS since these disks wouldn't persist if the VM shut down. I think it's called Local SSDs [0]. We were aware of this limitation and had 2 standbys in place, but we didn't ever consider the situation when Google Cloud would lock us out of our account, without any warning.

0 - https://cloud.google.com/compute/docs/disks/local-ssd

I have forgotten the exact reason but it had something to do with not having a valid payment method. Some change on Google Cloud end triggered it - they were billing initially with the Singapore subsidiary and when they changed it to the India one, something had to be done from our end. Hardly got any notices and also we had around 100k USD in credits at the time. Got it resolved by reaching out to some high level executive contact we got via our investor. Their normal support is pretty useless.

A very much needed feature. Had a nightmare scenario in my previous startup where Google Cloud just killed all our servers and yanked out access. We got back access in an hour or so, but we had to recreate all the servers. At that point we were taking Postgres base backups (to Google Cloud Storage) daily at 2:30 AM. The incident happened at around 15:00 so we had to replay the WAL for the period of about 12.5 hours. That was the slowest part and it took about 6-7 hours to get the DB back up. After that incident we started taking base backups every 6 hours.

It has become very practical / doable in the recent year or so. In my experience, if you have lot of frontend web experience, the easiest way to ship a RN app is by using Solito [0]. Also check out Nativewind [1] which allows you to style native apps the same way like you would on web. I was able to ship the first version of our app in about 1.5 weeks with this stack. Also checkout Tamagui [2].

[0] - https://solito.dev

[1] - https://www.nativewind.dev

[2] - https://tamagui.dev

As a customer, the app and service works really well. It is now my first choice to look for an Auto ride compared to Uber / Ola.

Shout out to Namma Yatri [1] app in Bengaluru, India. It is developed by a payments startup called Juspay. It is endorsed by the Auto Rickshaw Drivers Union. It was launched in November of 2022 and has since done about 5m rides and drivers have earned 9m USD [2]. The entire app, backend and protocol is completely open source [3]. Seems like it uses a fair bit of Haskell and Nix!

[1] https://www.nammayatri.in

[2] https://www.nammayatri.in/open/

[3] https://github.com/nammayatri

I recently started using Tailscale funnel for the same purpose. Works well! https://tailscale.com/blog/introducing-tailscale-funnel/

I’ve been using Tailscale Funnel for this use case.

About to start working on an app and exploring this stack. Do you have any resources, sample repo or any open source app that I can learn from?

Raycast. Apart from being a great launcher, it has replaced the need for a dedicated window manager and clipboard app.

This article by Julia Evans shows how to "build web apps like in 2005" but use libraries from NPM, use ES6 imports and stuff.

https://jvns.ca/blog/2021/11/15/esbuild-vue/

Erlang. They recently open sourced an Erlang type checker https://github.com/WhatsApp/eqwalizer and tree-sitter grammar https://github.com/WhatsApp/tree-sitter-erlang.

There is a sample app and tutorial here: https://github.com/liveviewnative

YouTube