We were fortunate enough to hear some valuable insights during our interview with M Farag of SubsBase that will inspire, motivate, and teach aspiring and established entrepreneurs alike. “Validate your idea and talk about it with people you know.

Founder of SaaS Startup SubsBase Shares Their Top Insights

SubsBase is a software-as-a-service (SaaS) platform that provides management services for subscription-based companies. “A subscription management platform. A cloud-based subscription and billing platform that empowers subscription-based businesses ...

SubsBase Profile

Delivering non-drug treatments for neurological conditions using neuroscience and data analytics, mentorship and job matching platform, and a digital VAT refund solution for tourists with saving of 20 per cent are among the 15 innovative startups joining ...

UAE: Drug-free treatment, job matching solutions among Hub71’s new group of startups

Delivering non-drug treatments for neurological conditions using neuroscience and data analytics, mentorship and job matching platform, and a digital VAT refund solution for tourists with saving ...

Subsbase, which simplifies recurring payments for businesses; and Inovat, a digital value added tax refund solution. Hub71 received 70 per cent more applications to join its start-up community compared to the previous cohort, including a significant ...

Abu Dhabi’s Hub71 selects 15 start-ups to join its growing tech system

The cohort also includes FinTech startups such as Subsbase, backed by notable investors including Global Ventures and Plug and Play, who are simplifying recurring payments for businesses and ...

HUB71 CONTINUES GROWTH WITH THE SELECTION OF 15 STARTUPS TO JOIN ABU DHABI’S TECH ECOSYSTEM AND SCALE GLOBALLY

The cohort also includes FinTech startups such as Subsbase, backed by notable investors including Global Ventures and Plug and Play, who are simplifying recurring payments for businesses and Inovat, which offers a digital VAT refund solution, enabling ...

Hub71 continues growth with selection of 15 startups

Hub71 Adds 15 Startups To Join Abu Dhabi’s Tech Ecosystem

The startups, part of Hub71's first cohort of the year, originate from the UAE, US, New Zealand, Egypt, the Netherlands and the UK

These 15 innovative startups are set to join Abu Dhabi’s Hub71 this year

Hub71 adds 15 startups to join Abu Dhabi’s tech ecosystem and scale globally

SubsBase

subsbase

