Dystopian (u/Dystopian)

Dystopian commented on Walmart VP took $30K/day kickbacks favoring Indian H1Bs over US applicants twitter.com/Anc_Aesthetic... · Posted by u/DonnyV

Dystopian · 6 months ago

I’m actually very surprised this happened at Walmart.

I worked on an adjacent project with one of their teams many years ago. I was very surprised by how zero tolerance their policies were about receiving anything.

It may have been the team I was working with, but I remember none of them allowed us to buy them coffee from the shop in our lobby when they visited.

Dystopian commented on Nvidia's RTX 5000 Ada Now Available: AD102 with 32GB of GDDR6 tomshardware.com/news/nvi... · Posted by u/pizza

valine · 2 years ago

It’s not a direct apples to apples comparison, but compared to a RTX 4090 this isn’t compelling. Other than the 32GB of VRAM there’s not much going for this card. For $4k most people would be better off with dual 4090s.

Dystopian · 2 years ago

Or 2x 3090s to make it even more cost effective.

If you're using these for purely inference (which is what the 5000 seems like it's tuned for) the vram's the real bottleneck so you get a similar bang for your buck using last gen's cards vs. the bleeding edge.

I've also found the crypto crash has dumped a bunch of these well-worn cards on the market you can pick up a bit cheaper.

Dystopian commented on Publishers in Canada urge regulator to prevent Meta from restricting news access philaverse.substack.com/p... · Posted by u/finphil

Dystopian · 3 years ago

As a Canadian, I find the whole saga of how our government works with the technology sector bat-shit crazy.

All of the media's coverage up here is disingenuously about tech overreach and not about how their lobbyists tried to double-dip on revenue (both demanding an estimated $329M/year[1] from tech companies, while also receiving the ad revenue from ++1.9B pageviews[2]).

The problem is there'll probably be some kind of settlement between the government, news companies, and tech. But while this drags on, the larger oligopoly of news outlets will come out alive, while smaller news outlets are really going to suffer financially.

If you want to read more about our government's recent brain-dead policies on technology you can look up:

C-11: A streaming services bill that mandates Canadian content on foreign streamers. Not horrible, but also a great way to have "This service is not available in your region." notices in your country.

DST: A "just because" global digital services tax of 3%, which will definitely be passed onto consumers, if not lead to service blockages in Canada.

C-18: ↑ This bill. Pretty much a shakedown by the government and media companies.

> This is coming from a registered liberal party member, who's socially liberal and is consistently confronted with the thought that I may actually be conservative.

[1] https://www.pbo-dpb.ca/en/publications/RP-2223-017-M--cost-e... [2] https://about.fb.com/news/2022/05/how-meta-supports-news-pro...

Dystopian commented on Streaming data in Postgres to 1M clients with GraphQL github.com/hasura/graphql... · Posted by u/tango12

atentaten · 3 years ago

How different is this from Supabase Realtime?

Dystopian · 3 years ago

Disclaimer - I work on Hasura, so I won't comment too much on which is better.

They're all similar flavors of producing realtime results - which take similar, but different, methods to their approach.

