Hello, Habr! Wataƙila, kowannenmu yana da fayil inda muke ɓoye wani abu mai amfani da ban sha'awa ga kanmu. Wasu hanyoyin haɗi zuwa labarai, littattafai, wuraren ajiya, littattafai. Waɗannan za su iya zama alamun burauza ko ma buɗe shafukan da aka bari na gaba. Bayan lokaci, duk wannan yana kumbura, hanyoyin haɗin gwiwa suna daina buɗewa, kuma yawancin kayan kawai sun zama tsofaffi.

Idan muka raba wannan alherin tare da al'umma kuma muka buga wannan fayil ɗin akan GitHub? Sa'an nan aikinku na iya zama da amfani ga wani, kuma za ku iya kula da dacewa tare, karɓar sabuntawa daga waɗanda suke so ta hanyar tsohuwar PR's. Wannan shi ne ainihin abin da aka tsara aikin. Lissafi masu ban sha'awa. An haɗa shi a cikin ɗakunan ajiya na TOP 10 GitHub, yana da taurari 138K, kuma hanyar haɗi zuwa ayyukanku na iya bayyana daidai a tushen README, wanda zai jawo hankalin masu sauraro masu yawa zuwa aikinku. Gaskiya, wannan zai buƙaci ƙoƙari kaɗan. Ina so in raba gwaninta na irin wannan ƙoƙarin tare da ku.

Sunana Maxim Gramin. A CROC Ina yin ci gaban Java da bincike na bayanai. A cikin wannan post ɗin zan gaya muku abin da Listoci masu ban sha'awa suke da yadda ake yin repo na hukuma mai ban mamaki.

Menene Lissafi masu ban sha'awa

Lokacin da na gano wasu sababbin fasaha ko yaren shirye-shirye, abu na farko da zan yi shi ne zuwa nan - Na sami sashin da ya dace, kuma akwai zanen gado masu dacewa a ciki. Kuma idan aka yi la’akari da adadin taurari da ci gaba da girma, ba ni kaɗai nake yin wannan ba.

A zahiri, wannan ƙaramin lebur readme.md ne, wanda ke zaune a cikin wani dabam wuraren ajiya, yana matsayi na 8 a cikin duk wuraren ajiyar GitHub kuma ya haɗa da hanyoyin haɗin kai zuwa wasu zanen gado da aka keɓe ga kowane batu. Misali, a sashen Programming Languages ​​zaka iya samun zanen gado akan Awesome Python da Awesome Go, kuma Front-End Development yana da dimbin albarkatu akan ci gaban WEB. Kuma, ba shakka, - sashe Databases (Zamu dawo kan wannan kadan kadan). Kuma a, duk wannan bai iyakance ga batutuwan fasaha ba. Misali, a cikin sassan Nishaɗi da Wasanni kuma kuna iya samun abubuwa masu ban sha'awa da yawa (Na ji daɗi da kaina madalla-fantasy).
Babban fasalin shi ne cewa duk waɗannan zane-zane ba a kiyaye su daga marubucin da kansa ba, amma ta al'umma kuma an haɗa su daidai da na musamman kuma mai tsanani. m manifesto. Kowace irin wannan takarda wata al'umma ce mai zaman kanta ta kwararru, tana rayuwarta kuma tana buɗewa ga buƙatun ku wanda zai sa ya fi kyau. Haka kuma kowa na iya yin takardar kansa idan har yanzu ba a rufe wasu batutuwa ba.

Marubucin ra'ayin kuma mai gudanarwa na wannan masana'antar gaba ɗaya shine almara Sindre Sorhus, mutum na farko akan GitHub, marubucin ƙari 1000 npm modules, kuma shi ne zai karbi PRs na ku.

Yadda ake shiga cikin jerin abubuwan ban mamaki

Idan ba zato ba tsammani ba ku sami takarda mai dacewa a kan batun da ke sha'awar ku ba, to wannan ita ce alamar farko da kuke buƙatar yin shi da kanku!

