Sawubona, Habr! Mhlawumbe, ngamunye wethu unefayela lapho sifihla khona okuthile okuwusizo nokuthakazelisayo kithi. Ezinye izixhumanisi kuma-athikili, izincwadi, amakhosombe, amamanyuwali. Lawa kungaba amabhukhimakhi esiphequluli noma avele avule amathebhu asele azowathola kamuva. Ngokuhamba kwesikhathi, konke lokhu kuyavuvuka, izixhumanisi ziyeka ukuvuleka, futhi izinto eziningi ezisetshenziswayo zivele ziphelelwe yisikhathi.

Kuthiwani uma sabelana ngalokhu okuhle nomphakathi futhi sithumela leli fayela ku-GitHub? Khona-ke umsebenzi wakho ungaba usizo komunye umuntu, futhi ningakwazi ukugcina ukuhambisana ndawonye, ​​nokwamukela izibuyekezo ezivela kulabo abafisa ngama-PR amahle amadala. Yilokhu kanye iphrojekthi eklanyelwe yona. Uhlu olumangalisayo. Ifakwe kumakhosombe angu-TOP 10 we-GitHub, inezinkanyezi ezingu-138K, futhi isixhumanisi semisebenzi yakho singavela khona ezimpandeni zayo README, ezoheha izethameli eziningi emsebenzini wakho. Yiqiniso, lokhu kuzodinga umzamo omncane. Ngifuna ukwabelana nawe ngolwazi lwami lwemizamo enjalo.

Igama lami nginguMaxim Gramin. Kwa-CROC ngenza ucwaningo lwe-Java kanye ne-database. Kulokhu okuthunyelwe ngizokutshela ukuthi i-Awesome Lists iyini nokuthi ungayenza kanjani i-repo yakho esemthethweni emangalisayo.

Yiziphi Awesome Lists

Uma kufanele ngithole ubuchwepheshe obusha noma ulimi lokuhlela, into yokuqala engiyenzayo ukuya lapha - ngithola isigaba esifanele, futhi kukhona amashidi afanelekile kuso. Futhi ukwahlulela ngenani lezinkanyezi nokukhula kwazo njalo, akumina kuphela owenza lokhu.

Eqinisweni, lena i-readme.md eyisicaba evamile, ehlala endaweni ehlukene izinqolobane, ikleliswe endaweni yesi-8 phakathi kwazo zonke izinqolobane ze-GitHub futhi ihlanganisa izixhumanisi eziya kwamanye amashidi anikezelwe kunoma yisiphi isihloko. Isibonelo, esigabeni Sezilimi Zokuhlela ungathola amashidi ku-Awesome Python naku-Awesome Go, kanye ne-Front-End Development inenani elikhulu lezinsiza ekuthuthukisweni kwe-WEB. Futhi-ke, - isigaba yolwazi (Sizobuyela kulokhu ngokuhamba kwesikhathi). Futhi yebo, konke lokhu akukhawulelwe ezihlokweni zobuchwepheshe. Ngokwesibonelo, esigabeni Ezokuzijabulisa Nezokudlala ungathola nezinto eziningi ezithakazelisayo (ngangijabulile ezesabekayo-fantasy).
Isici esiyinhloko ukuthi wonke lawa mashidi awagcinwanga umbhali mathupha, kodwa ngumphakathi futhi ahlanganiswa ngokuhambisana nesimiso esikhethekile nesiqinile kakhulu. i-manifesto emangalisayo. Ishidi ngalinye elinjalo liwumphakathi ozimele wochwepheshe, liphila impilo yalo futhi livulekele izicelo zakho zokudonsa ezizokwenza libe ngcono nakakhulu. Futhi noma ubani angenza ishidi lakhe uma isihloko esithile singakahlanganiswa.

Umbhali wombono kanye nomxhumanisi walo lonke leli bhizinisi yinganekwane uSindre Sorhus, umuntu wokuqala ku-GitHub, umbhali ngaphezulu 1000 npm amamojuli, futhi nguye ozothola ama-PRs akho.

Ungangena kanjani ohlwini oluhle kakhulu

Uma ngokungazelelwe ungakatholi ishidi elifanele esihlokweni esikuthakaselayo, khona-ke lesi yisibonakaliso sokuqala sokuthi udinga ukuzenza ngokwakho!

