#databasedesign — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databasedesign, aggregated by home.social.
-
Most devs think backend = APIs.
It’s not.
It’s:
• Efficient request handling
• Clean architecture
• Smart DB design
• Caching strategies
• Security
• Reliability under load
Great backend ≠ just code
It’s systems that don’t break in the real world.
Tools change. Principles don’t.https://jaswalaryan.space/article/backend-development-beyond-apis-complete-guide
#BackendDevelopment #WebDevelopment #APIDesign #SoftwareEngineering #SystemArchitecture #DatabaseDesign #Caching #Security #PerformanceOptimization #DevOps #Scalability #CodeQuality #Programming
-
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
-
🤡 "Design Me a Highly Resilient Database" is a riveting tale of one man's epic struggle against the dreaded No-Context Interview #Questions 🤔. Spoiler alert: He knows too much, which is apparently a crime in the tech world 🚨.
https://nikogura.com/DatabaseDesign.html #DesignMeAHighlyResilientDatabase #NoContextInterview #TechStruggles #EpicTale #DatabaseDesign #HackerNews #ngated -
"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
-
#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
-
Senior engineers kill startups by normalizing everything. Learn when to use aggregate thinking with JSONB instead of splitting domains into tables. https://hackernoon.com/when-proper-database-design-kills-startups #databasedesign
-
Most startups fail at scale because of poor database design, not buggy code. https://hackernoon.com/the-concrete-foundation-fallacy-why-your-quick-and-dirty-database-schema-is-a-ticking-time-bomb #databasedesign
-
Cải thiện tốc độ tìm kiếm email lên đến 71% với PostgreSQL Full-Text Search
Tìm kiếm email nhanh hơn 59-71% với tsvector và GIN index
Cải thiện hiệu suất tìm kiếm với trọng số và xếp hạng liên quan
#PostgreSQL #FullTextSearch #GINIndex #tsvector #TìmKiếmEmail #HiệuSuất #CảiThiện #Database #Optimization #Vietnamese #English #Tech #Technology #Programming #Developer #Software #EmailSearch #SearchEngine #DatabaseDesignhttps://dev.to/_877737de2d34ff8c6265/how-we-achieved-up-to-71-faster-email-sear
-
🎩✨ Behold the mystical "expand and contract pattern" for database schemas! Because who doesn't love a guide that turns simple schema changes into a quest for the Holy Grail? 🏰🔍 Spoiler: it's just another way to say "do it carefully," but with extra steps and a touch of #wizardry. 🧙♂️🗃️
https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated -
🚀 Breaking news: #SQLite isn't perfect! 🎉 In a shocking revelation, this article implores you to care about things like "concurrency" as if you didn't already have enough to worry about with your app's 1-star reviews. 🙄 If you survived 2025 without your world crumbling due to database design flaws, congrats, you're the real #MVP. 🎊
https://jellyfin.org/posts/SQLite-locking/ #Concurrency #DatabaseDesign #AppReviews #HackerNews #ngated -
Unveiling the latest visual for 'Data Science for the Modern Enterprise'! This one maps the crucial journey from raw data to meaningful insights, covering Database Design and Data Warehouse Design.
It's the backbone of any robust data strategy! What are the biggest challenges you've faced in designing or maintaining effective databases and data warehouses? Let's connect and share experiences! 👇
#DatabaseDesign #DataWarehouse #DataScience #DataArchitecture #SQL #ETL #OLAP #DataManagement #Tech -
🔧 Database tweaks done: no more min date fails, foreign keys now map RuleType properly. Smooth inserts, solid audit logging. #DatabaseDesign #LegalTech
-
Ah, yes, because nothing says "cutting-edge tech" like glorified doodles of your databases in the cloud. 🌥️🖍️ A revolutionary step forward for those who find the command line *too challenging* and prefer to squint at screens full of spaghetti diagrams. 🍝👀
https://app.chartdb.io #cuttingedgetechnology #cloudcomputing #databasedesign #spaghetti-diagrams #techhumor #HackerNews #ngated -
When starting with a new @couchdb #DatabaseDesign, you’ll need to consider document size and attachment size. Get them wrong… and, you’ll feel it later! 📏 💾
We’ve put together two #DataModelling tips that expand on why we recommend keeping it small.
Start with our post on attachment size:
https://neighbourhood.ie/blog/2025/02/19/couchdb-data-modelling-prefer-smaller-attachments -
🧠 SQL Mindmap & Daily Life SQL Commands for Developers 🧠
SQL (Structured Query Language) is a powerful tool used by developers to manage and manipulate databases. Whether you're querying data, updating records, or performing complex joins, SQL is essential in daily development tasks. Let’s break it down!
#SQL #SQLCommands #DatabaseManagement #DevelopersLife #TechSkills #DatabaseDesign
-
Not every query needs a primary key.
Keyless Entity Types in EF Core let you query database views, raw SQL results, and reports without requiring a unique identifier. Perfect for read-only scenarios and complex data models.
https://woodruff.dev/keyless-entity-types-in-ef-core-query-data-without-primary-keys/
