Molo, Habr! Mhlawumbi, ngamnye wethu unefayile apho sifihla into eluncedo kwaye inomdla kuthi. Amanye amakhonkco kumanqaku, iincwadi, iindawo zokugcina, iincwadana. Ezi inokuba ziibhukhimaki zesikhangeli okanye zivule iithebhu ezishiyekileyo zekamva. Ngokuhamba kwexesha, yonke le nto iyadumba, amakhonkco ayayeka ukuvulwa, kwaye uninzi lwezixhobo ziye ziphelelwe lixesha.

Kuthekani ukuba sabelana ngolu kulunga noluntu kwaye sithumele le fayile kwi-GitHub? Emva koko umsebenzi wakho unokuba luncedo komnye umntu, kwaye unokugcina ukufaneleka kunye, ukwamkela uhlaziyo oluvela kwabo banqwenela nge-PR's endala. Yile nto kanye iprojekthi eyenzelwe yona. Izintlu ezoyikekayo. Ifakwe kwi-TOP ye-10 ye-GitHub yokugcina, ineenkwenkwezi ze-138K, kwaye ikhonkco kwimisebenzi yakho inokuvela kanye kwingcambu yayo README, eya kutsala abaphulaphuli abaninzi emsebenzini wakho. Enyanisweni, oku kuya kufuna umgudu omncinci. Ndifuna ukwabelana nawe ngamava am ngemigudu enjalo.

Igama lam ndinguMaxim Gramin. Kwi-CROC ndenza uphuhliso lweJava kunye nophando lwedatha. Kule post ndiza kukuxelela ukuba yintoni uLuhlu olumangalisayo kunye nendlela yokwenza eyakho irepo esemthethweni eyoyikekayo.

Ziziphi izintlu ezoyikekayo

Xa kufuneka ndibone itekhnoloji entsha okanye ulwimi lwenkqubo, into yokuqala endiyenzayo kukuya apha-ndifumana icandelo elifanelekileyo, kwaye kukho amaphepha afanelekileyo kuwo. Kwaye ukugweba ngenani leenkwenkwezi kunye nokukhula kwazo rhoqo, ayindim kuphela owenza oku.

Enyanisweni, le yiflethi eqhelekileyo readme.md, ehlala kwindawo eyahlukileyo iindawo zokugcina, ibeka i-8th phakathi kwazo zonke iindawo zokugcina ze-GitHub kwaye iquka amakhonkco kwamanye amaphepha anikezelwe kuso nasiphi na isihloko. Umzekelo, kwicandelo leNkqubo yeeLwimi ungafumana amaphepha kwi-Awesome Python kunye ne-Awesome Go, kunye ne-Front-End Development inesixa esikhulu sezixhobo kuphuhliso lwe-WEB. Kwaye, kunjalo, - icandelo neeDathabheyisi (Siza kubuyela kule kamva kancinane). Kwaye ewe, konke oku akuphelelanga kwizihloko zobugcisa. Umzekelo, kwicandelo lokuzonwabisa kunye neMidlalo unokufumana izinto ezininzi ezinomdla (bendonwabile ngokobuqu eyoyikekayo-fantasy).
Into ephambili kukuba onke la maphepha awagcinwanga ngumbhali buqu, kodwa luluntu kwaye ahlanganiswe ngokuhambelana neyona nto ikhethekileyo kwaye ingqongqo kakhulu. i-manifesto emangalisayo. Iphepha ngalinye elilolo hlobo luluntu oluzimeleyo lweengcali, liphila ubomi balo kwaye livulelekile kwizicelo zakho zokutsalwa eziza kulwenza lubengcono. Kwaye nabani na unokuzenzela elakhe iphepha ukuba isihloko asikaqukwa.

Umbhali wembono kunye nomnxibelelanisi walo lonke eli shishini yintsomi uSindre Sorhus, umntu wokuqala kwiGitHub, umbhali ngakumbi Iimodyuli ze-1000 npm, kwaye nguye oya kufumana iiPRs zakho.

Ungena njani kuluhlu olumangalisayo

Ukuba ngokukhawuleza awufumananga ishidi elifanelekileyo kwisihloko esikuthandayo, ke lo mqondiso wokuqala omele uwenze ngokwakho!

