Iiyiolainfreecodecamp.org·Jun 17 · 18 min readHow to Schedule Jobs in PostgreSQL with pg_cron Every backend system eventually needs something to run on a schedule. Old sessions need deleting, summary tables need rebuilding, materialized views need refreshing, and maintenance tasks need to happ00
Iiyiolainfreecodecamp.org·Apr 16 · 19 min readHow Database Indexes Work – A Practical Guide with PostgreSQL ExamplesEvery developer eventually runs into a slow query. The table has grown from a few hundred rows to a few million, and what used to take milliseconds now takes seconds — or worse. The fix, more often th00
Iiyiolainfreecodecamp.org·Mar 27 · 11 min readWhat Are Database Triggers? A Practical Introduction with PostgreSQL ExamplesIf you've ever needed your database to automatically respond to changes – like logging every update to a sensitive table, enforcing a business rule before an insert, or syncing derived data after a de00
Iiyiolainiyiola.hashnode.dev·Jan 17, 2022 · 9 min readHow To use GraphQL with GoIntroduction to what we are building Prerequisite What is graphql Setup the project Install required packages setup the database setup the env file setup the glqen gen reset schema file generate from the resolver file write functions to get info/slap...01L
Iiyiolainiyiola.hashnode.dev·Dec 31, 2021 · 3 min read2021: The year that showed me shegeI don't even know how to start this but yeah month by month I guess. January I turned 17, Got my first pay in tech for a contract job I have been doing since November 2020 and I got another contract with the same place ( Kyshi ), I was able to get a ...00
