Mhoro, Habr! Zvichida, mumwe nomumwe wedu ane faira apo tinovanza chimwe chinhu chinobatsira uye chinonakidza isu pachedu. Zvimwe zvinongedzo kuzvinyorwa, mabhuku, dura, zvinyorwa. Aya anogona kunge ari mabhukimaki ebhurawuza kana kungovhura tabu dzakasiiwa kuitira gare gare. Nekufamba kwenguva, zvese izvi zvinozvimba, zvinongedzo zvinomira kuvhurwa, uye zvizhinji zvezvishandiso zvinongove zvechinyakare.

Ko kana tikagovana kunaka uku nenharaunda uye toisa iyi faira paGitHub? Ipapo basa rako rinogona kubatsira kune mumwe munhu, uye iwe unogona kuchengetedza kukosha pamwe chete, kugamuchira zvigadziriso kubva kune avo vanoshuvira kuburikidza neyakanaka yekare maPR. Izvi ndizvo chaizvo zvakagadzirirwa chirongwa. Awesome lists. Inosanganisirwa muTOP 10 GitHub repositori, ine 138K nyeredzi, uye chinongedzo kumabasa ako chinogona kuoneka mumudzi wayo README, iyo inokwezva vateereri vakakura kubasa rako. Chokwadi, izvi zvinoda kushanda nesimba. Ndinoda kugovera ruzivo rwangu rwekuedza kwakadaro nemi.

Zita rangu ndinonzi Maxim Gramin. PaCROC ini ndinoita Java development uye tsvakurudzo yedatabase. Mune ino post ini ndichakuudza kuti Awesome Rondedzero chii uye maitiro ekuita yako yepamutemo inotyisa repo.

Chii Awesome Lists

Pandinofanira kufunga imwe tekinoroji nyowani kana mutauro wechirongwa, chinhu chekutanga chandinoita kuenda pano - ndinowana chikamu chakakodzera, uye mune mashiti akakodzera mairi. Uye tichitonga nehuwandu hwenyeredzi uye kukura kwavo nguva dzose, handizi ini chete ndinoita izvi.

Muchokwadi, iyi yakajairika flat readme.md, inogara mune yakaparadzana repositories, iri pachisere pakati pezvese GitHub repositori uye inosanganisira zvinongedzo kune mamwe mapepa akatsaurirwa kune chero musoro wenyaya. Semuenzaniso, muChikamu cheMitauro yeChirongwa unogona kuwana mapepa paAwesome Python uye Awesome Go, uye Front-End Development ine huwandu hukuru hwezviwanikwa pakuvandudza WEB. Uye, zvechokwadi, - chikamu Databases (Tichadzokera kune izvi zvishoma gare gare). Uye hongu, izvi zvese hazvina kuganhurirwa kumisoro yehunyanzvi. Semuenzaniso, muchikamu cheVaraidzo neMitambo unogonawo kuwana zvakawanda zvinonakidza zvinhu (ini pachangu ndakafara zvinoshamisa-kufungidzira).
Chinhu chikuru ndechekuti mapepa ese aya anochengetwa kwete nemunyori pachezvake, asi nenharaunda uye anounganidzwa maererano neakakosha uye akanyanya kuomarara. inoshamisa manifesto. Pepa rega rega rakadai inharaunda yakazvimirira yenyanzvi, inorarama hupenyu hwayo uye yakavhurika kune yako zvikumbiro zvekudhonza izvo zvinoita kuti zvive nani. Uye zvakare chero munhu anogona kugadzira yavo pepa kana imwe nyaya isati yavharwa.

Munyori wezano uye murongi weiyi bhizinesi rese ndiye ane mukurumbira Sindre Sorhus, munhu wekutanga paGitHub, munyori zvimwe 1000 npm modules, uye ndiye achagamuchira maPRs enyu.

Maitiro ekupinda mune inotyisa-rondedzero

