IAmazon ikhuphe ikhowudi yomthombo weBabelfish yePostgreSQL

Mva nje iindaba zikhutshwe ukuba i-Amazon inqume ukukhulula ikhowudi yomthombo we "Babelfish ye-PostgreSQL", icebisa ulwandiso lwesiseko sedata yePostgreSQL ngokuphunyezwa kwesakhono ezithile sesiseko 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 bangayazi i-Babelfish, kuya kufuneka uyazi ukuba oku ixhasa inkqubo yomsebenzi womnatha esetyenziselwa ukudibanisa abathengi kwi-SQL Server, T-SQL, kunye ne-SQL Server-specific query language extensions, ikuvumela 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. Ikwenza ukwazi ukufudusa usetyenziso lwakho ukusuka kwi-SQL Server ukuya kwi-PostgreSQL ngexabiso eliphantsi, ngokukhawuleza, kunye nomngcipheko omncinci onxulumene nolo tshintsho.

Kuxelwe ukuba iprojekthi I-Babelfish ilandela imodeli yophuhliso evulekileyo eyenza ukuba abaxhasi boluntu benze utshintsho kwaye babe nefuthe kuphuhliso. Kubasebenzisi, utshintsho kwi I-Babelfish iya kukuvumela ukuba uthintele iintlawulo ezibalulekileyo zokusebenzisa i-SQL Server, izithintelo zelayisensi yokudlula kwaye azixhomekeke 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 ngenkxaso ye-PostgreSQL ye-syntax eyongezelelweyo, iindidi zedatha, kunye nemisebenzi efunekayo ukufuduka kwi-SQL Server. Kucetywa ulwandiso olu-4 lulonke:

  • babelfishpg_tsql: olululwandiso lokuphumeza ulwimi lwe-T-SQL (Transact-SQL) olongeza i-SQL ngenkqubo yenkqubo, inkxaso yezinto eziguquguqukayo zasekhaya kunye nemisebenzi ephambili yokuphatha imitya, imihla kunye nokuchazwa kwezibalo. Uninzi lwemisebenzi eceliweyo ye-T-SQL iphunyeziwe, 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 yokuhambelana). Umzekelo, i-constructs "YONGA ISAYINWE", "YENZA I-AGGREGATE", "YEKA / ALTER / YEHLISA INDIMA YOKUFAKA ISICELO | I-ASYMMETRIC KEY", "QALISA IXESHA LENXOXO", "PHELA / HAMBA INCOKO", njalo njalo. abakafumaneki.
  • babelfishpg_tds: ulwandiso lokuphunyezwa kweprotocol ye-TDS (Tabular Data Stream) esetyenziswa kwi-SQL Server yoqhagamshelwano lwenethiwekhi phakathi kweDBMS kunye nomxhasi. I-TDS protocol version 7.1 nangaphezulu iyaxhaswa.
  • babelfishpg_eqhelekileyo: ulwandiso lokuphumeza iindidi ezithile zedatha ye-SQL Server.
    babelfishpg_money: luhlobo lwemali oluphunyeziweyo olusekelwe kwikhowudi yokwandiswa kweFixedDecimal.

Iipatches ziquka utshintsho kwi-injini ye-PostgreSQL efunekayo ukubonelela ngokusebenza okongeziweyo kwizandiso ze-Babelfish. Okwangoku, kunye nabaphuhlisi bePostgreSQL, umsebenzi uyenziwa ukubandakanya iipetshi ezilungisiweyo kuyilo oluphambili lwePostgreSQL. Iipetshi ezilungiselelwe iPostgreSQL 13.

Usetyenziso lwekhampasi yenzelwe ukwahlula imibhalo ye-T-SQL DDL kunye nekhowudi yeSQL ukuze ihambelane ne-Babelfish. Kwisiphumo, ingxelo yenziwe ukuba yeyiphi imisebenzi efunekayo ukuqalisa isicelo ayikaxhaswa yi-Babelfish.

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

  • OLEDB / MSOLEDBSQL umboneleli
  • OLEDB / SQLLEDB umqhubi
  • Isakhelo sequmrhu le-Ado.NET
  • Umncedisi we-SQL 11.0 Umxhasi weNative
  • ODBC (uqhagamshelo lwedatha evulekileyo)
    I-JDBC (uQhagamshelwano lweDatha yeJava)

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


Umxholo wenqaku uyabambelela kwimigaqo yethu imigaqo yokuziphatha yokuhlela. Ukuxela impazamo cofa apha.

Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa.

*

*

  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.