Freelancers using SQLite in Madrid

Freelancers using SQLite in MadridFreelancers using SQLite in Madrid

Projects People

Berckan Guerrero

maxMadrid, Spain

Senior Full-stack AI Engineer. 14+ years building web stuff.

$10k+: Earned

7x: Hired

5.0: Rating

16: Followers

Senior Full-stack AI Engineer. 14+ years building web stuff.

Cover image for Pulso (https://heypulso.com): Prospect intelligence platform

Pulso (https://heypulso.com): Prospect intelligence platform that scans 28,000+ websites, scores them across 15 health metrics, and manages outreach from discovery to conversion. Scanner engine audits domains: SSL, performance, security headers, vulnerabilities, malware detection, SEO, accessibility. Each domain scores out of 100. Operations dashboard with prospect tables, inline notes, contact popovers, archiving, AI-generated outreach emails, and detail panels with color-coded health breakdowns. Role-based auth. Automated outreach generates custom reports per prospect via API with actual scores and recommendations. 14 years of web maintenance and optimization went into the scoring logic. Every check reflects real patterns found across hundreds of sites. 40,000+ domains. 15 metrics. Sub-second queries. Under €5/month infra.

1

1.3K

Cover image for Pulso (https://heypulso.com): Marketing and sales

Pulso (https://heypulso.com): Marketing and sales website for a web health monitoring service targeting small businesses in Latin America and Europe. Astro 5 static site with Stripe integration (EUR, USD, CLP), geolocation-based currency detection, and Resend API for transactional emails. Trilingual (ES/EN/FR). Four user flows in one site: email campaign recipients see personalized context, organic visitors get a free check CTA, salespeople share payment links, self-service users browse pricing and buy. Contact form via Resend API. Conditional hero based on referral source. 6 pricing tiers from free reports to monthly maintenance. Tone calibrated for Latin American SMBs. Stripe for subscriptions and one-time payments. Currency auto-switches via visitor geolocation.

1

1.3K

Cover image for SpeedDoc: AI-powered web performance optimization

SpeedDoc: AI-powered web performance optimization tool that scans websites, diagnoses bottlenecks, and generates ready-to-implement fix code. Not generic Lighthouse advice: actual code patches developers can copy and apply directly to their codebase. Built as part of a Vercel AI Accelerator application. Scans run against live URLs, identify specific performance issues (render-blocking resources, unoptimized images, layout shifts), and return targeted fixes with before/after impact estimates. Next.js 16, TypeScript, Tailwind 4, Vercel. Personal project.

1

1.3K

Cover image for Raven: AI-powered knowledge management app

Raven: AI-powered knowledge management app with notes, tasks, and built-in streaming chat. 34 components, 25 composables, 13 Supabase PostgreSQL tables with Row Level Security policies on every table. 12 AI functions including streaming responses, voice input, and automatic conversation titles via Gemini. Full i18n (EN/ES) with offline support and sync queue for unreliable connections. Real-time CRUD, folder organization, and workspace-based content separation. Auth via Supabase with RLS enforcing data isolation between workspaces. Nuxt 4, TypeScript strict mode, Supabase (PostgreSQL, Auth, Storage). Custom instance deployed for a private client with ongoing development.

1

1.3K

Nikita Beznosikov

Full-Stack Engineer · SaaS · Node.js / React / TypeScript

5.0: Rating

2: Followers

Full-Stack Engineer · SaaS · Node.js / React / TypeScript

Cover image for AI-powered language flashcard app for

AI-powered language flashcard app for iOS. Users describe any theme ("Coffee and tea", "Driving exam") and the app instantly generates a custom deck via Google Gemini. Features a progressive 3-level vocabulary system (beginner → intermediate → advanced) with mastery-based unlocking, SM-2/FSRS spaced repetition with Again/Hard/Good/Easy ratings, offline-first SQLite storage, bilingual audio examples, smart daily reminders, and a freemium model (RevenueCat) gating unlimited decks and advanced levels. Built with React Native (Expo), TypeScript, SQLite, Supabase, Google Gemini, RevenueCat.

0

71

Cover image for Pay-per-use video testimonial SaaS. Businesses

Pay-per-use video testimonial SaaS. Businesses collect text reviews for free and pay per video testimonial via a credit system — no subscriptions. Features include browser-based video recording, embeddable widget with masonry layout, Stripe payments, credit metering via Cloudflare Stream analytics, signed video URLs for hotlink protection, and a dashboard for approving/rejecting submissions. Built with Next.js, Supabase (PostgreSQL), Cloudflare Stream, Stripe.

1

87

Cover image for Shopify app for EU Digital

Shopify app for EU Digital Product Passport (DPP) compliance. Merchants can create and manage product passports with QR codes, print labels, bulk edit via CSV, and use AI to auto-fill passport fields from existing product data. Built with Remix, React, Node.js, Prisma, and Shopify GraphQL API.

1

90

Cover image for Built and owned the entire

Built and owned the entire technical stack for a US e-commerce platform generating $1M/mo revenue. Developed custom Next.js storefront, checkout, and CMS admin panel from scratch. Integrated Stripe, Braintree, PayPal, Apple Pay, and Google Pay. Implemented fraud protection, automated chargeback handling via Visa CDRN, server-side tracking (FB CAPI, Google Ads), and BigQuery analytics pipeline.

1

81