Best of Database — 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
DEV·2y
Guide To Choose A Database For Your Next Design
Guide to choosing the right database for your next design. Discusses the differences between relational and non-relational databases, their features and drawbacks, and provides guidance on choosing the appropriate database for specific requirements.
- 5
Community Picks·2y
The BEST Tool to Structure Golang Projects
The post discusses the topic of Go project structure and project layout. It mentions that there isn't a clear guide on how to structure Golang projects and introduces the go blueprint project as a solution. Go blueprint is a CLI tool that helps users spin up a Go project with a corresponding structure seamlessly.
- 6
Mastering SQL: Comprehensive Guide To Structured Query Language
This post provides a comprehensive guide to SQL, covering topics such as basic queries, filtering data, sorting data, aggregate functions, grouping data, joins, subqueries, views, indexing, transactions, stored procedures, backup and recovery, and SQL dialects.
- 7
Medium·2y
PRISMA 101 : A beginner’s guide to understand prisma.
Prisma is a powerful ORM that enhances the developer experience when working with databases in Node.js and TypeScript. It simplifies database management, provides type-safe queries, automates migrations, and offers a user-friendly interface.
- 8
Theo - t3․gg·2yCool Tools I’ve Been Using Lately
The author discusses various tools they have been using lately, including drizzle as an alternative to Prisma, Superhuman for email management, Synology DiskStation for storage and server purposes, Rectangle for window management, Pretty TS errors for better error messages, post Hog for analytics, and Arq as a browser.
- 9
How YouTube Was Able to Support 2.49 Billion Users With MySQL
YouTube used the Vitess MySQL combination to support 2.49 billion users, overcoming scalability issues. Vitess provides an abstraction layer on top of MySQL for simplicity and scalability, using components like VTGate, VTTablet, and a key-value database.
- 10
Python in Plain English·2y
POS (Point of Sale) System in PHP with Free Source Code and UML Diagrams
POS System in PHP with Free Source Code and UML Diagrams. This post provides information about a Point of Sale system in PHP, its features, and the availability of free source code and UML diagrams for download.
- 11
Does Laravel Scale?
Laravel is a fantastic choice for the majority of web applications, but there are limitations to scaling it for hyper-scale. Database, cache, and session management are important considerations. Writing consistent queries, offloading functionality when necessary, and caching expensive queries can help optimize performance. Code should be designed with scalability in mind, and AWS service limits should be taken into account. With the right infrastructure and services, Laravel can handle large projects.
- 12
- 13
LogRocket·2y
Caching in Next.js with unstable_cache
Learn how to cache data in Next.js using the unstable_cache method. Compare Next.js cache method with React cache method. Discover the benefits of unstable_cache for granular control over cache invalidation. Explore different caching strategies in Next.js.
- 14
- 15
How Pinterest Scaled to 11 Million Users With Only 6 Engineers
Learn about Pinterest's journey of scaling to 11 million users with only 6 engineers, including the four phases of their evolution, their core technologies for scalability, the choice between clustering and sharding, and the drawbacks and solutions of sharding.
- 16
- 17
- 18
Lobsters·2yDatabase Design for Google Calendar: a tutorial
This post provides a tutorial on how to design the database tables for a Google Calendar clone. It introduces the approach used in the book 'Database Design using Minimal Modeling' and is aimed at helping readers understand the process of designing a database.
- 19
- 20
TigerData (Creators of TimescaleDB)·2y
How to Collapse Your Stack Using PostgreSQL for Everything
The post discusses the concept of collapsing your stack by using PostgreSQL for multiple use cases. It highlights the challenges of stack sprawl with multiple databases and emphasizes the benefits of simplicity and using PostgreSQL for various workload types.
- 21
Daily Dose of Data Science | Avi Chawla | Substack·2y
Grouping Sets, Rollup and Cube in SQL
This post discusses three lesser-known grouping operations in SQL: Grouping Sets, Rollup, and Cube. These operations allow for efficient multiple aggregations on the same table, generating subtotals, grand totals, and all possible combinations of aggregations. The order is important in ROLLUP, and CUBE creates a result set with all possible combinations.
- 22
Towards AI·2y
What are Vector Databases?
Vector databases are designed specifically for storing vector embeddings and enhance operations such as semantic search, recommendation engines, and advanced AI/ML processes. They leverage similarity metrics for data retrieval and offer benefits like scalability, flexibility, ultra-low latency, high performance, and optimized storage and memory.
- 23
- 24
Get SQL-Server Stored Procedures with C#
Learn how to get SQL-Server stored procedures with C# using Microsoft Visual Studio 2022 and .NET 8 Framework. Explore the benefits of using stored procedures in C# and the required tools. Save stored procedure definitions to files for syntax coloring and easy access.
- 25