* * Achievement unlocked: With more than ‘4 billion’ in total votes -- almost half the population of earth voted for startups! JUST KIDDING! Some companies had a to accumulating their votes. unique approach In 2021, decided to host to highlight the backbone of the future - tech startups! for the first time in forever (make sure you sing it in Anna’s voice), HackerNoon.com Startups of The Year More than 44,000 startups were nominated all across the globe, spanning over 4,553 cities. That’s.Just.Spiffy! To see who is a winner in each respective city, visit and pick a city. The name at the top of the list is the winner. (Compromised awards are under review.) startups.hackernoon.com The will announce the winners per region in their respective cities. Startups Winners Announcement Series We’d like to take a moment here and thank every single person who cast a vote and every single company, both nominated and not nominated yet this year. Furthermore, we thank you for existing and opening more opportunities for the wonders of the future to come. Even if you don’t win anything today, you’ve won something much more valuable - our hearts <3 Okay, sorry for the long introduction. Below are all the Startups Winners: Startups of the Year (SOTY) in Africa Johannesburg, South Africa With more than 900 votes cast, #SOTY calls.... MiBRAND Thank you for connecting businesses and consumers, great job! Lagos, Nigeria With 836 votes in the bag, let’s give it up for... Goodtalent Thanks for helping tech companies build great engineering teams. Cape Town, South Africa Want to learn more about finance and use that knowledge to make better financial decisions? Look no further. Introducing winner of Startups of The Year, Cape Town: Revix With 527 votes cast, it seems like a lot of people have more money in their pockets thanks to . Revix Mahé, Seychelles With around 515 votes cast, #SOTY summons... DAOLaunch Thank you for bridging the gap between investors and startups. Lusaka And the winner for #SOTY in Lusaka is... ComGrow Thanks to them, people here are getting closer to the reality of the digitization of village banking. Nairobi, Kenya With 252 votes cast, UTU came out top as the Startup of The Year. Thanks for building the trust infrastructure of the internet to help businesses and consumers engage and transact in a more reliable way. Yaoundé Accounting for more than 73% of total votes, CamPay won this award fair and square. Thank you for making sending and receiving payments easier between online merchants. Abuja, Nigeria A proud winner in the prestigious capital of Nigeria, Elesaro deserves all the plaudits it gets. is a suite crowdfunding protocol built on BSC, Reward, Equity, Lending & NFT Marketplace. Congratulations! Elesaro Dar Es Salaam, Tanzania Jamii Africa is the name that will always be engraved on the #SOTY trophy. As a mobile micro-health insurance, Jamii Africa has done a great job for the health sector in Tanzania. Kigali, Rwanda Another #SOTY medal in the bag for none other than …wait for it… BAG Innovation BAG Innovation applies Gamification to offer real-time access to experience-based learning for University students in East Africa. Everybody loves playing games, but using games to learn in school is on another level. Gauteng, South Africa And the award goes to... Planet42 Thanks for democratising mobility by enabling people ignored by banks to get access to a personal vehicle through a car subscription service. Once again, congratulations! Port Harcourt, Nigeria Cryptocurrency is the present and the future, as we’ve all come to know. FLITBASE makes these digital assets more accessible to everyone. #SOTY is proud to add you to our Hall of Fame. Cairo, Egypt With 18 votes won out of the 91 cast, it seems there was fierce competition. Congratulations to... SubsBase for winning Startups of The Year. SubsBase allows businesses to manage their subscribers, automate recurring billings, set pricing plans, and monitor subscription KPIs. Tunis, Tunisia Come one, come all! Witness the greatness of yet another wonderful startup in the #SOTY. Thank you... VYND for providing a fully integrated digital platform to help venue owners better serve their customers and grow their businesses. Stellenbosch, South Africa BankTech connects clients to a payment network where it provides a convenient interface to meet various payments needs. You’ve won #SOTY proudly! Pretoria #SOTY acknowledges... Grays Pharmaceuticals Thank you for all you do. Lekki, Nigeria Middletrust provides reliable escrow services in Africa. Congratulations on winning a #SOTY medal. Addis Ababa Thank you... Hello Solar for consistently accelerating sustainable energy solutions, especially for remote communities. With half of the votes cast, you beat the odds. Accra, Ghana UT Bank Ghana provides various commercial banking services to individuals and companies in Ghana. We cannot emphasize enough the importance of financial services to humankind. #SOTY is proud of all you do. Gîza, Egypt Big congratulations to... HOVO for winning this award. Your on-demand mobile app for ordering trucks is truly appreciated! Goma, Democratic Republic of Congo Congratulations for coming out on top of #SOTY, SillonBlue Technologies As an ICT Consulting and SaaS company, SillonBlue Technologies focuses on software and mobile app development, and data collection. Yaba, Nigeria With more than half of the votes cast, this nominee conquered undisputedly. Let’s give it up for... Kuda a no-fee full-service digital bank making banking affordable for all Africans on the planet. Morocco City Almes provides infrastructure and logistics services. Congratulations on earning a #SOTY medal. Dakar ShopMeAway provides families and businesses with new ways to shop around the world with reduced shipping costs. You deserve the plaudits you’ve received! Casablanca Sheaply provides crowd shipping and crowd shopping solutions. This reduces cost and improves efficiency on shipping and shopping. Congratulations on winning a #SOTY medal. Nguru, Nigeria Accounting for 88% of the votes, TradeBuza wins #SOTY almost flawlessly. TradeBuza is a tech-enabled commodities sourcing platform for commodities aggregators and out-grower schemes. Ikeja, Nigeria PropertyPro Nigeria is now pronounced Startup of the Year in Ikeja. Let’s admit, who doesn’t appreciate a platform built to search for real estate properties? Ibadan, Nigeria No Bank, No Problem! (That’s probably not their motto, by the way) Shield Finders is a fintech and financial service provider to the unbanked. Congratulation on winning most of the votes! 6 October City, Egypt Wuilt is a website builder where you can create your own Arabic website in under 5 minutes. Thank you for making this technology accessible to people. One #SOTY medal for you! Algiers The only nominee who outvoted all others, please give it up for... Yassir Thank you for providing convenient transport services using your app. Enugu In an area that usually suffers from inconsistent electricity, Greenage comes to the rescue with their green cape and spandex suit. Greenage Technologies is a Nigerian startup solving electricity problems in Nigeria using solar energy technology. Congrats, Greenage. Abeokuta, Nigeria A government organization creating opportunities for entrepreneurs and the unemployed - no one deserves the title Startup of The Year better than Ogun Innovate Congratulations! Ariana And the award goes to... E-Stores Factory a web platform that helps rent and manage e-shops for enterprises seeking to sell online. Thank you for making the (not a typo) more friendly! e-cosystem Benin City Health really is wealth. MOBicure provides mobile technology solutions for Africa's biggest health problems. Thank you for all you do. From #SOTY with love <3 Centurion GameZBoost offers white label gaming platforms, including online desktop solutions, fully responsive mobile and social platforms. Thank you for making the world a more fun place! Gaborone Augmenta Cyber Security provides services in cyber security, safe data storage, SCADA security, SAP Security, etc. Congratulations on winning 10/10 of the votes. You rock! Garki There can never be enough medical platforms in the world. Congratulations to... Wella Health an operator of a healthcare technology company intended to provide treatments and medicines for malaria. Thank you for all you do! Lilongwe Yellow is a digital platform enabling informal merchants in Africa. #SOTY welcomes you to its hall of fame. Make yourself at home ;) Luanda Access to finance is important for any company or sector to succeed. And no other company deserves the title Startup of The Year more than Deya the first Angolan and PALOP crowdfunding platform that aims to increase access to financing for social impact causes and entrepreneurs. . 10/10 will recommend Mombasa Life can be hard, and so a little humor helps ease these hardships. Congratulations to this political satire puppet show, The XYZ Show for winning #SOTY. Thanks for putting smiles on our faces. Port Louis Town Bet you’ve never heard of a Smartcup. Thanks to Intellicup that exists now, and therefore earns this startup a #SOTY badge.  Intellicup is a unique high-speed beverage dispensing solution with integrated smart technology. While this cup won’t be able to wake you up in the morning, you have to agree that it’s still pretty impressive. Rabat Atlan Space is a startup building AI to autonomously pilot any fixed-wing drone, to monitor and take measures over very large areas. You deserve the #SOTY medal. Réunion Imagine having the power to do ultrasound scans on your handheld device. OSCULT by Oscadi is a handheld ultrasound imaging device interfaced with the Apple iPad. Congratulations on making it into the #SOTY! Somerset West Winning the award fair and square is Sticitt a cashless payment platform that is also aimed at teaching learners at school the basics of finance. The future of the world would be in good hands when our children know how to adequately manage finances. Thank you for saving the world in advance. Thika Flowers make the world a beautiful place to live in. Wilmar Flowers exports summer flowers grown by small and medium-sized farmers from Kenya. Kudos for making the world beautiful, #SOTY is honored to have you in our Hall of Fame. Kampala, Uganda Yo-Waste Limited is an African startup that provides waste, recycling and “smart city” solutions to businesses and governments. Your #SOTY gold medal shines as much as you do <3 Harare, Zimbabwe The world is becoming more and more digital every day. Thanks to companies like Golix that provide services of digital currencies for people in Africa, the digitization of the world is becoming more robust. Freetown Easy Solar is a distribution company making energy, durable goods and financial services affordable and accessible through pay-as-you-go tech. Thumbs up! Kicukiro FOODLINE specializes in non-genetically-modified grocery farming and production lines. Winner Winner Chicken Dinner! #SOTY Goma, Democratic Republic of Congo Startups Nuru is a renewable and environmental company that specializes in the fields of storage micro-grids and solar energy. After racking up all the votes, #SOTY honors you. Abidjan, Côte d'Ivoire Digitech provides a fully integrated and cloud-based InsurTech platform to incumbent insurance companies. You are awesome! Durban Security can never really be enough. We’d like to honor Blue Security the title Startup of The Year, for specializing in the installation and monitoring of intruder detection systems, and in providing armed response services. Ikoyi And the Startup of The year goes to... Winich Farms an Agritech Startup leveraging tech to connect rural farmers to Finance & Market, thus, increasing productivity and cutting post-harvest loss. You rock! Lomé The last recipient of #SOTY in Africa calls for... Gozem a transport technology platform for Francophone West and Central Africa. Thank you for providing a platform for transportation. We are honored to have you! *Winners missing from this list will be added accordingly. More Information If you’re a winner, please answer ! If you’re a reader, participant, just a curious individual, consider answering one of our interviews . this interview here Read the FAQs about or . Startups here here To see all of the winners you may visit , pick any city and view the name that appears at the top. this site If you’re interested in partnering with us, we invite you to look through some of these or reach out to our business department. unique sponsorship options Perhaps creating your very own tickles your fancy or maybe you have a whole new idea for how we can partner! writing contest Thank you to all of our sponsors! We truly appreciate your contribution to the tech world and thus the future! The Startups Awards are sponsored by: , , , , , , , , , , Blockster Brex FreeCodeCamp LaunchDarkly Coil Udacity Udemy Vercel Asia Pacific Transgender Network Bybit Everscale Network This post was written and edited by Kien Dao and Joshua Omale. If you have any questions or concerns or would like to report a discrepancy please email ellen@hackernoon.com.

