mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Server stats:

9K
active users

#RDBMS

3 posts3 participants0 posts today

Is anyone else old enough to remember the Dark Ages when file systems limited names to the 8.3 notation?

Back then there were some database products I worked with that had similar restrictions for table names and column names, etc.

But those days are so far behind us.

I know "naming things is hard". But I cringe when I see vague, ambiguous names like "xyz".

It's 2025, folks. Go ahead and spell out XylophoneYomamaZygote so we know what your intent is.

#RDBMS
#Database

I picked Redis for my personal website storage initially because it seemed simple. Just push docs and JSON blobs in and it Just WorksTM.

Right now I'm converting to MariaDB, in case you wanna know how I feel about my original storage decision right now.

Cloudflare Workers 提供的 MySQL/MariaDB 方案

在「Build global MySQL apps using Cloudflare Workers and Hyperdrive」這邊看到 Cloudflare 提供了 Cloudflare Workers 使用 MySQL/MariaDB 的方案。 本來以為是做出了 replicated globally 的系統,還在想要怎麼處理 ACID 問題,花了點時間看完才發現是弄出了一個類似 ProxySQL 的架構,最終還是要連回某個區域的 MySQL 主機上,可能是 AWS、GCP、Azure 或是自己的 MySQL 伺服器: Now, you can create new Hyperdrive c…

blog.gslin.org/archives/2025/0

Gea-Suan Lin's BLOG · Cloudflare Workers 提供的 MySQL/MariaDB 方案在「Build global MySQL apps using Cloudflare Workers and Hyperdrive」這邊看到 Cloudflare 提供了 Cloudflare Workers 使用 MySQL/MariaDB 的方案。 本來以為是做出了 replicated globally 的系統,還在想要怎麼處理 ACID 問題,花了點時間看完才發現是弄出了一...

A Relational Model of Data for Large Shared Data Banks - E.F. Codd, 1970

* introduced a revolutionary approach to database design
* fundamentally changed how we store/access data
* rather than complex hierarchical structures, organized data into tables (relations) w. rows/columns
* manipulated through well-defined operations
...

fermatslibrary.com/s/a-relatio

Django 5.2 支援 composite primary key

看到 Django 5.2 的公告,裡面列出了比較重大的改變,其中一個注意到的是支援 Composite (Compound) Primary Key 了:「Django 5.2 released」,完整的 release notes 則是在「Django 5.2 release notes」這邊可以看到。 就是因為這些 ORM library 不支援 compsite primary key,所以才會有 best (?) practice 要求每個表格都要有 primary key,而且是單一欄位... 大家應該都習以為常了,怎麼會突然在 2025 年才想要支援? …

blog.gslin.org/archives/2025/0

Gea-Suan Lin's BLOG · Django 5.2 支援 composite primary key看到 Django 5.2 的公告,裡面列出了比較重大的改變,其中一個注意到的是支援 Composite (Compound) Primary Key 了:「Django 5.2 released」,完整的 release notes 則是在「Django 5.