Ngizokutshela ngisebenzisa isibonelo sengqondo yami. Amathuluzi Wedatha Emangalisayo - Ukusuka kuphrojekthi kuye kuphrojekthi kufanele ngisebenze ngemininingwane ehlukahlukene, yingakho ngaqala ifayela lapho ngaqoqa khona amathuluzi awusizo okusebenza nawo, zonke izinhlobo zabafuduki besizindalwazi, ama-IDE, amaphaneli okuphatha, amathuluzi okuqapha kanye nazo zonke izinhlobo izinto ezihlukahlukene. Amathuluzi engivele ngiwasebenzisile noma ebengihlela ukuqala ukuwasebenzisa. Ngabelane ngaleli fayela nozakwethu e-CROC nangale kwalokho. Lokhu kwasiza abantu abaningi futhi kwakuthakazelisa. Ngenxa yalokho, ngangifuna udumo olwengeziwe lapho ngolunye usuku ngibona ukuthi esigabeni seDatabases lalingekho ishidi kulesi sihloko. Futhi nginqume ukwengeza okwami ​​lapho.

Yini edingekayo kulokhu?

1. Sibhalisa i-repo ye-GitHub evamile enegama elifana nenhle-noma yini. Endabeni yami bekungama-database-amathuluzi amangalisayo
2. Siletha ishidi lethu ngendlela emangalisayo, lokhu kuzosisiza generator-awesome-uhlu, ezokhiqiza wonke amafayela adingekayo ngefomethi edingekayo
3. Ukusetha i-CI yangempela. i-lint emangalisayo futhi travis ci izosisiza ukulawula ubuqiniso ishidi lethu
4. Silinda izinsuku ezingu-30
5. Sibuyekeza okungenani i-PR yabanye abantu abangu-2
6. Futhi ekugcineni senza i-PR ku-repo eyinhloko, lapho sengeza khona isixhumanisi ku-repo yethu. Lapha udinga ukufunda yonke into ngokucophelela futhi ugcwalise ngokucophelela zonke izidingo eziningi zeshidi elisha kanye ne-PR ngokwayo.

Ikhekhe lami lokuqala kuvele kube yizigaxa

Kodwa kwadlula isikhathi esincane, ngaqoqa ukwaziswa okwengeziwe, ngenza amaphutha futhi ngaqunga isibindi ukuzama kwesibili.

Kodwa ngikhohliwe ngento ebaluleke kakhulu, engaqanjwa ngomusa kimina:

Angizange ngiqaphe kakhulu futhi angizange ngingeze i-unicorn ukuze ngiqinisekise ukuthi zonke izimo zahlangatshezwana nazo

Kwabe sekudlula isikhathi esithe xaxa, ukuhlela okwengeziwe okumbalwa okusekelwe emazwaneni, kanye nokwakukade kulindelwe tweetukuthi i-PR yami yamukelwe.

Ngakho ngaba umbhali weshidi lami lokuqala, futhi baqala ukwamukela I-PR's emphakathini ukuze wengeze amathuluzi amasha. Futhi eziningi zazo sezifakiwe Amathuluzi Wedatha Emangalisayo. Uma uvilapha kakhulu ukulandela isixhumanisi,

nakhu okukhethiwe kwamanje ngesikhathi sokushicilelwa kokuthunyelwe

Amathuluzi Wedatha Emangalisayo

Uhlu oluqhutshwa umphakathi lwamathuluzi esizindalwazi

Lapha sizoqoqa ulwazi mayelana namathuluzi okuhlola amangalisayo awusizo futhi amangalisayo enza lula ngezizindalwazi ze-DBA, i-DevOps, Onjiniyela kanye nabantu nje abafayo.

Zizwe ukhululekile ukwengeza ulwazi mayelana namathuluzi akho e-db noma amathuluzi akho owathandayo ezinkampani zangaphandle ze-db.

Okuqukethwe

• LAPHA
• Abaphathi/Abathengi be-GUI
• Amathuluzi e-CLI
• Ukuzulazula kwe-DB-schema nokubona ngeso lengqondo
• Abamodelayo
• Amathuluzi okufuduka
• Amathuluzi okukhiqiza amakhodi
• I-Wrappers
• Amathuluzi ekhophi yasenqolobaneni
• Ukuphindaphinda/ Ukusebenza kwedatha
• Izikriphthi zase
• Ukuqapha/Izibalo/Ukusebenza
  • Zabbix
• Testing
  • Ijeneretha yedatha
• Administration
• HA/Failover/Sharding
• Kubernetes
• Ukucushwa Ukucushwa
• I-DevOps
• Amasampula e-schema
• Ukubika
• Ukunikezwa
• Security
• Abafometha bekhodi

LAPHA

