{"id":88581,"date":"2020-07-15T01:42:09","date_gmt":"2020-07-14T23:42:09","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real"},"modified":"2020-07-15T01:42:09","modified_gmt":"2020-07-14T23:42:09","slug":"unreal-features-of-real-types-ili-budte-ostorozhny-s-real","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real","title":{"rendered":"Ve\u00e7orit\u00eb e Real Types, ose Kujdesuni me REAL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pas publikimit <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/508038\/\">artikullit<\/a><\/noindex> p\u00ebr karakteristikat e tipizimit n\u00eb PostgreSQL, komenti i par\u00eb ishte p\u00ebr v\u00ebshtir\u00ebsit\u00eb n\u00eb pun\u00ebn me numra real\u00eb. Vendosa t\u00eb shfletoj shpejt kodin e pyetjeve SQL q\u00eb kisha n\u00eb dispozicion, p\u00ebr t\u00eb par\u00eb se sa shpesh p\u00ebrdoret tipi REAL. Si\u00e7 u duk, p\u00ebrdoret mjaft shpesh, dhe jo gjithmon\u00eb zhvilluesit e kuptojn\u00eb rreziqet q\u00eb lidhen me t\u00eb. Kjo ndodh edhe pse n\u00eb internet dhe n\u00eb Habr\u00eb ka mjaft artikuj t\u00eb mir\u00eb p\u00ebr karakteristikat e ruajtjes s\u00eb numrave real n\u00eb memorien kompjuterike dhe pun\u00ebn me ata. Prandaj, n\u00eb k\u00ebt\u00eb artikull do t\u00eb p\u00ebrpiqem t\u00eb aplikoj k\u00ebto karakteristika n\u00eb PostgreSQL, dhe do t\u00eb shqyrtoj me thjesht\u00ebsi problemet e lidhura me ta, n\u00eb m\u00ebnyr\u00eb q\u00eb zhvilluesit e pyetjeve SQL t\u00eb ken\u00eb m\u00eb leht\u00eb t'i shmangen atyre.<\/p>\n<p><\/p>\n<p>Dokumentacioni i PostgreSQL p\u00ebrmban nj\u00eb fraz\u00eb t\u00eb shkurt\u00ebr: \"Menaxhimi i k\u00ebsaj lloj gabimesh dhe p\u00ebrhapja e tyre gjat\u00eb llogaritjes \u00ebsht\u00eb nj\u00eb subjekt studimi i nj\u00eb seksioni t\u00eb t\u00ebr\u00eb t\u00eb matematik\u00ebs dhe shkenc\u00ebs kompjuterike, dhe k\u00ebtu nuk shqyrtohet\" (duke e d\u00ebrguar lexuesin me men\u00e7uri n\u00eb standardin IEEE 754). \u00c7far\u00eb gabimesh b\u00ebhet fjal\u00eb k\u00ebtu? Le t\u00eb diskutojm\u00eb ato nj\u00eb nga nj\u00eb, dhe shpejt do t\u00eb b\u00ebhet e qart\u00eb pse un\u00eb s\u00ebrish kam marr\u00eb pen\u00ebn p\u00ebr t\u00eb shkruar.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p>Marrim, p\u00ebr shembull, nj\u00eb pyetje t\u00eb thjesht\u00eb:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* PYETJE *********\nSELECT 0.1::REAL;\n**************************\nfloat4\n--------\n    0.1\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Si rezultat, nuk do t\u00eb shohim asgj\u00eb t\u00eb ve\u00e7ant\u00eb \u2013 do t\u00eb marrim 0.1 si\u00e7 pritej. Por tani krahasojm\u00eb at\u00eb me 0.1:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* PYETJE *********\nSELECT 0.1::REAL = 0.1;\n**************************\n?kolona?\n----------\nf\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Nuk jan\u00eb t\u00eb barabarta! \u00c7far\u00eb mrekullish! Por, m\u00eb tutje ka m\u00eb shum\u00eb. Disa do t\u00eb thon\u00eb, se e di q\u00eb REAL nuk sillet mir\u00eb me numrat me fraksion, prandaj do t\u00eb tregoj numra t\u00eb plot\u00eb, me ta do jet\u00eb me siguri gjith\u00e7ka n\u00eb rregull. Mir\u00eb, le t\u00eb konvertojm\u00eb numrin 123&nbsp;456&nbsp;789 n\u00eb tipin REAL:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* PYETJE *********\nSELECT 123456789::REAL::INT;\n**************************\n   int4   \n-----------\n123456792\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Po, ai rezultoi m\u00eb i madh me 3! Tani, databaza definitivisht harroi t\u00eb llogaris\u00eb! Apo ndoshta ne nuk e kuptojm\u00eb di\u00e7ka? Le t\u00eb eci me hapat.<\/p>\n<p><\/p>\n<p>S\u00eb pari, le t\u00eb kujtojm\u00eb disa gj\u00ebra themelore. Si\u00e7 dihet, \u00e7do num\u00ebr decimal mund t\u00eb shprehet me powers of ten. K\u00ebshtu, numri 123.456 do t\u00eb jet\u00eb i barabart\u00eb me 1*10^2 + 2*10^1 + 3*10^0 + 4*10^-1 + 5*10^-2 + 6*10^-3. Por kompjuteri punon me numra n\u00eb form\u00eb binare, prandaj ata p\u00ebrshkruhen si shprehje me powers of two. Numri 5.625 n\u00eb form\u00eb binare paraqitet si 101.101 dhe do t\u00eb jet\u00eb i barabart\u00eb me 1*2^2 + 0*2^1 + 1*2^0 + 1*2^-1 + 0*2^-2 + 1*2^-3. Dhe n\u00ebse powers of two pozitive gjithmon\u00eb japin numra decimal\u00eb t\u00eb plot\u00eb (1, 2, 4, 8, 16 etj.), me powers of two negative gj\u00ebrat jan\u00eb m\u00eb t\u00eb komplikuara (0.5, 0.25, 0.125, 0.0625 etj.). Problemi \u00ebsht\u00eb q\u00eb <b>nuk \u00e7do fraksion decimal mund t\u00eb paraqitet si nj\u00eb fraksion binar t\u00eb p\u00ebrfunduar<\/b>. K\u00ebshtu, e famshmja 0.1 n\u00eb form\u00ebn binare shfaqet si nj\u00eb vler\u00eb periodike 0.0(0011). Si rezultat, vlera p\u00ebrfundimtare e k\u00ebtij numri n\u00eb memorien kompjuterike do t\u00eb ndryshoj\u00eb n\u00eb var\u00ebsi t\u00eb sakt\u00ebsis\u00eb.<\/p>\n<p><\/p>\n<p>Tani \u00ebsht\u00eb koha p\u00ebr t\u00eb kujtuar si ruhen numrat real\u00eb n\u00eb memorien e kompjuterit. Duke folur n\u00eb terma t\u00eb p\u00ebrgjithsh\u00ebm, nj\u00eb num\u00ebr real p\u00ebrb\u00ebhet nga tri komponent\u00eb kryesore \u2013 shenja, mantisa, dhe eksponenti. Shenja mund t\u00eb jet\u00eb ose pozitive, ose negative, prandaj i kushtohet nj\u00eb bit. Sidoqoft\u00eb, numri i bit\u00ebve t\u00eb mantis\u00ebs dhe eksponent\u00ebve p\u00ebrcaktohet nga lloji i numrit real. K\u00ebshtu, p\u00ebr llojin REAL, gjat\u00ebsia e mantis\u00ebs \u00ebsht\u00eb 23 bit\u00eb (nj\u00eb bit, i barabart\u00eb me 1, n\u00eb m\u00ebnyr\u00eb q\u00eb t\u00eb shtohet n\u00eb fillim t\u00eb mantis\u00ebs, dhe b\u00ebhet 24), dhe eksponenti \u2013 8 bit\u00eb. N\u00eb total, kemi 32 bit\u00eb, ose 4 byte. Nd\u00ebrsa p\u00ebr llojin DOUBLE PRECISION, gjat\u00ebsia e mantis\u00ebs \u00ebsht\u00eb 52 bit\u00eb, dhe eksponenti \u2013 11 bit\u00eb, duke b\u00ebr\u00eb gjithsej 64 bit\u00eb, ose 8 byte. PostgreSQL nuk mb\u00ebshtet m\u00eb shum\u00eb sakt\u00ebsi p\u00ebr numrat me l\u00ebvizje t\u00eb pikave.<\/p>\n<p><\/p>\n<p>Le t\u00eb paketojm\u00eb numrin ton\u00eb 0.1 n\u00eb form\u00ebn dekimale n\u00eb t\u00eb dy llojet \u2013 REAL dhe DOUBLE PRECISION. Duke qen\u00eb se shenja dhe vlera e eksponentit tek ne p\u00ebrputhen, do t'i kushtojm\u00eb v\u00ebmendje mantis\u00ebs (q\u00eb po q\u00ebllimisht po e l\u00eb pas dore karakteristik\u00ebn jo shum\u00eb t\u00eb dukshme t\u00eb ruajtjes s\u00eb vlerave t\u00eb eksponentit dhe numrave real\u00eb zero, pasi k\u00ebto nd\u00ebrlikojn\u00eb kuptimin dhe shp\u00ebrqendrojn\u00eb nga thelbi i problemit, n\u00ebse doni t\u00eb dini m\u00eb shum\u00eb \u2013 shihni standardin IEEE 754). \u00c7far\u00eb do t\u00eb marrim? N\u00eb rreshtin e sip\u00ebrm do t\u00eb paraqes \"mantis\u00ebn\" p\u00ebr llojin REAL (duke e marr\u00eb parasysh rrumbullakimin e bitit t\u00eb fundit n\u00eb 1 n\u00eb numrin m\u00eb t\u00eb af\u00ebrt t\u00eb paraqitsh\u00ebm, p\u00ebrndryshe do t\u00eb del 0.099999...), ndersa n\u00eb rreshtin e posht\u00ebm \u2013 p\u00ebr llojin DOUBLE PRECISION:<\/p>\n<p><\/p>\n<blockquote><p><b>0.0001<\/b>1001100110011001100110<b>1<\/b><br \/>\n<b>0.0001<\/b>1001100110011001100110011001100110011001100110011001\n<\/p><\/blockquote>\n<p><\/p>\n<p>Sigurisht, k\u00ebto jan\u00eb dy numra t\u00ebr\u00ebsisht t\u00eb ndrysh\u00ebm! Prandaj, kur krahasojm\u00eb, numri i par\u00eb do t\u00eb plot\u00ebsohet me zero dhe, si rezultat, do t\u00eb jet\u00eb m\u00eb i madh se numri i dyt\u00eb (duke marr\u00eb parasysh rrumbullakimin \u2013 t\u00eb sh\u00ebnuarit n\u00eb t\u00eb trash\u00eb nj\u00ebsi). Kjo e shpjegon paqart\u00ebsin\u00eb nga shembujt tan\u00eb. N\u00eb shembullin e dyt\u00eb, numri i shprehur qart\u00eb 0.1 konvertohet n\u00eb llojin DOUBLE PRECISION, pas s\u00eb cil\u00ebs krahasohet me numrin e llojit REAL. T\u00eb dy konvertohen n\u00eb t\u00eb nj\u00ebjtin tip, dhe kemi pik\u00ebrisht at\u00eb q\u00eb shohim m\u00eb sip\u00ebr. Le t\u00eb ndryshojm\u00eb pyetjen, q\u00eb gjith\u00e7ka t\u00eb vendoset n\u00eb vendin e vet:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* K\u00cbRKES\u00cb *********\nSELECT 0.1::REAL &gt; 0.1::DOUBLE PRECISION;\n**************************\n?column?\n----------\nt\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Dhe n\u00eb t\u00eb v\u00ebrtet\u00eb, duke e ekzekutuar dyfish konvertimin e numrit 0.1 n\u00eb REAL dhe DOUBLE PRECISION, marrim p\u00ebrgjigjen p\u00ebr enigm\u00ebn:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* K\u00cbRKES\u00cb *********\nSELECT 0.1::REAL::DOUBLE PRECISION;\n**************************\n\n      float8       \n-------------------\n0.100000001490116\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Kjo shpjegon gjithashtu edhe shembullin e tret\u00eb nga ato t\u00eb m\u00ebsip\u00ebrme. Numri 123&nbsp;456&nbsp;789 thjesht <b>nuk mund t\u00eb vendoset n\u00eb 24 bita t\u00eb mantis\u00ebs<\/b> (23 t\u00eb qart\u00eb + 1 t\u00eb n\u00ebnkuptuar). Numri maksimal i plot\u00eb q\u00eb mund t\u00eb vendoset n\u00eb 24 bit \u00ebsht\u00eb 224-1 = 16&nbsp;777&nbsp;215. Prandaj, numri yn\u00eb 123&nbsp;456&nbsp;789 rroundohet n\u00eb numrin m\u00eb t\u00eb af\u00ebrt t\u00eb p\u00ebrfaqsh\u00ebm 123&nbsp;456&nbsp;792. Duke ndryshuar tipin n\u00eb DOUBLE PRECISION, nuk do ta shohim m\u00eb nj\u00eb skenar t\u00eb till\u00eb:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">********* K\u00cbRKES\u00cb *********\nSELECT 123456789::DOUBLE PRECISION::INT;\n**************************\n   int4   \n-----------\n123456789\n(1 rresht)\n<\/code><\/pre>\n<p><\/p>\n<p>Kjo \u00ebsht\u00eb gjith\u00e7ka. Zakonisht, nuk ka asnj\u00eb mrekulli. Por gjith\u00e7ka e p\u00ebrshkruar \u00ebsht\u00eb nj\u00eb arsye e mir\u00eb p\u00ebr t\u00eb menduar se sa e nevojshme \u00ebsht\u00eb v\u00ebrtet lloji REAL. Ndoshta, p\u00ebrfitimi m\u00eb i madh nga p\u00ebrdorimi i tij \u00ebsht\u00eb shpejt\u00ebsia e llogaritjeve me nj\u00eb humbje t\u00eb njohur sakt\u00ebsie. Por a do t\u00eb ishte ky nj\u00eb skenar universal q\u00eb justifikon p\u00ebrdorimin e till\u00eb t\u00eb shpesht\u00eb t\u00eb k\u00ebtij tipi? Nuk mendoj.<\/p>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/508350\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0431 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u0445 \u0442\u0438\u043f\u0438\u0437\u0430\u0446\u0438\u0438 \u0432 PostgreSQL, \u043f\u0435\u0440\u0432\u044b\u0439 \u0436\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0431\u044b\u043b \u043f\u0440\u043e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0432\u0435\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u043c\u0438 \u0447\u0438\u0441\u043b\u0430\u043c\u0438. \u042f \u0440\u0435\u0448\u0438\u043b \u0431\u0435\u0433\u043b\u043e \u043f\u0440\u043e\u0431\u0435\u0436\u0430\u0442\u044c\u0441\u044f \u043f\u043e \u043a\u043e\u0434\u0443 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u043c\u043d\u0435 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u043d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0447\u0430\u0441\u0442\u043e \u0432 \u043d\u0438\u0445 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0442\u0438\u043f REAL. \u0414\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f, \u043a\u0430\u043a \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c, \u0438 \u043d\u0435 \u0432\u0441\u0435\u0433\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u043f\u043e\u043d\u0438\u043c\u0430\u044e\u0442 \u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438, \u0441\u0442\u043e\u044f\u0449\u0438\u0435 \u0437\u0430 \u043d\u0438\u043c. \u0418 \u044d\u0442\u043e \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e, [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-88581","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0431 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u0445 \u0442\u0438\u043f\u0438\u0437\u0430\u0446\u0438\u0438 \u0432 PostgreSQL, \u043f\u0435\u0440\u0432\u044b\u0439 \u0436\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0431\u044b\u043b \u043f\u0440\u043e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Unreal Features of Real Types, \u0438\u043b\u0438 \u0411\u0443\u0434\u044c\u0442\u0435 \u043e\u0441\u0442\u043e\u0440\u043e\u0436\u043d\u044b \u0441 REAL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0431 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u0445 \u0442\u0438\u043f\u0438\u0437\u0430\u0446\u0438\u0438 \u0432 PostgreSQL, \u043f\u0435\u0440\u0432\u044b\u0439 \u0436\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0431\u044b\u043b \u043f\u0440\u043e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-07-14T23:42:09+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-07-14T23:42:09+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ve\u00e7orit\u00eb e Pashkruara t\u00eb Tipave t\u00eb V\u00ebrtet\u00eb, ose Kujdesi me REAL | ProHoster","description":"Pas publikimit t\u00eb artikullit mbi ve\u00e7orit\u00eb e tipizimit n\u00eb PostgreSQL, komenti i par\u00eb ishte p\u00ebr v\u00ebshtir\u00ebsit\u00eb e pun\u00ebs me.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47Unreal Features of Real Types, \u0438\u043b\u0438 \u0411\u0443\u0434\u044c\u0442\u0435 \u043e\u0441\u0442\u043e\u0440\u043e\u0436\u043d\u044b \u0441 REAL | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0431 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u0445 \u0442\u0438\u043f\u0438\u0437\u0430\u0446\u0438\u0438 \u0432 PostgreSQL, \u043f\u0435\u0440\u0432\u044b\u0439 \u0436\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0431\u044b\u043b \u043f\u0440\u043e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/unreal-features-of-real-types-ili-budte-ostorozhny-s-real","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-07-14T23:42:09+00:00","article:modified_time":"2020-07-14T23:42:09+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"88581","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:10:53","updated":"2022-10-03 00:47:31","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/88581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=88581"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/88581\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=88581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=88581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=88581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}