How to create a Birthday Reminders application using Blazor Server, C# and SQLite.

The complete re-development of a Blazor Server application from Microsoft SQL Server to SQLite. The final application will send email reminders automatically, warning for forthcoming birthdays (or other important dates). This video shows how to handle date functions in SQLite, in particular how to calculate someone's age and their next birthday.
00:00 - Introduction
03:07 - Demonstration of Birthday Reminders
04:50 - List of programming tasks
05:42 - Create project in Visual Studio 2022
11:04 - Adding NuGet packages (SQLite, Dapper, Syncfusion, Hangfire)
12:23 - Database introduction
13:11 - DB Browser for SQLite
13:37 - Adding SQLite database
15:00 - Adding SQLite table
19:25 - SQLite connection string
20:15 - Syncfusion controls setup and licensing
22:45 - Person class, service and interface
24:53 - Simple list of people
26:36 - Conversion of SQL Server list of people to SQLite
29:55 - Adding a person
33:55 - Prevent duplicates when adding records
37:47 - Updating a person, including duplicate check
42:47 - Delete a person
46:32 - Restrict person list by logged-in user
49:05 - Next birthday and age next birthday introduction
49:43 - Dealing with dates in SQLite
54:51 - SQLite date function examples in DB Browser for SQLite
1:04:11 - Modify person list to show next birthday and age next birthday
1:06:00 - Calculate number of days to next birthday
1:12:10 - Email reminders (manually)
1:14:48 - Hangfire setup and configuration
1:16:23 - Reminder service to send emails automatically
1:19:08 - Housekeeping
1:20:19 - Running the app to create the Hangfire.db file
1:21:48 - Set Hangfire.db properties
1:22:48 - Deploy to Microsoft Azure
References
Blazorcode.uk: blazorcode.uk/birthdayssqlite/
Blazorcode.uk full code: blazorcode.uk/birthdayssqlite...
SQLite: blazorcode.uk/birthdayssqlite...
DB Browser for SQLite: sqlitebrowser.org/
SQLite Date & Time functions: www.sqlite.org/lang_datefunc....
SQLite Tutorial: www.sqlitetutorial.net/
SQLite julianday function: www.techonthenet.com/sqlite/f...

[@jamesscott6864]

Hi Chris, I believe it's now time we explore Blazor Hybrid haha.

[@RouteDeTours]

Using Sqlite was brilliant idea, even if it wasn't your's intitially.
I keep coming back to your videos as no one else explains things anything like as well.
I have a couple of suggestions for future videos, neither of which I expect to even be considered.
1. How to convert the app to Webassembly
2. Instead of opening with a login page, have a a landing page that showcases the app and only allow users to login if they wish.

[@christopherbell7186]

Thanks for your kind words and your suggestions. I, too, keep coming round to thinking about converting the app to web-assembly; it would certainly be a logical next step - but it sounds a bit scary... Your second suggestion is intriguing, I imagine that's a lot more difficult than it sounds!

[@RouteDeTours]

@@christopherbell7186 Thankyou so much for even considering my suggestions.
It would be great if you were able to implement at least one of them, but I agree they are scary.
I have every confidence that if anyone can ...
My second suggestion sounds pretty difficult to me, so I too imagine it would not be something to be taken on lightly.

[@jamesscott6864]

You doing so well Christopher. Keep it up ! You have no idea the great impact you have on most of us around the world. Thank you !

[@christopherbell7186]

Thank you James - I appreciate that! (It was your comment that got me thinking about SQLite, and I'm glad I did!)

[@jamesscott6864]

@@christopherbell7186 you welcome and thank you too.