Talofa, Habr! Masalo, e tofu i tatou ma se faila e natia ai se mea aoga ma manaia mo i tatou lava. O nisi feso'ota'iga i tala, tusi, fale teu oloa, tusi lesona. O nei mea e mafai ona avea ma fa'ailoga tusi su'esu'e pe na'o na'o le tatalaina o laupepa e tu'u mo se taimi mulimuli ane. I le aluga o taimi, o nei mea uma e fulafula, fesoʻotaʻiga e taofi le tatalaina, ma o le tele o mea e faʻaaogaina ua le toe aoga.

Ae faʻapefea pe a tatou faʻasoa atu lenei lelei i le alalafaga ma faʻasalalau lenei faila ile GitHub? Ona mafai lea ona aoga lau galuega i se isi tagata, ma e mafai ona e faatumauina le talafeagai faatasi, talia faʻamatalaga mai ia i latou e manaʻo e ala i PR tuai lelei. O le mea tonu lava lea ua mamanuina ai le poloketi. Lisi mata'utia. O loʻo aofia i totonu o le TOP 10 GitHub repositories, e 138K fetu, ma o se fesoʻotaʻiga i au galuega e mafai ona faʻaalia saʻo i lona aʻa README, lea o le a tosina mai ai le toʻatele o tagata i lau galuega. E moni, o lenei mea o le a manaʻomia ai sina taumafaiga. Ou te fia faasoa atu lo'u aafiaga i ia taumafaiga ia te outou.

O loʻu igoa o Maxim Gramin. I le CROC ou te faia Java atinaʻe ma suʻesuʻega faʻamaumauga. I lenei pou, o le a ou taʻu atu ia te oe le a le Awesome Lists ma pe faʻafefea ona fai lau lava repo mataʻutia.

O a Lisi Matagofie

A tatau ona ou suʻesuʻeina ni tekinolosi fou poʻo se gagana faʻapolokalame, o le mea muamua lava ou te alu iinei - ou te maua le vaega saʻo, ma o loʻo i ai ni laupepa talafeagai i totonu. Ma faʻamasino i le numera o fetu ma lo latou tuputupu aʻe faifaipea, e le naʻo aʻu e faia lenei mea.