Ndiza kukuxelela usebenzisa umzekelo wengqondo yam. Izixhobo zeDatabase eyoyikekayo - Ukusuka kwiprojekthi ukuya kwiprojekthi kufuneka ndisebenze ngeendawo ezahlukeneyo zogcino-lwazi, yiyo loo nto ndiqale ifayile apho ndaqokelela izixhobo eziluncedo ekusebenzeni nazo, zonke iintlobo zabafuduki bedatabase, ii-IDE, iiphaneli zolawulo, izixhobo zokubeka iliso kunye nazo zonke iintlobo izinto ezahlukeneyo. Izixhobo esele ndizisebenzisile okanye bendiceba ukuqalisa ukuzisebenzisa. Ndabelane ngale fayile nabalingane kwi-CROC nangaphaya. Oku kwanceda abantu abaninzi kwaye kwakubangel’ umdla. Ngenxa yoko, ndandifuna udumo olungakumbi xa ngenye imini ndabona ukuba kwicandelo leDatabases akukho phepha kwesi sihloko. Ndaye ndagqiba ekubeni ndongeze okwam apho.

Yintoni efunekayo kule nto?

1. Sibhalisa i-repo ye-GitHub eqhelekileyo enegama elifana neloyikekayo-nantoni na. Kwimeko yam yayizoyikeka-izixhobo zedatha
2. Sizisa iphepha lethu kwifomathi emangalisayo, oku kuya kusinceda uluhlu lwejenereyitha-eyoyikekayo, eya kuvelisa zonke iifayile eziyimfuneko kwifomathi efunekayo
3. Ukumisela iCI yokwenene. i-lint eyoyikekayo kunye ne-travis ci iya kusinceda ukulawula ubunyani iphepha lethu
4. Silinda iintsuku ezingama-30
5. Siphonononga ubuncinci iiPR zabanye abantu ezi-2
6. Kwaye ekugqibeleni senza i-PR kwi-repo ephambili, apho songeza ikhonkco kwi-repo yethu. Apha kufuneka ufunde yonke into ngononophelo kwaye uzalisekise ngononophelo zonke iimfuno ezininzi zephepha elitsha kunye nePR ngokwayo.

Ipanekuku yam yokuqala kwabe kukho iqhuma

Kodwa kwadlula ixesha elincinane, ndaqokelela izinto ezingakumbi, ndasebenza kwiimpazamo ndaza ndaba nobuganga bokwenjenjalo itrayi yesibini.

Kodwa ndiyilibele into ebaluleke kakhulu, eyathi yandicaciselwa ngobubele:

Andizange ndiqaphele kwaye andizange ndifake i-unicorn ukuqinisekisa ukuba zonke iimeko zidibene

Kwaze kwadlula ixesha elingakumbi, ukuhlelwa okumbalwa okusekwe kumazwana, kunye nokwakukudala kulindelwe tweetukuba yamkelwe iPR yam.

Ngoko ndaba ngumbhali wephepha lam lokuqala, kwaye baqala ukufumana PR's ukusuka kuluntu ukongeza izixhobo ezitsha. Kwaye ezininzi zazo sele zibandakanyiwe Izixhobo zeDatabase eyoyikekayo. Ukuba uyonqena ukulandela ikhonkco,

nalu ukhetho lwangoku ngexesha lokupapashwa kwesithuba

Izixhobo zeDatabase eyoyikekayo

Uluhlu oluqhutywa luluntu lwezixhobo zesiseko sedatha

Apha siza kuqokelela ulwazi malunga nezixhobo eziluncedo nezoyikekayo zovavanyo ezenza lula ngoovimba bedatha ye-DBA, i-DevOps, abaPhuhlisi kunye nabantu nje abafayo.

Zive ukhululekile ukongeza ulwazi malunga nezixhobo zakho ze-db okanye izixhobo zakho ozithandayo zeqela lesithathu ze-db.

Contents

• APHA
• Abaphathi be-GUI / abaxhasi
• Izixhobo ze-CLI
• DB-schema navigation kunye nokubonwayo
• Iimodeli
• Izixhobo zokufuduka
• Izixhobo zokuvelisa ikhowudi
• Wrappers
• Izixhobo zokugcina
• Ukuphindaphinda/ukusebenza kwedatha
• Scripts
• Ukubeka iliso/uBalo-manani/ukusebenza
  • Zabbix
• Testing
  • Umvelisi wedatha
• Administration
• HA/Failover/Shading
• Kubernetes
• Uqwalaselo Tuning
• DevOps
• Iisampulu zeschema
• Ukubika
• Ukwabiwa
• ukhuseleko
• Iifomati zekhowudi

APHA

