Best of DatabaseAugust 2022

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

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

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

  5. 5
    Article
    Avatar of redislabsRedis·4y

    NoSQL Data Modeling

    The Embedded and Partial Embed Pattern is a great model for keeping different tables with information that relates to one another. In non-relational databases, what you’d want to do is embed your list on the bounded side.

  6. 6
    Article
    Avatar of lnLaravel News·4y

    How I develop applications with Laravel

    The API we are building is a basic to-do style application, where we can add tasks and move them between to do and done. For me, it always begins with a simple command: laravel new todo-api --jet --git. We will create an API because it is something I love doing. The way I work with Laravel is very similar to Domain Driven Design, so there is a little setup.

  7. 7
    Article
    Avatar of appsignalAppSignal·4y

    Build a CRUD App with Node.js and MongoDB

    MongoDB is an open-source, cross-platform, document-oriented database program. MongoDB’s horizontal, scale-out architecture can support huge volumes of both data and traffic. The application will connect to a MongoDB database and allow users to create, read, update, and delete blog posts. Make a services/BlogService.js file in your project root directory and add the code snippet below.

  8. 8
    Article
    Avatar of pointerPointer·4y

    surrealdb/surrealdb: A scalable, distributed, collaborative, document-graph database, for the realtime web

    SurrealDB is an end-to-end cloud native database for web, mobile, serverless, jamstack, backend, and traditional applications. It can run as a single server or in a highly-available, highly-scalable distributed mode. With strongly-typed data types, data can be fully modelled right in the database. Easily work with unstructured or structured data, in schemafull. Data can be completely modelled.

  9. 9
    Article
    Avatar of hashnodeHashnode·4y

    MongoDB schema design best practices

    MongoDB is a document-oriented NoSQL database that can store large amounts of data in a JSON format. It has a faster execution than RDBMS. This article will help you understand the theoretical core concepts of MongoDB that can be used to improve scalability and performance.

  10. 10
    Article
    Avatar of laravelLaravel·4y

    Laravel: New DB Commands

    This week's Laravel v9.24 release introduces three new database commands. Artisan "db:show" command gives you an overview of your database as a whole. The new db:monitor command allows you to quickly see the number of open connections to your database.

  11. 11
    Article
    Avatar of cockroachdbCockroachDB·4y

    Building a Payments System That Scales to Infinity (With Examples)

    Payments often don’t matter much beyond the 60-90 seconds during which a payment transaction takes place. Storing all of this data and keeping it available without bogging down your application can be. CockroachDB allows table- and row-level data homing, making it easy to assign rows to specific geographic regions.

  12. 12
    Article
    Avatar of supabaseSupabase·4y

    Supabase Vault

    Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.

  13. 13
    Article
    Avatar of gcgitconnected·4y

    Microservices with Node.js, Kubernetes, and RabbitMQ

    Kubernetes (‘K8s’) is an open source system for automating and managing container orchestration that grew out of Google’s Borg, and is now maintained by the Cloud Native Computing Foundation. A microservice architecture means that your app is made up of many smaller, independent applications RABBITMQ_URL. The orders/index.js will be listening for an ‘ORDER’ message and as soon as it gets that message.

  14. 14
    Article
    Avatar of singlestoreSingleStore·4y

    MariaDB vs. MySQL

    MariaDB is an open-source Relational Database Management System (RDBMS) MariaDB is gaining popularity due to its flexibility and availability. MariaDB has made significant progress in the areas of scalability and reliability, and has emerged as a competitor to MySQL.

  15. 15
    Article
    Avatar of hashnodeHashnode·4y

    Fullstack App built with ReactJS, NodeJS, ExpressJs and Redis-OM

    Fullstack App built with ReactJS, NodeJS, ExpressJs and Redis-OM Overview. We'll be building a Fullstack app with Redis Database for storing the data. Redis is an in-memory key-value store that is often used as a cache to make traditional databases faster. It gives us the methods to read, write and remove a specific Entity and lastly. A Repository is the main interface into Redis OM.

  16. 16
    Article
    Avatar of devdojoDevDojo·4y

    PhpStorm Plugins You Should Know

    PhpStorm plugin is an open-source Code Review and Static Code Analysis tool for PHP (aka inspections in JetBrains IDEs) It’s a must-have add-on to Php Storm to ensure high-quality coding.

  17. 17
    Article
    Avatar of dzDZone·4y

    Design Patterns for Microservices Architectures

    There are more than eight must-have design patterns for smooth development in a typical micro services architecture. An orchestrator (object) coordinates with all the services to do local transactions, get updates, and execute the next event.

  18. 18
    Article
    Avatar of logrocketLogRocket·4y

    Build a full stack app with Next.js and Supabase

    Next.js is an open source Firebase alternative with a lot of powerful tools, including seamless authentication. Next.js and Supabase are one of the easiest and most popular ways to build production-ready React applications. Use React's useEffect to optimize your application's performance Switch between multiple versions of Node.

  19. 19
    Article
    Avatar of rpythonReal Python·4y

    Building a URL Shortener With FastAPI and Python – Real Python

    A URL shortener reduces the number of characters in a URL, making it easier to read, remember, and share. By following this step-by-step project, you’ll build a URLShortener with Python and FastAPI.

  20. 20
    Article
    Avatar of pointerPointer·4y

    Event Driven Architecture — 5 Pitfalls to Avoid

    At Wix we have been gradually migrating our growing set of microservices from the request-reply pattern to event driven architecture over the last few years. Below there are 5 pitfalls that Wix engineers have encountered during our experimentation with event-driven architecture.

  21. 21
    Article
    Avatar of communityCommunity Picks·4y

    SOLID: The First 5 Principles of Object Oriented Design

    SOLID is an acronym for the first five object-oriented design principles by Robert C. Martin. Adopting these practices can also contribute to avoiding code smells and refactoring code.

  22. 22
    Article
    Avatar of kdnuggetsKDnuggets·4y

    Getting Started with SQL Cheatsheet

    SQL is one of the most powerful tools we have at our disposal as data scientists. There is no chance it will go out of style in the next few years, and can be immediately of practical use in your learning and your career.

  23. 23
    Article
    Avatar of tuts_plusTuts+·4y

    PHP Tutorial for Beginners: Free 7 Hour Course

    Learn the fundamentals of PHP and use it to write web apps in this free course. Follow along to learn the most important skills writing apps for the web.

  24. 24
    Article
    Avatar of bytebytegoByteByteGo·4y

    EP20: How SQL works under the hood. Also...

    How does Netflix scale push messaging for millions of devices? Amazon DynamoDB powered 89 million requests per second during prime days. Netflix’s homegrown solution called ‘Zuul Push’ is used. For Android, FCM is used to send push notifications for Apple devices.

  25. 25
    Article
    Avatar of hashnodeHashnode·4y

    PhpStorm Plugins You Should Know

    Php Inspections (EA Extended) is an open-source Code Review and Static Code Analysis tool for PHP. GitLive is an absolute must to enhance PhpStorms’s built-in Git functionality with real-time features such as online presence for team members and instant merge conflict detection.