#database-design tag

Business intelligence

10 Database Design Tools to Visualize & Build Data Models in 2025

Selecting the correct database design tool is crucial for effective management and efficiency.

fromHackernoon

1 year ago

JavaScript

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.

fromSitePoint Forums | Web Development & Design Community

4 months ago

Miscellaneous

Select data from a joined table with the newest date

By using a single query with JOIN and GROUP BY in MySQL, you can fetch current data and latest updates efficiently.

fromSitePoint Forums | Web Development & Design Community

6 months ago

Miscellaneous

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.

fromClickUp

2 weeks ago

Business intelligence

10 Database Design Tools to Visualize & Build Data Models in 2025

Selecting the correct database design tool is crucial for effective management and efficiency.

fromHackernoon

1 year ago

JavaScript

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.

fromSitePoint Forums | Web Development & Design Community

4 months ago

Miscellaneous

Select data from a joined table with the newest date

By using a single query with JOIN and GROUP BY in MySQL, you can fetch current data and latest updates efficiently.

fromSitePoint Forums | Web Development & Design Community

6 months ago

Miscellaneous

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.

more#data-management

fromInfoWorld

2 months ago

JavaScript

Keep your code open to possibilities

Prioritize abstraction in design to ensure flexibility in database and technology choices, allowing for adaptability as project needs evolve.

fromSitePoint Forums | Web Development & Design Community

6 months ago

Data science

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

6 months ago

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

8 months ago

JavaScript

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).

#database-design#database-design

10 Database Design Tools to Visualize & Build Data Models in 2025

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

Select data from a joined table with the newest date

Help with database design for personal project

10 Database Design Tools to Visualize & Build Data Models in 2025

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

Select data from a joined table with the newest date

Help with database design for personal project

Keep your code open to possibilities

Help with database design for personal project

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

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

#database-design
#database-design