Re: [web-devel] Yesod, Sqlite, Enabling Foreign Key Support

I think helper function is good variant. I wanted to make it on yesod level but i do not see hackage documentation for newly packages. When documentation will refreshed i can try to make 'foreign enabling' on framework level ;) Thanks. 2011/4/27 Michael Snoyman

I'm not sure we want to enable this by default. What about just providing a helper function that enables the pragma? There's already enough available from the public API to execute arbitrary SQL statements. I don't use SQLite for production deployments personally, so if others have an opinion on this, I'd like to hear it.

Michael

On Tue, Apr 26, 2011 at 1:31 PM, Anton Cheshkov wrote:

...

Hi Michael. Please show the way to enable foreign key support from sqlite connection. Now foreign key constrints does not work for sqlite from Yesod. Thanks.

http://www.sqlite.org/foreignkeys.html -- Best regards, Cheshkov Anton Phone: +7 909 005 18 82 Skype: cheshkov_anton

-- Best regards, Cheshkov Anton Phone: +7 909 005 18 82 Skype: cheshkov_anton