where

Where our kitchens came from and where they are going

How do you design a green, sustainable and healthy kitchen?




where

Best Renewables Project in the West - "Where's the Competition?" Ask Winners...

The UK-based renewable energy company Ecotricity recently won an award from the renewable energy agency for South West England for its development of three giant wind turbines at the industrial Avonmouth Docks site on the outskirts of Bristol (which we




where

An Aerial View of BPA: Where Are We Since the Rejected Ban?

Where does the FDA stand on a BPA ban?




where

Why is Canada fighting over a gas pipeline to nowhere?

The world is awash in LNG that's a lot closer to the ocean and a lot cheaper to move.




where

Chairs hidden everywhere in this multifunctional furniture collection (Video)

Chairs take up a lot of space, but not in this line of space-saving furniture.




where

Only 1/3 of sunscreens are safe and effective, here's where to find them

The 2019 rating by EWG finds that most sunscreens contain sketchy ingredients and/or don't offer adequate protection.




where

Zero waste depends on where you live

Some areas have more resources than others, so do your best to work with what you have.




where

So you want to learn how to surf? Here’s where to go

I went to Costa Rica for surf camp at the world's most sustainable surf school – it was amazing.




where

Jake Dyson introduces lamp that adjusts for the daylight where you live

The LightCycle follows our circadian rhythms via your phone and GPS.




where

Where scientists are superstars

... in the place where people understand the risks of living in an anti-globalist, post-fact era




where

Make this the last AIA Awards where they don't consider sustainability

They say these are about celebrating the best contemporary architecture. But what does that mean today?




where

This campaign platform for housing in London has ideas that could work anywhere

There are huge upfront carbon emissions from building new housing; a better approach is to be smarter about what we have.




where

Natural gas (and the hydrogen economy) is a bridge to nowhere

Everybody is hopping on the hydrogen train, but it's being driven by natural gas.




where

Where did COVID-19 come from?

To end new zoonotic diseases like coronavirus (COVID-19), humans need to start staying in their lanes.




where

The RadRover Step-Thru could be the perfect e-bike that anyone can ride anywhere

Roll over everything and get on and off easily on this powerful fatbike.




where

Where do house cats go all day? GPS maps reveal their secret lives

Where does Fluffy go when you aren't looking, and just what does Snowball get up to when she leaves the yard? A new study looks at how housecats move around.




where

Looking for a spot to park your tiny house? Here's where to find one

Interested in living in a tiny house, but not sure where to park it? Here are some places to start with.




where

Where Wiffle Ball's a Crime There May Be No Child Left Outside

With kids across America suffering from a severe case of nature deficit disorder as technology creeps in and takes over their room for creative play it may come as a surprise that a group of kids putting together their very own field of dreams on which




where

You can see Tesla's shop on the KuDamm, but not the cars: where is Germany's incentive program?

Tesla's new boutique shop on Berlin's famous KuDamm beckons, but where is Germany's national strategy for electric cars?




where

Where to find all-natural chewing gum

Several companies now make biodegradable chewing gum that's free from synthetic polymers -- healthier for both humans and Earth.




where

Your office is where you are: an update

The coronavirus may change the way we think about the office for a very long time.




where

Where are all the fantasy pedestrians?

Daniel Herridges of Strong Towns says, "If your goal is to promote public safety, design for the humans you have, not the ones you wish you had."




where

City, suburb or country? Where's the best place to ride out this crisis?

Apparently, policy is more important than place.




where

Do women really need trash cans everywhere they go?

Surely there's a way to ditch our wasteful, disposable habits.




where

Is it a new era, where architects should be held to account for the environmental impact of their work?

Sustainability matters, but so does hypocrisy.




where

Where are all the American chocoholics?

U.S. chocolate sales have been dropping and the industry is very worried. What's going on?




where

Where do you stand in the great bathroom debate: shower or tub?

In the building industry it is a big question, for all the wrong reasons.




where

Universal design works for everyone, everywhere

Everything we design should be simple to understand and use for people of all ages and abilities. It's not hard.




where

The Internet of Things knows where you are and what you are doing

It's the buzzword at CES this year, and Mother raises questions about the kinds of issues we are going to have to face.




where

"The Story of Plastic" is a moving film that reveals where plastic comes from – and where it goes

The film exposes a global catastrophe driven by corporate interests.




where

Bill Ackman looks to find another winner in restaurants, where his track record is perfect

Pershing Square made six previous investments in this industry and has never lost money on any of them.




where

Coronavirus has taken millions of jobs, but here's where they're coming back

While some jobs won't be coming back after the lockdown, most, at least for now, will.




where

Since 2000, here's where Dow, S&P 500 trade one month after wild moves in energy

The crazy action in crude oil futures was not the only recent extreme energy trade. The XLE was up over 10% last Friday. Here is how the Dow and S&P do one month after similar rallies since 2000.




where

Apple to start reopening stores in US next week—Here's where

Apple will reopen some of its stores in Idaho, South Carolina, Alabama and Alaska. CNBC's Josh Lipton reports on safety measures the company will be taking.




where

Cornerstone Macro's Carter Worth breaks down where tech's headed next

Carter Worth, Cornerstone Macro's chief market technician, on where tech goes from here. With CNBC's Melissa Lee and the Fast Money traders, Guy Adami, Tim Seymour, Pete Najarian and Steve Grasso.




where

Covid-19's impact on football: 'It could take 10 years to get where we were'

Figures from across the men’s professional game including managers, players and a scout, discuss how football will alter

When life has finally returned to normal, I think football will change for the better. We should see the reversal of a power balance that has swung the wrong way for too long, switching it back in favour of the clubs. I would certainly expect that to happen in the divisions below the Premier League, where the financial implications of Covid-19 are hitting particularly hard. Players and agents will have to lower their expectations, and we will see fewer instances of football clubs being held to ransom over deals and contracts.

Continue reading...




where

Where to find SaaS Benchmarks across the Customer LifeCycle? (3 FAQ’s)

Where do you find SaaS operational benchmarks? How accurate and statistically valid are the available benchmarks? And how do you benchmark KPI’s without spending too much time and money? Ray Rike has answers.

Keep on reading: Where to find SaaS Benchmarks across the Customer LifeCycle? (3 FAQ’s)




where

Guess Where I Just Was

There were over 245,000 people at this place on the day we were there. Kevin was more calm about this fact than I was.

You could probably take out your globe and figure it out from this picture. If you really wanted to :o).

