Combine Free tiers services to create fast form submission from event posters : free database (supabase), free image storage (ImageKit), and free image recognition (Gemini), all orchestrated by Claude, this time on pro subscription. The idea is to create a few intertwinned components :
- form that submits event to a database, with image upload to CDN remote storage
- associated data schema
Those components interact together via APIs
- SUPABASE : connection to remote database from javascript page ,
- IMAGEKIT : a free image hosting service with online optimization and transformation methods
- GEMINI AI STUDIO : provides OCR for quick analysis of event data (title, description, place, start / end dates)
Proactive security
currently I have to admit, I work on scaffolding so security is not optimal. Claude reviewed the whole submission process which is open to everyone, andd suggested adding status column and make public reading access only for approved rows. Nice One, obviously that leads to some sort of backend interface building : a single prompt does the job here. Claude delivers schema security update (in the case of SUPABASE, RLS security protocol) and authentification method.
Extreme caution with data
look what just happened : since all data interface is done via AI generated UI / methods, I asked for a new feature (admin page with ability to inline edit fields). Well I tried it and – god knows how – all the data in 2/3 tables got wiped out 100%, rendering the whole app useless…. Fortunately, it took me one hour to restore data from another previously opened browser page, asking claude to generate script for the console using specific JSON generation to restore bvrowser data… and it worked. All this because supabase free plan does not make backups, despite what the docs says…