What are the Top Startups in Africa?

Building a Secure Newsletter Subscription with NextJS, Supabase, Nodemailer, and Arcjet 🔐💯

Your Complete Guide to Self-Hosting Umami Analytics with Vercel and Supabase

How to Build a Chatbot with Langchain, Next.js, OpenAI, and Supabase

How to Build a Web Page Summarization App With Next.js, OpenAI, LangChain, and Supabase

Next.js, OpenAI, LangChain, এবং Supabase দিয়ে কিভাবে একটি ওয়েব পেজ সামারাইজেশন অ্যাপ তৈরি করবেন

So erstellen Sie eine App zur Zusammenfassung von Webseiten mit Next.js, OpenAI, LangChain und Supabase

Cómo crear una aplicación de resumen de páginas web con Next.js, OpenAI, LangChain y Supabase

Comment créer une application de synthèse de pages Web avec Next.js, OpenAI, LangChain et Supabase

Next.js, OpenAI, LangChain और Supabase के साथ वेब पेज सारांशीकरण ऐप कैसे बनाएं

Next.js、OpenAI、LangChain、Supabase を使って Web ページ要約アプリを構築する方法

Next.js, OpenAI, LangChain 및 Supabase를 사용하여 웹 페이지 요약 앱을 구축하는 방법