• AnySQL Maestro - Ithuluzi lokuphatha lezinhloso eziningi likaNdunankulu lokuphatha, ukulawula nokuthuthukiswa kwesizindalwazi.
• I-Aqua Data Studio - I-Aqua Data Studio isofthiwe yokukhiqiza yabathuthukisi beDatabase, ama-DBA, nabahlaziyi.
• Isizindalwazi.net - Ithuluzi lokuphatha i-database eminingi elisekelwa imininingwane yolwazi engama-20+.
• IdathaGrip - I-Cross-Platform IDE yolwazi kanye ne-SQL ngabakwaJetBrains.
• I-DBeaver - Imenenja yedatha yendawo yonke yamahhala kanye neklayenti le-SQL.
• I-dbForge Studio ye-MySQL - I-IDE yendawo yonke ye-MySQL kanye ne-MariaDB yokuthuthukiswa kwesizindalwazi, ukuphatha, nokuphatha.
• I-dbForge Studio ye-Oracle - I-IDE enamandla yokuphatha, ukuphatha, kanye nentuthuko ye-Oracle.
• I-dbForge Studio ye-PostgreSQL - Ithuluzi le-GUI lokuphatha nokuthuthukisa imininingwane kanye nezinto.
• I-dbForge Studio ye-SQL Server -Indawo enamandla yokuthuthukisa edidiyelwe yokuthuthukiswa kwe-SQL Server, ukuphathwa, ukuphatha, ukuhlaziywa kwedatha, nokubika.
• dbKoda - Yesimanje (i-JavaScript/Electron framework), i-IDE yomthombo ovulekile ye-MongoDB. Inezici zokusekela ukuthuthukiswa, ukuphatha kanye nokulungisa ukusebenza kusizindalwazi se-MongoDB.
• IBE Expert - Ithuluzi eliphelele le-GUI le-Firebird ne-InterBase.
• UHeidiSQL - Iklayenti elingasindi lokuphatha i-MySQL, i-MSSQL ne-PostgreSQL, ebhalwe eDelphi.
• I-MySQL Workbench - I-MySQL Workbench iyithuluzi elibumbene elibukwayo labakhi besizindalwazi, abathuthukisi, nama-DBA.
• I-Navicat - Ithuluzi lokuthuthukisa imininingwane egciniwe elikuvumela ukuthi uxhume ngesikhathi esisodwa ku-MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, kanye nesizindalwazi se-SQLite kusuka kuhlelo lokusebenza olulodwa.
• Unjiniyela we-Oracle SQL - I-Oracle SQL Developer iyindawo yokuthuthukisa yamahhala, ehlanganisiwe eyenza kube lula ukuthuthukiswa nokuphathwa kwe-Oracle Database kukho kokubili ukuthunyelwa kwendabuko kanye ne-Cloud.
• pgAdmin - Inkundla edume kakhulu nenesici esicebile sokuphatha nokuthuthukisa i-Open Source ye-PostgreSQL, isizindalwazi esithuthuke kakhulu se-Open Source emhlabeni.
• pgAdmin3 - Ukusekelwa Kwesikhathi Eside kwe-pgAdmin3.
• Unjiniyela we-PL/SQL - I-IDE eqondiswe ngokukhethekile ekuthuthukisweni kwamayunithi ohlelo agciniwe Oracle Databases.
• I-PostgreSQL Maestro - Ukuphathwa kwedatha egcwele futhi enamandla, ithuluzi lokuphatha kanye nentuthuko ye-PostgreSQL.
• Ithuluzi - I-Toad iyisisombululo sedatha eyinhloko yabathuthukisi, ama-admins nabahlaziyi bedatha. Phatha izinguquko eziyinkimbinkimbi zesizindalwazi ngethuluzi elilodwa lokuphatha lesizindalwazi.
• I-Toad Edge - Ithuluzi lokuthuthukisa i-database elenziwe lula le-MySQL ne-Postgres.
• I-TORA - I-TOra ingumthombo ovulekile we-SQL IDE ye-Oracle, MySQL kanye ne-PostgreSQL dbs.
• IValentina Studio - Dala, phatha, buza futhi uhlole i-Valentina DB, MySQL, MariaDB, PostgreSQL kanye nesizindalwazi se-SQLite MAHHALA.

Abaphathi/Abathengi be-GUI

