Robot | Path | Permission |
GoogleBot | / | ✔ |
BingBot | / | ✔ |
BaiduSpider | / | ✔ |
YandexBot | / | ✔ |
Title | Create Your Own AdonisJS Commands to Create and Drop |
Description | Warren Are you tired of logging into psql to create or drop a database? Learn how to do the same task from the command |
Keywords | N/A |
WebSite | warrenwong.org |
Host IP | 54.205.240.192 |
Location | United States |
Site | Rank |
US$287,710
Last updated: 2023-05-04 15:25:55
warrenwong.org has Semrush global rank of 36,788,169. warrenwong.org has an estimated worth of US$ 287,710, based on its estimated Ads revenue. warrenwong.org receives approximately 33,198 unique visitors each day. Its web server is located in United States, with IP address 54.205.240.192. According to SiteAdvisor, warrenwong.org is safe to visit. |
Purchase/Sale Value | US$287,710 |
Daily Ads Revenue | US$266 |
Monthly Ads Revenue | US$7,968 |
Yearly Ads Revenue | US$95,609 |
Daily Unique Visitors | 2,214 |
Note: All traffic and earnings values are estimates. |
Host | Type | TTL | Data |
warrenwong.org. | A | 299 | IP: 54.205.240.192 |
warrenwong.org. | A | 299 | IP: 64.227.12.111 |
warrenwong.org. | AAAA | 299 | IPV6: 2604:a880:400:d0::1756:9001 |
warrenwong.org. | AAAA | 299 | IPV6: 2600:1f18:2489:8201:aeea:87a5:6524:10fd |
warrenwong.org. | NS | 86400 | NS Record: major.ns.cloudflare.com. |
warrenwong.org. | NS | 86400 | NS Record: kami.ns.cloudflare.com. |
warrenwong.org. | MX | 300 | MX Record: 0 mail.warrenwong.org. |
warrenwong.org. | TXT | 300 | TXT Record: v=spf1 include:servers.mcsv.net ?all |
Warren Wong About Blog Create Your Own AdonisJS Commands to Create and Drop Databases August 12, 2021 If you found yourself logging into psql every time you needed to just drop and create a database while building your AdonisJS project, I have good news for you. AdonisJS allows you to write your own custom node ace scripts to make your development process much smoother. First off, we’ll be using the pgtools library to help us create and drop the database. # npm npm i -D pgtools # yarn yarn add -D pgtools Now, create a new command for creating and dropping the database. Since there’s already a db:seed , I think db:create and db:drop will be appropriate. node ace make:commmand db:create node ace make:command db:drop These scripts will generate two new files, commands/dbCreate.ts and commands/dbDrop.ts . To create a database, we’ll use pgtools.createdb , which takes a config object as the first argument, and the database name as the second. The third argument will be a NodeJS style |
HTTP/1.1 301 Moved Permanently cache-control: public, max-age=0, must-revalidate content-length: 38 content-type: text/plain date: Tue, 26 Oct 2021 16:41:12 GMT x-nf-request-id: 01FJYQMAG8Q3F4ZZN2Z7FHRZ5B location: https://warrenwong.org/ server: Netlify age: 0 HTTP/2 200 cache-control: public, max-age=0, must-revalidate content-type: text/html; charset=UTF-8 date: Mon, 25 Oct 2021 22:30:31 GMT etag: "d85381f19efebdf3727b9632d02e74be-ssl" strict-transport-security: max-age=31536000 content-length: 42645 age: 65441 server: Netlify x-nf-request-id: 01FJYQMAPKKX75W62Y9VKQWZYF |
Domain Name: WARRENWONG.ORG Registry Domain ID: D167872861-LROR Registrar WHOIS Server: whois.cloudflare.com Registrar URL: http://www.cloudflare.com Updated Date: 2021-01-14T20:07:56Z Creation Date: 2013-02-13T06:45:43Z Registry Expiry Date: 2022-02-13T06:45:43Z Registrar: CloudFlare, Inc. Registrar IANA ID: 1910 Registrar Abuse Contact Email: registrar-abuse@cloudflare.com Registrar Abuse Contact Phone: +1.6503198930 Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Registrant Organization: DATA REDACTED Registrant State/Province: DATA REDACTED Registrant Country: US Name Server: MAJOR.NS.CLOUDFLARE.COM Name Server: KAMI.NS.CLOUDFLARE.COM DNSSEC: unsigned URL of the ICANN Whois Inaccuracy Complaint Form https://www.icann.org/wicf/) >>> Last update of WHOIS database: 2021-09-14T16:29:45Z <<< |