NikolayS

-- Installs "file_fdw" extension and creates foreign table to work with data from CSV file.
-- See also the comment below which helps to automate the process for Google Spreadsheets
-- Another option would be using Multicorn for Google Spreadsheets, but it requires additional steps  
-- (see https://wiki.postgresql.org/wiki/Foreign_data_wrappers).

create extension file_fdw;
create server "import" foreign data wrapper file_fdw;

create foreign table "table1" (
  col1 text,

ekager

"""
This script will search 4chan (need to specify a board unfortunately) and then
search all comments on Reddit for specific keywords. If found, it will then send
an email with the links to any matching posts.

Because 4chan posts are archived after ~48 hours I would recommend setting this up
to run on that cadence as well.

Sender email will need "Allow less secure apps" to ON or similar setting. 
I followed these instructions for setting that up: 

alexjlockwood

package com.alexjlockwood.circlesquare


import androidx.compose.animation.animatedFloat
import androidx.compose.animation.core.AnimationConstants
import androidx.compose.animation.core.LinearEasing
import androidx.compose.animation.core.repeatable
import androidx.compose.animation.core.tween
import androidx.compose.foundation.Canvas
import androidx.compose.runtime.Composable