search

dogsheep / hacker-news-to-sqlite

Create a SQLite database containing data pulled from Hacker News
Apache License 2.0
48 stars 6 forks source link

Add permalink virtual field to items table #6

Open xavdid opened 1 year ago

xavdid commented 1 year ago

I added a virtual column (no storage overhead) to the output that easily links back to the source. It works nicely out of the box with datasette:

I got bit a bit by https://github.com/simonw/sqlite-utils/issues/411, so I went with a manual table_xinfo and creating the table via execute. Happy to adjust if that issue moves, but this seems like it works.

I also added my best-guess instructions for local development on this package. I'm shooting in the dark, so feel free to replace with how you work on it locally.

xavdid commented 1 year ago

@simonw can you take a look when you have a chance?