text:
← Kyiv City Administration Announces Contest for Heaven's Hundred Memorial
【情報レジスト】 5月20日(火)のまとめ――要約・解説 →
Dmitry Tymchuk, Coordinator, Information Resistance.
Brothers and sisters!
Here's the Summary for May 20, 2014 (for the summary from previous day, please see Summary for May 19.
The bad news:
1. In Luhansk and Donetsk Oblasts [regions], separatists captured eleven district election commissions [DEC], there is still a threat of the seizure of eight more.
According to our current Ukrainian legislation, the elections will be valid without a number of polling stations in Donbas. But why should some criminal bandits deny [Ukrainian] citizens the opportunity to make their political choice under normal circumstances?
We want to still believe that Ukrainian special forces will do everything in their power to maximally allow for the work of the election commissions. After all, it's the state's responsibility to ensure the realization of the constitutional rights of its citizens.
2. In the Vekhovna Rada [Ukrainian Parliament], the Party of Regions and the Communists thwarted the vote for the criminalization of bribing voters. Those who bribe the electorate, it was proposed, are to receive punishment of a prison term for up to three years.
As expected, at the mention of a prison term for these tricks, the Party of Regions members and the Communists got really nervous. These gentlemen from the past don't want honest politics. It's just not for them. Their brain refuses to recognize the idea of an honest life.
Something has to be decided about these brains.
Helicopter Ka-52 arriving to take part in Aviadarts-2014 military exercises. Photo source: http://fr.ria.ru/defense/20140520/201264346.html
3. Russia does not forego holding the "Aviadarts-2014" [military] exercises on the eve and day of the Presidential elections in Ukraine. Kyiv gave Moscow 48 hours to provide an explanation regarding these exercises.
It is clear that we won't hear a reasonable explanation. Although these exercises (participants master the combat use of missile, bomb, and cannon gun armaments against ground targets, as well as overcoming the air defense system of a simulated enemy) are in fact, the action script of the Russian Air Force in the invasion of Ukraine.
At the same time, we haven't yet observed the withdrawal of Russian troops from the border areas. However, at least they aren't currently hanging out in the 10-km [6-mile] border zone–which stabilizes the situation somewhat. But it's a rather illusory détente. For real stabilization, we need a complete return of Russian troops to the places of their permanent deployment.
The good news:
1. The Verkhovna Rada of Ukraine voted to adopt the "Memorandum of peace and harmony." It calls for the de-escalation of tension in the country, full support of the Geneva agreements, and the promise of Constitutional reform.
Obviously this document is nothing more than a declaration. But in my opinion, it's a very important step to a real dialogue. Obviously, not with terrorists–we can only speak the language of lead with them. But to a dialogue with the population of East and South–those who for some reasons don't trust Kyiv. But, at the same time, want to live in a unified and stable Ukraine.
2. 100,000 people representing the world community supported the petition to the U.S. government to recognize Russia as a sponsor of terrorism [Ed. –please sign].
If this status is de facto recognized by the West and the whole world thereafter, it will be an indisputable victory for Ukraine. Even though Russia prides itself on its current role as an actual rogue nation, nevertheless the further growth of international support for Ukraine won't hurt.
3. Oligarch Rinat Akhmetov has finally shed his false shame and supported a unified Ukraine. In Donetsk and Luhansk Oblasts, he urged [employees of] his largest enterprises to hold a warning strike against violence and separatism.
We recently criticized Akhmetov for his "memoranda" with the terrorist organization "Donetsk People's Republic." The fellow has redeemed himself. We are glad.
There may be plenty of reasons to explain the behavior of the Donbas oligarch. Let's not forget that a serious part of his business is in Europe–and [people] there wouldn't understand his "cooperation" with the terrorist organization.
On the other hand, while Rinat Leonydovych is torn between the "Russian" and the normal world, his fiefdom in Donbas is slowly getting overshadowed by Kolomoyskyi. Akhmetov doesn't need this type of sport even for free. And that's why his participation in the competition for the title of Best-friend-of-a-unified-Ukraine is self-explanatory.
Again, it's possible that Akhmetov considered the legitimate government to be more acceptable, while threatening to confiscate a part of [his] business, rather than the chaos and anarchy of his pro-Russian buddies. Especially since they vouched to conduct the "nationalization" of Akhmetov's enterprises.
In the end, we do not exclude a double play by Akhmetov. But it's not the point. If this tactical step by Akhmetov positively affects the situation in the region–why shouldn't it be welcomed? And we'll deal with his motives and secret desires later.
Source: Dmitry Tymchuk FB
This entry was posted in Analytics, Dmitry Tymchuk, English, English News, Languages, News, News summary, Opinions and tagged #RussiaInvadesUkraine, #SaveUkraine, #ukraineprotests, ATO, Dmitry Tymchuk, Donetsk, Information Resistance, Luhansk, Party of Regions, Russia, Ukraine. Bookmark the permalink.
5 Responses to Dmitry Tymchuk's Military Blog: Summary – May 20, 2014
patriciasanson says:
Reblogged this on psanson's blog.
godofreason says:
CALL ON THE PEOPLE OF THE EAST TO DEMAND THAT THE PRO – RUSSIAN SEPARATISTS LEAVE ALL SEIZED BUILDINGS AND RETURN ADMINISTATION OF CITIES TO THE POLICE AND LOCAL ADMINISTRATION
IN RETURN THE UKRAINIAN ARMY WITHDRAWS TO IT'S BASES AND DISMANTLES BARRACIDES -AND THEN CALL FOR A REAL REFERENDUM.
LET'S HAND PUTIN THE RESULTS OF A TRUE REFERENDUM THROUGHOUT ALL EASTERN OBLASTS
LET THE PEOPLE DEMOCRATICALLY DECIDE THEIR OWN FUTURE
CALL PUTIN'S BLUFF
A REFORM PROGRAM FOR UKRAINE AND ITS EAST
A democratic country cannot be held together by force of arms. By not calling for a referendum to let the people truly decide whether they want to remain part of Ukraine or separate, the Ukrainian government is allowing the pro Russian separatists to create anarchy forcing the Government to respond with force leading to civilian deaths that are blamed on the Government inflaming the East and turning the East against it and fueling the pro Russian secession drive.
This has given the pro Russians the ability to have their own phony referendum.
Prime Minister Yatsenyuk must at this Conference declare an immediate cession of its offensive BUT leaving troops in place and IMMEDIATELY CALL FOR A REAL REFERENDUM and declare the following:
1. The Ukraine must be declared a bilingual country with both Ukrainian and Russian as EQUAL languages which will have equality of status and equal rights and privileges as to their use in all institutions of Government at ALL levels. Any citizen must be able to obtain ALL government services in either language ANYWHERE in the country. This includes court proceedings.
2. Just as In Canada which is a bilingual country parents can have their children educated in both languages. Just as in Canada, the Ukrainian Government shall place obligations on private actors in Ukrainian society to provide access to goods or services in both official languages (such as the requirement that food products be labeled in both Ukrainian and Russian. The Ukrainian Government will provide support to non-government actors to encourage or promote the use or the status of one or the other of the two official languages. This includes grants and contributions to groups representing the Russian -speaking minority in the West and the Ukrainian -speaking minorities in the East to assist with the establishment of an infrastructure of cultural supports and services.
3. All governors to be democratically elected for ALL Oblasts.
4. A constitutional conference including representatives from the East to establish a new Constitution with decentralization of government services to the Oblasts with relevant tax powers. Donetsk People's Republic cannot participate in this constitutional conference until it vacates all buildings.
5. Ukrainian Government guarantees access for the Russian Federation to the armament industry based in the East which the Russian military is dependent on.
6. Ukrainian Government guarantees the electrical and water flows to Crimea.
7. Ukrainian Government guarantees no membership ever in Natio.
8. Follow the example of Poland that utilizes coal for most of its energy production. Dramatically start switching from gas to coal. Announce that the coal mine wages in Donetsk will be greatly increased.
9. The EU announces a Marshall program for the east to upgrade infrastructure etc.
10. Joining both the Eurasian trade zone and EU trade association, Ukraine will demand full equality in the Eurasian trade zone for both itself and Belorussia and Kazakhstan with Russia. Ukraine will seek to join the Eurasian, EU and the NAFTA trade zones into a free trade association consisting of about 1.3 billion peoples. This massive free trade zone could then be expanded to include South American creating a 2.3 billion membership the total population of China and India.
11. The Ukrainian government will call for a referendum to be held July 5th. The question will be
"Do you want to separate from the Ukraine and join the Russian Federation or remain part of Ukraine? "
The month of June will be declared referendum month. All parties will be given the same EQUAL access to TV and press to make its case. All buildings will be vacated with those pro Russians being given access to make their case to the voters. Once these buildings are vacated, the Ukraine army will withdraw to its bases.
The voting will be controlled by OSCE with each group represented at EACH ballot box and EACH box totally controlled to ensure the ABSOLUTE integrity of the voting. 60% of the total electorate must vote to be legal.
These proposals give Putin a face saving way out of the crisis he has created and boxed himself into. He can claim that he has protected the rights of Russian speakers and has a huge carrot of being an integral part of the largest free trade zone ever created.
John Sarlat says:
12. The return of Crimea to the sovereignty of Ukraine and return of all seized private and public lands and business entities in that territory. Also reparations from Russia for losses incurred to the Citizens of Crimea due to the illegal seizure and invasion of that Ukrainian Territory.
nazdaqau says:
Reblogged this on Ukraine Crisis Center.
Pingback: May 20: In Luhansk and Donetsk Oblasts [regions], separatists captured eleven district election commissions [DEC] | Roman in Ukraine


Distinction. It's in the Jewish community's DNA, and it has enabled our survival throughout the ages. We are a people scattered over all four corners of the Earth, and distinction is the unifier that has made our survival possible.
Our pursuit of distinction has biblical roots – easily seen throughout the Torah including the narrative documenting our journey to freedom beginning with the one bold act that became the first mezuzah. Jewish Egyptians demonstrated tremendous courage to distinguish their households as G-d directed by marking their doorposts with the blood of an animal considered sacred by the Egyptians.
G-d said, "mark your houses" because the values that you hold inside are the hallmark of the Jewish family that will distinguish you for all time. G-d clearly had an eternal message in what the mezuzah represents, and it applies to all institutions today that are extensions of the Jewish home – including our day schools.
With every mezuzah hanging on day school classrooms, there is a clear directive for educators to distinguish Jewish subjects from the other disciplines presented in school. Success in educating Jewishly is directly related to the expression of our distinct values. Day schools should align how they convey Judaic subjects with the desired outcomes for students. They should consider the impact of their decisions on students' Jewish self-esteem. They should ensure their policies, curricula, and evaluations convey to students what it means to be Jewish outside of a purely academic setting. Are all our day schools striving for this level of distinction?
As a funder and active thought partner in the work of the Jewish Education Innovation Challenge, I spend a considerable amount of my philanthropic time meeting talented day school educators and passionate parents and philanthropists, who are deeply invested in the benefits of a day school education. As every year passes, I become more resolute in my belief about the misuse of grades in day schools' Judaic studies classes. It is inconsistent with Jewish wisdom to judge critically a Jew's ability to learn Torah subjects. A student labeled anything but an "A" in a Jewish subject will internalize a view of him or herself as less than great at Jewish study, or worse, a less than great Jew. If we agree that we want to build Jewish self-esteem in students and cultivate their Jewish greatness, what role does administering exams and assigning grades serve? We feel the painful results of this rigid form of evaluation with every student who graduates from a day school without a lifelong love of Jewish learning and a rock solid Jewish identity.
Recently I received a message from my 21-year-old, a second year student studying at IDC Herziliya, noting how much he is 'starting to love the intellectual challenge of Talmud, now that there's no grade.' He even punctuated his WhatsApp message with two emojis: a laughing face and a crying face. He is the same student who lamented with his friends during high school about how demoralized they felt to be judged in Judaic subjects, which are supposed to build a foundation for their identity and support a lifestyle of Jewish engagement and growth.
I know in both my heart and my head that we are doing a huge disservice to our people by imitating a system of evaluation designed for subjects like math and history. Those subjects don't cut to the core of a person's identity. They aren't subjects unique to a people who have a responsibility to distinguish themselves among nations. Those subjects don't inform the values that build a home or a marriage. They aren't the basis for morality or ethical behavior. They don't build future Jewish leaders. Success is reflected in the happiness and well-being of these day school graduates, not on a job title or income level.
While I am all for academic achievement, mastery of textual skills alone is not going to see students to a definition of success that encompasses the whole human being. What will is how they navigate the world and demonstrate their ethics and courage. What will is how solidly rooted they are in their Jewish identity. What will is how relevant they view Jewish values and texts to their lives and the depth of their relationships with Jewish mentors, Jewish practice and ultimately G-d. These are the critical measures of a successful Jewish education.
Courage is a vital trait for Jewish growth and expression. It took an unimaginable amount of courage for those Jews in Egypt to mark their doorposts. It takes courage to move from one culture to another, to change practiced customs, to transform ourselves and even our institutions. Courage is so rare these days in leadership that when it shows up, it gets attention and admiration. I observed a great demonstration of courage last March at the AIPAC policy conference. From the lineup of prestigious speakers, the most talked about speaker was Ambassador Nikki Haley. She said, "The most important thing is to not be afraid to stick with the fundamental principles, even when they go against entrenched customs. Some of those outdated customs have gone unquestioned for years." Ambassador Haley presents a courage that is refreshing in politics. She dares to buck the status quo, stands up to bullying and speaks up for what she believes is just. She is a true hero. This type of courage is not foreign to Jews, who have courage embedded in their core.
I, too, am committed to fighting courageously for what I know is right, for the values that distinguish our people and for future generations of Jews to choose and to own their Judaism. I invite all Jewish day school leaders and stakeholders to have the courage to say what needs to be said, to do what needs to be done, and in doing so connect the dots that will actualize our efforts to evolve day schools into the distinct greatness befitting the Jewish people.
Manette Mayberg is a trustee of the Mayberg Foundation, which founded the Jewish Education Innovation Challenge (JEIC) in 2012. She now works with multiple philanthropic partners to advance JEIC's vision to reignite students' passion for Jewish learning and improve the way Jewish values, literacy, practice and belief are transferred to the next generation.


The Lawson Academy is always looking for candidates who can join our dream team of compassionate and committed professionals. We believe that every child can learn and become his or her best self. The work is not easy, but the rewards are unmatched! This is where your passion can benefit the students who need you most.
Certified Teachers. Responsible for teaching students in grades 6-8, this position is the teacher of record. To advance the mission of the academy while working in a school setting that cultivates respect for the culture(s) of all members of the learning community. All Academy teachers must demonstrate a desire to help students realize their fulfill their potential for intellectual, emotional, physical, and social growth. In accordance with the 5 key components of The Lawson Academy's strategic action plan, Academy faculty and staff are committed to insuring successes in student achievement, student engagement, stakeholder focus, professional growth and development.
Instructional Aide: The job of the Instructional Aide was established for the purpose(s) of working with individual and/or small groups of students under the supervision of a certified teacher in the supervision and instruction of students; reinforcing instruction to individual or small groups of students in a classroom environment, assisting students by modeling the necessary skills to perform assignments; following educational plans; modeling appropriate behaviors and interactions with students and staff; and assisting student. Employees in this classification will receive a variety of assignments including classroom support, lunchroom, playground, etc.
Curriculum and Instructional Specialist is responsible for the facilitation and improvement of the school-wide instructional plan and response to intervention plan. This role requires strong collaborative, teaching, coaching, and leadership skills to support student programming and work in a team setting.
Parent Engagement Liaison supports families and The Lawson Academy in building success through consistent daily attendance, parent involvement and education, and maintaining high academic expectations for all students.


text:
Settler Aggression
Palestine issue features high on agenda of Doha Interfaith Dialogue
The Palestinian issue has been present in the past nine Interfaith Dialogue Conferences hosted annually in Qatar, but was only really highlighted in the 10th conference held from April...
Israeli forces uproots Palestinian trees in West Bank
Israeli occupation forces uprooted on Tuesday hundreds of olive and almond trees in Un-Neer neighbourhood in the West Bank city of Hebron, Palestinian media reported. Palestinian citizen, Nasser Nawaja'a,...
Israeli settlers torch 10 Palestinian cars
On Tuesday morning Israeli settlers blazed ten Palestinian cars in Dier Jareer neighbourhood in the east of the West Bank city of Ramallah. Local sources said that Israeli settlers...
Israeli police enable rabbis and settlers to mark Passover inside Al-Aqsa Mosque
Protected by Israeli police officers, a large number of rabbis and illegal settlers have entered Al-Aqsa Mosque to mark the Jewish Passover. The mosque is the third holiest place...
Knesset bill proposed allowing Israeli settlers to open fire on Palestinians
In the first bill to be proposed in support of Israeli settlers in the West Bank, a Member of the Knesset for the Jewish Home Party –...
Pope Francis urged to ask Israel to stop the construction of the Separation Wall in Bethlehem
Palestinian Christians in the village of Beit Jala in the occupied West Bank have written an open letter to Pope Francis in protest at the Israeli decision to build...
Published in: Europe & Russia, Middle East, News, Vatican City
Sheikh Yusuf al-Qaradawi to visit Gaza next month
Head of the International Union of Muslim Scholars (IUMS), Sheikh Yusuf al-Qaradawi, has announced that he is to visit the Gaza Strip on May 8 with a delegation of...
Jewish settlers burn UN cars and gardens in Jerusalem
Jewish settlers have set fire to several cars belonging to the United Nations and Palestinian-owned gardens in Jerusalem during their celebrations of the so-called Lag B'Omer Festival, during which...
Wave of violence in wake of settler stabbing in West Bank
Hundreds of Israeli settlers have attacked Palestinians across the occupied West Bank following the Tuesday morning stabbing of a settler by a local man. Salam al-Zaghal, 24, stabbed his...
Israel detains senior Muslim officials in Jerusalem
Amid strict security measures around the holy city of Jerusalem, the Israeli occupation detained on Wednesday morning two senior Palestinian religious officials and prevented Muslim worshipers from entering the...
New settlement bloc established in Bethlehem
Palestinians sources have stated that Israeli occupation forces have allowed settlers to establish a new settlement bloc in the town of Beit Sahour, east of Bethlehem. This will mean...
Israeli settlers storm Al-Aqsa Mosque
More than 40 extremist Israeli settlers, including senior Likud officials, invaded Al-Aqsa Mosque through the Maghrabi Gate on Tuesday morning. They said they were commemorating the 'unification' of Jerusalem....
Israeli Religious Affairs Ministry: "Israel is reviewing a law allowing the division of prayer times between Muslims and Jews in Al-Aqsa Mosque"
The Director-general of the Israeli "Religious Affairs Ministry" announced during a session in the Knesset that the ministry is seeking to review a law that will allow Jews to...
Israel approves nearly 300 new settlements to coincide with Kerry-Livni meeting
As Israeli justice minister, Tzipi Livni, met with US Secretary of State John Kerry in Rome on Wednesday, the Israel Civil Administration approved a plan to build 296 housing...
Jewish settlers set fire to Palestinian farms and desecrate cemetery
Jewish settlers from the illegal Havat Ma'on settlement have set fire to half-an-acre of wheat grown by Ali Awad in the South Hebron Hills. The arson attack took place...
Knesset member calls for building of synagogue in Al-Aqsa courtyard
Israeli Knesset member, Mordechai Eugev, has called for a Jewish synagogue to be built in the southern part of the Aqsa Mosque courtyard. A statement from the Aqsa Foundation...
Ban Ki-moon contacts Netanyahu over Jerusalem violations following pressure from Egypt
Following the demands made by Egypt's permanent representative at the UN, UN Secretary General, Ban Ki-Moon, phoned Israeli Prime Minister, Benjamin Netanyahu, asking him to halt Israeli violations against...
Israel seeks to legalise four settlement outposts in the West Bank
The Israeli Peace Now movement has revealed plans by the Israeli authorities to start legalising four settlement outposts built on private land in the occupied West Bank. According to...
Israel cancels UNESCO mission to Jerusalem
Israeli authorities announced on Monday that they had cancelled the UNESCO mission due to visit the old city of Jerusalem because the Palestinian Authority had failed to keep the...
Israel constructed 16,000 settlement units over the past 3 years
Saeb Erekat, member of the Palestinian Liberation Organisation (PLO) Executive Committee, stated that the Israeli government "Continues to exercise the settlement policy on the occupied Palestinian territories." During a...
Google Palestine angers Gush Etzion's settlers
Settlers from the Gush Etzion settlement have expressed outrage after discovering that they belong to the State of Palestine on the global search engine of Google, as stated on...
Israeli forces detain five minors & three security officers, & kidnaps one
Undercover Israeli forces on Wednesday morning kidnapped a Palestinian citizen from Jenin in the northern West Bank. Eight orphans and three Palestinian security officers were also arrested from other...
Netanyahu will not freeze settlements in return for resumption of negotiations
An Israeli official has claimed that Prime Minister Benjamin Netanyahu will not freeze West Bank settlements in order to facilitate the resumption of peace talks and negotiations with the...
Israel re-arms settlers in the occupied Golan Heights
Israel has decided to re-arm and train teams of illegal settlers in the occupied Syrian Golan Heights. Hebrew media sources claim that the decision was made in the context...
Israeli settlers seek to legalise West Bank settlement by building new homes
Israeli settlers have begun construction of new buildings in the illegal Israeli settlement of Amona in the north of the occupied West Bank city of Ramallah, Israeli sources said...
Israeli forces block efforts to extinguish fires caused by settler arson attacks
Israeli occupation forces have blocked efforts to extinguish fires caused by Jewish settlers' arson attacks. A fire engine sent to help was prevented from getting close to the blazes...
Draft bill paves way for annexation of West Bank
Israel's Likud Party, headed by Prime Minister Benjamin Netanyahu, has proposed a basic law with constitutional status which, if passed by the Knesset, would lead to the annexation of...
Israeli aggression escalates
Israeli aggression against Palestinians in the occupied West Bank and Gaza Strip continues to escalate. The occupation forces arrested 17 Palestinians in Jerusalem and the Israeli navy opened fire...
Israeli settlers uproot 300 fruit bearing olive trees in the West Bank
Israeli settlers from the Itmar Settlement on Wednesday afternoon uprooted 300 fruit bearing olive trees in Awerta village in the north of the occupied West Bank. A Palestinian official,...
Netanyahu acknowledges Israeli "racism" and "hooliganism"
Israeli Prime Minister Benjamin Netanyahu has criticised the management of Superland Amusement Park for refusing to allow Arab students to enter on the same day as Jews. He described...
Israel escalates attacks on Jerusalem in May
Israeli attacks on Palestinian citizens and properties in occupied Jerusalem increased sharply in May, a local research and study centre has reported. Wadi Al-Hilwa Information Centre (WAIC) said that...
CBS reports sharp increase in Israeli settlement construction during 2013
Official Israeli data has shown a 176 per cent increase in Israeli settlement during the first quarter of 2013 when compared with the same period last year, the Israeli...

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: ATHENA/PRESTO complex query with multiple unnested tables i have i would like to create a join over several tables.
table login : I would like to retrieve all the data from login
table logging : calculating the Nb_of_sessions for each db & for each a specific event type by user
table meeting : calculating the Nb_of_meetings for each db & for each user
table live : calculating the Nb_of_live for each db & for each user
I have those queries with the right results :
SELECT db.id,_id as userid,firstname,lastname
FROM  "logins"."login",
UNNEST(dbs) AS a1 (db)

SELECT dbid,userid,count(distinct(sessionid)) as no_of_visits,
       array_join(array_agg(value.from_url),',') as from_url
FROM "loggings"."logging"
where event='url_event'
group by db.id,userid;

SELECT dbid,userid AS userid,count(*) as nb_interviews,
      array_join(array_agg(interviewer),',') as interviewer
FROM  "meetings"."meeting"
group by dbid,userid;

SELECT dbid,r1.user._id AS userid,count(_id) as nb_chat
FROM "lives"."live",
UNNEST(users) AS r1 (user)
group by dbid,r1.user._id;

But when i begin to try put it all together, it seems i retrieve bad data (i have only on db retrieved) and it seems not efficient.
select a1.db.id,a._id as userid,a.firstname,a.lastname,count(rl._id) as nb_chat
FROM
"logins"."login" a,
"loggings"."logging" b,
"meetings"."meeting" c,
"lives"."live" d,
UNNEST(dbs) AS a1 (db),
UNNEST(users) AS r1 (user)
where a._id = b.userid AND a._id = c.userid AND a._id = r1.user._id
group by 1,2,3,4

Do you have an idea ?
Regards.

A: The easiest way is to work with with to structure the subquery and then reference them.
with parameter reference:

You can use WITH to flatten nested queries, or to simplify subqueries.
The WITH clause precedes the SELECT list in a query and defines one or
more subqueries for use within the SELECT query.
Each subquery defines a temporary table, similar to a view definition,
which you can reference in the FROM clause. The tables are used only
when the query runs.

Since you already have working sub queries, the following should work:
with logins as
(
    SELECT db.id,_id as userid,firstname,lastname
    FROM  "logins"."login",
    UNNEST(dbs) AS a1 (db)
)
,visits as
(
    SELECT dbid,userid,count(distinct(sessionid)) as no_of_visits,
           array_join(array_agg(value.from_url),',') as from_url
    FROM "loggings"."logging"
    where event='url_event'
    group by db.id,userid
)
,meetings as
(
    SELECT dbid,userid AS userid,count(*) as nb_interviews,
          array_join(array_agg(interviewer),',') as interviewer
    FROM  "meetings"."meeting"
    group by dbid,userid
)
,chats as
(
    SELECT dbid,r1.user._id AS userid,count(_id) as nb_chat
    FROM "lives"."live",
    UNNEST(users) AS r1 (user)
    group by dbid,r1.user._id
)
select *
from logins l
left join visits v
    on l.dbid = v.dbid
    and l.userid = v.userid
left join meetings m
    on l.dbid = m.dbid
    and l.userid = m.userid
left join chats c
    on l.dbid = c.dbid
    and l.userid = c.userid;

redpajama_set_name: RedPajamaStackExchange


text:
Florence M Rose
Obituary of Florence M Rose
Please share a memory of Florence to include in a keepsake book for family and friends.
With profound sadness we announce the passing of Florence, our loving and devoted mother and friend to all whose lives she touched, on April 24, 2022.
Florence Maud Rose was born February 10th 1959 in St Mary Jamaica. At three years old she moved to Kingston. She attended Maxfield Park Primary and then Norman Manley for high school, where she graduated at the age of 17.
Six months later on February 18th 1977 she made history by becoming one of the first females to join the Jamaica defense force women's unit. She was 1 of only 54 women selected from the thousands that applied. She proudly served from 1977-1983.
She got married in 1982 to Ainsworth Rose. She had 3 children Marsha and her husband Francisco Alvarez, Ainsworth Jr. and his wife, Mikeyah and Basil and his wife, Miya. In July of 1986 she migrated to the United States of America where she worked as a nanny from 1986-2017. In August of 2017 she resigned from being a nanny. At the age of 59 she earned her CDL and joined the New Jersey Transit family.
On September 13, 2018 she was diagnosed with stage 4 colon cancer. She fought her illness with valor and grace and is now survived by her husband, 3 children, 6 grandchildren and 6 nieces and nephews, Joel, Mikayla, Francisco, Ainsworth, Michael, Mikaiya. Her brother Keith and sister in laws Maureen and Diana
Florence had many special friendships that spanned her lifetime.
Elaine Powery is her best friend of 40 years.
Erna VonAutenreid
Maria Guarino
Mellisa Williams (God Daughter)
Florence took special pride in the children she cared for throughout her career:Ava, Riley, Alec, Kayla, Paul, Christopher, Kurt, Sloane, Andrew and so many more.
She was a proud mom, wife, soldier but most importantly a friend to all. She will surely be missed.
Relatives and friends are invited to visit at the Festa Memorial Funeral Home, 111 Union Blvd, Totowa, on Sunday 2:00-6:00 PM. Funeral is private at the request of the family. In lieu of flowers, donations to Memorial Sloan Kettering Cancer Center, 1275 York Avenue, New York, NY would be appreciated.
To send flowers to the family or plant a tree in memory of Florence Rose, please visit Tribute Store
Order Flowers for Florence Rose's Visitation at Funeral Home
Florence Rose


NEW Now offering a 2.25" or 2.5" mandrel exhaust system. Our 3 piece slip fit easy install system offers a nice close tuck to the floor pan.
FLOWMASTER SUPER HP-2 MUFFLER 2.5"
Brand:Flowmaster Part Type:Mufflers Product Line:Flowmaster Super HP-2 Mufflers Muffler Material: Stainless steel Case Shape: Oval Inlet Diameter (in): 2.500 in. Inlet Quantity: One Inlet Location: Center Outlet Diameter (in): 2.500 in. Outlet Quantity: One Outlet Location: Center Muffler Finish: Black Case Exterior Length (in.): 12.000 in. Overall Length (in): 17.000 in. Thickness (in): 4.000 in. Width (in): 5.000 in. Quantity: Sold individually.
These Super HP-2 mufflers from Flowmaster are designed for use with our exhaust systems. They feature stainless steel construction with an internal, layered-laminar jet engine gas flow design that uses guided sound control with broadband sound cancellation for a mellow '50s tone. These mufflers support up to 400 HP, while delivering outstanding looks, durability, and sound control.
FLOWMASTER SUPER HP-2 MUFFLER 2.25"
Brand:Flowmaster Manufacturer's Part Number: 12412409 Part Type:Mufflers Product Line:Flowmaster Super HP-2 Mufflers Muffler Material: Stainless steel Case Shape: Oval Inlet Diameter (in): 2.250 in. Inlet Quantity: One Inlet Location: Center Outlet Diameter (in): 2.250 in. Outlet Quantity: One Outlet Location: Center Muffler Finish: Black Case Exterior Length (in.): 12.000 in. Overall Length (in): 17.000 in. Thickness (in): 4.000 in. Width (in): 5.000 in. Quantity: Sold individually.
Nissan Comp UNCOATED mild steel header. Please select size options. Most headers are made to order, please allow 2-4 weeks for shipping.


text:
Q: Retrieving JSON Object Property comes out as undefined in NodeJS Request I'm sending a POST request to an external API which returns a JSON response. But I'm unable to access the JSON property it comes out as undefined however when I print the whole body the property exists. I have tried cloning the body to a new variable but it didn't work. Also tried parsing the JSON again but it didn't work either.
request.post({url:`http://2captcha.com/in.php?key=${key}&method=${service}&sitekey=${sitekey}&pageurl=${pageurl}&json=${json}`}, function(error, response, body){
                   if (response.statusCode == 200) {
                       console.log(body);
                       console.log(body.status);
                       console.log(body.request);
                   }

My console
{"status":1,"request":"67055353796"}
undefined
undefined


text:
Warlpiri Sign Language, also known as Rdaka-rdaka (hand signs), is a sign language used by the Warlpiri, an Aboriginal community in the central desert region of Australia. It is one of the most elaborate, and certainly the most studied, of all Australian Aboriginal sign languages.

Social context
While many neighbouring language groups such as Arrernte and the Western Desert Language have auxiliary sign languages, Warlpiri Sign Language, along with Warumungu Sign Language, appears to be the most well developed and widely used — it is as complete a system of communication as spoken Warlpiri. This is possibly due to the tradition that widows should not speak during an extended mourning period which can last for months or even years; during this time they communicate solely by sign language.

In Warlpiri communities, widows also tend to live away from their families, with other widows or young single women. As a result, it is typical for Warlpiri women to have a better command of the sign language than men, and among older women at Yuendumu, Warlpiri Sign Language is in constant use, whether they are under a speech ban or not. However, all members of the community understand it, and may sign in situations where speech is undesirable, such as while hunting, in private communication, across distances, while ill, or for subjects that require a special reverence or respect. Many also use signs as an accompaniment to speech.

Linguistics
British linguist Adam Kendon (1988) argues that Warlpiri Sign Language is best understood as a manual representation of the spoken Warlpiri language (a manually coded language), rather than as a separate language; individual signs represent morphemes from spoken Warlpiri, which are expressed in the same word order as the oral language. However, "markers of case relations, tense, and cliticised pronouns are not signed."  Some spatial grammatical features are present which do not exist in spoken Warlpiri, though spoken Warlpiri incorporates directionals in its verbs, and in such cases sign corresponds to speech.

See also
Yolngu Sign Language

References

Further reading
 C.D. Wright (1980) Walpiri Hand Talk: An Illustrated Dictionary of Hand Signs used by the Walpiri People of Central Australia. Darwin: N.T. Department of Education.
 Mervyn Meggitt (1954) Sign language among the Warlpiri of Central Australia. Oceania, 25(1), pp. 2–16 (reprinted (1978) in Aboriginal sign languages of the Americas and Australia. New York: Plenum Press, vol. 2, pp. 409–423)
 Adam Kendon (1985) Iconicity in Warlpiri Sign language. In Bouissac P., Herzfeld M. & Posner R. (eds), Inconicity: Essay on the Nature of Culture . Tübingen: Stauffenburger Verlag.
 A. Kendon (1988) Parallels and divergences between Warlpiri sign language and spoken Warlpiri: analyses of signed and spoken discourses. Oceania, 58, pp. 239–254.
 A. Kendon (1988) Sign Languages of Aboriginal Australia:Cultural, Semiotic and Communicative Perpsectives. Cambridge University Press
 A. Kendon (1980) The sign language of the women of Yuendumu: A preliminary report on the structure of Warlpiri sign language. Sign Language Studies, 1980 27, 101–112.
 A. Kendon (1984) Knowledge of sign language in an Australian Aboriginal community. Journal of Anthropological Research. 1984 40, 556–576.
 A. Kendon (1985) Variation in Central Australian Aboriginal Sign language: A preliminary report. Language in Central Australia, 1(4): 1–11.
 A. Kendon (1987) Simultaneous Speaking and Signing in Warlpiri Sign language Users. Multilingua 1987, 6: 25–68.
 C. P. Mountford (1949) "Gesture language of the Walpari tribe, central Australia" Transactions of the Royal Society of South Australia, 73: 100–101.

Australian Aboriginal Sign Language family
Ngarrkic languages
Warlpiri

redpajama_set_name: RedPajamaWikipedia


text:
using System.Collections.Generic;
using System.Collections.Immutable;
using System.Threading;
using System.Threading.Tasks;
using Microsoft.CodeAnalysis.Host;

namespace Microsoft.CodeAnalysis.LanguageServices
{
    internal interface ISymbolDisplayService : ILanguageService
    {
        string ToDisplayString(ISymbol symbol, SymbolDisplayFormat format = null);
        string ToMinimalDisplayString(SemanticModel semanticModel, int position, ISymbol symbol, SymbolDisplayFormat format = null);
        ImmutableArray<SymbolDisplayPart> ToDisplayParts(ISymbol symbol, SymbolDisplayFormat format = null);
        ImmutableArray<SymbolDisplayPart> ToMinimalDisplayParts(SemanticModel semanticModel, int position, ISymbol symbol, SymbolDisplayFormat format = null);
        Task<string> ToDescriptionStringAsync(Workspace workspace, SemanticModel semanticModel, int position, ISymbol symbol, SymbolDescriptionGroups groups = SymbolDescriptionGroups.All, CancellationToken cancellationToken = default(CancellationToken));
        Task<string> ToDescriptionStringAsync(Workspace workspace, SemanticModel semanticModel, int position, ImmutableArray<ISymbol> symbols, SymbolDescriptionGroups groups = SymbolDescriptionGroups.All, CancellationToken cancellationToken = default(CancellationToken));
        Task<ImmutableArray<SymbolDisplayPart>> ToDescriptionPartsAsync(Workspace workspace, SemanticModel semanticModel, int position, ImmutableArray<ISymbol> symbols, SymbolDescriptionGroups groups = SymbolDescriptionGroups.All, CancellationToken cancellationToken = default(CancellationToken));
        Task<IDictionary<SymbolDescriptionGroups, ImmutableArray<SymbolDisplayPart>>> ToDescriptionGroupsAsync(Workspace workspace, SemanticModel semanticModel, int position, ImmutableArray<ISymbol> symbols, CancellationToken cancellationToken = default(CancellationToken));
    }
}

redpajama_set_name: RedPajamaGithub


Strecture:Multiple Outer Zipper Pockets including 1 front zip pockets and 2 zip pockets with a inner pocket.
Dimension:7.5"*2.8"*6.7"(L*W*H) /19x7x17cm,Weight:250g.The Crossbody purse has 3 zipper compartments are perfect for your wallets, cellphone, water bottle,umbrella and other personal belongings,convenient to organize your items.
Made of high quality water-resistant nylon with the properties of lightweight,practical and easy to clean.Equipped with classic gold hardware and zippers,smooth and easy to open and close.
Adjustable shoulder strap durable & soft top handle,allows the handbag to be worn as crossbody bag,shoulder bag,handbag,messenger bag.Match with suitable apparel for different occasion.
MONEY BACK GUARANTEE - We know you'll love our small cross body purse or cellphone bags as much as we do, if for any reason you're not 100% SATISFIED, let us know and our customer service team will make things right: full refund or a free replacement, whichever you prefer.


text:
Creates ZIP output streams. Depends on Node's build-in zlib module for compression available since version 0.6.

*This is a fork of the original repo meant to resolve several issues and hopefully more active development.*

## Install
    npm install zipstream-ctalkington

## API
    createZip(options)

Creates a ZipStream object. Options are passed to Zlib.

    ZipStream.addFile(inputStream, options, callback)

Adds a file to the ZIP stream. At this moment, options must contain "name". If the "store" option is set to true, the file will be added uncompressed.

    ZipStream.finalize(callback(bytes written))

Finalizes the ZIP. When everything is done, callback is called with the total number of bytes in the ZIP archive.

## Example
```javascript
var fs = require('fs');

var zipstream = require('zipstream-ctalkington');

var out = fs.createWriteStream('out.zip');
var zip = zipstream.createZip({ level: 1 });

zip.pipe(out);

zip.addFile(fs.createReadStream('file1.js'), { name: 'file1.js' }, function() {
  zip.addFile(fs.createReadStream('file2.js'), { name: 'file2.js' }, function() {
    zip.finalize(function(written) { console.log(written + ' total bytes written'); });
  });
});
```

## Contributing

#### Code Style Guide

* code should be indented with 2 spaces
* single quotes should be used where feasible
* commas should be followed by a single space (function params, etc)
* variable declaration should include `var`, [no multiple declarations](http://benalman.com/news/2012/05/multiple-var-statements-javascript/)

#### Tests

* tests should be added to the nodeunit config in `test/tests.js`
* tests can be run with `npm test`
* see existing tests for guidance

## Credits
Originally written by Antoine van Wel ([website](http://wellawaretech.com)).


Given that today is Mother's Day here in the U.S. I thought it would be rather appropriate to to talk about how vital and important my support network has been for me in terms of my recovery since my surgery 35 days ago.
I have mentioned this before but although you prepare for this surgery and you read about everything that happens and all the aspects of recovery, you recognise that it really is major facial surgery . . .
When I think about the surgery, these are some of the words that I think about: swelling, bruising, pain, aches, eating, drinking, medicine, wires, scratches, braces, blending, syringing, rubber bands, jaw exercises, yawning, sneezing, sleep apnea, snoring, Doctor visits, food shopping, weight loss, work, and so many more word associations.
Now when you consider all of the above, it comes as no surprise, that to go through all of this is just not possible without a great support network. Now this phrase is probably very American but essentially what I am talking about is a group of people (family, friends, neighbours, co-workers, etc.) who have help me where my recovery is concerned. I have read a lot of blogs and forums where people return from surgery on their own and take care of themselves. Let me just tell you know, I have no idea how they managed on their own. There is simply no way to do it!
My wife has, by a large margin, been my biggest support during the last month; starting from the time I was in hospital when the nurse asked her to suction my mouth (gross) of blood and everything, to running to stores to get the various medicines, foods, drinks, Jamba Juice and other items. As well as driving everywhere, she was constantly helping me prepare the food, medicines, making sure I was taking naps and basically completely taking care of me! When you consider that not only did she take care of me and everything that entails but also running the kids to school, their numerous extra-curricular activities, volunteering at school, etc., it has been the craziest month of her life I am sure!
It has been really quite amazing to see how many other people have helped, whether it be my in-laws helping to take me to Doc visits or taking the kids to school early in the morning, to friends and neighbours spontaneously bringing around dinners for the family and milkshakes for me! Lots of friends and neighbours brought around DVDs for me to watch or else they just asked how I was doing and whether they could help in any way. It has been really amazing to be honest and I am incredibly grateful to everyone!
Getting back to my original thought - I recognise that everything is possible and you can no doubt have this surgery without a lot of support from family or friends but being at the receiving end of so much support, it has definitely made the recovery so much more manageable and easier.
So there you have it, I recognise that is not my usual post in terms of updates where my recovery is concerned but really, having a great support network is part of the recovery process! So thanks to everyone, and especially my wife, for doing so much for me in the last month, I truly, truly, am appreciative and grateful!


Ignore the mess. For the passed 2 weeks families been up from Tucson and the containers been used as guest house a kitchen, and storage for vast amounts of building supplies that slowly disappear into the structure then get replenished after frequent trips to home depot. Picture above is of the front wall.
Electrical is all run except for the bathroom, which Ill build once I get the duct work in the attic done.
All the progress has Ginger flat out tuckered!
Sorry, I can't remember, will you have "shore power" or provide your own?
Hey Squire, it'll be all solar generator back up if needed.
Wow, lots of work there with the insulation and the electric. I am going to have to lie down now, like Ginger, after just looking at the pics.!!
Ginger, learn to pace yourself. Looking good. Duct work,ceiling? Some a/c?


text:
Home Uncategorized School board reviewing School Resource Officers contracts
School board reviewing School Resource Officers contracts
Contracts for school resource officers in schools are currently under review.
Superintendent of Schools Dr. Dan Rawls says the contracts have been sent to the Webster Parish School Board's attorney Jon Guice and expects to have approval no later than the August 3 meeting.
"If the board approves the positions, we will do a budget revision and include them in the budget," Rawls said. "The reason they weren't in the initial budget is because they came in after the budget had already been constructed and was out for public review. We have a number of accounts that we have to do budget revisions on and that's going to be one of them."
Springhill Police Chief Will Lynd and Springhill Mayor Carroll Breaux approached the board in June about getting the school board to pay for an SRO for them. Currently, the city pays for an SRO stationed at North Webster High School, but he covers other schools when needed, Lynd said in June.
Minden currently has two SROs, one recently becoming full-time at Webster Junior High School.
The board since has come back and said they wanted SROs to cover the other schools as well. Rawls says the board has asked for one for Doyline and Lakeside (one to be split between the two schools), one to be split between North Webster High School and North Webster Junior High and the two in Minden.
In the contracts will be what performances are needed, costs, terms and limits of the contract. Then the board will have to decide where the SROs will be, whether they will be full time or part time and list the conditions.
Lynd says he just wants it all to be fair across the board.
"It's their decision; it doesn't make me any difference either way," he said. "I want it to be fair for everybody. I want it to be fair for Minden, and I want it to be fair for Springhill."
He and Mayor Breaux attended Monday's board meeting, but they were not told it wouldn't be on the agenda, he says. However, he reiterated he just wants it to be fair.
In Minden, the school board pays for one full-time SRO at Minden High School for 10 months out of the year. The other two months, Sgt. Tokia Whiting goes back on regular patrol and back on the police department's payroll.
Rawls says with the deletion of one position (an industrial arts instructor), they should have the money to cover the expense of paying the SROs.


We let the global buyers lay their hands on the trendsetting assortment of the Embroidered Products that is handmade and hand-embroidered by the talented artisans. We are enlisted amid the fêted Manufacturers and Exporters of the Embroidered Products from Delhi, India. Our Embroidered Products are scrupulously screened to ensure the impeccable quality. Avail from us the Embroidered Suits, Embroidered Scarves, Embroidered Jackets, and other Embroidered Products at the viable prices.
We strictly use up-to-date equipments in the entire fabrication process which ensure the optimum quality production. Our Embroidered Scarves, embroidered shawl etc., are easily available in multitude of colors. We are a distinguished embroidered woolen shawls exporter from India.


A new study from the Center on Budget Policy and Priorities shows that more than half of states continue to make deep cuts to higher education funding, causing colleges and universities to pass those cuts on to students in the form of tuition hikes and service cuts. Nationwide, states are on average spending 28% less this year than they did in 2008, a decrease of $2,353 per student.
36 states have cut funding by more than 20%, with eleven states cutting funding by more than one-third. Two states — Arizona and New Hampshire — have cut their higher education spending in half. Just last week, Arizona universities announced another 3-5% tuition hike. Since 2007, tuition at Arizona universities has risen more approximately 90%. The report shows that in addition to all this, Arizona's university system cut more than 2,100 positions; consolidated or eliminated 182 colleges, schools, programs, and departments; and closed eight extension campuses.
According to the report, while many of these cuts came in response to the extreme budget compression coming out of the 2008 crisis, their effects may last much longer than that as officials look for ways to repair the damage to schools caused by the cuts. Those repairs, may end up costing more over the long term, had states opted instead to find ways to maintain higher education funding.
Report data shows that average annual tuition at four-year public colleges has grown by $1,850, or 27%, since the 2007-08 school year when adjusted for inflation. Many public colleges come close to $10,000 per year in tuition before room and board, while others still get close to that number inclusive of room and board. In seven states — Arizona, California, Florida, Washington, Georgia, Hawaii, and Alabama — average tuition has increased by more than 50%. Some states like Florida have proposed a $10,000 total cost college degree, instead of a $10,000 yearly tuition rate, although no state has been successful in making it happen yet.
Colleges and universities are making cuts too in response to having smaller funding pools to work with even with tuition increases, which often just fill holes instead of making room for improvement. These cuts mean fewer faculty positions, limited course offerings and cuts to helpful services like post graduate career placement.
Tuition increases at rates of 90% inside of six years also mean the cost of public education has quickly exceeded the resources of many middle class families, and made higher education virtually impossible for low income students who fail to qualify for financial aid or scholarships. Report authors note that, between 1991 and 2011, median household income grew by about 3% while the cost of a four-year public college grew by 159%. Even with grants and tax benefits, the cost of college grew by 58% in real terms, well above the rate of growth in household income.
This is especially problematic as now even low level jobs that previously didn't require a college degree, like service, administrative or trade positions, now do. Bachelor's degrees are required for jobs ranging from file clerk to retail associate. According to the Georgetown Center on Education and the Workforce, by 2018, 62% of all jobs will require at least some college education. That is an increase from 59% in 2007, 56% in 1992, and 28% in 1973. Georgetown Center data in the report shows that the nation's education system will not be able to keep up with the demand for college graduates and based on their projections through 2018, the education system will produce 3 million fewer college graduates than demanded by the private sector. Report authors say that this trend may make it increasingly difficult for lower and middle class people to move up or even maintain a standard of living.
"While debt is a crucial tool for financing higher education, excessive debt can impose considerable costs on both students and society as a whole. Research finds that higher student debt levels are associated with lower rates of home ownership among young adults; can create stresses that reduce the probability of graduation, particularly for students from lower-income families; and reduce the likelihood that graduates with majors in science, technology, engineering, and mathematics will go on to graduate school.
"This research suggests that states should strive to expand college access and increase college graduation rates to help build a strong middle class and develop the skilled workforce needed to compete in today's global economy. It suggests further that the severe higher education funding cuts that states have made since the start of the recession will make it harder to achieve those goals," report authors write.
Even if they can afford it, spots in some of the nation's largest pubic university systems aren't available. The report shows that, California's community colleges have cut enrollment by 485,000 students or about 17%, cut course offerings by 15% resulting in hundreds of thousands of students being denied access to classes, increased class sizes, laid off faculty and staff, and instituted furloughs. Colorado, Louisiana, Nevada, North Carolina, and New Hampshire also showed cuts in allowed class size and teaching positions.
The report calls on state legislatures to avoid making further tax cuts at the expense of an already weak national education system and begin working on a path toward reinvestment and reconstruction. "At the very least, states must avoid shortsighted tax cuts, which would make it much harder for them to invest in higher education, strengthen the skills of their workforce, and compete for the jobs of the future," authors write.


text:
Happily Ever After - by Teleflora's Flower Club
Send someone this delightful floral gift of pretty pink blossoms and share the gift of beauty! A glorious selection of fresh flowers is arranged in a rustic basket, then hand-delivered. What could be lovelier?
A mix of fresh flowers such as pink carnations, Matsumoto asters, Sweet William and alstroemeria is accented with greenery and delivered in a rustic basket.
Item # T11Z107A
Fri, Jan 21, 2022	Sat, Jan 22, 2022	Mon, Jan 24, 2022	Tue, Jan 25, 2022	Wed, Jan 26, 2022	Thu, Jan 27, 2022	Fri, Jan 28, 2022	Sat, Jan 29, 2022	Mon, Jan 31, 2022	Tue, Feb 01, 2022	Wed, Feb 02, 2022	Thu, Feb 03, 2022	Fri, Feb 04, 2022	Sat, Feb 05, 2022	Mon, Feb 07, 2022	Tue, Feb 08, 2022	Wed, Feb 09, 2022	Thu, Feb 10, 2022	Fri, Feb 11, 2022	Sat, Feb 12, 2022	Mon, Feb 14, 2022	Tue, Feb 15, 2022	Wed, Feb 16, 2022	Thu, Feb 17, 2022	Fri, Feb 18, 2022	Sat, Feb 19, 2022	Mon, Feb 21, 2022	Tue, Feb 22, 2022	Wed, Feb 23, 2022	Thu, Feb 24, 2022	Fri, Feb 25, 2022	Sat, Feb 26, 2022	Mon, Feb 28, 2022	Tue, Mar 01, 2022	Wed, Mar 02, 2022	Thu, Mar 03, 2022	Fri, Mar 04, 2022	Sat, Mar 05, 2022	Mon, Mar 07, 2022	Tue, Mar 08, 2022	Wed, Mar 09, 2022	Thu, Mar 10, 2022	Fri, Mar 11, 2022	Sat, Mar 12, 2022	Mon, Mar 14, 2022	Tue, Mar 15, 2022	Wed, Mar 16, 2022	Thu, Mar 17, 2022	Fri, Mar 18, 2022	Sat, Mar 19, 2022	Mon, Mar 21, 2022	Tue, Mar 22, 2022	Wed, Mar 23, 2022	Thu, Mar 24, 2022	Fri, Mar 25, 2022	Sat, Mar 26, 2022	Mon, Mar 28, 2022	Tue, Mar 29, 2022	Wed, Mar 30, 2022	Thu, Mar 31, 2022	Fri, Apr 01, 2022	Sat, Apr 02, 2022	Mon, Apr 04, 2022	Tue, Apr 05, 2022	Wed, Apr 06, 2022	Thu, Apr 07, 2022	Fri, Apr 08, 2022	Sat, Apr 09, 2022	Mon, Apr 11, 2022	Tue, Apr 12, 2022	Wed, Apr 13, 2022	Thu, Apr 14, 2022	Fri, Apr 15, 2022	Sat, Apr 16, 2022	Mon, Apr 18, 2022	Tue, Apr 19, 2022	Wed, Apr 20, 2022	Thu, Apr 21, 2022	 Fri, Jan 21, 2022	Sat, Jan 22, 2022	Mon, Jan 24, 2022	Tue, Jan 25, 2022	Wed, Jan 26, 2022	Thu, Jan 27, 2022	Fri, Jan 28, 2022	Sat, Jan 29, 2022	Mon, Jan 31, 2022	Tue, Feb 01, 2022	Wed, Feb 02, 2022	Thu, Feb 03, 2022	Fri, Feb 04, 2022	Sat, Feb 05, 2022	Mon, Feb 07, 2022	Tue, Feb 08, 2022	Wed, Feb 09, 2022	Thu, Feb 10, 2022	Fri, Feb 11, 2022	Sat, Feb 12, 2022	Mon, Feb 14, 2022	Tue, Feb 15, 2022	Wed, Feb 16, 2022	Thu, Feb 17, 2022	Fri, Feb 18, 2022	Sat, Feb 19, 2022	Mon, Feb 21, 2022	Tue, Feb 22, 2022	Wed, Feb 23, 2022	Thu, Feb 24, 2022	Fri, Feb 25, 2022	Sat, Feb 26, 2022	Mon, Feb 28, 2022	Tue, Mar 01, 2022	Wed, Mar 02, 2022	Thu, Mar 03, 2022	Fri, Mar 04, 2022	Sat, Mar 05, 2022	Mon, Mar 07, 2022	Tue, Mar 08, 2022	Wed, Mar 09, 2022	Thu, Mar 10, 2022	Fri, Mar 11, 2022	Sat, Mar 12, 2022	Mon, Mar 14, 2022	Tue, Mar 15, 2022	Wed, Mar 16, 2022	Thu, Mar 17, 2022	Fri, Mar 18, 2022	Sat, Mar 19, 2022	Mon, Mar 21, 2022	Tue, Mar 22, 2022	Wed, Mar 23, 2022	Thu, Mar 24, 2022	Fri, Mar 25, 2022	Sat, Mar 26, 2022	Mon, Mar 28, 2022	Tue, Mar 29, 2022	Wed, Mar 30, 2022	Thu, Mar 31, 2022	Fri, Apr 01, 2022	Sat, Apr 02, 2022	Mon, Apr 04, 2022	Tue, Apr 05, 2022	Wed, Apr 06, 2022	Thu, Apr 07, 2022	Fri, Apr 08, 2022	Sat, Apr 09, 2022	Mon, Apr 11, 2022	Tue, Apr 12, 2022	Wed, Apr 13, 2022	Thu, Apr 14, 2022	Fri, Apr 15, 2022	Sat, Apr 16, 2022	Mon, Apr 18, 2022	Tue, Apr 19, 2022	Wed, Apr 20, 2022	Thu, Apr 21, 2022	 Fri, Jan 21, 2022	Sat, Jan 22, 2022	Mon, Jan 24, 2022	Tue, Jan 25, 2022	Wed, Jan 26, 2022	Thu, Jan 27, 2022	Fri, Jan 28, 2022	Sat, Jan 29, 2022	Mon, Jan 31, 2022	Tue, Feb 01, 2022	Wed, Feb 02, 2022	Thu, Feb 03, 2022	Fri, Feb 04, 2022	Sat, Feb 05, 2022	Mon, Feb 07, 2022	Tue, Feb 08, 2022	Wed, Feb 09, 2022	Thu, Feb 10, 2022	Fri, Feb 11, 2022	Sat, Feb 12, 2022	Mon, Feb 14, 2022	Tue, Feb 15, 2022	Wed, Feb 16, 2022	Thu, Feb 17, 2022	Fri, Feb 18, 2022	Sat, Feb 19, 2022	Mon, Feb 21, 2022	Tue, Feb 22, 2022	Wed, Feb 23, 2022	Thu, Feb 24, 2022	Fri, Feb 25, 2022	Sat, Feb 26, 2022	Mon, Feb 28, 2022	Tue, Mar 01, 2022	Wed, Mar 02, 2022	Thu, Mar 03, 2022	Fri, Mar 04, 2022	Sat, Mar 05, 2022	Mon, Mar 07, 2022	Tue, Mar 08, 2022	Wed, Mar 09, 2022	Thu, Mar 10, 2022	Fri, Mar 11, 2022	Sat, Mar 12, 2022	Mon, Mar 14, 2022	Tue, Mar 15, 2022	Wed, Mar 16, 2022	Thu, Mar 17, 2022	Fri, Mar 18, 2022	Sat, Mar 19, 2022	Mon, Mar 21, 2022	Tue, Mar 22, 2022	Wed, Mar 23, 2022	Thu, Mar 24, 2022	Fri, Mar 25, 2022	Sat, Mar 26, 2022	Mon, Mar 28, 2022	Tue, Mar 29, 2022	Wed, Mar 30, 2022	Thu, Mar 31, 2022	Fri, Apr 01, 2022	Sat, Apr 02, 2022	Mon, Apr 04, 2022	Tue, Apr 05, 2022	Wed, Apr 06, 2022	Thu, Apr 07, 2022	Fri, Apr 08, 2022	Sat, Apr 09, 2022	Mon, Apr 11, 2022	Tue, Apr 12, 2022	Wed, Apr 13, 2022	Thu, Apr 14, 2022	Fri, Apr 15, 2022	Sat, Apr 16, 2022	Mon, Apr 18, 2022	Tue, Apr 19, 2022	Wed, Apr 20, 2022	Thu, Apr 21, 2022


If you never quite grew out of building things from LEGO, you'll be interested in Philo Hurbain's little creation: a working 3D scanner constructed entirely from the clever little plastic bricks.
As shown over on Make, the device is designed for use with the LDraw LEGO CAD application – specifically to make it easier for Hurbain to model complex LEGO parts in the software.
Constructed entirely from LEGO Technic parts – aside from a small needle used as the probe for the scanner – the device uses a linear actuator to convert the rotational movement of a motor into a linear movement which could be measured by the surprisingly high resolution LEGO NXT encoder.
The video of the device in action shows how the system moves the probe needle around the device and signals to the computer the points at which contact was made. A second movement module allows the object being scanned to move around and rotate, meaning the scanner can operate completely independently of human control. Using the data recorded by the NXT encoder, the scanner is able to provide a cartesian or cylindrical scan.
While the device is certainly neat – and full plans and source code is provided if you'd like to have a go – Hurbain admits that the device is somewhat slow, with a single scan taking "several hours" to complete. Despite this – and due largely to the fact that the device can be left running overnight – it still represents a significant improvement over measuring and modelling small parts by hand.
Tempted to create your own 3D scanner and create models of teeny-tiny objects, or are you simply in awe of how far LEGO has come since you played with it as a kid? Share your thoughts over in the forums.
Some of best Lego toys and models, and a guide to how to make your own Lego USB drive.
Created entirely from LEGO NXT parts - aside from an RFID reader and some IR equipment - the LEGO Automatic Teller Machine is a fully function cashpoint.


text:
Q: Performance bottlenecks in fast evaluation of trig functions using Eigen and MEX In a project using Matlab's C++ MEX API, I have to compute the value exp(j * 2pi * x) for over 100,000 values of x where x is always a positive double. I've written some helper functions that breakdown the computation into sin/cos using euler's formula. I then apply the method of range reduction to reduce my values to their corresponding points in the domain [0,T/4] where T is the period of the exponential I'm computing. I keep track of which quadrant in [0, T] the original value would have fallen into for later. I can then compute the trig function using a taylor series polynomial in horner form and apply the appropriate shift depending on which quadrant the original value was in. For further information on some of the concepts in this technique, check out this answer. Here is the code for this function:
Eigen::VectorXcd calcRot2(const Eigen::Ref<const Eigen::VectorXd>& idxt) {

    Eigen::VectorXd vidxt = idxt.array() - idxt.array().floor();
    Eigen::VectorXd quadrant = (vidxt.array()*2+0.5).floor();
    vidxt.array() -= (quadrant.array()*0.5);
    vidxt.array() *= 2*3.14159265358979;
    const Eigen::VectorXd sq = vidxt.array()*vidxt.array();

    Eigen::VectorXcd M(vidxt.size());
    M.real() = fastCos2(sq);
    M.imag() = fastSin2(vidxt,sq);
    M = (quadrant.array() == 1).select(-M,M);
    return M;
}

I profiled the code segment in which this function is called using std::chrono and averaged over 500 calls to the function (where each call to the mex function processes all 100,000+ values by calling calcRot2 in a loop. Each iteration passes about 200 values to calcRot2). I find the following average runtimes:
runtime with calcRot2:                   75.4694 ms
runtime with fastSin/Cos commented out:  50.2409 ms
runtime with calcRot2 commented out:     30.2547 ms

Looking at the difference between the two extreme cases, it seems like calcRot has a large contribution to the runtime. However, only a portion of that comes from the sin/cos calculation. I would assume Eigen's implicit vectorization and the compiler would make the runtime of the other operations in the function effectively negligible. (floor shouldn't be a problem!) Where exactly is the performance bottleneck here?
This is the compilation command I'm performing (It uses MinGW64 which I think is the same as gcc):
mex(ipath,'CFLAGS="$CFLAGS -O3 -fno-math-errno -ffast-math -fopenmp -mavx2"','LDFLAGS="$LDFLAGS -fopenmp"','DAS.cpp','DAShelper.cpp')

Reference Code
For reference, here is the code segment in the main mex function where the timer is called, and the helper function that calls calcRot2():
MEX function call:
chk1 = std::chrono::steady_clock::now();
// Calculate beamformed signal at each point
Eigen::MatrixXcd bfVec(p.nPoints,1);
#pragma omp parallel for
for (int i = 0; i < p.nPoints; i++) {
    calcPoint(idxt.col(i),SIG,p,bfVec(i));
}
chk2 = std::chrono::steady_clock::now();
auto diff3 = chk2 - chk1;

calcPoint:
void calcPoint(const Eigen::Ref<const Eigen::VectorXd>& idxt,
               const Eigen::Ref<const Eigen::MatrixXcd>& SIG,
               Parameters& p, std::complex<double>& bfVal) {

Eigen::VectorXcd pRot = calcRot2(idxt*p.fc/p.fs);

int j = 0;
for (auto x : idxt) {
    if(x >= 0) {
        int vIDX = static_cast<int>(x);
        bfVal += (SIG(vIDX,j)*(vIDX + 1 - x) + SIG(vIDX+1,j)*(x - vIDX))*pRot(j);
    }
    j++;
}
}

Clarification
To clarify, the line
(vidxt.array()*2+0.5).floor()

is meant to yield:
0 if vidxt is between [0,0.25]
1 if vidxt is between [0.25,0.75]
2 if vidxt is between [0.75,1]

The idea here is that when vidxt is in the second interval (quadrants 2 and 3 on the unit circle for functions with period 2pi), then the value needs to map to its negative value. Otherwise, the range reduction maps the values to the correct values.

A: The benefits of Eigen's vectorization are outweighed because you evaluate your expressions into temporary vectors. Allocating, deallocating, filling and reading these vectors has cost that seems significant. This is especially so because the expressions themselves are relatively simple (just a few scalar operations).
Expression objects
What usually helps here is aggregating into fewer expressions. For example line 3 and 4 can be collapsed into one:
vidxt.array() = 2*3.14159265358979 * (vidxt.array() - quadrant.array()*0.5);
(BTW: Note that that math.h contains a constant M_PI with pi in double precision).
Beyond that, Eigen expressions can be combined and reused. Something like this:
    auto vidxt0 = idxt.array() - idxt.array().floor();
    auto quadrant = (vidxt0*2+0.5).floor();
    auto vidxt = 2*3.14159265358979 * (vidxt0 - quadrant.array()*0.5);
    auto sq = vidxt.array().square();

    Eigen::VectorXcd M(vidxt.size());
    M.real() = fastCos2(sq);
    M.imag() = fastSin2(vidxt,sq);
    M = (quadrant.array() == 1).select(-M,M);

Note that none of the auto values are vectors. They are expression objects that behave like arrays and can be evaluated into vectors or arrays.
You can pass these on to your fastCos2 and fastSin2 function by declaring them as templates. The typical Eigen pattern would be something like
template<Derived>
void fastCos2(const Eigen::ArrayBase<Derived>& sq);

The idea here is that ultimately, everything compiles into one huge loop that gets executed when you evaluate the expression into a vector or array. If you reference the same sub-expression multiple times, the compiler may be able to eliminate the redundant computations.
Unfortunately, I could not get any better performance out of this particular code, so it is no real help here but it is still something worth exploring in these kind of cases.
fastSin/Cos return value
Speaking of temporary vectors: You didn't include the code for your fastSin/Cos functions but it looks a lot like you return a temporary vector which is then copied into the real and imaginary parts or the actual return value. This is another temporary that you may want to avoid. Something like this:
template<class Derived1, class Derived2>
void fastCos2(const Eigen::MatrixBase<Derived1>& M, const Eigen::MatrixBase<Derived2>& sq)
{
    Eigen::MatrixBase<Derived1>& M_mut = const_cast<Eigen::MatrixBase<Derived1>&>(M);
    M_mut = sq...;
}

fastCos2(M.real(), sq);

Please refer to Eigen's documentation on the topic of function arguments.
The downside of this approach in this particular case is that now the output is not consecutive (real and imaginary parts are interleaved). This may affect vectorization negatively. You may be able to work around this by combining the sin and cos functions into one expression for both. Benchmarking is required.
Using a plain loop
As others have pointed out, using a loop may be easier in this particular case. You noted that this was slower. I have a theory why: You did not specify -DNDEBUG in your compile options. If you don't, all array indices in Eigen vectors are range-checked with an assertion. These cost time and prevent vectorization. If you include this compile flag, I find my code significantly faster than using Eigen expressions.
Alternatively, you can use raw C pointers to the input and output vector. Something like this:
std::ptrdiff_t n = idxt.size();
Eigen::VectorXcd M(n);
const double* iidxt = idxt.data();
std::complex<double>* iM = M.data();
for(std::ptrdiff_t j = 0; j < n; ++j) {
    double ival = iidxt[j];
    double vidxt = ival - std::floor(ival);
    double quadrant = std::floor(vidxt * 2. + 0.5);
    vidxt = (vidxt - quadrant * 0.5) * (2. * 3.14159265358979);
    double sq = vidxt * vidxt;
    // stand-in for sincos
    std::complex<double> jval(sq, vidxt + sq);
    iM[j] = quadrant == 1. ? -jval : jval;
}

Fixed sized arrays
To avoid the cost of memory allocation and make it easier for the compiler to avoid memory operations in the first place, it can help to run the computation on blocks of fixed size. Something like this:

std::ptrdiff_t n = idxt.size();
Eigen::VectorXcd M(n);
std::ptrdiff_t i;
for(i = 0; i + 4 <= n; i += 4) {
    Eigen::Array4d idxt_i = idxt.segment<4>(i);
    ...
    M.segment<4>(i) = ...;
}
if(i + 2 <= n) {
    Eigen::Array2D idxt_i = idxt.segment<2>(i);
    ...
    M.segment<2>(i) = ...;
    i += 2;
}
if(i < n) {
    // last index scalar
}

This kind of stuff needs careful tuning to ensure that vectorized code is generated and there are no unnecessary temporary values on the stack. If you can read assembler, Godbolt is very helpful.
Other remarks

*

*Eigen includes vectorized versions of sin and cos. Have you compared your code to these instead of e.g. Eigen's complex exp function?

*Depending on your math library, there is also an explicit sincos function to compute sine and cosine in one function. It is not vectorized but still saves time on range reduction. You can (usually) access it through std::polar. Try this:
Eigen::VectorXd scale = ...;
Eigen::VectorXd phase = ...;
// M = scale * exp(-2 pi j phase)
Eigen::VectorXd M = scale.binaryExpr(-2. * M_PI * phase,
      [](double s, double p) noexcept -> std::complex<double> {
          return std::polar(s, p);
});

*

*If your goal is an approximation instead of a precise result, shouldn't your first step be to cast to single precision? Maybe after the range reduction to avoid losing too many decimal places. At the very least it will double the work done per clock cycle. Also, regular sine and cosine implementations take less time in float.

Edit

*

*I had to correct myself on the cast to int64 instead of int. There is no vectorized conversion to int64_t until AVX512

*The line (vidxt.array()*2+0.5).floor() bugs me slightly. This is meant to round down to negative infinity for [0, 0.5) and up to positive infinity for [0.5, 1), correct? vidxt is never negative. Therefore this line should be equivalent to (vidxt.array()*2).round(). With AVX2 and -ffast-math that saves one instruction. With SSE2 none of these actually vectorize, as can be seen on Godbolt


text:
Au pair in the Netherlands - work in a Dutch family with English
Au pair Netherlands
Au pair Netherlands - spend a colorful year in the land of tulips
If you want to learn not only one foreign language, but several, there are no obstacle for doing it. We introduce you program Au pair Netherlands - the best way to learn, at least, 2 foreign languages. The official language is Dutch, but almost everyone speaks English here, but there are regions, where one can understand and speak German as well. As a result, taking part in Au-pair Holland program, you have not only the opportunity to receive childcare experience, to discover the Netherlands, to travel within EU-countries, to master English but also to start learning another European language.
Au pair Netherlands Requirements
If your goal is to improve English, we recommend a program in a monolingual country - Au pair USA.
To be Au pair in Holland requires at least intermediate English. Au pair Netherlands documents are provided in your personal account after registration. Host family search begins immediately after reviewing of your uploaded files. Once au pair has spoken with a Dutch host family, the necessary documents are prepared in IND for further applying on an au pair visa to Netherlands in Kyiv. We do the registration process at Netherlands embassy in Kyiv properly, as we are experienced in it (providing services since 2010). After obtaining a visa, prepare for your coming to the Netherlands and being au pair for the duration of 1 year.
300-340 €/month
transfer to Netherlands
Au pair Netherlands duties are to look after and care for children, for which pocket money is paid. In addition, three meals a day and housing are provided free of charge. All au pairs have weekends (at least one per week and also during public holidays) and a two-week paid vacation. Use this time for getting acquainted with the culture of the country, sights and nature.
There are many ancient fortresses, castles and other architectural structures have survived by this day. A distinctive symbol of the Netherlands are windmills, which are presented everywhere. We recommend visiting the Keukenkof, a tulip park that also belongs to the symbols of the country. In the park there are not only millions of tulips themselves, but also numerous carnations, daffodils, hyacinths and other flowers.
Finally, it is worth paying attention to the capital of the country - Amsterdam. Here you can not only visit world-famous museums, but also just wander the streets, see an uncountable number of canals and connecting bridges. We advise those who chose an au pair in Holland to visit an authentic Dutch farm, where you will see how they make exclusive Dutch cheese and how they cut their national shoes - klomps, which can be immediately purchased.
Au pair Netherlands reviews
Au pair in the Netherlands - work in a Dutch family with English Au pair Spain - work with Engish in a Spanish host familyAu pair in Austria - working in an Austrian familyAu pair Australia - working in an Australian familyAu pair Belgium - work in a Belgian family - registrationAu pair program in Denmark - working in a Danish family with childrenAu pair program in Germany - an opportunity to learn GermanAu pair China - work in a Chinese family with EnglishAu pair Norway - work in a Norwegian family with EnglishAu pair USA - work in an American family with childrenAu pair in France - work in a French family with childrenAu pair Switzerland - work in a Swiss family with EnglishAu pair Sweden - work in a Swedish family with knowledge of EnglishAu pair Finland - work in a Finnish family with knowledge of EnglishHow to search and find a host familyOfficial website for finding an Au Pair family abroadVisa au pair definition and type - how to get an au-pair visa Au pair Italy - work in an Italian host family with EnglishAu pair Portugal - work in a Portuguese family with English


It is located in Xianhou Road Pedestrian Street, 15 minutes walk from the seaside. It is not 10 minutes walk from the supermarket. Shopping, shopping and entertainment are very convenient. There are various snacks downstairs. The new house is clean and tidy. It can accommodate up to 8 people. The room is fully equipped and convenient for parking.


text:
Q: Flask-admin display image with path from column I have my DB set like this :
  MediaPath    DateCreated    Message   Type
/home/1/1.jpg   21.09.2017              jpeg
/home/2/2.jpg   ....          ....      ....

How can i set up Flask code to preview images from the MediaPath column without uploading them to /static/ folder?
This is usual flask-admin code template:
class ImageView(sqla.ModelView):
def _list_thumbnail(view, context, model, name):
    if not model.path:
        return ''

    return Markup('' % url_for('static',
                                             filename=form.thumbgen_filename(model.path)))

column_formatters = {
    'path': _list_thumbnail
}

form_extra_fields = {
    'path': form.ImageUploadField('Image',
                                  base_path=file_path,
                                  thumbnail_size=(100, 100, True))
}

A: Is the path for the files in the MeidaPath column their absolute path?
Make sure that the path returned by form.thumbgen_filename(model.path) is the absolute path for the file and you can do the following:
Instead of:
return Markup('' % url_for('static',
    filename=form.thumbgen_filename(model.path)))
Use:
return Markup('' % form.thumbgen_filename(model.path))
** Assuming that the method thumbgen_filename() returns the absolute path to the image thumbnail (you haven't posted the code for that method so I assuming that is what the method returns)**
When you use url_for('static', filename='some-path') it generate a URL that includes the static path and the files that are inside the static folder depending on the value you provide to url_for's filename argument. If want to load your files using their absolute path, just provide their absolute path without using url_for()


text:
package org.lpw.tephra.dao.dialect;

import org.lpw.tephra.bean.BeanFactory;
import org.lpw.tephra.bean.ContextRefreshedListener;
import org.springframework.stereotype.Repository;

import java.util.HashMap;
import java.util.Map;

/**
 * @author lpw
 */
@Repository("tephra.dao.dialect.factory")
public class DialectFactoryImpl implements DialectFactory, ContextRefreshedListener {
    protected Map<String, Dialect> dialects;

    @Override
    public Dialect get(String name) {
        return dialects.get(name);
    }

    @Override
    public int getContextRefreshedSort() {
        return 2;
    }

    @Override
    public void onContextRefreshed() {
        dialects = new HashMap<>();
        BeanFactory.getBeans(Dialect.class).forEach(dialect -> dialects.put(dialect.getName(), dialect));
    }
}


Terrific Broth is rich nutritional medium developed by Tartoff and Hobbs supporting luxurious high density growth of E.coli and a higher yield of plasmid DNA compared to LB type media. Recombinant E. coli cells have an extended growth phase in Terrific medium.
Terrific medium is used with glycerol as a carbon source. Unlike glucose, glycerol is not fermented to acetic acid.
Tryptone and Yeast are present in the medium in elevated concentrations and provide nitrogen, vitamins and cofactors for a luxurious growth.
Potassium phosphate is present in Terrific broth buffered to balance the pH and subsequently prevent cell death due to a drop in pH.
Tartoff, K. D., and C. A. Hobbs, Improved media for growing plasmids and cosmid clones, Bethesda Research Laboratories, 9, 12, (1987).
Sambrook, J,., E. F. Fritsch, and T. Maniatis, 1989, Molecular cloning: a laboratory manual, 2nd edition ed., Cold Spring Harbour laboratory, Cold Spring Harbour, N.Y.