38284 postfrisch (never hinged) ** 1960s, FRENCH AFRICA, comprehensive u/m accumulation of various countries, sorted in glassines, comprising many attractive issues, thematic sets, airmails etc.
38286 Brief (cover) Ansichtskarte (Picture postcard) Over 140 Zeppelin postcards, mostly Real Photos with the largest part pioneer airships, with the Schuette Lanz, Z2, Z5, M1, ZIII, Schwaben, 1909 Luftschiffhalle construction, crashes, Kaiser Wilhelm II visiting Manzell, passengers on board, etc., and also several from the Graf Zeppelin. Many private and unpublished. An impossible to duplicate assembly of early German air travel.
38288 Brief (cover) 1962, 24 Nov, 123rd Zucker Rocket Flight, holding of 65 cards with three different cachets each, 43 pieces with signature of Zucker and of Nebel, 22 pieces with signature of Nebel.
38289 Brief (cover) 1962, 24 Nov, 124th Zucker Rocket Flight, holding of 91 cards with three different cachets each, 64 pieces with signature of Zucker and of Nebel, 27 pieces with signature of Nebel.
38291 ungebraucht ohne Gummi (unused without gum) (*) 1963, 30th Anniversary of Zucker Rocket Flights, group of four commemorative cards (in green, light blue, brown and orange-red), holding of apprx. 280 pieces each (=apprx. 1.120 pieces in total), some with signature.
38292 postfrisch (never hinged) ** 1963, 30th Anniversary of Zucker Rocket Flights, holding of 300 vignettes on gummed paper.
38294 Brief (cover) 1963, 31 Aug, 130th Zucker Rocket Flight, holding of nearly 200 flight covers bearing two vignettes (on front and on reverse), flight cachet and signature.
38295 Brief (cover) 1964, 10 Apr, Nebel Rocket Flight, holding of apprx. 300 cards with two cachets and signature each.
38296 Brief (cover) 1964, 12 Apr, Nebel Rocket Flight, holding of apprx. 530 cards with three cachets each.
38298 gestempelt (marked) 1964, 70th Birthday of Rudolf Nebel, coloured vignette on gummed paper and with two cachets each, holding of apprx. 600 pieces.
38299 postfrisch (never hinged) ** 1964, 70th Birthday of Rudolf Nebel, coloured vignette on gummed paper, holding of apprx. 310 pieces.
38300 Ansichtskarte (Picture postcard) Brief (cover) Collection of over 100 Zeppelin items, around 70 flown covers and 33 Schuette Lanz original construction photos from the factory archives (rare!). Flights include mostly Bordpost usages from both the Graf and the Hindenburg, often on airship Echt Foto / RPPCs. All original and in top condition virtually throughout.
38301 Ansichtskarte (Picture postcard) Brief (cover) Collection of over 120 Zeppelin items with dozens of flown covers including Saar, Iceland, Argentina,Paraguay, and Liechtenstein, as well as many of the better Rhein Main semi-official cards like the Princes children in Cossack uniform, Frankenstein, Otzberg, etc. Filled out with many pioneer-era picture postcards, Hindenburg color interiors, etc. All period and original.
38302 Ansichtskarte (Picture postcard) Brief (cover) Over 140 Zeppelin postcards, mostly Real Photos with the largest part pioneer airships, with the Schuette Lanz, Z2, Z5, M1, ZIII, Schwaben, 1909 Luftschiffhalle construction, crashes, Kaiser Wilhelm II visiting Manzell, passengers on board, etc., and also several from the Graf Zeppelin. Many private and unpublished. An impossible to duplicate assembly of early German air travel.
38303 Ansichtskarte (Picture postcard) Brief (cover) Amazing group of ca. 178 Zeppelin postcards mostly Echt Fotos from the pioneer period including the Viktoria Luise, Z1, ZII, ZIII , ZIV, LII, Parseval, Schwaben, Viktoria Luise, Hansa over Goslar, crew photos, crashes, Baden Oos, some WWI Feldpost, etc with private cards, unpublished views; mint and used, all original. Another unique collection impossible to replicate today.
38304 Ansichtskarte (Picture postcard) Brief (cover) Ca 185 Zeppelin postcards and a few photos, with a large number of pieces from the pioneer period, including LZ4, LZ6, Schwaben, ZI, ZIII, Baden-Oos, Dresden-Kaditz Luftschiffhalle, etc with private cards, Real Photos; mint and used, all original.
38306 Brief (cover) Collection of 71 Zeppelin cards and covers, ca 60 flown + several Hindenburg color interior postcards and related leaflets. Mostly German with many Rhein Main Schwaben flights on Duke of Hessen's family postcards (with better cities and uses) , as well as foreign from USA, Russia, Brazil, Austria and the Netherlands. Also many Bordpost on airship Echt Foto / RPPCs. Overall a very find group.
38307 Brief (cover) Collection of 84 Zeppelin covers, all different, in uniformly excellent condition. Mostly German with many Bordpost on Echt Foto / RPPCs, as well as foreign from Chile, Brazil, and Paraguay.
38308 Ansichtskarte (Picture postcard) Brief (cover) Over two hundred Zeppelin flights, original private photographs, real photo postcards, and WWI airmen Feldpost. Majority relate to pioneering Zeppelin airships, for example: many Schuette Lanz, WWI Marine airships (L49,L31,L12,L10, etc), Parseval, Deutschland, Potsdam Luftschiffehalle, Viktoria Luise, Crashes, and the Graf von Zeppelin, with unpublished views. Also Bordpost, including RPPC's from the Graf's Balkan Flight, Wiesbaden pioneers, Amerikafaht, Orientfahrt, etc. A remarkable assembly impossible to recreate.
38309 Brief (cover) Ansichtskarte (Picture postcard) Collection of over 110 Zeppelin items, mostly flown covers with a large number of good Bordpost usages on airship Echt Foto / RPPCs as well as many foreign flown usages from Liechtenstein, Netherlands, Brazil, Argentina, and Spain, filled out wih a few pioneer era postcards. A very clean and desirable lot with little to no duplication for a new collection or resale.
38314 Faszinierender Spaziergang durch die Geschichte des Buchdruckes, von den Anfängen mit Gutenberg bis hin zur modernsten Drucktechnik, belegt mit Marken, Ganzsachen, Ansichtskarten, Fotos und auch viel nicht philatelistischem Dokumentations-Material wie Bücher und andere Druckerzeugnisse aus verschiedenen Epochen, moderater Ansatz.
38316 30 Plakate bzw. Poster zum Thema bzw. aus dem Bereich Werbung und Politik.


Location: The hotel is situated only 100 m. away from the beach and at the very beginning of the art alley.
Accommodation: "Malibu" is a completely renovated 4/5 floor building with 3 sectors and 4 lifts.The hotel has a capacity of 298 beds in 152 double and single rooms. There is a satellite TV in every room, telephone, mini – bar, WC, balcony. As an additional service guests can use a fridge and safe.
Restaurant, lobby bar, outdoor swimming pool, children's playground, and parking. There is a personal safe at the reception. Nearby the hotel there are 2 tennis courts, mini golf, and bicycles for rent.


Rye (Meadowdale Riot) was flying the Meadowdale flag at Leeds Championship Show on Friday 22nd July 2011.
German Shorthaired Pointers at this show.
Delighted with my entry, such a shame some dogs were 'docked and denide' I do hope this rules changes in time.
Delighted that 'Banjo' wins the minor puppy dog class at his first championship show.
National Gundog is a lovely show, with super outdoor rings - lots to distract a mischievious puppy!!!!
16th July 2011, I head off to the Southern ESS Society Open Show with Banjo & Chaos.
Banjo delighted me by winning the class, with Chaos hot on his heels in 2nd place.
Bless him - he was only 6 months old on the day!
Today is the 8th July 2011, and it is also the first show that 'Meadowdale Chaos' is able to attend, as he is only 6 months old today!
What a wonderful day we had. He won Minor Puppy Dog, and then had to challenge the Puppy Dog winner. Delighted when he was declared 'Best Puppy Dog' What a wonderful start to his showing.
To the left is 'Meadowdale Riot', better know at Rye, who owned and loved by Sue.
Behaving himself and wagging his tail all day - what a superstar.


The highly anticipated wedding of Prince Henry and Meghan Markle will begin at noon London time on Saturday, May 19, 2018. If you are planning a viewing party for the Royal Wedding, grab the free party printables kit we have shared from thepurplepumpkinblog.co.uk at the bottom of this post. It is a wonderful set with party circles, food labels, cupcake wrappers, mini-flags, cocktail flags, favor bag toppers, buntings, popcorn boxes, and subway art.
In Hawaii (HST)- Saturday at 1 a.m.
In Los Angeles, Las Vegas, Seattle, Phoenix, Vancouver (PDT)- 4 a.m.
In Calgary and Denver (MDT)- 5 a.m.
In Chicago, Dallas, Mexicao City (CDT)- 6 a.m.
In New York City, Washington, D.C., Miami, Montreal, Toronto, Lima, San Juan (EDT)- 7 a.m.
In Buenos Aires, Sao Paulo- 8 a.m.
In Morocco, Western Sahara, Iceland, Greenland- 11 a.m.
In Rome, Paris, Barcelona, Berlin, Stockholm, Cape Town and Cairo- 1 p.m.
In Jerusalem, Moscow, Athens- 2 p.m.
In Armenia, Georgia- 3 p.m.
In New Delhi, Mumbai- 4:30 p.m.
In Hong Kong, Manila, Taipei, Beijing, Perth- 7 p.m.
In Tokyo, Seoul- 8 p.m.
In Sydney, Melbourne- 9 p.m.
Instructions: Click on the file, download, print, cut, embellish with string, popsicle sticks, as needed.


After seeing snow showers on Tuesday, we start Wednesday morning at just 18.5°. The last time it was this cold was back on February 17th. That is a span of 9 months or 270 days. For those of you wondering where this morning's low compares, the record for this date is 15°, which occurred back in 1920. A record that has stood for 93 years.
I do expect us to go up to the mid 40's today (44°) for the high temperature under sunny skies. It'll feel warmer due to the sunshine and light winds. We will have another cold night across the region and expect lows to drop to the middle 20's. For Thursday, we'll repeat today's forecast with sunny skies but add about 11° to the forecasted high as we'll hit 55°.
Clouds return on Friday with a high near 60° and rain is expected for the weekend with only a slight chance on Saturday and a better chance on Sunday.


