I would like to have a monthly/yearly/daily trigger on the sqlite database. The reason is simple, I don't want to have to use Excel spreadsheets to organize my personal finances.

One way that I found innovative would be to have a trigger for a determined time. Let's say you want the same entry to be repeated n times. An easy way to do this would be to have a trigger for a set time, for example you can set an entry that repeats every month, year, day.

The problem with this approach is that I find it difficult for anyone to want this, as there are excel sheets for this, as well as apps that do this like google calendar, google tasks, etc.

The big advantage I see in this is that people who only deal with data and are not programmers, this can make life easier.

Another advantage is that by default sqlite has the concept of triggers that are triggered automatically from an event that represents an action on the table. But these events do not have a period of time to end or start and in this sense if they had a period of beginning, end or recurrence this could be better used by the ram. Remembering that this event will be repeated n times, which can generate even small or large data consumption depending on the computer.

Another advantage that I notice is that I can't see any database that has this feature, this feature could help me and many people who don't want to use excel.

I want to hear what you all think

SQLite cannot guarantee to be running at the time you want the trigger to be fired, hence it cannot promise you to fire a trigger at a certain time.

A database server like PostgreSQL or MySQL is assumed to be running all the time, hence they can potentially make such a promise.

And even in PostgreSQL you need some extension to do so, like pg_cron or pg_timetable.

Just because a "time trigger" is beyond the original idea of a database system, it's not included anywhere.

It's a typical request which can be fulfilled by an operating system, like task scheduler on Windows or cron on Linux and Unix.

So please don't ask one tool to take over the job of another.

I think you may misunderstand what sqlite and indeed sqlite triggers are designed to do.

What you are describing seems to be a function of the program that you desire to create to display and enter your data.

Sqlite is the storage engine. You can store an entry for a repeating event, or generate multiple future occurrences very easily.

But what you are asking is like requesting your hard drive provides spell checking.

This isn't the role of the database engine. This would be the role of the application that makes use of the database engine.

You can use a programming language that uses SQLite to talk to your database. Your application can trigger hourly, monthly or whenever you desire.

anacron(8) or fcron(8)?

Any example of such programs that are Windows based and Android based?

Any example of such programs that are Windows based and Android based?

In Windows you can use SCHTASKS:

 9:31:22.76>schtasks /?

SCHTASKS /parameter [arguments]

Description:
    Enables an administrator to create, delete, query, change, run and
    end scheduled tasks on a local or remote system.

Parameter List:
    /Create         Creates a new scheduled task.

    /Delete         Deletes the scheduled task(s).

    /Query          Displays all scheduled tasks.

    /Change         Changes the properties of scheduled task.

    /Run            Runs the scheduled task on demand.

    /End            Stops the currently running scheduled task.

    /ShowSid        Shows the security identifier corresponding to a scheduled task name.

    /?              Displays this help message.

Examples:
    SCHTASKS
    SCHTASKS /?
    SCHTASKS /Run /?
    SCHTASKS /End /?
    SCHTASKS /Create /?
    SCHTASKS /Delete /?
    SCHTASKS /Query  /?
    SCHTASKS /Change /?
    SCHTASKS /ShowSid /?

you can also use various programming languages to manage it.

Exactly. The Task Scheduler is a wee little program that initiates execution when the computer IPLs and has what is called "supervision" to ensure that it is running at all times that the computer is running.

Therefore, this program (the Task Scheduler) is capable of "doing things" (firing off other executable programs) based on the system clock. cron does the same this for unix-like systems.

In other words, you can write a program (or several) that does what you want and then use the Task Scheduler to execute them according to the schedule you have set in the Task Scheduler (or cron).

THe SQLite3 library does nothing (not even execute). What executes is a user-written application that uses the SQLite3 library to perform I/O to a "database" disk file. There is no practical limit on what this user-written application may do nor how it is triggered to execute.

In Windows you can use SCHTASKS:

Thank you.

you can also use various programming languages to manage it.

I don't know programming. I only use SQLite for my personal databases.