Skip to content

November: 5th

2024

Section titled “2024”

  • 09:45AM

    Docs

    Decided to make a quick repo for the microbot community. It was a great refresh for operating inside my own repo without having to deal with a monorepo? Without that extra layer, it does make things so much easier to build and quickly deploy.

  • 11:40AM

    Election

    The day of the year is finally here and I can not wait until the day is over. There is going to be a nice release of all that political gunk stuck in everyones mind, its post election nut clarity.

  • 01:07PM

    Supabase

    Table structure is currently:

    • user_cards
    • user_cards_public
    • user_profiles

    With the user_cards_public being a materialized view, so we will not have to worry too much about it.

    Trigger structure, there are two areas that we need to process for the triggers, the auth schema and the public schema. Under the auth schema, we only have the on_auth_new_card_created trigger active but that will be disabled in this next query. The bigger concern will be under the public schema, where we have 4 more triggers!

    • handle_user_card_update - under table user_cards with function handle_user_card_update
    • handle_user_cards_update - under table user_cards with function moddatetime
    • handle_user_profile_update - under table user_profiles with function handle_profile_update
    • handle_user_profiles_update - under table user_profiles with function moddatetime

    Finally we have the database functions, which are split into into the two schemas again, auth and public. Under the public, we have:

    • before_insert_hcaptcha_verfication with 0 arguements, a return type of trigger and security of invoker.
    • create_user_profile - with _username as text, a return type of void and a security definer.