The "most prestigious French engineering school". Only 3 Nobels though as of 2019, the scientists are mostly at École normale supérieure (Paris). A gazillion CEOs ad politicians however.
Ciro Santilli studied there from 2010 to 2013.
Ciro considers him entering at Polytechnique a small miracle. First, on his second year of University in Brazil, he first had to fail to join the also good but not as good École centrales, which really annoyed him as he saw the "other good students" who wanted to go out get their wish. This also explains why there are so few students from his university going to Polytechnique in the late 2010's: most already went to other locations! Then, on his third year, he tried Polytechnique and got in despite feeling that the others who got in knew much more mathematics and physics than him. Rather, Ciro believes that he got in chiefly due to his intense passion for the sciences which he showed during the interview.
The miracle would have been even greater if it had happened in 2020. At this time, out of 10 Brazilians, 9 are from ITA, the "hardest to get into" university in Brazil, and also military like Polytechnique. Make no mistake, those students are amazing and deserve it without any doubt. But there is more to the story. It could be argued that many of them only go because they don't have any other choice of exchange program. Remember: Ciro had to fail applications on previous universities before getting into Polytech. Also, they don't get any Brazilian degree because ITA has no agreements with Polytechnique, and are therefore extremely likely to never come back. Not that Ciro thinks this is particularly bad for Brazil though, but it does make for a better deal for France overall as well. They also happen to have closer ties across cohorts of different years, and have managed to maintain a Google Doc with scanned past examinations (as of 2020 however, some/all of those examinations have been uploaded publicly, big kudos to them). Also almost all of them are software engineers, which is one of the few disciplines given at the relatively small ITA. This lack of diversity might not be ideal: if I were France, I would rather fish around all top Brazilian schools for "the best".
Besides the amazing funding/opportunities/alumni/staff loop which you can read about elsewhere, Polytechnique is amazing because you can choose what you will study every year to a very large extent.
This is in huge contrast to the crappy systems Ciro had seen e.g. in Brazil's Polytechnic School of the University of São Paulo, where students have to decide basically all their courses in huge packages, either at university entry (thus when they are completely clueless), or at a single point inside the university studies, changes being much harder.
Life quality was also amazing. Good free accommodation on campus and at the time a no-obligations scholarship for every foreign student great sport facilities. It seems that after Ciro left however more restrictions are added to the scholarships, what a shame! As of 2020 not everyone gets scholarships anymore it seems, mostly only loans that have to be paid back later. And those who are not poor have to pay Polytechnique scholarship fees on top of their living costs. And thus French austerity measures are undermining the greatest long term investment a country can possibly make: that of importing the very best students from other countries into yours. This after their host country has already spent 20 years raising and selecting them. And you won't even pay them 2 years of frugal existence to steal some of them them. Even if those students move away from your country later on, the contacts they made in your country mean they are much more likely to bring businesses over. But some will stay. Basically, France is becoming more like the United States.
This also makes it much more difficult for those students to do a PhD afterwards, where they would get paid very little, and are unable to pay their student debts. A PhD would be where they would possibly bring more of the next big thing to your country. Instead, they are much more likely to just go work for some big American company data wrangling and bring nothing to your country but their student debt dividends instead, which they will be pay to pay for in one year with those amazing salaries. And unsurprisingly many go to into banks. What a big time fail, France.
Sport was mandatory due to the military nature of the school. This did have the upside of getting students together more, although Ciro is against all forms of forced intellectual of physical activities for students. If you liked your sport it would be really cool though. But due to Section "Ciro Santilli's knee", he was forced to give up his first beloved choice which was soccer... life can be cruel. If only Ciro had known cycling at at the time, and if only that had been one of the sports you could choose (but of course it isn't, no school will want the bad reputation of when one of their students gets killed in a car accident).
There were also some useless "military exercises", or special situations in which you had to wear the useless school uniform as a formal "respect social clothing". Ciro Santilli is completely against all that meaningless bullshit, this his just a form of theatrical masturbation to nostalgically remember the good old days of Napoleon when France still ruled the world, and before they tortured the Algerians, see also: Video 4. "Gérard Fuchs interview from Ils racontent la Guerre d'Algérie (1982)". If you are going to do military-like stuff, then at least teach students how to shoot modern rifles and modern warfare tactics (which some of the French students actually do in the pre-school mandatory internship), and not this 18th century bullshit. Ciro favours of course the hoodie-wearing, "I only care about your abilities meritocracy" culture of Silicon Valley. And without the political correctness now associated with it in the 2020s. And no shooting people if possible.
During the time Ciro was at Polytechnique in early 2010's, the school was really isolated in the Plateau de Saclay, there were no shops in 10 minute walking distance! You either had to climb 300 steps to go down to the nearest village, Lozère, or take a bus to the nearest town, Massy. The fact that Times Higher Education ranked it as the second best university in the world in 2019 (archive) makes it good justice, given the small 500 student body. Things started to change a bit after Ciro left however, with the creation of the Polytechnic Institute of Paris, which is bringing other schools to the Lozere area. This is for the best, as it might improve the global rankings of Polytechnique. Also it is a waste to have so few students at a technopole. But it will reduce the mystique of the place. You can't have everything in life.
Before 1976, Polytechnique was actually in the center of Paris at the Latin Quarter, so the Lozère mystique is not a traditional thing. But even when in Paris, students were in theory restricted to school grounds a most of the time. Although there are famous stories of a certain tree that could be used to climb the fence to go to Parisian parties when they couldn't stand it anymore. The tree was somewhat intentionally overlooked by school administrators. Polytechnique was drawn to Saclay no doubt because of the gravity of the CEA Paris-Saclay, France's analog to the United States Department of Energy national laboratories.
This made for some good memories though. The isolation favored concentration, and gave the place a mystical feeling. And then when you went to eat amazing Chinese food in Paris it just felt even more special and magic since you were so limited during the week. It was also under those magical circumstances in which Ciro met his wife, another student of the school, see also: Section "The main function of university is sexual selection".
Ciro also agonized about passing courses to get useless grades though! Polytechnique is hard for most Brazilians, specially if you select the more mathematics oriented courses, because the French students were math brainwashed for two years before joining.
Ciro's favorite spots/activities:
- hide in top corner desk of the library to learn some science. Ciro loves libraries.
- weekend days in his awesome room learning Chinese
Figure 1. The room also has a bed and toilet, it was great, and it was free back in those days! Only the kitchen was shared, which is good for meeting people. And for getting your password keylogged in the shared supplies buying system. This actually happened while Ciro was at in Polytechnique, but the keylogger operator was caught, and the semi-secret-unknown-participants-Gestapo-like-but-mostly-head-of-school-approved student association "Khômiss" broke their door (which leads to an internal corridor) with a fire axe, their traditional way of saying that someone fucked up. All students live on campus, which is great for concentration. - randomly go study at night in one of the small 20 person classrooms that were used in the day and left open at night
Figure 3. A typical small classroom at École Polytechnique. Source. The tables are shown in the usual course configuration. Imagine that at night, in pure silence, with some of your best friends studying on a nearby room. The usual course configuration was first a course by the main teacher in a large amphitheater, and then break down into small groups with tutors, known in French as "Petites classes" (PC). In some English-speaking world traditions, such small class system is known as recitation class. While those small classes are a reasonable approach, Ciro Santilli's slow brain would rather just have a book and an online forum where tutors answer questions instead.
Horny Polytechnicienne mural by Binet BD
. Edit: Ciro noticed this mural had been removed as of 2023. Of course it was removed! TODO removal date. TODO photo of the new art that took its place, it seems to be a boring image of R5-D4. Fucking political correctness zealots. A perfectly fine piece of erotica artwork lost forever except for this photo of it. Thanks to Ciro's kinky friend, Mr. F. for in his infinite insight insisting on taking a picture of it.
Every year, student organizations, the binets, get to compete for student elections, and they are allowed to make murals in the school to advertise themselves.
They kinky people from the 1996 Cartoon Binet (BD == Band Dessiné == Cartoon in French) decided to take it to the next level, with the depiction of a horny polytechnicienne, on the corridor near the student bar, the Bôbar, in front of the cartoon library of the Binet BD.
Good old 1996, this would never be allowed in 2019 due to political correctness.
Let's see how much longer it will last.
How about adding a sexy male polytechnicien suggestively holding his theatrical sword (nicknamed the "tangente") with shirt open instead of removing the lady???
In 2022, sexual aggression accusations at Polytechnique surfaced, will the mural survive them?
Ciro heard of two other mural censorship events orally from younger students during a visit in 2023:
- there was a sexy girl from Judo also censored since
- Judo (again) also apparently used a red resing sun symbol that some Chinese students felt was too close to the Japanese war flag: en.wikipedia.org/wiki/Rising_Sun_Flag. This made Ciro feel a strong urge to advertise his mirror of github.com/cirosantilli/china-dictatorship at gitlab.binets.fr/ciro.duran-santilli/china-dictatorship just to test the supposed French obsession with freedom of speech!
Polytechnicienne by Ecole polytechnique
. Source. Promotional documentary in French showing the situation of women at Polytechnique. Ciro couldn't resist putting it next to the horny polytechnicienne.
Of particular note is is the footage of the first year in which women were accepted, 1972: youtu.be/IA1kSC_d4R8?t=298, shortly before Polytechnique moved from central Paris to Lozère in 1976.
www.mondedesgrandesecoles.fr/egalite-femmes-hommes-polytechnique-et-sa-communaute-sengagent claims that as of 2019 only 14% of the students were women.
The following promotional videos give an idea of how the school looks like, although they fundamentally miss the little corners that Ciro really loved in that the place and which made it magic:
And a one second Ciro Santilli appearance from a 2016 video made during the annual Brazilian barbecue (or as close as you an get to it) which many ex-Brazilian students attend able: www.youtube.com/watch?v=ndX_-A2Rjpo&t=189 wearing a Ring t-shirt.
Gérard Fuchs interview from Ils racontent la Guerre d'Algérie (1982)
Source. French. Title translation: "they tell the story War in Algeria". In this segment at this timestamp, French politician and ancient Polytechnician tells of his experience in Algeria, to which all Polytechnicians were sent for 2 years after graduating as part of their mandatory service to the French state. He is not notable enough to have an English Wiki page however unfortunately.
He mentions that the huge scale military operations they did were useless, they enemies could easily notice and escape before they had closed in. He then chose a job in intelligence, the alternative being special operations, without fully knowing what it was going to be. He then once walked into his colleague during an interrogation where torture had obviously been used. He claims however that he managed to forbid torture under his command. He was then gravely shot, but survived.
He then mentions that when he came back and started digesting the experience, he felt that democracy was not enough, and that to actually stop wars people needed to be better informed and have a more direct democracy (a point Ciro Santilli agrees with), and that kind of made him want to become a politician. He looks like a nice guy.
On a related note, the exact same "Maquis"/"Maquisard" is used in French to describe both French WWII Resistance fighters, as well as the Algerian revolutionaries, as the south of France has a somewhat similiar dry bushy region where the revolutionaries would hide. And the French were like the Gestapo in Algeria.
How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it KNF Laboport series laboratory vacuum pump Updated 2025-07-14 +Created 1970-01-01
You can't just talk nice and hope for people to belive you.
You can't not try to break things and just keep everyone happy in their false illusion of safety.
If you do any of that, you will get your ass handed to you in a little gift bag.
All of this is closely linked to Ciro Santilli's self perceived creative personality and being naughty and creative are correlated.
OK, there's a billion questions:
- SQL Server
- stackoverflow.com/questions/485409/generating-a-histogram-from-column-values-in-a-database OP did not know the difference between count and histogram :-) But it's the number one Google result.
- stackoverflow.com/questions/19103991/create-range-bins-from-sql-server-table-for-histograms has a minor extra group by twist, but otherwise fine
- stackoverflow.com/questions/16268441/generate-histogram-in-sql-server
- SQLite
- stackoverflow.com/questions/67514208/how-to-optimise-creating-histogram-bins-in-sqlite perf only, benchmarking would be needed. SQLite.
- stackoverflow.com/questions/32155449/create-a-histogram-with-a-dynamic-number-of-partitions-in-sqlite variable bin size, same number of entries per bin
- stackoverflow.com/questions/60348109/histogram-for-time-periods-using-sqlite-regular-buckets-1h-wide time
- MySQL: stackoverflow.com/questions/1764881/getting-data-for-histogram-plot MySQL appears to extend
ROUNDto also round by integers:ROUND(numeric_value, -2), but this is not widely portable which is a shame - stackoverflow.com/questions/72367652/populating-empty-bins-in-a-histogram-generated-using-sql specifically asks about empty bins, which is amazing. Amazon Redshift dialect unfortunately, but answer provided works widely, and Redshift was forked from PostgreSQL, so there's hope. Those newb open source server focused projects that don't use AGPL!
Let's try it on SQLite 3.40.1, Ubuntu 23.04. Data setup:
sqlite3 tmp.sqlite 'create table t(x integer)'
sqlite3 tmp.sqlite <<EOF
insert into t values (
0,
2,
2,
3,
5,
6,
6,
8,
9,
17,
)
EOF
sqlite3 tmp.sqlite 'create index tx on t(x)'For a bin size of 5 ignoring empty ranges we can:which produces the desired:
sqlite3 tmp.sqlite <<EOF
select floor(x/5)*5 as x,
count(*) as cnt
from t
group by 1
order by 1
EOF0|4
5|5
15|1And to consider empty ranges we can use SQL which outputs the desired:
genenerate_series + as per stackoverflow.com/questions/72367652/populating-empty-bins-in-a-histogram-generated-using-sql:sqlite3 tmp.sqlite <<EOF
select x, sum(cnt) from (
select floor(x/5)*5 as x,
count(*) as cnt
from t
group by 1
union
select *, 0 as cnt from generate_series(0, 15, 5)
)
group by x
EOF0|4
5|5
10|0
15|1
There are unlisted articles, also show them or only show them.