The avatar for @john-guerra
John Alexis Guerra Gómez
I love to build dataviz for insight discovery. I also love to put technology to the service of humanity
Public
Edited
Feb 20, 2024
Paused
9 forks
3
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
SELECT * FROM pragma_table_list
Insert cell
Insert cell
db
SELECT * FROM pragma_table_info('tracks')
Insert cell
Insert cell
db
SELECT * FROM pragma_foreign_key_list('tracks')
Insert cell
db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
str = visualizeSqlite(db, {showAttributes: true, showTables: true, returnStr: true})
Insert cell
mermaid`${str}`
Insert cell
mermaid`classDiagram
A: a`
Insert cell
Insert cell
db = SQLiteDatabaseClient.open(file?.url() || FileAttachment("chinook.db").url())

Insert cell
Insert cell
results = await db.query(query)
Insert cell
import {navio} from "@john-guerra/navio"
Insert cell
import {Editor} from '@cmudig/editor'
Insert cell
import {visualizeSqlite} from "@john-guerra/visualize-sqlite"
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more