HNHacker News
TopNewBestAskShowJobs

ggregoire

4,955 karma · joined October 31, 2012

submissionscomments
ggregoire··on Biden-Trump debate breaks parts of Reddit, it seems
I read this comment on one of the threads on reddit:

> It broke because of /r/politics. When a discussion thread gets meaningfully past 30,000 comments, it starts to lag subsequent submissions to that thread, and then lag the entire site, until there's eventually a full chokeoff. The debate thread ballooned to an insane number of 56k before mods locked it, at which point the comments in there were 25 minutes behind realtime.

> Had the /r/politics mods locked the first thread and started a new one properly, it wouldn't have caused a sitewide issue. But this has been a problem since forever. It just rarely happens because there are rarely scenarios where enough people are commenting on a single specific thread so as to cause the cascade failure.

ggregoire··on One Million Checkboxes
> react-window

I'm confused, I read everyday on hacker news that react is the slowest JS framework ever made. Seems fine to me.

ggregoire··on Comparing the Framework Laptop with the MacBook Air M2: A Detailed Review
> Operating System: [...] I already use Linux, so the Framework 13 wins.

Should probably start the review with this. I'm not gonna buy a Framework 13 if I want to use macOS, and vice versa.

ggregoire··on Should I use JWTs for authentication tokens?
> there is definitely "resume-driven development" where people pick something they want to put on their resume to solve a problem regardless of its suitability to the task in hand.

Or people in this industry are geeks and curious and like to try new stuff and technologies just for fun?

That's the case for the majority of people I've worked with.

ggregoire··on Ask HN: What's the best charting library for customer-facing dashboards?
I just tried nivo in my last react project and eventually had to reinstall echarts-for-react since most of my charts have 2+ vertical axises with different scales and it's not supported in nivo (I read there is a hack with stacking multiple charts on top of each other, but in echarts it's just a 1 line option).

I've been using echarts for 5+ years and I've yet to encounter a chart I couldn't make exactly like I needed.

ggregoire··on U.S. sues Apple, accusing it of maintaining an iPhone monopoly
Can Apple win?
ggregoire··on How to commit part of file in Git
VSCode handles this very well too: select the lines you want to commit and do "Git: Stage selected ranges"
ggregoire··on Sora: Creating video from text
That's what Twitch has become too. The most popular Twitch streamers do nothing other than watching YouTube videos and providing a fake relationship to their 50,000 live viewers.
ggregoire··on Should I use a pie chart?
> In the adjacent pie chart, try to figure out which group is the biggest one [...]. You will probably struggle to do so and this is why pie charts must be avoided.

It's not that bad when the purpose of the pie is not to figure out which group is the biggest.

I find the pie pretty appropriate when the goal is to figure out

- if all the groups are more or less the same

- if one or several groups are way bigger than the other groups

- if one or several groups are way smaller than the other groups

Not saying pies are the best for this (bar charts work well too), just saying it works well.

> try to order them by value

I mean, why would you not order them already inside the chart? So that the reader doesn't have to do it.

ggregoire··on Hono v4.0
From the example it seems like it's to make HTTP APIs? You declare a route "/" and it returns the content "Hello Hono!" for this route. The word "API" appears twice on the landing page and github README, and the word "web framework" appears once on the github README. But indeed we shouldn't have to scrutinize all the sources of information to know what this is.

Also "web standard API" doesn't really mean anything? Might just be because the authors are not native English speakers tho.

I'd rewrite the main description to "Hono: Fast, Lightweight, web framework to build APIs" or something. See FastAPI landing page [1] for a reference: "FastAPI is a modern, fast (high-performance), web framework for building APIs with Python 3.8+ based on standard Python type hints." I know immediately what this is.

[1] https://fastapi.tiangolo.com

ggregoire··on Transforming Postgres into a Fast OLAP Database
Slightly related but it's so interesting to me all those new small tech companies that basically provides value on top of Postgres! They usually blog about some obscure stuff about Postgres and one of their articles gets on the frontpage of HN. Good marketing and very cool stuff!
ggregoire··on Show HN: Million 3 – Optimizing compiler for React
Never heard of this, sounds super cool! Gratz on the milestone!

Theoretically, could this be merged in the main React project or would this break something?

ggregoire··on Pandoc
Don't know if you would call this a "program" but PostgREST is written is Haskell too.

https://github.com/PostgREST/postgrest

ggregoire··on We built our customer data warehouse all on Postgres
You might find some info in the docs of PostgREST [1] or in the previous discussions on HN about it [2].

For the versioning, I just have a git repo where I keep the definitions of every role, schema, table, view, function, trigger, grant, policy, etc. Every time I change something in the database I first change it in the git repo too to not lose the history. It also helps as a reference for future development, like if I need a trigger function I can just search one in the repo and copy/paste it.

[1] https://postgrest.org

[2] https://hn.algolia.com/?q=postgrest

ggregoire··on We built our customer data warehouse all on Postgres
> Use Postgres as my permissions layer?

