Best of MySQL — 2022
- 1
- 2
Honeypot·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.
- 3
Quastor 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.
- 4
Pointer·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.
- 5
The Architecture of Facebook's Distributed Message Queue
Facebook Ordered Queue Service (FOQS) is an internal Facebook tool that fills that role. FOQS provides an API that consists of the following operations - Enqueue - Add an item Dequeue The dequeue API accepts a collection of (topic, count) pairs where count represents the number of items to return from the topic.
- 6
DEV·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
EverSQL·4y
How I became a better CTO using these 8 resources
Google offers 25 lessons, 30+ exercises, real case studies, and lectures from Google experts. The SaaS CTO Security Checklist provides actionable security best practices CTOs can use to harden their security. JavaScript is a bird's eye view of JavaScript, its benefits, patterns, and more.
- 8
LogRocket·4y
Creating dashboards in React with React Dashboard
The Flatologic dashboard template is built with React, Bootstrap, React Router, Redux, and GraphQL. It comes with a React frontend and a Node.js backend. This tutorial will cover how to create a dashboard in three easy steps. We will connect it to an SQL database with MAMP so you have some local data.
- 9
Hacker News·4y
dolthub/dolt: Dolt – It's Git for Data
Dolt is a single 68 megabyte program. It can be used to run queries or update the data using SQL commands. All the commands you know for Git work exactly the same for Dolt. We also built DoltHub, a place to share Dolt databases. If you want to host your own version of Dolt, we have DoltLab.
- 10
- 11
DZone·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.
- 12
- 13
Community 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.
- 14
- 15
Changelog·4y
mgramin/awesome-db-tools: Everything that makes working with databases easier
Awesome Database Tools is a community driven list of database tools that simplify working with databases for DBA, DevOps, Developers and mere mortals. Feel free to add information about your own db-tools or your favorite third-party db- tools. For updates on awesome-db-tools and thoughts/news about databases/tools/SQL follow me at @GraminMaksim.
- 16
PlanetScale·3y
What is a query planner?
queries with lots of tables and lots of indexes can quickly run into the thousands and even millions of alternatives. Choosing the right indexes to use, and the right order to fetch data in, proves to be the difference between a 10ms and 5s query. The planner's job is to find the best possible query plan among all possibilities.
- 17
- 18
Section·4y
Creating Dashboards in React using React Dashboards
React Dashboard is a free and premium dashboard template from Flatologic. It is built with React, Bootstrap, React Router, Redux, and GraphQL. It comes with a React frontend and a Node.js backend. This tutorial will cover how to create a dashboard in three easy steps. Then, we will connect it to an SQL database with MAMP.
- 19
How Canva Stores Tens of Billions of User Generated Media
How Canva Stores Tens of Billions of User Generated Media Canva is an online design platform with tens of millions of users. The company has more than 100 million monthly active users, who collectively upload more than 50 million new pieces of media (pictures, videos, logos, etc.) every day.
- 20
freeCodeCamp·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.
- 21
turns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs.
NocoDB turns any database into a smart-spreadsheet. It uses Docker, Git, Npm, Slack, Reddit, and Twitter. NocoDB can search, sort, filter, hide columns with uber ease. It can also upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze)
- 22
Open Source Way·4y
Monitor your databases with this open source tool
Percona Monitoring and Measurement (PMM) is an open source solution for all three databases. The documentation is well written, detailed, and handy. The software itself is easy to obtain and install. PMM is only monitoring the underlying system and the database it uses for gathering statistics.
- 23
- 24
- 25
Detailed Way To Implement MySQL In NestJS
NestJS is a framework for building scalable Node.js server-side applications. It combines the support for Object-Oriented Programming (OOP), Functional Programming (FP) and Functional Reactive Programming (FRP) NestJS has full TypeScript support and uses it primarily, but users can also use JavaScript. For a read operation let’s create getUsers() method.