Kana kamwe kamwe usina kuwana pepa rakakodzera pane imwe nyaya yaunofarira iwe, saka ichi ndicho chiratidzo chekutanga chaunofanira kuzviita iwe pachako!

Ini ndichakuudza ndichishandisa muenzaniso wepfungwa yangu. Awesome Database Zvishandiso -Kubva kupurojekiti kuenda kupurojekiti ndinofanirwa kushanda neakasiyana dhatabhesi, ndosaka ndakatanga faira randakatora maturusi anobatsira ekushanda navo, marudzi ese evatamisi vedatabase, maIDE, mapaneru e admin, maturusi ekutarisa nemhando dzese zvinhu zvakasiyana-siyana. Zvishandiso zvandatoshandisa kana kuti ndanga ndichironga kutanga kushandisa. Ndakagovera iyi faira nevamwe vandaishanda navo kuCROC uye mberi. Izvi zvakabatsira vanhu vakawanda uye zvainakidza. Somugumisiro, ndaida mukurumbira apo rimwe zuva ndakaona kuti muchikamu cheDatabases pakanga pasina pepa pamusoro penyaya iyi. Uye ndakafunga kuwedzera yangu ipapo.

Chii chinodiwa nokuda kweizvi?

1. Isu tinonyoresa yenguva dzose GitHub repo ine zita senge rinotyisa-chero. Mune yangu yaive inotyisa-database-zvishandiso
2. Isu tinounza pepa redu kune inotyisa fomati, izvi zvichatibatsira jenareta-inotyisa-rondedzero, iyo ichagadzira mafaira ose anodiwa mumhando inodiwa
3. Kugadzira CI chaiyo. rinotyisa-lint uye travis ci ichatibatsira kudzora chokwadi pepa redu
4. Tinomirira mazuva makumi matatu
5. Isu tinoongorora kanenge 2 vamwe vanhu PR's
6. Uye pakupedzisira tinoita PR kune iyo huru repo, kwatinowedzera chinongedzo kune yedu repo. Pano iwe unofanirwa kuverenga zvese zvakanyatsonaka uye nekunyatsozadzisa zvese zvakawanda zvinodiwa zvebepa idzva uye iyo PR pachayo.

Pancake yangu yekutanga akaita bundu

Asi nguva shoma yapfuura, ndakaunganidza zvakatowanda, ndikashanda pane zvikanganiso uye ndakashinga edza yechipiri.

Asi ndakakanganwa pamusoro pechinhu chakakosha zvikuru, chandakapihwa zvinyoro nyoro:

Ndakanga ndisina kungwarira uye handina kuwedzera unicorn kuratidza kuti mamiriro ese akasangana

Pakazoti papera nguva yakati wandei, mamwe mashoma ekugadzirisa akavakirwa pamashoko, uye akamirirwa kwenguva refu tweetkuti PR yangu yakagamuchirwa.

Saka ndakava munyori wepepa rangu rekutanga, uye vakatanga kugamuchira PR's kubva munharaunda kuwedzera zvishandiso zvitsva. Uye vazhinji vavo vakatoverengerwa mukati Awesome Database Zvishandiso. Kana iwe uine nungo yekutevera iyi link,

heino sarudzo yazvino panguva yekuburitswa kweiyo post

Awesome Database Zvishandiso

Nharaunda inofambiswa rondedzero yezvishandiso zve database

Pano isu tichaunganidza ruzivo nezve anoshamisa anobatsira uye anotyisa ekuedza maturusi ayo anorerutsa nemadhatabhesi eDBA, DevOps, Vagadziri uye vanhuwo zvavo.

Inzwa wakasununguka kuwedzera ruzivo nezve yako wega db-zvishandiso kana yako yaunofarira yechitatu-bato db-zvishandiso.

Mukati

• HERE
• GUI Mamaneja/Vatengi
• CLI zvishandiso
• DB-schema navigation uye kuona
• Modelers
• Zvishandiso zvekutama
• Maturusi ekugadzira makodhi
• Wrappers
• Zvishandiso zvekuchengetedza
• Kudzokorora/Kushanda kweData
• Scripts
• Monitoring/Statistics/Performance
  • Zabbix
