As application developers, it is your job to ensure that sensitive data stored in your application does not get accidentally delivered to another party.
Row-level security (RLS) is the ability to secure and control access to specific rows of data inside a database table.
Neon Authorize streamlines the process of correctly implementing RLS by automatically integrating authentication from OAuth provider with PostgreSQL database.
The tutorial walks the users through how to build a Remix app using Clerk as an authentication layer.
Add Row Layer Security to your app today with Neon.
Our sample application is simple—it records every login into the RLS database, using the userID. When the page is loaded, the last 10 logins for the authenticated user will be displayed, and no other user’s data (stored in the same PostgreSQL table) will appear.
To protect sensitive data stored in applications, Neon Authorize provides an automatic integration of OAuth authentication providers like Clerk with PostgreSQL databases and provides Row-Level Security (RLS).
The LoaderFunction in the _index.tsx file completes tasks on the server before rendering the page for the client.
The LoaderFunction first checks if the user is not logged in and then redirects the user to the /sign-in page.
The Index() function in _index.tsx file renders the layout of the page.