Zan gaya muku ta amfani da misalin ƙwalƙwalwata. Kayayyakin Database mai ban sha'awa - Daga aikin zuwa aikin dole ne in yi aiki tare da bayanai iri-iri, kuma shine dalilin da ya sa na fara fayil ɗin da na tattara kayan aiki masu amfani don aiki tare da su, duk nau'ikan masu ƙaura na bayanai, IDEs, panels admin, kayan aikin sa ido da kowane nau'in. abubuwa daban-daban. Kayan aikin da na riga na yi amfani da su ko kuma nake shirin fara amfani da su. Na raba wannan fayil ɗin tare da abokan aiki a CROC da ƙari. Wannan ya taimaka wa mutane da yawa kuma yana da ban sha'awa. Sakamakon haka, ina son ƙarin shahara lokacin da wata rana na lura cewa a cikin sashin Databases babu takarda akan wannan batu. Kuma na yanke shawarar ƙara nawa a wurin.

Menene ake bukata don wannan?

1. Muna yin rijistar GitHub repo na yau da kullun tare da suna kamar madalla-komai. A cikin yanayina yana da ban mamaki-database-kayan aikin
2. Mun kawo takardar mu zuwa tsari mai ban mamaki, wannan zai taimake mu janareta-mai ban mamaki-jeri, wanda zai samar da duk mahimman fayiloli a tsarin da ake buƙata
3. Saita ainihin CI. madalla-lint kuma travis ci zai taimake mu sarrafa inganci takardar mu
4. Muna jira kwanaki 30
5. Muna bitar aƙalla 2 na wasu PR's
6. Kuma a ƙarshe mun yi PR zuwa babban repo, inda muka ƙara hanyar haɗi zuwa ga repo. Anan kuna buƙatar karanta komai a hankali kuma ku cika duk buƙatun da yawa don sabon takaddar da PR kanta.

pancake na farko ya zama lumpy

Amma ɗan lokaci kaɗan ya wuce, na tattara ƙarin kayan aiki, na yi aiki akan kurakurai kuma na yi ƙarfin hali gwaji na biyu.

Amma na manta da wani abu mai mahimmanci, wanda aka yi mini ishara a hankali:

Ban yi hankali sosai ba kuma ban ƙara unicorn ba don tabbatar da cewa an cika duk sharuɗɗan

Sannan ɗan lokaci kaɗan ya wuce, wasu ƴan gyare-gyare bisa sharhi, da abin da aka daɗe ana jira tweetcewa an karɓi PR dina.

Don haka na zama marubucin takarda ta farko, suka fara karba PR's daga al'umma don ƙara sababbin kayan aiki. Kuma da yawa daga cikinsu an riga an haɗa su Kayayyakin Database mai ban sha'awa. Idan ka yi kasala ka bi hanyar,

a nan ne zaɓi na yanzu a lokacin buga post

Kayayyakin Database mai ban sha'awa

Jerin kayan aikin tattara bayanai na al'umma

Anan zamu tattara bayanai game da kayan aikin gwaji masu fa'ida masu fa'ida da ban mamaki waɗanda ke sauƙaƙe tare da bayanan bayanai don DBA, DevOps, Masu haɓakawa da ƴan Adam kawai.

Jin kyauta don ƙara bayani game da kayan aikin db ɗin ku ko kayan aikin db na ɓangare na uku da kuka fi so.

Contents

• HERE
• GUI Managers/Abokan ciniki
• CLI kayan aikin
• DB-tsari kewayawa da gani
• Masu yin samfura
• Kayan aikin ƙaura
• Kayan aikin ƙirƙira code
• Wrappers
• Ajiyayyen kayan aikin
• Maimaita aiki/Bayani aiki
• Scripts
• Kulawa/Kididdiga/Ayyuka
  • Zabbix
• Testing
  • Mai samar da bayanai
• Administration
• HA/Rashin nasara/Sharding
• Kubernetes
• Gyaran Kanfigareshan
• DevOps
• Samfuran tsari
• Rahoto
• Raba
• Tsaro
• Masu tsara lamba

