Bontša HN: Pg-typesafe - Lipotso tse ngotsoeng ka matla bakeng sa PostgreSQL le TypeScript

\u003ch2\u003eBontša HN: Pg-typesafe – Lipotso tse ngoliloeng ka thata bakeng sa PostgreSQL le TypeScript\u003c/h2\u003e \u003cp\u003e Poso ena ea Hacker News "Show HN" e hlahisa projeke kapa sesebelisoa se entsoeng ke batho ba ntlafatsang sechaba. Tlhahiso e emela boqapi ba tekheniki le ho rarolla mathata.\u003c/p\u003e \u003ch3\u003e Lintlha-kholo tsa Morero\u003c/h3\u003e \u003cp\u003e Likarolo tsa bohlokoa tse etsang hore morero ona o hlokomelehe:\u003c/p\u003e \u003cul\u003e \u003cli\u003eMohloli o bulehileng o khothaletsang tšebelisano-mmoho\u003c/li\u003e \u003cli\u003eTharollo e sebetsang ea mathata a lefats'e la nnete\u003c/li\u003e \u003cli\u003e Boqapi ba botekgeniki ho nts'etsopele ea software\u003c/li\u003e \u003cli\u003e tšebelisano le sechaba le ntlafatso e susumetsoang ke maikutlo\u003c/li\u003e \u003c/ul\u003e \u003ch3\u003e Bohlokoa ba Theknoloji\u003c/h3\u003e \u003cp\u003e Mofuta ona oa morero o bontša matla a nts'etsopele e tsamaisoang ke sechaba le tsoelo-pele e tsoelang pele ea tharollo ea tekheniki ka boiteko ba tšebelisano.\u003c/p\u003e

Lipotso Tse Botsoang Hangata

Pg-typesafe ke eng hona e fapana joang le lilaebrari tse ling tsa PostgreSQL?

Pg-typesafe ke laebrari ea TypeScript e tlisang mokhoa o matla oa ho ngola o tsitsitseng ho lipotso tse tala tsa PostgreSQL, ho tšoasa mefuta e sa lumellaneng ka nako ea ho bokella ho fapana le nako ea ho sebetsa. Ho fapana le li-ORM tse kang Prisma kapa TypeORM tse sa utloisiseng SQL, pg-typesafe e u lumella ho ngola SQL ea tlhaho ha u ntse u rua molemo ho tsoa ho mofuta o felletseng oa TypeScript. Sena se bolela lintho tse makatsang tse fokolang tsa nako ea ho sebetsa, ho phethela ka boits'oaro ho betere ha IDE, le ts'ebetso e sireletsehileng haholoanyane - tsohle ntle le ho tela ponahatso ea phihlello e tobileng ea PostgreSQL.

Na ke hloka ho fetola schema ea ka ea PostgreSQL hore ke sebelise pg-typesafe?

Ha ho hlokahale liphetoho tsa schema. Pg-typesafe e fana ka mefuta ka kotloloho ho tsoa ho schema sa hau sa polokelo ea litaba kapa ho tsoa ho litlhaloso tsa mofuta oa TypeScript tseo u fanang ka tsona. E hokahana le tšebetso ea hau ea hajoale ntle le ho falla kapa ho ngola hape schema. Haeba u ntse u haha ​​sephutheloana se pharaletseng sa lihlahisoa - ka mohlala, u sebelisa sethala se kang Mewayz, se fanang ka li-module tse 207 tse kopantsoeng bakeng sa $ 19 / mo feela - pg-typesafe e ka kenya ka mokhoa o hloekileng sebakeng sa data ntle le ho senya ts'ebetso ea hau ea motheo.

Na pg-typesafe e loketse lits'ebetso tsa tlhahiso?

Pg-typesafe e entsoe ho nahanoa ka tšebeliso ea tlhahiso, e totobatsang ho nepahala, ts'ebetso, le ergonomics ea moqapi. Ho ngola ka matla ho fokotsa sehlopha sa litšitšili tse fihlang tlhahiso, 'me kaha lipotso li lula li le SQL, ha ho na ORM kapa tlhahiso e sa lebelloang ea lipotso. Joalo ka laeborari efe kapa efe e bulehileng, o lokela ho lekola kholo ea eona, ts'ebetso ea liteko, le ts'ebetso ea sechaba pele o e sebelisa lits'ebetsong tsa bohlokoahali. Ho e kopanya le mekotla e hlophisitsoeng hantle e thusa ho ts'epahala haholo.

Ho ngola ka matla lipotsong tsa polokelo ea litaba ho tsoela lihlopha tse kholoanyane molemo joang?

Bakeng sa lihlopha, ts'ireletso ea nako ea ho bokella e sebetsa e le konteraka lipakeng tsa schema ea database le khoutu ea kopo. Ha kholomo e rehoa bocha kapa mofuta o fetoha, TypeScript e araba potso e 'ngoe le e' ngoe e amehang hang-hang ho fapana le ho tlohella liphoso ho hlahella tlhahiso. Sena se fokotsa sekhahla sa QA haholo le likhohlano tsa onboarding. Lihlopha tse hahang lihlahisoa tse nang le likarolo tse feletseng - tse kang tse sebelisang sethala sa Mewayz 207-module ho $ 19 / mo - li ka rua molemo ka ho khetheha, kaha lera le tšepahalang la data le tšehetsa ntho e 'ngoe le e' ngoe ho tloha ho netefatso ho ea ho analytics workflows.