The avatar for @asg017
Alex Garcia
Software engineer, available for freelance work! • he/him/his
Public
SQLite Blog
Edited
Jun 12, 2023
2 forks
2 stars
4
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 SQLiteIntroducing sqlite-path: A SQLite extension for parsing and generating pathsIntroducing 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 SQLite
Introducing sqlite-regex: A fast Regular Expression Extension for SQLite
Making 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
Insert cell
Insert cell
Insert cell
Insert cell
db
select
regex_version(),
regex_debug(),
'foobar' regexp 'foo';
Insert cell
Insert cell
Insert cell
db
select regexset_is_match(
regexset(
"bar",
"foo",
"barfoo"
),
'foobar'
)
Insert cell
Insert cell
db
with test_strings as (
select value as string
from json_each('[
"example.com",
"foo@example.com",
"example"
]')
)
select
test_strings.string,
matches.pattern
from test_strings
left join regexset_matches(
regexset(
'[a-z]+@[a-z]+\.(com|org|net)',
'[a-z]+\.(com|org|net)'
),
test_strings.string
) as matches
Insert cell
Insert cell
db
select regex_find(
'\b\w{13}\b',
'I categorically deny having triskaidekaphobia.'
) as word_13_chars;
Insert cell
db
select *
from regex_find_all(
'\b\w{13}\b',
'Retroactively relinquishing remunerations is reprehensible.'
);
Insert cell
Insert cell
db
select *
from regex_split(
regex('[ \\t]+'),
'a b \t c\td e'
)
Insert cell
Insert cell
db
select
regex_replace(
'[^01]+',
'1078910',
''
) as only_binary,
regex_replace(
'(?P<last>[^,\s]+),\s+(?P<first>\S+)',
'Springsteen, Bruce',
'$first $last'
) as first_last
Insert cell
db
select regex_replace_all(
'dog',
'cat dog mouse dog',
'monkey'
)
Insert cell
Insert cell
Insert cell
import { DatasetteClient } from "@ambassadors/datasette-client"
Insert cell
db = new DatasetteClient("https://sqlite-extension-examples.fly.dev/data")
Insert cell
import { importCell } from "@mbostock/dataflow"
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