Best of Hacker News — May 2024
- 1
- 2
Hacker News·2y
Making a Postgres query 1,000 times faster
The author shares their journey of optimizing a Postgres query to make it 1,000 times faster. They discovered that the query was taking longer and longer each time it was executed due to processing all rows in the table and the use of a filter instead of an index condition. By using row constructor comparisons, they were able to significantly improve the query performance.
- 3
- 4
- 5
- 6
- 7
- 8
MHNightCat/superfile: Pretty fancy and modern terminal file manager
Superfile is a fancy and modern terminal file manager. It supports multiple systems, and you can install it by using Homebrew or downloading the binary file. You can customize the theme in superfile by editing the config.json file.
- 9
- 10
- 11
- 12
Old Dogs, new CSS Tricks
New CSS features have been shipped in recent years, but their adoption remains slow due to various factors, including browser support, lack of urgency, and changing design trends. To overcome the habit of sticking to old CSS patterns, it is important to rethink established patterns, experiment with new techniques in safe environments, and find inspiration from best practices in real-life projects.
- 13
How Might We Learn?
The post discusses the ideal learning environment and the patterns observed in rewarding high-growth periods. It explores the conflict between implicit learning and guided learning and proposes a synthesis of the two approaches. The post also introduces the concept of AI-based learning support and how it can be integrated into authentic learning contexts.
- 14
- 15
tembo-io/pgmq: A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
PGMQ is a lightweight message queue built on Postgres. It guarantees exactly once delivery of messages within a visibility timeout and offers API parity with AWS SQS and RSMQ. It provides features like message archiving and tables can be partitioned for efficient management. You can try PGMQ for free using the Tembo docker image.
- 16
Clean Up Your Gmail and Reclaim Your Inbox with InboxPurge
Clean up your Gmail and regain control of your inbox with InboxPurge. Unsubscribe, delete, and block all within your Gmail. Say goodbye to tedious unsubscribe processes. Bulk delete cluttered inboxes in seconds. Your emails and personal data remain private. Elevate your productivity and spend less time on email management. Streamlined email management experience within your Gmail.
- 17
- 18
roblillack/spot: React-like desktop GUI toolkit for Go
Spot is a simple, cross-platform, reactive GUI toolkit for Go using native widgets where available. It provides easy-to-use UI controls, automatic UI updates based on application state changes, and support for creating custom components.
- 19
- 20
mistralai/mistral-finetune
This post provides instructions on how to use the `mistral-finetune` codebase for memory-efficient and performant finetuning of Mistral's models. It also includes steps for downloading and preparing the required datasets and provides tips for avoiding CUDA out-of-memory errors.
- 21
The Worst Website In The Entire World
A post describing the author's experience with what they consider to be the worst website ever created, highlighting the user-hostile design and frustrating patterns. The author expresses their frustration with the Broadcom Support website and suggests that it should be shut down.
- 22
- 23
tegonhq/tegon: Tegon is an open-source, AI-first alternative to Jira, Linear
Tegon is an open-source, AI-first alternative to Jira and Linear. It automates manual tasks and provides context to engineers. Tegon offers a managed cloud version and integrates with Github, Slack, and Sentry. It also has plans for upcoming features like task prioritization and stack overflow references.
- 24
Openpanel-dev/openpanel: All the goodies from both Mixpanel and Plausible combined into one tool.
Openpanel is an open-source analytics tool that combines the functionalities of Mixpanel and Plausible. It allows users to visualize data with various charts, access events and visitors' history, and own their own data. Openpanel is GDPR compliant, privacy-friendly, and offers predictable pricing. It supports Nextjs for the dashboard, Fastify for the event API, Postgres for storing basic information, Clickhouse for storing events, and Redis for cache layer and pub/sub.
- 25