Como construir um aplicativo de resumo de páginas da Web com Next.js, OpenAI, LangChain e Supabase

Как создать приложение для суммирования веб-страниц с помощью Next.js, OpenAI, LangChain и Supabase

Next.js, OpenAI, LangChain ve Supabase ile Web Sayfası Özetleme Uygulaması Nasıl Oluşturulur

Cách xây dựng ứng dụng tóm tắt trang web với Next.js, OpenAI, LangChain và Supabase

如何使用 Next.js、OpenAI、LangChain 和 Supabase 构建网页摘要应用程序

Realistic prototype data is a cornerstone of successful , offering invaluable insights and support across various stages of the development process: software development Mock data allows developers to simulate real-world scenarios and test the functionality, performance, and usability of their applications under different conditions. By providing representative data sets, developers can identify and fix bugs, validate features, and ensure the reliability of their software before deployment. Testing: During the development phase, realistic data enables developers to work efficiently by providing them with data that closely resembles what the application will encounter in production. This allows developers to design and implement features more accurately, as they can see how the application interacts with actual data. Development: When onboarding new users, especially in the case of complex applications or platforms, realistic mock data can facilitate a smooth and intuitive user experience. By presenting users with data that reflects typical usage scenarios, they can familiarize themselves with the application's features and functionality more quickly, leading to higher user satisfaction and adoption rates. Onboarding New Users: In essence, while ‘lorem ipsum’ has its place, it's the authenticity and relevance of data that truly drives software development forward. Open Source Synergy: Classroomio's Revolution with Supabase and Sveltekit As an active contributor to open-source projects, I recently had the opportunity to collaborate on , an innovative educational platform reshaping virtual classrooms. Given the nature of the project, where educators and learners interact dynamically, the need for realistic prototype data was paramount. Classroomio Built with Supabase and Sveltekit, Classroomio combines the power of a robust database management system with the flexibility and efficiency of a lightweight front-end framework, ensuring scalability, performance, and good user experience. Database Management with Supabase Supabase is a feature-rich software built on top of . It abstracts away many of the complexities involved in working directly with PostgreSQL, providing simplified APIs and integrations for common tasks, and adding additional features like real-time updates, authentication, and storage. PostgreSQL By providing a friendly interface to interact with the Postgres data server, developers can build and manage web and mobile applications while leveraging the power and flexibility of PostgreSQL as the underlying database engine. Unraveling Database Dilemmas: A Case Study While tasked with the essential process of seeding the database for our Supabase application, I came across an interesting hurdle that shed light on the intricate nuances of database management. Initially, the objective appeared straightforward: generate an SQL dump file containing mock data reflective of real-world scenarios to populate our Supabase app's database. However, what ensued was an illuminating journey through debugging, ultimately leading to a deeper comprehension of database intricacies. In this article, I’m delighted to share the invaluable insights garnered from troubleshooting this database conflict. Despite grappling with a limited understanding of the schema at the onset, a common occurrence when immersing oneself in a new codebase, I've distilled these experiences into actionable lessons that might resonate with any developer navigating similar challenges. By reading this article, you'll find: A practical understanding of database management with Supabase Troubleshooting techniques that can empower you to confidently navigate similar challenges in your own Supabase projects. Seeding the Database As I delved into the process of seeding the database, I leveraged the user interface provided by the application. This task extended beyond merely populating the database; it involved meticulously curating demo course content and configuring various attributes such as course titles, descriptions, and associated resources. One crucial aspect to note is the importance of realism and relevance in our data curation efforts. This means that for our use case, each facet of data had to be carefully curated to mimic real-world scenarios as closely as possible, ensuring that our mock data accurately reflects the anticipated user experience. Generating Seed Data with Supabase The next critical step in our database seeding process is generating the SQL seed file. This file serves as a comprehensive snapshot of both the database schema and its data, facilitating seamless replication and setup of the Supabase app for new users. To accomplish this, we utilize the command, adding specific parameters to indicate that we want to capture only the necessary data without including any structural information. supabase db dump Executing the following command: supabase db dump -f supabase/seed.sql --data-only This command instructs the Supabase tool to create a backup file named `seed.sql`, containing exclusively the actual data stored within our database. Therefore, it omits any details regarding the database structure, focusing solely on the prototype data essential for seeding the database. Task Evaluation Now, upon completion of this step, one might expect the aforementioned task to conclude successfully. However, the subsequent action which is resetting the database and repopulating it with the contents of seed.sql yielded unexpected results. Let’s just say things took another turn. Encountering Database Integrity Challenges: Obstacles in Data Population When attempting to populate the database, I encountered an unexpected setback—a series of database integrity violations (I share a screenshot showing one of many below.) Essentially, this meant that default data already existed in our database, conflicting with attempts to add new data with the same IDs. Two-Step Debugging Process: Database Examination and Data Exclusion In addressing this issue, my approach was twofold: Comprehensively examine the database. Exclude tables with existing data from the SQL dump file. This process demanded a better understanding of the Supabase backend. My first point of call was definitely the docs, there it says that . every Supabase project comes with a full Postgres database Great, now the next action then was to engage the PostgreSQL server via Docker to enable me work directly with the database. Harnessing Terminal Efficiency: Docker and PostgreSQL Utilizing the terminal as my primary debugging tool, I executed the following commands: Cmd 1: docker ps Cmd 2: docker exec -it [container_id] psql -U postgres The first command displayed the running containers, enabling me to identify the specific container image for PostgreSQL. Subsequently, logging into the PostgreSQL server granted access to the database, allowing me to view its contents. By examining the tables, I identified those with default data—a crucial step in rectifying the primary key violation error. Database Resolution: Achieving Successful Database Seeding This debugging process thus provided necessary insights into the database structure of the project, informing subsequent decisions regarding the contents of the SQL dump file. Armed with this knowledge, I resolved the primary key violation error, ensuring the successful seeding of the database. Personal Reflections and Key Takeaways While fine-tuning the seeding process, I encountered an opportunity to optimize data dependencies and validate the SQL dump file to make for a smoother workflow overall and an error-free database population. This was done by organizing the order of table seeding to prevent key violations. However, I came to appreciate that this cleanup operation could also be effectively handled with a custom script using Python, Perl, or Bash, or a third party tool like . Snaplet I’d like to think it all depends on the use case(s) too. Best Practices for Working with Seed Data In this section, we'll discuss some important considerations to keep in mind when navigating similar tasks on a project. Schedule regular backups of your database to ensure you have up-to-date copies of your data in case of unexpected issues or data loss. This ensures that you always have a recent version of your database available for seeding or restoration purposes. Regular Backups: Consider storing SQL dump files in a version control system. This allows you to track changes to the database schema and data over time and revert to previous versions if needed. It also makes it easier to collaborate with team members and maintain a history of database changes. Version Control: Document the structure and contents of SQL dump files to provide context for future users or collaborators. Include information about the database schema, table relationships, and any custom configurations or constraints applied during the seeding process. This helps ensure consistency and understanding across different environments. Documentation: Before deploying SQL dump files to production or sharing them with others, validate the integrity of the data and test the seeding process in a controlled environment. This helps identify any potential issues or discrepancies early on and allows you to make adjustments as needed before impacting live systems or users. Validation and Testing: Consider implementing incremental updates or differential backups instead of full database dumps whenever possible. This approach only captures changes made since the last backup, reducing the size and complexity of the dump files and speeding up the seeding process. Incremental Updates: Take appropriate security measures to protect SQL dump files from unauthorized access or tampering. Encrypt sensitive data, restrict access to authorized users or systems, and implement secure transfer protocols (e.g., HTTPS) when sharing or transferring dump files over the network. Security Measures: Conclusion This article has taken us through the process of seeding a Supabase application using a real scenario. From resolving database integrity conflicts to optimizing the seeding process, each step along the way provided valuable insights and lessons that can be applied beyond the confines of our project. The importance of attention to detail cannot be overstated, as even the smallest oversight can have significant implications for the integrity and performance of our applications. Further Reading - A great comic by Julia Evans that can help you become more effective at debugging “How I got better at debugging” The Supabase database docs

