Hacker News
Obituary for a Quiet Life
Article URL: https://bittersoutherner.com/feature/2023/obituary-for-a-quiet-life
Comments URL: https://news.ycombinator.com/item?id=40028643
Points: 1
# Comments: 0
Carmack: I regret not doing more to support and defend PalmerLuckey at Facebook
Article URL: https://twitter.com/id_aa_carmack/status/1779171248083177500
Comments URL: https://news.ycombinator.com/item?id=40028629
Points: 1
# Comments: 0
Failures of Kindness (2013)
Article URL: https://jamesclear.com/great-speeches/failures-of-kindness-by-george-saunders
Comments URL: https://news.ycombinator.com/item?id=40028615
Points: 1
# Comments: 0
Doom as an Interface for Process Management (2000)
Article URL: https://www.cs.unm.edu/~dlchao/flake/doom/chi/chi.html
Comments URL: https://news.ycombinator.com/item?id=40028555
Points: 1
# Comments: 1
Why YouTube will continue to use Flash instead of HTML5 (2010)
Article URL: https://www.neowin.net/editorials/why-youtube-will-continue-to-use-flash-instead-of-html5/
Comments URL: https://news.ycombinator.com/item?id=40028546
Points: 1
# Comments: 0
Help on database for efficient group bys
I’m having trouble finding a database that can handle my use case:
Select device_id, min(signal_date_time) from signals where signal_date_time >= ‘specific_date_time_value’ group by device_id;
There are more where conditions, but essentially I can have millions of rows per device. After my where conditions I know I can have around 100000 devices. I need to be able to do this query in under 1 second for concurrent queries.
So far I’ve tried modeling this in: - clickhouse - Postgres - mongodb
Any help would be greatly appreciated!
Comments URL: https://news.ycombinator.com/item?id=40028523
Points: 1
# Comments: 1
The Wide Wide Sea:Imperial Ambition,First Contact and Final Voyage of James Cook
Article URL: https://www.penguinrandomhouse.com/books/602227/the-wide-wide-sea-by-hampton-sides/
Comments URL: https://news.ycombinator.com/item?id=40028509
Points: 1
# Comments: 0
Can You Grok It – Hacking Together Your Own Dev Tunnel Service
Article URL: https://0xda.de/blog/2024/04/can-you-grok-it/
Comments URL: https://news.ycombinator.com/item?id=40028494
Points: 1
# Comments: 1
Police arrested four people over $300k of stolen Lego kits
Article URL: https://www.theverge.com/2024/4/13/24129595/lego-crime-ring-arrested-los-angeles-300000-dollars
Comments URL: https://news.ycombinator.com/item?id=40028480
Points: 2
# Comments: 0
Crying Myself to Sleep on the Biggest Cruise Ship
Article URL: https://www.theatlantic.com/magazine/archive/2024/05/royal-caribbean-cruise-ship-icon-of-seas/677838/
Comments URL: https://news.ycombinator.com/item?id=40028475
Points: 1
# Comments: 0
'Unconventional' Warfare
Article URL: https://acoup.blog/2024/04/12/fireside-friday-april-12-2024/
Comments URL: https://news.ycombinator.com/item?id=40028421
Points: 2
# Comments: 0
The classic DOOM game over htop, the text-based process viewer
Article URL: https://github.com/0x0mer/doom-htop
Comments URL: https://news.ycombinator.com/item?id=40028400
Points: 1
# Comments: 0
AI Coding Co-worker.One agent to rule everything API
Article URL: https://github.com/IncredibleDevHQ/Incredible.dev
Comments URL: https://news.ycombinator.com/item?id=40028378
Points: 2
# Comments: 0
QLLMs: A Study in Quantum Architecture + QNLP
Article URL: https://arxiv.org/abs/2307.08191
Comments URL: https://news.ycombinator.com/item?id=40028369
Points: 1
# Comments: 1
View of the World from 9th Avenue and Steinbergian Cartography
Article URL: https://saulsteinbergfoundation.org/essay/view-of-the-world-from-9th-avenue/
Comments URL: https://news.ycombinator.com/item?id=40028367
Points: 1
# Comments: 0
Show HN: Codepilot – The Ultimate SaaS Starter Kit
I've noticed I kept doing the same things over and over again while building SaaS apps from scratch. So I thought, why not streamline the process? I launched a super flexible SaaS Starter Kit, CODEPILOT, that can be used for all sorts of SaaS building.
My goal is to ensure I am are on the right track when it comes to technology, customizability, developer experience, and maintenance. It's built with the latest frameworks to ensure that your application is fast, secure, and scalable.
I hope this boilerplate will help you as it helps me!
Enis.
Comments URL: https://news.ycombinator.com/item?id=40028363
Points: 1
# Comments: 0
Implementing an SHA Transformer by Hand
Article URL: https://andrew.gr/stories/sha/
Comments URL: https://news.ycombinator.com/item?id=40028340
Points: 2
# Comments: 0
Making Truth Social Comply with the AGPL
Article URL: https://boehs.org/node/truth-social
Comments URL: https://news.ycombinator.com/item?id=40028338
Points: 89
# Comments: 5
How a board game like Catan is created
Article URL: https://www.cnn.com/2024/04/11/us/creating-catan-board-games-card-cec/index.html
Comments URL: https://news.ycombinator.com/item?id=40028329
Points: 2
# Comments: 0
Show HN: One Billion Rows in CUDA
Article URL: https://github.com/tspeterkim/cuda-1brc
Comments URL: https://news.ycombinator.com/item?id=40028326
Points: 2
# Comments: 0