• AnySQL Maestro - Isixhobo seNkulumbuso esineenjongo ezininzi zolawulo, ulawulo nophuhliso.
• I-Aqua Data Studio -Isitudiyo seDatha yeAqua yisoftware yemveliso yabaPhuhlisi beDatha, iiDBA, kunye nabaHlalutyi.
• Isiseko sedatha.net -Isixhobo solawulo lwesiseko seenkcukacha ezininzi ngenkxaso yogcino-lwazi olungaphezulu kwama-20.
• IdathaGrip -I-IDE ye-Cross-Platform ye-Databases kunye ne-SQL yi-JetBrains.
• DBever -Umphathi wedatabase yasimahla kunye nomxhasi weSQL.
• I-dbForge Studio ye-MySQL -I-IDE ye-Universal ye-MySQL kunye nophuhliso lwedatha ye-MariaDB, ulawulo, kunye nolawulo.
• I-dbForge Studio ye-Oracle -I-IDE enamandla kulawulo lwe-Oracle, ulawulo kunye nophuhliso.
• I-dbForge Studio yePostgreSQL - Isixhobo se-GUI sokulawula nokuphuhlisa ugcino-lwazi kunye nezinto.
• I-dbForge Studio ye-SQL Server -Ubume obunamandla obudibeneyo bophuhliso lophuhliso lwe-SQL Server, ulawulo, ulawulo, uhlalutyo lwedatha, kunye nokunika ingxelo.
• dbKoda -Imihla yangoku (i-JavaScript / isakhelo se-Electron), i-IDE yomthombo ovulekileyo we-MongoDB. Ineempawu zokuxhasa uphuhliso, ulawulo kunye nokulungisa ukusebenza koovimba beenkcukacha beMongoDB.
• IBE Expert -Isixhobo esibanzi se-GUI seFirebird kunye ne-InterBase.
• IHeidiSQL -Umxhasi olula wokulawula iMySQL, iMSSQL kunye nePostgreSQL, ebhalwe eDelphi.
• Indawo yokusebenza ye-MySQL -I-MySQL Workbench sisixhobo esibonakalayo esidibeneyo sabakhi bedatha, abaphuhlisi, kunye nee-DBA.
• navicat -Isixhobo sophuhliso lwedatha ekuvumela ukuba uqhagamshele ngaxeshanye kwi-MySQL, i-MariaDB, i-SQL Server, i-Oracle, i-PostgreSQL, kunye nedatha ye-SQLite kwisicelo esinye.
• Umyili we-Oracle SQL - I-Oracle SQL Developer yindawo ekhululekile, edibeneyo yophuhliso eyenza lula ukuphuhliswa nokulawulwa kweDatha ye-Oracle kwi-deployments yendabuko kunye ne-Cloud.
• pgAdmin -Eyona ndawo idumileyo nebonisa ulawulo olutyebileyo loMthombo oVulekileyo kunye neqonga lophuhliso lePostgreSQL, eyona ndawo iphezulu yedatha evulelekileyo kwihlabathi.
• pgAdmin3 -Inkxaso yexesha elide ye-pgAdmin3.
• PL/SQL Developer - I-IDE ejoliswe ngokukodwa ekuphuhliseni iiyunithi zeprogram ezigciniweyo ze-Oracle Databases.
• I-PostgreSQL Maestro -Ulawulo olupheleleyo nolunamandla lwedathabheyisi, ulawulo kunye nesixhobo sophuhliso lwePostgreSQL.
• Isixhobo -I-Toad sisisombululo sesiseko sesiseko sabaphuhlisi, ii-admins kunye nabahlalutyi bedatha. Lawula utshintsho oluntsonkothileyo lwedathabheyisi ngesixhobo esinye solawulo lwesiseko sedatha.
• I-Toad Edge -Isixhobo esilula sophuhliso lwedatha yeMySQL kunye nePostgres.
• TOra - I-TOra ngumthombo ovulekileyo we-SQL IDE ye-Oracle, i-MySQL kunye ne-PostgreSQL dbs.
• Isitudiyo sikaValentina -Yenza, ulawule, ubuze kwaye uphonononge iValentina DB, iMySQL, iMariaDB, iPostgreSQL kunye neSQLite yogcino-lwazi SIMAHLA.

Abaphathi be-GUI / abaxhasi