text:
Storyful & Weber Shandwick Launch Cognitive Context, a Content Intelligence Service for Marketers and Corporate Communicators
-- Partnership Combines Data-driven Content Insights with Strategic Planning Expertise to Enhance Brand & Social Media Campaigns, and Help Marketers Mitigate Risk --
Apr 25, 2017, 09:00 ET
NEW YORK, April 25, 2017 /PRNewswire/ -- Storyful, the leader in discovering, validating and acquiring social video for global media organizations, and Weber Shandwick, a leading global communications and engagement agency, have partnered to develop Cognitive Context, a digital content intelligence service. As part of the joint effort, Weber Shandwick clients will have the opportunity to gain access to pre-viral social media content that is surfaced by Storyful with the same speed and accuracy that it has been delivering to leading newsrooms, including Buzzfeed, The Wall Street Journal, The New York Times, Vice and others. Storyful's content-mining technology and insights from its global team of former journalists combined with Weber Shandwick's expertise in content strategy and communications will provide marketers and communicators with a new solution for fine-tuning social strategy, managing risk and informing content programs. The companies are also co-developing a custom reporting module that will make it easier for marketers to take action after receiving Storyful data and insights, exclusive to Weber Shandwick clients.
"Social media has fundamentally redefined how news, marketing and communications professional do their job and how audiences consume content. For the last seven years, Storyful has built the technology and expertise that modern storytellers have come to rely on to report the news, create innovative advertising solutions and mitigate risk in real-time. Our global team of journalists process billions of data points a day to find the insights and content that drive strategy and content creation for our partners. Weber Shandwick's global scale and innovative approach to communications makes them an ideal partner to harness our capabilities and expand our best-in-class solutions to organizations and brands around the world," said Rahul Chopra, CEO of Storyful.
"The rules of marketing and PR today favor those willing to continually understand how trending content surfaces, who is behind it and how that impacts news and social media conversations – it's all interconnected," said Chris Perry, Chief Digital Officer, Weber Shandwick. "This unique partnership with Storyful will arm us with the insights that make our planning, content creation and integrated media programs even stronger."
Storyful's unparalled access to and insights behind billions of social posts complement Weber Shandwick's already robust planning and data/analytics capabilities, expanding the data pool to derive intelligence for clients. In addition to informing campaigns and communications programs, this partnership will help organizations more rapidly adapt to the evolution of consumer interaction with news and branded content.
About Storyful
Storyful, a division of News Corp (NASDAQ:NWS, NWSA; ASX:NWS, NWSLV), is the world leader in discovering, verifying and acquiring the compelling and relevant user-generated video our partners need to tell stories that matter to their audiences. Storyful combines world class journalism with industry-leading technology to discover, verify and acquire the original content and provide the on-the-ground sources news and media organizations need to tell the stories that matter to their audience.
About Weber Shandwick
Weber Shandwick is a leading global communications and engagement firm in 79 cities across 34 countries, with a network extending to 127 cities in 81 countries. The firm's diverse team of strategists, analysts, producers, designers, developers and campaign activators has won the most prestigious awards in the world for innovative, creative approaches and impactful work. Weber Shandwick was the only public relations agency included on the Ad Age Agency A-list in 2014 and 2015 and the only PR firm designated an A-List Agency Standout in 2017. Weber Shandwick was honored as PRWeek's Global Agency of the Year in 2015 and 2016, The Holmes Report's Global Agency of the Year in 2010, 2012, 2014 and 2015 and The Holmes Report's Global Digital Agency of the Year in 2016. The firm deploys deep expertise across sectors and specialty areas, including consumer marketing, corporate reputation, healthcare, technology, public affairs, financial services, corporate social responsibility, financial communications and crisis management, using proprietary social, digital and analytics methodologies. Weber Shandwick is part of the Interpublic Group (NYSE: IPG). For more information, visit http://www.webershandwick.com.
Mike Hess
SOURCE Weber Shandwick
http://webershandwick.com

redpajama_set_name: RedPajamaCommonCrawl


Thanks for the advise.  I agree with you on all counts.  However, the computer I am working with can't be updated… it's a older Mac Mini (2004).  All I've read says 10.6.8 is the latest OS it can support.
>    dispatch "revUnloadLibrary" to stack "tsNetLibURL"
> unpatched OS is too dangerous to have connected to the Internet.
> for Apple's old versions.


