> If the vulnerability were critical, someone would have merged it by now.
> GitHub Copilot can automatically suggest fixes for security vulnerabilities. Instead of updating to a patched version, let AI generate a workaround in your own code.
Agree with other commenters that the title is a bit confusing and should be renamed to something like "Is your Postgres workload read heavy or write heavy?"
But title aside, I found this post very useful for better understanding PG reads and writes (under the hood) and how to actually measure your workload
Curious if the tuning actions any different if you're using a non-vanilla storage engine like AWS Aurora or GCP AlloyDB or Neon?
Sequence | London / NYC (Hybrid) or EMEA (Remote) | Full-time | sequencehq.com
Sequence is reinventing accounts receivable for modern businesses.
We're one of the first a16z backed companies in Europe, building an AI first revenue automation platform that enables sales and finance teams to streamline the quoting, billing, invoicing and revenue workflow.
Our tech stack includes Kotlin, TypeScript, React, Postgres, and GCP. We're looking for engineers who enjoy being hands-on, shipping code, and working closely with customers to solve complex financial problems.
Open roles:
* Senior Product Engineer (Backend) | London / NYC (Hybrid) or EMEA (Remote) | £75k-110k + equity
Sequence is reinventing accounts receivable for modern businesses. We're building a flexible toolkit that helps B2B finance teams scale their revenue collection infrastructure with a world-class billing engine.
Backed by top investors including a16z and Salesforce Ventures, we're a team with decades of experience building category-defining marketplace, fintech, and enterprise software.
Our tech stack includes Kotlin, TypeScript, React, Postgres, and GCP. We're looking for engineers who enjoy being hands-on, shipping code, and working closely with customers to solve complex financial problems.
Big +1 for Bunny.net - I moved my current company to Bunny and it's been excellent. Super fast (for our PoPs at least), reasonable pricing, love the image optimizer & edge rules (especially for solving header issues when embedding documents), has a Terraform provider, and I was able to set most of it up in a day. Was a night and day difference from GCP's Cloud CDN
Good to see Skip on the home page! We were evaluating Skip just a couple weeks ago for a side project.
The issue we ran into is that we've already built a native iOS app with SwiftUI + a bit of UIKit. Integrating Skip with an existing app seemed like a significant task
Does that hold true in your experiences? Do you have any examples of small- or medium-sized existing apps that have migrated to Skip?
The GitHub readme is well documented but hard to know how that translates into the dev exp, like with scaling or upgrades and if its features are comparable to managed Postgres providers (I'd assume no but happy to be proven wrong!)
That's a fair point - it can vary a lot between groups and it can certainly relate to life stage / situation. Students and roommates are a large portion of the market for bill splitting apps. In my experience those groups tend to care more about splitting things accurately / fairly, perhaps as they have a more limited income
Yep the split is the same but the conversions back to your base currency that can be a bit of a faff, especially if we're on holiday and doing these calculations multiple times per day
For example if I go to a restaurant with a large group and each item on the bill is in yen, we need to sum each person's total in yen and then convert each of their totals into GBP so we can each transfer what we owe (easy enough)
But depending on the exchange rates and rounding, those calculations can sometimes be off by a penny or two. Some people don't mind, others do
Like another commenter mentioned, managed container platforms like Cloud Run and Fargate don't have the same cold start limitations as serverless functions like Lambda.
Serverless functions spin up resources and run isolated code on-demand for every request as it's received. If you have no traffic, it scales down to zero and cold starts can be a concern. And paying for compute per-request like this can get very expensive at scale.
While Fargate is advertised as "serverless", I'd think of it as a fully container platform, it's closer to Heroku than it is serverless functions. You point it to an image, tell it how many instances you want to run, maybe set up some autoscaling rules (like to add more instances when CPU reaches X%), and then it'll run those instances 24/7. From what you've described, it sounds like a good fit.
Even on low-volume projects I've noticed reliability issues with Fly.io too. For example today we have requests timing out at the gateway (before hitting our services) while the status page indicates their current outage is only related to delayed app logs [0][1]. Haven't gone deep enough with the other new-ish PaaS providers (like Render and Railway) to get a feel for their limitations.
Unless you're certain you need K8s and have the in-house expertise to support it, I'd suggest going for Fargate or Cloud Run. Are there any requirements that you're concerned they won't meet?
> On 22nd February 2024 at 08:13:57 UTC the ID of the message threads table grew larger than the maximum size of the "int" data type. Writes to this table continued to work fine however there were four tables that had columns with references to the message_thread ID that were still using the int data type. Writes to these tables started failing immediately as the message_thread ID referenced was too large for that data type.
> If the vulnerability were critical, someone would have merged it by now.
> GitHub Copilot can automatically suggest fixes for security vulnerabilities. Instead of updating to a patched version, let AI generate a workaround in your own code.