Best of DatabaseSeptember 2023

  1. 1
    Article
    Avatar of amplicationAmplication·3y

    The Complete Microservices Guide

    Microservices have emerged as a popular architectural approach for designing and building software systems for several compelling reasons and advantages. It is a design approach that involves dividing applications into multiple distinct and independent services called "microservices" Microservices are naturally distributed services as each service is isolated from the others and runs in its own instance.

  2. 2
    Article
    Avatar of communityCommunity Picks·3y

    Rust Vs Go: A Hands-On Comparison

    This article compares Rust and Go in terms of web development and discusses the benefits of using Rust for web services. It covers the differences in syntax, web ecosystems, handling web tasks, concurrency models, and more. The article also explores the use of databases, middleware, and templates in both languages. While Go provides a batteries-included development environment and is great for quick start-ups, Rust offers long-term benefits with its robust type system, error handling mechanisms, and compile-time checks. Rust, in combination with Shuttle for deployment, can provide a fast and extensible solution for web development.

  3. 3
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP76: Netflix's Tech Stack

    In this CEO-approved slide deck, you’ll find simple ways to communicate how your team is increasing engineering efficiency. For too many engineering leaders, the most stressful part of their job isn’t a bug or a system crash. The CTO Board Deck is your secret weapon for owning any boardroom you enter.

  4. 4
    Article
    Avatar of dzDZone·3y

    What Is Good Database Design?

    DZone: Good database design is essential to ensure data accuracy, consistency, and integrity. The design must address the storing and retrieving of data quickly and easily while handling large volumes of data in a stable way. Data security is a critical consideration in modern database design, given the rising prevalence of fraud and data breaches.

  5. 5
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP77: My Recommended Materials for Cracking Your Next Technical Interview

    The third annual Observability Forecast by New Relic is out now. The survey results show that observability continues to deliver a clear, positive business impact and a 2x median annual return on investment. Uber Tech Stack is based on research from many Uber engineering blogs and open-source projects.

  6. 6
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP78: How to Crack Any System Design Interview

    We break down the key concepts of database partitioning, explaining both vertical and horizontal strategies. Drata automates evidence collection and monitors risk 24/7 for 16+ frameworks, including SOC 2, ISO 27001, GDPR, and HIPAA. Book a demo to see how you can stay compliant with continuous control monitoring.

  7. 7
    Article
    Avatar of cloudnativenowCloud Native Now·3y

    Top 9 Microservices Design Patterns

    Microservices design patterns are gaining immense popularity due to their myriad benefits. They offer flexibility, scalability and the ability to independently develop and deploy parts of an application. They are the blueprints that guide the design of microservices architecture, especially for cloud-native applications.

  8. 8
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP75: How Does A Password Manager Work

    This week’s system design refresher: Top 5 Most Used Architecture Patterns. How does a Password Manager work? Implement passkey authentication in minutes (Sponsored) Join TikTok, Paypal, Google, and other leading tech companies by giving your users a faster and more secure sign-in experience with passkeys.

  9. 9
    Article
    Avatar of awstipAWS Tip·3y

    Microservices design

    The application is deployed in Amazon ECS as a single service that’s scalable and highly available. As the app has grown, we’ve noticed that content delivery becomes a bottleneck during normal operations. To deal with these issues, we decided to split the app into three microservices: Course Catalog, Content Delivery and Progress Tracking.

  10. 10
    Article
    Avatar of bytebytegoByteByteGo·3y

    Why is Kafka so fast? How does it work?

    Kafka has emerged as a popular choice for its speed and scalability - but what exactly makes it so fast? In this issue, we'll explore: Kafka's architecture and its core components like producer, brokers, and consumers. How Kafka optimizes data storage and replication and replication.

  11. 11
    Article
    Avatar of pointerPointer·3y

    Upsert in SQL

    This article discusses the concept of upsert in SQL and explains how it works in different database management systems (DBMS) like MySQL, SQLite, and PostgreSQL. It provides examples and code snippets for each DBMS to demonstrate the various ways to perform upsert operations.

  12. 12
    Article
    Avatar of devtoDEV·3y

    Docker Node.js and MongoDB example

    Docker provides lightweight containers to run services in isolation from our infrastructure so we can deliver software quickly. In this tutorial, I will show you how to dockerize Nodejs Express and MongoDB example using Docker Compose. The problem is to containerize a system that requires more than one Docker container.

  13. 13
    Article
    Avatar of awstipAWS Tip·3y

    The Backend part of MNNN Stack: MongoDB, NestJS, NextJS and NodeJS

    Learn about the MNNN Stack, its advantages over a Relational Database, and the purpose of a DTO.

  14. 14
    Article
    Avatar of amplicationAmplication·3y

    Picking the Perfect Database for Your Microservices

    Microservices have been the go-to application architecture that many software projects have adopted. Microservices favour independent service components where each service can run on its own runtime and connect to its own database. This means you're encouraged to share data between microservices rather than using an extensive single database for all your microservices.

  15. 15
    Article
    Avatar of communityCommunity Picks·3y

    Detailed Introduction To Prisma ORM

    Prisma is an open-source object-relational mapper (ORM) tool for Node.js and TypeScript. In Prisma, you define your models as classes that map to tables in a database. Models are entities that represent data in your database.

  16. 16
    Article
    Avatar of amplicationAmplication·3y

    How to Effectively Use Caching to Improve Microservices Performance

    Caching is a technique used in computer systems to store frequently accessed data or computation results in a temporary storage area called a "cache" This article will dive into the art of leveraging caching techniques to their fullest potential. We will explore database caching, edge caching, API caching, and local caching.

  17. 17
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    The SQL Handbook – A Free Course for Web Developers

    The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel.

  18. 18
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    Full Stack Project Tutorial – Create A Notes App Using React and Node.js

    Learn how to create a full stack notes app using React and Node.js. The tutorial covers building the UI, connecting it to the backend, and adding features like validation and error handling. By the end of the tutorial, readers will have a functional notes app that they can use as a starting point for their own projects.

  19. 19
    Article
    Avatar of medium_jsMedium·3y

    Writing Production-Ready Code in Node.js

    Node.js is often used for building APIs and handling data-intensive operations and it works a charm for the same. Let’s discuss the NodeJS-specific tips for writing production-ready code.

  20. 20
    Article
    Avatar of gcgitconnected·3y

    How Discord Stores Trillions of Messages — Curious Case of System Design

    Discord’s Cassandra cluster exhibited serious performance issues that required increasing amounts of effort to just maintain, not improve. In 2017, the Discord team ran 12 Cassandra nodes, storing billions of messages. They migrated their data to ScyllaDB because they were looking for a database that was scalable and fault-tolerant.

  21. 21
    Article
    Avatar of pointerPointer·3y

    electric-sql/electric: Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.

    ElectricSQL is a local-first software platform that makes it easy to develop high-quality, modern apps with instant reactivity, real-time multi-user collaboration and conflict-free offline support. ElectricSQL gives you instant local- first for your Postgres-based system. The app code talks directly to an embedded local database and data syncs.

  22. 22
    Article
    Avatar of communityCommunity Picks·3y

    How to handle Large data in Laravel?

    This tip mainly focuses on improving the memory usage of your application when dealing with large datasets. If your application needs to process a large set of records, instead of retrieving them all at once, you can retrieve a subset of results and process them in groups. This approach will make more database queries but highly memory efficient.

  23. 23
    Article
    Avatar of communityCommunity Picks·3y

    Creating an 👩‍💻 Open Source Search Platform: Search Engines with AI - Swirl 🌌

    Swirl is a unified open-source search platform built with Python and Django. Users can conduct a single query, instantly pooling and presenting relevant data from multiple platforms in one consolidated UI. Built on Python, it carries the Apache 2.0 License, which means developers and businesses can utilize and modify it without any licensing costs.

  24. 24
    Article
    Avatar of communityCommunity Picks·3y

    Build your own AI Meme Generator & learn how to use OpenAI's function calls ☎️

    Build your own AI Meme Generator & learn how to use OpenAI’s function calling API. Check out a deployed version of the app we’re going to build here: The Memerator. If you just want to see the code for the finished app, check out the Memerators' GitHub Repo.

  25. 25
    Article
    Avatar of communityCommunity Picks·3y

    Designing and Modeling the Database with Mongoose

    This comprehensive guide provides step-by-step instructions for crafting a scalable MongoDB database design and modeling it effectively using Mongoose ODM. The data layer often acts as the cornerstone that underpins an application's business logic and user experience. The right design depends on your needs and how you intend to interact with the data.