• Testing
  • Data jenareta
• adhimini
• HA/Failover/Sharding
• Kubernetes
• Configuration Tuning
• DevOps
• Schema samples
• Reporting
• Distributions
• chibatiso
• Vagadziri vekodhi

HERE

• AnySQL Maestro - Premier multi-chinangwa admin chishandiso chekuchengetedza dhatabhesi, kutonga uye kusimudzira.
• Aqua Data Studio -Aqua Data Studio inogadzira software yeDatabase Developers, DBAs, uye Analysts.
• Database.net - Yakawanda dhatabhesi manejimendi chishandiso nerutsigiro rwemakumi maviri+ dhatabhesi.
• datagrip -Cross-Platform IDE yeDatabases & SQL neJetBrains.
• dbeaver - Yemahara yepasirese dhatabhesi maneja uye SQL mutengi.
• dbForge Studio yeMySQL - Universal IDE yeMySQL uye MariaDB dhatabhesi kusimudzira, manejimendi, uye manejimendi.
• dbForge Studio yeOracle - Yakasimba IDE yeOracle manejimendi, manejimendi, uye kusimudzira.
• dbForge Studio yePostgreSQL - GUI chishandiso chekugadzirisa nekugadzira dhatabhesi uye zvinhu.
• dbForge Studio yeSQL Server -Yakasimba yakabatanidzwa kusimudzira nharaunda yeSQL Server kusimudzira, manejimendi, manejimendi, kuongororwa kwedata, uye kushuma.
• dbKoda - Yemazuva ano (JavaScript / Electron framework), yakavhurika sosi IDE yeMongoDB. Iyo ine zvinhu zvekutsigira kusimudzira, kutonga uye kuita tuning pane MongoDB dhatabhesi.
• IBEexpert - Yakakwana GUI chishandiso cheFirebird uye InterBase.
• HeidiSQL -Mutengi asingaremi wekubata MySQL, MSSQL uye PostgreSQL, yakanyorwa muDelphi.
• mysql workbench -MySQL Workbench chishandiso chakabatana chekuona chevagadziri vedatabase, vanogadzira, uye maDBA.
• navicat -Chishandiso chekuvandudza dhatabhesi chinokutendera kuti ubatanidze panguva imwe chete kuMySQL, MariaDB, SQL Server, Oracle, PostgreSQL, uye SQLite dhatabhesi kubva kune imwechete application.
• Oracle SQL Mushambadzi -Oracle SQL Developer inzvimbo yemahara, yakabatanidzwa yekusimudzira inorerutsa kusimudzira uye manejimendi eOracle Database mune ese echinyakare uye Cloud deployments.
• pgAdmin -Iyo inonyanya kufarirwa uye inoratidzira yakapfuma Open Source manejimendi uye kusimudzira chikuva chePostgreSQL, yakanyanya kukwirisa Open Source dhatabhesi munyika.
• pgAdmin3 -Kutsigira Kwenguva Yakareba kwepgAdmin3.
• PL/SQL Developer - IDE yakanangidzirwa pakuvandudzwa kwezvikamu zvechirongwa zvakachengetwa zveOracle Databases.
• PostgreSQL Maestro -Yakazara uye ine simba dhatabhesi manejimendi, admin uye kusimudzira chishandiso chePostgreSQL.
• toad -Toad ndiyo yekutanga dhatabhesi mhinduro yevagadziri, admins uye vanoongorora data. Tonga shanduko yakaoma yedatabase ine imwechete database manejimendi chishandiso.
• Toad Edge - Yakareruka dhatabhesi yekuvandudza chishandiso cheMySQL uye Postgres.
• TOra - TOra ndeye yakavhurika sosi SQL IDE yeOracle, MySQL uye PostgreSQL dbs.
• Valentina Studio -Gadzira, tonga, bvunza uye ongorora Valentina DB, MySQL, MariaDB, PostgreSQL uye SQLite dhatabhesi MAHARA.