• Umphathi - Ukuphathwa kwedathabhesi kufayela elilodwa le-PHP.
• I-DbVisualizer - Ithuluzi le-database eliphelele labathuthukisi, ama-DBA nabahlaziyi.
• I-HouseOps - I-UI ye-ClickHouse Ops ye-Enterprise ukuze ugijime imibuzo, uqaphe impilo ye-ClickHouse futhi wenze abanye abaningi bacabange.
• JackDB - Ukufinyelela okuqondile kwe-SQL kuyo yonke idatha yakho, kungakhathaliseki ukuthi ihlala kuphi.
• I-OmniDB - Ithuluzi lewebhu lokuphathwa kwedathabhesi.
• I-Pgweb - Isiphequluli sesizindalwazi esisekelwe kuwebhu se-PostgreSQL, esibhalwe ku-Go futhi sisebenza kumishini ye-macOS, Linux kanye neWindows.
• phpLiteAdmin - Ithuluzi lokulawula lesizindalwazi se-SQLite elisekelwe kuwebhu elibhalwe nge-PHP elisekelwa i-SQLite3 ne-SQLite2.
• phpMyAdmin - Isixhumanisi sewebhu se-MySQL ne-MariaDB.
• psequel - I-PSequel inikeza isikhombimsebenzisi esihlanzekile nesilula ukuze wenze imisebenzi evamile ye-PostgreSQL ngokushesha.
• I-PopSQL - Umhleli wesimanje we-SQL weqembu lakho.
• I-Postico - Iklayenti lesimanje le-PostgreSQL le-Mac.
• I-Robo 3T - I-Robo 3T (phambilini eyayaziwa ngokuthi i-Robomongo) iyithuluzi lokuphatha le-MongoDB eliphakathi kwegobolondo.
• I-Sequel Pro - I-Sequel Pro iyisicelo sokuphatha idatha egciniwe ye-Mac esheshayo, esebenziseka kalula ukuze isebenze nesizindalwazi se-MySQL ne-MariaDB.
• I-SQL Operations Studio - Ithuluzi lokuphatha idatha elivumela ukusebenza ne-SQL Server, i-Azure SQL DB ne-SQL DW evela ku-Windows, macOS kanye ne-Linux.
• Isazi se-SQLite - I-Graphical interface isekela zonke izici ze-SQLite.
• sqlpad - Isihleli se-SQL esekwe kuwebhu sisebenza efwini lakho eliyimfihlo.
• I-SQLPro - Umphathi wePostgres olula, onamandla we-macOS.
• I-SquirreL - Iklayenti le-Graphical SQL elibhalwe ku-Java elizokuvumela ukuthi ubuke ukwakheka kwesizindalwazi esithobela i-JDBC, uphequlule idatha emathebulani, ukhiphe imiyalo ye-SQL njll.
• I-SQLTools - Ukuphathwa kwedathabhe ye-VSCode.
• I-SQLyog - I-GUI ye-MySQL ephelele kunazo zonke futhi kulula ukuyisebenzisa.
• I-Tabix - Umhleli we-SQL & Umthombo ovulekile wobuhlakani bebhizinisi beClickhouse.
• I-TablePlus - Ithuluzi le-GUI lesimanje, lendabuko, nelinobungane lemininingwane yokuxhumana: I-MySQL, i-PostgreSQL, i-SQLite nokuningi.
• I-TeamPostgreSQL - I-PostgreSQL Web Administration GUI - sebenzisa imininingwane yakho yolwazi ye-PostgreSQL noma yikuphi, enothile, eshesha umbani yewebhu ye-AJAX.

Amathuluzi e-CLI

• ipython-sql — Xhuma kusizindalwazi ukuze uthole imiyalo ye-SQL ngaphakathi kwe-IPython noma i-IPython Notebook.
• iredis - I-Cli ye-Redis ene-AutoCompletion kanye nokugqamisa kwe-Syntax.
• pgcenter - Ithuluzi lokuphatha elifana eliphezulu le-PostgreSQL.
• pg_umsebenzi - Uhlelo lokusebenza oluphezulu olufana nokuqapha umsebenzi weseva ye-PostgreSQL.
• pg_phezulu - 'phezulu' kwe-PostgreSQL.
• pspg -I-Postgres Pager
• sql - I-Oracle SQL Developer Command Line (SQLcl) iyisixhumi esibonakalayo samahhala somugqa womyalo we-Oracle Database.
• usql - Isixhumanisi somugqa womyalo wendawo yonke we-PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, nezinye izingosi zolwazi eziningi kufaka phakathi i-NoSQL kanye nedathabheyisi engahlobene!

dbcli

