A full query console for Cloudflare's D1 database product.

Related tags

Learning resource console database cloudflare d1
Overview

D1 Console

A console/REPL for Cloudflare's D1 Database product.

NPM | GitHub

Supports all the features expected of a modern database client, including:

  • multiline queries
  • table-formatted query outputs
  • command history
  • the ability to save your Cloudflare credentials for later use (opt-in)

To get started, run npx d1-console (or use another package manager of your choice). To authenticate, you need:

  • your account ID, can be found on any zone (domain) of your Cloudflare account
  • an API token with the D1 Edit permission, which can be generated on the Cloudflare dashboard

Options:

  • --json to run in JSON mode (no table graphics).
  • --json-all to show the entire JSON response (including parameters such as query time).

For more info and to get help, join us on the Cloudflare Developers Discord!

You might also like...

Frontend Mentor - E-commerce product page solution

Frontend Mentor - E-commerce product page solution

Frontend Mentor - E-commerce product page solution This is a solution to the E-commerce product page challenge on Frontend Mentor. Frontend Mentor cha

Nov 2, 2022

Tiny API that provide product/library name for a URL

JSer.info Product Name API Tiny API that provide product/library name for a URL. Usage Supported All products. curl https://jser-product-name.deno.dev

Oct 21, 2022

Fusion of Twitter and Discord and getting a single product as a outcome.

TWTCORD Connect your cords through TWTCORD What is TWTCORD? TWTCORD is derived from the combination of twitter and discord. It is basically the fusion

May 11, 2022

A product system made with NestJS. It's a service where you list products, create products or even delete them.

Products-API A product system made with NestJS. It's a service where you list products, create products or even delete them. What I used in this proje

May 18, 2022

An E-commerce product page, responsive and dynamic

An E-commerce product page, responsive and dynamic

This is a solution to the E-commerce product page challenge on Frontend Mentor. Frontend Mentor challenges help you improve your coding skills by building realistic projects.

Jul 3, 2022

An e-commerce web application that allows people to buy clothes product

Getting Started with Create React App This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: np

Aug 4, 2022

scaffold-stark is a forkable StarkNet dev stack focused on fast product iterations, inspired by scaffold-eth.

scaffold-stark is a forkable StarkNet dev stack focused on fast product iterations, inspired by scaffold-eth.

💠 scaffold-stark scaffold-stark is a forkable StarkNet dev stack focused on fast product iterations, inspired by scaffold-eth. Drop in your Cairo sma

Oct 7, 2022

Event Bus Demo - This product is built with Remix

Event Bus Demo - This product is built with Remix

Event Bus Demo This product is built with Remix Remix Docs Netlify Functions Google Maps API Development The project requires an API key. You can get

Jan 4, 2023

Simple jQuery plugin that will allow users to zoom in your images, perfect for product images and galleries.

Simple jQuery plugin that will allow users to zoom in your images, perfect for product images and galleries.

Image Zoom (jQuery) Plugin Simple jQuery plugin that will allow users to zoom in your images, perfect for product images and galleries that is less th

Aug 3, 2022
Comments
  • Feature Request: d1-console login

    Feature Request: d1-console login

    Hi! First, love d1-console :) I could barely use D1 without it!

    It'd be cool if there was a command to re-auth, like d1-console login - I accidently entered the wrong account ID and had to find where it was storing the creds to fix it ($HOME/.d1).

    Along with this, d1-console whoami might be helpful, to see what I'm logged in as (I have multiple CF accounts.)

    Thanks!

    opened by jahands 2
  • In-REPL Commands & Batch Execution

    In-REPL Commands & Batch Execution

    • Added the commands within the REPL (such as USE, CREATE DATABASE, etc) back in addition to the new subcommands.
    • Queries seperated with a semicolon now correctly execute as a batch which supports automatic transactions (BEGIN and ROLLBACK) still fail.
    • Queries can now be joined with REPL commands by joining them with a semicolon (for example, USE <dbname>; SELECT * FROM <table>; USE <otherdb>; SELECT * FROM <othertable>;).
    opened by isaac-mcfadyen 0
  • Commander Rewrite

    Commander Rewrite

    This PR moves D1 Console from a DIY CLI implementation to commander, a popular Node.JS CLI framework.

    Breaking changes:

    • Commands such as USE, SHOW DATABASES, and CREATE DATABASE have been moved to dedicated subcommands (see --help for more information).
    • Colors are back! :tada: (but can be disabled with the --no-colors flag if needed for any reason)
    • To choose the database to query, a new flag -d or --database is now used instead of the USE command inside the REPL.
    • If you wish to use D1 Console in CI/CD pipelines, the flag --execute can be used to immediately execute a command. In addition, D1 Console will now prefer CLOUDFLARE_ACCOUNT_ID and CLOUDFLARE_API_TOKEN environment variables over the saved authentication (if any).

    Closes #3 Closes #4

    opened by isaac-mcfadyen 0
Owner
Isaac McFadyen
Isaac McFadyen
GitHub
Hemsida för personer i Sverige som kan och vill erbjuda boende till människor på flykt

Getting Started with Create React App This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: np

null 4 May 3, 2022
Kurs-repo för kursen Webbserver och Databaser

Webbserver och databaser This repository is meant for CME students to access exercises and codealongs that happen throughout the course. I hope you wi

null 14 Jan 3, 2023
A simple query builder, it will helps to develop DSL query for Elasticsearch

Elasticsearch Dynamic Query Builder A simple query builder, it will helps to develop DSL query for elasticsearch Installation You can start it from np

Hashemi Rafsan 4 Nov 20, 2022
Interplanetary Database: A Database built on top of IPFS and made immutable using Ethereum blockchain.

IPDB IPDB (Interplanetary Database) is a key/value store database built on top of IPFS (Interplanetary File System). Project is intended to be an MVP

turinglabs 8 Oct 6, 2022
Visualize, modify, and build your database with dbSpy! An open-source data modeling tool to facilitate relational database development.

Visualize, modify, and build your database with dbSpy! dbSpy is an open-source data modeling tool to facilitate relational database development. Key F

OSLabs 115 Dec 22, 2022
Full-Stack CRUD Application With Angular + Firebase Database + Authentication + REST APIs

BookCompany Full-Stack CRUD Application With Angular + Firebase Database + Authentication + REST APIs Technologies & Features Angular front-end framew

Rodrigo Bravo 3 Apr 10, 2022
VueJS based Shopsystem for the Athena Framework, absolute free and open source! Full Database Integration (MongoDB)

Open Source Shop Herewith we bring a free store system for the Athena Framework which is under the MIT license and thus can be completely modified and

Der Lord! 13 Oct 31, 2022
This is a full-stack exercise tracker web application built using the MERN (MongoDB, ExpressJS, ReactJS, NodeJS) stack. You can easily track your exercises with this Full-Stack Web Application.

Getting Started with Create React App This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: np

WMouton 2 Dec 25, 2021
Simple scripts for crawling shopee's shop and product information from shopee.vn

Table of Contents About The Project Built With Getting Started Prerequisites Installation Usage License About The Project shopee-crawler is a simple p

Hoàng Kim Minh 5 Dec 13, 2022
Pay Creators to Promote your Product in $CRYPTO

Next.js + Tailwind CSS Example This example shows how to use Tailwind CSS (v3.0) with Next.js. It follows the steps outlined in the official Tailwind

Satyam Kulkarni 1 Feb 7, 2022