GUI Mamaneja/Vatengi

• admin - Dhatabhesi manejimendi mune imwechete PHP faira.
• DbVisualizer - Yese dhatabhesi chishandiso chevagadziri, DBAs uye vanoongorora.
• HouseOps - Enterprise ClickHouse Ops UI yako inomhanyisa mibvunzo, kutarisa hutano hweClickHouse uye kuita kuti vamwe vazhinji vafunge.
• JackDB -Yakananga SQL kuwana kune yako yese data, zvisinei kuti inogara kupi.
• OmniDB - Webhu chishandiso chekutarisira database.
• Pgweb - Webhu-based database browser yePostgreSQL, yakanyorwa muGo uye inoshanda pane macOS, Linux uye Windows michina.
• phpLiteAdmin - Webhu-yakavakirwa SQLite dhatabhesi admin chishandiso chakanyorwa muPHP nerutsigiro rweSQLite3 uye SQLite2.
• phpMyAdmin -A web interface yeMySQL uye MariaDB.
• psequel - PSequel inopa yakachena uye yakapusa interface yekuti iwe uite zvakajairika PostgreSQL mabasa nekukurumidza.
• PopSQL -Yazvino, inodyidzana SQL mupepeti wechikwata chako.
• Postico -Azvino PostgreSQL Mutengi weMac.
• Robo 3T - Robo 3T (yaimbova Robomongo) is shell-centric cross-platform MongoDB management tool.
• Sequence Pro -Sequel Pro inokurumidza, iri nyore kushandisa Mac dhatabhesi manejimendi application yekushanda neMySQL & MariaDB dhatabhesi.
• SQL Operations Studio -Chishandiso chekushandisa data chinogonesa kushanda neSQL Server, Azure SQL DB uye SQL DW kubva kuWindows, macOS neLinux.
• SQLite Nyanzvi - Graphical interface inotsigira ese SQLite maficha.
• sqlpad -Webhu-yakavakirwa SQL mupepeti inomhanya mune yako yakavanzika gore.
• SQLPro -Yakareruka, ine simba Postgres maneja ye macOS.
• SQuirreL - Graphical SQL mutengi yakanyorwa muJava iyo inokutendera iwe kuti utarise chimiro cheJDBC inoenderana dhatabhesi, tsvaga iyo data mumatafura, buritsa SQL mirairo nezvimwe.
• SQLTools - Dhatabhesi manejimendi yeVSCode.
• SQLyog -Iyo yakakwana uye iri nyore kushandisa MySQL GUI.
• Tabix - SQL Mharidzo & Vhura sosi yakapusa bhizinesi kungwara kweClickhouse.
• TafuraPlus -Yazvino, yemuno, uye inoshamwaridzana GUI chishandiso chehukama dhatabhesi: MySQL, PostgreSQL, SQLite nezvimwe.
• TeamPostgreSQL - PostgreSQL Web Administration GUI - shandisa yako PostgreSQL dhatabhesi kubva chero kupi, ine hupfumi, mheni-inokurumidza AJAX web interface.

CLI zvishandiso

• ipython-sql - Batanidza kune dhatabhesi yekuburitsa SQL mirairo mukati meIPython kana IPython Notebook.
• iredis - A Cli yeRedis ine AutoCompletion uye Syntax Kusimudzira.
• pgcenter - Yepamusoro-senge admin chishandiso chePostgreSQL.
• pg_activity -Pamusoro senge application yePostgreSQL server chiitiko chekutarisa.
• pg_top - 'pamusoro' yePostgreSQL.
• pspg —Postgres Pager
• sql - Oracle SQL Developer Command Line (SQLcl) ndeyemahara yekuraira mutsara interface yeOracle Database.
• usql - Yepasirese yekuraira-mutsara interface yePostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, uye mamwe akawanda databases kusanganisira NoSQL uye isiri-yehukama dhatabhesi!