• Umlawuli -Ulawulo lweDatabase kwifayile enye yePHP.
• DbVisualizer -Isixhobo sedatha yendalo yonke sabaphuhlisi, ii-DBA kunye nabahlalutyi.
• HouseOps -Ishishini leClickHouse Ops UI yokuba uqhube imibuzo, ujonge impilo yeClickHouse kwaye wenze abanye abaninzi bacinge.
• IJackDB -Ukufikelela ngokuthe ngqo kwi-SQL kuyo yonke idatha yakho, nokuba ihlala phi.
• OmniDB -Isixhobo seWebhu solawulo lwedathabheyisi.
• Pgweb -Ibhrawuza esekwe kwiWebhu yePostgreSQL, ebhalwe kwiGo kwaye isebenza kwiMacOS, iLinux kunye noomatshini beWindows.
• phpLiteAdmin - Isixhobo solawulo sedatha ye-SQLite esekwe kwiWebhu esibhalwe kwi-PHP ngenkxaso yeSQLite3 kunye neSQLite2.
• phpMyAdmin -Unxibelelwano lwewebhu lweMySQL kunye noMariaDB.
• psequel -I-PSequel ibonelela ngojongano olucocekileyo nolulula ukuze wenze imisebenzi eqhelekileyo yePostgreSQL ngokukhawuleza.
• I-PopSQL -Umhleli wangoku, wentsebenziswano weSQL weqela lakho.
• Postico -UmThengi wePostgreSQL wangoku weMac.
• Robo 3T - I-Robo 3T (eyayisakuba yiRobomongo) i-shell-centric cross-platform ye-MongoDB isixhobo sokulawula.
• Ukulandelelana Pro -I-Sequel Pro sisicelo solawulo lwedatha ekhawulezayo, ekulula ukusisebenzisa seMac ukuze usebenze ngoovimba beenkcukacha zeMySQL kunye noMariaDB.
• Isitudiyo sokuSebenza seSQL -Isixhobo sokulawula idatha esenza ukuba usebenze ngeSQL Server, i-Azure SQL DB kunye neSQL DW esuka kwiWindows, macOS kunye neLinux.
• Ingcali ye-SQLite -Ujongano lomzobo luxhasa zonke iimpawu zeSQLite.
• sqlpad - Umhleli we-SQL esekwe kwiWebhu uqhutywa kwilifu lakho labucala.
• SQLPro -Umphathi wePostgres olula, onamandla weMacOS.
• SQuirreL - Umxhasi we-Graphical SQL obhalwe kwiJava oya kukuvumela ukuba ujonge ubume bedatha ehambelanayo ye-JDBC, ukukhangela idatha kwiitafile, ukhuphe imiyalelo yeSQL njl.njl.
• SQLTools - Ulawulo lweDatha yeVSCOde.
• SQLyog -Eyona iphelele kwaye kulula ukuyisebenzisa iMySQL GUI.
• Tabix - Umhleli weSQL kunye nomthombo ovulekileyo wobukrelekrele beshishini kwiClickhouse.
• ItafilePlus -Isixhobo se-GUI sanamhlanje, somthonyama kunye nesinobubele sedathabheyisi yobudlelwane: MySQL, PostgreSQL, SQLite & more.
• TeamPostgreSQL -I-GUI yoLawulo lweWebhu yePostgreSQL - sebenzisa i-database yakho ye-PostgreSQL naphi na, enesityebi, i-intanethi ye-AJAX ekhawulezayo yombane.

Izixhobo ze-CLI

• ipython-sql — Qhagamshela kuvimba weenkcukacha wokukhutshwa kwemiyalelo yeSQL ngaphakathi kweIPython okanye iIPython Notebook.
• iredis -I-Cli yeRedis enokuQeda ngokuzenzekelayo kunye nokuGqamisa iSyntax.
• pgcenter -Isixhobo esifana nesolawulo esiphezulu sePostgreSQL.
• pg_umsebenzi -Ephezulu njengesicelo sokujongwa komsebenzi weseva yePostgreSQL.
• pg_phezulu - 'phezulu' kwiPostgreSQL.
• pspg —IiPostgres Pager
• sqlcl - I-Oracle SQL Developer Command Line Line (SQLcl) yi-interface yomgca womyalelo we-Oracle Database.
• usql -Ujongano lomgca womyalelo wendalo yonke wePostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, kunye nabanye oovimba beenkcukacha ezininzi kuquka i-NoSQL kunye ne-non-relation databases!

dbcli