My understanding (please feel free to correct me if I'm wrong):

- Supabase Realtime uses WAL.

- Hasura Streaming Subscriptions uses a query which will be append-only (could be a sort-by or also WAL).

- Hasura Live Queries uses interval polling, refetching, and multiplexing.

- Supabase uses Postgres RLS for authorization, while Hasura uses an internal RLS system which composes queries (which allows for features like the multiplexing above).

- All 3 use websockets for their client communication.

Supabase Realtime

https://github.com/supabase/realtime#introduction

https://supabase.com/docs/guides/realtime

Hasura Streaming Subscriptions / Live Queries

https://github.com/hasura/graphql-engine/blob/master/archite...

Dystopian commented on Streaming data in Postgres to 1M clients with GraphQL github.com/hasura/graphql... · Posted by u/tango12

nicoburns · 3 years ago

We’ve been using hasura at work, but we’ve stopped using it for everything other than subscriptions in favour of hand written rest apis. The problem for us wasn’t really graphql itself, but the fact that the client app was determining the query. If the client could request a “named query”, that was then determined by the backend (perhaps via a web hook?)then we’d have been able to use hasura more.

Dystopian · 3 years ago

Hasura also has controls for allow listing opertaions for that composed on the FE problem (https://hasura.io/docs/latest/security/allow-list/).

There's also a few NPM packages for auto-generating that allow list from your project (https://www.npmjs.com/search?q=hasura%20allow%20list -- the one I've used before was from `tallerdevs`).

Dystopian commented on Show HN: Elestio – Managed platform for over 150 open-source software stacks · Posted by u/js4ever

Dystopian · 4 years ago

Really like the idea - think there's a super decent market for this kind of solution.

Only thing I'd be aware about though is making sure you're on the right side of licensing for all the vendors you're using (/ possibly who you've talked with to make sure the usage is ok).

Off the top I saw N8N on the homepage who are a little more strict about their licensing for cloud vendors. There's also Airbyte and Redpanda who use Elastic and BSL licenses to try and deter cloud vendors from packaging some parts of their services.

Dystopian commented on Ask HN: Who is hiring? (January 2022) · Posted by u/whoishiring

Dystopian · 4 years ago

Hasura (https://hasura.io) | Haskell / React | Global / Remote First | Multiple Roles | Full-time

Hasura is creating tools which help developers quickly and efficiently stand-up GraphQL APIs. We provide instant-on GraphQL APIs, while providing easy-to-use resources for setting up authentication, authorization, and data-access permissions.

We're actively hiring for open positions:

1) Front-End Developer

2) Haskell Developer

3) Engineering Manager

4) DevOps / SRE

5) Product Designer / Developer Experience

Apply Now: https://hasura.io/careers/

Dystopian commented on Ask HN: Simple HTTP server for local dev and testing? · Posted by u/forgotmypw17

gjvc · 4 years ago

as close as possible as to what's used in production

Dystopian · 4 years ago

I agree with this ↑

If you want to play with something fun though, Richard Hipp (of SQLite) has althttpd which sparked my interest when I first heard about it - https://sqlite.org/althttpd/doc/trunk/althttpd.md

Dystopian commented on PostgREST 9.0 postgrest.org/en/v9.0/rel... · Posted by u/kiwicopple

revskill · 4 years ago

Wish PostgresQL has built-in version control for every DDL changes.

For example, i want a history of changes when i run command like CREATE OR REPLACE FUNCTION...

Else programming inside database is still a pain.

Dystopian · 4 years ago

While general best practice is that you version your changes in git and deploy migrations with something like FlyWay I've also run into the problem of needing some form of 'audit log' to make sure no DDL changes are being made in prod (and if they are, moving them over into version control).

I have a migration which is something like this one: https://www.alibabacloud.com/help/doc-detail/169290.html which uses a trigger on `ddl_command_end` in PG to copy over the query which made the DDL change from `pg_stat_activity` to a new audit schema to stash. Can definitely help with maintenance and finding out what happened when.

Dystopian commented on Hasura GraphQL Engine 2.0 github.com/hasura/graphql... · Posted by u/stevefan1999

yodon · 5 years ago

The Hasura pricing pages list SSO as being a "contact sales for pricing" feature. Does that mean endpoint authentication via JWT and Webhooks is only available to Enterprise customers or does the SSO pricing line item refer to something else other than this type of endpoint authentication?

Dystopian · 5 years ago

(From Hasura)

The self-hosted community version has full access to JWT and webhook validation.

The SSO listed is a feature to integrate with the Hasura Cloud Dashboard for logging in and managing projects. Think Okta => Hasura Cloud => Hasura Project (Instance). We'll definitely take a look at wording it to make it more clear.