dbcli

• athenacl -AthenaCLI chishandiso cheCLI cheAWS Athena sevhisi iyo inogona kuita otomatiki kupedzisa uye kusimbisa syntax.
• Litecli -CLI yeSQLite Database ine auto-kupedzisa uye syntax inosimudzira.
• mssql-cli -Mutengi-mutsara wemutengi weSQL Server ine otomatiki-kuzadza uye syntax inosimudzira.
• mycli -A Terminal Client yeMySQL ine AutoCompletion uye Syntax Highlighting.
• pgcli -Postgres CLI ine autocompletion uye syntax inosimudzira.
• vcli - Vertica CLI ine auto-kupedzisa uye syntax inosimudzira.

DB-schema navigation uye kuona

• dbdiagram.io -Kurumidza uye nyore chishandiso chekubatsira iwe kudhirowa dhayagiramu yehukama hwe database uye kuyerera nekukurumidza uchishandisa nyore DSL mutauro.
• ERAlchemy - Entity Relation Diagrams yekugadzira chishandiso.
• SchemaCrawler - Yemahara dhatabhesi schema kuwanikwa uye nzwisiso chishandiso.
• Schema Spy -Kugadzira dhatabhesi yako kune zvinyorwa zveHTML, kusanganisira Entity Relationship diagram.
• tbls - CI-Hushamwari chishandiso chegwaro dhatabhesi, rakanyorwa muGo.

Modelers

• Navicat Dhata Modeler -Iyo ine simba uye inodhura-inoshanda dhizaini yedhizaini iyo inokubatsira iwe kuvaka emhando yepamusoro pfungwa, inonzwisisika uye yemuviri data modhi.
• Oracle SQL Developer Data Modeler -Oracle SQL Developer Data Modeler ndeyemahara graphical chishandiso chinosimudzira kugadzirwa uye kurerutsa data modelling mabasa.
• pgmodeler -Data modelling tool yakagadzirirwa PostgreSQL.

Zvishandiso zvekutama

• 2bass -Databhesi yekumisikidza-se-kodhi chishandiso chinoshandisa pfungwa yeidempotent DDL zvinyorwa.
• flyway - Database migration tool.
• gh-ost - Online schema kutama kweMySQL.
• liquibase -Databhesi-yakazvimirira raibhurari yekutevera, kutonga uye kushandisa database schema shanduko.
• migrates -Kufanana nekusiyana asi kune PostgreSQL schemas.
• node-pg-migrate -Node.js dhatabhesi yekufambisa manejimendi yakavakirwa chete postgres. (Asi inogona zvakare kushandiswa kune mamwe maDB anoenderana neSQL standard - eg CockroachDB.)
• Pyrseas -Inopa zvinoshandiswa kutsanangura iyo PostgreSQL dhatabhesi schema seYAML.
• SchemaHero -A Kubernetes opareta yeanozivisa dhatabhesi schema manejimendi (gitops yedatabase schemas).
• Sqitch - Inonzwisisika dhatabhesi-yekuzvarwa shanduko manejimendi yekusimudzira-isina kusimudzira uye yakavimbika kuendesa.
• yuniql - Chimwezve schema shanduro uye migration chishandiso changogadzirwa neveko.NET Core 3.0+ uye tinovimba zviri nani.

Maturusi ekugadzira makodhi

• ddl-jenareta -Infers SQL DDL (Data Tsanangudzo Mutauro) kubva patafura data.
• chirongwa2ddl - Raira mutsara wekushandisa kutumira kunze Oracle schema kuseta ddl init zvinyorwa nekugona kusefa isingadikanwi ruzivo, patsanura DDL mumafaira akasiyana, yakanaka fomati inobuda.

Wrappers