How to Seed a Supabase App: A Hands-On Guide

Boost your Golang backend with the API: A seamless guide to setting up and utilizing supabase for efficient database operations and authentication. supabase Summary has emerged as a compelling open-source alternative to Firebase, offering a suite of tools including a database, authentication, real-time subscriptions, and storage. For Golang developers, integrating it can seem daunting due to the lack of proper library support. supabase However, the library provides a simplified way to interact with in your Golang projects. This article will guide you through setting up the library and demonstrate its use in a Golang backend project, ensuring you can leverage ’s powerful features with minimal hassle. supa supabase supa supabase Installation To begin, install in your Golang project. supa go get github.com/lengzuo/supa Setting Up Supabase in Your Golang Project Before diving into the code, ensure you have setup a supabase project. From your supabase project dashboard, note down the and the . These will be required to connect your Golang application to supabase. Project Ref Project API keys Configuration Import the library along with other necessary packages in your Golang project. supa package main

import (
	"fmt"
	"github.com/lengzuo/supa"
)

func main() {
    conf := supabase.Config{
        // Your project api key, you can use either `anon` or `service_role`.
        // but i will suggest you to use `service_role` as your api key and keep it secret.
		ApiKey:     "your-project-api-key",
        // Retrieve your project ref from project url
        // eg: https://this-your-project-ref.supabase.co
		ProjectRef: "your-project-ref",
        // Set it `false` in production to avoid extra log print.
		Debug:      true,
	}
	supaClient, err := supabase.New(conf)
	if err != nil {
		fmt.Println("failed in init supa client: ", err)
		return
	}
} Replace and according from your project. your-project-api-key your-project-ref supabase Use Case func signUp(supaClient *supabase.Client) {
  body := dto.SignUpRequest{
		Email:    "user@email.com",
		Password: "user-password",
	}
	resp, err := supaClient.Auth.SignUp(ctx, body)
    if err != nil {
        var supaErr catch.Exception
        // use this to catch the error of http status code != 2xx 
		if errors.As(err, &supaErr) {
			log.Error("status: %d, err: %s", supaErr.StatusCode(), supaErr.Error())
			return
		}
        fmt.Println("failed in sign up: ", err)
        return
    }
    bytes, _ := json.Marshal(resp)
    fmt.Printf("sign up success: %s", bytes)
}


