Turbo Rascal is a development environment for the Commodore computers but also for others like NES and so on.

It is a bit different from other IDE because it is based on a Pascal-like language. It is not easy to compile high level programming language on 6502, but Pascal seems to pay its bill well.

Read More

SQLite is slowing becoming a new standard. It is fast, and has a growing number of features.

Useful settings

1. PRAGMA journal_mode = wal;
2. PRAGMA foreign_keys = true; Query, set, or clear the enforcement of foreign key constraints.
3. PRAGMA busy_timeout=....; In milliseconds, the busy_timeout is associated with each connection to the database and as such you need to set the timeout for each connection.
4. pragma synchronous = OFF; I call this "scissor mode" referring to running with a scissor in hands. This directive disables the call to fsync and it is very dangerous if a power outrange happens on the host. It delegates to filesystem the "fsync". Some database reach full speed disabling fsync call, but your data are not guaranteed to be stored in safe place until operating system flush data (which will eventually occur...).
5. NUMERIC type is special.... https://news.ycombinator.com/item?id=28069694 From the documentation: "A column with NUMERIC affinity may contain values using all five storage classes. When text data is inserted into a NUMERIC column, the storage class of the text is converted to INTEGER or REAL (in order of preference) if the text is a well-formed integer or real literal . . . If the TEXT value is not a well-formed integer or real literal, then the value is stored as TEXT." So NUMERIC is kind of like TEXT except when the text is a pure number.
6. SQLite ".expert" can help you to find out missed indexes:

   For most non-trivial SQL databases, the key to performance is creating the right SQL indexes. In this context "the right SQL indexes" means those that cause the queries that an application needs to optimize run fast. The ".expert" command can assist with this by proposing indexes that might assist with specific queries, were they present in the database.

Relevant reading

• Hosting SQLite databases on static github pages
• Distinctive Features Of SQLite
• SQLite Autoincrement
• SQLite FAQ
• Why SQLite succeeded as a database (Hacker News)
• SQLite small blob storage: 35% Faster Than the Filesystem (Hacker News)
• SQLite: Small, Fast, Reliable – Choose any three (Hacker News)
• Replicated SQLITE (give a try)

I am not a project manager-born killer, but I learned a lot in my tiny life (and with 20+ experience, I am more or less in the middle of my career).

My rules when I must do an estimation are

1. Tune your estimation on the context. To make simple the explanation, I will divide the estimation in categories; for instance take the fine grained and big cost estimation ones. All fine-grained estimation tasks should be between 2 and 10 days (it is an example). Big cost models are done with 10x or 20x days multiplexer Avoid mixing small estimation with bigger one (i.e. do not mix a task of 5 days with a task of 20 days, reason below).
2. Never never never estimate a task less than two days. As one of my boss said, if you ends before your estimation, no one will complain; but be late of a day...also you have no chances to increase it after declaring it. Every time you open your IDE or answer to a call, two days are gone. In a small company I worked for, it was forbidden to have less than two days on a SAP time capture, because admin's customer invoice management overhead was higher than supposed gain.
3. For fine grained estimation follow the 2,3,5 rules, if possibile

If you follow me, you will end up with a set of tasks with a low standard deviation from the average value. Why this is important? Because estimation is an art.

Suppose you have done a wrong estimation on a task, haven’t you?

Read More

In my personal top ten on open source software initiative with some original sin inside them. Note: this is not a negative review, is only a snapshot of the world I see, I could be wrong, but please explain to me my mistakes, if any.

Read More

On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian):

SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I evolved it to be able to support a special use case called “dump to SQLite”.

Read More

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

Read More

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 * ).

Read More

It all started with the Covid Lockdown. For the first time, Italy has complied with the RULES. 97% of people complied with the restraints imposed by a government that certainly did not shine out of charisma, perhaps fear helped.

Then we became the best in the world at managing the epidemic from Covid, the country with fewer resources than Germania and France.

Read More