• Zviroto - Yakavhurika sosi REST API backend yenharembozha, webhu, uye IoT zvikumbiro.
• Hasura GraphQL Injini -Kupisa nekukurumidza, nekukurumidza realtime GraphQL APIs paPostgres ine yakanaka gorosi yekuwana yekutonga, zvakare inokonzeresa webhooks pane database zviitiko.
• jl-sql - SQL yeJSON uye CSV hova.
• mysql_fdw -PostgreSQL yekune dzimwe nyika data wrapper yeMySQL.
• Oracle REST Data Services -Iyo yepakati-tier Java application, ORDS mepu HTTP (S) verbs (GET, POST, PUT, DELETE, nezvimwewo) kune dhatabhesi transactions uye inodzosera chero mhinduro dzakarongwa uchishandisa JSON.
• Prisma -Prisma inoshandura dhatabhesi yako kuita realtime GraphQL API.
• postgREST - REST API yechero Postgres dhatabhesi.
• perst -Iyo nzira yekushandira RESTful API kubva kune chero dhatabhesi rakanyorwa muGo.
• restSQL - SQL jenareta ine Java neHTTP APIs, inoshandisa iri nyore RESTful HTTP API ine XML kana JSON serialization.
• resquel -Shandura zviri nyore yako SQL dhatabhesi kuita REST API.
• sandman2 -Gadzira otomatiki iyo RESTful API sevhisi kune yako legacy dhatabhesi.
• sql-boot - Yepamberi REST uye UI kuputira kune yako SQL-mibvunzo.

Zvishandiso zvekuchengetedza

• pgbackrest -Yakavimbika PostgreSQL Backup & Dzosera.
• Barman -Kuchengetedza uye Kudzoreredza Maneja wePostgreSQL.

Kudzokorora/Kushanda kweData

• Datasette -Chishandiso chekuongorora uye kuburitsa data.
• dtle - Yakagoverwa Data Transfer Service yeMySQL.
• pgsync - Sync Postgres data pakati pedhatabhesi.
• pg_chameleon - MySQL kuPostgreSQL replica system yakanyorwa muPython 3. Iyo sisitimu inoshandisa raibhurari mysql-replication kudhonza mitsara mifananidzo kubva kuMySQL iyo inochengetwa muPostgreSQL seJSONB.
• PGDeltaStream - Iyo Golang webserver yekuyerera Postgres inoshandura kamwechete-kamwe chete pamusoro pewebhu, uchishandisa Postgres inonzwisisika decoding chimiro.
• repmgr -Iye Anonyanya Kuzivikanwa Replication Maneja wePostgreSQL.

Scripts

• pgx_scripts -Muunganidzwa wezvinyorwa zvidiki zvinobatsira zvekuongorora dhatabhesi uye kutonga, yakagadzirwa nechikwata chedu kuPostgreSQL Nyanzvi.
• pgsql-bloat-estimation -Mibvunzo yekuyera bloat yehuwandu mune indexes uye matafura ePostgreSQL.
• pgWikiDont - SQL bvunzo inotarisa kana dhatabhesi yako ichitevera mitemo kubva https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-utils - Inobatsira PostgreSQL zvishandiso.
• Postgres cheat sheet -Inobatsira SQL-zvinyorwa uye mirairo na .
• postgres_dba - Iyo yakarasika seti yezvishandiso zvinobatsira zvePostgres DBAs uye ese mainjiniya.
• postgres_queries_and_commands.sql -Inobatsira PostgreSQL Mibvunzo uye Mirairo.
• TPT - Aya sqlplus zvinyorwa ndezveOracle Database performance optimization & kugadzirisa matambudziko.

Monitoring/Statistics/Performance