O le mea moni, o se readme.md mafolafola masani, lea e nofo i se isi faleteuoloa, tulaga 8th i totonu o faleoloa GitHub uma ma e aofia ai fesoʻotaʻiga i isi laupepa faʻapitoa i soʻo se autu. Mo se faʻataʻitaʻiga, i le vaega o Polokalama Gagana e mafai ona e mauaina pepa ile Awesome Python ma Awesome Go, ma le Front-End Development o loʻo i ai le tele o punaoa ile atinaʻe WEB. Ma, ioe, - vaega utufaamatalaga faaeletonika (O le a tatou toe foi i lenei mea i se taimi mulimuli ane). Ma ioe, o nei mea uma e le gata i mataupu faʻapitoa. Mo se faʻataʻitaʻiga, i vaega Faʻafiafia ma Taaloga e mafai foi ona e mauaina le tele o mea manaia (Na ou fiafia lava mata'utia-faufaufau).
O le uiga autu o nei laupepa uma e le o tausia e le tusitala patino, ae o le alalafaga ma tuʻufaʻatasia e tusa ai ma se faʻapitoa ma le faʻamaoni. fa'aaliga mata'utia. O ia laupepa taʻitasi o se faʻalapotopotoga tutoʻatasi o tagata tomai faapitoa, ola i lona lava olaga ma tatala i au talosaga toso e faʻaleleia atili ai. Ma e mafai fo'i e so'o se tasi ona fai a latou lava pepa pe afai e le'i fa'asalalauina nisi autu.

O le tusitala o le manatu ma le faamaopoopo o lenei pisinisi atoa o le lauiloa Sindre Sorhus, tagata muamua ile GitHub, tusitala sili atu 1000 npm modules, ma o ia o le a mauaina lau PRs.

E faʻafefea ona e alu i se lisi mataʻutia

Afai faʻafuaseʻi e te leʻi mauaina se laupepa talafeagai i luga o se autu e te fiafia i ai, o le faʻailoga muamua lea e te manaʻomia e te faia oe lava!

O le a ou taʻu atu ia te oe e faʻaaoga ai le faʻataʻitaʻiga o laʻu faʻataʻitaʻiga. Mata'utia Meafaigaluega Fa'amaumauga - Mai le poloketi i le poloketi, e tatau ona ou galue i le tele o faʻamaumauga, ma o le mea lea na ou amataina ai se faila lea na ou aoina mai ai meafaigaluega aoga mo le galulue faʻatasi ma i latou, ituaiga uma o faʻamaumauga faʻamaumauga, IDEs, admin panels, meafaigaluega mataʻituina ma ituaiga uma. mea eseese. Meafaigaluega ua uma ona ou faʻaaogaina pe na o le fuafua e amata faʻaaoga. Na ou fa'asoaina lenei faila i a'u uo ile CROC ma tua atu. Na fesoasoani lenei mea i le tele o tagata ma sa manaia. O le iʻuga, na ou manaʻo e sili atu le taʻutaʻua i se tasi aso na ou matauina ai i le vaega o Faʻamaumauga e leai se laupepa i lenei autu. Ma sa ou filifili e faaopoopo la'u iina.

O le a le mea e manaʻomia mo lenei?

1. Matou te resitalaina se GitHub repo masani ma se igoa e pei o le mataʻutia-poʻo le a lava. I loʻu tulaga sa mataʻutia-faʻamaumauga-meafaigaluega
2. Matou te aumaia la matou pepa i le tulaga mataʻutia, o le a fesoasoani ia i matou generator-mata'utia-lisi, lea o le a gaosia uma faila manaʻomia i le faatulagaga manaʻomia
3. Faʻatulagaina se CI moni. mata'utia-lint ma travis ci o le a fesoasoani ia i tatou e pulea aoga la matou laupepa
4. Matou te faatali mo le 30 aso
5. Matou te iloiloina a itiiti ifo ma le 2 isi tagata PR's
6. Ma mulimuli ane matou faia se PR i le repo autu, lea matou te faʻaopoopoina ai se fesoʻotaʻiga i la matou repo. O iinei e te manaʻomia e faitau ma le faʻaeteete ma faʻaeteete mea uma e manaʻomia mo le laupepa fou ma le PR lava ia.

O la'u panikeke muamua ua aliali mai ua tu'u

Ae ua mavae sina taimi, sa ou aoina mai nisi mea, galue i mea sese ma lototele e fai taumafai lona lua.

Ae na galo ia te aʻu se mea taua tele, lea na faʻaali mai ia te aʻu:

Ou te leʻi faʻaeteete tele ma ou te leʻi faʻaopoopoina se unicorn e faʻamaonia ai ua ausia uma tulaga

Ona alu ai lea o sina taimi, o nai toe teuteuga e faavae i faʻamatalaga, ma mea ua leva ona faʻatali tweetna talia la'u PR.

O lea na avea ai aʻu ma tusitala o laʻu pepa muamua, ma na amata ona latou mauaina PR's mai le alalafaga e faʻaopoopo meafaigaluega fou. Ma o le tele o latou ua uma ona aofia i totonu Mata'utia Meafaigaluega Fa'amaumauga. Afai e te paie e mulimuli i le sootaga,

o le filifiliga lea i le taimi nei i le taimi o le lolomiina o le pou

Mata'utia Meafaigaluega Fa'amaumauga

Lisi fa'aalaua'itele o meafaigaluega fa'amaumauga

O iinei o le a matou aoina ai faʻamatalaga e uiga i meafaigaluega faʻataʻitaʻi aoga ma mataʻutia e faʻafaigofie i faʻamaumauga mo DBA, DevOps, Developers ma tagata ola.

Lagona le saoloto e faʻaopoopo faʻamatalaga e uiga i au lava db-tools poʻo au mea e sili ona e fiafia i ai lona tolu-party db-tools.

Mataupu

• IINEI
• GUI Pule/tagata fa'atau
• CLI meafaigaluega
• DB-schema navigation ma va'aiga
• Fa'ata'ita'iga
• Mea faigaluega femalagaiga
• Meafaigaluega fa'atupu tulafono
• Toa
• Meafaigaluega faaleoleo
• Fa'agaioiga/Fa'amatalaga
• Lisi
• Mata'ituina/Fa'amaumauga/Fa'atinoga
  • Zabbix
• tofotofoga
  • Fa'amatalaga fa'amatalaga
• pulega
• HA/Failover/Sharding
• Kubernetes
• Fa'atonu Fa'atonu
• DevOps
• Fa'ata'ita'iga ata
• lipoti
• Faʻasalaga
• Security
• Fa'ailoga tulafono

IINEI

• So'o seSQL Maestro - Tele mea faigaluega faʻapitoa faʻapitoa mo le puleaina o faʻamaumauga, pulea ma atinaʻe.
• Aqua Data Studio - O le Aqua Data Studio o le polokalama fa'akomepiuta mo Fa'amaumauga Fa'amaumauga, DBA, ma Su'esu'ega.
• Database.net - Tele meafaigaluega faʻatautaia faʻamaumauga faʻatasi ma le lagolago mo 20+ faʻamaumauga.
• fa'amaumauga - Cross-Platform IDE mo Databases & SQL e JetBrains.
• dbeaver - Pulea fa'amaumauga tu'ufa'atasi e leai se totogi ma le tagata fa'atau SQL.
• dbForge Studio mo MySQL - Universal IDE mo MySQL ma MariaDB database atinae, pulega, ma pulega.
• dbForge Studio mo Oracle - IDE malosi mo Oracle pulega, pulega, ma atinaʻe.
• dbForge Studio mo PostgreSQL - GUI meafaigaluega mo le puleaina ma le atinaʻeina o faʻamaumauga ma mea faitino.
• dbForge Studio mo le SQL Server - Malosiaga tu'ufa'atasia atina'e siosiomaga mo SQL Server atina'e, pulega, pulega, auiliiliga o faamatalaga, ma lipoti.
• dbKoda — Fa'aonaponei (JavaScript/Electron framework), tatala puna IDE mo MongoDB. O loʻo i ai foliga e lagolago ai le atinaʻe, pulega ma le faʻaogaina o faʻatinoga i luga o faʻamaumauga MongoDB.
• IBEXpert - Meafaigaluega GUI atoatoa mo Firebird ma InterBase.
• HeidiSQL - O se tagata faʻatau mama mo le puleaina o MySQL, MSSQL ma PostgreSQL, tusia i Delphi.
• mysql laulau faigaluega - MySQL Workbench o se meafaigaluega vaʻaia tuʻufaʻatasia mo tusitala faʻamaumauga, atinaʻe, ma DBA.
• navicat - O se meafaigaluega faʻapipiʻi faʻamaumauga e mafai ai ona e faʻafesoʻotaʻi i le taimi e tasi i MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, ma SQLite database mai se talosaga e tasi.
• Oracle SQL Atinaʻe — Oracle SQL Developer o se siosiomaga tau atina'e saoloto, tu'ufa'atasia e fa'afaigofie ai le atina'eina ma le fa'afoeina o le Oracle Database i tu'ufa'atasiga fa'ale-aganu'u ma le fa'aogaina o le Ao.
• pgAdmin - Le sili ona ta'uta'ua ma fa'apitoa Open Source pulega ma atina'e fa'avae mo PostgreSQL, le fa'amaumauga sili ona maualuga Open Source i le lalolagi.
• pgAdmin3 - Lagolago umi mo pgAdmin3.
• PL/SQL Developer — IDE o lo'o fa'atatau tonu ile atina'eina o iunite polokalame teuina mo Oracle Databases.
• PostgreSQL Maestro - Faʻatonu ma mamana faʻamaumauga tuʻufaʻatasia, pulega ma meafaigaluega atinaʻe mo PostgreSQL.
• Tasi - Toad o le faʻamaumauga muamua o faʻamaumauga mo tagata atiaʻe, pule ma tagata suʻesuʻe faʻamaumauga. Pulea suiga lavelave fa'amaumauga fa'atasi ma se meafaigaluega e tasi e pulea ai fa'amaumauga.
• Toad Edge - Faʻafaigofieina faʻamaumauga faʻavae meafaigaluega mo MySQL ma Postgres.
• TOra - TOra o se punaoa tatala SQL IDE mo Oracle, MySQL ma PostgreSQL dbs.
• Valentina Studio - Fausia, faʻatautaia, fesili ma suʻesuʻe Valentina DB, MySQL, MariaDB, PostgreSQL ma SQLite faʻamaumauga mo le FREE.

GUI Pule/tagata fa'atau

• Pule - Pulea fa'amaumauga i se faila PHP se tasi.
• DbVisualizer - Mea faigaluega faʻamaumauga lautele mo tagata atiaʻe, DBA ma tagata suʻesuʻe.
• HouseOps - Enterprise ClickHouse Ops UI mo oe faʻatautaia fesili, mataʻituina le soifua maloloina ClickHouse ma faʻaosofia le toʻatele o isi.
• JackDB - Fa'asa'o le SQL avanoa i au fa'amatalaga uma, tusa lava po'o fea e nofo ai.
• OmniDB - Meafaigaluega i luga ole laiga mo le puleaina o faʻamaumauga.
• Pgweb — Web-based database browser mo PostgreSQL, tusia i le Go ma galue i macOS, Linux ma Windows masini.
• phpLiteAdmin - Meafaigaluega faʻatautaia o database SQLite i luga o le upega tafaʻilagi tusia i le PHP ma le lagolago mo SQLite3 ma SQLite2.
• phpMyAdmin - O se upega tafaʻilagi mo MySQL ma MariaDB.
• fa'ailoga - O le PSequel e maua ai se atinaʻe mama ma faigofie mo oe e faʻatino ai galuega masani PostgreSQL vave.
• PopSQL - Fa'aonaponei, fa'atonu SQL fa'atasi mo lau 'au.
• Postico - Ose PostgreSQL Client mo le Mac.
• Robo 3T - Robo 3T (muamua Robomongo) o se atigi-centric cross-platform meafaigaluega pulega MongoDB.
• Sequence Pro - Sequel Pro o se faʻaoga vave, faigofie-faʻaogaina Mac faʻamaumauga faʻamaumauga mo le galulue faʻatasi ma MySQL & MariaDB database.
• SQL Operations Studio - O se meafaigaluega e pulea ai faʻamatalaga e mafai ai ona galue ma SQL Server, Azure SQL DB ma SQL DW mai Windows, macOS ma Linux.
• SQLite Tomai Faʻapitoa - Faʻamatalaga faʻataʻitaʻi e lagolagoina uma uiga SQLite.
• sqlpad - Fa'atonu SQL fa'avae i luga ole laiga e tamomoe i lau oe lava ao.
• SQLPro - O se pule Postgres faigofie, mamana mo macOS.
• SquirreL - Graphical SQL client na tusia i Java e mafai ai ona e vaʻai i le fausaga o le JDBC compliant database, suʻesuʻe faʻamaumauga i luga o laulau, tuʻuina atu tulafono SQL ma isi.
• SQLTools - Pulea fa'amaumauga mo VSCode.
• SQLyog - Le sili ona atoatoa ma faigofie ona faʻaoga MySQL GUI.
• Tabix — SQL Editor & Open source atamai pisinisi faigofie mo Clickhouse.
• LaulauPlus - Meafaigaluega GUI faʻaonaponei, faʻaonaponei, ma faauo mo fesoʻotaʻiga faʻamaumauga: MySQL, PostgreSQL, SQLite & sili atu.
• TeamPostgreSQL - PostgreSQL Web Administration GUI - fa'aoga au fa'amaumauga PostgreSQL mai so'o se mea, fa'atasi ai ma le tamaoaiga, uila-saosaoa AJAX atina'e.

CLI meafaigaluega

• ipython-sql - Fesoʻotaʻi i se faʻamaumauga mo le tuʻuina atu o tulafono SQL i totonu o le IPython poʻo le IPython Notebook.
• iredis - O se Cli mo Redis ma le Autocompletion ma le Syntax Highlighting.
• pgcenter - Meafaigaluega faʻatonu sili mo PostgreSQL.
• pg_activity — Tulaga e pei o le talosaga mo le mataituina o gaoioiga a le server PostgreSQL.
• pg_pito - 'pito' mo PostgreSQL.
• pspg — Postgres Pager
• SQLcl — Oracle SQL Developer Command Line (SQLcl) ose laina fa'atonuga e leai se totogi mo Oracle Database.
• usql - O se fesoʻotaʻiga laina-laina lautele mo PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, ma le tele o isi fa'amaumauga e aofia ai le NoSQL ma faʻamaumauga e le o fesoʻotaʻiga!

dbcli

• athenacl - AthenaCLI o se meafaigaluega CLI mo le auaunaga AWS Athena e mafai ona faʻamaeʻaina le faʻamaeʻaina ma faʻamamafaina le syntax.
• litecli - CLI mo SQLite Databases faʻatasi ai ma le faʻamaeʻaina otometi ma faʻailoga faʻasologa.
• mssql-cli - O se tagata fa'atonu laina laina mo SQL Server fa'atasi ai ma le fa'amae'aina otometi ma fa'ailoga fa'asologa.
• mycli - O se Terminal Client mo MySQL ma le Autocompletion ma le Syntax Highlighting.
• pgcli - Postgres CLI faʻatasi ai ma le faʻamaeʻaina ma le faʻasologa o le syntax.
• vcli - Vertica CLI faʻatasi ma le faʻamaeʻaina otometi ma faʻailoga faʻasologa.

DB-schema navigation ma va'aiga

• dbdiagram.io - Meafaigaluega vave ma faigofie e fesoasoani ia te oe e tusi au ata o fesoʻotaʻiga faʻamaumauga ma tafe vave e faʻaaoga ai le gagana DSL faigofie.
• ERAlchemy - Mea faigaluega fa'atupuina ata o Fa'alapotopotoga.
• SchemaCrawler - O se su'esu'ega fuafuaga fa'amaumauga ma mea faigaluega malamalama.
• Sipai Sipai - Fausia lau faʻamaumauga i faʻamaumauga HTML, e aofia ai faʻataʻitaʻiga Faʻatasiga Faʻalapotopotoga.
• tbls - CI-Friendly meafaigaluega mo le faʻamauina o se faʻamaumauga, tusia i le Go.

Fa'ata'ita'iga

• Fa'ata'ita'iga Fa'amatalaga Navicat - O se mea faigaluega faʻamaumauga mamana ma taugofie e fesoasoani ia te oe e fausia ai faʻataʻitaʻiga faʻataʻitaʻiga maualuga, faʻatatau ma faʻaletino.
• Oracle SQL Developer Fa'ata'ita'iga Fa'amatalaga - Oracle SQL Developer Data Modeler ose mea faigaluega faʻataʻitaʻi fua e faʻaleleia ai le gaosiga ma faʻafaigofie galuega faʻataʻitaʻiga.
• pgmodeler - Meafaigaluega faʻataʻitaʻiga faʻamatalaga ua fuafuaina mo PostgreSQL.

Mea faigaluega femalagaiga

• 2bass - Mea faigaluega faʻapipiʻi faʻamaumauga-as-code e faʻaogaina ai le manatu o faʻamaumauga DDL idempotent.
• auala lele - Mea faigaluega femalaga'i fa'amaumauga.
• gh-ost — Femalaga'iga fuafuaga i luga ole laiga mo MySQL.
• liquibase - Faletusi tuto'atasi fa'amaumauga mo le su'esu'eina, pulea ma le fa'aogaina o suiga o fuafuaga fa'amaumauga.
• migra — E pei o le eseesega ae mo PostgreSQL schemas.
• node-pg-malaga - Node.js fa'amaumauga o femalaga'iga fa'atonu na fausia fa'apitoa mo postgres. (Ae mafai foʻi ona faʻaoga mo isi DB e faʻatatau ile tulaga SQL - eg CockroachDB.)
• Pyrseas - Tuuina atu mea faʻaoga e faʻamatala ai le PostgreSQL database schema e pei o le YAML.
• SchemaHero - O se fa'alapotopotoga Kubernetes mo le fa'atonuina o fa'amaumauga o fa'amaumauga (gitops mo fa'amaumauga o fa'amaumauga).
• Sqitch - Fa'atonuga fa'amaumauga-fa'atonu suiga fa'ale-aganu'u mo le atina'eina e aunoa ma se fa'avae ma le fa'atinoina fa'alagolago.
• yuniql - Ae o le isi polokalame fa'aliliuga ma mea faigaluega femalaga'i na'o faia i le .NET Core 3.0+ ma fa'amoemoe e sili atu.

Meafaigaluega fa'atupu tulafono

• ddl-generator — Fa'ailoa le SQL DDL (Gagana Fa'amatalaga Fa'amatalaga) mai fa'amaumauga o laulau.
• polokalame2ddl - Fa'aoga laina fa'atonu mo le auina atu i fafo Oracle schema e seti ai ddl init scripts ma le mafai ona fa'amama fa'amatalaga le mana'omia, tu'u'ese'ese le DDL i faila eseese, matagofie le fa'atulagaina.

Toa

• Faʻafiafiaga - O se punaoa tatala REST API pito i tua mo telefoni feaveaʻi, upega tafaʻilagi, ma IoT talosaga.
• Hasura GraphQL Engine — Fa'asao vave, vave taimi moni GraphQL API i Postgres fa'atasi ai ma le fa'atonutonuina o avanoa lelei, fa'aosoina ai fo'i webhooks i luga o fa'amaumauga fa'amaumauga.
• jl-sql - SQL mo JSON ma CSV vaitafe.
• mysql_fdw - PostgreSQL faʻamaumauga mai fafo mo MySQL.
• Oracle REST Au'aunaga Fa'amatalaga - O se talosaga Java ogatotonu, ORDS faʻafanua HTTP(S) veape (GET, POST, PUT, DELETE, ma isi) i fefaʻatauaiga faʻamaumauga ma toe faʻafoʻi mai soʻo se faʻaiʻuga ua faʻapipiʻiina e faʻaaoga ai le JSON.
• Faʻavae — Prisma liliu lau database i se taimi moni GraphQL API.
• postgREST - REST API mo soʻo se Postgres database.
• tagata - O se auala e tautua ai se API FESOASOANI mai soʻo se faʻamaumauga o loʻo tusia i le Go.
• restSQL - SQL generator ma Java ma HTTP API, faʻaaogaina se HTTP API faigofie ma le XML poʻo le JSON faʻasologa.
• resquel - Fa'afaigofie ona fa'aliliu lau SQL database ile REST API.
• tagata oneone2 - Fausiaina otometi se auaunaga API RESTful mo lau faʻamaumauga faʻamaumauga.
• sql-fa'a - Fa'amalo maualuga REST ma UI afifi mo au fesili SQL.

Meafaigaluega faaleoleo

• pgbackrest - Fa'atuatuaina PostgreSQL Backup & Toe Fa'afo'isia.
• BaRMan — Pule Lagolago ma Toe Faaleleia mo PostgreSQL.

Fa'agaioiga/Fa'amatalaga

• Fa'amaumauga - O se meafaigaluega mo le suʻesuʻeina ma le lolomiina o faʻamaumauga.
• dtle — Tufatufaina Au'aunaga Fa'aliliuga mo MySQL.
• pgsync - Fa'atasi fa'amaumauga Postgres i le va o fa'amaumauga.
• pg_chameleon — MySQL i le PostgreSQL replica system tusia i le Python 3. O le faiga e faʻaaoga ai le faletusi mysql-replication e toso ai ata laina mai MySQL o loʻo teuina i PostgreSQL e pei o JSONB.
• PGDeltaStream - O se Golang webserver e faʻasalalau Postgres suiga a itiiti ifo-tasi i luga o websockets, faʻaaogaina le Postgres logical decoding feature.
• repmgr - Le sili ona lauiloa Replication Pule mo PostgreSQL.

Lisi

• pgx_scripts - O se aofaʻiga o faʻamatalaga laiti aoga mo suʻesuʻega faʻamaumauga ma pulega, na faia e la matou 'au i PostgreSQL Experts.
• pgsql-bloat-estimation - Fesili e fua ai fuainumera fuainumera i faʻamatalaga ma laulau mo PostgreSQL.
• pgWikiAua - Su'ega SQL e siaki pe o mulimuli lau fa'amaumauga i tulafono mai https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-utils - Fa'aoga aoga PostgreSQL.
• Pepa fa'a'ole'ole a Postgres — Fa'aoga SQL-tusitusi ma fa'atonuga e .
• postgres_dba - Le seti o mea faigaluega aoga mo Postgres DBAs ma inisinia uma.
• postgres_queries_and_commands.sql - Fa'aoga PostgreSQL Fesili ma Poloaiga.
• TPT - O nei sqlplus scripts e mo le Oracle Database faʻatinoga faʻatinoga ma faʻafitauli.

Mata'ituina/Fa'amaumauga/Fa'atinoga

• ASH Viewer - Tuuina atu se ata faʻataʻitaʻi o faʻamaumauga o tala faʻasolopito o sauniga i totonu ole Oracle ma PostgreSQL DB.
• Monyog — Meafaigaluega e Mataitu ai MySQL e leai se sui & taugofie.
• mssql-mata'ituina - Mataʻituina lau SQL Server ile faʻatinoga o Linux e faʻaaoga ai le aoina, InfluxDB ma le Grafana.
• Navicat Monitor - O se mea faigaluega e mata'ituina ai le 'au'aunaga mamao saogalemu, faigofie ma leai se fa'apolopolo o lo'o fa'atumuina i foliga mamana e fa'aoga lelei ai lau mata'ituina.
• Mataituina ma Pulega a Percona - Tatala punaoa faʻavae mo le puleaina ma le mataʻituina o MySQL ma MongoDB faʻatinoga.
• panalyze collector - Su'esu'e le aoina o fuainumera mo le aoina mai o fua faatatau PostgreSQL ma fa'amaumauga o fa'amaumauga.
• postgres-checkup - Meafaigaluega faʻataʻitaʻiga fou-tupulaga e mafai ai e tagata faʻaoga ona faia se suʻesuʻega loloto o le soifua maloloina o Postgres databases.
• postgres_exporter - Prometheus fa'atau oloa mo PostgreSQL metrics server.
• pgDash - Fua ma siaki vaega uma o au faʻamaumauga PostgreSQL.
• PgHero - O se lisi o faʻatinoga mo Postgres - siaki faʻalesoifua maloloina, faʻasino igoa, ma isi mea.
• pgmetrics - Aoina ma faʻaalia faʻamatalaga ma fuainumera mai se PostgreSQL server.
• pgNapi - O se faʻaoga faʻaoga mo Postgres faʻamatalaina fuafuaga, faʻatasi ai ma fautuaga e faʻaleleia ai le faʻatinoga.
• pgstats - Aoina mai fuainumera PostgreSQL, ma sefe i faila CSV pe lolomi i luga o le stdout.
• pgwatch2 — Fetuuna'i fa'atatau PostgreSQL metrics mata'ituina / dashboarding solution.
• Telegraf PostgreSQL plugin - Tuuina metrics mo lau postgres database.

Zabbix

• Mamonsu - Su'e su'esu'e mo PostgreSQL.
• Orabbix - Orabbix o se faʻapipiʻi faʻapipiʻiina e galulue faʻatasi ma le Zabbix Enterprise Monitor e tuʻuina atu ai le tele-tiered mataʻituina, faʻatinoga ma avanoa lipoti ma fua mo Oracle Databases, faʻatasi ai ma metric faʻatinoga a le auʻaunaga.
• pg_monz - O le faʻataʻitaʻiga mataʻituina lea a Zabbix mo PostgreSQL Database.
• Pyora — Python script e mataʻituina Oracle Databases.
• ZabbixDBA - ZabbixDBA e vave, fetuutuunai, ma faʻaauau ona atiaʻe faʻapipiʻi e mataʻituina lau RDBMS.

tofotofoga

• DbFit - O se faʻavae suʻega faʻamaumauga e lagolagoina faigofie suʻega faʻataʻitaʻiga o lau code database.
• RegreSQL - Toe fa'afo'i Su'ega au fesili SQL.

Fa'amatalaga fa'amatalaga

• Databene Benerator — Ose fa'avae mo le fa'atupuina o fa'amaumauga fa'ata'ita'iga fa'aola maualuga ma fa'amaonia mo lau faiga o lo'o fa'ata'ita'iina (aloese mai le fa'ata'ita'iga a le Datalite).
• dbForge Fa'amatalaga Fa'amatalaga mo MySQL - Malosiaga GUI meafaigaluega mo le fatuina o le tele o voluma o faʻamatalaga moni suʻega.
• dbForge Faʻamatalaga Faʻamatalaga mo Oracle - Mea faigaluega GUI laʻititi ae malosi mo le faʻatupuina o fuafuaga a Oracle ma tone o faʻamatalaga moni o suʻega.
• dbForge Fa'amatalaga Fa'amatalaga mo le SQL Server - Meafaigaluega GUI mamana mo se faʻatupu vave o faʻamatalaga suʻega anoa mo faʻamaumauga.

pulega

• pgbadger - O se PostgreSQL Log Analyzer vave.
• pgbedrock — Puleaina matafaioi a le vaega o Postgres, matafaioi o sui auai, pule fuafuaga, ma avanoa.
• pgslice - Vaevaega postgres e faigofie pei o pai.

HA/Failover/Sharding

• Citus - Faʻaopoopoga Postgres e tufatufa atu au faʻamatalaga ma au fesili i le tele o nodes.
• patroni - Se faʻataʻitaʻiga mo PostgreSQL Avanoa Maualuga ma ZooKeeper, etcd, poʻo le Konesula.
• Percona XtraDB Cluster - O se Fofo Maualuga Maualuga mo MySQL Clustering ma Avanoa Maualuga.
• stolon — Cloud native PostgreSQL pule mo PostgreSQL maualuga avanoa.
• pg_auto_failover - Postgres faʻaopoopoga ma auaunaga mo faʻaoga faʻapitoa ma maualuga avanoa.
• pglookout - PostgreSQL replication mataʻituina ma failover daemon.
• PostgreSQL Automatic Failover - Avanoa maualuga mo Postgres, faʻavae i luga o faʻamatalaga faʻapisinisi Pacemaker ma Corosync.
• postgresql_cluster - PostgreSQL High-Availability Cluster (faʻavae i luga o le "Patroni" ma le "DCS(etcd)"). Fa'autometi le fa'atinoina i le Ansible.
• Vitess - Fa'amaumauga fa'apipi'i fa'amaumauga mo le fa'alava fa'alava o MySQL e ala i le fa'avasegaina lautele.

Kubernetes

• KubeDB - Fa'afaigofieina le fa'aogaina o fa'amaumauga o gaosiga-grade i Kubernetes.
• Fa'afoeina Postgres - O le Postgres Operator e mafai ai ona maua tele PostgreSQL fuifui i Kubernetes (K8s) faʻamalosia e Patroni.
• Spilo - HA PostgreSQL Clusters ma Docker.
• StackGres — Atina'e-vaega, Full Stack PostgreSQL i Kubernetes.

Fa'atonu Fa'atonu

• MySQLTuner-perl - Faʻamatalaga tusia i Perl e faʻatagaina oe e toe iloilo vave se faʻapipiʻi MySQL ma faia fetuunaiga e faʻateleina ai le faʻatinoga ma le mautu.
• PGConfigurator - Meafaigaluega i luga ole laiga e maua ai se mea sili ona lelei postgresql.conf.
• pgtune — PostgreSQL fetuutuunaiga wizard.
• postgresqltuner.pl - Faʻamatalaga faigofie e faʻavasega ai lau PostgreSQL faʻamaumauga faʻamaumauga, ma tuʻuina atu fautuaga faʻalogo.

DevOps

• DBmaestro - DBmaestro faʻavavevave le faʻasaʻoina o taamilosaga ma lagolagoina le faʻamalosi i le IT atoa faʻanatura.
• Toad DevOps Toolkit - Toad DevOps Toolkit e faʻatino galuega autu o le atinaʻeina o faʻamaumauga i totonu o lau galuega DevOps - e aunoa ma le faʻafefeina o le lelei, faʻatinoga poʻo le faʻamaoni.

Fa'ata'ita'iga ata

• Oracle Database Fa'ata'ita'iga Fuafuaga - Oracle Database Fa'ata'ita'iga Fa'ata'ita'iga.

lipoti

• faapupulaina - O se faʻaoga faigofie e faʻaoga ai le faʻamatalaga SQL na fausia mo tagata fiafia SQL.

Faʻasalaga

• DBdeployer - Meafaigaluega e faʻapipiʻi faigofie ai sapalai database MySQL.
• dbatools - PowerShell module atonu e te mafaufau i ai e pei o se laina-line SQL Server Management Studio.
• Postgres.app - Faʻapipiʻi PostgreSQL faʻapipiʻi atoatoa o loʻo faʻapipiʻiina e avea o se Mac app masani.
• BigSQL - O se tufatufaina faauo-faauo o Postgres.
• Fale Elefane — Fa'ainitaneti PostgreSQL pulega pito i luma o lo'o tu'ufa'atasia le tele o mea aoga ma talosaga mo le fa'aoga ma PostgreSQL.

Security

• Accra - Fa'amaumauga mo le puipuiga malu. Su'e fa'amaumauga fa'atasi ma fa'ailoga tulaga, su'esu'e e ala i fa'amatalaga fa'ailoga, puipuiga o tui SQL, su'esu'ega fa'alavelave, fa'amomoli. Lagolago le itu o tagata o tausia ma le itu sui ("manino") fa'ailoga. SQL, NoSQL.

Fa'ailoga tulafono

• CodeBuff — Gagana-agnostic pretty-lomitusi e ala i masini aoaoina.

Fesoasoani

• E talia pea au sao! Faamolemole faitau le taiala o saofaga tulaga tasi.

Afai e iai ni au su'esu'ega mo le fa'amaumauga, fa'amolemole fa'asoa. O le a ou fiafia foi e maua ni manatu faaalia - PR ma fetu. Afai ei ai ni au fesili e uiga i le fatuina o au lava pepa, tusi foi.

puna: www.habr.com