Recent

Author Topic: A diary project with SQLite3...  (Read 623 times)

cdbc

  • Hero Member
  • *****
  • Posts: 2687
    • http://www.cdbc.dk
A diary project with SQLite3...
« on: February 17, 2026, 06:58:37 pm »
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... 8-)
Regards Benny
« Last Edit: February 21, 2026, 10:08:30 pm by cdbc »
If it ain't broke, don't fix it ;)
PCLinuxOS(rolling release) 64bit -> KDE6/QT6 -> FPC Release -> Lazarus Release &  FPC Main -> Lazarus Main

Roland57

  • Hero Member
  • *****
  • Posts: 588
    • msegui.net
Re: A diary project with SQLite3...
« Reply #1 on: February 17, 2026, 08:30:10 pm »
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.  ;D
My projects are on Codeberg.

Roland57

  • Hero Member
  • *****
  • Posts: 588
    • msegui.net
Re: A diary project with SQLite3...
« Reply #2 on: February 17, 2026, 08:46:29 pm »
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?
My projects are on Codeberg.

cdbc

  • Hero Member
  • *****
  • Posts: 2687
    • http://www.cdbc.dk
Re: A diary project with SQLite3...
« Reply #3 on: February 17, 2026, 09:03:25 pm »
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  :D
« Last Edit: February 17, 2026, 09:08:28 pm by cdbc »
If it ain't broke, don't fix it ;)
PCLinuxOS(rolling release) 64bit -> KDE6/QT6 -> FPC Release -> Lazarus Release &  FPC Main -> Lazarus Main

cdbc

  • Hero Member
  • *****
  • Posts: 2687
    • http://www.cdbc.dk
Re: A diary project with SQLite3...
« Reply #4 on: February 19, 2026, 06:12:05 am »
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...  ;D
Regards Benny
If it ain't broke, don't fix it ;)
PCLinuxOS(rolling release) 64bit -> KDE6/QT6 -> FPC Release -> Lazarus Release &  FPC Main -> Lazarus Main

 

TinyPortal © 2005-2018