Munguva pfupi yapfuura nhau dzakaputika kuti Amazon yakasarudza kusunungura kodhi ye "Babelfish yePostgreSQL", ichikurudzira yekuwedzera kune dhatabhesi rePostgreSQL nekushandiswa kwehunyanzvi hweMicrosoft SQL Server database.
Chinangwa chikuru chepurojekiti ndechekupa kugona kumhanyisa zvikumbiro zvakanyorerwa SQL Server pamaseva anomhanya PostgreSQL. Iyo kodhi yeprojekiti yakavhurika pasi peApache 2.0 marezinesi uye PostgreSQL License.
Kune avo vasina kujairana neBabelfish, iwe unofanirwa kuziva kuti izvi inotsigira network protocol inoshandiswa kubatanidza vatengi kuSQL Server, T-SQL, uye SQL Server-chaiyo yemubvunzo yekuwedzera mutauro, zvinokubvumidza kushandura maapplication anoshanda kubva kuMicrosoft SQL Server kuenda kuPostgreSQL pasina kugadzirisa kodhi yako kana nekuchinja kushoma uye pasina kutsiva madhiraivha kuDBMS. Zvekushandisa, Babelfish inotaridzika seyakajairika SQL server. Iyo purojekiti yatove kushandiswa paAmazon Aurora.
Nhasi, tinoita kuti Babelfish iwanikwe yeAurora PostgreSQL. Babelfish inogonesa Amazon Aurora PostgreSQL-Inoenderana Edition kuti inzwisise iyo SQL Server yekubatanidza protocol. Inokugonesa kutamisa zvikumbiro zvako kubva kuSQL Server kuenda kuPostgreSQL zvakachipa, nekukurumidza, uye nenjodzi shoma ine chekuita neshanduko yakadaro.
Zvinonzi chirongwa Babelfish inotevera yakavhurika yekusimudzira modhi izvo zvinoita kuti vabatsiri venharaunda vaite shanduko nekukurudzira budiriro. Kune vashandisi, shanduko ku Babelfish ichakubvumidza kuti udzivise kukosha kwakakosha pakushandisa SQL Server, bypass rezinesi zvirambidzo uye zvisingatsamiri pane shanduko mune yekuchengetedza mutemo wechigadzirwa chemuridzi (kubviswa kwemabhenefiti, kugumiswa kwekutsigira kwepuratifomu, kuwedzera kwemutengo).
Iyo purojekiti inosanganisira seti yePostgreSQL yekuwedzera, seti yePostgreSQL zvigamba, uye kampasi yekushandisa:
Iwo ekuwedzera anopa PostgreSQL tsigiro yekuwedzera syntax, data mhando, uye mabasa anodiwa kutama kubva kuSQL Server. Huwandu hwemawedzero e4 anotsanangurwa:
- babelfishpg_tsql: chinova chiwedzero chekuita kushandiswa kwemutauro weT-SQL (Transact-SQL) unowedzera SQL neprocedural programming, tsigiro yezvakasiyana-siyana zvemunharaunda uye mabasa epamusoro ekubata tambo, misi uye masvomhu matauriro. Mazhinji eakakumbirwa T-SQL mabasa akaitwa, anosanganisira evha mapoinzi, akachengetwa maitiro, uye nested transaction. Nekudaro, chikamu chakakosha cheiyo syntax uye mabasa anoramba asina kuitika (sekutonga, aya ndiwo maitiro asingawanzo shandiswa mumashandisirwo chaiwo, tafura yekuenderana). Semuyenzaniso, iwo anovaka "ADD SIGNATURE", "CREATE AGGREGATE", "GADZIRA / ALTER / DROP APPLICATION ROLE | ASSEMBLY | ASYMMETRIC KEY", "TANGA NGUVA YEKURUKURA", "KUPEDZA / KUSVIRA KUTAURA", zvichingodaro. havasati vawanikwa.
- babelfishpg_tds: kuwedzera kwekuita kweTDS (Tabular Data Stream) protocol inoshandiswa muSQL Server yekubatanidza network pakati peDBMS nemutengi. TDS protocol vhezheni 7.1 uye yepamusoro inotsigirwa.
- babelfishpg_common: kuwedzera kwekushandiswa kweiyo chaiyo SQL Server data marudzi.
babelfishpg_money: imari yemhando yekushandisa yakavakirwa pane FixedDecimal yekuwedzera kodhi.
Iwo mapeche anosanganisira shanduko kuPostgreSQL injini inodiwa kuti ipe imwe mashandiro kune Babelfish ekuwedzera. Parizvino, pamwe chete nevagadziri vePostgreSQL, basa riri kuitwa kusanganisa zvigamba zvakagadzirirwa mune chikuru PostgreSQL kuumbwa. Zvimedu zvakagadzirirwa PostgreSQL 13.
Chishandiso chekambasi chakagadzirirwa kupatsanura T-SQL DDL zvinyorwa uye SQL kodhi kuti ienderane neBabelfish. Mune zvakabuda, mushumo unogadzirwa kuti ndeupi mashandiro anodiwa kutanga application haisati yatsigirwa neBabelfish.
Maraibhurari emutengi anotevera ekubatanidza kuMS SQL Server anotsigirwa zviri pamutemo:
- OLEDB / MSOLEDBSQL mupi
- OLEDB / SQLOLEDB mutyairi
- Ado.NET entity framework
- SQL Server 11.0 Native Client
- ODBC (Open Database Connectivity)
JDBC (Java Database Connectivity)
Finalmente kana iwe uchifarira kuziva zvakawanda nezvazvo, unogona kutarisa ruzivo rwechinyorwa Mune inotevera chinongedzo. Kana vari avo vanofarira kukwanisa kuona iyo kodhi kodhi, vanogona kuzviita kubva pano.