func signInWithPassword(supaClient *supabase.Client) {
	body := dto.SignInRequest{
		Email:    "user@email.com",
		Password: "user-password",
	}
	resp, err := supaClient.Auth.SignInWithPassword(ctx, body)
    if err != nil {
       ...
    }
    bytes, _ := json.Marshal(resp)
    fmt.Printf("sign in with password success: %s", bytes)
}

func getAuthUser(supaClient *supabase.Client) {
    token = "logged-in-access-token"
	user, err := supaClient.Auth.User(ctx, token)
    if err != nil {
       ...
    }
    bytes, _ := json.Marshal(resp)
    fmt.Printf("sign in with password success: %s", bytes)
} There are more example functions such as and in the repo for your reference. RPC DB operation Github Conclusion In my personal experience with other Golang libraries, I find the library to be the most developer-friendly. It offers extensive authentication APIs such as SignInWithOTP, SignInWithOAuth, and more. Additionally, it allows developers to pass in for each operation. supabase supa context Besides that, it streamlines the process of integrating a robust backend database and authentication. With just a few lines of code, you can harness the power of supabase in your applications, making your development process more efficient and dynamic.

How to Accelerate Your Golang Backend With Supabase API

This is Part 2 of my Supabase tutorial series. If you haven't, please check out the (How to create a contact form with Supabase & Next JS). We will make use of the same Supabase project and API keys. previous article In this tutorial, we learn how to create an edge function to send emails. We will walk through how to trigger email notifications when the table has a new entry in the next article. contacts To follow along, you need basic knowledge of JavaScript. You can also check it out on . Github Edge functions are server-side TypeScript functions, distributed globally at the edge - close to your users. They can be used for listening to webhooks or integrating your Supabase project with third-parties like Stripe." Edge Functions We can deploy server-side code that works as API endpoints. If you have worked with Firebase or Netlify, this is similar to how Cloud functions and Netlify functions work. Initialize supabase locally To create an edge function in our project, we need the supabase CLI. If you don't have this installed, follow the instructions . here to avoid spending 2 days debugging like me. Check that you have the latest version installed brew install supabase/tap/supabase Next, initialize a supabase project and follow the instructions. supabase init Next, link your supabase database to your local project. Replace with the project reference, you can check yours in the of the project settings page. The database password is in the also. [reference_id] General tab Database tab supabase link --project-ref [reference_id] Once this is done, we should have a folder at the root of our local project with the file. supabase config.toml Create function Next, we create an edge function named email. supabase functions new email This creates an function. This function is situated in folder. All our functions will be added to this folder. email supabase/functions The default email function should look like this. Next, modify the function to be functional. Feel free to use any email service you like. For the sake of this example, we will use resend. Thankfully, there is a guide . email here A few things to note here. First, notice the email, body, and name values from our table in Part 1 of this series. We also use from our environment variables (more on this in the next section). Feel free to use more environment variables. contacts RESEND_API_KEY Environment variables We need to set the variable to use. There are two ways to do this. RESEND_API_KEY The first involves creating an file in the root folder. Remember to add to your . file. This will add all the variables in the file. .env supabase .env gitignore .env supabase secrets set --env-file ./supabase/.env Alternatively, you can set the variables individually. supabase secrets set RESEND_API_KEY=value Note that some environment variables have been set by default. To view all environment variables, run: supabase secrets list For a more comprehensive explanation, check the or . functions guide CLI documentation Deployment To deploy the function, simply run: email supabase functions deploy email Feel free to invoke your function in your terminal to test. Replace the and with yours. FUNCTION_URL API_KEY curl --request POST 'FUNCTION_URL' \
  --header 'Authorization: Bearer API_KEY' \
  --header 'Content-Type: application/json' \
  --data '{"email":"hello@deolaj.com", "name":"Test person", "body":"This is a test email"}' Conclusion I hope this tutorial helps to get started with edge functions on supabase. Next, we learn how to trigger email notifications when our contact form (from Part 1) gets a new submission. Till next time… Also published . here Lead image by on Carl Nenzen Loven Unsplash