HERE

• AnySQL Maestro - Premier multi-purpose admin kayan aiki don sarrafa bayanai, sarrafawa da haɓakawa.
• Aqua Data Studio - Aqua Data Studio shine software na haɓakawa don Masu Haɓaka Bayanai, DBAs, da Manazarta.
• Database.net - Kayan aikin sarrafa bayanai da yawa tare da tallafi don bayanan bayanai 20+.
• datagrip - Cross-Platform IDE don Databases & SQL ta JetBrains.
• Bayarwa - Manajan bayanai na duniya kyauta da abokin ciniki na SQL.
• dbForge Studio don MySQL - Universal IDE don MySQL da MariaDB haɓaka bayanai, gudanarwa, da gudanarwa.
• dbForge Studio don Oracle - IDE mai ƙarfi don gudanarwa, gudanarwa, da haɓaka Oracle.
• dbForge Studio don PostgreSQL - Kayan aikin GUI don sarrafawa da haɓaka bayanan bayanai da abubuwa.
• dbForge Studio don SQL Server - Kyakkyawan yanayin haɓaka haɓaka haɓaka don haɓaka SQL Server, gudanarwa, gudanarwa, nazarin bayanai, da bayar da rahoto.
• dbKoda - Na zamani (tsarin JavaScript/Electron), buɗaɗɗen tushen IDE don MongoDB. Yana da fasalulluka don tallafawa haɓakawa, gudanarwa da daidaita aiki akan bayanan MongoDB.
• IBE gwani - Cikakken kayan aikin GUI don Firebird da InterBase.
• HeidiSQL - Abokin ciniki mara nauyi don sarrafa MySQL, MSSQL da PostgreSQL, wanda aka rubuta a Delphi.
• mysql workbench - MySQL Workbench kayan aiki ne na gani ɗaya don masu gine-ginen bayanai, masu haɓakawa, da DBAs.
• navicat - Kayan aikin haɓaka bayanai wanda ke ba ku damar haɗawa lokaci guda zuwa MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, da bayanan SQLite daga aikace-aikacen guda ɗaya.
• Oracle SQL Mai haɓakawa - Mai Haɓakawa Oracle SQL kyauta ne, yanayin haɓaka haɓakawa wanda ke sauƙaƙa haɓakawa da sarrafa bayanan Oracle a cikin ayyukan al'ada da na Cloud.
• pgAdmin - Mafi shahara kuma fasalin gudanarwar Buɗaɗɗen Gudanarwa da dandamali na haɓakawa don PostgreSQL, mafi kyawun tushen tushen bayanai a duniya.
• pgAdmin3 - Taimakon Dogon Lokaci don pgAdmin3.
• PL/SQL Developer - IDE wanda aka yi niyya na musamman don haɓaka rukunin shirye-shiryen da aka adana don Oracle Databases.
• PostgreSQL Maestro - Cikakken kuma mai ƙarfi sarrafa bayanai, gudanarwa da kayan haɓaka don PostgreSQL.
• toad - Toad shine mafita na farko don masu haɓakawa, admins da manazarta bayanai. Sarrafa rikitattun canje-canjen bayanai tare da kayan aikin sarrafa bayanai guda ɗaya.
• Tushen Edge - Sauƙaƙe kayan aikin haɓaka bayanai don MySQL da Postgres.
• TOra - TOra shine tushen budewar SQL IDE don Oracle, MySQL da PostgreSQL dbs.
• Valentina Studio - Ƙirƙiri, gudanarwa, tambaya da bincika Valentina DB, MySQL, MariaDB, PostgreSQL da bayanan SQLite don KYAUTA.

GUI Managers/Abokan ciniki

