While Supabase provides automated daily backups for paid projects, having your own external backups is important, especially if you are on the free plan. This tutorial will guide you through creating manual external backups of your Supabase-hosted PostgreSQL database to your local machine. Prerequisites Check Before we begin, let’s verify if you have PostgreSQL client… Continue reading How to Create External Backup of Your Supabase-Hosted PostgreSQL Database
Category: SQL
How to find closest locations using coordinates with SQL
Many existing apps nowadays are offering the ability to display nearest records, these records can be user profiles, actual places or anything that can be linked to a location. This is certainly a useful feature and there is a high chance you’d need to make such an implementation, either for a client, or for your… Continue reading How to find closest locations using coordinates with SQL