text:
Halloween Makes an Early Appearance at Merkin Concert Hall
Last night at Merkin Concert Hall was a gleefully fun and surprisingly nuanced concert of Halloweenish orchestral works that transcended being pigeonholed as such. Sure, it was impossible not be drawn into the fun as conductor/composer Charles Coleman scrunched his face into a triumphant, "yessssss!" expression as he signaled a series of macabre, pulsing tritones from the violins as the world premiere of his symphonic poem Carmilla for String Orchestra got underway. But there was plenty of subtlety and sophistication that tends to get trampled in this kind of music: while there was an abundance of menace on the program, it never really went over the edge into grand guignol.
Anchored by heavy washes of bass and cello, the piece quickly shifted into more plaintively neoromantic territory before hitting a hypnotic, rhythmically minimalist coda that wouldn't have been out of place in the Julia Wolfe catalog. The full orchestra followed with William Maselli's deliciously fun Visions of Sabbath, a mashup of classic Black Sabbath themes. How familiar the ensemble members were with the source material became obvious in an instant, from who was dealing with it like any other task, and who couldn't resist a grin. One of the bassists and a violist in particular were having a ball with the artful interweave of motives: the signature chromatic theme that opens the band's first album; riffs galore from Electric Funeral and War Pigs,and a playfully blustery arrangement of the verse from Iron Man, to name a few. And when they reached the point where one of the clarinets voiced a couple of Ozzy lines from The Wizard, pretty much everybody was cracking up. "This initial effort may well be expanded on in the future," the program notes hinted. Bring it on!
The final work was Maselli's two-act opera Draculette. It's a highly thought out piece of music, and it was well executed. Bloodily surreal as the storyline is, there was less bombast than expected. Maselli's main themes developed out of a cinematic progression of the utmost simplicity that rose and fell with a Moussorgsky-esque unease, punctuated by several more bittersweet interludes, a couple veering into lively, carefree Italianate operatic territory, others with a vividly anthemic art-song quality that reminded of Elvis Costello at his most ornate. Did Maselli immerse himself in a Prokofiev opera before tackling this? That wouldn't be a surprise.
Coloratura soprano Olga Zhuravel sang the lead role, holding the center with a fang-baring luridness. High soprano Micaela Oeste got less time in the spotlight but made the most of it: one particular spine-tingling, stratospheric, chromatic phrase of hers was worth the price of admission alone. The guys – baritones Brad Cresswell and Kevin Glavin, and tenor John Bellemer – were given goofier roles and thus less opportunity to explore as much emotional terrain as the women. Which made sense considering the storyline: unsympathetic characters are easier to kill off. In the spaces between, brief solos made their way cleverly and purposefully throughout the orchestra: Tomina Parvanova's harp, BJ Karpen's oboe and Allyson Clare's viola in particular were standouts. Meanwhile, a series of microphones hung overhead: if the engineers soundchecked this right, the orchestra and singers got a dandy live recording out of it.
October 5, 2014 Posted by delarue | classical music, concert, Live Events, Music, music, concert, New York City, review, Reviews, rock music	| 21st century music, art-rock, avant-garde music, brad cresswell, charles coleman composer, charles coleman review, classical music, classical rock, concert, concert review, gothic music, heavy metal, indie classical, instrumental rock, john bellemer singer, kevin glavin singer, metal music, micaela oeste, micaela oeste review, Music, music review, new music, olga zhuravel, olga zhuravel review, opera, orchestral music, orchestrated rock, rock music, symphonic music, symphonic rock, william maselli composer, william maselli draculette, william maselli draculette review, william masselli review | Leave a comment
Intense Paradigm-Shifting Sounds from Salim Ghazi Saeedi
One important rising composer who's doing genuinely visionary work in microtonal music, helping to integrate sounds from the Middle East into jazz and rock, is Tehran-based multi-instrumentalist Salim Ghazi Saeedi. His latest album namoWoman is an often otherworldly creation. It's considerably more raw and roughhewn than, say, recent albums by David Fiuczynski and Hafez Modirzadeh, both artists to which he compares favorably. Aside from the fact that Saeedi plays all the instruments on the album – guitars, keys, basses and drums – what's most amazing about it is how through-composed it is. Thematic variations recur frequently but always change shape, melodically and dynamically. It's a dark, bracing, uneasy roller-coaster ride.
Saeedi's main axe is the guitar, which he multitracks using two basic tones: a ringing, watery timbre that he typically uses to deliver plaintive, judiciously picked microtonal phrases and ringing sustained lines, along with a gritty, crunchy, distorted tone that often takes centerstage with a sneering, occasionally comedic flair. That tone, and its bombastic allusions and head-on assaults, poses the question of whether this is heavy metal, or jazz, or Persian art-rock. Ultimately, the answer is all of the above.
Saeedi's unorthodox use of both piano and bass is also extremely clever. Saeedi leans heavily on the piano's lowest keys, whether to anchor the music in a murky, overtone-spiced ambience, or for basslines. By contrast, Saeedi utilizes the bass's entire sonic spectrum, frequently bowing eerily elegant viola melodies in the upper registers. A few of the tracks have trebly-toned, judiciously played electric bass along with the occasional electronic keyboard motif. All this contrasts with the savage, distorted guitar lines: whether or not that dichotomy is deliberate or not (two sides of the same coin, maybe, one profound and the other profane?), it's inescapable.
Throughout the nine-part suite, Saeedi establishes individual voices within the arrangements, with all kinds of melodic interweaving and conversations: piano ripples respond to bass bubbles, cello-flavored lines hand off to the guitar, or to the drums. Without knowing it, you wouldn't necessarily guess that guitar is Saeedi's primary axe, considering how graceful, dexterous and propulsive his bass work is; his piano lines are terse, imaginative and serve an important part of the musical backbone. If there's any criticism of this, it's that Saeedi swings on the guitar and especially the bass but not the drums: a percussionist with a proficiency equal to Saeedi's on those two instruments could have been useful here. Then again, percussionists capable of playing such eclectic compositions are hard to find anywhere, let alone in traditional Persian music.
Bluesy allusions give way to suspenseful not-quite-minor, not-exactly major Persian intervals; rhythms tend to be straight-up but not always, one interlude bouncing along on a tricky groove that would be perfectly at home in Macedonia or Greece. Pensive, moody guitar echoes until it's bludgeoned out of the picture as the distorted roar takes over, and then recedes, a constant game of good cop vs. bad cop with an occasional exchange of roles. There's simple, insistent staccato guitar riffage straight out of the Pantera playbook, and also spacious, distantly anguished David Gilmour-inflected phrasing. The High Romantic, the gothic, the gypsy and the jazz – think Cecil Taylor in extreme deep space mode – mingle and echo and at their most cohesive, haunt the hell out of you. Little flourishes like a jaunty melodica vamp, hints of surf rock and Mediterranean psychedelia lighten the darkness while enhancing the surrealism of it all. Who is the audience for this? Middle Eastern metalheads; fans of Persian music who need a jolt of energy, and any fan of loud, dark sounds laced with fearless humor. There is no one in the world who sounds anything like Salim Ghazi Saeedi: where he takes these ideas in the future promises to be a pretty wild place.
January 10, 2013 Posted by delarue | jazz, middle eastern music, Music, review, Reviews, rock music	| album review, art-rock, classical rock, heavy metal, iranian music, jazz rock, metal music, metal rock, middle eastern jazz, middle eastern music, Music, music review, orchestrated rock, persian music, prog rock, progressive rock, rock music, Salim Ghazi Saeedi, Salim Ghazi Saeedi namowoman, Salim Ghazi Saeedi namowoman review, Salim Ghazi Saeedi review, symphonic rock, world music | Leave a comment
Album of the Day 10/9/11
As we do pretty much every day, our 1000 best albums of all time countdown continues all the way to #1. Sunday's album was #479:
Flower Travellin' Band – Satori
This one's for the smoking section. By the time these Japanese stoners came out with this sludgy, creepy 1971 five-part suite, they were arguably heavier than Sabbath. Some of you may find this ugly and heavyhanded; the band alternates between bludgeoning blues and morbid, funereal dirges. The lyrics are in Japanese. Part one of the suite sets the stage for the slightly more Hendrix-inspired part two. Part three might be the high point, doom rock with Asian motifs; part four blends funk and even jazz touches into the murk; the concluding movement foreshadows where King Crimson would be in five years. Call it metal, or art-rock, or proto-goth, either way it's pretty amazing. Here's a random torrent via Lysergia.
October 11, 2011 Posted by delarue | lists, Music, music, concert, rock music	| acid rock, art-rock, best albums, best albums all time, best albums alltime, best albums ever, best albums list, best albums lucid culture, best music, best music ever, best obscure albums, best obscure albums all time, best obscure albums alltime, best obscure albums ever, best rock albums, best rock albums all time, best rock albums alltime, best rock albums ever, best underrated albums, flower marching band, flower marching band satori, flower traveling band, flower traveling band satori, flower travellin band, flower travelling band satori, greatest albums all time, greatest albums alltime, greatest albums ever, greatest obscure albums, greatest rock albums all time, greatest rock albums alltime, greatest rock albums ever, heavy metal, metal music, most underrated albums, most underrated albums all time, Music, prog rock, progressive rock, proto metal, psychedelia, psychedelic music, psychedelic rock, stoner metal, stoner music, top albums all time, top albums alltime, top albums ever | Leave a comment
Album of the Day 9/6/11
Every day, pretty much that is, our 1000 best albums of all time countdown continues all the way to #1. Tuesday's album is #511:
Led Zeppelin – Physical Graffiti
At the risk of losing our entire subscriber base, here's something that might be kind of obvious to some of you and completely offensive to the rest (don't worry, we'll be back with more obscure stuff momentarily). In order to "get" Led Zep, you have to remember that they were a bunch of hippies, consequently, they didn't take themselves all that seriously (especially the goofball singer). Ironically, this is the one place where they reached for epic grandeur and actually nailed it, particularly on the magnificently arranged, utterly chilling Ten Years Gone and the eleven-minute bluesmetal epic In My Time of Dying. The rest of this sprawling 1974 double album is eclectic to the extreme: woozy stoner metal like Custard Pie, Sick Again (a prototype for AC/DC) and the tongue-in-cheek prog-rock Houses of the Holy; In the Light, with its almost nine-minute, twisted Indian vibe that the Beatles reached for but never quite achieved; Trampled Under Foot, which sounds like Stevie Wonder gone metal; the delicate instrumental Bron-Yr-Aur; the gentle, bucolic Down by the Seaside; the completely sick funk-metal of The Wanton Song; The Rover, a midtempo riff-rocker; Night Flight, a 1971 shot at a pop hit with swirling organ; an amusing Beggars Banquet-era Stones ripoff, a jam with the Stones' keyboardist, and, oh yeah, that song from Fast Times at Ridgemont High. Here's a random torrent.
September 6, 2011 Posted by delarue | lists, Music, music, concert, rock music	| albums ever, best albums ever, best albums list, best albums lucid culture, best music ever, best obscure albums, best obscure albums all time, best obscure albums alltime, best obscure albums ever, best rock albums, best rock albums all time, best rock albums alltime, best underrated albums, greatest albums all time, greatest albums alltime, greatest albums ever, greatest obscure albums, greatest rock albums all time, greatest rock albums alltime, greatest rock albums ever, heavy metal, led zeppelin, led zeppelin physical graffiti, metal music, most underrated albums, most underrated albums all time, top albums all time, top albums alltime, top albums ever | Leave a comment
This coming weekend is our last blowout of the year. We realize that all the time we've spent on the road this year, coupled with starting a brand-new blog to catch some of the spillover from this one, would take its toll on our daily coverage for awhile, and we apologize. More of the usual reviews and concerts coming next week. Til then, every day, pretty much that is, our 1000 best albums of all time countdown continues all the way to #1. Saturday's album is #514:
Motorhead – No Sleep Til Hammersmith
How does Motorhead manage to sound so titanic with only one guitarist? Lemmy's wall-of-sound bass chords. He plays bass like a guitarist, which enables whoever's on guitar – in this case, Fast Eddie Clarke, in his last stint in the classic original lineup – to take off and go way, way out into the bluesmetal ionosphere as much as he wants. This raw, cheaply produced but intensely adrenalinized 1981 live set – which went to #1 on the British charts – includes the longer anthems like Capricorn and Bomber that the band was beginning to introduce alongside their more punk numbers like their signature song, Stay Clean (what a joke that title is), The Hammer, Overkill and of course Ace of Spades. The best track is actually a mammoth version of We Are the Road Crew, the irresistibly catchy tribute to the guys who lug all the gear and never get any credit; the band also tackle a cover of Born to Lose and actually avoid embarrassing themselves. Why'd we choose this one? Only because everybody else seems to choose Ace of Spades. Here's a random torrent.
September 2, 2011 Posted by delarue | lists, Music, music, concert, rock music	| best albums, best albums all time, best albums alltime, best albums ever, best albums list, best albums lucid culture, best music, best music ever, best obscure albums, best obscure albums all time, best obscure albums alltime, best obscure albums ever, best rock albums, best rock albums all time, best rock albums alltime, best rock albums ever, best underrated albums, blues metal, fast eddie clarke, greatest albums all time, greatest albums alltime, greatest albums ever, greatest obscure albums, greatest rock albums all time, greatest rock albums alltime, greatest rock albums ever, heavy metal, lemmy, lemmy kilmister, metal music, most underrated albums, most underrated albums all time, Motorhead, motorhead no sleep til hammersmith, Music, punk metal, punk rock, top albums all time, top albums alltime, top albums ever | Leave a comment
Album of the Day 8/31/11
Getting closer to where we should be, every day, as our 1000 best albums of all time countdown continues all the way to #1. Wednesday's album was #517:
Iron Maiden – Live After Death
"Scream for me Long Beach!" Bruce Dickinson howls again and again. By the time the standard bearers of the new wave of British heavy metal (NWOBHM for short) made this double vinyl monstrosity in 1985, they were a well-oiled machine in the midst of a tour that would take them around the world more than once in over a year. It's basically their greatest hits live done by the classic lineup with the two-guitar attack of Dave Murray and Adrian Smith, with the unsurpassed, nimble rhythm section of bass god Steve Harris and Nicko McBain on drums. Every facet of the band is represented: the pounding, punkish Aces High, Die with Your Boots On, Running Free and 22 Acacia Ave.; the artsy, classically-flavored epics Rime of the Ancient Mariner, Powerslave and Phantom of the Opera (no relation to the musical); and catchy, anthemic classics including Run to the Hills, 2 Minutes to Midnight and of course The Number of the Beast. Tuneful, melodic and intelligent, this band transcends any metal stereotype. Don't confuse these guys with another great British band called Iron Maiden, a proto-metal group from the late 60s/early 70s. Here's a random torrent.
September 1, 2011 Posted by delarue | lists, Music, music, concert, rock music	| adrian smith, best albums, best albums all time, best albums alltime, best albums ever, best albums list, best albums lucid culture, best music, best music ever, best obscure albums, best obscure albums all time, best obscure albums alltime, best obscure albums ever, best rock albums, best rock albums all time, best rock albums alltime, best rock albums ever, best underrated albums, dave murray, greatest albums all time, greatest albums alltime, greatest albums ever, greatest obscure albums, greatest rock albums all time, greatest rock albums alltime, greatest rock albums ever, heavy metal, iron maiden, iron maiden band, iron maiden live after death, metal music, most underrated albums, most underrated albums all time, Music, new wave british heavy metal, nicko mcbain, nwobhm, psychedelia, psychedelic music, psychedelic rock, steve harris, stoner music, top albums all time, top albums alltime, top albums ever | 2 Comments
Every day, our 1000 best albums of all time countdown continues all the way to #1. Monday's album was #526:
The JPT Scare Band – Past Is Prologue
Legendary in the midwest, the Kansas City power trio of drummer Jeff Littrell, bassist Paul Grigsby and guitarist Terry Swope recorded most of this between 1973 and 1975. While none of these tracks were officially released until 2001, the band was a cult favorite of the "cassette underground" for years. The opening track here, Burn In Hell, a forest of tense, flanged minor chords, was actually recorded that year and shows that the band was keeping up with the times. But it's the old stuff that's the most riveting: Sleeping Sickness, practically fourteen minutes of virtuoso Texas blues with metal flourishes, ten years before Stevie Ray Vaughan mastered the art; the wildly Hendrix-inspired proto-noiserock of I've Been Waiting and Time to Cry (which clocks in at a modest 12:59); Jerry's Blues, which sounds a lot more like Jimi than the Dead; and the riff-rocking psychedelia of Titan's Sirens. Recently reunited, the band played their first show in thirty years earlier this summer and are reputedly as scary as ever. Most of the tracks are streaming at myspace (without ads, happily); here's a random torrent via Cavites Pride. The album, along with the equally good, bizarrely titled Acid Blues Is the White Man's Burden, is also still available from Ripple Music.
August 23, 2011 Posted by delarue | lists, Music, music, concert, rock music	| best albums, best albums all time, best albums alltime, best albums ever, best albums list, best albums lucid culture, best music, best music ever, best obscure albums, best obscure albums all time, best obscure albums alltime, best obscure albums ever, best rock albums, best rock albums all time, best rock albums alltime, best rock albums ever, best underrated albums, greatest albums all time, greatest albums alltime, greatest albums ever, greatest obscure albums, greatest rock albums all time, greatest rock albums alltime, greatest rock albums ever, hard rock, heavy metal, jeff littrell, jpt scare band, metal music, most underrated albums, most underrated albums all time, Music, paul grigsby, power trio, proto metal, psychedelia, psychedelic music, psychedelic rock, terry swope, top albums all time, top albums alltime, top albums ever | Leave a comment
Ripple Music's First Anniversary Free Sampler – Get It While You Can
In this age of independent music, do we really need labels at all? If you want to sell more than downloads and unload physical product in a country where you don't live, or probably won't be visiting soon, a label can be useful. And good branding never hurts – Norton does garage rock; Tzadik does every shade of klezmer and sometimes the Middle East; and Ripple Music have carved themselves a niche as purveyors of tasty, retro 70s stoner rock. Considering how much great stuff these guys have put out over the last year, the answer's yes, these guys actually fill a need, unlike the parasitic corporate labels.
Ripple Music went for cred right off the bat by signing Poobah, whose 1972 proto-metal classic Let Me In they reissued last year. And they wasted no time scoring midwestern acid rock cult favorites the JPT Scare Band, who just played their first gig in 35 years if you can believe it. In this age where virtually everything audible online is free, and most commercial radio stations won't go near good original music, how does a label stay in business? Like a drug dealer. They turn you on to their product for free and then let you decide, heh heh. Their freebie right now is a first anniversary sampler available for free at their bandcamp site, featuring bands whose material they've released or reissued, often on vinyl as well as digitally, in the past year, along with previews of a couple of upcoming releases. It's a cool mixtape for 7-11 parking lots.
As usual with this kind of stuff, the more fun the bands let themselves have, the better the music is (which applies to pretty much any style when you think about it). "70s rock preservationists" Stone Axe are a mighty good choice to open the album with Riders of the Night, a period-perfect, LOL Spinal Tap party scenario. They're "busy blowing smoke rings around the midnight sun," and the guitars do the same. Surprisingly, Mighty High, Brooklyn's funniest self-described regressive rock act don't go as hard for the comedy as they usually do, although their track, Don't Panic – It's Organic, is smoking. Imagine it's 1973, Blue Oyster Cult is trying to channel Chuck Berry and kicking out the best guitar solos on the entire compilation, evil chromatic Deniz Tek style.
The JPT Scare Band's contribution, It's a Jungle, really is a time trip. It has the feel of a vinyl rip – that sidewinding, trebly, melodic bass and those Spooky Tooth metalfunk hooks are killer. And is that a qanun (Arabic hammered dulcimer) slapping the lo-fi synth upside the head? Surprisingly, Poobah is represented by one of the less ferocious tracks from Let Me In, although this one shows off the rhythm section: it's not just Jim Gustafson guitar pyrotechnics. But Venomin James' Bullet Juice delivers buckets of evil via a delicious Sabbath-style chromatic riff and a razorwire wah solo that leaves you wanting more. And Mos Generator's moonshine-running anthem Stone County Line injects fresh blood into a bunch of hallowed 70s moves, with some blunt instrument Bill Ward-ish drums.
There are a couple of ringers here. Modern Day Moonshine offer a soulfully shuffling update on the Grateful Dead's Cumberland Blues, while Bay Area songwriter Kevin Beadles' Sharkskin sounds like a metal spoof done as bluesy, swinging, late 70s Rhodes piano pop. It wouldn't be out of place on a Tubes album. There's also Tripdavon's By the River, which merges southern slide guitar rock and blues overtones; riff-heavy Scottish band Iron Claw, which would fit in fine with the Nazareth catalog; and Vancouver band Fen's Queen of the Mountain, pensive and apprehensive with lots of dynamic shifts – these guys sound like they used to listen to grunge but left it behind. There are a couple of duds, but what do you expect for nothing? Get it while it's still available.
July 26, 2011 Posted by delarue | Music, music, concert, review, Reviews, rock music	| 70s rock, acid rock, fen band, fen band vancouver, free download, free mp3, heavy metal, iron claw band, jpt scare band, kevin beadles, metal bands, metal music, metal rock, mighty high band, modern day moonshine, mos generator, poobah band, psychedelia, psychedelic music, psychedelic rock, ripple music, ripple music compilation, ripple music first anniversary sampler, ripple music free sampler, ripple music mixtape, seventies rock, stone axe band, stoner music, tripdavon, venomin james | 4 Comments
Two Cool Singles from Fun, Entertaining Brooklyn Bands
Spanking Charlene have a brand-new version of Dismissed with a Kiss – the title track to their deliciously fun album – just out on Little Steven Van Zandt's label Wicked Cool. How cool is that? The pay-radio conglomerate SiriusXM ran a yearlong "best unsigned band contest," which we had no idea existed. And Spanking Charlene won! Imagine that. When is the last time a band that didn't suck actually won some kind of contest? Maybe never? And as you can hear from the single (at the band's reverbnation), it's a lot of fun. We're partial to the Eric Ambel-produced original because it's on the album, one of the first ones we ever got in the mail back when we started the blog in 2007, but this is killer. Charlene McPherson's wounded wail is as seductive as ever and Mo Goldner's guitars roar and sizzle. They've got a new album due out this fall, titled Where Are the Freaks which is something to look forward to, ostensibly a blast from a much cooler East Village NYC past.
Strange Haze also have a new single out, Let Me Hear the Dropping Pin, available at cdbaby both as a download AND on purple vinyl, which we obviously recommend. It's as hilarious as pretty much everything the Brooklyn stoner retro-metal band has ever come up with. It's kind of a three-minute history of weedhead music from, say, 1964 to 1974. A fuzztone funk intro and classic garage riffage sets the stage for the woozy one-liners, which begin with "I don't have nothing to do today, but I got all day to do it, so I got to get away." The rest are just as good, or…at least as surreal. The band has the oldschool, rolling, kinda funky early 70s groove down cold and some musical jokes to go with the lyrical ones, and of course a guitar solo. It might sound like an insult to say the higher you are, the more fun this is, but that's the point.
May 10, 2011 Posted by delarue | Music, music, concert, review, Reviews, rock music	| americana punk, best bands brooklyn, best bands new york, best bands nyc, charlene mcpherson, comedy music, garage punk, garage rock, heavy metal, joke band, joke music, little steven, metal music, mo goldner, Music, musical comedy, novelty song, parody band, proto metal, psychedelia, psychedelic music, psychedelic rock, punk rock, rock music, Spanking Charlene, spanking charlene dismissed with a kiss, stoner metal, stoner music, stoner rock, strange haze, strange haze band, strange haze let me hear the dropping pin, strange haze review, xmsirius best unsigned band, xmsirius best unsigned band winner | Leave a comment
Pitom Shreds With Ominous Majesty
Guitarist Yoshie Fruchter's band Pitom's new instrumental album Blasphemy and Other Serious Crimes, just out on Tzadik, blends Israeli stoner metal with surf music, gothic rock and ancient Hasidic ngunim. Ostensibly a reflection on Yom Kippur, if there's anything to atone for here, it should be for not making the album longer – and it is a long one to begin with. Here bassist Shanir Blumenkranz (also of Pharaoh's Daughter) serves as their Lemmy, propelling much of this with a roaring chordal attack, alongside Jeremy Brown on violin and Kevin Zubek on drums. Fruchter has an individual and impressively tasteful style for a genre where florid is the norm: he roars, squalls and skronks but also cuts his chords up into juicy pieces that he offers up like a lion tamer determined to get the best out of the beast. The melodies bristle and wail, charged with eerie chromatics and Middle Eastern tonalities along with the metal riffage and slowly careening psychedelic licks.
The first song is a flamenco-tinged stomp with guitar that ranges from theremin-ish to Dick Dale-ish, set to a pounding Nine Inch Nails beat. After that, they deliver a sludgy bulldozer waltz driven by distorted bass chords and an apprehensive violin solo, Fruchter screaming in wildly to ambush Brown's stately lines. The third track is a Maidenesque, chromatic gallop with scrapy violin/guitar textures and a watery, dambuster Leslie speaker guitar solo. With slyly growling twin guitars over a gritty bass groove, the fourth track builds to a genuinely anguished crescendo, Blumenkranz wailing with a dirty, distorted tone over Fruchter's clanging, echoey, menacing chordal fragments.
Motorhead goes to a Jewish wedding and dances in 14/4 through a pungent cloud of guitar/violin smoke on the fifth cut; the sixth is a creepy, low-key spiderwalk. The seventh starts out with a gorgeously plaintive klezmer melody that grows menacing, then hits a grand guignol interlude straight out of early Queen, then back to the menace again. Track eight amps the rustic, wounded beauty higher, with a slow Peter Gunn-style interlude and variations. On the next cut, a frantic Balkan chase scene collapses and gets all Sonic Youth before reassembling and scurrying off again – and then they hit a noisy bridge with an early 70s style bluesmetal solo peeking out from behind the gnashing and thrashing. They close with another klezmer melody, this one done as 80s psychedelic rock a la the the Raybeats or Slickee Boys, and the majestic concluding cut featuring alternatingly intense guitar and violin solos over the murk beneath. Fans of intelligent, artsy metal bands from Junius to Iron Maiden will love this stuff. Pitom play the cd release show for this one at Rock Shop in Gowanus on Monday May 2 at 9 or so with the excellent, eclectic Gutbucket opening at 8. The bands are also bringing food for everybody.
April 28, 2011 Posted by delarue | Music, music, concert, review, Reviews, rock music	| art-metal, heavy metal, instrumental metal, instrumental music, instrumental rock, iron maiden, israeli metal, jeremy brown violin, jewish music, junius band, kevin zubek, klezmer, klezmer music, klezmer punk, klezmer rock, middle eastern rock, Motorhead, pharaoh's daughter band, pitom, pitom band, pitom blasphemy and other serious crimes, pitom blasphemy and other serious crimes review, psychedelic music, psychedelic rock, queen band, raybeats, shanir blumenkranz, Slickee Boys, stoner metal, stoner music, surf music, tzadik records, yoshie fruchter | Leave a comment


