areohbe

  const fetchMachine = Machine({
    id: "powerUp",
    initial: "inactive",
    context: {
      count: 0,
      selected: {
        sender: undefined,
        filter: undefined
      },
      filters: undefined,

areohbe

macOS Utilities

Cleanup

mac-cleanup

cleanup -n

areohbe

Keybase proof

I hereby claim:

• I am areohbe on github.
• I am areohbe (https://keybase.io/areohbe) on keybase.
• I have a public key ASDU2EiSBFB9TiOGKnjUsgXj1H6y0AHVPaliwZ6pZbgEygo

To claim this, I am signing this object:

areohbe

--Case statement covnert user generated events to the user's local time zone based on a user's state
--Best used when your date/time field is stored as a timestampz, time zone aware, value in postgres
--For states that have more than one time, the time zone with the largest population is used.
--Exmaple use case: figuring out what percentage of user generated events take place outside of buiness hours

--Replace 'state' and 'event_time' with the respective columns names from your postgres database.

case
	when state in ('CT','DE','DC','FL','GA','IN','KY','ME','MD','MA','MI','NH','NJ','NY','NC','ND','OH','PA','RI','SC','VT','VA','WV') then event_time at time zone 'us/eastern'
	when state in ('AR','IL','IA','KS','LA','MN','MS','MO','MT','NE','OK','SD','TN','TX','WI') then event_time at time zone 'us/central'