A diary project with SQLite3...

[cdbc]

Hi
Daily Diary version 5.21.02.2026
Get it HERE.
Here's a small project, I made 4 years ago, it was sort of the fore-runner for my MVP exploration, so it is __very__ crude and simple, but nonetheless a nifty little project, that does exactly what the name says

As a curiousum, it sports a 'readme.md' made for me, by Joao Paulo Schuler and some AI-magic of his -- quite thorough =^ Thanks mate.

It's tested to compile with FPC >= 3.2.2 & Lazarus >= 4.4, get it while it's hot and enjoy...
Regards Benny

[Roland57]

Thank you for the updated version. I will try it out.

and some AI-magic

I understand now why it is so long and boring. 

[Roland57]

Stupid question (from someone having zero experience with DB). Is the DB3 file usable by other applications? Imagine I would like to make a script or a program exporting data from DB3 file to a text file (for example)? Is it possible?

[cdbc]

Hi Roland
Yup, sure is... Practically anything and the kitchen-sink can read and use the 'SQLite3'-format, I just call it '.db3' to remind me, it's a SQLite3 db-file and not a e.g.: 'employee.fdb' which would be a 'Firebird' database(-file).
If you're on *nix or linux, you can go to the commandline and type "sqlite3 daily_diary.db3" + [enter] and it opens the file. You can then query it with the same sql-querys from the diary-app and see the resulting data... etc and so forth.
HTH
Regards Benny

edit: If you need help with that, just holler -- I'm only a click away 

[cdbc]

Hi
I completely forgot, I have an 'Extraction'-tool lying around somewhere, let me know if you need it, then I'll dig it up and clean it up... 
Regards Benny