Hacker News with Generative AI: Data Modeling

Just Throw It into Postgres (simonsafar.com)
When you think of databases... it probably looks like a neatly organized schema of multiple tables, having unique ids connecting them, neatly listing names, addresses and other well-defined entities. It's either something corporate, or... maybe a PHP webapp? A forum?

Databases, Data Modeling, Programming

7 points by todsacerdoti 9 days ago | 0 comments

Postgres to ClickHouse: Data Modeling Tips V2 (clickhouse.com)
It is becoming increasingly common for customers to use Postgres and ClickHouse together, with Postgres powering transactional workloads and ClickHouse powering analytics.

Databases, Data Modeling, ClickHouse, Postgres

3 points by saisrirampur 39 days ago | 0 comments

Historically, 4NF explanations are needlessly confusing (minimalmodeling.substack.com)
Historically, 4NF explanations are needlessly confusing

Databases, Data Modeling, 4NF

104 points by thunderbong 140 days ago | 65 comments

Data Modeling with Sums and Products (funktionale-programmierung.de)
Data Modeling is often an underappreciated aspect of software architecture, yet it plays a crucial role in achieving not only functional but also usability and maintainability goals.

Data Modeling, Software Architecture, Programming

54 points by markusschlegel 151 days ago | 20 comments

Show HN: TypeSchema – A JSON specification to describe data models (typeschema.org)
TypeSchema is a JSON specification to describe data models.

JSON, Data Modeling, Specifications, Open Source, Show HN

117 points by k42b3 184 days ago | 49 comments

Reinventing Core Data Development with SwiftData Principles – Fatbobman's Blog (fatbobman.com)
In modern application development, an efficient persistence framework is crucial. The emergence of SwiftData once caught the eyes of many Core Data developers, who anticipated the advent of a new era integrating modern programming concepts. This article will explore how to apply SwiftData’s way of thinking within Core Data, focusing on data modeling and concurrent programming.

SwiftData, Core Data, iOS Development, Programming, Data Modeling

3 points by tambourine_man 192 days ago | 0 comments

Google Zanzibar: Implementing the Check API and Expand API Using .NET (2023) (bytefish.de)
In the previous articles we have seen how to implement a very simplified Relationship-based Access Control using a Google Zanzibar-like data model and some SQL queries. It worked good, and I quite like what we ended up with. But it doesn't let us define an effictive ACL, because at the moment we need to materialize all relations in the database.

.NET, Google Zanzibar, Access Control, Data Modeling, SQL

31 points by bytefish 216 days ago | 5 comments

ClickHouse Data Modeling for Postgres Users (clickhouse.com)
Last month, we acquired PeerDB, a company that specializes in Postgres CDC. PeerDB makes it fast and simple to replicate data from Postgres to ClickHouse. A common question from PeerDB users is how to model their data in ClickHouse after the replication process to maximize the benefits of ClickHouse.

ClickHouse, Databases, Postgres, Data Modeling, Data Replication

80 points by saisrirampur 228 days ago | 9 comments

Data Modeling SaaS Entitlements and Pricing (garrettdimon.com)

Data Modeling, SaaS, Pricing

51 points by jnunemaker 247 days ago | 2 comments

From Trees to Tables: Storing Hierarchical Data in Relational Databases (medium.com)