Migrating from SQL Server to Postgres is a significant move for organizations looking to reduce costs, improve scalability, and future-proof their data infrastructure. But database migrations are costly and time consuming. They frequently run overtime, carry significant business risks, and are a significant opportunity cost. So if you’re going
Snowflake vs. Databricks: who’s better for your company’s AI initiatives? Competition between the two has been heating up for years, and their recent announcements at the 2024 Snowflake Summit and Databricks’ Data+AI conference reflect the intensifying shift towards enabling AI capabilities for their users. It's
In this post, we explore the limits of single-node Postgres and what optimizations can extend its usefulness as a primary application database before requiring more advanced scaling solutions. Monolithic ecommerce app on RDS PostgreSQL Let's use a real-world scenario, a monolith web application that uses PostgreSQL as the
What's missing from APMs? Sales are dropping on your ecommerce shop. Customers are getting sluggish response times when they're viewing products for sale. As a backend engineer supporting your Ruby on Rails and PostgreSQL ecommerce platform, you spring into action using your available tools. Your primary
Do you have a Rails app built on PostgreSQL and need to scale it to millions of users? In this interview, I speak with Andrew Atkinson, one of StepChange's expert consultants, who brings deep expertise in optimizing Rails applications for performance and scalability. Andrew’s expertise is backed
Having discussed why Postgres performance tuning matters, and how to write better queries to optimize performance, it’s time to look beyond the basics towards more advanced techniques in Postgres performance tuning and monitoring. I’ll share how you can use tools like pg_stat_statements for query analysis, implement
Are you thinking about migrating a Native mobile app to React Native or building one from scratch? Are you interested in hearing lessons learned from migrating Coinbase's 56 million users from Native to React Native? Nick Cherry, an Expert React Native developer and former Software Engineer at Coinbase,
In my previous article, I discussed why Postgres performance tuning matters, warning signs you should pay attention to know if your Postgres database is struggling, and 8 parameters you can try to improve its performance and see results immediately. Today, we’ll take a closer look at Postgres query optimization
In our work as seasoned database specialists, we often approach Postgres performance tuning with an eye towards how we can best tune a range of configuration parameters to suit a specific workload and hardware setup. But it’s not always obvious why you should start here, where you should start,
In this interview, I talk with Justin Watt, the founder of Switchboard, a consultancy focused on automation solutions, about how his company helps businesses automate their processes and workflows. Before founding Switchboard, Justin worked at IBM on large-scale government projects and at MetaLab with clients like Amazon and Uber. His
Are you thinking about building a polished AI powered app to explore a large data set? Worried about how to handle data accuracy issues? Do you want to know the pro's and con's of using pgvector with Postgres over a dedicated vector store? Are you interested
Do you have a Django app built on Postgres that needs to use geospatial data? Want to know how to scale it to millions of users using Postgres? In this article, I interview Ananth Chandrasekharan about the challenges Nextdoor faced while scaling its Django application, which made heavy use of