garrett.dev | Cody’s Blog – My personal blog for code snippets and solutions to issues that plagued me for

Robots.txt Information

Robot	Path	Permission
GoogleBot	/	✔
BingBot	/	✔
BaiduSpider	/	✔
YandexBot	/	✔
# If you are regularly crawling WordPress.com sites, please use our firehose to receive real-time push updates instead. # Please see https://developer.wordpress.com/docs/firehose/ for more details. Sitemap: https://garrett.dev/sitemap.xml Sitemap: https://garrett.dev/news-sitemap.xml User-agent: * Disallow: /wp-admin/ Allow: /wp-admin/admin-ajax.php Disallow: /wp-login.php Disallow: /wp-signup.php Disallow: /press-this.php Disallow: /remote-login.php Disallow: /activate/ Disallow: /cgi-bin/ Disallow: /mshots/v1/ Disallow: /next/ Disallow: /public.api/ # This file was generated on Tue, 31 Jan 2023 16:23:56

Meta Tags

Title	Cody’s Blog – My personal blog for code snippets and solutions to issues that plagued me for
Description	My personal blog for code snippets and solutions to issues that plagued me for
Keywords	N/A

Server Information

WebSite	garrett.dev
Host IP	192.0.78.25
Location	United States

Related Websites

                        Site
                        Rank
                    

More to Explore

garrett.dev Valuation

US$908,826

Last updated: 2023-05-08 06:33:43

garrett.dev has Semrush global rank of 11,646,133. garrett.dev has an estimated worth of US$ 908,826, based on its estimated Ads revenue. garrett.dev receives approximately 104,865 unique visitors each day. Its web server is located in United States, with IP address 192.0.78.25. According to SiteAdvisor, garrett.dev is safe to visit.

Traffic & Worth Estimates

Purchase/Sale Value	US$908,826
Daily Ads Revenue	US$839
Monthly Ads Revenue	US$25,168
Yearly Ads Revenue	US$302,010
Daily Unique Visitors	6,991
Note: All traffic and earnings values are estimates.

DNS Records

Host	Type	TTL	Data
garrett.dev.	A	300	IP: 192.0.78.25
garrett.dev.	A	300	IP: 192.0.78.24
garrett.dev.	NS	86400	NS Record: ns3.wordpress.com.
garrett.dev.	NS	86400	NS Record: ns1.wordpress.com.
garrett.dev.	NS	86400	NS Record: ns2.wordpress.com.
garrett.dev.	MX	3600	MX Record: 20 mx2.emailsrvr.com.
garrett.dev.	MX	3600	MX Record: 10 mx1.emailsrvr.com.
garrett.dev.	TXT	3600	TXT Record: v=spf1 include:emailsrvr.com ~all
garrett.dev.	TXT	3600	TXT Record: google-site-verification=nVcZg35otwbvoZjiDzsd7CX3VQNCvi_zPF9lkG3gLys

HtmlToTextCheckTime:2023-05-08 06:33:43

Menu LinkedIn Contact Cody’s Blog My personal blog for code snippets and solutions to issues that plagued me for hours. MariaDB – Creating an Event and Procedure Posted on April 26, 2023 by qwertycody Taking some time today to share a simple example of how to create an Event and a Stored Procedure in MariaDB. Use Case / Benefits: Executes an Stored Procedure on a set schedule (like a cronjob) Using a Stored Procedure in conjunction with an event allows you to change the code associated with the procedure without having to recreate the Event if something needs to be added Example – Stored Procedure: DROP PROCEDURE IF EXISTS `MariaDB-SchemaName`.`MY_MARIADB_PROCEDURENAME`; -- This needs to be commented out unless testing locally in MySQL Workbench or equivalent -- DELIMITER // CREATE PROCEDURE `MariaDB-SchemaName`.`MY_MARIADB_PROCEDURENAME`(IN exampleBoolean BOOLEAN) BEGIN SELECT ’EXAMPLE QUERY’ as example; End -- This needs to be commented out unless testing locally in MySQL Workbench

HTTP Headers

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Fri, 29 Oct 2021 13:15:43 GMT
Content-Type: text/html
Content-Length: 162
Connection: keep-alive
Location: https://garrett.dev/
X-ac: 2.mdw _dca 

HTTP/2 200 
server: nginx
date: Fri, 29 Oct 2021 13:15:43 GMT
content-type: text/html; charset=UTF-8
strict-transport-security: max-age=31536000
vary: Accept-Encoding
vary: Cookie
x-hacker: If you're reading this, you should visit automattic.com/jobs and apply to join the fun, mention this header.
host-header: WordPress.com
link: ; rel=shortlink
x-ac: 2.mdw _dca

garrett.dev Whois Information

Domain Name: garrett.dev
Registry Domain ID: 3298083CB-DEV
Registrar WHOIS Server: whois.nic.google
Registrar URL: http://www.gofrancedomains.com/
Updated Date: 2021-04-14T16:00:02Z
Creation Date: 2019-02-28T16:00:02Z
Registry Expiry Date: 2022-02-28T16:00:02Z
Registrar: Go France Domains, LLC
Registrar IANA ID: 1153
Registrar Abuse Contact Email: abuse@godaddy.com
Registrar Abuse Contact Phone: +1.4806242505
Domain Status: clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited
Domain Status: clientRenewProhibited https://icann.org/epp#clientRenewProhibited
Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited
Domain Status: clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited
Registrant Organization: Domains By Proxy, LLC
Registrant State/Province: Arizona
Registrant Country: US
Name Server: ns1.wordpress.com
Name Server: ns2.wordpress.com
Name Server: ns3.wordpress.com
DNSSEC: unsigned
>>> Last update of WHOIS database: 2021-09-17T02:22:25Z <<<

garrett.dev valuation and analysis