Best of DatabaseDecember 2022

  1. 1
    Article
    Avatar of communityCommunity Picks·3y

    The complete guide to System Design in 2022

    System Design is the process of defining the architecture, interfaces, and data for a system that satisfies specific requirements. System design meets the needs of your business or organization through coherent and efficient systems. The complete guide to System Design Interview in 2022 is available.

  2. 2
    Article
    Avatar of phProduct Hunt·3y

    AI Query - Generate SQL Queries with AI in Seconds

    The fastest way for engineers to generate queries using basic English and let AI do the heavy lifting for you. With AI Query anyone can create efficient queries, without even knowing a thing about it. AI Query is not rated yet. This is AI Query's first launch.

  3. 3
    Article
    Avatar of logrocketLogRocket·3y

    Build a real-time chat app with Rust and React

    Rust is known for its speed and reliability, while React is one of the most popular frontend frameworks for building user interfaces. In this article, we’ll demonstrate how to build a real-time chat app with Rust and React that offers functionality for chat, checking user status, and indicating when a user is typing.

  4. 4
    Article
    Avatar of bitBits and Pieces·3y

    I asked Chat GPT to build a To-Do app — Have we finally met our replacement?

    Chat GPT asked Chat GPT to build a To-Do app - Have we finally met our replacement? Are we about to be replaced by an AI, again? We saw the release of GitHub Copilot in October of 2021 and the whole dev community went crazy again. But are they right this time around?

  5. 5
    Article
    Avatar of gcgitconnected·3y

    Ultimate 10 Stages to Master Backend Development

    Backend development refers to server-side programming in which a developer creates application architecture and business logic to process and store the data and output useful information. There are multiple backend programming languages, frameworks, and stacks like JavaScript, Python, PHP, Java, Ruby, etc.

  6. 6
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Build Your Own SaaS – PagerDuty Clone

    Ania Kubów creates popular software tutorials on both the freeCodeCamp channel and her own channel. In this course, Ania will teach you how to build a dashboard to let you know if your app is down. This is a clone of the popular software as a service app called PagerDuty.

  7. 7
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP 38: Where do we cache data?

    This week’s system design refresher: ByteByteGo Facebook page What is OSI Model? What tech stack is commonly used for microservices? We’ve launched a Facebook page and want our content to be more accessible. The diagram illustrates where we cache data in a typical architecture.

  8. 8
    Article
    Avatar of medium_jsMedium·3y

    Data Fetching: FETCH API Approach vs SWR Approach

    Fetching is a method of receiving and sending data provided to us by JavaScript. The Fetch API method has an asynchronous nature. It is not a method that can be used alone as a substitute for FETCH API. In the Single Page Application method, there is usually no need to load a web page from scratch.

  9. 9
    Article
    Avatar of hnHacker News·3y

    Just Use Postgres for Everything

    Use Postgres for everything is a tradeoff, says Stephan As a CTO, Interim CTO and CTO Coach. Postgres can replace - up to millions of users - many backend technologies, such as Kafka, RabbitMQ, Mongo and Redis among them.

  10. 10
    Article
    Avatar of quastorQuastor Daily·3y

    How Netflix Syncs Hundreds of Millions of Devices

    Netflix is an online video streaming service that operates at insane scale. They have more than 220 million active users and account for more of the world's downstream internet traffic than YouTube. At peak, it can be about 150,000 events per second. To handle this, Netflix built RENO, their Rapid Event Notification System.

  11. 11
    Article
    Avatar of threedotslabsThree Dots Labs·3y

    The Go libraries that never failed us: 22 libraries you need to know

    Awesome Go contains over 2600 libraries, but popularity is not always the best indicator of library quality. It’s generally better to use libraries instead of frameworks for long-term projects. We’ve included some common anti-patterns to help you avoid making those mistakes.

  12. 12
    Article
    Avatar of sqlshackSQL Shack·3y

    5 Best Practices for writing SQL queries

    Queries are used to communicate with the databases and perform the database operations. We use the queries to update data on a database or retrieve data from the database. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. Microsoft offers two different tools to develop queries.

  13. 13
    Article
    Avatar of supabaseSupabase·3y

    What's new in Postgres 15?

    The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.

  14. 14
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP36: Types of Databases and Use Cases

    Ilum is the Spark cluster manager and monitoring tool. Ilum provides an all-in-one solution for: Apache Spark Cluster management and monitoring service Hadoop. The core of ElasticSearch lies in the data structure and indexing. It is important to understand how ES builds the term dictionary using LSM Tree.

  15. 15
    Article
    Avatar of faunaFauna·3y

    Side-by-side comparison of serverless databases

    Serverless databases make it easy to build and scale your application because they abstract away the underlying infrastructure and automatically scale to meet the need of your application. With MongoDB, you don’t have to manage any infrastructure by yourself. This article compares commonly used serverless databases so you can make an informed decision.

  16. 16
    Article
    Avatar of logrocketLogRocket·3y

    Build a full-stack application with AdminJS

    AdminJS is an open source Node.js admin panel that promises to do just that: AdminJS. The tutorial portion of this post will demonstrate how to use AdminJS to build a full-stack application. It offers a range of customizability, it provides a REST API that can be integrated into other applications.

  17. 17
    Article
    Avatar of phProduct Hunt·3y

    Postgres Playground - Hands-on tutorials to learn Postgres

    Postgres Playground is a free, hands-on tutorial to learn Postgres. Advanced tutorials include performance analysis, JSON, PostGIS, and window functions. This is Postgres playground's first launch. Postgres Playgrounds is not rated yet.

  18. 18
    Article
    Avatar of phProduct Hunt·3y

    hubble - Github star manager

    The best of Product Hunt, everyday Web3 Keep up to date with the latest in web3 Community Discussions Ask questions, find support and connect Stories Tech news, interviews and tips from Makers Changelog Release notes from the Product Hunt team Office hours Give feedback directly to our product team Visit streaks.

  19. 19
    Article
    Avatar of communityCommunity Picks·3y

    How JWTs Could Be Dangerous and Its Alternatives

    JWTs are the most popularly used tokens for web authentication and managing user sessions in modern-day software applications. They are a standardized format for securely transferring cryptographically signed data across systems. JWTs can make websites vulnerable to a variety of high-security threats and attacks if not managed properly.

  20. 20
    Article
    Avatar of supabaseSupabase·3y

    graphql v1.0

    pg_graphql is a Postgres extension that allows you to query your database using GraphQL. It is the foundation of GraphQL support in the Supabase stack. Since our first platform release, v0.2.1, the feature set of Postgres has steadily grown and stabilized.

  21. 21
    Article
    Avatar of codemotionCodemotion·3y

    5 Top API Tools for Front-End Web and Mobile Development

    5 Top API Tools for Front-End Web and Mobile Development API tools are key elements in front-end development, both mobile and web. This article explores some interesting options available and their main features. In terms of web development, Application Programming Interfaces are powerful and extremely useful tools. These services help save considerable time, increase the developers’ performance.

  22. 22
    Article
    Avatar of dzDZone·3y

    The Right Database for You Project's Success

    The Right Database for You Project's Success Maximize Your Project's success with the Right Database Selection Learn the key considerations for choosing the right database for your project. The database management system is chosen depending on the tasks of the business.

  23. 23
    Article
    Avatar of towardsdevTowards Dev·3y

    ORM -The good and the bad things

    An ORM (Object Relation Mapper) is a piece of software dedicated to translating between the data representations in relational databases and the representation in memory used with object-oriented programming (OOP) The good - Helps to save time to write queries - Reduce development time - reduce development costs - Adds an abstract layer for the DB repository.

  24. 24
    Article
    Avatar of logrocketLogRocket·3y

    5 ways to rapidly improve MySQL database performance

    The database management system can support all kinds of projects, from gaming forums to healthcare solutions. Improving database performance is also something that every DBA struggles with at some point in their career.

  25. 25
    Article
    Avatar of tuts_plusTuts+·3y

    Mapping Relational Databases and SQL to MongoDB

    MongoDB is an open source document-oriented NoSQL database which stores data in the form of JSON-like objects. This article will drive you to understand how the RDBMS/SQL domain, its functionalities, terms and query language map to MongoDB database. The article assumes that you are aware of the basic relational database concepts.