• athenacl - I-AthenaCLI sisixhobo se-CLI senkonzo ye-AWS ye-Athena enokwenza ukugqiba ngokuzenzekelayo kunye nokugqamisa kwe-syntax.
• litecli -I-CLI yeeDatha zeSQLite ngokugqibezela ngokuzenzekelayo kunye nokuqaqambisa isintaksi.
• mssql-cli — Umxhasi womgca womyalelo we-SQL Server ngokugqibezela okuzenzekelayo kunye nokuqaqambisa isintaksi.
• mycli -UmThengi weSitena seMySQL ngokuQinisekiswa ngokuzenzekelayo kunye nokuGqamisa iSyntax.
• pgcli -I-Postgres CLI ngokugqibezela ngokuzenzekelayo kunye nokuqaqambisa isintaksi.
• vcli -I-Vertica CLI ngokugqibezela okuzenzekelayo kunye nokuqaqambisa isintaksi.

DB-schema navigation kunye nokubonwayo

• dbdiagram.io -Isixhobo esikhawulezayo nesilula sokukunceda uzobe imizobo yobudlelwane bedatabase yakho kwaye uhambe ngokukhawuleza usebenzisa ulwimi olulula lweDSL.
• I-ERAlchemy -Isixhobo sokuvelisa iMizobo yoBudlelwane beQumrhu.
• SchemaCrawler -Isixhobo sokufunyanwa kweschema sedatha simahla kunye nesixhobo sokuqonda.
• Schema Spy — Ukuvelisa idatabase yakho kumaxwebhu e-HTML, kuquka nemizobo yoBudlelwane beQumrhu.
• tbls — CI-Isixhobo esinobuhlobo kuxwebhu lwedatha, ebhalwe kwiGo.

Iimodeli

• Navicat Data Modeler -Isixhobo soyilo sesiseko sedatha esinamandla nesisebenzayo esikuncedayo ukuba wakhe ingqikelelo ekumgangatho ophezulu, ingqiqo kunye nemodeli yedatha ebonakalayo.
• Oracle SQL Developer Data Modeler — I-Oracle SQL yeDeveloper Data Modeler sisixhobo segraphical sasimahla esonyusa imveliso kwaye senza lula imisebenzi yokubonisa idatha.
• pgmodeler -Isixhobo sokubonisa idatha eyenzelwe iPostgreSQL.

Izixhobo zokufuduka

• 2bass -Uqwalaselo lwesiseko sedatha njengesixhobo esisebenzisa ingqikelelo yemibhalo yeDDL engenamsebenzi.
• indlela yokubhabha -Isixhobo sokufuduka seDatabase.
• gh-ost -Ukufudukela kwi-intanethi ye-schema ye-MySQL.
• i-liquibase — Ithala leencwadi elizimeleyo lokukhangela umkhondo, ukulawula nokusebenzisa iinguqu zeschema sedatabase.
• ukufudukela -Njenge-diff kodwa ye-PostgreSQL schemas.
• i-node-pg-fuduka - Ulawulo lokufuduka kwedatha yeNode.js eyakhelwe kuphela iipostgres. (Kodwa ingasetyenziselwa ezinye iiDB ezihambelana nomgangatho weSQL - umz. iCockroachDB.)
• Pyrseas -Ibonelela ngezinto eziluncedo ukuchaza ischema sedatha yePostgreSQL njengeYAML.
• SchemaHero — Umsebenzisi we-Kubernetes wolawulo lwe-schema yedatha ebhengezayo (ii-gitops zeschema sedathabheyisi).
• Qhuba - Ulawulo olunengqiqo lwesiseko sedatha yendalo yophuhliso olungenasakhelo kunye nokusasazwa okuthembekileyo.
• yuniql - Ukanti enye inguqulelo yeschema kunye nesixhobo sokufuduka esenziwe ngemveli .NET Core 3.0+ kwaye ngethemba ngcono.

Izixhobo zokuvelisa ikhowudi

• ddl-jenereyitha - I-Infers SQL DDL (uLwimi lweNkcazo yeDatha) kwidatha yetafile.
• iskimu2ddl -Umgca womyalelo usetyenziselwa ukuthumela ngaphandle kwe-Oracle schema ukuseta i-ddl init scripts kunye nokukwazi ukucoca ulwazi olungafunekiyo, yahlula i-DDL kwiifayile ezahlukeneyo, imveliso yefomathi entle.

Wrappers

