Best of MySQLOctober 2022

  1. 1
    Article
    Avatar of honeypotHoneypot·4y

    Dolt - A SQL Database that Works like Git

    Dolt is an SQL-based database that allows you to maintain your database like Git repositories. It combines all the great features of Git and SQL in order to give you an amazing experience. Dolt comes with a powerful CLI similar to Git, and you can apply your knowledge in Git to easily commit, merge, and push database changes. Earn Money from DoltHub Data Bounties.

  2. 2
    Article
    Avatar of quastorQuastor Daily·4y

    Building a Scalable Notification Service

    Razorpay is one of India’s most valuable fintech startups. The company powers payments for over 8 million businesses in India and has been growing extremely quickly. With the increase in transactions, the Razorpay team encountered a few scalability issues - Database Bottleneck - Read query performance was getting worse and it couldn’t scale to meet the required input/output operations per second.

  3. 3
    Article
    Avatar of pointerPointer·4y

    mikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization.

    Most self-hosted software can be installed using Docker, a packaging system which allows software to bundle their configuration and dependencies. Shipwright is a WebUI to generate templates for Yacht, Portainer, Docker-Compose, and Unraid. Dozzle is a small lightweight application with a web based interface to monitor Docker logs. Diun is a tool that receive notifications when a Docker image is updated.

  4. 4
    Article
    Avatar of laravelLaravel·4y

    Forge: Dark Mode

    dark mode can be toggled between light, dark, or automatically switch between modes. We're releasing dark mode as a beta feature and will continue to improve it based on your feedback. If you don’t have a Forge account, now is a great time to sign up!

  5. 5
    Article
    Avatar of communityCommunity Picks·4y

    How we simplified MySQL Tuning to improve Laravel Performance

    The Releem - MySQL Performance Tuning is the first step before optimizing code to improve the performance of web applications. It is faster than optimizing and testing source code. Before you start tuning, you should read the documentation, "best practices", and check the efficiency of your current MySQL configuration.

  6. 6
    Article
    Avatar of freecodecampfreeCodeCamp·4y

    What is an ORM – The Meaning of Object Relational Mapping Database Tools

    Object Relational Mapping (ORM) is a technique used in creating a "bridge" between object-oriented programs and relational databases. The ORM and ORM tools help simplify the interaction between relational databases and different OOP languages. The tools are built to eliminate the possibility of SQL injection attacks.

  7. 7
    Article
    Avatar of systemweaknessSystem Weakness·4y

    MySQL Packet Injection

    I recommend to everyone this tool the best for network attacks. It gives many errors with issues of versions and Python libraries, the creators recommend using Python 3.7.7.

  8. 8
    Article
    Avatar of singlestoreSingleStore·4y

    Speed Up Database Queries MySQL

    The airportdb database is 2GB in size and consists of 14 tables containing a total of 55,983,205 records. You must execute the EXPLAIN command on the query that you want to optimize.

  9. 9
    Article
    Avatar of linuxhandbookLinux Handbook·4y

    How to Install LOMP Stack on Ubuntu

    A LOMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web applications. This tutorial will show you how to install a LEMP stack on an Ubuntu 22.04 server. MariaDB is a drop-in replacement for the MySQL database server. These options include removing anonymous users, disallowing remote root login, and removing the test databases, etc.