Best of Database — November 2023
- 1
- 2
Community Picks·2y
Advanced Transaction Management with NestJS & TypeORM
This article explores advanced transaction management techniques in NestJS and TypeORM. It covers the basics of transactions, different ways of implementing transactions, and a step-by-step guide to implementing advanced transaction management using interceptors, request-scoped repositories, and custom decorators. The article provides code examples and highlights the benefits of using transactions in database operations.
- 3
- 4
- 5
What is Redis and Why is it used by leading industries?
Redis is a high-performance data-structure store that uses key-value pairs and is used by leading industries for caching, real-time updates, and more. It offers features like in-memory storage, advanced data structures, persistence, replication, and huge support. Industries like social media, gaming, Q&A platforms, online delivery, and more use Redis for caching, leaderboards, real-time analytics, machine learning, and message brokering. Redis should be used alongside other databases, has alternatives like Memcached, MongoDB, RabbitMQ, and Cassandra, and may not be suitable as a sole transactional database or relational database.
- 6
System Design Pastebin
Pastebin is an online text storage service that allows clients to store and share code snippets or configuration files. It generates a unique paste ID for each paste, which clients can use to access the content. The system uses a combination of SQL database and object storage to store metadata and content, and employs caching to improve latency. The system also includes rate limiting, encryption, and content filtering features.
- 7
Towards Data Science·2y
System Design Cheatsheets: ElasticSearch
ElasticSearch is a powerful search engine that excels at performing full-text searches on large datasets. It can be used as a secondary database for full-text search operations, a real-time data analysis pipeline, or a recommendations system. However, ElasticSearch is not suitable for ACID compliance, complex joins, or small datasets with simple query needs. When using ElasticSearch in system design, consider its distributed architecture, scalability, document-based data modeling, real-time data analysis capabilities, and cost implications.
- 8
- 9
I Will Fucking Dropkick You If You Use That Spreadsheet — Ludicity
The author strongly opposes using spreadsheets in automated processes and offers alternatives like databases and coding. They find the use of spreadsheets unreasonable and are willing to provide professional help to those who seek alternatives.
- 10
Laravel News·2y
Generate Validation Rules from a Database Schema in Laravel
Generate Validation Rules from a Database Schema in Laravel using the Laravel Schema Rules package. This package automatically generates basic Laravel validation rules based on your database table schema. It provides options to generate rules for specific columns, skip columns, and even generate a form request class. You can also try out the online version of the package to manually convert a schema to an array of validation rules.
- 11
TigerData (Creators of TimescaleDB)·3y
How We Scaled PostgreSQL to 350 TB+ (With 10B New Records/Day)
Insights is a tool in the Timescale platform that allows users to analyze their query performance. They collected query information by instrumenting the databases and storing the records in a single Timescale service. They faced challenges in ingesting and querying large amounts of data, and storing hundreds of TBs in a single Timescale service. Despite the challenges, TimescaleDB proved to be scalable and efficient.
- 12
Code Like A Girl·2y
SQL’s Order of Execution
Understanding the order of execution in SQL queries is crucial for optimizing performance and obtaining accurate results. The logical order of execution includes clauses like FROM, WHERE, GROUP BY, SELECT, and ORDER BY, while the physical order can be influenced by indexing, query optimization, and storage structures. Subqueries can be integrated into the SQL execution flow and impact query processing. Different databases may have variations in the execution order due to optimization strategies. When writing efficient SQL queries, consider factors like indexing, limiting the use of SELECT *, and optimizing JOIN operations. The database engine can change the order of execution through query optimization, utilizing techniques like cost-based optimization, index usage, and parallel processing. Troubleshooting issues related to the execution order involves understanding the logical flow, examining the query execution plan, checking index usage, profiling the query, and optimizing conditions in the WHERE clause.
- 13
DevBlogs·3y
Entity Framework Core 8 (EF8) is available today
Entity Framework Core 8 (EF8) is now available on NuGet. EF8 introduces major enhancements including support for value objects using Complex Types and improvements in JSON column mapping. It aligns with .NET 8 as a long-term support (LTS) release.
- 14
