wojcikstefan

5 ms·

1.
by wojcikstefan 2y ago
> A diet of mostly-plants can be just as delicious as one with a lot of beef. I strongly disagree – as a person who's eaten vegan for over a year, tried all the fancy meat alternatives, and has gone back because a good grass-fed ste
2.
by wojcikstefan 2y ago
Thank you very much! :) I still advise that you try really, really hard to avoid using `pg_hint_plan` if you can, but it's nice that it exists if all else fails or if you need temporary relief at a time of crisis.
3.
by wojcikstefan 2y ago
Good intuition and thank you! :) Not sure if this is a good fit for you, but you could consider using the partitioning built into Postgres to split one large logical table with all your games into a "hot" partition containing the
4.
by wojcikstefan 2y ago
Agreed, event sourcing is a pretty good match for call flows. You could first store every call leg / conference / recording / etc. webhook Twilio sends you as an event and then derive the state of the final "call" c
5.
by wojcikstefan 2y ago
Hi HN community, author of the post here. Let me know please if you have any questions, comments, or feedback!
6.
PostgreSQL Statistics, Indexes, and Pareto Data Distributions(making.close.com)
49 points by wojcikstefan 2y ago|8 comments
7.
by wojcikstefan 2y ago
Can you tell us more about your scaling issues with Temporal? I haven't yet used it in production, but I would've expected that a system which evolved out of Uber's Cadence [0] (and which I believe is used at Uber extensively
8.
by wojcikstefan 3y ago
Hiya Aidan! :D > Is this behaviour new? Don't think so. Even the docs for SQLA v1.3 ([0]) mention it: > native_enum – Use the database’s native ENUM type when available. Defaults to True. When False, uses VARCHAR + check constrai
9.
by wojcikstefan 3y ago
Whew, good to know! Another point towards the `CHECK` constraint approach. Thanks! :)
10.
by wojcikstefan 3y ago
Can you elaborate on what it means to use PostgreSQL enums "on your code API"? > It's such an outrageously naive idea that I'm sure most people here were attracted to the title thinking it's about algebraic types
11.
by wojcikstefan 3y ago
> I usually use C# Enums translated by EF Core now (...) Does this approach ensure data consistency? Or could you accidentally insert a number value into your table which is not represented by any of the enum values?
12.
by wojcikstefan 3y ago
Apologies for my ignorance, but what does "FDW" stand for in your comment? :)
13.
by wojcikstefan 3y ago
Just to make sure I understand your suggestion fully, you're saying: 1. Use `smallint` instead of `text` for the column type. 2. Otherwise follow our "`CHECK` constraint" approach (without it we're jeopardizing data cons
14.
Representing Enums in PostgreSQL(making.close.com)
112 points by wojcikstefan 3y ago|74 comments
15.
by wojcikstefan 4y ago
Coca Cola & Red Bull are massive, they surely have tiny marketing spend… Right?
16.
by wojcikstefan 4y ago
Agreed!
17.
by wojcikstefan 4y ago
I thought it was GitLab which was remote-first (or should we say remote-only?). GitHub still seems to have offices and people going into them.
18.
by wojcikstefan 4y ago
My heart goes out to the laid off employees, though I think they'll be able to find solid jobs (or start their own companies) when they're ready. What I'm more surprised by is: 1. GitHub operating so independently from Micros
19.
by wojcikstefan 4y ago
The YC company I work at (and have been happy working at for the last 11 years) is hiring remotely, anywhere in the time zones of Americas, Europe, and Africa: https://jobs.close.com
20.
How to connect to PostgreSQL (and other data stores) reliably(making.close.com)
6 points by wojcikstefan 4y ago|0 comments
21.
by wojcikstefan 4y ago
I wholeheartedly agree with every single word in this post. I also mourn this feature's death daily. Being able to force-push on the spacebar is not good enough of a replacement.
22.
by wojcikstefan 4y ago
Back when I lived in San Francisco I've met many people who used the SF311 app [0] where you can very quickly snap a picture and report an issue. One person I knew did so multiple times a day every day for many things – poop, trash, et
23.
by wojcikstefan 5y ago
I live in Poland and regularly order Uber Eats/Wolt for $6-8.
24.
by wojcikstefan 5y ago
1. This is not “no-code”. You still have to read & understand the code Copilot generates. 2. I’m very skeptical of a small group of people reading a bunch of online comments and deciding what is “toxic” and “non-toxic”, even more so whe
25.
by wojcikstefan 5y ago
I'm very happy about this proposal. The only sad thing is that it has come so late, after so many tools and protocols (e.g. GraphQL) already abuse POSTs for this use case.
26.
by wojcikstefan 5y ago
> Maybe have a X-GET-QUERY header to indicate the type if GET request? Note that using the "X-" prefix has been deprecated since 2012: https://datatracker.ietf.org/doc/html/rfc6648
27.
by wojcikstefan 5y ago
IMO this helps a lot more people than just database folks. Any web application which implements a fairly granular search/filtering mechanism for its resources may run into the URL character limit with GETs. QUERY sounds much more appro
28.
by wojcikstefan 5y ago
Ah, yep, that explains it. They do solve this problem as documented: https://github.com/socketio/engine.io/blob/64d57545116c7a7d9...
29.
by wojcikstefan 5y ago
100% agree!
30.
by wojcikstefan 5y ago
Indeed it does! https://github.com/primus/primus/blob/a7ba7249cb0205a01629da... I do wish we didn't all have to reinvent this wheel though…

More ›