HN jira: Pg-typesafe – Ɲininkali sɛbɛnnen barikamaw PostgreSQL ni TypeScript kama

\u003ch2\u003eShow HN: Pg-typesafe – Ɲininkali sɛbɛnnen barikamaw PostgreSQL ni TypeScript\u003c/h2\u003e kama \u003cp\u003eNin Hacker News "Show HN" sɛbɛn in bɛ porozɛ walima baarakɛminɛn kura dɔ jira min dabɔra baarakɛlaw fɛ sigida kama. O cikan bɛ fɛɛrɛ kuraw ni gɛlɛyaw ɲɛnabɔcogo jira wale la.\u003c/p\u003e \u003ch3\u003ePorozɛ ka ɲɛfɔliw\u003c/h3\u003e \u003cp\u003eFɛn koloma minnu bɛ nin porozɛ in kɛ kɔlɔsili ye:\u003c/p\u003e \u003cul\u003e \u003cli\u003eDa wulicogo min bɛ jɛkafɔ sabati\u003c/li\u003e \u003cli\u003eDiɲɛ gɛlɛya lakikaw ɲɛnabɔcogo ɲuman\u003c/li\u003e \u003cli\u003eFɛɛrɛ kura donna porozɛw dilanni na\u003c/li\u003e \u003cli\u003eSigida ka jɛkafɔ ni hakilinaw ka ɲɛtaa sabatili\u003c/li\u003e \u003c/ul\u003e \u003ch3\u003eFɛɛrɛko nafa\u003c/h3\u003e \u003cp\u003eNin porozɛ sugu in bɛ sigida yiriwali fanga jira ani fɛɛrɛko ɲɛnabɔcogo jiginni ka taa a fɛ jɛkafɔ cɛsiriw fɛ.\u003c/p\u003e

Ɲininkali minnu bɛ kɛ tuma caman na

pg-typesafe ye mun ye ani a ni PostgreSQL gafemarayɔrɔ tɔw tɛ kelen ye cogo di ?

Pg-typesafe ye TypeScript gafemarayɔrɔ ye min bɛ na ni sɛbɛnni jɔlen barikama ye PostgreSQL ɲininkali raw la, ka suguya bɛnbaliya minɛ dalajɛ waati la sanni ka kɛ baarakɛcogo la. A tɛ i n’a fɔ ORMw i n’a fɔ Prisma walima TypeORM minnu bɛ SQL bɔ yen, pg-typesafe b’a to i bɛ SQL native sɛbɛn k’a sɔrɔ i bɛ nafa sɔrɔ hali bi TypeScript inference dafalen na. O kɔrɔ ye ko boli waati kabako dɔgɔyali, IDE yɛrɛdafalen ɲuman, ani refactoring lakananen — o bɛɛ kɛra k’a sɔrɔ i ma PostgreSQL sɔrɔli tilennen jiracogo saraka.

Yala ne ka kan ka n ka PostgreSQL sɛrɛkili kɔrɔ ladilan walasa ka baara kɛ ni pg-typesafe ye wa ?

Schema caman caman cili tɛ wajibiya . Pg-typesafe bɛ suguyaw jateminɛ k’a ɲɛsin i ka database schema ma min bɛ yen walima ka bɔ TypeScript suguya ɲɛfɔliw la i bɛ minnu di. A bɛ don i ka baarakɛcogo la sisan k’a sɔrɔ i ma jiginni walima schema sɛbɛnni kura kɛ. N’i bɛ ka fɛn dilannenw kuluba dɔ jɔ — misali la, ka baara kɛ ni plateforme ye i n’a fɔ Mewayz, min bɛ modulu 207 jɛlenw dilan $19/mo dɔrɔn na — pg-typesafe bɛ se ka slot saniya ka don data layer kɔnɔ k’a sɔrɔ a ma i ka infrastructure setup tiɲɛ.

yala pg-typesafe bɛnnen don sɛnɛko baarakɛcogo ma wa ?

Pg-typesafe dabɔra ni sɛnɛfɛnw dilanni baarakɛcogo ye hakili la, ka sinsin tiɲɛni, baarakɛcogo, ani yiriwalikɛlaw ka ergonomi kan. Sɛbɛnni barikama bɛ dɔ Bɔ buguw kulu la minnu bɛ Se sɛnɛfɛnw bɔli ma, wa ikomi ɲininkaliw bɛ To SQL gansan ye, ORM sanfɛla walima ɲininkaliw bɔli ma Laɲini tɛ yen. I n’a fɔ a bɛ kɛ cogo min na gafemarayɔrɔ dafalen bɛɛ la, aw ka kan k’a kɔgɔcogo, a sɛgɛsɛgɛli kɛcogo, ani a ka sigida baara jateminɛ sani aw k’a ta cidenyabaara siratigɛ la. A faralen ɲɔgɔn kan ni kɔkanna-kulu ye min labɛnna ka ɲɛ, o bɛ dɛmɛ ka dannaya bonya.

sɛbɛnni barikama kɛli kunnafonidilan ɲininkaliw la , o bɛ yiriwali jɛkulubaw nafa cogo di ?

Ekipuw fɛ, daɲɛgafe-waati suguya lakanani bɛ kɛ i n’a fɔ bɛnkansɛbɛn kunnafonidilanw sɛgɛsɛgɛli ni baarakɛminɛnw kode cɛ. Ni kulu dɔ tɔgɔ jiginna walima ni suguya dɔ Changé, TypeScript bɛ ɲininkali bɛɛ min bɛ nɔ bila a la, o bɛ bɔ kɛnɛ kan o yɔrɔnin bɛɛ sanni a ka filiw bila ka bɔ kɛnɛ kan a dilanni na. O bɛ dɔ bɔ kosɛbɛ QA sanfɛla ni kurun kɔnɔ ɲɔgɔndan na. Ekipu minnu bɛ fɛn dafalenw jɔ — i n’a fɔ minnu bɛ baara kɛ ni Mewayz ka 207-module platform ye $19/mo — olu bɛ se ka nafa sɔrɔ kɛrɛnkɛrɛnnenya la, bawo kunnafonidilan dannamɔgɔ bɛ fɛn bɛɛ sinsin, k’a ta dantigɛli la ka se jateminɛ baarakɛcogo ma.

ye