Viewing profile — xi

Maybe you'd like to check FunSQL.jl, my library for compositional construction of SQL queries. It also follows algebraic approach and covers many analytical features of SQL includi…

This is pretty close to how my Julia library [0] for composable construction of SQL queries works: From(foo) |> Where(Get.value . Join(From(bar) |> As(:bar), on = Get.bar.id .== Ge…

Are you serious? Regular Russian troops have been fighting and dying in Ukraine for weeks now. http://www.nato.int/cps/en/natolive/news_112103.htm http://uk.reuters.com/article/201…

A Russian native speaker does not equal a Russian. About 2/3 of the population of Donetsk region identify themselves as ethnic Ukrainians. More than half of those name Russian as t…

Crimea was occupied by Russian forces in February. Military hostilities in mainland Ukraine started in April when Sloviansk has been captured by Russian ex-FSB officer Igor Girkin …

Which means that there is an "excess of 1.5 millions of people" in Donetsk Region, that "[people of] Donetsk Region mustn't be undestood [by the people from the rest of Ukraine], a…

Maybe the TV host didn't challenge him because his comments are already so backward and idiotic as to not need further emphasis. I'll give you a better explanation: the TV host did…

> EDIT: What's the downvote for? A lack of citations? Maybe because of them? The article about Timoshenko is written by a serious antisemitic nutjob.

Orange juice? ...The Florida industry’s aggressive marketing of oranges and orange juice is a key feature of orange juice history, as it slowly developed demand for the product. In…

Armin's implementation of `cached_property` is not entirely correct. Well, it works, but the branch where `value` is not `missing` is never executed: the object's `__dict__` takes …

The original paper, which is quite informative and easy to read: http://www.ploscompbiol.org/article/info%3Adoi%2F10.1371%2Fj...

You are right, now that I read the original article, it appears the particular ant genus they were studying does not use pheromone trails. Since this ant species gather seeds which…

AFAIK, it's completely decentralized. When a scout ant finds food, it returns back to the nest leaving a strong trail of pheromone. Ants tend to follow a pheromone trail and reinfo…

I was about to prepare the query without ties and yes it is a lot harder than necessary and, more important IMO, much less readable/intuitive for people than have to maintain the c…

Thank you. I accept your answer with the note that you ignored my request to return only the latest post when there are more then one posts with the same number of comments, but it…

That means #1 is totally relational (as an aside, you don't need ORDER BY or LIMIT for it either). I would love to see it. Yes, you can do it in SQL, but I'd say it's not easy at a…

People mean different things when they say relational model, so to clarify, by relational model I mean a model in which data is represented as sets of N-tuples of fixed structure, …

ORDER BY, LIMIT/OFFSET have to do with presentation of data. So, although it's highly desired that a language based on the relational model supports them, they have nothing to do w…

People conflate "relational" with "SQL", because of the historical accident that SQL is the most popular way to query relational data. Then when SQL isn't a good fit for their prob…

I'd guess premiere just means offered for the first time.

GPLv3 and AGPLv3 are mutually compatible, that is, you could link GPL code to AGPL code and vice versa.