text:
Q: How to hierarchical query in PostgreSQL with language-dependent data I am trying to retrieve a hierarchical ordered result from a query on an auto referenced table like this:
create table category (
  id          serial,

  -- parent category,
  parent_id   integer default null, -- null for root category

  -- tree control
  tree_depth  smallint not null, -- calculated

  primary key (id),
  unique (parent_id, id),
  foreign key (parent_id) references category (id)
);

This is a common approach to store a tree of categories except for the need for supporting multiple languages. To that aim, we join a language-dependent table like this:
create table category_lang (
  id            serial,

  -- natural primary key
  category_id   integer not null,
  lang_code     char(2) not null,

  -- language-dependent data
  title         varchar(128) not null,

  primary key (id),
  unique (category_id, lang_code)
);

The tree_depth column is calculated in a before insert trigger like this:
create or replace function fn_category__bins () returns trigger as $$
begin
  -- calculate tree_depth as parent tree_depth + 1
  if new.parent_id is null then
    new.tree_depth = 0;
  else
    new.tree_depth = (select tree_depth from category where id = new.parent_id limit 1) + 1;
  end if;

  return new;
end;
$$ language plpgsql;

create trigger tg_category__bins before insert on category for each row
execute procedure fn_category__bins();

We populate the tables with easy to read texts in two languages:
insert into category (parent_id, id) values
(null, 1),
(null, 2),
(null, 3),

