Create PostgreSQL Functions with Supabase
In this video, Jon Meyers explains how Postgres Functions can help make our application code more maintainable, by abstracting away complex logic into SQL functions. This can also improve the performance of data fetching, as we can use the database to transform the data into the shape required by the client, rather than sending unnecessary bits across the Internet, and having an API transform and throw away the excess.
Is the Future of Coding Code-Less
Low code platforms allow non-technical people to build automations, tooling and even full blown applications! In this video, Jon Meyers (
Build Static Pages Dynamically using Next.js and the Notion API
Notion is a note taking application that empowers super productive workflows, without compromising on beautiful UI or intuitive UX. Next.js is a React framework that sprinkles in server-side logic in the places it is needed. This allows each page to be dynamically rendered by the client, rendered by the server or entirely static and rendered at build-time. This makes it an incredibly flexible option that can start off as simple as create-next-app and incrementally introduce complexity as the application evolves.
Implement Authorization using Row Level Security with Supabase
In this video, Jon Meyers explains how Row Level Security (RLS) works and why you should enable it! He steps through implementing some common policies using the Supabase Dashboard, and demonstrates how rules across multiple tables can work together to restrict access. PostgreSQL provides a simple syntax for RLS, allowing access rules to be declared in the Database itself. This can make queries more efficient as the client can query the Database directly, without the need for a middleware API. Additionally, RLS can help to protect the Database against poorly written API code that could potentially leak or compromise sensitive data.
Building a SaaS with Next.js, Prisma, Stripe and Auth0
Thinking of creating your own product by tying together a number of SaaS products like Auth0, Stripe, and Supabase? That's what Jon Meyers wanted to do too, so Auth0 Developer Advocate Ben Dechrai caught up with him for a fireside chat to discuss his journey. From platform and tool selection, to data handling and deployment options, this session also delves into a couple of alternatives to see why certain decisions were made.
How to use Named Constraints with Prisma
Prisma's 2.29.0 release includes support for Named Constraints. This is super useful for custom constraints that do not match conventional naming. In this video, Jon Meyers walks through introspecting an existing remote PostgreSQL Database, and creating a locally hosted development environment.
Set up a local PostgreSQL Database on macOS
In this video we look at how easy it is to get a PostgreSQL server running locally on macOS. We step through installing the Postgres App, initializing a user database and connecting to it using the
Install a local MongoDB Database on macOS
In this video we look at how easy it is to get a MongoDB server running locally on macOS. We step through installation, configuration and using basic CRUD operations to interact with the database.
This is What a Technologist Looks Like
Today we are catching up with Jon Meyers from UpBank. From teaching technology at university, to becoming an engineer at one of Australia's most well known neobanks, we can't wait to explore Jon's journey.
Build an E-commerce platform in 25 days using Next.js, Netlify and Stripe
Using custom hooks in React to reduce complexity
Want to abstract some complex logic into a reusable React hook? In this video we look at how useState and useEffect work, then use these to build a custom hook for requesting data from an API and caching the response.
Generating an API at Build Time with Gatsby
Gatsby is fast! Blazing fast! But how much can you actually do with a static site. ANYTHING! In this talk we will look at how Gatsby can be used to build highly dynamic content - such as gated/authenticated content - without breaking the JAMstack workflow. This talk will begin with a brief introduction to Gatsby and the JAMstack, detailing the performance benefits and unique problems that surface with static content. The main focus of the talk will be around dynamically building an authenticated API from markdown files at build time - keeping our workflow consistent for both public and protected content. This style of development would also allow all content to be tracked by git and easily rolled back.
Simple caching with local storage
Caching is one of the most important things we can do to create performant web applications. So much data is traveling between our client apps, APIs and databases, during which our users are sitting there staring at a loading spinner. In this video we look at implementing a super simple cache using localStorage.