Monthly Archives: January 2023

Pros and Cons of Cloud SQL vs. self-managed MySQL or Postgres

Posted on January 24, 2023 by Siddharth Jain

If you want to run a MySQL or Postgres server in GCP you have two options: you can either use the managed service provided by Google or you can provision a VM and install MySQL or Postgres yourself (I call … Continue reading →

Posted in Computers, programming, Software | Tagged | Leave a comment

Swift vs. C# Performance

Posted on January 8, 2023 by Siddharth Jain

I am always a sucker for performance. Recently I migrated a .NET GDI+ app to Swift. There were several reasons for it: To my surprise the C# code runs way faster than Swift. The difference is not because of GDI+ … Continue reading →

Posted in Computers, programming, Software | Tagged | Leave a comment

Deleting Entities in Bulk from Google Datastore

Posted on January 5, 2023 by Siddharth Jain

The easiest way to do this seems to be using Dataflow. Here is sample Dataflow job to delete all entities of kind foo in namespace bar: As example a job to delete 44,951,022 entities with default autoscaling took 1 hr … Continue reading →

Posted in Computers, programming, Software | Tagged , | Leave a comment