• IphuphaFactory -Umthombo ovulekileyo we-REST API ngasemva kwiselfowuni, iwebhu, kunye nosetyenziso lwe-IoT.
• Injini yeHasura yeGraphQL -Ukuvutha ngokukhawuleza, kwangexesha lokwenyani iGraphQL APIs kwiiPostgres ezinolawulo olucolekileyo lokufikelela, ikwabangela iiwebhooks kwimisitho yedatha.
• jl-sql -I-SQL ye-JSON kunye nemisinga ye-CSV.
• mysql_fdw -I-PostgreSQL yokugoqa idatha yangaphandle ye-MySQL.
• I-Oracle REST Iinkonzo zeDatha - Usetyenziso lweJava oluphakathi, iimephu ze-ORDS zezenzi zeHTTP(S) (GET, POST, PUT, DELETE, etc.) kwi-database transactions kwaye ibuyisela naziphi na iziphumo ezifomathiweyo kusetyenziswa i-JSON.
• Prism -I-Prisma ijika idatabase yakho ibe yiGraphQL API yexesha lokwenyani.
• Iposti yeposi -REST API kuyo nayiphi na i-database ye-Postgres.
• perst - Ngaba yindlela yokukhonza i-RESTful API kuyo nayiphi na i-database ebhalwe kwi-Go.
• restSQL - I-SQL generator eneJava kunye ne-HTTP APIs, isebenzisa i-RESTful HTTP API elula kunye ne-XML okanye i-JSON serialization.
• resquel -Guqulela ngokulula isiseko sedatha yakho yeSQL ibe yi-REST API.
• isanti2 -Yenza ngokuzenzekelayo inkonzo ye-RESTful API yesiseko sedatha yelifa lakho.
• sql-boot -I-REST ephucukileyo kunye ne-UI esongayo yemibuzo yakho ye-SQL.

Izixhobo zokugcina

• pgbackrest -Ethembekileyo PostgreSQL Backup & Buyisela.
• UBharman -Ugcino kunye noMlawuli woBuyiselo kwiPostgreSQL.

Ukuphindaphinda/ukusebenza kwedatha

• Uluhlu lwedatha -Isixhobo sokuphonononga kunye nokupapasha idatha.
• dtle -Inkonzo yokuThuthukiswa kweDatha yeMySQL.
• pgsync - Sync Postgres data phakathi kogcino lweenkcukacha.
• pg_notshetshe -I-MySQL ukuya kwi-PostgreSQL replica system ebhalwe kwiPython 3. Inkqubo isebenzisa ilayibrari ye-mysql-replication ukutsala imifanekiso ekroliweyo esuka kwi-MySQL egcinwe kwi-PostgreSQL njenge-JSONB.
• PGDeltaStream -Iseva yewebhu yeGolang ukusasaza iPostgres itshintsha nokuba kanye phezu kwee-websockets, kusetyenziswa iPostgres logical decoding feature.
• repmgr -Oyena Mlawuli udumileyo wokuPhinda kwiPostgreSQL.

Scripts

• pgx_scripts -Ingqokelela yemibhalo emincinci eluncedo yohlalutyo lwesiseko kunye nolawulo, olwenziwe liqela lethu kwiiNgcali zePostgreSQL.
• pgsql-bloat-uqikelelo -Imibuzo yokulinganisa i-bloat yezibalo kwizalathisi kunye neetafile ze-PostgreSQL.
• pgWikiDont — Uvavanyo lweSQL olujonga ukuba uvimba wakho wedatha ulandela imigaqo ukusuka https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-izixhobo -Izinto eziluncedo zePostgreSQL.
• Postgres cheat sheet -Izikripthi eziluncedo zeSQL kunye nemiyalelo ngo .
• postgres_dba -Isethi engekhoyo yezixhobo eziluncedo zePostgres DBAs kunye nazo zonke iinjineli.
• postgres_queries_and_commands.sql -Imibuzo yePostgreSQL eluncedo kunye neMiyalelo.
• TPT — Ezi zikripthi ze-sqlplus zeze-Oracle Database yokuphucula ukusebenza kunye nokusombulula ingxaki.

Ukubeka iliso/uBalo-manani/ukusebenza

