Ask HN: is Prolog special or enlightening?
Another blog post, "Six programming paradigms that will change how you think about coding", mentioned Prolog as an example of the mind-expanding "declarative programming" paradigm, which got me curious enough to start experimenting with it.
As an experienced programmer in C++, Python, SQL and other languages, I found myself thinking, "I could do all this quite easily with a relational database, or with structured data types in a mainstream language." Defining relationships between data (e.g. "likes(fred, apple)."), boolean predicates ("is_fruit_eater(X)."), etc., could be represented easily with boolean fields, boolean functions, and so on. And searching through your data for certain conditions is pretty trivial with a for loop or recursive search, with the added bonus that you know what the hell is going on algorithmically without having to read the Prolog interpreter's source code.
But: I'm a Prolog ignoramus at this point and have only scratched the surface, so I wanted to see if any Prolog veterans on here could shed some light. Is there a moment of enlightenment that comes with a little more persistence and study? Am I missing something? Can it be summed up in mainstream-language terms?
People giving advice online seem to take the attitude of "learn everything you possibly can, it can only help your programming knowledge" but with finite time on earth and a bottomless supply of information out there (look at how deep you can go into the game of chess!) that always strikes me a bit glib and uninsightful. So for someone who's walked down the Prolog road - how was it worth it?