Entity inheritance You can reduce duplication in your code by using entity inheritance. For example, you have Photo, Question, Post entities: As you can see all those entities have common columns: id, title, description. To reduce duplication and produce a better abstraction we can create a base class called Content for them: All columns (relations, embeds, etc.) from parent entities (parent can extend other…
simple-json column type There is a special column type called simple-json which can store any values which can be stored in database via JSON.stringify. Very useful when you do not have json type in your database and you want to store and load object without any hassle. For example: Will be stored in a single database column as {"name":"John","nickname":"Malkovich"} value.…
Creating entities and tables using decorators in TypeORM is a fundamental aspect of defining your data model and database schema. TypeORM is an Object-Relational Mapping (ORM) library that enables you to define your database structure using TypeScript classes and decorators, making it easier to work with databases in a more object-oriented manner. Here’s how you…
Data warehousing is a process and architecture for collecting, storing, and managing data from various sources to facilitate business analysis, reporting, and decision-making. Data warehouses are optimized for query performance and reporting rather than transactional processing, making them suitable for complex analytical queries. While MySQL is often used as a relational database management system, data…
Replication in MySQL: Replication in MySQL is a process that allows you to create and maintain multiple copies (replicas) of a database to ensure data redundancy, improve data availability, and distribute the workload among different servers. In a typical replication setup, one server acts as the master while one or more servers act as replicas.…
Partitioning in MySQL is a database optimization technique that involves splitting a large table into smaller, more manageable pieces called partitions. Each partition is stored separately and can have its own storage characteristics, indexes, and data storage locations. Partitioning can improve query performance, data management, and maintenance for large datasets. Here’s how partitioning works in…
Performance tuning in SQL involves optimizing the performance of database queries and operations to ensure that they run efficiently, consume fewer resources, and produce results quickly. The goal of performance tuning is to improve the overall responsiveness and scalability of a database system. It’s an iterative process that involves identifying bottlenecks, analyzing query execution, and…
Using the * wildcard and selecting specific columns in SQL queries each has its own advantages and disadvantages. Let’s explore both approaches: Advantages of using * (Wildcard): Disadvantages of using * (Wildcard): Advantages of Selecting Specific Columns: Disadvantages of Selecting Specific Columns: In summary, using * can be convenient for quick queries but might lead…
Dolor sit amet, adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Good draw knew bred ham busy his hour. Ask agreed answer rather joy nature admire.
