Best of DatabaseJuly 2023

  1. 1
    Article
    Avatar of quastorQuastor Daily·3y

    How LinkedIn Serves 5 Million User Profiles per Second

    LinkedIn has over 930 million users in 200 countries. At peak load, the site is serving nearly 5 million user profile pages a second. To manage the increase in traffic, LinkedIn incorporated Couchbase into their stack as a caching layer. They’ve been able to serve 99% of requests with this caching system.

  2. 2
    Article
    Avatar of dzDZone·3y

    Postgres vs. MySQL: a Complete Comparison

    Postgres has taken over the first place spot from MySQL and become the most admired, desired database. As Postgres gains momentum, choosing between them is still hard and often causes heated debate. Postgres is still the world's most popular open-source database by install base.

  3. 3
    Article
    Avatar of communityCommunity Picks·3y

    Typescript CRUD API: Next.js, Tailwind, tRPC, Prisma Postgres, Docker

    Learn how to build a FULL CRUD API app, including a simple frontend to use it, using the following technologies: Next.js, Tailwind, tRPC, Prisma Postgres, Docker. All the code is available for free on GitHub(link in video description) Learn how to code your own blockchain and create your own crypto-currency with the CoinCamp.

  4. 4
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Add Real-time Post Notifications to Your React Applications

    How to add Real-time Post Notifications to your React app, that updates the user when someone likes or comments on your thread? You must know React and Firebase in order to proceed with the things explained below. If you want to build a social media application, simply refer to the videos below.

  5. 5
    Article
    Avatar of bytebytegoByteByteGo·3y

    Database Indexing Strategies

    Poorly designed indexes and a lack of indexes are primary sources of database application bottlenecks. Designing efficient indexes is critical to achieving good database and application performance. An index, much like the index at the end of a book, is a data structure that speeds up data retrieval operations.

  6. 6
    Article
    Avatar of devtoDEV·3y

    SOLID: Single Responsibility Principle With Examples

    The Single Responsibility Principle (SRP) is one of the five SOLID design principles that guide software development. It states that a class should have only one reason to change and one responsibility. The principle is intended to promote modularity and help developers create easier code to understand, modify, and maintain.

  7. 7
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    Learn Full Stack Development with Next.js and Supabase by Building a Twitter Clone.

    Learn Full Stack Development with Next.js 13, Tailwind CSS, TypeScript, and Supabase by building a Twitter clone. The course is designed around a project-based learning approach, providing you with the opportunity to gain hands-on experience as you create a functional, full-stack Twitter clone.

  8. 8
    Article
    Avatar of tilThis is Learning·3y

    Backend development is more than writing endpoints for frontend

    Backend development is a crucial part of web development that involves creating and maintaining the logic, functionality and data of a website or an application. Backend developers are responsible for writing backend code that communicates with the frontend, the server and the database. They also ensure that the backend code is secure, scalable, reliable and efficient.

  9. 9
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Why is DuckDB Getting Popular?

    DuckDB combines the simplicity and ease of use of SQLite with the analytical performance of specialized columnar databases. DuckDB is free and open-source software, so anyone can use and modify the code. It's embedded, meaning the DBMS ( database management system) runs in the same process as the application that uses it.

  10. 10
    Article
    Avatar of asayerasayer·3y

    Build an app with React and Supabase

    Build an app with React and Supabase Back this tutorial will explore building a basic CRUD (Address Book) application using React. We will set up a Supabase database, connecting a React application to it and implementing CRUD operations in our application. By the end of this tutorial, you will have a solid understanding of how to use Supabase.

  11. 11
    Article
    Avatar of dzDZone·3y

    Designing High-Performance APIs

    Designing High-Performance APIs Learn API design principles for high-performance, scalable APIs that deliver exceptional user experiences and handle growing workloads. In a competitive market, speed and reliability are key differentiators. High-performance APIs are crucial in today's digital landscape.

  12. 12
    Article
    Avatar of amplicationAmplication·3y

    How to Build a Node.js GraphQL API With NestJS and Prisma

    NestJS and Prisma are a great couple that can provide exactly that. NestJS is a powerful framework specifically designed for building Node.js applications. Prisma is an open-source database toolkit that provides tools and features to simplify database access. Amplication Amplication can automatically generate entities for your database models if you prefer.

  13. 13
    Article
    Avatar of devtoDEV·3y

    All your ssh and database servers accessible directly from your Browser

    New Border0 client portal allows users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details. We offer both a card and a list view and the choice between dark or light mode. The search box at the top of the screen supports fuzzy search capabilities.

  14. 14
    Article
    Avatar of asayerasayer·3y

    Implementing Live Search Functionality in JavaScript

    This article will explore the ins and outs of implementing live search functionality using JavaScript. This article is designed to provide you with the general coding knowledge and tools necessary to incorporate live search into your projects. The Importance of Live Search Functionality Live search functionality has become vital in today’s digital landscape.

  15. 15
    Article
    Avatar of amplicationAmplication·3y

    Differences in Scaling Stateless vs. Stateful Microservices

    A microservice is designed, developed, and deployed as an independent service. Stateless microservices maintain and manage session-specific states throughout multiple requests. Scaling out involves the addition of more nodes (or instances) of your microservice. It's important to understand that scaling out is done automatically in a serverless environment.

  16. 16
    Article
    Avatar of communityCommunity Picks·3y

    Laravel Volt

    Laravel Volt is a new project announced at Laracon 2023. Volt brings single-file components to Blade templates. This will allow developers to create powerful interactive components that leverage the back-end and the front-end. Conclustion Volt is scheduled to be released this week and I will update this post as soon as this.

  17. 17
    Article
    Avatar of amplicationAmplication·3y

    Create API with GraphQL, Prisma, and MongoDB

    Create API with GraphQL, Prisma, and MongoDB Jump to GraphQL Prisma MongoDB Amplication. Amplication is an open-source platform that automatically generates APIs and clients based on pre-defined data models. It streamlines the development process by minimizing repetitive coding tasks and boilerplate code.

  18. 18
    Article
    Avatar of communityCommunity Picks·3y

    Optimizing Your Architecture with Microservices Design Patterns

    Optimizing Your Architecture with Microservices Design Patterns. We will explore the need for design patterns, popular patterns, and the importance of avoiding anti-patterns. These patterns provide guidance and best practices to overcome common problems such as service communication, data management, fault tolerance, and scalability.

  19. 19
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Database Optimization: Exploring Indexes in SQL

    A similar issue also occurs in SQL Server when it retrieves data from the database. To overcome this, SQL server also uses indexing which speeds up the data retrieval process. We will cover why indexing is needed and how we can effectively create and delete indexes.

  20. 20
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    FastAPI Tutorial – How to Develop, Test, and Deploy APIs

    FastAPI is a sleek and high-performance web framework for constructing Python APIs. We'll create a Python backend system using FastAPI, a fast web framework, and a MongoDB database for course information storage and retrieval. The system will allow users to access course details, view chapters, rate individual chapters, and aggregate ratings.

  21. 21
    Article
    Avatar of cloudnativedailyCloud Native Daily·3y

    Microservices Patterns: The Saga Pattern

    This blog will give the reader some insights into ACID Transactions, 2PC Pattern and finally the Saga Pattern. The primary objective is to give an overview of how Saga Pattern operates and how it can solve real-world distributed transactional issues. The blog was written with some background reading on multiple literature resources mentioned under the References.

  22. 22
    Article
    Avatar of communityCommunity Picks·3y

    The Complete Guide to Becoming a Web Developer: Part 8

    The Complete Guide to Becoming a Web Developer: Part 8 is designed to be your roadmap, your companion as we navigate the intricate landscape of a developer’s mind and the crucial role web security plays in our day-to-day coding lives. We’ll start by exploring the developer mindset, dissecting its key components, and understanding why it's so essential.

  23. 23
    Article
    Avatar of cloudnativedailyCloud Native Daily·3y

    Rethink the Way You Share Data Between Microservices with Change-Data-Capture

    Re -Think the Way You Share Microservices Data. Use Change Data Capture to replicate the data for microservice architecture. Re-think the way You Share Data Between Microservices with Change-Data-Capture Organizing and sharing your data across microservices. Use the replication system when the services will be sharing the data.

  24. 24
    Article
    Avatar of discdotDiscover .NET·3y

    Using your Database as a Queue?

    Using your Database as a Queue? See how NServiceBus makes it easier to design, build, and manage software systems that use message queues to achieve loose coupling. Get started for free. Check out my YouTube channel, where I post all kinds of content accompanying my posts.

  25. 25
    Article
    Avatar of communityCommunity Picks·3y

    The Complete Guide to Becoming a Web Developer: Part 7

    The Complete Guide to Becoming a Web Developer: Part 7. Node.js, NPM, Express and Express are at the forefront of this revolution. These tools have made it possible for developers to use JavaScript, a language traditionally used for front-end development, for server-side programming. NPM is a tool that comes with Node.