#database-design

[ follow ]
#data-management

How to Build a Database From Scratch: Understanding LSM Trees and Storage Engines (Part 1) | HackerNoon

Building a database from scratch enhances understanding of database design and functionality.

Help with database design for personal project

Normalization in databases can be approached with either strings or lookup tables, with considerations for efficiency and database size.

How to Build a Database From Scratch: Understanding LSM Trees and Storage Engines (Part 1) | HackerNoon

Building a database from scratch enhances understanding of database design and functionality.

Help with database design for personal project

Normalization in databases can be approached with either strings or lookup tables, with considerations for efficiency and database size.
moredata-management

Help with database design for personal project

Effective database normalization is crucial for managing JSON data.
Creating separate tables for locations and car details will reduce redundancy.
Linking towns to counties improves data integrity.
Indexing important columns will enhance query performance.

API with NestJS #170. Polymorphic associations with PostgreSQL and Drizzle ORM

Polymorphic associations optimize database design by allowing a single comment table to relate to multiple types of content without redundancy.

Designing Database Diagrams Effortlessly with Open-Source ERDL Language | HackerNoon

DatabaseDiagram.com simplifies database schema visualization with an intuitive, keyboard-friendly design tool.

API with NestJS #161. Generated columns with the Drizzle ORM and PostgreSQL

SQL generated columns help with data consistency, query performance, and database design. Two types: virtual (not supported in PostgreSQL) and stored (updated on row modification).
#data-integrity

API with NestJS #146. Polymorphic associations with PostgreSQL and Prisma

Polymorphic association allows one table to be associated with multiple types of tables.
Avoid duplicating logic by using a single table with polymorphic associations for different entities.

API with NestJS #150. One-to-one relationships with the Drizzle ORM

Managing relationships in databases, especially one-to-one connections, is crucial for structuring data efficiently.

API with NestJS #146. Polymorphic associations with PostgreSQL and Prisma

Polymorphic association allows one table to be associated with multiple types of tables.
Avoid duplicating logic by using a single table with polymorphic associations for different entities.

API with NestJS #150. One-to-one relationships with the Drizzle ORM

Managing relationships in databases, especially one-to-one connections, is crucial for structuring data efficiently.
moredata-integrity
[ Load more ]