phiresky / blog Goto Github PK

Hi, not sure if this is the right place for comments. I notice you mention:

Uses memory mapping instead of read/write calls when db is < mmap_size.

Maybe I misread it, but I took this to mean "when total database size > mmap_size, the memory mapping would not be used at all". I later found out the memory mapping will still be used, but only for the starting bytes of the database up to mmap_size, so it can still give some performance benefit. It also might be worth noting a warning from the SQLite documentation: if a read fails (e.g. USB stick pulled out of drive), then you'll get a signal or crash rather than a graceful read error! But that's OK for some applications.

I noticed your blog post about sql libraries for Typescript ( https://phiresky.github.io/blog/2020/sql-libs-for-typescript/ ).

I developed a library for that (MIT licence) which I now consider mature enough: https://github.com/Seb-C/kiss-orm

Would you consider adding it to the list?

I designed it with a completely different approach and think it could be useful to people.

I've documented install commands for compatibility issues:
https://model.earth/data-pipeline/timelines/sqlite/phiresky/

I included steps from issue 11
But ultimately I still had to run npm install

The last remaining item to resolve is loading the SQLite file. Any ideas?
Error: Could not load httpvfs config: 404 Not Found

Note: You won't see the blog list locally here: http://localhost:3000
Go here instead: http://localhost:3000/blog/

Is the inclusion of "blog" in the site path a possible clue for why the SQLite file is not found?

Hi, just got a SharedArrayBuffer error on firefox while trying to run one of your code blocks on the sqlite post:
https://stackoverflow.com/questions/64650119/react-error-sharedarraybuffer-is-not-defined-in-firefox
Hope this helps!

Just a note to say thanks. It is a very useful project. I often have to deal with large trees of files of many kinds, including the non-open-source ones like DOCX.

I have been using this and also crgrep (https://sourceforge.net/projects/crgrep/files/), which is unfortunately getting a little old now.

Anyway, thanks!

Hi

I'm a complete typescript novice and was trying to rebuild a working blog from this repo to explore using the sqlite components.

After installing TypeScript (npm install typescript) I tried the yarn build command but it failed on:

client/pages/index.tsx:3:21 - error TS2307: Cannot find module '../../posts-built/summary.json' or its corresponding type declarations.

Chasing dow the errors, I created an empty posts-built/summary.json file, then one with the contents {"posts":[]}, but it still wants more; does a schema, or some such, for that object need defining somewhere to be able to run the build?

Hello, I found your blog project very interesting, and I tried to replicate it in my local environment, but it is showing some compatibility errors with React libraries.

Below is the error that is happening.

npm WARN using --force Recommended protections disabled.
npm WARN ERESOLVE overriding peer dependency
npm WARN While resolving: [email protected]
npm WARN Found: [email protected]
npm WARN node_modules/react
npm WARN   react@"^18.2.0" from the root project
npm WARN   32 more (@emotion/react, ...)
npm WARN 
npm WARN Could not resolve dependency:
npm WARN peer react@"^15.3.2 || ^16.0.0" from [email protected]
npm WARN node_modules/react-katex
npm WARN   react-katex@"^2.0.2" from the root project
npm WARN 
npm WARN Conflicting peer dependency: [email protected]
npm WARN node_modules/react
npm WARN   peer react@"^15.3.2 || ^16.0.0" from [email protected]
npm WARN   node_modules/react-katex
npm WARN     react-katex@"^2.0.2" from the root project

➜  ~ node -v 
v18.13.0
➜  ~ npm -v 
9.6.5
➜  ~ yarn -v 
1.22.17
➜  ~ 

This was the first thing I saw upon checking out https://phiresky.netlify.app/blog/2021/hosting-sqlite-databases-on-github-pages/:

Repeated reloads resulted in a seemingly-random cycle between expected behaviour and a return of the above error message. Observed in well-updated FF and Chrome fwiw.