Two dollars for all-you-can-drink milk. (Yuck!)

Fried pickles. (Fried everything else, too.)

This building is called Sheep. (Subtitle Dairy Goats.)

Standing is hard, guys!

In another building, displays of prize-winning flowers.

Kevin was extremely patient while I took pictures of basically every single flower. I LOVED the flowers!

Oooh!

Oooooo.

Have you guessed yet?



Where can one find prize-winning vegetables, and this veterinarian holding a piglet?

You guessed it. Kevin and I had lots of fun Sunday at the Minnesota State Fair.


Hi, my dear readers! I know I haven't been blogging lately, despite having a lot to share – including more Arctic pictures, from the trip that was almost a year ago at this point! These days, the amount I blog is inversely proportional to how intensely I'm working on the next book. This is good news for those of you waiting for my next book, but I am sorry about the lack of blogging :o). I've made a promise to myself to blog some pictures of Arctic critters soon. Stay tuned.



  • Guess where I am







where

The one where we interviewed Luca Ferrari

#352 — April 22, 2020

Read on the Web

???? We've got a neat bonus for you this week at the bottom of the issue ????

Postgres Weekly

Postgres Explain Visualizer 2: A Vue.js Component to Show Execution Plans — Less a standalone tool and something you’d use when building your own Postgres tooling. There is, however, a demo here. The output is really nifty.