(1, 11),
(1, 12),
(1, 13),

(2, 21),
(2, 22),
(3, 31),

(21, 211),
(21, 212),
(21, 213);

-- lang_code = 'EN'
insert into category_lang (category_id, title, lang_code) values
(1, 'One',   'EN'),
(2, 'Two',   'EN'),
(3, 'Three', 'EN'),

(11, 'One.One',   'EN'),
(12, 'One.Two',   'EN'),
(13, 'One.Three', 'EN'),

(21, 'Two.One',   'EN'),
(22, 'Two.Two',   'EN'),
(31, 'Three.One', 'EN'),

(211, 'Two.One.One',   'EN'),
(212, 'Two.One.Two',   'EN'),
(213, 'Two.One.Three', 'EN');

-- lang_code = 'ES'
insert into category_lang (category_id, title, lang_code) values
(1, 'Uno',  'ES'),
(2, 'Dos',  'ES'),
(3, 'Tres', 'ES'),

(11, 'Uno.Uno',  'ES'),
(12, 'Uno.Dos',  'ES'),
(13, 'Uno.Tres', 'ES'),

(21, 'Dos.Uno',  'ES'),
(22, 'Dos.Dos',  'ES'),
(31, 'Tres.Uno', 'ES'),

(211, 'Dos.Uno.Uno',  'ES'),
(212, 'Dos.Uno.Dos',  'ES'),
(213, 'Dos.Uno.Tres', 'ES');

A plain query produces a natural result like this:
select * from category tc
left outer join category_lang tl on tl.category_id = tc.id and tl.lang_code = 'EN';

id |parent_id|tree_depth|id|category_id|lang_code|title        |
---|---------|----------|--|-----------|---------|-------------|
  1|         |         0| 1|          1|EN       |One          |
  2|         |         0| 2|          2|EN       |Two          |
  3|         |         0| 3|          3|EN       |Three        |
 11|        1|         1| 4|         11|EN       |One.One      |
 12|        1|         1| 5|         12|EN       |One.Two      |
 13|        1|         1| 6|         13|EN       |One.Three    |
 21|        2|         1| 7|         21|EN       |Two.One      |
 22|        2|         1| 8|         22|EN       |Two.Two      |
 31|        3|         1| 9|         31|EN       |Three.One    |
211|       21|         2|10|        211|EN       |Two.One.One  |
212|       21|         2|11|        212|EN       |Two.One.Two  |
213|       21|         2|12|        213|EN       |Two.One.Three|

when the expected order should be compliant with tree hierarchy and alphabetical order in English (at every depth level), like this:
[Edited to fix the error identified by Erwin]
id |parent_id|tree_depth|id|category_id|lang_code|title        |
---|---------|----------|--|-----------|---------|-------------|
  1|         |         0| 1|          1|EN       |One          |
 11|        1|         1| 4|         11|EN       |One.One      |
 13|        1|         1| 6|         13|EN       |One.Three    |
 12|        1|         1| 5|         12|EN       |One.Two      |
  3|         |         0| 3|          3|EN       |Three        |
 31|        3|         1| 9|         31|EN       |Three.One    |
  2|         |         0| 2|          2|EN       |Two          |
 21|        2|         1| 7|         21|EN       |Two.One      |
211|       21|         2|10|        211|EN       |Two.One.One  |
213|       21|         2|12|        213|EN       |Two.One.Three|
212|       21|         2|11|        212|EN       |Two.One.Two  |
 22|        2|         1| 8|         22|EN       |Two.Two      |

Note that the alphabetical order at every depth forces a different result for Spanish:
[Edited to fix the error identified by Erwin]
id |parent_id|tree_depth|id|category_id|lang_code|title       |
---|---------|----------|--|-----------|---------|------------|
  2|         |         0|14|          2|ES       |Dos         |
 22|        2|         1|20|         22|ES       |Dos.Dos     |
 21|        2|         1|19|         21|ES       |Dos.Uno     |
212|       21|         2|23|        212|ES       |Dos.Uno.Dos |
213|       21|         2|24|        213|ES       |Dos.Uno.Tres|
211|       21|         2|22|        211|ES       |Dos.Uno.Uno |
  1|         |         0|13|          1|ES       |Uno         |
 12|        1|         1|17|         12|ES       |Uno.Dos     |
 13|        1|         1|18|         13|ES       |Uno.Tres    |
 11|        1|         1|16|         11|ES       |Uno.Uno     |
  3|         |         0|15|          3|ES       |Tres        |
 31|        3|         1|21|         31|ES       |Tres.Uno    |

I have tried a number of approaches, including a recursive CTE as in https://www.postgresql.org/docs/12/queries-with.html, but none seems to cope with the problem of different orders for different languages.
Any ideas?

A:
... the expected order should be compliant with tree hierarchy and alphabetical order in English (at every depth level),

The additional difficulty is that category_lang(title, lang_code) is not defined UNIQUE, so we need to sort by title and category_id (as tiebreaker) on every level - which is hard to implement for a dynamic number of levels. An array of composite type can solve the conundrum.
Your displayed results do not currently comply with your requirement. 'Three' should sort before 'Two' according to English sorting rules. The result of the following query implements your requirement:
Create once per database:
CREATE TYPE title_id AS (title varchar(128), id int);

Then use a recursive CTE to generate an array of this composite type according to its path.
WITH RECURSIVE tree AS (
   SELECT c.id AS cat_id, c.parent_id, c.tree_depth
        , l.id AS lang_id, l.title, l.lang_code
        , ARRAY[(l.title, l.category_id)::title_id] AS sort_arr
   FROM   category      c
   JOIN   category_lang l ON l.category_id = c.id
                         AND l.lang_code = 'EN'
   WHERE  c.parent_id IS NULL  -- root cat

   UNION ALL
   SELECT c.id AS cat_id, c.parent_id, c.tree_depth
        , l.id AS lang_id, l.title, l.lang_code
        , sort_arr || (l.title, l.category_id)::title_id
   FROM   tree          t
   JOIN   category      c ON c.parent_id = t.cat_id
   JOIN   category_lang l ON l.category_id = c.id
                         AND l.lang_code = t.lang_code
    )
SELECT cat_id, parent_id, tree_depth, lang_id, title
FROM   tree
ORDER  BY sort_arr;

db<>fiddle here
Closely related with more explanation and details:

*

*Retrieving full hierarchy sorted by a column under PostgreSQL's Ltree module
COLLATE?
But that's not all. The simple solution sorts by the default collation of your database, which seems inappropriate for different languages.
Every language has its own collation rules, or typically several of them, depending on the region of the world and other political / cultural rules. The "language" is not enough to specify exact rules for sorting. The precise locale matters. Postgres implements collation-aware sorting with the COLLATE keyword. You would have to store the actual precise collation in addition to the language, and use it to sort properly.
Also, indexes depend on the exact COLLATION. You might consider multiple partial indexes with different collation. Lots of tricky stuff that goes beyond the scope of this question. See:

*

*How to choose a collation for international database?

*PostgreSQL 9.1 using collate in select statements
Asides

*

*Your trigger is not safe against race conditions between concurrent writes. For the purpose of this query we do not need a persisted tree_depth at all. We could easily generate it in the rCTE. Consider dropping the column tree_depth and the trigger.

*A FK constraint seems to be missing in table category_lang:
 , FOREIGN KEY (category_id) REFERENCES category (id)

*Consider text instead of varchar(n) and char(n). See:

*

*Any downsides of using data type "text" for storing strings?

*Should I add an arbitrary length limit to VARCHAR columns?

*Consider an IDENTITY column instead of serial:

*

*Auto increment table column

A: Before Erwin answered with a much simpler solution, I made this recursive approach by myself. It works better inserting a virtual root category, which allow us to retrive the whole tree from a single entry point.
create or replace function list_category_tree (
    _category_id integer,
    _lang_code char(2)
)
returns setof category
as $$
declare
    _child_category category;
