English Content

Welcome to the English Section of Gioorgi.com
Do not miss our sitemap!

SQLite, again

SQLite is slowing becoming a new standard. It is fast, and has a growing number of features. Useful settings PRAGMA journal_mode = wal; PRAGMA foreign_keys = true; Query, set, or clear the enforcement of foreign key constraints. PRAGMA busy_timeout=….; In milliseconds, the busy_timeout is associated with each connection to the database and as such you need …

SQLite, again Read More »

Simple method to add historic feature to SQLite

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 …

Simple method to add historic feature to SQLite Read More »

How to re-enable right click

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" …

How to re-enable right click Read More »

PiHole Lockdown

Securing our privacy, defending our rights is increasing becoming difficult. Who can refrain from using Facebook or GMail nowedays? No one. But my printer downloads update, track down my paper usage too often from my taste. We already reviewed PiHole in the past. After some trial and error, here my suggestions Do not put PiHole …

PiHole Lockdown Read More »

HP 42s the BEST calculator and its FAST MODE

The HP 42S accompanied me throughout my university career, secretly designed for me some function graphs and with its 7KB alphanumeric also managed to make me keep some secret notes. I bought it on December 5, 1992, paying it 229,000 lire, a year before I started university (about 200€ now considering inflation * ). I …

HP 42s the BEST calculator and its FAST MODE Read More »

Simple Html debug via CSS

Add the following css lines to your CSS theme, possibly at the end div::before { content:” C:” attr(class) “” } *::before,*::after { color:red; font-weight:100; font-size:1.0em } and div classes will showup easily. Very handly while customizing WoooordPress :) This page show a demo.

The end of the Database Mangement System as we know it

In Microservices architecture, you decompose your services in a set of fine-grained services. These services are full-stack software, from front end API down to database layer. Each microservice is responsible and owns its data. For instance if you have a MovieInventory service and a CheckIn/Checkout services, they must communicate each other via API. To search …

The end of the Database Mangement System as we know it Read More »

The Single-Point-of-Failure called “Cloudflare”

On Friday one of the biggest content delivery network (CDN) had a configuration issue on its DNS, causing a global outrage for about half an hour. Hacker news has a long thread about it, but the embarrassing point is a lot of services was affected (Patreon, npmjs, DigitalOcean, Coinbase, Zendesk, Medium, GitLab…) including healthcheck 3-thrd …

The Single-Point-of-Failure called “Cloudflare” Read More »