home.social

#databasedesign — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #databasedesign, aggregated by home.social.

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

    jaswalaryan.space/article/back

    #BackendDevelopment #WebDevelopment #APIDesign #SoftwareEngineering #SystemArchitecture #DatabaseDesign #Caching #Security #PerformanceOptimization #DevOps #Scalability #CodeQuality #Programming

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

    jaswalaryan.space/article/back

    #BackendDevelopment #WebDevelopment #APIDesign #SoftwareEngineering #SystemArchitecture #DatabaseDesign #Caching #Security #PerformanceOptimization #DevOps #Scalability #CodeQuality #Programming

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

    jaswalaryan.space/article/back

    #BackendDevelopment #WebDevelopment #APIDesign #SoftwareEngineering #SystemArchitecture #DatabaseDesign #Caching #Security #PerformanceOptimization #DevOps #Scalability #CodeQuality #Programming

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

    jaswalaryan.space/article/back

    #BackendDevelopment #WebDevelopment #APIDesign #SoftwareEngineering #SystemArchitecture #DatabaseDesign #Caching #Security #PerformanceOptimization #DevOps #Scalability #CodeQuality #Programming

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

    thetshaped.dev/p/database-desi

    #programming #sql #postgresql #databasedesign

  6. 🤡 "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 🚨.
    nikogura.com/DatabaseDesign.ht #DesignMeAHighlyResilientDatabase #NoContextInterview #TechStruggles #EpicTale #DatabaseDesign #HackerNews #ngated

  7. 🤡 "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 🚨.
    nikogura.com/DatabaseDesign.ht #DesignMeAHighlyResilientDatabase #NoContextInterview #TechStruggles #EpicTale #DatabaseDesign #HackerNews #ngated

  8. 🤡 "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 🚨.
    nikogura.com/DatabaseDesign.ht #DesignMeAHighlyResilientDatabase #NoContextInterview #TechStruggles #EpicTale #DatabaseDesign #HackerNews #ngated

  9. 🤡 "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 🚨.
    nikogura.com/DatabaseDesign.ht #DesignMeAHighlyResilientDatabase #NoContextInterview #TechStruggles #EpicTale #DatabaseDesign #HackerNews #ngated

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

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

    youtu.be/oSVbqJ9M8QU

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

    youtu.be/oSVbqJ9M8QU

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

    youtu.be/oSVbqJ9M8QU

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

    youtu.be/oSVbqJ9M8QU

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

    youtu.be/oSVbqJ9M8QU

  16. #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 ⇨ bit.ly/3Z9AiwX

    📄 #transcript included

    #DataEngineering #Database #DatabaseDesign #CRDTs #Python

  17. #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 ⇨ bit.ly/3Z9AiwX

    📄 #transcript included

    #DataEngineering #Database #DatabaseDesign #CRDTs #Python

  18. #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 ⇨ bit.ly/3Z9AiwX

    📄 #transcript included

    #DataEngineering #Database #DatabaseDesign #CRDTs #Python

  19. #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 ⇨ bit.ly/3Z9AiwX

    📄 #transcript included

    #DataEngineering #Database #DatabaseDesign #CRDTs #Python

  20. - the Man Group moved from managing one of Europe's largest MongoDB clusters to a truly architecture with - 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 video and dive into the full architecture behind this shift ⇨ bit.ly/3Z9AiwX

    📄 included

  21. Senior engineers kill startups by normalizing everything. Learn when to use aggregate thinking with JSONB instead of splitting domains into tables. hackernoon.com/when-proper-dat #databasedesign

  22. Phát triển ERD Editor phiên bản 1 bằng React Flow – cho phép tạo bảng, định nghĩa cột và xem cấu trúc trực quan. Giao diện còn đơn giản nhưng đang được cải thiện từng bước. #ERD #DatabaseDesign #ReactFlow #SaaS #Developer #ThiếtKếCơSởDữLiệu #LậpTrình #CôngCụPhátTriển

    reddit.com/r/SaaS/comments/1q4

  23. 🎩✨ 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. 🧙‍♂️🗃️
    prisma.io/dataguide/types/rela #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated

  24. 🎩✨ 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. 🧙‍♂️🗃️
    prisma.io/dataguide/types/rela #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated

  25. 🎩✨ 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. 🧙‍♂️🗃️
    prisma.io/dataguide/types/rela #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated

  26. 🎩✨ 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. 🧙‍♂️🗃️
    prisma.io/dataguide/types/rela #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated

  27. 🚀 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. 🎊
    jellyfin.org/posts/SQLite-lock #Concurrency #DatabaseDesign #AppReviews #HackerNews #ngated

  28. Tôi đang kỹ thuật):如何設計一個搜索庫存200,000 PDF trangkí trên 128GB trạng xác? Gợi ý công cụ, cấu trúc dữ liệu, và kiến trúc tìm kiếm khôngाने? Mục tiêu: Cần truy cập أدري online với máy tính thông dụng 20 năm sau.

    #Verbatim #PDF #DataArchiving #OfflineSearch #TechSolutions #VietnamTech #DatabaseDesign

    *(397 ký tự)*

    Archive.org

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

  30. 🔧 Database tweaks done: no more min date fails, foreign keys now map RuleType properly. Smooth inserts, solid audit logging. #DatabaseDesign #LegalTech

  31. 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. 🍝👀
    app.chartdb.io #cuttingedgetechnology #cloudcomputing #databasedesign #spaghetti-diagrams #techhumor #HackerNews #ngated

  32. 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. 🍝👀
    app.chartdb.io #cuttingedgetechnology #cloudcomputing #databasedesign #spaghetti-diagrams #techhumor #HackerNews #ngated

  33. 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. 🍝👀
    app.chartdb.io #cuttingedgetechnology #cloudcomputing #databasedesign #spaghetti-diagrams #techhumor #HackerNews #ngated