https://github.com/minimaxir/hacker-news-undocumented

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 :)

Read More

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.

Extra feature you can find useful:

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

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

 

Splinch

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:

Read More

JSON Schema is a vocabulary that allows you to annotate and validate JSON documents.

Benefits

On top of it you can run JSON Forms, a  data driven forms library:

On Oracle Autonomous Database (Oracle Cloud DB service), the consumer groups of the predefined service names provide different levels of performance and concurrency.

How do you tune this limits?

1. From the Autonomous Database details page, click Service Console.
2. On the Service Console click Administration.
3. Click Set Resource Management Rules.
4. On the Set Resource Management Rules page, select the Concurrency limit tab

 

For more information see the Oracle Manual

Read More

Log4jShell vulnerability

1. Kasperky article
2. https://www.lunasec.io/docs/blog/log4j-zero-day-update-on-cve-2021-45046/ with the following "news":If you have previously used LOG4J_FORMAT_MSG_NO_LOOKUPS to mitigate the log4shell vulnerability, in certain conditions this will not be sufficient to protect your code from RCE. Refer to our mitigation guide for additional steps you can take to remediate the impact of Log4Shell
3. Apache group released two fix in short delay, after  the second fix was found vulnerable to other attacks, a third fix (2.17.0) was released.

 

1. Shutdown VM and compress the compact the disks
2. Check if you have enough space: you need more or less the space of the VM disks+ minimal RAM configured
3. From your Hyper-V host, run PowerShell as an administrator and then run something like: GET-VM This will display all the VMs running on the current host.
4. Then run:

   $ExportPath = “C:\\Exports”
   Export-VM -Name “BoxNameFromGetVM Step3” -Path $ExportPath

    

Apache Cassandra Compendium, pasting together documentation from https://cassandra.apache.org/doc/latest/cassandra/data_modeling/index.html

Read More

Abstract: Make a database which can be store historic modification is often considered a “secondary” activity, but bad design leads to databases that are difficult to optimize and often not very understandable. In this article we illustrate a simple method that respects the dictates of relational theory & is easy to understand. As a plus we will show it on SQLite, a small but powerful database system.

Read More

Some news site still try in 2021 to disable right click and ability to copy content. These tactis are very very poor, and only block the users not interested in copying/stealing your code.

The  idea is to put something like that on body tag:

<body oncopy="return false" oncut="return false" onpaste="return false" onbeforecopy="return false" ondragstart="return false" onselectstart="return false" oncontextmenu="return false">

The code to re-enable it is easy to find out:

Read More

Good insights from this article:

How to strangle a legacy codebase

The strategy is simple:

Progressively delete the old code base, in favor of a new one.

Here’s the plan:

• Have the new code acts as a proxy for the old code. Users use the new system, but it just redirects to the old one.
• Re-implement each behavior to the new codebase, with no change from the end-user perspective.
• Progressively fade away the old code by making users consume the new behavior. Delete the old, unused code.

[...]

More here

TiddlyWiki is a rich, interactive tool for manipulating complex data with structure that doesn't easily fit into conventional tools like spreadsheets or wordprocessors.

Tiddlywiki born in 2004, is great if you need a fast way to make fast notes. In the past it was able to store itself using local javascript extensions, but now you need a node server or some specific setup.

https://johnnydecimal.com/