• athenacl - I-AthenaCLI iyithuluzi le-CLI lensizakalo ye-AWS Athena engakwazi ukuqedela ngokuzenzakalela nokugqamisa i-syntax.
• litecli - I-CLI ye-SQLite Databases enokuqedela ngokuzenzakalela nokugqamisa kwe-syntax.
• mssql-cli - Iklayenti lomugqa womyalo we-SQL Server enokuqedela okuzenzakalelayo nokugqanyiswa kwe-syntax.
• mycli - I-Terminal Client ye-MySQL ene-AutoCompletion kanye nokugqamisa kwe-Syntax.
• pgcli - I-Postgres CLI ngokuqedela ngokuzenzakalela nokugqamisa kwe-syntax.
• vcli - I-Vertica CLI enokuqedela okuzenzakalelayo nokugqamisa kwe-syntax.

Ukuzulazula kwe-DB-schema nokubona ngeso lengqondo

• dbdiagram.io - Ithuluzi elisheshayo nelilula lokusiza ukudweba imidwebo yobudlelwano besizindalwazi sakho bese ugeleza ngokushesha usebenzisa ulimi olulula lwe-DSL.
• I-ERAlchemy - Ithuluzi lokukhiqiza I-Entity Relation Diagrams.
• I-SchemaCrawler - Ukutholwa kwe-schema sedatha yamahhala kanye nethuluzi lokuqonda.
• I-Schema Spy - Ukukhiqiza idatha yakho egciniwe ibe imibhalo ye-HTML, okuhlanganisa nemidwebo yoBudlelwane Benhlangano.
• tbls - Ithuluzi elilungele i-CI lokuqopha imininingwane egciniwe, ebhalwe ku-Go.

Abamodelayo

• Imodeli yedatha ye-Navicat — Ithuluzi lokuklama isizindalwazi esinamandla futhi esingabizi esikusiza ukuthi wakhe amamodeli edatha yekhwalithi ephezulu, enengqondo kanye nengokoqobo.
• I-Oracle SQL Developer Data Modeler - I-Oracle SQL Developer Data Modeler iyithuluzi lamahhala lokuqhafaza elithuthukisa ukukhiqiza futhi lenze imisebenzi yokumodela idatha ibe lula.
• pgmodeler - Ithuluzi lokumodela idatha elenzelwe i-PostgreSQL.

Amathuluzi okufuduka

• 2bass - Ithuluzi lokucushwa kwe-database-njengekhodi elisebenzisa umqondo wemibhalo ye-DDL engabonakali.
• i-flyway - Database migration ithuluzi.
• gh-ost - Ukufuduka kwe-schema ku-inthanethi kwe-MySQL.
• i-liquibase - Umtapo wolwazi ozimele wokulandelela, ukuphatha nokusebenzisa izinguquko ze-schema sedatha.
• imigra - Njengokwehluka kepha ngama-PostgreSQL schemas.
• i-node-pg-migrate - Ukuphathwa kokuthutha kwesizindalwazi se-Node.js kwakhelwe ama-postgres kuphela. (Kodwa ingasetshenziselwa amanye ama-DB ahambisana nezinga le-SQL - isb. I-CockroachDB.)
• I-Pyrseas - Inikeza izinsiza ukuchaza i-schema sedatha ye-PostgreSQL njenge-YAML.
• SchemaHero - Umsebenzisi we-Kubernetes wokuphathwa kwe-schema sedatha ememezelayo (ama-gitops ama-schemas esizindalwazi).
• Sqitch - Ukuphathwa koshintsho lwesizinda sedatha okunengqondo ukuze kuthuthukiswe ngaphandle kohlaka kanye nokuthunyelwa okuthembekile.
• iyuniql — Kanti elinye ithuluzi lokuguqula i-schema kanye nethuluzi lokufuduka elisanda kwenziwa nge-.NET Core 3.0+ yomdabu futhi ngethemba lokuthi lingcono.

Amathuluzi okukhiqiza amakhodi

• ddl-generator - Infers SQL DDL (Data Definition Language) kusuka kudatha yetafula.
• isikimu2ddl - Umugqa womyalo osetshenziswayo wokuthekelisa i-Oracle schema ukusetha izikripthi ze-ddl init ezinekhono lokuhlunga imininingwane engathandeki, ihlukanise i-DDL kumafayela ahlukene, ukuphuma kwefomethi enhle.

I-Wrappers