• Mai Gudanarwa - Gudanar da bayanai a cikin fayil ɗin PHP guda ɗaya.
• DbVisualizer - Kayan aikin bayanai na duniya don masu haɓakawa, DBAs da manazarta.
• HouseOps - Enterprise ClickHouse Ops UI don ku gudanar da tambayoyin, sa ido kan lafiyar ClickHouse da sa wasu da yawa suyi tunani.
• JackDB - Kai tsaye SQL damar zuwa duk bayanan ku, komai inda yake zaune.
• OmniDB - Kayan aikin gidan yanar gizo don sarrafa bayanai.
• Pgweb - Mai binciken bayanan yanar gizo na PostgreSQL, wanda aka rubuta a cikin Go kuma yana aiki akan injunan macOS, Linux da Windows.
• phpLiteAdmin - Kayan aikin sarrafa bayanan SQLite na tushen yanar gizo da aka rubuta a cikin PHP tare da tallafi don SQLite3 da SQLite2.
• phpMyAdmin - Yanar gizo don MySQL da MariaDB.
• psequel - Psequel yana ba da ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙa'idodin don aiwatar da ayyukan PostgreSQL na gama gari cikin sauri.
• PopSQL - Na zamani, editan SQL na haɗin gwiwa don ƙungiyar ku.
• Postico - Abokin ciniki na PostgreSQL na zamani don Mac.
• Robo 3T - Robo 3T (tsohon Robomongo) kayan aikin sarrafa kayan aikin MongoDB ne na tsaka-tsakin harsashi.
• Binciko Pro - Sequel Pro mai sauri ne, mai sauƙin amfani da aikace-aikacen sarrafa bayanai na Mac don aiki tare da bayanan MySQL & MariaDB.
• SQL Ayyuka Studio - Kayan aikin sarrafa bayanai wanda ke ba da damar aiki tare da SQL Server, Azure SQL DB da SQL DW daga Windows, macOS da Linux.
• Masanin SQLite - Keɓantaccen hoto yana goyan bayan duk fasalulluka na SQLite.
• sqlpad - Editan SQL na tushen yanar gizo yana gudana a cikin gajimare na sirri na ku.
• SQLPro - Mai sauƙi, mai sarrafa Postgres mai ƙarfi don macOS.
• SQuirreL - Abokin ciniki na SQL na zane wanda aka rubuta a cikin Java wanda zai ba ku damar duba tsarin tsarin bayanan JDBC, bincika bayanai a cikin tebur, bayar da umarnin SQL da sauransu.
• SQLTools - Gudanar da bayanan bayanai don VSCode.
• sqlyog - Mafi cikakke kuma mai sauƙin amfani MySQL GUI.
• Tabix - Editan SQL & Buɗe tushen bayanan kasuwanci mai sauƙi don Clickhouse.
• Table Plus - Kayan aikin GUI na zamani, ɗan ƙasa, da abokantaka don alaƙar bayanai: MySQL, PostgreSQL, SQLite & ƙari.
• TeamPostgreSQL GUI Gudanarwar Yanar Gizo na PostgreSQL - yi amfani da bayanan bayanan ku na PostgreSQL daga ko'ina, tare da wadatar yanar gizo mai saurin walƙiya AJAX.

CLI kayan aikin

• ipython-sql - Haɗa zuwa bayanan bayanai don fitowar umarnin SQL a cikin IPython ko littafin rubutu na IPython.
• iredis - A Cli don Redis tare da AutoCompletion da Haskakawa Haɗin kai.
• pgcenter - Babban kayan aikin gudanarwa na PostgreSQL.
• pg_aiki - Babban kamar aikace-aikacen don sa ido kan ayyukan uwar garken PostgreSQL.
• pg_ saman - 'saman' don PostgreSQL.
• psg - Postgres Pager
• sql - Layin Umarnin Mai Haɓakawa na Oracle SQL (SQLcl) layin umarni ne kyauta don Oracle Database.
• usql - Tsarin layin umarni na duniya don PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, da sauran rumbun adana bayanai gami da NoSQL da bayanan bayanan da ba na alaƙa ba!

dbcli

