ktorides.com | Kyriakos’s Den - One of these days I will quit web development and take up

Robots.txt Information

Robot	Path	Permission
GoogleBot	/	✔
BingBot	/	✔
BaiduSpider	/	✔
YandexBot	/	✔
User-agent: * Disallow: /wp-admin/ Allow: /wp-admin/admin-ajax.php

Meta Tags

Title	Kyriakos’s Den - One of these days I will quit web development and take up
Description	One of these days I will quit web development and take up
Keywords	N/A

Server Information

WebSite	ktorides.com
Host IP	104.21.48.129
Location	United States

Related Websites

                        Site
                        Rank
                    

More to Explore

ktorides.com Valuation

US$296,935

Last updated: 2022-06-22 12:12:05

ktorides.com has Semrush global rank of 35,645,266. ktorides.com has an estimated worth of US$ 296,935, based on its estimated Ads revenue. ktorides.com receives approximately 34,262 unique visitors each day. Its web server is located in United States, with IP address 104.21.48.129. According to SiteAdvisor, ktorides.com is safe to visit.

Traffic & Worth Estimates

Purchase/Sale Value	US$296,935
Daily Ads Revenue	US$275
Monthly Ads Revenue	US$8,223
Yearly Ads Revenue	US$98,674
Daily Unique Visitors	2,285
Note: All traffic and earnings values are estimates.

DNS Records

Host	Type	TTL	Data
ktorides.com.	A	298	IP: 104.21.48.129
ktorides.com.	A	298	IP: 172.67.151.155
ktorides.com.	AAAA	298	IPV6: 2606:4700:3034::ac43:979b
ktorides.com.	AAAA	298	IPV6: 2606:4700:3035::6815:3081
ktorides.com.	NS	86400	NS Record: jocelyn.ns.cloudflare.com.
ktorides.com.	NS	86400	NS Record: plato.ns.cloudflare.com.
ktorides.com.	MX	300	MX Record: 0 dc-0ff5aca36f7e.ktorides.com.

HtmlToTextCheckTime:2022-06-22 12:12:05

Skip to main content Toggle navigation Kyriakos’s Den Home About Remove duplicate rows from table in PostgreSQL December 26, 2018 December 26, 2018 kyriakos I was recently looking for a quick way to delete duplicate rows from large table (around half a billion rows) in PostgreSQL. In my case the table didn’t have a primary key – it was the result of importing a bunch of CSV files using the copy command. After some googling it turned out that the quickest way is also the easiest to understand. So here is how its done: -- Create a new table with only unique rows: create table temp as select distinct on (lon,lat,label) * from buildings; -- Check the before and after counts: select count(*) as before from buildings; select count(*) as after from temp; -- Now drop the original table drop table buildings; -- Rename the temporary one. alter table temp rename to buildings; Essentially, a new table is created with the duplicated rows removed then the original table is dropped and the new table

HTTP Headers

HTTP/1.1 301 Moved Permanently
Date: Sun, 24 Oct 2021 01:50:18 GMT
Content-Type: text/html; charset=UTF-8
Connection: keep-alive
location: http://www.ktorides.com/
CF-Cache-Status: DYNAMIC
Report-To: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=e6%2BwCF81t%2BYyB8FzQSBi%2BR4a9I8nTXcCFj48GWs%2FX9s2AfjXt4kb1P6judgScHLMzRVltx15L5ticPwOj7rD9DvyiMA8peU0bni5MZC2NlD0Znd70uOwQw6HO86OvyM%3D"}],"group":"cf-nel","max_age":604800}
NEL: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
Server: cloudflare
CF-RAY: 6a2f8db32a6662e8-ORD
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400

HTTP/1.1 200 OK
Date: Sun, 24 Oct 2021 01:50:19 GMT
Content-Type: text/html; charset=UTF-8
Connection: keep-alive
link: ; rel="https://api.w.org/", ; rel=shortlink
CF-Cache-Status: DYNAMIC
Report-To: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=tmMDBhrA7PlfwP5vueTlabuedHHfBwXn1ynJA2nD67%2BLkXyyoa19y2tYJpli00WjEjT0DpghWro40sf1Qc8bFL2fdXH26ajLJ6EUFgJx2RxGgV7DLyNKjkeL4hAJIkp9vPxn"}],"group":"cf-nel","max_age":604800}
NEL: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
Server: cloudflare
CF-RAY: 6a2f8db66dfb635c-ORD
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400

ktorides.com Whois Information

Domain Name: KTORIDES.COM
Registry Domain ID: 119764357_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.namecheap.com
Registrar URL: http://www.namecheap.com
Updated Date: 2021-05-09T17:27:01Z
Creation Date: 2004-05-11T09:33:06Z
Registry Expiry Date: 2024-05-11T09:33:06Z
Registrar: NameCheap, Inc.
Registrar IANA ID: 1068
Registrar Abuse Contact Email: abuse@namecheap.com
Registrar Abuse Contact Phone: +1.6613102107
Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited
Name Server: JOCELYN.NS.CLOUDFLARE.COM
Name Server: PLATO.NS.CLOUDFLARE.COM
DNSSEC: unsigned
>>> Last update of whois database: 2021-09-12T10:31:36Z <<<

ktorides.com valuation and analysis