• I-DreamFactory - Umthombo ovulekile we-REST API backend wezinhlelo zokusebenza zeselula, iwebhu, ne-IoT.
• Injini ye-Hasura GraphQL - I-GraphQL API esheshayo, esheshayo yesikhathi sangempela ku-Postgres enokulawulwa kokufinyelela okuhle kakhulu, iphinde iqalise ama-webhook emicimbini yokugcinwa kwemininingwane.
• jl-sql - I-SQL ye-JSON ne-CSV stream.
• mysql_fdw - Isisonga sedatha yangaphandle ye-PostgreSQL ye-MySQL.
• Isevisi yedatha ye-Oracle REST - Uhlelo lokusebenza lwe-Java olumaphakathi, i-ORDS ibeka izenzo ze-HTTP(S) (GET, POST, PUT, DELETE, njll.) kudathabhesi yokwenziwayo futhi ibuyisela noma yimiphi imiphumela efomethwe kusetshenziswa i-JSON.
• Prisma - I-Prisma iguqula isizindalwazi sakho sibe i-GraphQL API yesikhathi sangempela.
• I-PostgREST - I-REST API yanoma iyiphi i-Postgres database.
• perst - Iyindlela yokusebenzisa i-RESTful API kunoma iyiphi isizindalwazi esibhalwe ku-Go.
• restSQL - Ijeneretha ye-SQL ene-Java ne-HTTP APIs, isebenzisa i-RESTful HTTP API elula ene-XML noma i-JSON serialization.
• resquel - Guqula kalula isizindalwazi sakho se-SQL sibe i-REST API.
• i-sandman2 - Khiqiza ngokuzenzakalelayo insiza ye-RESTful API yesizindalwazi sakho sefa.
• sql-boot - I-REST Ethuthukisiwe kanye ne-UI wrapper yemibuzo yakho ye-SQL.

Amathuluzi ekhophi yasenqolobaneni

• pgbackrest - Isipele Esithembekile se-PostgreSQL & Buyisela.
• UBarman - Isipele kanye Nomphathi Wokubuyisela we-PostgreSQL.

Ukuphindaphinda/ Ukusebenza kwedatha

• Idathasethi - Ithuluzi lokuhlola nokushicilela idatha.
• dtle - Isevisi Yokudluliswa Kwedatha Esabalalisiwe ye-MySQL.
• pgsync - Vumelanisa idatha ye-Postgres phakathi kolwazi.
• pg_unwabu - Isistimu ye-replica ye-MySQL kuya ku-PostgreSQL ebhalwe nge-Python 3. Uhlelo lusebenzisa umtapo wezincwadi we-mysql-replication ukudonsa izithombe zomugqa ku-MySQL ezigcinwe ku-PostgreSQL njenge-JSONB.
• I-PGDeltaStream - Iseva yewebhu ye-Golang ukuze isakaze i-Postgres ishintsha okungenani kanye phezu kwama-websockets, isebenzisa isici sokuqopha esinengqondo se-Postgres.
• repmgr - Umphathi Wokuphindaphinda Odume Kakhulu we-PostgreSQL.

Izikriphthi zase

• pgx_scripts - Iqoqo lemibhalo emincane ewusizo yokuhlaziywa kwesizindalwazi nokuphatha, edalwe ithimba lethu KwaPostgreSQL Ochwepheshe.
• pgsql-bloat-estimation - Imibuzo yokukala ukuvuvuka kwezibalo kuma-index namathebula e-PostgreSQL.
• pgWikiDont - Ukuhlolwa kwe-SQL okuhlola ukuthi isizindalwazi sakho siyayilandela yini imithetho kusuka https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-ukusetshenziswa - Izinsiza eziwusizo ze-PostgreSQL.
• Ishidi lokukopela le-Postgres - Imibhalo ewusizo ye-SQL nemiyalo ngo .
• postgres_dba - Isethi engekho yamathuluzi awusizo ama-Postgres DBAs nabo bonke onjiniyela.
• postgres_queries_and_commands.sql - Imibuzo Ewusizo ye-PostgreSQL nemiyalo.
• TPT - Lezi zikripthi ze-sqlplus ezenzelwe ukusebenza kahle kwe-Oracle Database & nokuxazulula izinkinga.

Ukuqapha/Izibalo/Ukusebenza

