Monday, March 23, 2026

Day 81 of Year 3
Day 812 overall since Jan 1, 2024

💻 nhcarrigan-mentorship:
• Set up Prisma and modeled my first database table
• Took another step toward building a structured backend
• Seeing the foundation come together piece by piece

From schema to structure — this is where backend systems begin to take shape. ⚙️

#JavaScript #BackendDevelopment #PrismaORM #DatabaseDesign #NodeJS #SoftwareEngineering #CodingProgress #100DaysOfCode

Software developer Petar Ivanov from the T-Shaped Dev blog shares a checklist of things one should go through mentally while working on a new database design, and when tuning a database due to performance issues.

"Database Design Doesn't Start With Table. It Starts With Consequences"

https://thetshaped.dev/p/database-design-foundations-backend-engineers-mistakes-and-lessons

#programming #sql #postgresql #databasedesign

Join Lætitia Avrot at PG DATA 2026 for three hands-on database design trainings!

Cover fundamentals, build conceptual & logical models, and practice implementing physical models with real examples.

🎓 Trainings are included with your PG DATA 2026 ticket - at no extra cost!

Reserve your spot: https://lnkd.in/g5QaxP2v

#PGData #PGData2026 #PostgreSQL 🐘 #DatabaseDesign #DBATraining #SQL #DataModeling #OpenSource #TechLearning #HandsOnTraining #DevCommunity

"Design Me a Highly Resilient Database"

https://nikogura.com/DatabaseDesign.html

#HackerNews #Design #Resilient #Database #DatabaseDesign #DataArchitecture #TechInnovation

I'm an engineer and garage tinkerer from a country where the internet is slowly being boxed in. Structured forums — those quiet, organized places where we used to share deep knowledge — are dying. Replaced by chats and algorithm-driven feeds.

So I wrote a kind of manifesto. A proposal for a decentralized, minimalist database standard for text-based communities. Something that outlives platforms, servers, and owners.

I'm here to find people who still believe in forums. Let's talk. 🧵👇 (continued in thread) #Decentralization #Forum #DatabaseDesign

Để AI thiết kế database "thông minh" hơn, FluxStack đã tích hợp thêm lớp RAG (Retrieval-Augmented Generation) thay vì chỉ dựa vào kiến thức chung của LLM.

Cụ thể:
- Sử dụng pgvector trong Postgres để lưu trữ và tìm kiếm vector.
- Khi có yêu cầu, AI sẽ tìm kiếm các mẫu schema thực tế (SaaS, E-commerce...) trong database để tham khảo.
- Kết quả là các schema chuyên sâu, sát với thực tế thay vì các câu lệnh SQL chung chung.

#AI #DatabaseDesign #RAG #Postgres #FluxStack #CongNghe #LapTrinh

https:

My newest video is out on the @phparch #youtube channel. I go over how you can use #database #views to reduce bugs and make your code more maintainable. I also discuss #materialized views, which aren't supported by all #RDMS but are really cool and can be "faked" using other methods.

#phpc #php #postgresql #mysql #softwareengineering #databasedesign

https://youtu.be/oSVbqJ9M8QU

#CaseStudy - the Man Group moved from managing one of Europe's largest MongoDB clusters to a truly #serverless architecture with #ArcticDB - no more chasing space, no more annoying upgrades - just a software library connecting directly to S3.

How do you build a high-performance database without a server? Alex Seaton breaks down the hard-won lessons from the transition:
• Clock drift is real
• Sometimes you have to redesign from scratch
• CRDTs are useful but very subtle things

🎬 Watch the #InfoQ video and dive into the full architecture behind this shift ⇨ https://bit.ly/3Z9AiwX

📄 #transcript included

#DataEngineering #Database #DatabaseDesign #CRDTs #Python