{"id":93089,"date":"2020-09-03T01:42:16","date_gmt":"2020-09-02T23:42:16","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota"},"modified":"2020-09-03T01:42:16","modified_gmt":"2020-09-02T23:42:16","slug":"awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","title":{"rendered":"Creating Your Own Awesome List, or GitHub Instead of a Notebook","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/41d7ca428261b80f365797a19c547000.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Hello, Habr! We all probably have that file where we stash useful and interesting things for ourselves. Some links to articles, books, repositories, manuals. These can be bookmarks in a browser or even just open tabs left for later. Over time, all of this accumulates, links stop working, and a large portion of the materials simply becomes outdated. <\/p>\n<p><\/p>\n<p>What if you share this valuable resource with the community and upload this file to GitHub? Then your efforts could be useful to someone else, and maintaining relevance could be done collectively by accepting updates from willing contributors through the good old PRs. This project is intended for just that. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">Awesome lists<\/a><\/noindex>is for. It ranks in the top 10 GitHub repositories with 138K stars, and a link to your work could end up right in its main README, attracting a huge audience to your creations. However, it will require a bit of effort. I want to share my experience in such endeavors with you. <\/p>\n<p><\/p>\n<p>My name is Maxim Gramin. At KROK, I work on Java development and research in the field of databases. In this post, I will explain what Awesome Lists are and how to create your own official awesome repository.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"chto-takoe-awesome-lists\">What are Awesome Lists<\/h2>\n<p><\/p>\n<p>When I need to get to grips with a new technology or programming language, the first place I go is here \u2014 I find the relevant section and suitable lists. Judging by the number of stars and their constant growth, I\u2019m not the only one who does this.<br \/>\n<img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/383d1f4d5126fe2a11d449cf5e83b576.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>In fact, it is just an ordinary flat readme.md that lives in a separate <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">the repository<\/a><\/noindex>, currently holding 8th place among all GitHub repositories and including links to other lists dedicated to specific topics. For example, in the Programming Languages section, you can find lists like Awesome Python and Awesome Go, and in Front-End Development, there is an abundance of resources for web development. And, of course, there\u2019s the section <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome#databases\">Databases<\/a><\/noindex> (which we will return to shortly). And yes, all of this is not limited to just technical topics. For instance, in the Entertainment and Gaming sections, you can find a lot of interesting things (personally, I was pleased by <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/RichardLitt\/awesome-fantasy\">awesome-fantasy<\/a><\/noindex>).<br \/>\nThe main feature is that all these lists are curated not by the author alone, but by the community and are compiled according to a special and very strict <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/blob\/main\/awesome.md\">awesome manifesto<\/a><\/noindex>. Each of these lists is a self-contained community of professionals, living its own life and open to your pull requests, which will make it even better. Additionally, anyone can create their own list if a certain topic has not yet been covered.<\/p>\n<p><\/p>\n<p>The author of the idea and coordinator of all this is the legendary Sindre Sorhus, <noindex><a rel=\"nofollow\" href=\"https:\/\/gitstar-ranking.com\/users\">the first person on GitHub<\/a><\/noindex>the author of more than <noindex><a rel=\"nofollow\" href=\"https:\/\/www.npmjs.com\/~sindresorhus\">1000 npm modules,<\/a><\/noindex>and it is he who will accept your PRs.<br \/>\n<img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/6e5e9416b5f97ef4c0c9f00a3fb21f19.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<h2 id=\"kak-popast-v-awesome-list\">How to enter the awesome list<\/h2>\n<p><\/p>\n<p>If you haven't found a suitable list on the topic that interests you, that's the first sign that you need to make it yourself!<\/p>\n<p><\/p>\n<p>I'll explain using my own project as an example, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools.<\/a><\/noindex> In each project, I have to work with various databases, and that's why I created a file where I gathered useful tools for working with them, various DB migrators, IDEs, admin panels, monitoring tools, and so on. Tools that I have already used or was planning to start using. I shared this file with colleagues at KROK and beyond. This helped many and was interesting. Ultimately, I wanted more recognition when I noticed that there was no list on this topic in the Databases section. So, I decided to add mine. <\/p>\n<p><\/p>\n<p><strong>What do you need for this?<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Register a regular GitHub repo with a name like awesome-something. In my case, it was awesome-database-tools.<\/li>\n<li>Bring your list to the awesome format with the help of <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dar5hak\/generator-awesome-list\">generator-awesome-list,<\/a><\/noindex>which will generate all the necessary files in the required format.<\/li>\n<li>Set up a real CI. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome-lint\">awesome-lint<\/a><\/noindex> and Travis CI will help us monitor the <noindex><a rel=\"nofollow\" href=\"https:\/\/travis-ci.org\/github\/mgramin\/awesome-db-tools\">validity<\/a><\/noindex> of our list.<\/li>\n<li>Wait 30 days. <\/li>\n<li>We review at least 2 other people's PRs.<\/li>\n<li>And finally, make a PR to the main repo, where you add a link to your repo. Here, it's essential to read everything carefully and thoroughly meet all the numerous requirements for the new list and the PR itself.<\/li>\n<\/ol>\n<p><\/p>\n<p>My first attempt <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1336\">was unsuccessful.<\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/196dd3f494d5e91eaa7af49e16f74393.jpeg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nBut some time passed, I gathered even more material, worked on my mistakes, and dared to make a <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1679\">second attempt.<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>However, I forgot one very important thing, which was gently hinted at to me:<br \/>\n<img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/0ec0a33b3c7bb15b6cce6bf076208f09.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>I was not very attentive and did not add the unicorn as confirmation that all conditions were met.<br \/>\n<img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/3a69eb82ca26310c78bf5f6c3c8ef383.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Then a little more time passed, a few more corrections were made based on the remarks, and the long-awaited <noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/awesome__re\/status\/1246779641475424256\">tweet<\/a><\/noindex>, announcing that my PR was accepted.<\/p>\n<p><\/p>\n<p>That's how I became the author of my first list, and I started receiving <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools\/pulls?q=is%3Apr+is%3Aclosed\">PRs<\/a><\/noindex> from the community to add new tools. Many of them are already included in <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools.<\/a><\/noindex>. If you're too lazy to click the link, <\/p>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">here's the current list at the time of the post's publication<\/b><\/p>\n<h1 id=\"awesome-database-tools-awesomehttpsawesomerebadgesvghttpsawesomere\">Awesome Database Tools. <noindex><a rel=\"nofollow\" href=\"https:\/\/awesome.re\"><img decoding=\"async\" alt=\"Creating Your Own Awesome List, or GitHub Instead of a Notebook\" src=\"\/wp-content\/uploads\/2020\/09\/2951c443e95e3c56f93fb685afed6115.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/h1>\n<p><\/p>\n<blockquote><p>Community driven list of database tools<\/p><\/blockquote>\n<p>Here we will collect information about great useful and experimental tools that simplify working with databases for DBAs, DevOps, Developers, and regular users.<\/p>\n<p><\/p>\n<p>Feel free to add information about your own db-tools or your favorite third-party db-tools.<\/p>\n<p><\/p>\n<h2 id=\"contents\">Contents<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#ide\">IDE<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#gui-managersclients\">GUI Managers\/Clients<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#cli-tools\">CLI tools<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#db-schema-navigation-and-visualization\">DB-schema navigation and visualization<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#modelers\">Modelers<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#migration-tools\">Migration tools<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-generation-tools\">Code generation tools<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#wrappers\">Wrappers<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#backup-tools\">Backup tools<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#replicationdata-operation\">Replication\/Data operation<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#scripts\">Scripts<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#monitoringstatisticsperfomance\">Monitoring\/Statistics\/Performance<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#zabbix\">Zabbix<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#testing\">Testing<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#data-generator\">Data generator<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#administration\">Administration<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#hafailoversharding\">HA\/Failover\/Sharding<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#kubernetes\">Kubernetes<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#configuration-tuning\">Configuration Tuning<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">DevOps<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#schema-samples\">Schema samples<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#reporting\">Reporting<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#distributions\">Distributions<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#security\">Security<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-formatters\">Code formatters<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"ide\">IDE<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/anysql\/maestro\">AnySQL Maestro<\/a><\/noindex> \u2014 Premier multi-purpose admin tool for database management, control and development.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.aquafold.com\/aquadatastudio\">Aqua Data Studio<\/a><\/noindex> \u2014 Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/fishcodelib.com\/Database.htm\">Database .net<\/a><\/noindex> \u2014 Multiple database management tool with support for 20+ databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jetbrains.com\/datagrip\">DataGrip<\/a><\/noindex> \u2014 Cross-Platform IDE for Databases &amp; SQL by JetBrains.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbeaver\/dbeaver\">DBeaver<\/a><\/noindex> \u2014 Free universal database manager and SQL client.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/studio\">dbForge Studio for MySQL<\/a><\/noindex> \u2014 Universal IDE for MySQL and MariaDB database development, management, and administration.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/studio\">dbForge Studio for Oracle<\/a><\/noindex> \u2014 Powerful IDE for Oracle management, administration, and development.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/postgresql\/studio\">dbForge Studio for PostgreSQL<\/a><\/noindex> \u2014 GUI tool for managing and developing databases and objects.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/studio\">dbForge Studio for SQL Server<\/a><\/noindex> \u2014 Powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/SouthbankSoftware\/dbkoda\">dbKoda<\/a><\/noindex> \u2014 Modern (JavaScript\/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.ibexpert.net\/ibe\">IBExpert<\/a><\/noindex> \u2014 Comprehensive GUI tool for Firebird and InterBase.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HeidiSQL\/HeidiSQL\">HeidiSQL<\/a><\/noindex> \u2014 A lightweight client for managing MySQL, MSSQL, and PostgreSQL, written in Delphi.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\/products\/workbench\">MySQL Workbench<\/a><\/noindex> \u2014 MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products#navicat\">Navicat<\/a><\/noindex> \u2014 A database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\">Oracle SQL Developer<\/a><\/noindex> \u2014 Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgadmin.org\">pgAdmin<\/a><\/noindex> \u2014 The most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\/pgadmin3\">pgAdmin3<\/a><\/noindex> \u2014 Long Term Support for pgAdmin3.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.allroundautomations.com\/products\/pl-sql-developer\">PL\/SQL Developer<\/a><\/noindex> \u2014 IDE specifically targeted at the development of stored program units for Oracle Databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/postgresql\/maestro\">PostgreSQL Maestro<\/a><\/noindex> \u2014 Complete and powerful database management, admin and development tool for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/toad\/\">Toad<\/a><\/noindex> \u2014 Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.toadworld.com\/products\/toad-edge\">Toad Edge<\/a><\/noindex> \u2014 Simplified database development tool for MySQL and Postgres.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tora-tool\/tora\">TOra<\/a><\/noindex> \u2014 TOra is an open-source SQL IDE for Oracle, MySQL and PostgreSQL databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.valentina-db.com\/en\/valentina-studio-overview\">Valentina Studio<\/a><\/noindex> \u2014 Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"gui-managersclients\">GUI Managers\/Clients<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vrana\/adminer\">Adminer<\/a><\/noindex> \u2014 Database management in a single PHP file.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbvis.com\">DbVisualizer<\/a><\/noindex> \u2014 Universal database tool for developers, DBAs and analysts.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HouseOps\/HouseOps\">HouseOps<\/a><\/noindex> \u2014 Enterprise ClickHouse Ops UI for running queries, monitoring ClickHouse health and performing many other tasks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jackdb.com\">JackDB<\/a><\/noindex> \u2014 Direct SQL access to all your data, no matter where it resides.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/OmniDB\/OmniDB\">OmniDB<\/a><\/noindex> \u2014 Web tool for database management.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sosedoff\/pgweb\">Pgweb<\/a><\/noindex> \u2014 Web-based database browser for PostgreSQL, written in Go and compatible with macOS, Linux, and Windows machines.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.phpliteadmin.org\">phpLiteAdmin<\/a><\/noindex> \u2014 Web-based SQLite database administration tool written in PHP, supporting SQLite3 and SQLite2.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/phpmyadmin\/phpmyadmin\">phpMyAdmin<\/a><\/noindex> \u2014 A web interface for MySQL and MariaDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.psequel.com\">psequel<\/a><\/noindex> \u2014 PSequel provides a clean and simple interface for performing common PostgreSQL tasks quickly.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/popsql.com\">PopSQL<\/a><\/noindex> \u2014 Modern, collaborative SQL editor for your team.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/eggerapps.at\/postico\">Postico<\/a><\/noindex> \u2014 A modern PostgreSQL client for macOS.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Studio3T\/robomongo\">Robo 3T<\/a><\/noindex> \u2014 Robo 3T (formerly Robomongo) is a shell-centric, cross-platform MongoDB management tool.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sequelpro\/sequelpro\">Sequel Pro<\/a><\/noindex> \u2014 Sequel Pro is a fast, easy-to-use database management application for working with MySQL &amp; MariaDB databases on macOS.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\">SQL Operations Studio<\/a><\/noindex> \u2014 A data management tool that enables you to work with SQL Server, Azure SQL DB, and SQL DW from Windows, macOS, and Linux.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqliteexpert.com\/index.html\">SQLite Expert<\/a><\/noindex> \u2014 Graphical interface that supports all SQLite features.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rickbergfalk\/sqlpad\">sqlpad<\/a><\/noindex> \u2014 Web-based SQL editor running in your own private cloud.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.macpostgresclient.com\">SQLPro<\/a><\/noindex> \u2014 A simple yet powerful Postgres manager for macOS.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/squirrel-sql\">SQuirreL<\/a><\/noindex> \u2014 Graphical SQL client written in Java, allowing you to view the structure of a JDBC compliant database, browse data in tables, issue SQL commands, and more.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mtxr\/vscode-sqltools\">SQLTools<\/a><\/noindex> \u2014 Database management tool for VSCode.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/sqlyog\">SQLyog<\/a><\/noindex> \u2014 The most comprehensive and user-friendly MySQL GUI available.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tabixio\/tabix\">Tabix<\/a><\/noindex> \u2014 SQL Editor &amp; open-source simple business intelligence tool for Clickhouse.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/TablePlus\/TablePlus\">TablePlus<\/a><\/noindex> \u2014 Modern, native, and user-friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite &amp; more.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.teampostgresql.com\">TeamPostgreSQL<\/a><\/noindex> \u2014 PostgreSQL web administration GUI \u2014 use your PostgreSQL databases from anywhere with a rich, lightning-fast AJAX web interface.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"cli-tools\">CLI tools<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ipython-sql\">ipython-sql<\/a><\/noindex> \u2014 Connect to a database to issue SQL commands within IPython or IPython Notebook.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/laixintao\/iredis\">iredis<\/a><\/noindex> \u2014 A CLI tool for Redis with auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/lesovsky\/pgcenter\">pgcenter<\/a><\/noindex> \u2014 Top-like admin tool for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/julmon\/pg_activity\">pg_activity<\/a><\/noindex> \u2014 Top-like application for monitoring PostgreSQL server activity.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/markwkm\/pg_top\">pg_top<\/a><\/noindex> \u2014 'top' for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/okbob\/pspg\">pspg<\/a><\/noindex> \u2014 Postgres Pager.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sqlcl\/overview\/index.html\">SQLcl<\/a><\/noindex> \u2014 Oracle SQL Developer Command Line (SQLcl) is a free command-line interface for Oracle Database.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql\">usql<\/a><\/noindex> \u2014 A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql#database-support\">and many other databases<\/a><\/noindex> including NoSQL and non-relational databases!<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"dbcli\">dbcli<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/athenacli\">athenacli<\/a><\/noindex> \u2014 AthenaCLI is a CLI tool for the AWS Athena service that offers auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/litecli\">litecli<\/a><\/noindex> \u2014 CLI for SQLite databases with auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mssql-cli\">mssql-cli<\/a><\/noindex> \u2014 A command-line client for SQL Server, featuring auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a><\/noindex> \u2014 A terminal client for MySQL with auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a><\/noindex> \u2014 Postgres CLI with auto-completion and syntax highlighting.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/vcli\">vcli<\/a><\/noindex> \u2014 Vertica CLI with auto-completion and syntax highlighting.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"db-schema-navigation-and-visualization\">DB-schema navigation and visualization<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/dbdiagram.io\">dbdiagram.io<\/a><\/noindex> \u2014 Quick and simple tool that helps you draw your database relationship diagrams and flows using a simple DSL language.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Alexis-benoist\/eralchemy\">ERAlchemy<\/a><\/noindex> \u2014 Entity Relation Diagrams generation tool.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemacrawler\/SchemaCrawler\">SchemaCrawler<\/a><\/noindex> \u2014 A free tool for database schema discovery and comprehension.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemaspy\/schemaspy\">Schema Spy<\/a><\/noindex> \u2014 Generates HTML documentation for your database, including entity relationship diagrams.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/k1LoW\/tbls\">tbls<\/a><\/noindex> \u2014 CI-friendly tool for documenting a database, written in Go.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"modelers\">Modelers<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-data-modeler\">Navicat Data Modeler<\/a><\/noindex> \u2014 A powerful and cost-effective database design tool that helps you build high-quality conceptual, logical, and physical data models.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/datamodeler\/overview\/index.html\">Oracle SQL Developer Data Modeler<\/a><\/noindex> \u2014 Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgmodeler\/pgmodeler\">pgmodeler<\/a><\/noindex> \u2014 Data modeling tool designed specifically for PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"migration-tools\">Migration tools<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CourseOrchestra\/2bass\">2bass<\/a><\/noindex> \u2014 Database configuration-as-code tool that utilizes the concept of idempotent DDL scripts.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flyway\/flyway\">flyway<\/a><\/noindex> \u2014 Database migration tool.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/github\/gh-ost\">gh-ost<\/a><\/noindex> \u2014 Online schema migration tool for MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/liquibase\/liquibase\">liquibase<\/a><\/noindex> \u2014 A database-independent library for tracking, managing, and applying database schema changes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/djrobstep\/migra\">migra<\/a><\/noindex> \u2014 Similar to diff, but for PostgreSQL schemas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/salsita\/node-pg-migrate\">node-pg-migrate<\/a><\/noindex> \u2014 A Node.js database migration management tool built exclusively for PostgreSQL. (It can also be used for other databases conforming to SQL standards \u2014 such as CockroachDB.)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/perseas\/Pyrseas\">Pyrseas<\/a><\/noindex> \u2014 Provides utilities for describing a PostgreSQL database schema in YAML format.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemahero\/schemahero\">SchemaHero<\/a><\/noindex> \u2014 A Kubernetes operator for declarative database schema management (gitOps for database schemas).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqitchers\/sqitch\">Sqitch<\/a><\/noindex> \u2014 A sensible database-native change management tool for framework-free development and reliable deployment.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rdagumampan\/yuniql\">yuniql<\/a><\/noindex> \u2014 Another schema versioning and migration tool designed specifically for .NET Core 3.0+ with improved functionality.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-generation-tools\">Code generation tools<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ddl-generator\">ddl-generator<\/a><\/noindex> \u2014 Infers SQL DDL (Data Definition Language) from table data.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/qwazer\/scheme2ddl\">scheme2ddl<\/a><\/noindex> \u2014 Command line utility for exporting Oracle schemas to a set of DDL initialization scripts, with options to filter out unnecessary information and separate DDL into different files while formatting output neatly.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"wrappers\">Wrappers<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dreamfactorysoftware\/dreamfactory\">DreamFactory<\/a><\/noindex> \u2014 An open-source REST API backend for mobile, web, and IoT applications.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/graphql-engine\">Hasura GraphQL Engine<\/a><\/noindex> \u2014 Lightning-fast, real-time GraphQL APIs on PostgreSQL with fine-grained access control, capable of triggering webhooks on database events.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/avz\/jl-sql\">jl-sql<\/a><\/noindex> \u2014 SQL designed for JSON and CSV streams.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/EnterpriseDB\/mysql_fdw\">mysql_fdw<\/a><\/noindex> \u2014 PostgreSQL foreign data wrapper for MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/rest-data-services\">Oracle REST Data Services<\/a><\/noindex> \u2014 A mid-tier Java application that maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions, returning results formatted in JSON.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prismagraphql\/prisma\">Prisma<\/a><\/noindex> \u2014 Prisma transforms your database into a real-time GraphQL API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgREST\/postgrest\">PostgREST<\/a><\/noindex> \u2014 A REST API for any PostgreSQL database.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prest\/prest\">prest<\/a><\/noindex> \u2014 Provides a way to serve a RESTful API from any database through Go.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/restsql\/restsql\">restSQL<\/a><\/noindex> \u2014 SQL generator featuring Java and HTTP APIs, utilizing a straightforward RESTful HTTP API with XML or JSON serialization.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/formio\/resquel\">resquel<\/a><\/noindex> \u2014 Easily convert your SQL database into a REST API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jeffknupp\/sandman2\">sandman2<\/a><\/noindex> \u2014 Automatically generates a RESTful API service for your legacy database.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CrocInc\/sql-boot\">sql-boot<\/a><\/noindex> \u2014 An advanced REST and UI wrapper for your SQL queries.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"backup-tools\">Backup tools<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgbackrest\/pgbackrest\">pgbackrest<\/a><\/noindex> \u2014 A reliable solution for PostgreSQL backup and restore tasks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndquadrant-it\/barman\">BaRMan<\/a><\/noindex> \u2014 Backup and Recovery Manager for PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"replicationdata-operation\">Replication\/Data operation<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/simonw\/datasette\">Datasette<\/a><\/noindex> \u2014 A tool for exploring and publishing data.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/actiontech\/dtle\">dtle<\/a><\/noindex> \u2014 A Distributed Data Transfer Service for MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgsync\">pgsync<\/a><\/noindex> \u2014 Synchronizes PostgreSQL data between different databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/the4thdoctor\/pg_chameleon\">pg_chameleon<\/a><\/noindex> \u2014 A MySQL to PostgreSQL replication system developed in Python 3. This system uses the mysql-replication library to pull row images from MySQL, storing them in PostgreSQL as JSONB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/pgdeltastream\">PGDeltaStream<\/a><\/noindex> \u2014 A Golang web server that streams PostgreSQL changes at least-once over websockets, using the logical decoding feature of PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndQuadrant\/repmgr\">repmgr<\/a><\/noindex> \u2014 The most popular replication manager for PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"scripts\">Scripts<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgexperts\/pgx_scripts\">pgx_scripts<\/a><\/noindex> \u2014 A collection of handy scripts for database analysis and administration, created by our team at PostgreSQL Experts.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ioguix\/pgsql-bloat-estimation\">pgsql-bloat-estimation<\/a><\/noindex> \u2014 Queries designed to measure statistical bloat in PostgreSQL indexes and tables.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/depesz\/pgWikiDont\">pgWikiDont<\/a><\/noindex> \u2014 An SQL test that evaluates if your database adheres to the guidelines from <noindex><a rel=\"nofollow\" href=\"https:\/\/wiki.postgresql.org\/wiki\/Don&#039;t_Do_This\">https:\/\/wiki.postgresql.org\/wiki\/Don&#8217;t_Do_This<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dataegret\/pg-utils\">pg-utils<\/a><\/noindex> \u2014 Useful utilities for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrescheatsheet.com\">Postgres cheat sheet<\/a><\/noindex> \u2014 Helpful SQL scripts and commands from .<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/NikolayS\/postgres_dba\">postgres_dba<\/a><\/noindex> \u2014 A comprehensive set of useful tools for PostgreSQL DBAs and engineers.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gist.github.com\/rgreenjr\/3637525\">postgres_queries_and_commands.sql<\/a><\/noindex> \u2014 A collection of useful PostgreSQL queries and commands.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tanelpoder\/tpt-oracle\">TPT<\/a><\/noindex> \u2014 These SQL*Plus scripts are designed for optimizing and troubleshooting Oracle Database performance.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"monitoringstatisticsperfomance\">Monitoring\/Statistics\/Performance<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/akardapolov\/ASH-Viewer\">ASH Viewer<\/a><\/noindex> \u2014 Provides a graphical view of active session history data within Oracle and PostgreSQL databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/monyog\">Monyog<\/a><\/noindex> \u2014 An agentless and cost-effective MySQL monitoring tool.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/mssql-monitoring\">mssql-monitoring<\/a><\/noindex> \u2014 Monitors SQL Server performance on Linux using collectd, InfluxDB, and Grafana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-monitor\">Navicat Monitor<\/a><\/noindex> \u2014 A safe, straightforward, and agentless remote server monitoring tool packed with features to enhance your monitoring effectiveness.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/pmm\">Percona Monitoring and Management<\/a><\/noindex> \u2014 Open source platform for managing and monitoring MySQL and MongoDB performance.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pganalyze\/collector\">pganalyze collector<\/a><\/noindex> \u2014 Pganalyze statistics collector for gathering PostgreSQL metrics and log data.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/postgres-ai\/postgres-checkup\">postgres-checkup<\/a><\/noindex> \u2014 New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/wrouesnel\/postgres_exporter\">postgres_exporter<\/a><\/noindex> \u2014 Prometheus exporter for PostgreSQL server metrics.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgdash.io\">pgDash<\/a><\/noindex> \u2014 Measure and track every aspect of your PostgreSQL databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pghero\">PgHero<\/a><\/noindex> \u2014 A performance dashboard for Postgres \u2014 health checks, suggested indexes, and more.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rapidloop\/pgmetrics\">pgmetrics<\/a><\/noindex> \u2014 Collect and display information and stats from a running PostgreSQL server.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgmustard.com\">pgMustard<\/a><\/noindex> \u2014 A user interface for Postgres explain plans, plus tips to improve performance.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gleu\/pgstats\">pgstats<\/a><\/noindex> \u2014 Collects PostgreSQL statistics, and either saves them in CSV files or prints them on the stdout.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cybertec-postgresql\/pgwatch2\">pgwatch2<\/a><\/noindex> \u2014 Flexible self-contained PostgreSQL metrics monitoring\/dashboarding solution.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/telegraf\/tree\/master\/plugins\/inputs\/postgresql\">Telegraf PostgreSQL plugin<\/a><\/noindex> \u2014 Provides metrics for your postgres database.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"zabbix\">Zabbix<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">Mamonsu<\/a><\/noindex> \u2014 Monitoring agent for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.smartmarmot.com\/wiki\/index.php?title=Orabbix\">Orabbix<\/a><\/noindex> \u2014 Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pg-monz\/pg_monz\">pg_monz<\/a><\/noindex> \u2014 This is the Zabbix monitoring template for PostgreSQL Database.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/bicofino\/Pyora\">Pyora<\/a><\/noindex> \u2014 Python script to monitor Oracle Databases.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/anetrusov\/ZabbixDBA\">ZabbixDBA<\/a><\/noindex> \u2014 ZabbixDBA is a fast, flexible, and continuously developing plugin to monitor your RDBMS.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"testing\">Testing<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbfit\/dbfit\">DbFit<\/a><\/noindex> \u2014 A database testing framework that supports easy test-driven development of your database code.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dimitri\/regresql\">RegreSQL<\/a><\/noindex> \u2014 Regression testing your SQL queries.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"data-generator\">Data generator<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/benerator\">Databene Benerator<\/a><\/noindex> \u2014 It is a framework for generating realistic and valid high-volume test data for your system under test (avoiding the Datalite anti-pattern).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/data-generator\">dbForge Data Generator for MySQL<\/a><\/noindex> \u2014 Powerful GUI tool for creating massive volumes of realistic test data.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/data-generator\">dbForge Data Generator for Oracle<\/a><\/noindex> \u2014 Small but mighty GUI tool for populating Oracle schemas with tons of realistic test data.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/data-generator\">dbForge Data Generator for SQL Server<\/a><\/noindex> \u2014 Powerful GUI tool for a fast generation of meaningful test data for databases.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"administration\">Administration<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dalibo\/pgbadger\">pgbadger<\/a><\/noindex> \u2014 A fast PostgreSQL Log Analyzer.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Squarespace\/pgbedrock\">pgbedrock<\/a><\/noindex> \u2014 Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgslice\">pgslice<\/a><\/noindex> \u2014 Postgres partitioning as easy as pie.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"hafailoversharding\">HA\/Failover\/Sharding<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/citus\">Citus<\/a><\/noindex> \u2014 Postgres extension that distributes your data and your queries across multiple nodes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/patroni\">patroni<\/a><\/noindex> \u2014 A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/percona-xtradb-cluster\">Percona XtraDB Cluster<\/a><\/noindex> \u2014 A High Scalability Solution for MySQL Clustering and High Availability.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sorintlab\/stolon\">stolon<\/a><\/noindex> \u2014 Cloud native PostgreSQL manager for PostgreSQL high availability.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/pg_auto_failover\">pg_auto_failover<\/a><\/noindex> \u2014 Postgres extension and service for automated failover and high-availability.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/aiven\/pglookout\">pglookout<\/a><\/noindex> \u2014 PostgreSQL replication monitoring and failover daemon.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClusterLabs\/PAF\">PostgreSQL Automatic Failover<\/a><\/noindex> \u2014 High-Availability for Postgres, based on industry references Pacemaker and Corosync.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitabaks\/postgresql_cluster\">postgresql_cluster<\/a><\/noindex> \u2014 PostgreSQL High-Availability Cluster (based on \"Patroni\" and \"DCS(etcd)\"). Automating deployment with Ansible.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitessio\/vitess\">Vitess<\/a><\/noindex> \u2014 Database clustering system for horizontal scaling of MySQL through generalized sharding.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"kubernetes\">Kubernetes<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/kubedb.com\">KubeDB<\/a><\/noindex> \u2014 Making running production-grade databases easy on Kubernetes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/postgres-operator\">Postgres operator<\/a><\/noindex> \u2014 The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/spilo\">Spilo<\/a><\/noindex> \u2014 HA PostgreSQL Clusters with Docker.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/ongresinc\/stackgres\">StackGres<\/a><\/noindex> \u2014 Enterprise-grade, Full Stack PostgreSQL on Kubernetes.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"configuration-tuning\">Configuration Tuning<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/major\/MySQLTuner-perl\">MySQLTuner-perl<\/a><\/noindex> \u2014 Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgconfigurator.cybertec-postgresql.com\">PGConfigurator<\/a><\/noindex> \u2014 Free online tool to generate an optimized <code>postgresql.conf<\/code>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gregs1104\/pgtune\">pgtune<\/a><\/noindex> \u2014 PostgreSQL configuration wizard.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jfcoz\/postgresqltuner\">postgresqltuner.pl<\/a><\/noindex> \u2014 A simple script to analyze your PostgreSQL database configuration and provide tuning recommendations.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"devops\">DevOps<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbmaestro.com\">DBmaestro<\/a><\/noindex> \u2014 DBmaestro accelerates release cycles and supports agility across the entire IT ecosystem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/products\/toad-devops-toolkit\/\">Toad DevOps Toolkit<\/a><\/noindex> \u2014 The Toad DevOps Toolkit performs essential database development functions within your DevOps workflow\u2014without compromising quality, performance, or reliability.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"schema-samples\">Schema samples<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/oracle\/db-sample-schemas\">Oracle Database Sample Schemas<\/a><\/noindex> \u2014 Oracle Database Sample Schemas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"reporting\">Reporting<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/shzlw\/poli\">Poli<\/a><\/noindex> \u2014 An easy-to-use SQL reporting tool designed for SQL enthusiasts.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"distributions\">Distributions<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/datacharmer\/dbdeployer\">DBdeployer<\/a><\/noindex> \u2014 A tool that simplifies the deployment of MySQL database servers.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlcollaborative\/dbatools\">dbatools<\/a><\/noindex> \u2014 A PowerShell module that can be seen as a command-line version of SQL Server Management Studio.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgresApp\/PostgresApp\">Postgres.app<\/a><\/noindex> \u2014 A full-featured PostgreSQL installation packaged as a standard Mac application.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\">BigSQL<\/a><\/noindex> \u2014 A developer-friendly distribution of Postgres.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/credativ\/elephant-shed\">Elephant Shed<\/a><\/noindex> \u2014 A web-based PostgreSQL management front-end that integrates several utilities and applications for PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"security\">Security<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cossacklabs\/acra\">Acra<\/a><\/noindex> \u2014 Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side (\"transparent\") encryption. SQL, NoSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-formatters\">Code formatters<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/antlr\/codebuff\">CodeBuff<\/a><\/noindex> \u2014 Language-agnostic pretty-printing powered by machine learning.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"contributing\">Contributing<\/h2>\n<p><\/p>\n<ul>\n<li>Your contributions are always welcome! Please read the <noindex><a rel=\"nofollow\" href=\"http:\/\/contributing.md\">contribution guidelines<\/a><\/noindex> first.<\/li>\n<\/ul>\n<p><\/p>\n<p>If you have findings for databases, share them. I would also appreciate feedback\u2014PRs and stars are welcome. If you have questions about creating your own lists, feel free to reach out.<\/p>\n<p>Source: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/croc\/blog\/496594\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041d\u0430\u0432\u0435\u0440\u043d\u043e\u0435, \u0443 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0438\u0437 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u0442\u0430\u043a\u043e\u0439 \u0444\u0430\u0439\u043b\u0438\u043a, \u043a\u0443\u0434\u0430 \u043c\u044b \u043f\u0440\u0438\u043f\u0440\u044f\u0442\u044b\u0432\u0430\u0435\u043c \u0447\u0442\u043e-\u0442\u043e \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0435 \u0438 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0435 \u0434\u043b\u044f \u0441\u0435\u0431\u044f. \u041a\u0430\u043a\u0438\u0435-\u0442\u043e \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0441\u0442\u0430\u0442\u044c\u0438, \u043a\u043d\u0438\u0433\u0438, \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438, \u043c\u0430\u043d\u0443\u0430\u043b\u044b. \u042d\u0442\u043e \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043a\u043b\u0430\u0434\u043a\u0438 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0438\u043b\u0438 \u0434\u0430\u0436\u0435 \u043f\u0440\u043e\u0441\u0442\u043e \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0435 \u0432\u043a\u043b\u0430\u0434\u043a\u0438, \u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u0430 \u043f\u043e\u0442\u043e\u043c. \u0421\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0432\u0441\u0435 \u044d\u0442\u043e \u0440\u0430\u0437\u0431\u0443\u0445\u0430\u0435\u0442, \u0441\u0441\u044b\u043b\u043a\u0438 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u044e\u0442 \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0442\u044c\u0441\u044f, \u0430 \u0431\u043e\u043b\u044c\u0448\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u043e\u0432 \u043f\u0440\u043e\u0441\u0442\u043e \u0443\u0441\u0442\u0430\u0440\u0435\u0432\u0430\u0435\u0442. \u0410 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":93090,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-93089","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Awesome-\u043b\u0438\u0441\u0442 \u0441\u0432\u043e\u0438\u043c\u0438 \u0440\u0443\u043a\u0430\u043c\u0438, \u0438\u043b\u0438 GitHub \u0432\u043c\u0435\u0441\u0442\u043e \u0431\u043b\u043e\u043a\u043d\u043e\u0442\u0430 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-09-02T23:42:16+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-02T23:42:16+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47An awesome list created by you, or GitHub instead of a notebook | ProHoster","description":"Hello, Habr!","canonical_url":"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"en_US","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47Awesome-\u043b\u0438\u0441\u0442 \u0441\u0432\u043e\u0438\u043c\u0438 \u0440\u0443\u043a\u0430\u043c\u0438, \u0438\u043b\u0438 GitHub \u0432\u043c\u0435\u0441\u0442\u043e \u0431\u043b\u043e\u043a\u043d\u043e\u0442\u0430 | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!","og:url":"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-09-02T23:42:16+00:00","article:modified_time":"2020-09-02T23:42:16+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"93089","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 11:55:35","updated":"2022-09-28 06:26:02","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/93089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/comments?post=93089"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/93089\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media\/93090"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media?parent=93089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/categories?post=93089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/tags?post=93089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}