• I-ASH Viewer - Inikeza umbono wesithombe sedatha yomlando weseshini esebenzayo ngaphakathi kwe-Oracle ne-PostgreSQL DB.
• Monyog - Ithuluzi Lokugada le-MySQL elingabizi futhi elingabizi kakhulu.
• mssql-monitoring - Qaphela i-SQL Server yakho ekusebenzeni kwe-Linux usebenzisa okuqoqiwe, i-InfluxDB ne-Grafana.
• I-Navica Monitor - Ithuluzi lokuqapha iseva elikude eliphephile, elilula nelingasebenzeli eligcwele izici ezinamandla zokwenza ukuqapha kwakho kusebenze kahle ngangokunokwenzeka.
• Percona Monitoring and Management - Inkundla yomthombo ovulekile yokuphatha nokuqapha ukusebenza kwe-MySQL ne-MongoDB.
• pganalyze umqoqi - Umqoqi wezibalo we-Pganalyze wokuqoqa amamethrikhi we-PostgreSQL nedatha yokungena.
• postgres-checkup - Ithuluzi lokuxilonga lesizukulwane esisha elivumela abasebenzisi ukuthi benze ukuhlaziya okujulile kwempilo yolwazi lwe-Postgres.
• postgres_exporter - Umthengisi we-Prometheus wamamethrikhi weseva ye-PostgreSQL.
• pgDash - Kala futhi ulandelele zonke izici zolwazi lwakho lwe-PostgreSQL.
• PgHero - Ideshibhodi yokusebenza ye-Postgres - ukuhlolwa kwezempilo, izinkomba eziphakanyisiwe, nokuningi.
• pgmetrics - Qoqa futhi ubonise imininingwane nezibalo kusuka kuseva ye-PostgreSQL esebenzayo.
• pgMustard - I-interface yomsebenzisi ye-Postgres ichaza izinhlelo, kanye namathiphu okuthuthukisa ukusebenza.
• pgstats - Iqoqa izibalo ze-PostgreSQL, futhi izigcine kumafayela e-CSV noma iphrinte ku-stdout.
• pgwatch2 - Isixazululo sokuqapha/ideshibhodi esiziqukathe se-PostgreSQL.
• I-plugin ye-Telegraf PostgreSQL - Inikeza amamethrikhi esizindalwazi sakho se-postgres.

Zabbix

• UMamonsu - I-ejenti yokuqapha ye-PostgreSQL.
• Orabbix - I-Orabbix iyi-plugin eklanyelwe ukusebenza ne-Zabbix Enterprise Monitor ukuhlinzeka ngokuqapha okunezigaba eziningi, ukubika ukusebenza nokutholakala kanye nokukalwa kwe-Oracle Databases, kanye namamethrikhi okusebenza kweseva.
• pg_monz - Lesi isifanekiso sokuqapha se-Zabbix seDathabhethi ye-PostgreSQL.
• UPyora -Iskripthi sePython sokuqapha i-Oracle Database.
• ZabbixDBA - I-ZabbixDBA iyashesha, ivumelana nezimo, futhi ithuthukisa i-plugin ngokuqhubekayo ukuze igade i-RDBMS yakho.

Testing

• I-DbFit - Uhlaka lokuhlola isizindalwazi esisekela ukuthuthukiswa okulula okuqhutshwa ukuhlolwa kwekhodi yakho yesizindalwazi.
• I-RegreSQL - Ukuhlehla Ukuhlola imibuzo yakho ye-SQL.

Ijeneretha yedatha

• I-Databene Benerator — Kuwuhlaka lokukhiqiza idatha yokuhlola engokoqobo nevumelekile yevolumu ephezulu yohlelo lwakho oluvivinywayo (ukugwema iphethini ye-Datalite anti-pattern).
• I-dbForge Data Generator ye-MySQL - Ithuluzi elinamandla le-GUI lokudala umthamo omkhulu wedatha yokuhlola engokoqobo.
• I-dbForge Data Generator ye-Oracle - Ithuluzi le-GUI elincane kodwa elinamandla lokugcwalisa izikimu ze-Oracle ngamathani edatha yokuhlola engokoqobo.
• I-dbForge Data Generator ye-SQL Server - Ithuluzi elinamandla le-GUI lesizukulwane esisheshayo sedatha yokuhlola enenjongo yolwazi.

Administration

• pgbadger - I-PostgreSQL Log Analyzer esheshayo.
• pgbedrock - Phatha izindima zeqoqo le-Postgres, ubulungu bendima, ubunikazi be-schema, namalungelo.
• pgslice - Ukuhlukaniswa kwe-Postgres kulula njengophaya.

HA/Failover/Sharding

