Best of DatabaseAugust 2023

  1. 1
    Article
    Avatar of bootcampuxdesignBootcamp·3y

    Backend Projects 🏗️ for Transitioning to a Senior-Level 🙌 Developer 🧑‍💻

    As a backend developer, you play a crucial role in designing and implementing the server-side logic that powers applications. In this article, we will explore a range of project ideas that can help you level up your backend development skills, demonstrate your proficiency in handling advanced concepts, and pave the way for a senior-level developer role.

  2. 2
    Article
    Avatar of communityCommunity Picks·3y

    Auth.js

    Use with any OAuth 2 or OpenID Connect provider - Built in email / passwordless / magic link. Use with any username / password store.

  3. 3
    Article
    Avatar of bytebytegoByteByteGo·3y

    How to Choose a Message Queue?

    The diagram below shows how it works: When the cashier takes an order, a new order is created in the database-backed queue. For Starbucks’ use case, a simple database queue meets the requirements without needing Kafka. RabbitMQ works like a messaging middleware - it pushes messages to consumers then deletes them upon acknowledgment.

  4. 4
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP73: Cheat sheet of different databases in cloud services

    For the fifth year, the State of the API Report is the world's largest and most comprehensive survey and report on APIs. More than 40,000 developers and API professionals have shared their thoughts on development priorities, their API tools, and where they see APIs going.

  5. 5
    Article
    Avatar of asayerasayer·3y

    React: Performing Authentication with JWT

    This article will discuss how to perform JWT authentication in a React app. We will cover the steps involved in setting up a backend JWT endpoint, signing up and signing in from your React app, and protecting routes with JWT validation. You will use a custom-built Express server API to relay the JWT token for a user.

  6. 6
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    React Server Components – How and Why You Should Use Them in Your Code

    React has changed how we think about building user interfaces. We must adapt to this new mental model to fully leverage its power in building applications. In this tutorial, you'll learn about React Server Components (RSC) You'll learn exactly what they are and how they work, and more importantly, what problem they solve.

  7. 7
    Article
    Avatar of bytebytegoByteByteGo·3y

    Database Indexing Strategies - Part 2

    We’ll discuss how indexing is used in non-relational databases and round off our discussion on general database indexing strategies with practical use cases and best practices. In the July 6 issue, we focused on indexing use cases for relational databases where records are stored as individual rows.

  8. 8
    Article
    Avatar of eversqlEverSQL·3y

    PostgreSQL is taking the lead

    PostgreSQL is taking the lead from other relational databases such as MySQL. Postgres is gaining popularity among startups and large enterprises. Cloud vendors are going in a PostgreSQL-first approach, with cloud vendors creating customized databases based on PostgreSQL. PostgreSQL has an internal engine that can be trusted to build other technologies.

  9. 9
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Build a Task Manager CLI Tool with Node.js

    How to build a Task Manager CLI tool with Node.js is a simple task manager tool. You can use commands to Create, View, Update, or Delete your todos. We'll also use MongoDB as the database to store all our todos. You can find the complete code for this project on GitHub.

  10. 10
    Article
    Avatar of quastorQuastor Daily·3y

    How Quora scaled MySQL to 100k+ Queries Per Second

    Quora is a social media site where you can post questions for the community to respond to. They have over 300 million monthly active users with tens of thousands of questions posted per day. Quora scaled this with improving their caching strategy (changing the structure to minimize cache misses) and also by optimizing inefficient read queries.

  11. 11
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    OWASP API Security Top 10 – Secure Your APIs

    The OWASP API Security Top 10 is a standard reference guide highlighting the most critical web API vulnerabilities. We just published a course on the freeCodeCamp.org YouTube channel that will teach you about each security risk and techniques to fortify your APIs against potential threats.

  12. 12
    Article
    Avatar of thevergeThe Verge·3y

    Why note-taking apps don’t make us smarter

    This is Platformer, a newsletter on the intersection of Silicon Valley and democracy from Casey Newton and Zoë Schiffer. For decades now, software tools have promised to make working life easier. But on one critical dimension - their ability to improve our thinking - they don't seem to be making much progress.

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

    Best Observability Tools for Microservices

    Microservices architecture has become popular among developers due to its scalability and flexibility. Helios Helios is an observability tool that offers comprehensive monitoring and analytics solutions for microservices and distributed applications. Lightstep Lightstep is a leading observability platform that helps to gain deep insights into the performance and behavior of microservices architectures.

  14. 14
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    The Ultimate Guide to High Performance WordPress

    This guide combines over 20 years of experience of fine-tuning servers, CDNs, and website code to deliver high performance WordPress sites. This guide was put together by the team at InMotion Hosting. They offer web hosting, servers, and cloud WordPress hosting.

  15. 15
    Article
    Avatar of bytebytegoByteByteGo·3y

    Data Replication: A Key Component for Building Large-Scale Distributed Systems

    Data Replication is critical for building reliable, large-scale distributed systems. We'll explore three main replication strategies: Leader-Follower, Multi-Leader, and Leaderless. Improving durability is perhaps the single most important reason for data replication. When a single database server fails, it could lead to catastrophic data loss and downtime.

  16. 16
    Article
    Avatar of lnLaravel News·3y

    NativePHP Tutorial: Building a Mac MenuBar application

    NativePHP allows us Laravel Devs to leverage all the working knowledge we already have with Laravel to build native Mac, Windows, and Linux applications. This is kinda like sorcery if you think about it - web technologies to build out a 'native' application.

  17. 17
    Article
    Avatar of pointerPointer·3y

    clockworklabs/SpacetimeDB: Multiplayer at the speed of light

    SpacetimeDB is a relational database system that lets you upload your application logic directly into the database. You can write your entire application in a single language, Rust, and deploy it as a single binary. It is designed to be used for real-time applications like games, chat, and collaboration tools.

  18. 18
    Article
    Avatar of crunchydataCrunchy Data·3y

    When Did Postgres Become Cool?

    Postgres just passed the 25 year milestone as an open source project. Postgres' origin started with the Ingres project at the University of California Berkeley as Ingres (INteractive Graphics REtrieval System) The first version of Postgres was released as 6.0 in 1996 and the Postgres Global Development Team was established.

  19. 19
    Article
    Avatar of communityCommunity Picks·3y

    What is the N+1 query problem and how to detect it?

    The infamous N + 1 query problem is an anti-pattern that stems from the leaky abstraction that ORMs provide. This problem is mainly associated with how ORM frameworks handle the lazy loading of related entries. The more blog posts and Authors in your database, the more severe the problem can be, impacting application performance and user experience.

  20. 20
    Article
    Avatar of amplicationAmplication·3y

    Modernizing Legacy Systems with Amplication's DB Schema Import

    Amplication’s auto-generation tools drastically cut down the development process by handling boilerplate and infrastructure code. Amplication ensures your backend services are consistent, scalable, and up to industry standards. The challenge of updating old systems is significant, especially without losing data or running into issues.

  21. 21
    Article
    Avatar of supabaseSupabase·3y

    Supabase Studio 3.0: AI SQL Editor, Schema Diagrams, and new Wrappers

    Supabase Studio 3.0: AI SQL Editor, Schema Diagrams, and Wrappers.0 is here, with some huge new features. Supabase AI is aware of the SQL snippet in the editor and can modify it for you. You can ask it to change to, for example, for example.

  22. 22
    Article
    Avatar of pointerPointer·3y

    apioo/fusio: Open source API management platform

    Fusio is an open source API management platform which helps to create innovative API solutions. Fusio covers many aspects of the API life cycle so that you can concentrate on writing the actual business logic of your API. It provides a powerful code generator which can automatically generate an SDK for your API.

  23. 23
    Article
    Avatar of planetscalePlanetScale·3y

    Build a contacts app with Node, Express, and MySQL

    The database is an essential component of every application as it provides the requisite data for the application to function. In this article, I will show you how to implement SSR using Express and Pug. Planetscale will provide the database service - allowing you to enjoy all the benefits of MySQL via a highly scalable and reliable service provider.

  24. 24
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Build a WhatsApp Dictionary Chatbot using Twilio, FastAPI, and MongoDB

    How to build a WhatsApp Dictionary Chatbot using Twilio, FastAPI, and MongoDB. Use Fast API to create the web server and interact with the database. By the end of this tutorial, you will have developed a functional chatbot that can define words in real-time.

  25. 25
    Article
    Avatar of pointerPointer·3y

    getonboard.dev

    Ask questions to find your way around where do we put items in the user database? How does auth work? What does the processor module do?