Best of Database2022

  1. 1
    Article
    Avatar of hashnodeHashnode·4y

    System Design: The complete course

    System design is one of the earliest decisions we can make when building a system. System design meets the needs of your business or organization through coherent and efficient systems. The OSI Model can be seen as a universal language for computer networking. It's based on the concept of splitting up a communication system into seven abstract layers, each one stacked upon the last.

  2. 2
    Article
    Avatar of devtoDEV·4y

    An animated guide for Node.js event loop

    Node.js is single-threaded, but what does it mean in practical terms? We will explore it by following this piece of code step by step. The V8 JavaScript engine manages a call stack, an essential piece that tracks which part of our program is running. The event loop connects the queue with the call stack.

  3. 3
    Article
    Avatar of devtoDEV·4y

    System Design: Netflix

    Netflix is a subscription-based streaming service that allows its members to watch TV shows and movies on an internet-connected device. The system should meet the following requirements: Users should be able to stream and share videos. This API will allow our users to post a comment on a video (like YouTube) The tweet service will handle video streaming-related functionality. It will be discussed in detail separately.

  4. 4
    Article
    Avatar of communityCommunity Picks·3y

    The complete guide to System Design in 2022

    System Design is the process of defining the architecture, interfaces, and data for a system that satisfies specific requirements. System design meets the needs of your business or organization through coherent and efficient systems. The complete guide to System Design Interview in 2022 is available.

  5. 5
    Article
    Avatar of anavidAnalytics Vidhya·4y

    Creating a Music Streaming Backend Like Spotify Using MongoDB

    Creating a Music Streaming Backend like Spotify using MongoDB. This article was published as a part of the Data Science Blogathon. In this article, I will show you how to handle uploading songs to the database, streaming music, user authentication, the ability to choose your favorite songs, and a recommendation engine. We will add our code in a new file named ‘auth.ts’ in a new file.ts.

  6. 6
    Article
    Avatar of faunFaun·4y

    Top 30 System Design Interview Questions and Problems for Programmers and Software Engineers

    System design is a process of defining the elements of a system such as the modules, components, various interfaces and architecture. Here are the top 20 System Design interview questions you can prepare before your next Interview. What are the Types of Documentation in System Design? What do you understand by load balancing? Why is it important in system design?

  7. 7
    Article
    Avatar of freecodecampfreeCodeCamp·4y

    Best Practices for Scaling Your Node.js REST APIs

    Use throttling at the first junction point between your application and the News Feed Service. Use the ELK stack for setting up a good logging and alerting pipeline. If a request goes through multiple services during the lifecycle, you can pass along a unique ID in the logs to capture a particular request across all the services.

  8. 8
    Article
    Avatar of phProduct Hunt·4y

    Appwrite - 100% open source alternative for Firebase

    Appwrite provides authentication, database, storage, functions, and advanced realtime capabilities.

  9. 9
    Article
    Avatar of communityCommunity Picks·4y

    Top 10 Microservices Design Patterns and Principles

    Microservice architecture is structured on the business domain and it's a collection of small autonomous services. Transaction management is the fundamental advantage of a shared database versus a per-service database. Event Sourcing is based on the idea that any change in an entity's state should be captured by the system. The persistence of a business item is accomplished by storing a series of state-changing events.

  10. 10
    Article
    Avatar of communityCommunity Picks·4y

    DDD, Hexagonal, Onion, Clean, CQRS, … How I put it all together

    Ports & Adapters architecture identifies three fundamental blocks of code in a system. In most languages and in its most simple form, the Port will be an Interface, but it might actually be composed of several Interfaces and DTOs.

  11. 11
    Article
    Avatar of bytebytegoByteByteGo·4y

    EP30: Why is PostgreSQL the most loved database

    The ByteByteGo talent collective has 100 candidates live at this moment, and over 300+ applications from the best companies out there. The collective's members will have exclusive access to opportunities at high-growth startups and world-class companies such as Meta, Stripe, Snowflake, etc.

  12. 12
    Article
    Avatar of phProduct Hunt·3y

    AI Query - Generate SQL Queries with AI in Seconds

    The fastest way for engineers to generate queries using basic English and let AI do the heavy lifting for you. With AI Query anyone can create efficient queries, without even knowing a thing about it. AI Query is not rated yet. This is AI Query's first launch.

  13. 13
    Article
    Avatar of logrocketLogRocket·3y

    Build a real-time chat app with Rust and React

    Rust is known for its speed and reliability, while React is one of the most popular frontend frameworks for building user interfaces. In this article, we’ll demonstrate how to build a real-time chat app with Rust and React that offers functionality for chat, checking user status, and indicating when a user is typing.

  14. 14
    Article
    Avatar of phProduct Hunt·4y

    DbVisualizer - The Universal Database tool

    DbVisualizer is a universal database tool for administrators, developers, and analysts. It runs on all major OSes and connects to all commercially viable database engines.

  15. 15
    Article
    Avatar of bitBits and Pieces·3y

    I asked Chat GPT to build a To-Do app — Have we finally met our replacement?

    Chat GPT asked Chat GPT to build a To-Do app - Have we finally met our replacement? Are we about to be replaced by an AI, again? We saw the release of GitHub Copilot in October of 2021 and the whole dev community went crazy again. But are they right this time around?

  16. 16
    Article
    Avatar of cockroachdbCockroachDB·4y

    SQL Performance Best Practices

    A distributed database can distribute the query and most of the work of the sort operation, but can’t reduce the workload without using an index. This index is ordered by email, enabling the server to isolate only the user’s messages, and ignore the other 999,000 in the table. It still has 3 stages, but when you take a closer look, the scan stage only touches 1,000 rows.

  17. 17
    Article
    Avatar of gcgitconnected·3y

    Ultimate 10 Stages to Master Backend Development

    Backend development refers to server-side programming in which a developer creates application architecture and business logic to process and store the data and output useful information. There are multiple backend programming languages, frameworks, and stacks like JavaScript, Python, PHP, Java, Ruby, etc.

  18. 18
    Article
    Avatar of asayerasayer·4y

    7 Microservice Design Patterns to Use

    Microservice architecture is self-contained and wrap up around one business capability. It also refers to an architectural style for app development. The design is rapidly evolving and is one of the most important aspects of microservices. In the following sections, we’ll discuss seven important patterns.

  19. 19
    Article
    Avatar of asayerasayer·4y

    Dockerizing Full-Stack React apps

    Using infrastructures such as Docker and Containers gives a developer an upper hand to quickly set up and deploy applications. Containers are lightweight operating systems that run as a form of virtualization.

  20. 20
    Article
    Avatar of communityCommunity Picks·3y

    Architecting an API Backend

    An API’s architecture often mimics how it is maintained and what the service accomplishes. An API may tap into various services to support its own backend, making the architecture stack deceptively complex. A similar ecosystem may exist fueling the components that make up an API itself.

  21. 21
    Article
    Avatar of communityCommunity Picks·4y

    Fully Typed Web Apps

    The secret to fully typed web apps is typing the boundaries. There are plenty of examples of boundaries you’ll encounter on the web. There’s a handy utility I use in almost all my projects to make this slightly nicer on the eyes. It's just a tricky problem because TypeScript doesn’t know your conventions or config.

  22. 22
    Article
    Avatar of honeypotHoneypot·4y

    Dolt - A SQL Database that Works like Git

    Dolt is an SQL-based database that allows you to maintain your database like Git repositories. It combines all the great features of Git and SQL in order to give you an amazing experience. Dolt comes with a powerful CLI similar to Git, and you can apply your knowledge in Git to easily commit, merge, and push database changes. Earn Money from DoltHub Data Bounties.

  23. 23
    Article
    Avatar of quastorQuastor Daily·4y

    Building a Scalable Notification Service

    Razorpay is one of India’s most valuable fintech startups. The company powers payments for over 8 million businesses in India and has been growing extremely quickly. With the increase in transactions, the Razorpay team encountered a few scalability issues - Database Bottleneck - Read query performance was getting worse and it couldn’t scale to meet the required input/output operations per second.

  24. 24
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Build Your Own SaaS – PagerDuty Clone

    Ania Kubów creates popular software tutorials on both the freeCodeCamp channel and her own channel. In this course, Ania will teach you how to build a dashboard to let you know if your app is down. This is a clone of the popular software as a service app called PagerDuty.

  25. 25
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP 38: Where do we cache data?

    This week’s system design refresher: ByteByteGo Facebook page What is OSI Model? What tech stack is commonly used for microservices? We’ve launched a Facebook page and want our content to be more accessible. The diagram illustrates where we cache data in a typical architecture.