I was trying to explore a way to build a client/server application in Typescript; after some failed experiments, I found something better: Next.js offer the ability to build a React application and to render server-side its dynamic components.

So you can have the best of the two words: static pre-rendered pages pushed to the browser, and server side components (for doing your overwhelming BORING queries you know :)

Random list of very interesting projects (will be updated, guys).

I will add my own ideas/impression as soon as possible.

From simpler to more complex stuff:

1. sqlite-utils is a rather useful tool for managing SQLite databases, importing structured data and manipulating them from the command line
2. A simple approach to use json, virtual column and indexes to get NoSQL features on SQLite
3. Full text search FTS5
4. Tools from datasette ecosystem (like DogSheep)
5. Litestream Litestream is a standalone streaming replication tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.
6. Dqlite (distributed SQLite) extends SQLite across a cluster of machines, with automatic failover and high-availability to keep your application running. It uses C-Raft, an optimised Raft implementation in C, to gain high-performance transactional consensus and fault tolerance while preserving SQlite’s outstanding efficiency and tiny footprint.
7. Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables A lot of tools, from plugin like Xlite to command line export tools.

1. STRICT TABLES SQLite uses duck-typing and it is very "elastic" on typing. Anyway in the more recent versions you can enable a "STRICT" typing, which does not work on date types, but can help to avoid mixing integer, real and strings in the same column.... see https://www.sqlite.org/stricttables.html

Ebbene sì, dopo oltre un anno dalla sua uscita, e nonostante la crisi imperante, ho deciso di acquistare un Mac Mini M1.

Dopo anni di onoratissimo servizio (nonché modding con disco SSD rimpiazzato al posto del CDROM), il MacBook 2009 era non aggiornabile e benché ancora perfettamente funzionante è stato al momento spento.

Ma andiamo ad iniziare…

You can easily use bash to search-and-replace on variables…

f="/home/alice/myfile.md"
$ echo ${f//.md/.pdf}
/home/alice/myfile.pdf

$ echo ${f//alicee/bob}
/home/alice/myfile.md

$ echo ${f////-}
-home-alice-myfile.md

When you run pihole in a docker container, it could be difficult to build images on the same docker daemon, because docker-compose cannot pass DNS request to another container during build, and normal dns resolution fixes won’t work.

I solved this issue reading this article and configuring my docker daemon to use a public DNS service: