The avatar for @asg017
Alex Garcia
Software engineer, available for freelance work! • he/him/his
Published
SQLite Blog
Edited
Aug 26, 2022
1 star
6
SQLite Blog
A new Blog Series on SQLite and ToolingIntroducing sqlite-lines - a SQLite extension for reading files line-by-lineIntroducing sqlite-html: query, parse, and generate HTML in SQLiteIntroducing sqlite-http: A SQLite extension for making HTTP requestsScraping JSON, HTML, and ZIP Files with Pure SQLite
Introducing sqlite-path: A SQLite extension for parsing and generating paths
Introducing sqlite-url: A SQLite extension for parsing and generating URLsIntroducing sqlite-loadable-rs: A framework for building SQLite Extensions in RustIntroducing sqlite-xsv: The Fastest CSV Parser for SQLiteIntroducing sqlite-regex: A fast Regular Expression Extension for SQLiteMaking SQLite extensions pip install-ableIntroducing sqlite-vss: A SQLite Extension for Vector SearchMaking SQLite extensions npm install'able for Node.js, and on deno.land/x for DenoMaking SQLite extension gem install'able for Ruby Developerssqlite-vss v0.1.1 Annotated Release Notes
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db = DemoSQLitePathDatabaseClient(FileAttachment("react-archive.db").blob())
Insert cell
db
select path_version(), path_debug();
Insert cell
Insert cell
db
select * from pragma_function_list where name like 'path%' order by 1;
Insert cell
Insert cell
db
select * from react_files limit 20;
Insert cell
Insert cell
db
select
path_at(name, 1) top_directory,
sum(size) sum_bytes
from react_files
-- filter out top-level files
where (select count(*) from path_parts(name)) > 2
group by 1
order by 2 desc;
Insert cell
Insert cell
db
select name, size
from react_files
where path_at(name, 1) = 'packages'
order by 2 desc;
Insert cell
Insert cell
db
select
name,
size
from react_files
where path_extension(name) not in ('.js', '.lock', '.json')
order by 2 desc;
Insert cell
Insert cell
db
select name
from react_files;
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
sqljs = require(await FileAttachment("path0-sqljs.js").url())
Insert cell
wasm = FileAttachment("path0-sqljs.wasm").url()
Insert cell
DemoSQLitePathDatabaseClient = async (source) => {
//Adapted from https://github.com/observablehq/stdlib/blob/main/src/sqlite.js
function load(source) {
return typeof source === "string"
? fetch(source).then(load)
: source instanceof Response || source instanceof Blob
? source.arrayBuffer().then(load)
: source instanceof ArrayBuffer
? new Uint8Array(source)
: source;
}

const [SQL, buffer] = await Promise.all([
sqljs({ locateFile: (filename, prefix) => wasm }),
Promise.resolve(source).then(load)
]);

return new SQLiteDatabaseClient(new SQL.Database(buffer));
}
Insert cell
pics = Promise.all([
FileAttachment(
"DALL·E 2022-08-25 19.04.40 - wooden bridge over a river, animation, playful.png"
).url(),
FileAttachment(
"DALL·E 2022-08-25 19.04.52 - Incredible, wooden bridge over a river, matte painting, dramatic lighting.png"
).url(),
FileAttachment(
"DALL·E 2022-08-25 19.05.00 - wooden bridge over a river, animation, playful.png"
).url()
])
Insert cell
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more