Dalibo

Insert-Only Tables To Be Autovacuumed in Postgres 13 (But Why?) — Autovacuuming clears up dead tuples that are often left when updating or deleting data from tables, so why is autovacuuming for append-only tables a big deal in Postgres 13? Laurenz explains.

Laurenz Albe

Faster CI/CD for All Your Software Projects Using Buildkite — See how Shopify scaled from 300 to 1800 engineers while keeping their build times under 5 minutes.

Buildkite sponsor

Full Text Search in Milliseconds with Rails and Postgres — If you’ve never played with full text search with Postgres and Rails, this is a fine place to start. It covers LIKE/ILIKE, trigrams, and ‘proper’ full text searching. We also get to see how Leigh took a query from taking 130ms down to 7ms.

Leigh Halliday

An Easy Postgres 12 and pgAdmin 4 Setup with Docker — Docker provides an easy and loosely coupled way to get things set up in a development environment.

Jonathan S. Katz

Is There a Limit on Number of Partitions Handled by Postgres? — Sort of, but you’d really have to be going at it to stretch Postgres 12’s capabilities in this area.

Denish Patel

Where Do My Postgres Settings Come From? — A nice visual look at how parameters and settings cascade or override each other.

My DBA Notebook

Identify Slow-Running PostgreSQL Queries Quickly in Datadog — Improve PostgreSQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards in Datadog.

Datadog sponsor

Replicate Multiple Postgres Servers to a Single MongoDB Server using Logical Decoding Output Plugin

David Zhang

An Overview of the JOIN Methods in Postgres

Kumar Rajeev Rastogi

???? A Q&A with…
Luca Ferrari
Postgres community organizer, author, adjunct professor, and open source advocate.

Luca Ferrari has had a huge impact on the Postgres community in Italy, having been president of the Italian PostgreSQL Users Group in the past and having helped to organize the popular PGDay.it events. He also blogs frequently about Postgres and wrote PostgreSQL 11 Server Side Programming Quick Start Guide for Packt.

Note: A more complete version of this interview is on the Web.

We caught up with him to ask about server side Postgres use cases in particular:

For those who use Postgres as a simple database and haven't touched the deeper elements, where do you think they should start?

There's no single answer to this question, since Postgres is such a huge project with so many features and a rich community. I never found a project where it cannot fit in. Postgres is somehow like Unix: you cannot touch it as "just a database", you need to commit to its culture to benefit the most out of it.

In my classes, I can see that people usually get fascinated by the capabilities of doing server side programming, and that is why I decided to write my book about this topic. Often, people do not expect to be able to embed their Perl, Java, or Python libraries directly into PostgreSQL without having to rewrite their business logic in an SQL-like language.

Another great feature nowdays is the support to JSON within the database, thanks to which PostgreSQL can be used as both a relational database and a 'NoSQL' storage engine, providing a lot of flexibility in your infrastructure.

One suggestion I always gave is to join the mailing lists: there are several that differ by topic and amount of traffic. Most are very active and have high quality contributors that take care in providing accuate replies to users' questions, that spend time in reproducing errors and edge-cases, and who will help you. That's a mandatory place where you have to start, in my opinion, to better learn about the project, its features and its culture.

Where should the line be drawn between doing things in an external programming language versus within Postgres?

Often the right choice is to place business logic near the data it refers to, that is within the database itself. However, there are several things to take into account including the developer's experience and the expressiveness of SQL-derived languages like pl/PgSQL.

There's a habit of letting ORMs (Object Relational Mappers) do most of the database interaction nowadays, reducing the database to a "simple storage". Of course, databases can do a lot more, and PostgreSQL in particular can help you migrate and embed your own business logic into the database itself.

I have helped a few companies embed their own Java libraries into Postgres resulting in a more robust and coherent way to access the data (the real value) without any regard of the application they were using. Because once you start having data, you will soon find that such data is required by multiple applications in different technologies and on different platforms, so that implementing the same business logic rules over and over becomes a huge effort; on the other hand, moving such logic within the database simplifies and keep uniform the way your data is manipulated.

