Lmst

I saw a post touting the virtues of using an ORM.

I threw up in my mouth a little. 🤮

#SQL
#RDBMS

Sigh. My SQL Servers often feel like NoSQL data dumpsters.

#RDBMS
#SQLServer

It's true with database design too.

#Databases
#RDBMS
#SQL

It is easier to resist at the beginning than at the end.
~Leonardo da Vinci

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…

https://blog.gslin.org/archives/2025/04/13/12341/cloudflare-workers-%e6%8f%90%e4%be%9b%e7%9a%84-mysql-mariadb-%e6%96%b9%e6%a1%88/

#cloudflare #database #db #hyperdrive #mariadb #mysql #proxy #rdbms #serverless #sql #workers

Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.

#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration

https://www.youtube.com/watch?v=Su6aUb2yM1g&t=64s

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

https://fermatslibrary.com/s/a-relational-model-of-data-for-large-shared-data-banks#email-newsletter

#RDBMS #RelationalData #datascience #databases #Codd

New problem, new library! This time, I made a small utility for Laravel to limit a group of models on the table.

https://github.com/Laragear/Capstone

I talked about the implementation on my Medium blog, but in a nutshell, it uses a subquery to keep only the records you don't want to delete, like the latest five.

#PHP #Programming #Coding #Code #Laravel #Composer #GitHub #Git #Library #Package #WebDevelopment #WebDev #SoftwareDevelopment #Software #SQL #Database #ORM #RDBMS #DB

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 年才想要支援？ …

https://blog.gslin.org/archives/2025/04/04/12331/django-5-2-%e6%94%af%e6%8f%b4-composite-primary-key/

#composite #compound #database #db #django #library #orm #pk #PrimaryKey #rdbms

Ugh. We have > 7,000 database tables with a column named [ID].

This is true, even on days not dated April 1st.

#NotJoking
#RDBMS

Here's the TSQL thing I mentioned a day or two ago: a stored procedure that performs an assessment of an existing database table.

So far, it does the following:
Checks for the presence/absence of certain criteria:
🔹A Primary Key and/or Unique Key.
🔹A clustered index.
🔹Compression (if any).
🔹Total number of rows.
🔹Create date.
🔹Columns with deprecated data types.
🔹Columns with ambiguous names.

https://codeberg.org/DaveMasonDotMe/SQL-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql

#SQLServer
#Database
#RDBMS
#TSQL

Many will tell you the leading cause of alcoholism is family history.

But they're wrong--it's poor database design.

#RDBMS
#SQL

Softr Expert certification ✅

What do you need help with? 🛟

#apps #airtable #database #databases #rdbms #data #softr #software #softwaredevelopment #webapps #webdevelopment #nocode #lowcode

Ook erg interessant was #DuckDB, een #OpenSource #RDBMS waarmee je ook razendsnel rechtstreeks op csv- en parquet-files kunt queriën. Uiteraard kun je zo'n #database ook in je #Java-project opnemen waarbij de jdbc-connectie zelf de database is. 👀

https://youtu.be/utWdNJEAG74

http://duckdb.org/

#DevWorldConference