• athenacl - AthenaCLI kayan aiki ne na CLI don sabis na AWS Athena wanda zai iya yin cikawa ta atomatik da nuna alama.
• litecli - CLI don SQLite Databases tare da cikawa ta atomatik da nuna alama.
• mssql-cli - Abokin ciniki-layin umarni don SQL Server tare da cikawa ta atomatik da nuna alama.
• mycli - Abokin ciniki na Terminal don MySQL tare da AutoCompletion da Haɗin Haɓakawa.
• pgcli - Postgres CLI tare da ƙaddamarwa ta atomatik da nuna alama.
• vcli - Vertica CLI tare da cikawa ta atomatik da nuna alama.

DB-tsari kewayawa da gani

• dbdigram.io - Kayan aiki mai sauri da sauƙi don taimaka muku zana zane-zanen bayanan bayananku da gudana cikin sauri ta amfani da yaren DSL mai sauƙi.
• ERAlchemy - Kayan aikin tsara zane-zanen mahalli.
• SchemaCrawler - Kayan aikin ganowa da fahimtar tsarin bayanai kyauta.
• Tsarin Leken asiri - Samar da bayanan ku zuwa takaddun HTML, gami da zane-zanen Abokan Hulɗa.
• tbls - Kayan aikin CI-Friendly don tattara bayanai, an rubuta a cikin Go.

Masu yin samfura

• Navicat Datalerler - Kayan aiki mai ƙarfi da tsada mai tsada wanda ke taimaka muku ƙirƙirar ingantaccen ra'ayi, ma'ana da ƙirar bayanan zahiri.
• Oracle SQL Developer Data Modeler - Oracle SQL Developer Data Modeler kayan aiki ne na zane kyauta wanda ke haɓaka yawan aiki da sauƙaƙe ayyukan ƙirar bayanai.
• pgmodeler - Kayan aikin ƙirar bayanai da aka tsara don PostgreSQL.

Kayan aikin ƙaura