What one thing do you think people should learn?

Stored procedures. They serve as a common base for triggers and are very similar to routines, therefore allowing you to build more complex pieces into your own cluster. Once you have learnt the common way of defining functions, you can go deeper and write your own native functions using other languages (e.g. C). This is more complex, but thanks to the extensibility of Postgres is not an impossible task and can help you migrating more and more code into the database. Once you have created a new feature, please do contribute it back so that other people can use it!

...

Last, allow me to announce that I'm working on another book right now: me and a friend of mine are writing a more general book on Postgres that will try to answer your question by leading the reader through the main features that make Postgres unique and great.

Be sure to check out Luca's book PostgreSQL 11 Server Side Programming Quick Start Guide to learn more about the topics covered in this interview. You can also find the code from the book in this GitHub repo.

If you enjoyed this interview, Luca actually gave some more detailed answers in the full interview which you can read here.




where

Coronavirus: Where has all the hand sanitiser gone?

Shelves all over the world are empty - it turns out more alcohol is needed, to ramp up production.




where

The shop where you can still buy huge bags of pasta

Wholesalers are opening their doors to members of the public keen to buy supplies in bulk.




where

Where two worlds meet

The restaurant landscape of Powai has minuscule space for street food favourites, barring the desi ice cream trucks that line its famous lake. The scene is dominated by fine-dine chains or international fast food properties. So, when restaurateurs attempt to offer a novel quick service restaurant (QSR) experience, it could go either way. In such scenarios, pricing and innovative menus play a key role in swinging the customer opinion.

El Rancho and Pick Pocket’s menu grabs our attention on both counts — its pricing and attempt to focus on two cuisines, which not many QSRs can pull off. What we also like is the floor plan — it is divided into two sections to represent the two cuisines, without giving the patron a feeling of claustrophobia on entering the outlet. It’s a great example of utilising a small space.


Veg Mexican Pizza

For a QSR, the menu is extensive, and we are tempted to try a few dishes, except for out-of-context options such as chicken stroganoff and anda bhurji. We stick to their specialities and start with cottage cheese burger (Rs 179), Veg Mexican Pizza (Rs 119, for a slice), veg nachos and a falafel pocket (Rs 159 each). We eye a box of Jenga to while away our time, but the service is super quick and two dishes make it to our table under 10 minutes. The portions overwhelm us too. Famished, we start with the nachos that are served with a tasty salsa sauce, cheese sauce and sour cream. The nachos are crisp to our liking.


Chicken Kabsa

The Mexican pizza arrives with near-identical flavours that include beans, mozzarella and a tangy sauce, but we like it nonetheless, especially the crisp base. The burger is a big downer. While the portion size is generous, the jerk sauce that they serve is nowhere close to the real one and the thick paneer patty is bland. The falafel pocket scores a ten on ten, though. The pita pocket is super soft with several pieces of falafel stuffed in, and with the right amount of hummus so that the pocket doesn’t feel dry. In love with this dish, we pick another option — butter chicken pocket (Rs 189). It offers a heady, smoky gravy but chunks of fragrant chicken are a tad undercooked. The Mexican chicken pizza is bland too (Rs 169) and the bad run continues with the chicken kabsa (Rs 249). The chicken is raw, but the accompanying gravy is fragrant with cumin, which compliments the saffron rice.


Baklava 

The saving grace is the deep fried shredded barbeque chicken burger (Rs 199). The glistening bun is stuffed with melted cheese and delicious pieces of chicken (more cheesy than BBQ though). The dish is perfect and our favourite of the evening; we would love to return here just for this mean burger.
Stuffed, we attempt to try their dessert offerings. Since the churros weren’t available (it’s 11.30 pm now), we call for Turkish Baklava (Rs 199) and umm Ali (Rs 199).