• I-ASH Viewer -Ibonelela ngomzobo wedatha yembali yeseshoni esebenzayo ngaphakathi kwe-Oracle kunye ne-PostgreSQL DB.
• Monyog -Isixhobo sokuJonga isiXhobo seMySQL esingena-Agentless kunye neendleko.
• mssql-esweni -Jonga iSeva yakho yeSQL ekusebenzeni kweLinux usebenzisa eqokelelweyo, i-InfluxDB kunye neGrafana.
• Navicat Monitor -Isixhobo esikhuselekileyo, esilula kunye nesingena-arhente esikude esigcwele izinto ezinamandla ukwenza ukuba iliso lakho lisebenze kangangoko.
• UkuBekwa esweni kunye noLawulo lwePercona -Iqonga lomthombo ovulekileyo lokulawula kunye nokubeka iliso kwiMySQL kunye nokusebenza kweMongoDB.
• pganalyze umqokeleli -Pganalyze umqokeleli wezibalo zokuqokelela i-PostgreSQL metrics kunye nedatha yelog.
• postgres-ukuhlolwa - Isixhobo esitsha sokuxilonga esivumela abasebenzisi ukuba benze uhlalutyo olunzulu lwempilo yePostgres yogcino-lwazi.
• postgres_exporter -Umthengisi wePrometheus we-PostgreSQL server metrics.
• pgDash -Linganisa kwaye ulandele yonke imiba yogcino-lwazi lwakho lwePostgreSQL.
• PgHero - Ideshibhodi yokusebenza yePostgres - ukuhlolwa kwezempilo, izalathisi ezicetyiswayo, kunye nokunye.
• pgmetrics - Qokelela kwaye ubonise ulwazi kunye nezibalo kwiseva yePostgreSQL esebenzayo.
• pgMustard -I-interface yomsebenzisi ye-Postgres ichaza izicwangciso, kunye neengcebiso zokuphucula ukusebenza.
• pgstats -Iqokelela izibalo zePostgreSQL, kwaye mhlawumbi uzigcine kwiifayile zeCSV okanye uziprinte kwistdout.
• pgwatshi2 -I-Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
• Telegraf PostgreSQL iplagi -Ibonelela ngeemetrics kwidatabase ye-postgres yakho.

Zabbix

• Mamonsu -Iarhente yokubeka iliso kwiPostgreSQL.
• Orabbix -I-Orabbix yiplagin eyenzelwe ukusebenza kunye neZabbix Enterprise Monitor ukubonelela ngokubeka iliso okunemigangatho emininzi, ukusebenza kunye nokufumaneka kwengxelo kunye nomlinganiselo weeDatha zeOracle, kunye neemetrics zokusebenza kweseva.
• pg_monz — Le yitemplate yokubeka iliso yeZabbix yePostgreSQL Database.
• Pyora -Iskripthi sePython sokubeka iliso kwiiDatha zeOracle.
• ZabbixDBA -I-ZabbixDBA iyakhawuleza, iguquguquka, kwaye iqhubeka nokuphuhlisa iplagin ukujonga i-RDBMS yakho.

Testing

• DbFit -Isikhokelo sovavanyo lwesiseko sedatha esixhasa uphuhliso oluqhutywa lula lovavanyo lwekhowudi yakho yedatha.
• RegreSQL -Ukuhlengahlengisa Ukuvavanya imibuzo yakho yeSQL.

Umvelisi wedatha

• Databene Benerator — Sisakhelo sokuvelisa idatha yovavanyo oluyinyani kunye noluphezulu lwevolumu yenkqubo yakho phantsi kovavanyo (ukuphepha i-Datalite anti-pattern).
• dbForge Data Generator for MySQL -Isixhobo esinamandla se-GUI sokwenza umthamo omkhulu wedatha yovavanyo eyinyani.
• dbForge Data Generator for Oracle -Isixhobo esincinci kodwa esinamandla se-GUI sokuzalisa i-Oracle schemas ngeetoni zedatha yovavanyo eyinyani.
• I-dbForge Data Generator ye-SQL Server -Isixhobo esinamandla se-GUI kwisizukulwana esikhawulezayo sedatha yovavanyo enentsingiselo yogcino-lwazi.

Administration

• pgbadger -I-PostgreSQL Log Analyzer ekhawulezayo.
• pgbedrock -Lawula iindima zeqela lePostgres, ubulungu, ubunini beschema, kunye namalungelo.
• pgslice -Ukwahlulahlula kwePostgres kulula njengepayi.

HA/Failover/Shading

