HNHacker News
TopNewBestAskShowJobs

aggrrrh

139 karma · joined June 10, 2014

submissionscomments
aggrrrh··on Steam censors LGBTQ+ content on behalf of the Russian Government
Have you ever been in russia?
aggrrrh··on I think Yann Lecun was right about LLMs (but perhaps only by accident)
This is a really important question that still has no answer. No one wins in the late stage of capitalism
aggrrrh··on Nokia 6600 vs. Samsung S24 Ultra
It has a-gps that works with mobile network triangulation
aggrrrh··on Use a work journal
It’s great. You should do a separate hn post
aggrrrh··on Sora: Creating video from text
Looking at it and in my opinion it just reinforces theory that we live in simulation
aggrrrh··on An Introduction to APIs
Basic REST and JSON RPC are very simple to start with, but have common problems when application gets bigger. How do you represent relations, pagination, filtering etc? My go-to specification for structuring JSON documents is https://jsonapi.org/ It covers most basic needs of a standard API.
aggrrrh··on Alien Supercivilizations Absent from 100k Nearby Galaxies (2015)
Take a look on Bobiverse series. Not quite the same, but similar.
aggrrrh··on Initial revision of “Git”, the information manager from hell
git's first self-hosted commit
aggrrrh··on SkyLifter is an eVTOL air crane
I wonder if it would work in Venus atmosphere?
aggrrrh··on Ask HN: How do you manage direct updates to databases in a production system
Schema(or data in a database) in your release N should be compatible with release N-1, so you can revert your code to previous working version with new schema. That's the only way to ship new releases without stopping service for maintenance.
aggrrrh··on Ask HN: How do you manage direct updates to databases in a production system
A lot of replies talks about schema migration and tools like Liquibase etc. But as I understand the question, it's about running update / delete queries in production environment, not DDL.

In my opinion such queries should be subject of established development process: 1. Commit your query to a repository 2. Send to code review 3. After successful review and merge it should be deployed automatically by ci/cd

It may be necessary to run query directly via console in some cases, though. But such query should be committed to the repository latter any way.

And of course you should use proper tools like comments suggest.

aggrrrh··on Mistakes I've Made in AWS
Probably you should try sqlite. And maintenance will be even easier.
aggrrrh··on Switching to Windows
You can open a menu with option-click and hold on expand icon and snap window to the side of the screen
aggrrrh··on Ending our Medium integration
I hope more people will use open source self-hosted platforms like Ghost. We used medium before, but experience, including their api was just awful.