Best of DatabaseMarch 2023

  1. 1
    Article
    Avatar of gcgitconnected·3y

    System Design Master Template: How to Answer Any System Design Interview Question.

    System Design Master Template: How to Answer Any System Design Interview Question. The two biggest challenges of answering a system design interview question are: To know where to start. Arslan Ahmad: Have a look at the top image to understand the major components that could be part of any system design.

  2. 2
    Article
    Avatar of devgeniusDev Genius·3y

    SOLID principles in Reactjs

    SOLID principles in ReactJS are a set of five principles aimed at making software design maintainable, scalable and easy to modify. These principles can be applied to any object-oriented programming language, including ReactJS. In this blog post, we’ll discuss the importance of the SOLID Principles in React JS and how they can improve your code.

  3. 3
    Article
    Avatar of codemotionCodemotion·3y

    What Are Microservices Design Patterns?

    Microservice architecture is an organizational approach to software development where the programmer has to use a collection of small autonomous services. As autonomous services, they are able to complete certain functions independently from other services with which it interacts. Microservices use two types of load-balancing architecture, and these are server-side load balancing.

  4. 4
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP 51: How does DNS work?

    This week's system design briefer: How does DNS work? How Discord Stores Trillions Of Messages Silicon Valley Bank (SVB) collapse. What’s new in GPT-4 AI is evolving at a scary pace. Join the ByteByteGo Talent Collective for customized job offerings.

  5. 5
    Article
    Avatar of bartwullemsThe Art of Simplicity·3y

    Data API Builder

    Data API builder for Azure Databases(DAB) is a small application where you only need an API to expose some data. With data API builder, database objects can be exposed via REST or GraphQL endpoints so that your data can be accessed using modern techniques on any platform.

  6. 6
    Article
    Avatar of amplicationAmplication·3y

    4 Common Mistakes Made by Node.js Developers

    The growth of Node.js is tremendous, it has a rich packages ecosystem, it’s battle-tested and the usage of JavaScript allows businesses to go full-stack and cut the development lifecycle short.

  7. 7
    Article
    Avatar of codemagiccodemagic·3y

    Clean architecture explored

    Clean architecture explored by Jahswill Essien and Robert Martin. Clean architecture was proposed by Robert C Martin and relies heavily on the SOLID principles. It follows the principle of the design principle by introducing four layers of design. Separation of concerns is introduced by introducing distinct layers of concerns.

  8. 8
    Article
    Avatar of communityCommunity Picks·3y

    Redis: The Precious of the Software World

    Redis is an in-memory data structure store that can be used as a database, cache, and message broker. It provides high performance, flexibility, and wide language support. Redis offers persistence options such as RDB and AOF. Scaling options include single Redis instance, Redis Sentinel, and Redis Cluster.

  9. 9
    Article
    Avatar of bytebytegoByteByteGo·3y

    From 0 to Millions: A Guide to Scaling Your App - Final Part

    As traffic continues to scale, the modern application stack will start to run into issues. As traffic grows, the combined read and write traffic could start to overwhelm the serverless database. The first place that could break is the database tier. For a read-heavy application, we should consider migrating the read load to read replicas.

  10. 10
    Article
    Avatar of gcgitconnected·3y

    Master the Art of Caching for System Design Interviews: A Complete Guide

    Master the Art of Caching for System Design Interviews: A Complete Guide A Comprehensive Caching Guide for Acing System Design interviews. Caching is an essential technique used in software engineering to improve system performance and user experience. In-memory caching stores data in the main memory of the computer, which is faster than disk storage.

  11. 11
    Article
    Avatar of medium_jsMedium·3y

    Interview questions related to optimizing application performance in Node JS

    Interview questions related to optimizing application performance in NodeJS are part of a set of interview questions. The questions will test the candidate’s knowledge of NodeJS and their ability to optimize performance in a range of scenarios, making it a valuable resource for companies looking to hire skilled NodeJS developers.

  12. 12
    Article
    Avatar of medium_jsMedium·3y

    Designing a Fault-Tolerant Web Application: Building a Highly Available 3-Tier Architecture

    A 3-tier architecture is a type of software architecture that is commonly used to develop web-based applications. The architecture consists of three layers or tiers, each responsible for different functions. The three tiers are interconnected and communicate with each other through well-defined interfaces.

  13. 13
    Article
    Avatar of planetscalePlanetScale·3y

    How to read MySQL EXPLAINs

    Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.

  14. 14
    Article
    Avatar of kdnuggetsKDnuggets·3y

    SQL Query Optimization Techniques

    Learn how to optimize SQL queries for faster and more memory efficient execution. Topics include using EXIST() instead of COUNT(), using varchar instead of char, avoiding subqueries in WHERE clause, ordering JOINs from a larger table to a smaller table, and using regexp_like instead of LIKE clause.

  15. 15
    Article
    Avatar of communityCommunity Picks·3y

    MongoDB - The Leading NoSQL Database

    MongoDB is a popular NoSQL database that allows for flexible data management and rapid backend development. It follows a document-oriented structure and is highly scalable and performant.

  16. 16
    Article
    Avatar of changelogChangelog·3y

    Mathesar

    Mathesar is an open source and web-based interface that allows users to easily access and manipulate their databases without requiring technical skills.

  17. 17
    Article
    Avatar of sqlshackSQL Shack·3y

    PostgreSQL vs MySQL: Understanding their differences

    Compare PostgreSQL and MySQL database systems based on their differences, ownership, programming language, supported data types, ACID compliance, troubleshooting approach, and suitability for web-based applications.

  18. 18
    Article
    Avatar of colkgirlCode Like A Girl·3y

    Structured Project Code Repository

    Structured code can be achieved through the use of various programming concepts and tools, such as modules, classes, functions, and namespaces. A well-structured codebase can be more scalable and reusable, allowing developers to build more complex applications with less effort and fewer errors.

  19. 19
    Article
    Avatar of reflectoringReflectoring·3y

    Build CRUD APIs Using Apollo Server(Graphql), MongoDB and Node.Js

    GraphQL allows clients to define the structure of the data to be returned by the server, as well as allowing multiple resource requests in a single query call. It’s like when a teacher keeps a class register with detailed information about each student, such as their name, age, favorite color, etc.

  20. 20
    Article
    Avatar of lnLaravel News·3y

    MySQL for Developers Course is Live

    The MySQL for Developers course by Aaron Francis is now live. It is a free course consisting of over 7 hours and 64 videos covering various key topics. No previous database experience is required. Check out the course on the PlanetScale website.

  21. 21
    Article
    Avatar of awstipAWS Tip·3y

    A guide to Creating a Three-Tier Architecture on AWS

    A guide to creating a three-tier architecture on AWS, including an explanation of each tier and their benefits.

  22. 22
    Article
    Avatar of crunchydataCrunchy Data·3y

    Is your Postgres ready for production?

    Is your database ready for production? Here's a handy checklist to make sure you're not caught flat footed. Logical backups are great if you want to move data around between environments or need a local copy. Physical backups are a combination of a base backup and the write-ahead-log or WAL.

  23. 23
    Article
    Avatar of lnLaravel News·3y

    Replace Raw Query Calls With Laravel Query Expressions

    The Query Expressions package for Laravel replaces raw query calls with expressions. The package builds on new features introduced in Laravel 10 to solve that problem. If you'd like to learn more about this package, check out laravel-query-expressions on GitHub.

  24. 24
    Article
    Avatar of foojayioFoojay.io·3y

    5 Great Reasons to use jOOQ

    JOOQ is an internal domain-specific language (DSL) modelling the SQL language as an API directly in Java. This provides compile-time type safety to your query and enables a lot of other interesting features that I'll show later. JOOQ's code generator also generates stubs for your stored procedures.