Tseklist is a repository of climbing crags in the Philippines. Users can track their sends (thus the name tseklist - checklist) and (in future versions) contribute information about our local climbs.

I used Electric SQL to enable a local-first experience so that the app can be used offline as crags are usually in remote places. I unfortunately didn't have time to make the app a proper PWA. But as long as you have the app loaded and are signed in, you should be able to update the local database and sync later when you get internet. I've also utilized the newly released Anonymous Users feature to allow users to log their climbs before signing up. This is not shown in the video (logging a climb opens up the sign in dialog) but this works in live.

• Screencast
• Screencast showing usage offline (doesn't show taps)