Skip to content

Instantly share code, notes, and snippets.

@ravachol70
Created July 17, 2024 12:20
Show Gist options
  • Save ravachol70/b5b7deade7ec6084d2f80a77b2550ecc to your computer and use it in GitHub Desktop.
Save ravachol70/b5b7deade7ec6084d2f80a77b2550ecc to your computer and use it in GitHub Desktop.
Karen's Recovery

SQL Query: Selecting Data Indicative of Positive Trends

SELECT ke.timestamp, ke.efficacy, ke.negativity, ke.internet_usage,
       iw.idiocy, iw.worthlessness,
       (ke.efficacy - ke_prev.efficacy) AS efficacy_increase,
       (ke_prev.negativity - ke.negativity) AS negativity_decrease,
       (ke.internet_usage - ke_prev.internet_usage) AS internet_usage_change,
       (iw_prev.idiocy - iw.idiocy) AS idiocy_decrease,
       (iw_prev.worthlessness - iw.worthlessness) AS worthlessness_decrease
FROM KarenExistence AS ke
JOIN KarenExistence AS ke_prev
  ON ke_prev.timestamp = (
      SELECT MAX(timestamp)
      FROM KarenExistence
      WHERE timestamp < ke.timestamp
  )
JOIN IdiocyWorthlessness AS iw
  ON ke.timestamp = iw.timestamp
JOIN IdiocyWorthlessness AS iw_prev
  ON iw_prev.timestamp = (
      SELECT MAX(timestamp)
      FROM IdiocyWorthlessness
      WHERE timestamp < iw.timestamp
  )
WHERE ke.efficacy > ke_prev.efficacy -- Increasing efficacy
  AND ke.negativity < ke_prev.negativity -- Decreasing negativity
  AND ke.internet_usage <= ke_prev.internet_usage -- Managing internet usage
  AND iw.idiocy < iw_prev.idiocy -- Decreasing idiocy
  AND iw.worthlessness < iw_prev.worthlessness -- Decreasing worthlessness
ORDER BY ke.timestamp;

In the context of Karen's existential journey:

  • Efficacy: Reflects Karen's overall effectiveness in managing her life, combining her sense of agency and stewardship.
  • Negativity: Tracks negative interactions or stress levels, aiming for reduction.
  • Internet Usage: Monitors the time spent online, aiming for balanced and productive use.
  • Idiocy/Worthlessness: Tracks feelings of idiocy and worthlessness, aiming for reduction.

System Dynamics Reference

In system dynamics, managing personal aspects like efficacy, negativity, internet usage, idiocy, and worthlessness can be seen as balancing feedback loops. Increasing efficacy while reducing negativity, idiocy, and worthlessness can lead to a more balanced and fulfilling life. The timestamp column helps track these dynamics over time, providing a temporal dimension to the analysis.

Conclusion

This existential model focuses on personal management indicators and individual agency. By monitoring key metrics such as efficacy, negativity, internet usage, idiocy, and worthlessness, Karen can identify positive trends and areas for improvement in her personal management and well-being, reflecting her deeper existential journey.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment