Best of DatabaseSeptember 2022

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

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

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

  4. 4
    Article
    Avatar of phProduct Hunt·4y

    Appwrite - 100% open source alternative for Firebase

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

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

  6. 6
    Article
    Avatar of devtoDEV·4y

    Database GUIs in JavaScript

    Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox.

  7. 7
    Article
    Avatar of rhdevRed Hat Developer·4y

    MongoDB Cheat Sheet

    MongoDB Cheat Sheet covers basic commands and tasks for using MongoDB. It introduces key concepts, like collections and indexes, and explains how to perform common tasks. It also provides tips on how to carefully execute dangerous tasks like dropping collections from a database.

  8. 8
    Article
    Avatar of bytebytegoByteByteGo·4y

    EP23: How to choose the right database? Also...

    GraphQL is a query language for APIs developed by Meta. It provides a complete description of the data in the API and gives clients the power to ask for Migrating to a new database in the real world could take years at a high scale. Bloom Filters Algorithms You Should Know For System Design #2.

  9. 9
    Article
    Avatar of communityCommunity Picks·4y

    System Design Series' Articles

    System Design Series' Series System Design: The complete course System Design. System Design is based on Karan Pratap Singh's series System Design. The series also includes Netflix, Netflix and Netflix. System Design series: Netflix System Design, Netflix, Twitter and Twitter.

  10. 10
    Article
    Avatar of communityCommunity Picks·4y

    How to Scale Application to support Millions User

    How to Scale Application to support Millions User Designing a system that supports millions of users is a process that requires continuous improvement and refinement.

  11. 11
    Article
    Avatar of communityCommunity Picks·4y

    donnemartin/system-design-primer: Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.

    The system design interview is an open-ended conversation. You are expected to lead it. To help solidify this process, work through the System design interview questions with solutions. Ask questions to clarify use cases, constraints, and assumptions Gather requirements and scope the problem.

  12. 12
    Article
    Avatar of dockerDocker·4y

    How to Setup Your Local Node.js Dev Environment Using Docker

    Docker is the de facto toolset for building modern applications and setting up a CI/CD pipeline. How to set up a local Node.js development environment for a relatively complex application that uses React for its front end, Node and Express for a couple of micro-services and MongoDb for our datastore.

  13. 13
    Article
    Avatar of btrprogBetter Programming·4y

    Writing My First Microservice Using Go

    Go is an open source programming language supported by Google. The biggest companies using Go are Google, Netflix, Dropbox, Uber, Meta, Twitch, etc. With Go, you can create cloud & network services, web applications, and command-line interfaces. It’s a great solution to aggregate, collect, store and visualize logs from your applications.

  14. 14
    Article
    Avatar of logrocketLogRocket·4y

    Prisma vs. Thin Backend

    Prisma enables you to access your database straight from Node.js and TypeScript application code. Thin Backend provides you with an IDE that has custom business logic and serverless functions. Prisma is a type-safe query builder that is an alternative to Sequelize and TypeORM.

  15. 15
    Article
    Avatar of tigerdataTigerData (Creators of TimescaleDB)·4y

    PostgreSQL + TimescaleDB: 1000x Faster Queries, 90% Data Compression, and Much More

    TimescaleDB can dramatically improve query performance by 1000x or more, reduce storage utilization by 90% or more. Timescale provides two methods to reduce the amount of data being stored, compression and downsampling using continuous aggregates.

  16. 16
    Article
    Avatar of communityCommunity Picks·4y

    Scalability For Junior Engineers

    Scalability is an ability to adjust the capacity of the system to cost-efficiently fulfill the demands. Scalability of a system depends on many factors, but if we narrow them down, there are three main measurements to measure the system's capability. The third measurement of scalability is the Rate of interactions between Advantages of Vertical Scaling.

  17. 17
    Article
    Avatar of redislabsRedis·4y

    5 Things You Didn’t Know You Could Do With Redis

    The pandemic had a huge effect on Ulta Beauty, from swift adoption of curbside delivery service (which ballooned six-fold in the final quarter of 2020, industry-wide) The founders of Kipp set out to be the bridge between credit issuers and merchants in the digital payment approval process.

  18. 18
    Article
    Avatar of developercomDeveloper.com·4y

    Top 10 Microservices Design Principles

    Microservice architecture is a software architecture pattern where a system is designed as a network of loosely coupled services. This tutorial presents a discussion on some microservices design principles that will serve as guidelines to build scalable, high performance, fault tolerant microservices-based applications.

  19. 19
    Article
    Avatar of logrocketLogRocket·4y

    Comparing the 7 best ORM packages in Go

    The GORM (Go-ORM) package is the most popular ORM package in the Go ecosystem. The SQLC package provides database queries, transactions, configurations, and functionalities. The Beego ORM is a powerful ORM inspired by popular Python ORMs, like the Django ORM and SQLAlchemy.

  20. 20
    Article
    Avatar of pointerPointer·4y

    steven-tey/dub: An open-source link shortener with built-in analytics + free custom domains.

    Dub is an open-source link shortener SaaS with built-in analytics + free custom domains. Built with Vercel Edge Functions and Upstash Redis. Dub provides a powerful analytics dashboard for your links, including geolocation, device, and browser information.

  21. 21
    Article
    Avatar of logrocketLogRocket·4y

    Modeling NestJS app data with Dynamoose

    DynamoDB is a NoSQL database, meaning that it does not have a pre-defined structure. We will explore why you should use ORM, or object-relational mapping, with DynamoDB to manage the models of the models. The first step to creating a NestJS app with Dynamoose is to install the NestJS CLI. The next step is to create an entity class that extends the Document class provided by Dynamoose. The nextStep is to define the data structure.

  22. 22
    Article
    Avatar of bytebytegoByteByteGo·4y

    EP22: Latency numbers you should know. Also...

    The in-memory cache can deal with a much higher throughput than the database. We can also put requests into a message queue so the requests can be processed at the service's own pace. The diagram below shows the 4 key business areas in a typical e-commerce company: procurement, inventory, eComm platform, and transportation. The promotion system defines big sale activities, coupons, etc.

  23. 23
    Article
    Avatar of devtoDEV·4y

    The Complete List of Heroku Alternatives to Consider

    Heroku will be shutting down its free tier in the coming months. Starting October 26, 2022, we will begin deleting inactive accounts and associated storage for accounts that have been inactive for over a year. Some people are looking for free alternatives to replace their current Heroku arrangement. Some are smaller companies that are just getting started.

  24. 24
    Article
    Avatar of faunaFauna·4y

    Understanding the document-relational database

    Fauna is a distributed document-relational database built for modern applications. It combines the flexibility and familiarity of JSON documents with the power of a traditional relational database. It is delivered as an API, removing the operational burden from developers.

  25. 25
    Article
    Avatar of systemweaknessSystem Weakness·4y

    SQL Injection

    The first thing to do when faced with an SQL vulnerability is to try to detect how many columns exist in your table. To do this we will use the payload order by 1000. When you have executed this, you will see an error like this. To automate this I create a very nice python tool and it will be the tool with which I will teach you how to exploit a Blind SQL Injection. It is a type of SQL injection.