Deep Fried Shredded Barbeque Chicken Burger

Both the sweet treats are the QSR versions of the indulgent ones we are used to having, but we aren’t complaining. The baklava doesn’t have many layers, but we’re fine with this abridged version as we are pretty full by now. The umm Ali, with four pieces of croissant dunked in milk doesn’t have the crust a baked version should have, but is tasty nonetheless.

Despite the chicken debacle, the quick service and tempting price points somewhat tilt our opinion. Both menus display promise but the kitchen needs to up its game for an all-out glitch-free experience.

TIME 10 am to 1 pm
AT Cypress CHS, Hiranandani Gardens, Powai.

CALL 30151775

Catch up on all the latest Crime, National, International and Hatke news here. Also download the new mid-day Android and iOS apps to get latest updates





where

Five environment-friendly options from where you can order food in Mumbai

Vikhroli resident Dr Suvajeet Duttagupta loves cooking his meals. But, the 31-year-old cinematographer admits that some days are long and tiring and the only option is to order in. Yet, this comes with its share of heartaches. "The worst bit about ordering out is the amount of plastic that they use to package the food. While I make it a point to ask the restaurants not to send any plastic cutlery, there's only so much one can do." But, Duttagupta isn't the only Mumbaikar who wishes ordering in was more environment-friendly. With the plastic ban coming into full effect on June 23, Mumbai establishments have little more than a month to find alternatives. While some places now pack their containers in cloth bags, the containers themselves remain plastic, thus almost negating the good work done. But, there are a few who have switched to eco-friendly alternatives:

The New York Burrito Company

This brand new Mexican quick service restaurant has a takeout menu that includes Mexican bowl, burrito, tacos, nachos, quesadillas, chips with guacamole and more. They use recyclable bagasse trays and kraft bags (made from recycled paper). They also add wooden spoons and forks to their takeout bags. Senil Shah, partner, says,
"As our packaging is eco-friendly and fresh, we don't fear food getting bad. Costs have risen, but we see it as an investment for our future generation's betterment."


Senil Shah, partner, The New York Burrito Company

Where: Chowpatty
Timings: 11 am – 11 pm
Meal for two: Rs 600
Call: 8999347000

29 – Twenty Nine

This pan-Indian restaurant which opened in 2016, is much loved by the patrons for the range of regional dishes (29 states) available under one roof. "We have been experimenting with various packaging material at our Kemps Corner outlet, long before the plastic ban. The packaging material we have found best for our use is made of paper and cornstarch with an eco-friendly dissolvable lamination. This was then applied to all other 29 outlets," says owner Nishek Jain. The initial sourcing of the products came from an exhibition called PackPlus hosted in New Delhi. Certain items, like rabadi with jalebi all come in a kulhad. They pack the curries in an eco-friendly thick-bond-with-lamination pack.


Nishek Jain, owner, 29 - Twenty Nine. Pic/Bipin Kokate

Where: Kemps Corner
Timings: 11 am – 3.30 pm and 7 pm – 11.30 pm
Meal for two: R1,000
Call: 7208022929

O Pedro

This Goan eatery became an instant talk-of-the-town thanks to its mix of flavours soaked in the coastal calm. From healthy options such as corn falafel lettuce wrap to good ol' chorizo chili fry poie, their menu has something for everyone. Before starting their takeaway services, O Pedro's tried and tested their delivery menu so that they knew that the food ordered for delivery would travel well. All these dishes are packed in products made of sugarcane, sorghum and wheat that are sourced locally from Pappco Greenware. "Working without plastic has its own challenges as one is not able to secure or seal in liquids completely, but we seal our boxes with paper tape to reduce chances of spillage," says Yash Bhanage, Partner at O Pedro. He adds, "The quality and the experience of eating the meal is most important for us. Therefore, we are only looking at delivering within a limited radius where we know the food would reach our guests quickly and in the way it was intended to."

