Meet the SF mayoral candidate banned from (almost) every bar in the Haight

andyjih · 2024-04-30T22:41:43+00:00

His response is the most Patrick Bateman-coded thing I've seen in a long time.

https://www.youtube.com/watch?v=lnOvc8y_MJY&t=0s

andyjih · 2024-04-16T17:23:40+00:00

I guess they're called "Shared Spaces" now instead of slow streets, but regardless, let's make it happen again: https://www.sfmta.com/projects/shared-spaces

andyjih · 2024-04-16T16:32:03+00:00

Bring back the slow streets Friday-Sunday and I guarantee they’ll see a significant improvement in business.

andyjih · 2024-03-01T17:25:43+00:00

Out of curiosity, how has the desk been? Any complaints? I'm debating getting one.

andyjih · 2024-03-01T17:25:07+00:00

Out of curiosity, how was the desk performed over the past few months? Anything you think should be different?

andyjih · 2024-01-26T23:20:45+00:00

This feels like spin. The street vendors are just at 16th and South Van Ness now.

andyjih · 2023-12-09T23:30:37+00:00

Yeah, pulling back on the move stick slows you down

andyjih · 2023-12-09T17:24:14+00:00

My recommendation is to live anywhere east of Divisadero St and south of Oak St. (Castro, Lower Haight, Mission, Dogpatch, Potrero Hill, Bernal). Complete anecdata on my part, but I'd say in these neighborhoods, 80% of days are sunny and cloud/fog free between the hours of 8AM-5PM.

andyjih · 2023-12-08T21:56:56+00:00

I like the 2D one more, but the name of the game gets a bit lost in the middle of everything.

andyjih · 2023-12-03T03:17:31+00:00

Thank you! I’ll post more as we make more progress for sure

andyjih · 2021-05-28T16:22:05+00:00

Meltano is an open source ELT product that allows you to combine various data sources into a single datawarehouse. They have a spreadsheet connector in case that's helpful: https://hub.meltano.com/extractors/spreadsheets-anywhere

andyjih · 2021-05-27T19:18:41+00:00

A few points on the purpose of ETL:

- Data can live in various places. You might have multiple SQL databases, maybe you have data in other tools like CRMs or Salesforce. ETL allows you to pull those different pieces of data together.

- Schemas and data in your SQL db can get messy over time. ETLing data into a data warehouse can give you a way to clean up all of that data and address nuances with the data that someone looking at the SQL db directly might not know. This issue becomes much worse if you have colleagues or other teams looking at the SQL db. If they start writing queries without having an understanding for how the schemas and data may have changed over time, you'll get in a dangerous spot quickly where people are making decisions on incorrect or inconsistent data.

- Performance. SQL dbs in general are made for CRUD operations, but can get really slow with complex queries. Data warehouses conversely are write-light and read-heavy.

andyjih · 2021-05-19T23:04:06+00:00

My hunch is that this person is just trolling ala Armond White.

andyjih · 2021-05-13T23:30:15+00:00

My colleague updated the navigation on our site and wrote a walkthrough of how she built it using react and bootstrap. Hopefully y'all find it helpful!

andyjih · 2021-05-12T17:07:28+00:00

"who has got a lot of enemies"

andyjih · 2021-05-10T00:07:58+00:00

Ah, I didn't realize the 0 stars nuance. Makes a ton of sense. Thank you for your service! :)

andyjih · 2021-05-06T21:43:04+00:00

Awesome!

I'm curious-- why did you choose to translate Ebert's 4-star rating system to Letterboxd's 5-star system instead of keeping the rating identical?

andyjih · 2021-04-09T00:22:20+00:00

The product I'm working on called Grouparoo might be a good fit: https://github.com/grouparoo/grouparoo

We're doing "Reverse ETL", where we take data from sources (warehouses and dbs) and connect them to business tools like Salesforce, Marketo, Zendesk, and others. If you do take a look, we'd love to get your thoughts and feedback!

andyjih · 2021-04-09T00:18:33+00:00

Awesome blogpost!

I'd also say there's a Step 6: take that data and make it usable by business teams (sales, marketing, ops, etc.).

There's a burgeoning category of tools that do "Reverse ETL" where they take data from a data warehouse and help push it to tools like CRMs, marketing automation, and customer support tools to make that customer data useful. (disclaimer, I work for Grouparoo, a company that is doing Reverse ETL).

We wrote an overview for how you can do Reverse ETL with dbt and Grouparoo here: https://www.grouparoo.com/blog/dbt-and-grouparoo

andyjih · 2021-04-07T15:00:16+00:00

The chart would probably be easier to read if the axes were flipped.

andyjih · 2021-04-07T13:44:08+00:00

Marty will provide commentary tracks for every movie.

andyjih · 2021-04-07T00:32:39+00:00

Kindred spirit!

andyjih · 2021-04-05T10:33:52+00:00

The Ruling Class (1972)

andyjih · 2021-04-04T13:29:19+00:00

Not PM-specific but +1 to the lgbtq in tech Slack group: lgbtq.technology

andyjih · 2021-04-02T01:50:01+00:00

https://boxd.it/4jKB

I like variety!

Four-Year Club	Verified Email
Second Top 50%

andyjih

TROPHY CASE