Sending emails with Edge Functions on Supabase

Photo by on Annie Spratt Unsplash Supabase is an open source and helps you to build faster and focus on your products. As someone that likes to test out ideas once in a while, Firebase and Supabase have been interesting to work with. Firebase alternative In this tutorial, I will walk you through an introduction to Supabase, setting up a Database table, creating a simple contact form in Next JS, and putting it all together. I assume you have basic knowledge of Next JS to follow along. To follow along with the Next JS project, on Github. The contact form demo is also . check it out live Supabase Creating a Supabase account is pretty simple. Visit and click on the “Start your project” button. Supabase First, create an organization Next, create a project On the next screen, your project API keys will be displayed. Copy the public key and keep it aside. We will use it later in this tutorial. Copy the URL under the Project Configuration section too. This will be your base URL for the project. Next, we will create a table for the contact form. Create a Database table In the section below, click on Database A blank page will be displayed. Click on the button to create a new table and follow the steps. Add as many columns as you'd like. For the sake of this tutorial, we will create a table named "contacts" with the following columns. Note that the column types are important and the RLS policies section is checked. This controls access to our table. Next, we write a simple policy for our table. Without a row level policy, we will not be able to read, update or delete rows on our table. On our blank table, click on "No active RLS policies" on the extreme right of the table. Create a new policy and select "For full customization". For the sake of this tutorial, we will enable access to all operations on our table. To read more about Row level security, visit this page in the . documentation Follow the steps below. We are all set to create our contact form now. Contact form To follow along with the Next JS project, check it out on . Github Create a simple Next JS project npx create-next-app contact-form
npm install formik yup @supabase/supabase-js We install a few dependencies to help create the contact form and to interact with our supabase table. To start, we create the supabase client in our next JS application using the library. I added the Supabase base URL and our project's public key to the file to be used here. supabase-js .env There is an example file in the github project. .env import { createClient } from "@supabase/supabase-js";

const supabase = createClient(
    process.env.NEXT_PUBLIC_SUPABASE_URL,
    process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY
);

export default supabase; Next, we create a simple contact form with the following schema ...

const ContactSchema = Yup.object().shape({
    name: Yup.string().max(140, "Too long!").required("Required."),
    email: Yup.string().email("Invalid email.").max(140, "Too long!").required("Required."),
    body: Yup.string().max(280, "Too long!").required("Required."),
});

... Any kind of form works here. I chose formik for convenience. Next, we create the function to interact with our supabase table. handleSubmit The supabase client is used to insert a new row into the exact table we created (contacts). If this works well, you should see the new row on your table. Using React Query Alternatively, you can use this with React Query. First, create a hook Then call the hook inside your contact form, ...

const { mutateAsync: submitFormAsync, isLoading: isSubmittingForm } = useUpdateContacts();

... Then use this in your function instead handleSubmit Conclusion Note that for free accounts on Supabase, the project is paused after 7 days of inactivity. I hope this tutorial helps to get started with supabase. This is part 1 of my Supabase and Next JS series. Till next time... Also published . here

How to Create a Contact Form Using Supabase & Next JS