• Citus - Isandiso se-Postgres esabalalisa idatha yakho nemibuzo yakho ezindaweni eziningi.
• umlandeli - Isifanekiso sokutholakala okuphezulu kwe-PostgreSQL ne-ZooKeeper, njlld, noma i-Consul.
• I-Percona XtraDB Cluster - Isixazululo Esisezingeni Eliphezulu Se-MySQL Clustering kanye Nokutholakala Okuphezulu.
• stolon - Imenenja yendabuko ye-PostgreSQL yamafu yokutholakala okuphezulu kwe-PostgreSQL.
• pg_auto_failover - Isandiso se-Postgres kanye nensizakalo ye-failover ezenzakalelayo kanye nokutholakala okuphezulu.
• i-pglookout - Ukuqapha ukuphindaphinda kwe-PostgreSQL kanye ne-failover daemon.
• Ukuhluleka kwe-PostgreSQL okuzenzakalelayo - Ukutholakala Okuphezulu Kwama-Postgres, okusekelwe kuzinkomba zomkhakha we-Pacemaker ne-Corosync.
• postgresql_cluster - I-PostgreSQL High-Availability Cluster (esekelwe ku-"Patroni" kanye "ne-DCS(etcd)"). Ukuthunyelwa okuzenzakalelayo nge-Ansible.
• Vitess - Uhlelo lokuqoqwa kwedathabhesi yokukala okuvundlile kwe-MySQL ngokusebenzisa ukuhlukanisa okuvamile.

Kubernetes

• KubeDB - Ukwenza ukugcinwa kolwazi lwebanga lokukhiqiza kube lula ku-Kubernetes.
• Umsebenzisi we-Postgres - I-Postgres Operator inika amandla amaqoqo e-PostgreSQL atholakala kakhulu ku-Kubernetes (K8s) anikwa amandla nguPatroni.
• Spilo - Amaqoqo e-HA PostgreSQL ane-Docker.
• StackGres - Ibanga lebhizinisi, i-Full Stack PostgreSQL ku-Kubernetes.

Ukucushwa Ukucushwa

• I-MySQLTuner-perl - Iskripthi esibhalwe nge-Perl esikuvumela ukuthi ubuyekeze ukufakwa kwe-MySQL ngokushesha futhi wenze izinguquko ukuze ukhuphule ukusebenza nokuzinza.
• I-PGConfigurator - Ithuluzi lamahhala le-inthanethi lokukhiqiza okwenziwe kahle postgresql.conf.
• pgtune - Iwizadi yokumisa ye-PostgreSQL.
• postgresqltuner.pl - Umbhalo olula wokuhlaziya ukumiswa kwesizindalwazi sakho se-PostgreSQL, futhi unikeze izeluleko zokulungisa.

I-DevOps

• I-DBmaestro - I-DBmaestro isheshisa imijikelezo yokukhululwa futhi isekela ukusebenza kahle kuyo yonke i-IT ecosystem.
• I-Toad DevOps Toolkit - I-Toad DevOps Toolkit yenza imisebenzi ebalulekile yokuthuthukiswa kwesizindalwazi ngaphakathi kokuhamba komsebenzi wakho we-DevOps -ngaphandle kokubeka engcupheni ikhwalithi, ukusebenza noma ukwethembeka.

Amasampula e-schema

• I-Oracle Database Sample Schemas - Oracle Database Sample Schemas.

Ukubika

• Okuningi - Uhlelo lokusebenza lokubika lwe-SQL olulula ukulisebenzisa olwakhelwe abathandi be-SQL.

Ukunikezwa

• DBdeployer - Ithuluzi elisebenzisa amaseva esizindalwazi se-MySQL kalula.
• ama-dbatools - Imojula ye-PowerShell ongase ucabange ngayo njenge-studio ye-SQL Server Management Studio.
• I-Postgres.app - Ukufakwa okugcwele kwe-PostgreSQL okupakishwe njengohlelo lokusebenza olujwayelekile lwe-Mac.
• I-BigSQL - Ukusabalalisa okusebenziseka kalula kwe-Postgres.
• IShedi Lendlovu - Isiphetho sokuphathwa kwe-PostgreSQL esekwe kuwebhu esihlanganisa izinsiza ezimbalwa nezinhlelo zokusebenza ezizosetshenziswa ne-PostgreSQL.

Security

• I-Accra - I-database security suite. Ummeleli wesizindalwazi onokubethela kwezinga lenkundla, sesha ngedatha ebethelwe, ukuvimbela imijovo ye-SQL, ukutholwa kokungena, izimbiza zoju. Isekela ukubethela kohlangothi lweklayenti kanye nohlangothi lommeleli ("transparent"). SQL, NoSQL.

Abafometha bekhodi

• I-CodeBuff - Ukuphrinta okuhle kolimi-agnostic ngokufunda ngomshini.

Ukufaka isandla

• Iminikelo yakho yamukelekile njalo! Sicela ufunde incwadi imihlahlandlela yokunikela okokuqala.

Uma unokuthile okutholiwe kusizindalwazi, sicela wabelane. Ngizophinde ngijabule ukwamukela impendulo - PR kanye nezinkanyezi. Uma unemibuzo mayelana nokudala amashidi akho, yibhale futhi.

Source: www.habr.com