PGlite = import ("https://cdn.jsdelivr.net/npm/@electric-sql/pglite/dist/index.js").then(d => d.PGlite)
db = new PGlite()
randomMessage = await db.query("select 'Hello world' as message;")
randomMessage
Type Table, then Shift-Enter. Ctrl-space for more options.
pgTypes = await db.query(`
SELECT * FROM pg_catalog.pg_type
`)
pgTypes
Type Table, then Shift-Enter. Ctrl-space for more options.
/**
* Create the table
**/
async function createTable() {
await db.query(`
CREATE TABLE BabyNames(
uid SERIAL
, year INT
, gender VARCHAR(50)
, rank INT
, name VARCHAR(50)
, count INT
, PRIMARY KEY (year, gender, name)
)
`);
}
q = insert1(data[0])
function insert1({ Year, Gender, Rank, Name, Count }) {
return `
INSERT INTO BabyNames(Year, Gender, Rank, Name, Count)
VALUES(${Year}, '${Gender}', ${Rank}, '${Name}', ${Count})
`;
}
/**
* Insert new record
**/
async function insert({ Year, Gender, Rank, Name, Count }) {
return await db.query(`
INSERT INTO BabyNames(Year, Gender, Rank, Name, Count)
VALUES(${Year}, '${Gender}', ${Rank}, '${Name}', ${Count})
`);
}
{
var tableNames, records;
// Create the table
await createTable();
// Check if my table is inserted
tableNames = await db.query(`
SELECT relname FROM pg_class
JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
WHERE pg_class.relkind = 'r'
AND relname NOT LIKE 'pg_%'
`);
// Insert some record
for (let i = 0; i < data.length; ++i) {
await insert(data[i]);
}
// Checkout the records
records = await db.query(`
SELECT *
FROM BabyNames
`);
return { tableNames, records };
}
viewof search = Inputs.search(data)
data = FileAttachment("baby_names.csv").csv({typed: true})
Inputs.table(search, {
format: {
Year: d3.format("d") // format as "1960" rather than "1,960"
}
})
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.
