sqlite-viewer VS datasette

Now open the http://127.0.0.1:8000/, you will see the following output: You can also use sqlite3 command line tool or SQL Viewer tool in order to inspect changes in your database.

Just for fun, I threw the db.sqlite3 database on testing site, https://inloop.github.io/sqlite-viewer/, to see if the data is still valid and it is, I just need to redirect django to point to the local sqlite3 database.

Now have a look in that database ( https://inloop.github.io/sqlite-viewer/ ) and compare it to your external drive file paths. Maybe the drive has a different name…?

So, try using a tool that can read SQLite databases, like https://inloop.github.io/sqlite-viewer/ or https://sqlitebrowser.org/

sqlite-viewer - View SQLite file online

The History file is an SQLite database. You can see its contents on this webpage: http://inloop.github.io/sqlite-viewer/

SQLite Viewer - Online .db, .sqlite3, etc. File Viewer. Open Source. Website.

I was able to open them with this tool: https://github.com/inloop/sqlite-viewer

Simon Willison's github would be a great place to get started imo -

https://github.com/simonw/datasette

I'm a fan on simonw's datasette/dogsheep ecosystem https://datasette.io/

I use Anki the exact same way. After a lifetime of learning I have accepted that I will never read over anything I write for myself voluntarily - so my two options are:

1. Write an article so good I can publish it and look it over myself later on. I did this last year with https://andrew-quinn.me/fzf/, for example.

2. Create Anki cards out of the material. Use the builtin Card Browser or even https://datasette.io/ on the underlying SQLite database in a pinch to search for my notes any time I have to.

Were you aware of, or tempted by https://datasette.io/ for creating your solution?

Browsing HN, GitHub and the like we get to see a huge variety of software products and code bases.

I often see products and think - if this product X, got together with Y, it would be pretty cool - kind of like if they had a kid together.

Not too literally, but more on the conceptual level - my level of programming is low.

E.g. Just some....

- pocketable.io & datasette (+with some more charting) [https://pocketbase.io, https://datasette.io]

You might like the Datasette project: https://datasette.io/

I don't think they are desperate for contributions but it's a welcoming environment and a fun project to hack on. You'll learn a lot just from reading the source and the incredibly informative PRs. The creator is a really talented developer with a great blog which shows up on the HN front page often.

Last year I worked through the challenges using VisiData, Datasette, and Pandas. I walked through my thought process and solutions in a series of posts.

> uploads of boring raw excel data and receive a nice UI

https://datasette.io/