• Citus -Ulwandiso lwePostgres olusasaza idatha yakho kunye nemibuzo yakho kwiindawo ezininzi.
• umxhasi -Ithemplethi yokuFumana okuphezulu kwePostgreSQL kunye neZooKeeper, etcd, okanye uConsul.
• Iqela lePercona XtraDB -Isisombululo esiPhezulu se-Scalability ye-MySQL Clustering kunye nokuFumana okuphezulu.
• isitokhwe -Umphathi wePostgreSQL waMafu wokufumaneka okuphezulu kwePostgreSQL.
• pg_auto_failover -Ukwandiswa kwePostgres kunye nenkonzo ye-automated failover kunye nokufumaneka okuphezulu.
• pglookoout -Ujongo lokuphindaphinda kwePostgreSQL kunye nedaemon efileyo.
• I-PostgreSQL Ukusilela okuzenzekelayo -Ukufumaneka okuphezulu kwePostgres, ngokusekelwe kwiireferensi zeshishini iPacemaker kunye neCorosync.
• postgresql_iqela -Iqela le-PostgreSQL yokuFumana okuphezulu (esekelwe kwi-"Patroni" kunye ne "DCS (etcd)"). Ukusasazwa ngokuzenzekelayo nge-Ansible.
• Vitess -Inkqubo yokuhlanganisa iDatabase yokukalwa ngokuthe tye kweMySQL ngokwabelana ngokubanzi.

Kubernetes

• KubeDB -Ukwenza ugcino lwedatha yemveliso lube lula kwiKubernetes.
• Umsebenzisi wePostgres -I-Postgres Operator yenza ukuba amaqela e-PostgreSQL afumaneke kakhulu kwi-Kubernetes (K8s) exhaswa nguPatroni.
• Spilo -Amaqela e-HA PostgreSQL aneDocker.
• StackGres -Ibakala leShishini, iSitaki esipheleleyo sePostgreSQL kwiKubernetes.

Uqwalaselo Tuning

• I-MySQLTuner-perl -Iskripthi esibhalwe kwiPerl esikuvumela ukuba uphonononge ukufakwa kweMySQL ngokukhawuleza kwaye wenze uhlengahlengiso ukwandisa ukusebenza kunye nokuzinza.
• PGConfigurator -Isixhobo sasimahla kwi-intanethi ukwenza usetyenziso olulungiselelweyo postgresql.conf.
• pgtune -PostgreSQL iwizadi yoqwalaselo.
• postgresqltuner.pl -Iskripthi esilula sokuhlalutya uqwalaselo lwedatha yakho yePostgreSQL, kwaye unike iingcebiso zokulungisa.

DevOps

• DBmaestro -I-DBmaestro ikhawulezisa imijikelo yokukhulula kwaye ixhasa i-agility kuyo yonke i-IT ecosystem.
• Toad DevOps Toolkit -Isixhobo se-Toad DevOps Toolkit senza imisebenzi ephambili yophuhliso lwesiseko sedatha ngaphakathi kokuhamba komsebenzi wakho weDevOps-ngaphandle kokuthomalalisa umgangatho, ukusebenza okanye ukuthembeka.

Iisampulu zeschema

• I-Oracle Database yeSampule yeSchemas -I-Oracle Database yeSampule yeSchemas.

Ukubika

• Ipoli - Isicelo esilula ukusisebenzisa se-SQL sengxelo eyakhelwe abathandi beSQL.

Ukwabiwa

• DBdeployer -Isixhobo esisebenzisa iiseva zedatha yeMySQL ngokulula.
• iidbatools -Imodyuli yePowerShell onokucinga ngayo njengeSitudiyo soLawulo lweSeva yeSQL yomgca womyalelo.
• Postgres.app -Ufakelo olugcweleyo lwePostgreSQL lupakishwe njengenkqubo eqhelekileyo yeMac.
• BigSQL - Ukusasazwa komphuhlisi-friendly of Postgres.
• IShedi yeendlovu -Isiphelo sangaphambili solawulo lwePostgreSQL esekwe kwiWebhu edibanisa izinto ezininzi eziluncedo kunye nezicelo zokusetyenziswa ngePostgreSQL.

ukhuseleko

• accra — Indawo yokhuseleko lweDatabase. I-proxy ye-database ene-encryption yezinga le-field-level, khangela ngokusebenzisa idatha efihliweyo, uthintelo lwe-inaliti ye-SQL, ukubonwa kokungena, i-honeypot. Ixhasa i-client-side kunye ne-proxy-side ("transparent") ufihlo. SQL, NoSQL.

Iifomati zekhowudi

• CodeBuff -Ulwimi olungaziwayo luprinta ngokufunda koomatshini.

Ukuba negalelo

• Iminikelo yakho yamkelekile rhoqo! Nceda ufunde i izikhokelo zomnikelo Ekuqaleni.

Ukuba unayo nayiphi na into efunyenweyo kwisiseko sedatha, nceda wabelane. Ndiya kuvuya kwakhona ukufumana impendulo-PR's kunye neenkwenkwezi. Ukuba unayo nayiphi na imibuzo malunga nokwenza amaphepha akho, wabhale nawo.

umthombo: www.habr.com