• 2 bass - Kayan aiki na tushen bayanai-as-code wanda ke amfani da manufar rubutun DDL masu ƙarfi.
• titin jirgin sama - Kayan aikin ƙaura na Database.
• gh- ost - ƙaura na tsarin kan layi don MySQL.
• liquibase - Laburare mai zaman kansa na Database don bin diddigin, sarrafawa da amfani da canje-canjen tsarin bayanai.
• ƙaura - Kamar diff amma don tsarin PostgreSQL.
• node-pg- ƙaura - Node.js sarrafa ƙaura na bayanai wanda aka gina shi kaɗai don postgres. (Amma kuma ana iya amfani da su don wasu DBs masu dacewa da ma'aunin SQL - misali CockroachDB.)
• Pyrseas - Yana ba da abubuwan amfani don bayyana tsarin bayanan PostgreSQL azaman YAML.
• SchemaHero - Ma'aikacin Kubernetes don sarrafa tsarin tsarin bayanai (gitops don tsarin tsarin bayanai).
• Skitch - Mahimman bayanai-manyan gudanarwar canji na asali don haɓakawa mara tsari da tura abin dogaro.
• yuniql - Duk da haka wani tsarin siga da kayan ƙaura da aka yi tare da NET Core 3.0+ na asali kuma da fatan mafi kyau.

Kayan aikin ƙirƙira code

• ddl-generator - Yana haɓaka SQL DDL (Harshen Ma'anar Bayanai) daga bayanan tebur.
• makirci2ddl - Layin umarni don fitarwa tsarin Oracle zuwa saitin rubutun init ddl tare da ikon tace bayanan da ba'a so, raba DDL a cikin fayiloli daban-daban, ingantaccen tsarin fitarwa.

Wrappers

• Mafarini - Buɗewar tushen REST API don wayar hannu, yanar gizo, da aikace-aikacen IoT.
• Injin Hasura GraphQL - Zazzagewa da sauri, APIs na GraphQL na ainihi nan take akan Postgres tare da ingantaccen ikon sarrafa hatsi, kuma yana haifar da mahaɗar yanar gizo akan abubuwan da suka faru na bayanai.
• jl-sql - SQL don rafukan JSON da CSV.
• mysql_fdw - PostgreSQL na bayanan waje don MySQL.
• Ayyukan Bayanan Oracle REST - Aikace-aikacen Java na tsakiyar matakin, taswirar ORDS HTTP(S) fi'ili (GET, POST, PUT, DELETE, da sauransu) zuwa ma'amalar bayanai kuma yana dawo da duk wani sakamako da aka tsara ta amfani da JSON.
• Prism - Prisma yana juya bayanan ku zuwa API na GraphQL na ainihi.
• Karin bayani - REST API don kowane bayanan Postgres.
• perst - Hanya ce ta hidimar API mai RESTful daga kowace rumbun adana bayanai da aka rubuta a cikin Go.
• restSQL - Generator SQL tare da Java da HTTP APIs, yana amfani da API mai sauƙi RESTful HTTP tare da serialization XML ko JSON.
• zage-zage - Sauƙaƙa canza bayanan SQL ɗinku zuwa API REST.
• Sandman2 - Ƙirƙiri ta atomatik sabis na API RESTful don bayanan gadonku.
• sql-boot - Babban REST da UI wrapper don tambayoyin ku na SQL.

Ajiyayyen kayan aikin

• pgbackrest - Amintaccen Ajiyayyen PostgreSQL & Dawo.
• BaRMan - Ajiyayyen da Mai sarrafa farfadowa don PostgreSQL.

Maimaita aiki/Bayani aiki

• Bayanan bayanai - Kayan aiki don bincike da buga bayanai.
• dtle - Sabis ɗin Canja wurin Bayanan Rarraba don MySQL.
• pgsync - Daidaita bayanan Postgres tsakanin bayanan bayanai.
• pg_chameleon - MySQL zuwa PostgreSQL tsarin kwafi da aka rubuta a cikin Python 3. Tsarin yana amfani da ɗakin karatu na mysql-replication don cire hotunan jere daga MySQL waɗanda aka adana a cikin PostgreSQL azaman JSONB.
• PGDeltaStream - Sabar gidan yanar gizo na Golang don yawo Postgres yana canzawa aƙalla-sau ɗaya akan shafukan yanar gizo, ta amfani da fasalin tantance ma'ana ta Postgres.
• repmgr - Mafi Shahararrun Manajan Kwafi don PostgreSQL.

Scripts

• pgx_scripts - Tarin ƙananan rubutun masu amfani don nazarin bayanai da gudanarwa, wanda ƙungiyarmu ta ƙirƙira a PostgreSQL Experts.
• pgsql-kumburi-kimantawa - Tambayoyi don auna kumburin ƙididdiga a cikin fihirisa da tebur don PostgreSQL.
• pgWikiDont - Gwajin SQL wanda ke bincika idan bayananku ya bi ka'idoji daga https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg - kayan aiki - Abubuwan amfani PostgreSQL masu amfani.
• Postgres yaudara takardar - Rubutun SQL masu amfani da umarni ta .
• postgres_dba - Abubuwan da suka ɓace na kayan aiki masu amfani don Postgres DBAs da duk injiniyoyi.
• postgres_queries_and_commands.sql - Tambayoyin PostgreSQL masu amfani da umarni.
• TPT - Waɗannan rubutun sqlplus don haɓaka aikin Database na Oracle ne & magance matsala.

Kulawa/Kididdiga/Ayyuka

• ASH Viewer - Yana ba da ra'ayi mai hoto na bayanan tarihin zaman aiki a cikin Oracle da PostgreSQL DB.
• Monyog - Kayan aikin Kulawa na MySQL mara izini & Mai tsada.
• mssql-sa idanu - Kula da Sabar SQL ɗin ku akan aikin Linux ta amfani da tattarawa, InfluxDB da Grafana.
• Navicat Monitor - Amintaccen kayan aikin sa ido na uwar garken nesa mai sauƙi mai sauƙi wanda ba shi da wakili wanda ke cike da fasali masu ƙarfi don sa sa ido ya yi tasiri gwargwadon yiwuwa.
• Percona Kulawa da Gudanarwa - Buɗe tushen dandamali don sarrafawa da saka idanu akan ayyukan MySQL da MongoDB.
• pganalyze mai tarawa - Pganalyze mai tara kididdiga don tattara ma'auni na PostgreSQL da bayanan log.
• postgres-checkup - Sabbin kayan aikin bincike na zamani wanda ke ba masu amfani damar yin zurfin bincike kan lafiyar bayanan bayanan Postgres.
• postgres_exporter - Mai fitar da Prometheus don ma'aunin sabar sabar PostgreSQL.
• pgDash - Auna da bin kowane bangare na bayanan bayanan ku na PostgreSQL.
• PgHero - Dashboard ɗin aiki don Postgres - bincikar lafiya, fihirisar da aka ba da shawara, da ƙari.
• pgmetrics - Tattara da nuna bayanai da ƙididdiga daga sabar PostgreSQL mai gudana.
• pgMustard - Mai amfani da mai amfani don Postgres yayi bayanin tsare-tsare, da shawarwari don inganta aiki.
• pgstat - Yana tattara kididdigar PostgreSQL, kuma ko dai adana su a cikin fayilolin CSV ko buga su akan stdout.
• pgwatch2 - Mai sassaucin ra'ayi na PostgreSQL matakan saka idanu / maganin dashboarding.
• Telegraf PostgreSQL plugin - Yana ba da awo don bayanan postgres ɗinku.

Zabbix

• Mamonsu - Wakilin saka idanu don PostgreSQL.
• Orabbix - Orabbix plugin ɗin da aka ƙera don aiki tare da Zabbix Enterprise Monitor don samar da sa ido iri-iri, aiki da bayar da rahoto da ma'auni don Databases na Oracle, tare da ma'aunin aikin uwar garken.
• pg_monz - Wannan shine samfurin saka idanu na Zabbix don Bayanan Bayani na PostgreSQL.
• Pyora - Rubutun Python don saka idanu akan Databases na Oracle.
• ZabbixDBA - ZabbixDBA yana da sauri, sassauƙa, kuma yana ci gaba da haɓaka plugin don saka idanu akan RDBMS ɗin ku.

Testing

• DbFit - Tsarin gwaji na bayanai wanda ke goyan bayan haɓakar gwaji mai sauƙi na lambar bayanan ku.
• RegreSQL - Regression Gwajin tambayoyin SQL ku.

Mai samar da bayanai

• Databene Benerator - Tsari ne don samar da ingantaccen bayanan gwaji mai girma mai inganci don tsarin ku a ƙarƙashin gwaji ( guje wa tsarin ƙirar Datalite).
• dbForge Data Generator don MySQL - Kayan aikin GUI mai ƙarfi don ƙirƙirar ɗimbin ɗimbin bayanan gwaji na gaske.
• dbForge Data Generator don Oracle - Ƙananan kayan aikin GUI mai ƙarfi don haɓaka tsarin Oracle tare da tarin bayanan gwaji na gaske.
• dbForge Data Generator don SQL Server - Kayan aikin GUI mai ƙarfi don saurin tsara bayanan gwaji mai ma'ana don bayanan bayanai.

Administration

• pgdager - Mai sauri PostgreSQL Log Analyzer.
• pgbedrock - Sarrafa ayyukan gungu na Postgres, membobin rawar, ikon mallakar tsari, da gata.
• pgslice - Rarraba Postgres mai sauƙi kamar kek.

HA/Rashin nasara/Sharding

• Citus - Tsawaita Postgres wanda ke rarraba bayanan ku da tambayoyin ku a kan nodes da yawa.
• majiɓinci - Samfura don Babban Samuwar PostgreSQL tare da ZooKeeper, da sauransu, ko Consul.
• Percona XtraDB Cluster - Babban Maganin Sikeli don Tarin MySQL da Babban Samuwar.
• stolon - Mai sarrafa PostgreSQL na Cloud don babban wadatar PostgreSQL.
• pg_auto_failover - Tsawaitawa da sabis na Postgres don gazawar atomatik da babban samuwa.
• pglokout - Saka idanu kwafi na PostgreSQL da gazawar daemon.
• PostgreSQL Nasara ta atomatik - Babban Samuwar don Postgres, dangane da nassoshin masana'antu Pacemaker da Corosync.
• postgresql_cluster - Taguwar Samun Babban Samun PostgreSQL (dangane da "Patroni" da "DCS(da sauransu)"). Yin aiki ta atomatik tare da Mai yiwuwa.
• Vitess - Tsarin tarin bayanai don a kwance a kwance na MySQL ta hanyar sharding gaba ɗaya.

Kubernetes

• KubeDB - Yin tafiyar da bayanan samar da bayanai mai sauƙi akan Kubernetes.
• Ma'aikacin Postgres - Ma'aikacin Postgres yana ba da damar samun dama ga gungu na PostgreSQL akan Kubernetes (K8s) wanda Patroni ke bayarwa.
• Spilo - HA PostgreSQL Gungu tare da Docker.
• StackGres - Matsayin ciniki, Cikakken Stack PostgreSQL akan Kubernetes.

Gyaran Kanfigareshan

• MySQLTuner-perl - Rubutun da aka rubuta a cikin Perl wanda ke ba ku damar sake duba shigarwar MySQL da sauri da yin gyare-gyare don ƙara aiki da kwanciyar hankali.
• PGConfigurator - Kayan aikin kan layi kyauta don samar da ingantaccen aiki postgresql.conf.
• pgtun - Mayen sanyi na PostgreSQL.
• postgresqltuner.pl - Rubutun sauƙaƙan don bincika tsarin bayanan bayanan ku na PostgreSQL, da ba da shawarar daidaitawa.

DevOps

• DBmaestro - DBmaestro yana haɓaka sake zagayowar sakewa & yana goyan bayan ƙarfi a duk yanayin yanayin IT.
• Toad DevOps Toolkit - Toad DevOps Toolkit yana aiwatar da mahimman ayyukan haɓaka bayanai a cikin ayyukan DevOps ɗinku - ba tare da lalata inganci, aiki ko dogaro ba.

Samfuran tsari

• Oracle Database Samfurin Tsare-tsaren - Oracle Database Samfurin Tsare-tsaren.

Rahoto

• Poly - Aikace-aikacen rahoton SQL mai sauƙin amfani wanda aka gina don masoya SQL.

Raba

• DBdeployer - Kayan aiki wanda ke tura sabobin bayanan MySQL cikin sauƙi.
• dbatools - Tsarin PowerShell wanda zaku iya tunanin kamar layin umarni na SQL Server Studio Studio Management.
• Postgres.app - Cikakken shigarwar PostgreSQL wanda aka kunshi shi azaman daidaitaccen aikace-aikacen Mac.
• Babban SQL - Rarraba mai haɓakawa na Postgres.
• Gidan Giwa - Gaba-gaba na gudanarwa na PostgreSQL na tushen yanar gizo wanda ke haɗa abubuwa da yawa da aikace-aikace don amfani tare da PostgreSQL.

Tsaro

• Accra - Database security suite. Wakilin bayanan bayanai tare da boye-boye matakin filin, bincika ta hanyar rufaffiyar bayanai, rigakafin alluran SQL, gano kutse, wuraren saƙar zuma. Yana goyan bayan ɓoyayyen ɓoyayyen abokin ciniki da gefen wakili ("m"). SQL, NoSQL.

Masu tsara lamba

• CodeBuff - Harshe-agnostic kyawawan-buga ta hanyar koyon injin.

Ba da gudummawa

• Ana maraba da gudummawar ku koyaushe! Da fatan za a karanta jagororin gudummawa na farko.

Idan kuna da wani abin da aka samo don bayanan bayanai, da fatan za a raba. Zan kuma yi farin cikin samun ra'ayi - PR's da taurari. Idan kuna da wasu tambayoyi game da ƙirƙirar zanen gadonku, rubuta su ma.

source: www.habr.com