[users] Gemini "Server of the Day" & database

I'm glad to announce this useless thing! => gemini://sotd.sysrq.in It advertises randomly chosen gemini server for a day. Also there's a list of all servers and SQLite database. And speaking of database, it can be automatically updated by email. => gemini://sotd.sysrq.in/info/README.gmi That's all. (By the way, how to fix this error with PRAGMA foreign_keys: foreign key mismatch - "server_features" referencing "servers")

Hi anna, Cool project ! The foreign key mismatch in your sql table is most likely because, the key , your foreign key is referencing to , is not guaranteed to be unique. Which means its neither the primary key , nor  having the unique constraint which is necessary for the parent key referenced in a foreign key in sqlite3. For more info, refer to https://www.sqlite.org/foreignkeys.html#fk_indexes To help more, I would need to know your dbschema. But hopefully the docs linked above, should help you solve your problem Have a great day ! Regards, Klien On 5 Nov 2021, 1:58 PM +0530, Anna “CyberTailor” <cyber@sysrq.in>, wrote: > I'm glad to announce this useless thing! > > => gemini://sotd.sysrq.in > > It advertises randomly chosen gemini server for a day. > Also there's a list of all servers and SQLite database. > > And speaking of database, it can be automatically updated by email. > => gemini://sotd.sysrq.in/info/README.gmi > > That's all. > > (By the way, how to fix this error with PRAGMA foreign_keys: > foreign key mismatch - "server_features" referencing "servers")