begin
    -- return the passed category
    return query
    select * from category where id = _category_id;

    -- loop over the passed category children
    for _child_category in
        select tc.*
        from category tc
        join category_lang tl on tl.category_id = tc.id and tl.lang_code = _lang_code
        where tc.parent_id = _category_id
        order by tl.title asc
    loop
        -- recursively look for every children childrens
        return query
        select * from list_category_tree(_child_category.id, _lang_code);
    end loop;
end;
$$ language plpgsql;

A simple test could be
select *
from list_category_tree (0, 'EN') as tc
join category_lang tl on tl.category_id = tc.id and tl.lang_code = 'EN';

id |parent_id|tree_depth|id|category_id|lang_code|title        |
---|---------|----------|--|-----------|---------|-------------|
  1|         |         0| 1|          1|EN       |One          |
 11|        1|         1| 4|         11|EN       |One.One      |
 13|        1|         1| 6|         13|EN       |One.Three    |
 12|        1|         1| 5|         12|EN       |One.Two      |
  2|         |         0| 2|          2|EN       |Two          |
 21|        2|         1| 7|         21|EN       |Two.One      |
211|       21|         2|10|        211|EN       |Two.One.One  |
213|       21|         2|12|        213|EN       |Two.One.Three|
212|       21|         2|11|        212|EN       |Two.One.Two  |
 22|        2|         1| 8|         22|EN       |Two.Two      |
  3|         |         0| 3|          3|EN       |Three        |
 31|        3|         1| 9|         31|EN       |Three.One    |

select *
from list_category_tree (0, 'ES') as tc
join of_category_lang tl on tl.category_id = tc.id and tl.lang_code = 'ES';

id |parent_id|tree_depth|id|category_id|lang_code|title       |
---|---------|----------|--|-----------|---------|------------|
  2|        0|         1|14|          2|ES       |Dos         |
 22|        2|         2|20|         22|ES       |Dos.Dos     |
 21|        2|         2|19|         21|ES       |Dos.Uno     |
212|       21|         3|23|        212|ES       |Dos.Uno.Dos |
213|       21|         3|24|        213|ES       |Dos.Uno.Tres|
211|       21|         3|22|        211|ES       |Dos.Uno.Uno |
  3|        0|         1|15|          3|ES       |Tres        |
 31|        3|         2|21|         31|ES       |Tres.Uno    |
  1|        0|         1|13|          1|ES       |Uno         |
 12|        1|         2|17|         12|ES       |Uno.Dos     |
 13|        1|         2|18|         13|ES       |Uno.Tres    |
 11|        1|         2|16|         11|ES       |Uno.Uno     |

having inserted the root node as
insert into of_category (parent_id, id) values
(null, 0),

(null, 1),
(null, 2),
(null, 3),

(1, 11),
(1, 12),
(1, 13),

(2, 21),
(2, 22),
(3, 31),

(21, 211),
(21, 212),
(21, 213);

-- lang_code = 'EN'
insert into of_category_lang (category_id, title, lang_code) values
(0, 'Root', 'EN'),

(1, 'One',   'EN'),
(2, 'Two',   'EN'),
(3, 'Three', 'EN'),

(11, 'One.One',   'EN'),
(12, 'One.Two',   'EN'),
(13, 'One.Three', 'EN'),

(21, 'Two.One',   'EN'),
(22, 'Two.Two',   'EN'),
(31, 'Three.One', 'EN'),

(211, 'Two.One.One',   'EN'),
(212, 'Two.One.Two',   'EN'),
(213, 'Two.One.Three', 'EN');

-- lang_code = 'ES'
insert into of_category_lang (category_id, title, lang_code) values
(0, 'Raíz', 'ES'),

(1, 'Uno',  'ES'),
(2, 'Dos',  'ES'),
(3, 'Tres', 'ES'),

(11, 'Uno.Uno',  'ES'),
(12, 'Uno.Dos',  'ES'),
(13, 'Uno.Tres', 'ES'),

(21, 'Dos.Uno',  'ES'),
(22, 'Dos.Dos',  'ES'),
(31, 'Tres.Uno', 'ES'),

(211, 'Dos.Uno.Uno',  'ES'),
(212, 'Dos.Uno.Dos',  'ES'),
(213, 'Dos.Uno.Tres', 'ES');

redpajama_set_name: RedPajamaStackExchange


text:
The Ayacucho Municipality is one of the 29 municipalities that makes up the western Venezuelan state of Táchira and, according to a 2007 population estimate by the National Institute of Statistics of Venezuela, the municipality has a population of 60,454.  The town of Colón is the municipal seat of the Ayacucho Municipality.

Demographics
The Ayacucho Municipality, according to a 2007 population estimate by the National Institute of Statistics of Venezuela, has a population of 60,454 (up from 50,992 in 2000).  This amounts to 5.1% of the state's population.  The municipality's population density is .

Government
The mayor of the Ayacucho Municipality is Gabino Paz Guerrero, re-elected on October 31, 2004, with 47% of the vote.  The municipality is divided into three parishes; Ayacucho, Rivas Berti, San Pedro del Río.

References

External links
ayacucho-tachira.gob.ve

Municipalities of Táchira

redpajama_set_name: RedPajamaWikipedia


text:
Watch the Routines That Just Won Two Choreographers Emmy Awards
Courtney Escoyne
No, you didn't miss the Emmy Awards telecast. (It's next weekend.) The Creative Arts Emmys, on the other hand, were awarded yesterday, including the Emmy Award for Outstanding Choreography. Among the nominees were "Dancing With the Stars" favorite Derek Hough, "So You Think You Can Dance?" contestant-turned-choreographer Travis Wall, surprise contender Fred Tallaksen for comedy "The Real O'Neals" and commercial dance juggernaut Mandy Moore, who grabbed two nominations for both "DWTS" and "SYTYCD."
And in a delightful twist, there was a tie in the voting for this juried category, meaning not one, but two of these choreographers went home with a statuette: first time winner Mandy Moore (for "DWTS") and Travis Wall, who previously won in 2015. Moore was nominated specifically for her group routines "On Top of the World" and "Carol of the Bells," while Wall was recognized for two duets ("The Mirror" and "She Used to be Mine") and a group routine ("Send in the Clowns").
Are we surprised? Not really. Moore has had a breakout year, propelled in part by the critical and commercial success of La La Land, and Wall has been making beautiful (if occasionally controversial) short pieces for "SYTYCD" for years. Check out their winning routines below, and join us in wishing them both a hearty congrats!
Mandy Moore: "On Top of the World"
Mandy Moore: "Carol of the Bells"
Travis Wall: "The Mirror"
Travis Wall: "Send in the Clowns"
Travis Wall: "She Used to be Mine"
dancing with the stars dwts emmy awards emmys mandy moore so you think you can dance sytycd travis wall
Lloyd Knight Illuminates the Stage at Graham and Beyond
Marina Harss
Performing a Balancing Act, Dutch National Ballet Principal Maia Makhateli Juggles Motherhood and Dance
Wei Wang on Being the First Chinese Male Principal at San Francisco Ballet
Wei Wang
More Dancer Spotlight


In this lesson, your tutor will help you go over question two from the TOEFL speaking test. Read the question below out loud with the tutor.
Is it better to get news from newspapers and magazines, or is it better to get news from television? Use specific reasons and examples to support your preference.
Choose a question at random from the list below. Answer the question right away without making notes. Try to speak for at least 10 seconds.
Which types of news stories do you like to read about? I like reading world news, Korean news and technology news.
What is one advantage of newspapers and magazines?
What is one advantage of television news?
Use the following pointers as a guideline to refine your answer.
Reading Newspapers and Magazines: It is much better to get news from newspapers and magazines.
Reading great sample answers is one way to improve. Go over the sample answer with your tutor. Ask questions if you have any.
Reading Newspapers and Magazines: In my opinion, it is much better to get news from newspapers and magazines. One reason is their greater detail. Most newspaper and magazine articles have a lot of specific information. This allows me to understand news stories better. Another reason I prefer newspapers and magazines is their variety. Newspapers and magazines cover many different kinds of stories. These include world news, economic news and even video games. Considering this, I would much rather get news from newspapers and magazines.
Watching Television: I prefer to watch television for my news for two reasons. First, television news lets me actually see news stories. News reporters can go live on the scene of breaking news stories. They interview people for news events and film them as they happen. I also enjoy watching the news on television because it saves time. Television news covers the day's news in just a few minutes. Even though newspapers and magazines have their advantages, I prefer watching television for my news.
coverage (n) the activity of reporting about an event or subject in newspapers, on television news programs, etc.
e.g. The issue is not getting much coverage in the mainstream press.
e.g. Suddenly the program was interrupted and went live to the White House for the announcement that the president had died.
e.g. CNN's broadcast switched to breaking news about the presidential election results.
e.g. She liked to read the gossip column in People magazine.
article (n) a piece of writing about a particular subject that is included in a magazine, newspaper, etc.
e.g. I just read an interesting article about San Francisco's early history.
e.g. The paper published an editorial strongly criticizing the mayor's actions.
e.g. The newscaster gave a live report on the election results in California.
e.g. The advertisement will appear in three magazines.
e.g. Calvin and Hobbes is my favorite comic strip.


"Wrexham has been identified as one of the fastest-moving markets" – The Independent.
Clearly, Wrexham is a desirable place to live. The numbers speak for themselves. People are moving here and property values are increasing. The Council has identified that at least 8,525 homes are needed in the next 15 years to cope with demand in the area. Demand is coming from first-time buyers, growing families and those looking to downsize.
As such, the plans for land south of Holt Road will deliver up to 600 new homes to meet this demand and respond to local housing needs. Our vision builds on this identified local need and an ambition to deliver a local community that Wrexham can be proud of.
The vision for new homes in Wrexham is being brought forward by Barratt Homes and Bloor Homes North West. This partnership brings together expertise and a track record for delivering new, high-quality homes across the UK. With two developers set to deliver these homes, the development will be designed to complement and enhance the existing community.
Delivering the ambitious economic growth that Wrexham and North Wales wants to achieve needs new homes. Our plans compliment the plans of the Borough.
Your feedback and views will inform our plans. Our proposals, therefore, will be built on the views of the local community. We want to know your opinion and how you think the proposals should take shape for existing and future residents.
Our plans include open spaces, public footpaths and links to the cycle network. Our proposals are designed to help people be active and stay active; encouraging people to rely less on cars where possible.
Modern, in-keeping designs built to the highest standards. Our proposals will help Wrexham prepare for the future, delivering the new homes needed to drive Wrexham forward.


