xi

6 ms·

1.
by xi 5y ago
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 including aggregates/window functions, recursive queries
2.
by xi 5y ago
This is pretty close to how my Julia library [0] for composable construction of SQL queries works: From(foo) |> Where(Get.value .< 10) |> Join(From(bar) |> As(:bar), on = Get.bar.id .== Get.bar_id) |> Where(
3.
by xi 12y ago
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/2014/
4.
by xi 12y ago
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 their native language.
5.
by xi 12y ago
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 and his gang of Russian ultranationalists.
6.
by xi 12y ago
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], and Donetsk Region [and it's people
7.
by xi 12y ago
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 didn't challenge him because it never happened
8.
by xi 12y ago
> 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.
9.
by xi 13y ago
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 1907 oranges became the first perishable fruit “ever” to b
10.
by xi 14y ago
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 precedence over the descriptor as long as the descriptor d
11.
by xi 14y ago
The original paper, which is quite informative and easy to read: http://www.ploscompbiol.org/article/info%3Adoi%2F10.1371%2Fj...
12.
by xi 14y ago
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 are scattered by wind and could be brought back by a singl
13.
by xi 14y ago
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 reinforce it on their return if they find food, so when a good s
14.
by xi 14y ago
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 code and that is exactly why different SQL dialects introduc
15.
by xi 14y ago
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's not hard to adapt you query to satisfy this requirement.
16.
by xi 14y ago
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 all without ORDER BY and LIMIT or windowing functions and
17.
by xi 14y ago
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, and queries are constructed using set-based operations such
18.
by xi 14y ago
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 with the model per se. By fit poorly I mean that you cannot
19.
by xi 14y ago
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 problem, they think relational is not a good fit for their prob
20.
by xi 14y ago
I'd guess premiere just means offered for the first time.
21.
by xi 14y ago
GPLv3 and AGPLv3 are mutually compatible, that is, you could link GPL code to AGPL code and vice versa.
22.
Why is oil black?(shkrobius.livejournal.com)
2 points by xi 15y ago|0 comments
23.
People Behind Debian: Mark Shuttleworth, Ubuntu’s founder(raphaelhertzog.com)
4 points by xi 15y ago|0 comments
24.
What's in which Python?(nedbatchelder.com)
5 points by xi 15y ago|0 comments
25.
New implementation of Python regex(code.google.com)
1 points by xi 15y ago|0 comments
26.
by xi 15y ago
You might be interested in a project I've been working on lately: http://htsql.org/ -- it's a high-level query language that compiles into SQL. The syntax was motivated by URLs and XPath; the semantics is based on navigational model. As
27.
by xi 16y ago
I, for one, prefer fors and ifs to high order functions when reading and writing Python code. I use the latter very sparingly and only when it does not violate the overall "pseudocode" feel of the code. For that, generator expressions and
28.
by xi 16y ago
See http://www.python.org/dev/peps/pep-0374/ for the rationale; but keep in mind it's more than two years old so some of the criticisms may not longer apply.
29.
by xi 16y ago
While each of your individual complains may make sense, as a whole, they are amusingly self-contradictory. You start with arguing for groundbreaking changes in the semantics and internal API, which practically render every single binary ext
30.
by xi 16y ago
Well, I don't entirely agree here; there are some valid concerns about Py3-specific design decisions. Take, for instance, conversion of `str` to Unicode. That * significantly increases the memory footprint as every character requires 2-4

More ›