30-60
No. of days in which sugarcane bagasse decomposes

Where: Bandra Kurla Complex
Timings: Noon to 1 am
Meal for two: R1,200
Call: 26534700

Mandala

This delivery kitchen offers a wide range of salads, sandwiches and soups. Sticking to their organic living philosophy, they also ensure that their food reaches their patrons in bio-degradable containers made of sugarcane bagasse — the fibrous residue. They source these products from a company that buys the packaging raw material from the UK and then processes it to create biodegradable bowls. The company also provides data on how many carbon credits they save by using their boxes. "We don't add any items on our menu that don't withstand our rigorous testing. This means that we let our food sit out at room temperature for up to an hour to see if it retains its flavour and freshness," says Sarvangi Shah, director of marketing.

Where: Kemps Corner and Prabhadevi
Timings: 11 am-midnight
Meal for two: Rs 700
Call: 8291817376

The Pantry

Tucked in the bylanes of the city's art district, this artsy café is a perfect hideout. The Pantry was established six years ago with principles of using fresh, local produce. This even translates in their packaging where they use food containers made of cornstarch while their straws, sleeves, boxes are all made of paper. Soup containers are made of bagasse. "Liquid foods like soups are the trickiest to pack but as we use bagasse container for the same and they are with an airtight lid which holds liquids safely, it makes it easy to travel," says Sumit Gambhir, the partner at The Pantry. In order to avoid spoilage due to temperature, they ensure that they maintain the delivery timings.

Address: Kala Ghoda, Fort
Timings: 8.30 am – 11.30 pm
Meal for two: Rs 1,400
Call: 22678901

Catch up on all the latest Mumbai news, crime news, current affairs, and also a complete guide on Mumbai from food to things to do and events across the city here. Also download the new mid-day Android and iOS apps to get latest updates





where

World Record Store Day: The ultimate guide to where you can buy an LP

The romanticising of vinyls is not without reason - the gritty, warm sound, the bout of nostalgia and the act of listening may all be cliches, but they also hold true. And today being World Record Store Day, there is perhaps no better way of spending it than actually being in one. So here are a few that can satiate everyone from the grandpa obsessed with Madhubala to the hipster who wears socks from different pairs. Take your pick.

The Revolver Club
Jude D'Souza (seated in pic), CeO at The Revolver Club, says, "I once got a call about someone wanting to purchase weapons and another one asking how they could join this club." He explains that the name is a play on the revolving aspect of vinyls and also an ode to a Beatles album. D'Souza set up the store with co-founder Shalom Benjamin about three years ago, and it has now become a go-to hub for record junkies.
At: LJ Road, Mahim West.
Call: 9833182255
Cost: Rs 100 to Rs 25,000

Royal Music Collection
Known simply as Abdul Razaak's store to those in the trade, this shop tucked away in Fort has been around since 1982. Featuring an array of languages and genres, the stock is a treasure trove of collectors' records. "Most of my customers are regulars and now that record players are back, I get some new ones too. Much what I have comes from old collections, so it's cheap and exquisite," says Razaak, the owner.
At: Kitab Mahal, Dr DN Road.
Call: 98209 33365
Cost: Rs 250 to Rs 2,000.

Music Circle
Pilak Bhatt, owner of Music Centre, which has been around for five years, says he has been collecting records for the last 40 years. At his store you can find both pre-owned records and new ones. "Because of my passion and love for music, I want this format to stay alive. Analogue sound is natural and warm and records have lovely artwork. Plus, there's ample information about the artistes. The sound of Mp3s isn't great, and people are realising that, which is why this revival has come about," Bhatt says.
At: V Mall, Kandivali east
Call: 9833062221
Cost: Rs 300 to Rs 2,000

Catch up on all the latest Mumbai news, crime news, current affairs, and also a complete guide on Mumbai from food to things to do and events across the city here. Also download the new mid-day Android and iOS apps to get latest updates