text:
Teachers could be allowed to use 'reasonable force' in behaviour crackdown
Press Association Reporter
Published: 08:24 Wednesday 28 August 2019
Ministers could be preparing a crackdown on bad behaviour in schools with teachers to be allowed to use "reasonable force" and urged to confiscate mobile phones, according to a report.
The Guardian reported on Tuesday that it had seen a briefing document from the Department for Education, dated August 22 and marked "Official-Sensitive", which included a slew of controversial new measures for schools, including harsher rules for tackling unruly pupils and cuts to the number of teaching assistants.
The proposals will be spearheaded by a £3.5 billion funding announcement and plans to increase teachers' basic pay to £30,000 by 2022.
But also set to grab headlines will be suggested plans for more stringent rules to help schools in the fight against ill-discipline.
Confiscating mobile phones, same-day detentions and even the use of reasonable force were measures said to be outlined in the briefing note, with headteachers to be given further powers when it comes to suspending and expelling disruptive children and youths.
Cuts to support staff could also be forthcoming, with the number of teaching assistants set to be reduced if the details of the report are correct. Further free schools could also be rolled out, along with a fresh push to convert local authority grant-maintained schools to academies.
The DfE said it did not recognise the "figures" reported by the Guardian and said priorities for the new Secretary of State, Gavin Williamson, would be announced "in due course".
According to the report, the DfE paper includes a major focus on poor behaviour in schools.
"This government backs headteachers to improve behaviour and will support them to create safe and disciplined school environments," the document is said to state.
"We will back heads to use powers to promote good behaviour including sanctions and rewards; using reasonable force; to search and confiscate items from pupils (including mobile phones); impose same-day detentions; suspend and expel pupils; ban mobile phones."
The headline figure for the £3.5bn funding boost is broken down into an additional £2.8bn for primary and secondary schools up to the age of 16, including £800m for children with special educational needs and disabilities (SEND). The details for an extra £800m for sixth form and further education colleges are still under discussion with the Treasury, according to the Guardian.
Last year, the Institute for Fiscal Studies estimated per-pupil funding had been cut by 4% in real terms since 2015, after a freeze was imposed by the Government. It estimated returning school funding to 2015 levels would require nearly £2bn.
The leaked paper was also said to contain evidence that Downing Street and the DfE had calculated that there are too many teaching assistants (TAs) working in the education system.
Kirkham Grammar School flute player joins National Youth Orchestra
"No 10 and HMT (the Treasury) have been keen to publicly express concerns about the rising number of TAs and set out Government's commitment to more effective deployment of TAs being integral to more efficient use of school spend," it states.
The document, according to the newspaper, advises against going public with the possibility of TA cuts, warning "it would undermine the 'hearts and minds' aspect of the announcement with the numerous audiences we know value TAs - parents, teachers, heads and (the) SEND lobby".
"This needs to be handled very sensitively if we are to protect the positivity of the announcement," the leaked note says.
Shadow education secretary Angela Rayner called the alleged details of the briefing "concerning".
She said: "Time after time Boris Johnson has backed Tory cuts to school budgets that created the crisis in our classrooms, while slashing taxes for the richest.
"Johnson shows no sign of taking the action needed to undo that damage, and isn't even proposing to reverse the Conservatives' cuts to schools since 2010.
"It is concerning that this leaked document shows senior Tories casting doubt on the value of teaching assistants and suggesting that more cuts are on the way, despite the vital work they do, such as supporting children with special education needs.
"The next Labour government will fully reverse Tory cuts to our schools, increasing per pupil funding in real terms and offering a real-terms pay rise to both teachers and support staff."
A DfE spokeswoman said: "We do not comment on leaks. We will announce further information on our domestic priorities in due course."


Beloved Final Fantasy creature Moogle makes its appearance as super-sized rectangular cushion! With a good amount of elasticity, it has a great feel, so you can keep it as a cuddle buddy or use it as a decorative accent in your room!
If you are familiar with Final Fantasy Square Cushion: Moogle, why not let others know?
the price for Final Fantasy Square Cushion: Moogle drops.
Final Fantasy Square Cushion: Moogle is available.
there are new images or links available for Final Fantasy Square Cushion: Moogle.


text:
Q: Google Compute RHEL Instance - Peer cert cannot be verified I am trying to undertake a yum upgrade on one of my servers and I am getting this error:
Could not retrieve mirrorlist https://cds.rhel.updates.googlecloud.com/pulp/mirror//client/rhel6/x86_64 error was
14: Peer cert cannot be verified or peer cert invalid
I've looked across the internet and the common answer is turn SSL off however this doesn't work either.
https://cds.rhel.updates.googlecloud.com/pulp/repos/client/rhel6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
Trying other mirror.
To address this issue please refer to the below knowledge base article
https://access.redhat.com/articles/1320623
If above article doesn't help to resolve this issue please open a ticket with Red Hat Support.
Has anyone else been experiencing this? What have I been doing wrong?
Thanks in advance for any help that you can provide,
Sam

A: This question was answered the google issue tracker at this URL: https://issuetracker.google.com/issues/67348923


Probate Publications is the Internet's best resource for finding the latest probate filings in San Francisco and the Peninsula. Unlike other websites, our staff gathers and organizes this data on a daily basis. Our goal is to provide you with the most accurate reflection of the current probate market in a simple, no-nonsense manner. Our cancel-anytime membership package allows you to find what you need for as long (or short) as you'd like.
We pride ourselves on our website's intuitive friendly and professional approach to the process of researching and marketing for probate properties.


text:
Der Engelbert-Brunnen war ein Brunnen in der Innenstadt von Bochum an der heutigen Kortumstraße Ecke Brüderstraße. Mit seiner Brunnenstatue erinnerte er an Graf Engelbert von der Mark, der die Grafschaft Mark von 1346 bis 1391 regierte, und der Legend nach das Maiabendfest stiftete. Heute ist noch eine Statue als Denkmal erhalten, die nach Restaurierungsarbeiten im Gerberviertel ihren heutigen Standort an der Großen Beckstraße, Ecke Untere Marktstraße vor der Propsteikirche erhielt. Die Enthüllung der Statue war am 4. Juli 2020.

Geschichte

Der ursprüngliche Brunnen wurde Anfang August 1910 im Rahmen des Schützenfestes eingeweiht. Die vom Bochumer Bildhauer Markus Wollner geschaffene Skulptur stand auf einer achteckigen Granitsäule mit vier Wasserspeiern. Die Staute wurde in den frühen 1940er im Zweiten Weltkrieg zusammen mit dem Kuhhirten und dem Soldatendenkmal aus Gerthe eingeschmolzen.

Der neue Brunnen mit einer neu angefertigten Statue wurde 1964 von Ferdinand Spindel entworfen und 29. April 1964 eingeweiht. Unter dem Brunnen wurde 1979 ein U-Bahnhof eröffnet, der ursprünglich nach dem Brunnen benannt war und heute U-Bahnhof Bermuda3eck/Musikforum heißt. Der Brunnen, gegenüber einem Supermarkt gelegen, war ein beliebter Treffpunkt für Punks.

Ein am Standort angedachter, neuer, von der Stadtverwaltung bereits gekaufter Brunnen, hätte mit einem 120-Tonnen-Kran aufgebaut werden sollen, was die Statik des U-Bahn-Tunnels aber nicht ausgehalten hätte. Dieser Brunnen steht nun am Ende der Kortumstraße auf dem Konrad-Adenauer-Platz.

Die Statue wurde im Rahmen von Straßenbauarbeiten und zugunsten der Außengastronomie an den Straßenrand Kerkwege versetzt. Damit war die Statue ohne Brunnen, stand aber wieder fast am Standpunkt des ersten Brunnens. Über eine weiter Verlegung wurde länger diskutiert; ein Vorschlag war, sie an den Ort der ehemaligen Altstadt zu versetzen. In der Nähe des Standpunktes war früher die Beckporte, eines der Stadttore. Durch dieses müssen die Maischützen dem Brauch zur Folge mit den Baum durchziehen. Das Tor wird seit 2013 durch zwei Metallplatten symbolisch dargestellt. Die Statue wurde im Bermudadreieck Anfang 2020 komplett abgebaut. Nach einer Restaurierung wurde sie dann an der Ecke Große Beckstraße / Untere Marktstraße, in der Nähe der symbolischen Beckporte, wieder aufgestellt. Die Aufstellung, die im April stattfinden sollte, hatte sich wegen Corona verschoben.

Siehe auch
 Liste von Brunnen in Bochum

Einzelnachweise

Brunnen in Nordrhein-Westfalen
Abgegangenes Bauwerk in Bochum
Skulptur (1910)
Zerstört im Zweiten Weltkrieg
Zerstört in den 1940er Jahren
Replik
Personendenkmal (Herrscher)
Skulptur (Bochum)
Bronzeskulptur in Nordrhein-Westfalen
Gedenkbrunnen


When retrofitting with MS-Tech, you have two main options for your retrofits. This page goes over the differences between each option, and the benefits to each.
Regardless of which option you choose, MS-Tech is committed to having your machine running with our CNC controls, making good parts. We have a solution for everybody – we can customize our controls and services to meet your needs.
Flexible installation – Work on your own schedule.
Responsive support – Receive prompt support and guidance from our team. Never worry about what comes next if you get stuck.
On-site support available – On-site assistance can be ordered at any step of the process, or for final tuning and training. When buying our CNC control retrofit kit, you can be confident and assured in knowing that there's only one final result: your machine installed with our control, making your part.
With this option, you will receive the hardware and software necessary to replace your old CNC control. We will provide detailed installation manuals and notes, and our team will support you throughout the retrofit.
We recommend this option for installation by engineers or technicians with a good background in electrical wiring and machine maintenance.
With this option, you will receive the hardware and software necessary to replace your old CNC control, as well as our professional installation service. We will ship the parts to your facility and send our engineers to do the retrofit – they can travel almost anywhere in the world.
We recommend this option for customers who have an urgent need for new controls.
Customers can choose between using existing motors and drives, or purchasing new ones from MS-Tech. MS-Tech has developed technologies to make either choice an easy fit with our CNC control systems.
For many of our customers, keeping the existing motors and drives is a way to save more money. We have developed additional adapter boards, which make it easy to use your existing servo drives and motors with our control. MS-Tech's CNC control solution is one of the only in the world which allows connections to existing motors and drives.
MS-Tech works with partnered manufacturers to make MS-Tech branded motors and drives, which have been used in thousands of machines across the world. They are reliable, powerful, and unbeatable in price. Our motor and drive sets are exclusively available to our control customers at a discounted price, making them the single most cost-effective option for high quality motors and drives. If you have a better price for motors and drives, we'll beat it.