• ASH Viewer -Inopa graphical maonero einoshingaira chikamu nhoroondo data mukati meOracle uye PostgreSQL DB.
• Monyog -Isina mumiririri uye inodhura-inoshanda MySQL Monitoring Turusi.
• mssql-kutarisa - Tarisa yako SQL Server paLinux maitiro uchishandisa yakaunganidzwa, InfluxDB uye Grafana.
• Navicat Monitor -Yakachengeteka, yakapusa uye isina mumiriri kure server yekutarisa chishandiso icho chakazara nezvinhu zvine simba kuita kuti yako yekutarisa ishande sezvinobvira.
• Percona Monitoring uye Management - Vhura sosi chikuva chekutonga uye chekutarisa MySQL uye MongoDB kuita.
• pganalyze collector -Pganalyze manhamba muunganidzi wekuunganidza PostgreSQL metrics uye log data.
• postgres-checkup -Chizvarwa chitsva chekuongorora chishandiso chinobvumira vashandisi kuita ongororo yakadzama yehutano hwePostgres dhatabhesi.
• postgres_exporter -Prometheus mutengesi wePostgreSQL server metrics.
• pgDash -Kuyera uye kutevedzera ese maficha ePostgreSQL dhatabhesi.
• PgHero -Dhibhodhi rekuita rePostgres - macheki ehutano, akakurudzirwa indexes, nezvimwe.
• pgmetrics - Unganidza uye ratidza ruzivo uye zviverengero kubva kune inomhanya PostgreSQL server.
• pgMustard -Mushandisi interface yePostgres inotsanangura zvirongwa, pamwe nematipi ekuvandudza mashandiro.
• pgstats -Inounganidza nhamba dzePostgreSQL, uye dzinozvichengeta mumafaira eCSV kana kuzvidhinda pane stdout.
• pgwat2 - Flexible yega-ine PostgreSQL metrics yekutarisa / dashboarding mhinduro.
• Telegraf PostgreSQL plugin -Inopa metrics kune yako postgres dhatabhesi.

Zabbix

• Mamonsu -Kutarisisa mumiriri wePostgreSQL.
• Orabbix - Orabbix iplugin yakagadzirirwa kushanda neZabbix Enterprise Monitor kuti ipe akawanda-matiresi ekutarisa, kuita uye kuwanikwa kwekubika uye kuyerwa kweOracle Databases, pamwe chete neserver performance metrics.
• pg_monz - Iyi ndiyo Zabbix yekutarisa template yePostgreSQL Database.
• Pyora -Python script yekutarisa Oracle Databases.
• ZabbixDBA -ZabbixDBA inokurumidza, inochinjika, uye inoramba ichigadzira plugin yekutarisa RDBMS yako.

Testing

• DbFit -Iyo dhatabhesi yekuyedza dhizaini inotsigira nyore bvunzo-inofambiswa kusimudzira kwekodhi yako yedatabase.
• RegreSQL - Regression Kuedza yako SQL mibvunzo.

Data jenareta

• Databene Benerator -Iyo dhizaini yekugadzira yechokwadi uye inoshanda yakakwira-vhoriyamu bvunzo data kune yako system mukuyedzwa (kudzivisa iyo Datalite anti-pattern).
• dbForge Data Generator yeMySQL -Yakasimba GUI chishandiso chekugadzira mavhoriyamu makuru echokwadi bvunzo data.
• dbForge Dhata jenareta yeOracle -Idiki asi ine simba GUI chishandiso chekuzadza Oracle schemas nematani echokwadi bvunzo data.
• dbForge Data Generator yeSQL Server -Yakasimba GUI chishandiso chekukurumidza chizvarwa cheyakakosha bvunzo data yedatabase.

adhimini

• pgbadger -Inokurumidza PostgreSQL Log Analyzer.
• pgbedrock - Tonga mabasa ePostgres cluster, nhengo dzebasa, schema varidzi, uye neropafadzo.
• pgslice -Postgres partitioning zviri nyore sepai.

HA/Failover/Sharding

