Ir gad\u012bjies tak dz\u012bv\u0113 rakst\u012bt k\u0101du CREATE TABLE steitmentu? Nav? Nu ja \u0161\u0137iet, ka ar\u012b neb\u016bs, tad at\u0101, uz redz\u0113\u0161anos, lasi n\u0101kamo rakstu, vai kaut ko pavisam citu.<\/p>\n
Tagad, kad esam paliku\u0161i tikai m\u0113s, g\u012bki, run\u0101sim (\u010dukstus) t\u0101l\u0101k.<\/p>\n
T\u0101tad situ\u0101cija sekojo\u0161a. Tu esi pr\u0101t\u012bgs cilv\u0113ks tu savus tabulas izveides skriptus glab\u0101, bet nezin\u0101mu iemeslu d\u0113\u013c pien\u0101k diena, kad nezin\u0101mu iemeslu d\u0113\u013c (vad\u012bbas, pa\u0161inciat\u012bvas, vai k\u0101da cita motiv\u0101tora vad\u012bts) n\u0101kas nomain\u012bt DBPS (nu tur MySQL:u uz Postgresu, vai otr\u0101di), vai ar\u012bdzan vienk\u0101r\u0161i p\u0113k\u0161\u0146i pien\u0101k br\u012bdis, kad tev viens un tas pats ir j\u0101uztur uz abiem (kas ir nepat\u012bkam\u0101k), vai ar\u012b tu vienk\u0101r\u0161i proti rakst\u012bt CREATE TABLE priek\u0161 postgresa\/mysql (lieko izsv\u012btro pats), bet tagad vajag sro\u010dna priek\u0161 t\u0101 otra.<\/p>\n
So we have a problem. Jo, kaut ar\u012b abi tjipa saprot, tjipa to pa\u0161u SQL:u, tom\u0113r katram ir savi datu tipi un citas savas nians\u012btes. Ko nu? Var protams las\u012bt dokument\u0101ciju un attiec\u012bgos piepras\u012bjumus konvert\u0113t ar roku (kas princip\u0101 laikam ir jebkur\u0101 gad\u012bjum\u0101 for\u0161i un ieteicami), bet m\u0113s ta\u010du esam slinki cilv\u0113ki un galu gal\u0101 ir tak\u0161 izdom\u0101ti ar\u012b datori un t\u0101, kas vis\u0101das meh\u0101niskas darb\u012bbas prot izdar\u012bt m\u016bsu viet\u0101.<\/p>\n
Kur gad\u012bjies, kur ne – talk\u0101 n\u0101k \u0161\u012bsdienas probl\u0113mas risin\u0101jums<\/a>. Izv\u0113lamies to dialektu uz kuru grib\u0101s to visu nokonvert\u0113t, ierakstam pa\u0161u SQL piepras\u012bjumu un nospie\u017eam vienu podzi\u0146u. Teor\u0113tiski tev b\u016btu j\u0101sa\u0146em (vismaz 80% vienk\u0101r\u0161o gad\u012bjumu) nokonvert\u0113ts SQL piepras\u012bjums, kuru tad nu vari barot iek\u0161\u0101 savai DBPS un cer\u0113t uz to, ka tabula izveidosies.<\/p>\n Ja nu gad\u012bjum\u0101 ietr\u0101p\u012bjies starp tiem 20%, kuriem nekas nesan\u0101ca, bet proti kod\u0113t php un \u0161o to saproti no t\u0101, k\u0101p\u0113c tie\u0161i var\u0113ja nesan\u0101kt (vai ar\u012b tu gribi, lai tur b\u016btu pie atbalst\u012btaj\u0101m b\u0101z\u0113m ar\u012b, teiksim, SQLite vai Or\u0101klis), vai ar\u012b vienk\u0101r\u0161i gribi \u0161ito fig\u0146u izmantot sav\u0101 php kod\u0101, tad dodies uz bitu spaini<\/a>.<\/p>\n Lai nu k\u0101, b\u016b\u0161u \u013coti priec\u012bgs, ja k\u0101dam (v\u0113l bez manis pa\u0161a) \u0161is izr\u0101d\u012bsies noder\u012bgs.<\/p>\n","protected":false},"excerpt":{"rendered":" Ir gad\u012bjies tak dz\u012bv\u0113 rakst\u012bt k\u0101du CREATE TABLE steitmentu? Nav? Nu ja \u0161\u0137iet, ka ar\u012b neb\u016bs, tad at\u0101, uz redz\u0113\u0161anos, lasi n\u0101kamo rakstu, vai kaut ko pavisam citu. Tagad, kad esam paliku\u0161i tikai m\u0113s, g\u012bki, run\u0101sim (\u010dukstus) t\u0101l\u0101k. T\u0101tad situ\u0101cija sekojo\u0161a. Tu esi pr\u0101t\u012bgs cilv\u0113ks tu savus tabulas izveides skriptus glab\u0101, bet nezin\u0101mu iemeslu d\u0113\u013c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[11],"_links":{"self":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/506"}],"collection":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/comments?post=506"}],"version-history":[{"count":4,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"predecessor-version":[{"id":509,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/506\/revisions\/509"}],"wp:attachment":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}