text:
Home > Solutions > Scientists > Roduner
Emil Roduner is a physical chemist at University of Stuttgart and the University of Pretoria, South Africa. His colleague Tjaart Krüger is a physicist at the University of Pretoria. They have recently written a paper on the origin of irreversibility. They were kind enough to cite my 2014 paper on the origin of irreversibility, which I located in quantum events that happen at indeterministic times and move in indeterministic directions, such as the emission and absorption of photons, as discovered by Albert Einstein in 1916.
Their latest work on irreversibility asks whether "memory" can be considered a new parameter for the physical state of matter? They write...
Most elementary theories describing processes of matter, like Newtonian dynamics and quantum mechanics, are symmetric with respect to time-reversal, but thermodynamics is not and describes processes that come to rest at equilibrium. A long-standing dispute is represented by the question: "How can microscopic equations of motion that are symmetric to time reversal give rise to macroscopic behavior that clearly does not share this symmetry?" The answer is commonly sought in size, with small systems being time-reversible and large systems not. It turns out that this is not correct. Time-reversibility and thermodynamic reversibility are two different issues. Thermodynamic equilibria are well-defined in terms of entropy or free energy and are reached in processes described by the "arrow of time". But the process of equilibration can be either reversible or irreversible with respect to time, independent of the system size. There is a second criterion, the system's memory of a previous state, which does not contribute to thermodynamic parameters. Time-reversible processes are deterministic, and if the past is understood, the future can be predicted. What destroys time-reversibility are non-Newtonian processes, mostly of probabilistic nature, like the decay of excited states.
In my analysis of the creation of information structures in the universe, I have shown that the reduced local entropy (so-called "negative entropy") of such structures requires that an amount of positive entropy equal to or greater than the negative entropy must be carried away from the structure, or the new pocket of negative entropy (also information) will not survive.
For example, in the early years after the origin of the universe, atoms were repeatedly being formed from protons combining with electrons. But the temperatures were so high and the radiation field so intense, that photons (some emitted by electrons as they fell into bound atomic states) immediately ionized atoms back to their elementary particles.
Some 380,000 years after the origin, the expansion of the universe had cooled the temperature to a few thousand degrees Kelvin, and even more importantly created vast numbers of new phase space cells that provided a cool thermodynamic "sink" into which the "source" of hot photons could radiate.
After that somewhat inaccurately called "recombination era" the combinations of protons and electrons into hydrogen atoms became stable. The free electron gas that was the major source of opacity preventing the photons from traveling very far disappeared. The universe became transparent to radiation, allowing astronomers today to see all the way back to that recombination era some 13.75 billion years ago to the isotropic microwave background radiation coming to us from all directions.
We are looking at the residue of the "Big Bang." The original blackbody spectrum of 5000K radiation (approximately the white light from our Sun with wavelengths from 400 to 700 nanometers) has been red-shifted to much longer wavelengths from 1 to 2 millimeters.
Based on a 1934 suggestion of Arthur Stanley Eddington and the 1970's work of my late Harvard colleague David Layzer, I have shown that the information structures in the universe today (from subatomic particles like electrons and quarks, to the galaxies, stars, and planets, as well as living things on Earth) are all dependent on a two-stage cosmic creation process.
In the first stage, there must be multiple indeterministic possibilities for different quantum arrangements of the particles of future structures. If/when the new arrangement has created a new information structure, energy released in the new binding of particles must be carried away in the second stage.
Note if there were only one possibility, information would be a constant and only one (predetermined?) possible future.
The great theoretician of quantum mechanics, John von Neumann, described the importance of new information created in a quantum measurement. He defined two fundamental processes in quantum mechanics, one the "causal" deterministic information-preserving time evolution of a quantum system between measurements, the other the indeterministic information-creating measurement itself.
Von Neumann said the deterministic causal evolution process "does not reproduce one of the most important and striking properties of the real world, namely its irreversibility, the fundamental difference between the time directions, 'future' and 'past.' "
He also said that the indeterministic measurement is "statistical" and causes a "change of the probabilities and the expectation values. Indeed, it is precisely for this reason that one introduces statistical ensembles and probabilities!"
See von Neumann's landmark book, Mathematical Foundations of Quantum Mechanics, (English translation, pp.357-358)
Roduner and Krüger's study of memory critically involves the roles of irreversibility and the "arrow of time." Von Neumann saw those two issues as central to understanding quantum mechanics.
Memory depends on the recording of information in brains/minds and the recall/reproduction or "playback" of that information on demand, when needed by an agent to make a decision on the next action or thought. See our model of the mind as an Experience Recorder and Reproducer.
When particles collide, a quantum process can erase the past path information that would be needed to reverse their paths. This is the origin of irreversibility. But an interaction of a particle with a measurement apparatus can also generate new path information that allows us to predict (within some uncertainty) future events.
In quantum events, information can be both destroyed and created.
According to the second law of thermodynamics, entropy in the universe is is always increasing. But counterintuitively, we now also know that new information and new knowledge is also increasing. Both disorder and order are increasing in the direction of the "master arrow of time," the expansion of the universe, as shown in 1975 by my Harvard colleague David Layzer, based on a 1935 suggestion of Arthur Stanley Eddington.


text:
Q: Wanted to delete ldap node and delete all the subtree node under it I wanted to delete ldap node and delete all the subtree node under it.
eg.I want to delete ou=F115630019  along with its child node i.e cn =xxxxx and ou=115630019 showed in snap shot.

While running the below code i am encountering below error.Please let me know how can i fix this problem.
Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -1
    at java.lang.String.substring(String.java:1911)
    at deleteorg.deleteDN(deleteorg.java:28)
    at deleteorg.deleteDN(deleteorg.java:58)
    at deleteorg.main(deleteorg.java:96)

java code:-
  import java.util.*;
    import javax.naming.Context;
    import javax.naming.ContextNotEmptyException;
    import javax.naming.NameNotFoundException;
    import javax.naming.NamingEnumeration;
    import javax.naming.NamingException;
    import javax.naming.directory.Attributes;
    import javax.naming.directory.BasicAttributes;
    import javax.naming.directory.DirContext;
    import javax.naming.directory.InitialDirContext;
    import javax.naming.directory.SearchControls;
    import javax.naming.directory.SearchResult;

    public class deleteorg {

        public boolean deleteDN(String srchost, String srcport, String srcuserId,String srcpasswd, String srcBaseDn, String deleteDn) {
            String attribList = "";
            String temp = null;
            try {
                DirContext srcCtx = createContext(srchost, srcport, srcBaseDn,
                        srcuserId, srcpasswd);

                SearchControls srcont = new SearchControls();
                srcont.setSearchScope(SearchControls.SUBTREE_SCOPE);
                int i = deleteDn.indexOf(",");
                System.out.println("i: "+i);
                System.out.println("deleteDN="+deleteDn);
                deleteDn = deleteDn.substring(0,deleteDn.indexOf(","));
                System.out.println("index->>"+i+"------" + deleteDn);

                NamingEnumeration answer = null;
                try {
                 answer = srcCtx.search(deleteDn, "objectclass=*", srcont);
                 System.out.println("Answer"+ answer);
                } catch (NameNotFoundException ne) {
                    System.out.println("name not found exception");
                }
                if (answer != null) {
                    while (answer.hasMore()) {
                        Attributes attrs = new BasicAttributes(true);
                        System.out.println("Attr"+ attrs);
                        SearchResult sr = (SearchResult) answer.next();
                        System.out.println("Search Result"+sr);
                        String addDN = sr.getName() + "," + deleteDn;
                        System.out.println("adDN"+addDN);
                        String attribnamevalues = "";
                        if (addDN.indexOf(',') == 0)
                            addDN = addDN.substring(1); // get rid of the leading
                                                        // ","

                        try {
                            System.out.println("AddDN"+addDN);
                            srcCtx.destroySubcontext(addDN);
                    System.out.println("destroyed");
                        } catch (ContextNotEmptyException e) {
                        }
                    }
                    deleteDN(srchost, srcport, srcuserId, srcpasswd, srcBaseDn,
                            deleteDn);
                }
                srcCtx.close();
                return true;
            } catch (NamingException e) {
                e.printStackTrace();
                return false;
            }
        }

        public DirContext createContext(String servername, String port, String basedn, String username, String password) {
            System.out.println("sername=" + servername + "#port=" + port + "#baseDn="+ basedn + "#uid=" + username + "#pwd=" + password);

            DirContext ctx;
            Hashtable<String, String> env = new Hashtable<String, String>();
            env.put(Context.INITIAL_CONTEXT_FACTORY,"com.sun.jndi.ldap.LdapCtxFactory");
            env.put(Context.PROVIDER_URL, "ldap://" + servername + ":" + port + "/"
                    + basedn);
            env.put(Context.SECURITY_PRINCIPAL, username);
            env.put(Context.SECURITY_CREDENTIALS, password);
            env.put(Context.SECURITY_AUTHENTICATION, "simple");

            try {
                ctx = new InitialDirContext(env);
                return (ctx);

            } catch (NamingException e) {
                e.printStackTrace();
                return (null);
            }
        }

        public static void main(String[] args) {

            deleteorg ctx = new deleteorg();

            ctx.deleteDN("localhost", "1389","cn=Directory Manager","Welcome1","ou=organizations,dc=xyz,dc=com","ou=F115630019  ,ou=organizations,dc=xyz,dc=com");

        }

    }

A: Only leaf nodes can be deleted from ldap. You need to follow these steps.

*

*Traverses the subtre, find the last element

*Deletes this node in the reverse order and move up till you reach the target/highlighted node


text:
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>

Project Description

redpajama_set_name: RedPajamaGithub