4 ms·

Neat idea. I've been deep diving into sqlite the past few months and it's gotta be one of my favorite projects ever. Got any other neat sqlite things or resour

Neat idea. I've been deep diving into sqlite the past few months and it's gotta be one of my favorite projects ever. Got any other neat sqlite things or resources I might check out?

nattaylor 3y ago
I think this parquet virtual table extension is a pretty neat example of the power of extension https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
simonw 3y ago
I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io https://sqlite-utils.datasette.io My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io https://datasette.io I've also written a ton of stuff about SQLite on my two blogs: - https://simonwillison.net/tags/sqlite/ https://simonwillison.net/tags/sqlite/ - https://til.simonwillison.net/sqlite https://til.simonwillison.net/sqlite
- jamietanna 3y ago
  Your excellent work around SQLite led me to building https://dmd.tanna.dev https://dmd.tanna.dev and some other projects with it recently, and it's been such a game changer for me, so thank you
  - simonw 3y ago
    This is really neat! Found your live demo: https://dependency-management-data-example.fly.dev/datasette/datasette/dmd/dependabot?_facet=repo&_facet=package_manager#facet-package_manager https://dependency-management-data-example.fly.dev/datasette... Blogged it: https://simonwillison.net/2023/Aug/11/dependency-management-data/ https://simonwillison.net/2023/Aug/11/dependency-management-...
    - jamietanna 3y ago
      Oh wow, thanks very much :D yes Datasette was _so_ useful with making my organisation able to be more productive with understanding the data, made it much nicer than folks writing SQL locally, huge props for building it
- naikrovek 3y ago
  TWO blogs? you're pretty prolific, even with blogging. I have ADHD, I can barely finish a sentence

Neat idea. I've been deep diving into sqlite the past few months and it's gotta be one of my favorite projects ever. Got any other neat sqlite things or resources I might check out?

nattaylor 3y ago

I think this parquet virtual table extension is a pretty neat example of the power of extension https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html

simonw 3y ago

I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io https://sqlite-utils.datasette.io My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io https://datasette.io I've also written a ton of stuff about SQLite on my two blogs: - https://simonwillison.net/tags/sqlite/ https://simonwillison.net/tags/sqlite/ - https://til.simonwillison.net/sqlite https://til.simonwillison.net/sqlite

jamietanna 3y ago
Your excellent work around SQLite led me to building https://dmd.tanna.dev https://dmd.tanna.dev and some other projects with it recently, and it's been such a game changer for me, so thank you
- simonw 3y ago
  This is really neat! Found your live demo: https://dependency-management-data-example.fly.dev/datasette/datasette/dmd/dependabot?_facet=repo&_facet=package_manager#facet-package_manager https://dependency-management-data-example.fly.dev/datasette... Blogged it: https://simonwillison.net/2023/Aug/11/dependency-management-data/ https://simonwillison.net/2023/Aug/11/dependency-management-...
  - jamietanna 3y ago
    Oh wow, thanks very much :D yes Datasette was _so_ useful with making my organisation able to be more productive with understanding the data, made it much nicer than folks writing SQL locally, huge props for building it
naikrovek 3y ago
TWO blogs? you're pretty prolific, even with blogging. I have ADHD, I can barely finish a sentence