• Citus -Postgres yekuwedzera iyo inogovera data rako uye mibvunzo yako munzvimbo dzakawanda.
• patroni - Iyo template yePostgreSQL Yakakwirira Kuwanikwa neZooKeeper, etcd, kana Consul.
• Percona XtraDB Cluster - Yakakwira Scalability Solution yeMySQL Clustering uye Kuwanikwa Kwepamusoro.
• stolon - Cloud yekuzvarwa PostgreSQL maneja yePostgreSQL kuwanikwa kwepamusoro.
• pg_auto_failover -Postgres yekuwedzera uye sevhisi yeotomatiki failover uye yakakwirira-kuwanikwa.
• pglookout -PostgreSQL replication yekutarisa uye failover daemon.
• PostgreSQL Automatic Failover -Kuwanikwa Kwepamusoro kwePostgres, zvichibva pane mareferensi eindasitiri Pacemaker uye Corosync.
• postgresql_cluster - PostgreSQL Yakakwirira-Kuwanikwa Cluster (yakavakirwa pa "Patroni" uye "DCS (etcd)"). Automating deployment neAnsible.
• Vitess -Database clustering system yekuyera kuyera kweMySQL kuburikidza neyakajairwa sharding.

Kubernetes

• KubeDB -Kuita kuti dhizaini yekugadzira-giredhi zvive nyore paKubernetes.
• Postgres operator - Iyo Postgres Operator inogonesa-inowanikwa PostgreSQL masumbu paKubernetes (K8s) anofambiswa naPatroni.
• Spilo - HA PostgreSQL Masumbu ane Docker.
• StackGres -Bhizinesi-giredhi, Yakazara Stack PostgreSQL paKubernetes.

Configuration Tuning

• MySQLTuner-perl - Script yakanyorwa muPerl iyo inokutendera kuti uongorore kuisirwa kweMySQL nekukurumidza uye kugadzirisa kuti uwedzere kuita uye kugadzikana.
• PGConfigurator - Yemahara online chishandiso kugadzira yakagadziridzwa postgresql.conf.
• pgtune -PostgreSQL kumisikidza wizard.
• postgresqltuner.pl -Chinyorwa chakareruka chekuongorora yako PostgreSQL dhatabhesi kumisikidzwa, uye kupa tuning zano.

DevOps

• DBmaestro - DBmaestro inomhanyisa kutenderera kutenderera uye inotsigira agility mukati meiyo yese IT ecosystem.
• Toad DevOps Toolkit -Toad DevOps Toolkit inoita akakosha ekuvandudza dhatabhesi mabasa mukati meDevOps yako mafambiro ekufambisa - pasina kukanganisa kunaka, kuita kana kuvimbika.

Schema samples

• Oracle Database Sample Schemas - Oracle Database Sample Schemas.

Reporting

• Poly -Iyo nyore kushandisa SQL yekubika application yakavakirwa vanoda SQL.

Distributions

• DBdeployer -Chishandiso chinotumira MySQL dhatabhesi maseva zviri nyore.
• dbatools - PowerShell module yaungafunga nezvayo seyekuraira-mutsara SQL Server Management Studio.
• Postgres.app -Yakazara-inoratidzwa PostgreSQL yekumisikidza yakaiswa seyakajairwa Mac app.
• BigSQL -Kugovera-inoshamwaridzika kugovera kwePostgres.
• Shedhi reNzou - Webhu-yakavakirwa PostgreSQL manejimendi kumberi-kuguma iyo inounganidza akati wandei maturusi uye maapplication ekushandisa nePostgreSQL.

chibatiso

• accra -Database kuchengetedza suite. Database proxy ine munda-level encryption, tsvaga kuburikidza neyakavharidzirwa data, SQL jekiseni kudzivirira, kuona intrusion, mapoto. Inotsigira mutengi-parutivi uye proxy-divi ("pachena") encryption. SQL, NoSQL.

Vagadziri vekodhi

• CodeBuff -Mutauro-agnostic yakanaka-kudhinda kuburikidza nekudzidza muchina.

Kupa

• Mipiro yako inogamuchirwa nguva dzose! Ndapota verenga mipiro nhungamiro chekutanga.

Kana iwe uine chero chawawana kune database, ndapota govana. Ini zvakare ndichafara kugamuchira mhinduro - PR's uye nyeredzi. Kana uine mibvunzo pamusoro pekugadzira mapepa ako, zvinyorewo.

Source: www.habr.com