💾 Archived View for rawtext.club › ~sloum › geminilist › 007534.gmi captured on 2023-09-08 at 16:32:43. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-11-30)
-=-=-=-=-=-=-
Teito Klien opensource at teitoklien.com
Fri Nov 5 08:57:45 GMT 2021
- - - - - - - - - - - - - - - - - - -
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 tohttps://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,KlienOn 5 Nov 2021, 1:58 PM +0530, Anna “CyberTailor” <cyber at 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")-------------- next part --------------An HTML attachment was scrubbed...URL: <https://lists.orbitalfox.eu/archives/gemini/attachments/20211105/9921d55b/attachment.htm>