Add support for SQLite's foreign key

[ad-si]

https://www.sqlite.org/foreignkeys.html

[loicknuchel]

Yep!
As there is a lot of specificities in SQL languages, I'm doing what "is needed" => what I need or people ask ;)
I will add this to my todo list :)

BTW: do you have some experience with Elm parser ?
Today the parser is built with regex, this was "easy" but I hit a few walls ^^

[ad-si]

BTW: do you have some experience with Elm parser ?

I actually do 😅. I just wrote a parser for a custom schema specification language. It causes some head scratching in the beginning, but it definitely scales better than Regex. The trick is to force yourself to start with the atoms and then work your way up to the full AST.

[loicknuchel]

Oh, that's awesome ;)
I already tried parsers in several other languages but it has always been hard...
Would you be interested in some pair programming to get me started with it ?

[ad-si]

Ah sorry, a lot of stuff came up at work and it will be some time before I can think of anything else 😭

[loicknuchel]

Outch, be strong!
No problem, I'm moving forward on many part and will do what I can (or have time for ^^)
Tell me if you are interested and have some time to do some pair one day ;)

[loicknuchel]

Hi @ad-si

I implemented SQLite foreign keys (in #41).
Can you try it and tell me if this is fine for you ?

Thanks,
Cheers!

[ad-si]

Uhm, didn't get that far 😅 => #43

[loicknuchel]

haha, will check ^^