Category: VacationRelay
-
VaRe&DaIn–part 020 of n–testing sqlite has 2 tables
Once the schema creation script ran at startup, I needed proof — not just trust — that SQLite really ends up with the two tables: `vr_data` and `vr_data_history`. So I wrote a Playwright UI test that drives SqliteWeb (the viewer exposed by Aspire) and asserts both tables are visible and that `vr_data` has the expected…
-
VaRe&DaIn–part 001 of n – start idea
I wanted a proof-of-concept app that is truly database-independent: SQL Server, PostgreSQL, MongoDB, or just a local SQLite file. Partly for fun, partly for the engineering challenge, and mostly because real enterprise installs rarely have the same infrastructure. That is the **DaIn (Database Independence)** goal behind this project. That idea became **Vacation Relay (VaRe)**: when…
-
VaRe&DaIn–part 010 of n–creation of database.md
The first iteration of the project should create the database – no matter if SqlServer, PostgreSql, Sqlite or MongoDB ( see references ) . Database independence sounds simple until,because I use simple connections, the app should do schema creation. The challenge is that each backend speaks a different language. SQL Server and PostgreSQL need SQL…