It's actually so good I regret not having done it sooner. We migrated all our APIs into PostgREST [1] and it reduced our development/testing/deployment time by an insane amount, decreased the number of bugs automatically by removing 1 extra layer and made all our requests faster without having to optimize anything.

I'm genuinely surprised it's not more popular. It would probably benefit like 99% of the small/medium size companies.

Writing SQL is kinda fun too.

[1] https://postgrest.org

ggregoire··on Apple announces changes to iOS, Safari, and the App Store in the European Union
Can EU users opt-out from all that stuff?
ggregoire··on Python Packaging, One Year Later: A Look Back at 2023 in Python Packaging
There is nothing to maintain. I bump python in the dockerfile if I need to bump it for some reasons, otherwise there is no reason to change anything and it indeed just works. Takes like 2 min of work once a year.

I can rebuild an image from 5 years ago and deploy it on multiple OSes and it will probably still work.

ggregoire··on Python Packaging, One Year Later: A Look Back at 2023 in Python Packaging
I use pip inside docker and it just works.
ggregoire··on I'm sorry but I cannot fulfill this request it goes against OpenAI use policy
Seems like an issue with people buying the cheapest stuff from brands no one has ever heard of. See previous comment, someone bought a blender that doesn't blend. Pretty sure if you buy a mid-high price blender on Amazon from a reputable brand, it will blend.
ggregoire··on JSONB has landed
There are good use cases, but from my personal experience, I've seen people use JSONB mainly to avoid to have too many columns when they inspect their tables, so they split their data into two groups, the ones supposedly important that have dedicated columns and the rest that is thrown into a single JSONB column.
ggregoire··on An update on Twitch in Korea
Do you know what's the audience share of AfreecaTV and Twitch in Korea? I can't find the information.
ggregoire··on New in Chrome 120 back button detection
> CloseWatcher API

> Chrome 120 brings the solution with CloseWatcher, a new API for directly listening and responding to close requests.

> watcher.addEventListener("close", () => document.querySelector("#sidebar").classList.remove("open"));

Couldn't they add an HTML attribute onCloseRequest?

Slightly related, I wish there was an attribute "onClickOutside" so we could close modals and dropdown menus without manually adding an event listener on the window and checking if the click wasn't inside the element.

ggregoire··on An update on Twitch in Korea
Twitch shutting down in Korea will most likely not stop Riot Games to keep hosting the World Championship in Korea.

Also, from what I understand, Twitch is marginal in Korea, since they have their own alternative streaming platforms.

ggregoire··on Ask HN: What are some unpopular technologies you wish people knew more about?
I use it in production. Handling roles and permissions in the DB is a game changer.
ggregoire··on Ask HN: What are some unpopular technologies you wish people knew more about?
Turn your Postgres database into a REST API: https://postgrest.org

Previous discussions on HN: https://hn.algolia.com/?q=postgrest

ggregoire··on The Seamless Communication models
> I told her then that the industry would be disrupted by AI before she retired.

Yes. I just discovered there is a text-to-speech addon [1] (now a few months old) for World of Warcraft that adds voices for every NPC in the game... It is so impressive and game changer (pun intended) that I naively asked in the chat of the Twitch stream I was watching "when did Blizzard add voices to the NPCs??". For an instant I really thought Blizzard contracted actors, but no, someone like you and me just used AI to generate realistic voices for every character in the game. I don't think it's ready yet to completely replace actors in video games (surely it will in the near future tho) but voice acting is something so expensive to do that I can see studios and developers in 2024 already use this tech for all the optional dialogues and secondary characters' voices.

[1] https://www.curseforge.com/wow/addons/voiceover

ggregoire··on Show HN: DataSheetGrid, an Airtable-like React component
> The frontend JS frameworks evolve so quickly that it's head-spinning.

They really don't, tho.

React took over the front-end world 8 years ago or so. It barely evolved since then. I read the doc a second time 4 years ago when they introduced React Hooks.

ggregoire··on Ask HN: What are you passionate about at the moment?
Most modern board games have a solo mode and many games are solo only. I gave two links to the sibling comment if you want to look at some games.
ggregoire··on Ask HN: What are you passionate about at the moment?
Here is a good start: https://boardgamegeek.com/geeklist/306154/2022-peoples-choic...

The subreddit is pretty active too: https://old.reddit.com/r/soloboardgaming

ggregoire··on Stack Overflow is laying off another 28%
Same here. I look for answers about 10 times a day I'd say and in 90% of the cases I found what I was looking for, in a few seconds, for free. I also post answers when I found old questions and the answers are outdated or not complete. I know it helps other people cause I usually get 1-10 upvotes / year for those answers on old questions. Mostly about python, sql, postgres, js, react, aws and docker, so popular topics. I rarely have to post questions on my own, usually cause it's already asked and answered, or cause I'm experienced enough to find the solutions on my own or somewhere else.

Anyway, have been using SO for 12 years and still think it's great.

← PreviousPage 5 of 33Next →