IAmazon ikhuphe ikhowudi yomthombo weBabelfish yePostgreSQL

Mva nje Iindaba zakhutshwa ukuba iAmazon yagqiba ekubeni ikhuphe ikhowudi yomthombo we "Babelfish for PostgreSQL", icebisa ulwandiso lwedatha yePostgreSQL ngokuphunyezwa kwezakhono ezithile zesiseko sedatha seseva ye-Microsoft SQL.

Injongo ephambili yeprojekthi kukubonelela ngokukwazi ukuqhuba izicelo ezibhaliweyo kwi-SQL Server kwiiseva eziqhuba i-PostgreSQL. Ikhowudi yeprojekthi ivuliwe phantsi kweelayisensi ze-Apache 2.0 kunye neLayisensi yePostgreSQL.

Kwabo bangaziyo ngeBabelfish, kufuneka uyazi ukuba oku ixhasa inkqubo yomsebenzi womnatha esetyenziselwa ukudibanisa abathengi kwi-SQL Server, T-SQL, kunye ne-SQL Server-specific query language extensions, ekuvumela ukuba uguqulele usetyenziso olusebenzayo ukusuka kwiMicrosoft SQL Server ukuya kwiPostgreSQL ngaphandle kokuguqula ikhowudi yakho okanye ngotshintsho oluncinci kwaye ngaphandle kokubuyisela abaqhubi kwiDBMS. Kwizicelo, iBabelfish ijongeka njengeseva yeSQL eqhelekileyo. Iprojekthi sele isetyenziswa kwiAmazon Aurora.

Namhlanje, senza i-Babelfish ifumaneke kwi-Aurora PostgreSQL. I-Babelfish yenza ukuba i-Amazon Aurora PostgreSQL-Compatible Edition iqonde i-SQL Server protocol protocol. Ikuvumela ukuba ufuduse usetyenziso lwakho ukusuka kwi-SQL Server ukuya kwi-PostgreSQL ngexabiso eliphantsi, ngokukhawuleza kwaye kunye nemingcipheko embalwa ehambelana notshintsho olunjalo.

Kuxelwe ukuba iprojekthi I-Babelfish ilandela imodeli yophuhliso evulekileyo evumela abaxhasi boluntu ukuba benze utshintsho kwaye babe nefuthe kuphuhliso. Kubasebenzisi, utshintsho kwi I-Babelfish iya kubavumela ukuba baphephe iimali ezibalulekileyo zokusebenzisa i-SQL Server, izithintelo zelayisenisi ye-bypass kwaye ayixhomekeke kwiinguqu kumgaqo-nkqubo wokugcinwa kwemveliso yobunini (ukucinywa kweenzuzo, ukupheliswa kwenkxaso yeqonga, ukunyuka kwamaxabiso).

Iprojekthi ibandakanya isethi yezandiso zePostgreSQL, iseti yeepetshi zePostgreSQL kunye nekiti yesixhobo sekhampasi:

Izandiso zibonelela nge-PostgreSQL ngenkxaso ye-syntax eyongezelelweyo, iindidi zedatha, kunye nemisebenzi efunekayo ukufuduka kwi-SQL Server. Kucetywa ulwandiso olu-4 lulonke:

  • babelfishpg_tsql: olululwandiso lokuphumeza ukuphunyezwa kolwimi lwe-T-SQL (Transact-SQL) olongeza i-SQL ngenkqubo yenkqubo, inkxaso yezinto eziguquguqukayo zasekhaya kunye nemisebenzi ephambili yokuphatha imitya, imihla kunye nokuchazwa kwezibalo. Uninzi lweempawu eziceliweyo ze-T-SQL ziphunyeziwe, kubandakanywa amanqaku okugcina, iinkqubo ezigciniweyo, kunye neentengiselwano ezifakwe kwindlwane. Nangona kunjalo, inxalenye ebalulekileyo ye-syntax kunye nemisebenzi ihlala ingabonakali (njengomthetho, ezi ziimpawu ezingaqhelekanga zisetyenziswe kwizicelo zangempela, itafile ehambelanayo). Umzekelo, i-constructs "YONGEZANI ISIGINISO", "CREATE AGGREGATE", "CREATE/ALTER/DROP APPLICATION ROLE|ASSEMBLY|ASYMMETRIC KEY", "QALA IXESHA LENXOXO", "PHELA/HAMBA INGXOXO", njl. Azikabikho.
  • babelfishpg_tds: ulwandiso lokuphunyezwa kweprotocol ye-TDS (Tabular Data Stream) esetyenziswa kwi-SQL Server yothungelwano phakathi kweDBMS kunye nomxhasi. I-TDS protocol version 7.1 nangaphezulu iyaxhaswa.
  • babelfishpg_eqhelekileyo: ulwandiso lokuphunyezwa kweentlobo ezithile zedatha ye-SQL Server.
    babelfishpg_money: luhlobo lwemali oluphunyeziweyo olusekelwe kwikhowudi yokwandiswa kweFixedDecimal.

Iipatches zibandakanya utshintsho kwi-injini ye-PostgreSQL efunekayo ukubonelela ngokusebenza okongezelelweyo kwi-Babelfish extensions. Okwangoku, kunye nabaphuhlisi bePostgreSQL, umsebenzi uyaqhubeka ukubandakanya iipetshi ezilungisiweyo kuyilo oluphambili lwePostgreSQL. Iipetshi ezilungiselelwe iPostgreSQL 13.

Usetyenziso lweCompass yenzelwe ukuhlalutya izikripthi zeT-SQL DDL kunye nekhowudi yeSQL yokuhambelana neBabelfish. Kwisiphumo, ingxelo yenziwe ukuba yeyiphi imisebenzi efunekayo ukuqalisa isicelo ayikaxhaswa yi-Babelfish.

La mathala eencwadi alandelayo abaxumi bokuqhagamshela kwi-MS SQL Server axhaswa ngokusemthethweni:

  • OLEDB/MSOLEDBSQL Umboneleli
  • OLEDB/SQLOLEDB umqhubi
  • I-Ado.NET Entity Framework
  • Umncedisi we-SQL 11.0 Umxhasi weNative
  • I-ODBC (Vula uQhagamshelwano lweDatabase)
    I-JDBC (uQhagamshelwano lweDatha yeJava)

Gqibela ukuba unomdla wokwazi okungakumbi ngayo, ungajonga iinkcukacha zenowuthi Kule khonkco ilandelayo. Ngokuphathelele abo banomdla wokukwazi ukubona ikhowudi yomthombo, unokwenza njalo kule khonkco.


Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.