💾 Archived View for lists.flounder.online › gemini › threads › YYTrANBBDoz+YTbR@sysrq.in.gmi captured on 2022-07-16 at 16:22:15. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

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

From: cyber@sysrq.in

Date: Fri, 5 Nov 2021 13:27:44 +0500

Message-Id: YYTrANBBDoz+YTbR@sysrq.in

To: <gemini@lists.orbitalfox.eu>

Export

--------------------------------------

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")

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

From: opensource@teitoklien.com

Date: Fri, 5 Nov 2021 08:57:45 +0000

Message-Id: 0109017cef5176c0-d759e0c4-c0e8-4c66-bacc-7b87ddae4e7d-000000@ap-south-1.amazonses.com

To: <gemini@lists.orbitalfox.eu>, "Anna “CyberTailor”" <cyber@sysrq.in>

In-Reply-To: YYTrANBBDoz+YTbR@sysrq.in

Export

--------------------------------------

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: