Hacker News

Subscribe to Hacker News feed
Hacker News RSS
Updated: 17 min 44 sec ago

Help on database for efficient group bys

Sat, 04/13/2024 - 11:58pm

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

Categories: Hacker News

'Unconventional' Warfare

Sat, 04/13/2024 - 11:32pm
Categories: Hacker News

QLLMs: A Study in Quantum Architecture + QNLP

Sat, 04/13/2024 - 11:20pm

Article URL: https://arxiv.org/abs/2307.08191

Comments URL: https://news.ycombinator.com/item?id=40028369

Points: 1

# Comments: 1

Categories: Hacker News

Show HN: Codepilot – The Ultimate SaaS Starter Kit

Sat, 04/13/2024 - 11:18pm

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

Categories: Hacker News

Implementing an SHA Transformer by Hand

Sat, 04/13/2024 - 11:11pm

Article URL: https://andrew.gr/stories/sha/

Comments URL: https://news.ycombinator.com/item?id=40028340

Points: 2

# Comments: 0

Categories: Hacker News

Making Truth Social Comply with the AGPL

Sat, 04/13/2024 - 11:10pm

Article URL: https://boehs.org/node/truth-social

Comments URL: https://news.ycombinator.com/item?id=40028338

Points: 89

# Comments: 5

Categories: Hacker News

Show HN: One Billion Rows in CUDA

Sat, 04/13/2024 - 11:07pm
Categories: Hacker News

Pages