Receiving Webhooks 101 Webhooks are how services notify each other of events. They are essentially just a POST request to a preset endpoint. You generally want to use one function per service that will listen to all event types. For example, if you receive webhooks from Stripe, you might structure your URL like this: https://www.example.com/webhooks/stripe To indicate that a webhook has been successfully processed, return a 2xx (status code 200-299) response within a reasonable time-frame. It's important to turn off CSRF protection for the endpoint if the framework automatically enables it. Because of how webhooks work, attackers can impersonate services by sending fake webhooks to an endpoint. They're just an HTTP POST from an unknown source so it’s a potential security hole for many applications (or at the very least a source of problems). This is why most webhook implementations sign their messages. It lets receivers verify the origin of the message. In this tutorial, we'll set up a Supabase Edge Function to receive a webhook from Svix and validate the webhook signature. Supabase Setup (Note: Make Sure to Enable Deno for the Workspace) Run the following commands at the root of your project: supabase init This initializes Supabase in your project. supabase login You'll need to create an access token in your Supabase account dashboard. supabase link --project-ref your-project-ref Your project ref is available under your project settings. You'll be prompted here for your database password. Linking your project makes it easier to deploy your function without having to enter your project's reference ID over and over. supabase functions new receive-webhook This creates the default functions directory and the boilerplate for your function which we'll call “receive-webhook.” supabase functions deploy receive-webhook --no-verify-jwt It's important to set the no-verify-jwt flag when deploying your function because it will be a public URL, and the sender won't be an authenticated user with a JWT. We've successfully created the webhook endpoint where we'll receive webhook messages. You can find the URL in your Supabase dashboard under Edge Functions: Now, we're ready to start writing our function for verifying the webhook signature. The specifics will vary from provider to provider but the basic idea is to calculate the expected signature and compare it to the signature provided in the header of the webhook message. Generally, there will be 3 headers used for verification: webhook-id: the unique identifier for the message webhook-timestamp: timestamp in seconds since epoch webhook-signature: the base64 encoded signature Verifying Manually To get started, let's construct the content to be signed. A common signature scheme (and the one we use at Svix) is to concatenate the webhook message's ID, timestamp, and payload body separated by the full-stop character ("."). It will look something like this: const webhook_id = request.headers.get('webhook-id')
const webhook_timestamp = request.headers.get('webhook-timestamp')

const body = await request.text()

const signed_content = `${webhook_id}.${webhook_timestamp}.${body}` Different providers construct their signatures in different ways, so make sure to reference their documentation. Body is the raw body of the request. The signature is sensitive to any changes, so even a small change (including extra or missing whitespace) in the body will cause the signature to be completely different. This is a common failure mode for verifying webhook signatures. Next, we need to determine the expected signature. Most providers use an HMAC with SHA-256 to sign its webhooks. Some will use other hash functions, so make sure to reference your webhook provider's documentation. To calculate the expected signature, you should HMAC the signed content from above using your signing secret as the key. Get your signing secret from your webhook provider, and save it as an environment variable in Supabase. You can do this via the following command using the Supabase CLI: supabase secrets set WEBHOOK_SECRET=your-webhook-secret Now, calculate the expected signature: import { HMAC } from "https://deno.land/x/hmac@v2.0.1/mod.ts";
import { SHA256 } from "https://deno.land/x/hmac@v2.0.1/deps.ts";
import { Buffer } from "https://deno.land/std@0.177.0/node/buffer.ts";
import { timingSafeEqual } from "./timing_safe_equal.ts";

const secret = Buffer.from(Deno.env.get("WEBHOOK_SECRET")!.split("_")[1], "base64")

const expected_signature = new HMAC(new SHA256())
   .init(secret, "base64")
   .update(signed_content)
   .digest("base64") Finally, we'll add a try/catch to handle returning the correct response based on whether the signature from the header matches our expected signature: const signature = request.headers.get("webhook-signature")!.split(",")[1]

try {
    timingSafeEqual(signature, expected_signature)
} catch (err) {
    console.log("Invalid Signature")
    return new Response(err.message, { status: 400 })
}

console.log("Signature Verified")
return new Response(JSON.stringify({ ok: true }), { status: 200 }) Note that we're using a constant time comparison function to check the given signature against the signature we calculated. This is to prevent timing attacks on the signature. For more information about timing attacks, you can read this article on from our blog. securely verifying signature hashes Verifying Svix Webhooks For a concrete example, let’s verify a webhook from Svix. We provide open-source libraries for verifying webhooks sent from Svix or from any Svix user to simplify the verification process. import { serve } from "https://deno.land/std@0.168.0/http/server.ts";
import { Webhook } from "https://cdn.skypack.dev/svix"

serve(async (request) => {
  const headers = {
    "svix-id": request.headers.get("svix-id"),
    "svix-signature": request.headers.get("svix-signature"),
    "svix-timestamp": request.headers.get("svix-timestamp")
  }
  const payload = await request.text()
  const secret = Deno.env.get("WEBHOOK_SECRET")!
  const webhook = new Webhook(secret)

  try {
    await webhook.verify(payload, headers)
  } catch (err) {
    console.log("Invalid Signature")
    return new Response(err.message, { status: 400 })
  }

  console.log("Signature Verified")
  return new Response(JSON.stringify({ ok: true }), { status: 200 })
}) We handle extracting content from the message, generating the HMAC, any string manipulations to remove versioning and other prefixes, and the constant time comparison. If we send a test webhook from Svix, we can see that the message was successful: We also see in the Supabase functions logs that the signature was verified: Also published here

Stories, News & Mentions about SUBSBASE

Subsbase’s Stories on HackerNoon

Subsbase's News & Mentions