iva

Your new year's resolution: Get serious about your consumer data privacy strategy

How an organization responds to CCPA and future-proofs itself against additional laws will dictate how well it will perform for years to come




iva

Survival strategies for businesses during COVID-19 lockdown

We are all in this together, so the ideal way is to stay transparent with your consumers about what your business is going through. Customers can empathize with companies facing a crisis, as long as the communication is transparent.




iva

First Ride: Honda Activa 6G BS6 review

First Ride: Honda Activa 6G BS6 review





iva

Take user privacy seriously, don't collect data without consent: Xiaomi

Xiaomi India Managing Director said that the company does not collect any user data that the user has not explicitly given permission or consent to. He added that in the browser's incognito mode, all user data is completely encrypted and anonymised. He also pointed out that all Mi Browser and Mi Cloud data of Indian users is stored locally in AWS servers in India.




iva

Karnataka looks to build a tech bridge with Pravasi Divas

The Karnataka government is expecting to create multiple corridors with countries such as Portugal and Suriname whose top officials attended the event.




iva

SCCM Pod-163 PCCM: Central ECMO Leads to Better Survival in Children

Graeme MacLaren, MD, FCCM, is the lead author on an article published in the March Pediatric Critical Care Medicine.




iva

POKE ME: Government, get out of skilling. Motivate the bureaucracy to create the right ecosystem instead

What we need before Skill India is perhaps a Skill Government mission. And what’s more, in this Budget season, a visionary leader can do this without much fund allocation.




iva

Covid-19: Revival of economy through tax measures

The government (GoI) has so far been very supportive and empathetic towards businesses and was quick to respond through delayed application of few amendments introduced in Finance Act 2020 (FA 2020) along with relief measures on various tax and other statutory compliances announced subsequently.




iva

Share transfer: Provision, procedure & valuation for a private company

Transferability of shares in a privately held company is governed by the Articles of Association, which is a document that lays down the rules and regulations.




iva

I can't risk lives of my policemen to manage crowd at liquor shops: Delhi Police Commissioner SN Shrivastava

Police should have welfare systems similar to the ones implemented by the armed forces, says Delhi Police Commissioner SN Shrivastava.




iva

Economic revival will depend on our covid policy

Cement is a perfect barometer to gauge economic activity. On May 5, a day after India began a graded opening up in its fight against the scourge of the novel coronavirus, economic activity could be tracked by the movement of rakes carrying cement: 7 out of every 10 trains were chugging towards green and orange zones, bypassing the prosperous districts in the red zone.The government, by then, had colour-coded all 733 districts in the country. The 130 districts that were the worst affected by Covid-19 were in the red zone. Suddenly, the country’s biggest and most vital commercial hubs such as Mumbai, Delhi, Pune, Ahmedabad and Chennai were hotspots. The virus-free 319 districts were coded green and the rest 284 districts, which were only moderately affected, were called orange. The many guidelines issued by the Ministry of Home Affairs, state chief secretaries and even resident welfare societies boiled down to the same thing — the harshest lockdown will be in the red zone, there will be partial relaxation in orange zones while green will be opened up, albeit with conditions.Cement movement is a good measure of economic activity on the ground as it is often ferried straight to project sites. When the nationwide lockdown began on March 25, all non-essential work, including construction, came to a grinding halt. And the rakes carrying cement stopped running. 75649505The railway data, previewed by ET Magazine, shows that 254 trains carrying cement were on the move on May 5 when Lockdown 3.0 began: 84 of them were travelling towards green zones, 99 to orange and only 71 to red.India in Numbers- Source: McKinsey (% of population- 2011 census)Total Districts in India: 733GREEN ZONE- 319 Districts- 24 per cent populationORANGE ZONE- 284 Districts- 43 per cent populationRED ZONE- 130 Districts- 33 per cent population49-57% Economic activity during the lockdown 41% Red districts’ share of economic activities 50% Share of red districts in households with annual disposable income of over Rs 4.85 lakh 143 mn Minimum number of inactive non-farm workers during lockdown (Note: Green districts are Covid-free for previous 21 days; red and orange zones are identified on the basis of positive cases, doubling rate, testing, etc.)The colour-coded division and lockdown of India raises three big questions. One, are the green and orange zones robust enough to fire up the nation’s $2.7 trillion economy? Two, can the lockdown in the red zones be stretched beyond May 17 even as the number of Covid-19 cases in the country jump to about 60,000 on Saturday morning, with almost all of the new active cases coming from the red districts? Three, if the lockdown is prolonged in the metropolises, have we calculated the impact on the economy? In essence, how should India navigate a health emergency and an economic crisis — both unprecedented in its nature and magnitude? 75649443Bibek Debroy, chairman of the Prime Minister’s Economic Advisory Council, resorts to Greek mythology to explain the dilemma India is in and the possible way out for it. Homer’s hero Odysseus, Debroy says, chose to sail closer to the sea beast Scylla and lose a few sailors, rather than lose his entire ship by travelling near the monstrous whirlpool Charybdis. In Debroy’s telling, the sea monster Scylla is the Covid pandemic and Charybdis is the economic toll. (See the column, “The Ship Inches a Little Away From Whirlpool”).That Greek myth could be a clue to what the Indian government is likely to do after May 17: lift the clampdown on entire districts and impose severe restrictions only on containment zones; kick-start the economy even as Covid cases and the death toll rise alongside. Says Debroy: “Mortality and morbidity apply to enterprises too; MSMEs more pronounced than most. The baseline GDP growth was already in slowdown mode and a capital crunch was compounded by lockdown’s labour constraint. There were both supply and demand shocks. That Scylla/Charybdis metaphor is apt, because Homer’s account tells us what Odysseus did.” 75649534“All the big cities are in red zones. Even if a factory opens in orange or green zone, who will it produce for? Red zones cannot turn orange quickly. So will you not allow the sale of nonessential items in red zones?” Arvind Mediratta, MD & CEO, Metro Cash & Carry.The worry about the nation’s economic health is palpable. If the lockdown continues in the commercial hubs any longer, the losses will pile up for many companies; the smaller firms likely to go under first. It will have a debilitating effect on the economy in general and jobs in particular. The Indian economy would be on the ventilator then.As those cement-carrying rakes show, there are many factories in orange and green zones as well, miles away from city limits. Work can begin there, and some have already started production. 75649555“There is total disruption. Supply chains are badly affected. Liquidity is a big issue. The govt must announce a stimulus package. I also urge the govt to stop the imports of all products that can be made in India” Gautam Singhania, CMD, RaymondBut the million-rupee question is, who are they producing for? The 130 districts in the red zone are critical centres of not just production but also consumption. Even as they account for 41% of national economic activity, 38% of industrial output and 40% of non-farm employment, they also have half of India’s consuming-class households — those with an annual disposable income of more than Rs 4.85 lakh each — according to a recent McKinsey report titled “Reopening India: Implications for Economic Activity and Workers”.Breaking the Value ChainFurthermore, dividing swathes of the country into zones and restricting movement of goods and people will have a disastrous effect on production, labour, supply and distribution chains, which are deeply intertwined. In the textiles sector, for example, if cotton is bought in the western parts of India, yarn is spun in the north and west, while weaving mostly takes place in the south, and apparel is manufactured in clusters in the north and south, as the McKinsey report further points out. Similarly, in the chemical industry, the acetic acid value chain supplies to a variety of industries such as pharmaceuticals, pesticides, paper, food processing and construction. Any blockage will have a ripple effect on sectors.Arvind Mediratta, managing director and CEO of Metro Cash and Carry, says dividing the country into colour-coded districts is unrealistic and the rules guiding it are arbitrary. “It seems those who designed it (colour-coded zones) are not aware of ground realities. All the big cities are in red zones. Even if a factory opens in orange or green zone, who will it produce for? Also, the implementation on the ground is arbitrary. In red zones today, you can buy liquor but not kitchen items,” says Mediratta.Mohit Anand, managing director of Kellogg, South Asia, says solutions have to be found locally. “Each region has its own issues, each warehouse and factory has a different problem. India is like 21 countries put together and, hence, the solutions also have to be hyperlocal in nature,” he says. In red zones, not only are malls and market places shut but ecommerce firms are barred from selling non-essential items. An Amazon spokesperson says when restrictions were lifted, the company saw a huge demand from orange and green zones for smart devices, kitchen appliances, baby clothes and products related to study-from-home. “The opening up of these areas for ecommerce has meant that thousands of small businesses received orders for the first time in the past many weeks of lockdown,” the spokesperson adds. Consumers and businesses in the red zone, meanwhile, have to wait. 75649590“MMCAS (manufacturing, mining, construction and allied services) constitutes about 50% of GVA and about 35% of employment. This segment must be freed up, even in red zones” Arvind Virmani, Former chief economic adviser.Out of WorkThe lockdown has seen a massive reverse migration of workers. Deprived of work and wages for weeks, hundreds of thousands of labourers have left cities. In sheer desperation, many hid in trucks and freight trains and trudged hundreds of kilometres to reach home. It was only after 40 days of lockdown that the government arranged special trains for them— by Saturday, 302 trains have ferried around 3.4 lakh migrant workers to their native states.Some states are worried about reverse migration at a time when factories are reopening and life in green pockets are returning to normalcy. Karnataka even made an abortive attempt to stop such special trains to stonewall the return of migrant labourers. Rajasthan Deputy Chief Minister Sachin Pilot says workers should be persuaded to stay back. He says: “There is a cost to the migrants’ travelling back to their native districts. Once a worker goes home, she won’t return in the next three-four months. I feel that only those who are desperate and determined to return home should go; the rest should stay back, taking temporary jobs. They won’t be gainfully employed in their native areas.” The loss of workforce will particularly affect states such as Maharashtra, Delhi, Andhra Pradesh, Telangana, Karnataka and Kerala that rely heavily on migrant workers in construction and services sectors. 75649620“After Covid-19 there will be new normals: new models of engagement between companies and their clients” Keshav Murugesh, Group CEO, WNS Global ServicesMontek Singh Ahluwalia, former deputy chairman of the Planning Commission, says labourers will not return to cities anytime soon, and it will be one of the factors that will prolong the economic pain. He says green and orange zones cannot help in economic revival “as 60% of the economy is in the red zone”. Even if restrictions in all the zones are lifted, he says, it will take some more time for economic activity to get back to normal. “The reverse migration that has taken place may not be quickly reversed. Recession in the world economy and reduced level of remittances will have a negative impact. Private sector investment plans which have been interrupted will take time to resume. That is why many analysts are predicting that we may see negative growth in 2021, with recovery beginning only next year,” Ahluwalia adds.In this pervasive gloom, some indicators offer flickers of hope. Bengaluru-based trucking platform BlackBuck has seen a spike in bookings on the back of a good harvest. The agri pickup is likely to continue into the kharif season, with the India Meteorological Department forecasting a good monsoon. Cofounder Rajesh Yabaji says: “We have seen 80,000 bookings since we opened up our commission-free platform in April-end. Now, we estimate truck traffic to be at 50% of pre-lockdown trucking movement.”On April 29 and 30, two freight trains originating from Karnataka ferried about 350 new tractors to Rajasthan and Gujarat, responding to demand in western India ahead of the kharif season.Companies are ramping up production of agri-related items to meet seasonal demand from rural India. Hemant Sikka, president, farm equipment sector, Mahindra & Mahindra, says the company has resumed production in its tractor plants in Rudrapur (Uttarakhand), Nagpur (Maharashtra) and Mohali (Punjab) after getting necessary approvals. 75649661“With dealerships opening up, bounty harvest and forecast of a normal monsoon, the tractor industry will perform well” Hemant Sikka, President, farm equipment sector, Mahindra & Mahindra.“The highest levels of safety protocols and social distancing are being ensured at the plants, especially on the shop floor. With dealerships gradually opening up, a bounty harvest and forecast of a normal monsoon, I am positive that the tractor industry will perform well and ensure rural growth and prosperity during the year,” says Sikka.Farming sector is likely to get a boost this year with labourers who are back from the cities lending a hand on the fields. The number of people engaged in work under NREGA (National Rural Employment Guarantee Act) has swelled multiple times. In Rajasthan, as against 62,000 NREGA workers on April 18, there were 16.5 lakh on May 5. All of them are engaged in their own farmland, receiving Rs 220 daily from the government.While agriculture could be a sector to watch out for in the coming months, the Covid-19 crisis will inflict a body blow to sectors such as hospitality and tourism, which are likely to remain dormant for quite some time even after the lockdown is lifted. 75649456After Covid The post-Covid world will be vastly different from the before-Covid universe we have left behind. Keshav Murugesh, group CEO of WNS Global Services and former chairman of Nasscom, says there will be “new normals”. Clients and BPO companies will come up with ingenious models of engagement. Work from home could become the norm even if it leads to productivity loss. “At WNS, we are in no hurry to go back to office in May although work from home would mean productivity would drop to 85%,” says Murugesh, adding that uninterrupted power supply at homes is essential for making the model a success in the longer term.Saugata Gupta, managing director of consumer goods company Marico, says they are strategising on new pricing to sell their products effectively in a post-Covid environment. “We have to be cognisant of the fact that with mounting pressure on consumers’ disposable income, there will be a risk of downtrading. So, one has to be very careful on pricing, and we have to ensure a good value to consumers. Any gains on input costs need to be passed on to consumers,” says Gupta, adding that the opening up of green zones is good news for them as many of their products are popular in rural markets. 75649645“Each region has its own problems. India is like 21 countries put together, and solutions also have to be hyperlocal in nature” Mohit Anand, MD, Kellogg, South AsiaGautam Singhania, chairman and MD of Raymond, says there seems to be a communication gap between the Centre and states. He says: “There is total disruption. The supply chains are badly affected. Liquidity is a big issue and banks are not willing to pump in cash now. It is high time the government took this up, and announced a stimulus package.” He proposes a ban on imports. “For one year, we should follow the motto of buying only Indian products. I urge the government to stop imports of products that can be made in India. This is a question of survival.”India Inc, by and large, has come to terms with the new reality that till a vaccine for Covid-19 is discovered, the companies will be forced to shed some productivity by allowing employees to work from home and by deploying fewer labourers to ensure social distancing.The government, however, cannot remain in stasis till a vaccine is discovered. It has to take a call on whether a blanket ban on economic activities in red districts is the way forward. Former chief economic adviser Arvind Virmani says economic activities should be allowed in red zones. “We estimate that MMCAS (manufacturing, mining, construction and allied services) constitutes about 50% of GVA (gross value added) and about 35% of employment. This segment of economy must be freed up entirely, even in red zones, with restrictions such as physical distancing,” he says.The virus is not going away anytime soon. The hastily drawn colour codes will have to be smudged away now. Otherwise, an economic contagion will be upon us.Read More1. Our first objective is to provide value to customers: Saugata Gupta, MD, Marico2.Economy likely to show negative growth in current year: Montek Singh Ahluwali3. Rajasthan’s thrust will be on textile, agriculture and domestic tourism: Sachin Pilot4. With a phased opening, India tries to avoid a grave economic toll: Bibek Debroy




iva

Coronavirus lockdown: 5 steps to protect your privacy online

Due to lockdown in the country, we are more dependent on the Internet, which also means that we are more susceptible to tracking by websites and apps for our data. Here are 5 simple steps you can take to protect your personal information.




iva

From Srinagar's Tulip festival to Assam's Rongali Bihu, spring time fests you just can't miss out on

Time to get into the festive spirit.




iva

How To Prepare For Financing Your Child’s Private School Education

It’s that time of year again for private school acceptance letters and all the excitement they can bring.




iva

Athletes Serving Athletes Share Bond At Running Festival

The program partners wheelchair bound athletes with able bodied athletes who train and compete in various races, from 5Ks to marathons.




iva

Poll: Hogan Approval High, Leading Democratic Rivals

While his approval rating among Democrats is above 60 percent, the poll shows Gov. Larry Hogan draws less than 50 percent of the vote, in head-to-head matchups with leading Democratic candidates.





iva

Volunteers from Grand Canyon Private Boaters Association Team Up with NPS Staff for Rehabilitation Project

https://www.nps.gov/grca/learn/news/2010-03-01_rehab.htm




iva

Take Wing this Weekend with Grand Canyon National Park’s Festival of Flight

Grand Canyon National Park invites bird enthusiasts of all levels to participate in a weekend of birding fun and excitement including a LIVE radio broadcast with Talkin’ Birds Radio. https://www.nps.gov/grca/learn/news/grand-canyon-bird-festival.htm




iva

A sensitivity analysis of Forests on the Edge: Housing Development on America's Private Forests.

The original Forests on the Edge report (FOTE 1) indicated that 44.2 million acres of private forest land was projected to experience substantial increases in residential development in the coming decades.




iva

Regional Cost Information For Private Timberland Conversion and Management

Cost of private timber management practices in the United States are identified, and their relationship to timber production in general is highlighted. Costs across timber-producing regions and forest types are identified by forest type and timber management practices historically applied in each region. This includes cost estimates for activities such as forest establishment practices such as reforestation and afforestation on crop and pastureland. Establishment costs for reforestation in the Southern United States are less than in other regions, although regional differences in establishment costs are less evident in hardwood than in softwood stands. Also, included in the list of timber management costs ate the intermediate management treatments of precommercial thinning, herbicide, and fertilizer application. Intermediate management treatments are less costly in the southern United States than in other regions. Trends in timber management costs reported as part of the management costs reporting.




iva

Regional Cost Information For Private Timberland Conversion and Management

Cost of private timber management practices in the United States are identified, and their relationship to timber production in general is highlighted. Costs across timber-producing regions and forest types are identified by forest type and timber management practices historically applied in each region. This includes cost estimates for activities such as forest establishment practices such as reforestation and afforestation on crop and pastureland. Establishment costs for reforestation in the Southern United States are less than in other regions, although regional differences in establishment costs are less evident in hardwood than in softwood stands. Also, included in the list of timber management costs ate the intermediate management treatments of precommercial thinning, herbicide, and fertilizer application. Intermediate management treatments are less costly in the southern United States than in other regions. Trends in timber management costs reported as part of the management costs reporting.




iva

Evaluating Forest Land Development Effects On Private Forestry In Eastern Oregon

Research suggests that forest land development can reduce the productivity of remaining forest land because private forest owners reduce their investments in forest management. We developed empirical models describing forest stocking, thinning, harvest, and postharvest tree planting in eastern Oregon, as functions of stand and site characteristics, ownership, and building densities. The models are based on USDA Forest Service Forest Inventory and Analysis data gathered in eastern Oregon in 1987 and 1998, and data describing building densities gathered by the Oregon Department of Forestry from aerial photographs taken over the same period. We used the models to examine the potential effects of population growth and development, as described by increasing building densities, on the likelihood that private forest owners maintain forest stocking, precommercially thin, harvest, and plant trees following harvest. Empirical results suggest that population growth and development have had no measurable effect on these activities in eastern Oregon during the period examined. Any development effects on private forest management and investment so far are likely to be fairly localized.




iva

A closer look at forests on the edge: future development on private forests in three states

Privately owned forests provide many public benefits, including clean water and air, wildlife habitat, and recreational opportunities. By 2030, 44.2 million acres of rural private forest land across the conterminous United States are projected to experience substantial increases in residential development. As housing density increases, the public benefits provided by private forests can be permanently altered. We examine factors behind projected patterns of residential development and conversion of private forest land by 2030 in northwestern Washington, southern Maine, and northwestern Georgia. Some key factors affecting the extent of future residential housing include (1) population growth from migration into an area; (2) historical settlement patterns, topography, and land ownership; and (3) land use planning and zoning.




iva

Private Forests, Public Benefits: Increased Housing Density and Other Pressures on Private Forest Contributions

Over half (56 percent) of America's forests are privately owned and managed and provide a vast array of public goods and services, such as clean water, timber, wildlife habitat, and recreational opportunities. These important public benefits are being affected by increased housing density in urban as well as rural areas across the country.




iva

Sage-Grouse on the edge: understanding and managing western landscapes for their survival

Scientists have had little information about how prescribed fire and cattle grazing—common practices in many Western ponderosa pine forests—affect plant abundance and reproduction in the forest understory. Pacific Northwest Research Station scientists began to explore how these practices affect vegetation in a five-year study of postfire vegetation in eastern Oregon ponderosa pine forests where cattle have been routinely pastured from late June or early July through early to mid August. For this area of eastern Oregon, they found that excluding cattle grazing during peak growing season increased native plant cover and grass flowering capability in ungrazed areas compared to grazed areas. Because vegetation was measured prior to releasing cattle on the land, the study's results tend to reflect lasting grazing impacts rather than simple consumption.




iva

Gateshead Beer Festival team pour their efforts into a charity challenge instead

Gateshead Rugby Football Club members swap Bank Holiday festival plans for a 554-mile fund-raising 'journey' to London and back




iva

Last-minute VE Day ideas from easy war-time snacks to a virtual festival

Here's how families can still make the most of this Friday's 75 year anniversary of Victory in Europe Day




iva

Porter Robinson's Secret Sky Festival Happening May 9th

GOLDENVOICE, BROWNIES & LEMONADE, and SLUSH MANAGEMENT present PORTER ROBINSON'S Secret Sky Festival this SATURDAY (5/9).  It's ROBINSON's first performance of 2020. … more




iva

Privacy During a Pandemic: Town Hall for Library, Information Workers for Choose Privacy Week

CHICAGO – When states and local governments closed libraries and schools to curtail the COVID-19 pandemic, library workers and educators responded to the emergency by quickly adopting commercial online tools and platforms to ensure continued access to resources. But with the emergency becoming a new normal, libraries need to critically evaluate these technologies and address any potential privacy and security gaps that could pose a threat to users' privacy.




iva

Alice Knapp, president of the Ferguson Library, wins 2020 Sullivan Award

CHICAGO — The American Library Association (ALA) is pleased to announce the 2020 Peggy Sullivan Award for Public Library Administrators Supporting Services to Children was awarded to Alice Knapp, president of the Ferguson Library (Stamford, Connecticut).  The Sullivan Award is presented annually to an individual in a library administrator role who has shown exceptional understanding and support of public library service to children.  With the cancellation of the ALA Annual Conference, the award will be presented at the Award Ceremony and Reception Sunday, Jan.




iva

The 2020 XPoNentional Music Festival Has Been Canceled

TODAY (4/30) UNIVERISTY OF PENNSYLVANIA Triple A WXPN/PHILADELPHIA -- in consultation with its partners the CAMDEN COUNTY BOARD OF FREEHOLDERS and LIVE NATION -- announced the cancellation of … more




iva

Matt Pinfield-Hosted 'Sessions' To Launch On Twitch As Virtual Festival, May 6th

TRUIDEATION is bringing together MUSICARES and TWITCH for a two-hour virtual festival, SESSIONS, on four consecutive WEDNESDAYS, starting this week on MAY 6th at 1p PT/4p ET on TWITCH, with … more




iva

Dos artículos de perspectivas sobre los medicamentos para la hipertensión y su uso continuo a fin de combatir el COVID-19

DALLAS, 1 de abril del 2020 — Algunos cardiólogos de Wuhan, China y otros países recomiendan a los pacientes con hipertensión arterial que continúen tomando sus medicamentos, aunque los efectos de algunos se hayan visto afectados por las infecciones ...




iva

Más pasos por día se relaciona con reducciones significativas de la diabetes y la hipertensión arterial

Puntos destacados de la investigación: Los adultos de mediana edad que caminaron una mayor cantidad de pasos al día mostraron un 43% menos de riesgo de padecer diabetes y un 31% menos de riesgo de hipertensión arterial, en comparación con personas de...




iva

El nuevo registro de datos de pacientes con COVID-19 proporcionará perspectivas sobre la atención y los resultados cardiovasculares adversos

DALLAS, 3 de abril del 2020 – Debido al esfuerzo de médicos, científicos e investigadores de todo el mundo por comprender la pandemia del coronavirus (COVID-19), la American Heart Association está desarrollando un nuevo registro para agregar datos y...




iva

Perspectiva del paciente: vivir con diabetes de tipo 2 y cardiopatías en medio del COVID-19

Botones para compartir de AddThis Compartir en Facebook Compartir en Twitter Compartir por correo electrónico Compartir para imprimir DALLAS y ARLINGTON, 23 de abril del 2020 — Debido a que la ciencia que emerge en torno al COVID-19...




iva

Carnival Row at Disney

Matt Ridley on putting everything in perspective I love this guy… he always has a fresh perspective on things. Daily Photo – Carnival Row at Disney When I was at Disneyland in Anaheim, I thought this would make excellent subject-matter for an HDR shot. This mix of lights and textures usually comes out pretty cool. […]




iva

Sullivan: County leads with many of Iowa’s ‘firsts’

I grew up on a Heritage farm (150 years in the same family) near Sutliff, and attended K-12 in the Lisbon school system. I am an alumnus of the University of Iowa. I have held several positions in the field of human services, including six years with the Department of Human Services and six years as executive director of the Arc of Johnson County.

I am married to Dr. Melissa Fath, a research scientist at the University of Iowa and a volunteer pharmacist at the Free Medical Clinic. We have three adult children — Rachel, Jordan and BJ, and have served as foster parents for another 50+ children.

I am a member of several community organizations, including: St. Andrew Presbyterian Church, Iowa Foster & Adoptive Parent Association, NAMI, Center for Worker Justice, ACLU Hawkeye Chapter, AFT Local 716, and Iowa City Federation of Labor. I also served four years as chairman of the Johnson County Democratic Party.

Some of the accomplishments of which I am proud:

• Leadership during the COVID-19 crisis.

• Leadership during 2008 floods.

• Raising the minimum wage — the first county in Iowa to do so.

• Passed a Human Rights Ordinance — the first county in Iowa to do so.

• Passed a Sensitive Areas Ordinance — the first county in Iowa to do so.

• Passed the Conservation Bond Initiative — the first county in Iowa to do so.

• Passed the Community ID Program — the first county in Iowa to do so.

• Started 1105 Project with gift of old Public Health building.

• Saved Sutliff Bridge after 2008 floods.

• Started trails funding.

• Created the Free Tax Help project.

• Created the Livable Community for Successful Aging.

• Added outdoor warning sirens to unincorporated Johnson County.

• Created the Local Foods Policy Council.

• Heritage AAA Outstanding Elected Official — 2009.

If reelected, my goals are:

1. Continue community recovery from COVID-19;

2. Begin serving people at the GuideLink Center;

3. Improve affirmative action results;

4. Renegotiate six union contracts to the benefit of all.

I am grateful for your past support, and I thank you for your future consideration. I promise to never take this position for granted! I respectfully request your vote on or before June 2.

Rod Sullivan is a candidate in the Democratic primary for Johnson County Board of Supervisors.




iva

Design Festival, The Setup, and Upcoming Posts

Wow, this has been a busy period. I’m just back from the Ampersand web typography conference in Brighton, and having a catch-up day in Mild Bunch HQ. Just before that I’ve been working flat out. First on Mapalong which was a grass-roots sponsor of Ampersand, and is going great guns. Then on an article for The Manual which is being published soon, and on 8 Faces #3 which is in progress right now. Not to mention the new talk for Ampersand which left me scratching my head and wondering if I was making any sense at all. More on that in a subsequent post.

In the meantime two previous events deserve a mention. (This is me starting more of a journalistic blog. :)

First of all, an interview with Simon Pascal Klien, the typographer and designer who’s curating the Design Festival podcast at the moment. We talked about all things web typography. Pascal cheekily left in a bit of noise from me in the prelude, and that rant pretty much sets the tone for the rest of the conversation. Thanks for your time, Pascal! If anyone reading this would care to listen in, the podcast can be downloaded or played from here:

Secondly, Daniel Bogan of The Setup sent me a few questions about my own tools. My answers are pretty clipped because of time, but you may find it interesting to compare this designer’s setup with your own:

I should note that in the meantime I’ve started writing with Writer, and discovered the great joy of keeping a journal and notes with a Midori Traveler’s Notebook. The latter is part of an on-going search I’m having to find Tools for Life. More on that, too at some point. Here’s my current list of topics I want to write about shortly:

  • Ampersand, the aftermath
  • Marrying a FujiFilm X100
  • No-www
  • Tools for life
  • Paper versus pixels

There, I’ve written it!




iva

New Auphonic Privacy Policy and GDPR Compliance

The new General Data Protection Regulation (GDPR) of the European Union will be implemented on May 25th, 2018. We used this opportunity to rework many of our internal data processing structures, removed unnecessary trackers and apply this strict and transparent regulation also to all our customers worldwide.

Image from pixapay.com.

At Auphonic we store as few personal information as possible about your usage and production data.
Here are a few human-readable excerpts from our privacy policy about which information we collect, how we process it, how long and where we store it - for more details please see our full Privacy Policy.

Information that we collect

  • Your email address when you create an account.
  • Your files, content, configuration parameters and other information, including your photos, audio or video files, production settings, metadata and emails.
  • Your tokens or authentication information if you choose to connect to any External services.
  • Your subscription plan, credits purchases and production billing history associated with your account, where applicable.
  • Your interactions with us, whether by email, on our blog or on our social media platforms.

We do not process any special categories of data (also commonly referred to as “sensitive personal data”).

How we use and process your Data

  • To authenticate you when you log on to your account.
  • To run your Productions, such that Auphonic can create new media files from your Content according to your instructions.
  • To improve our audio processing algorithms. For this purpose, you agree that your Content may be viewed and/or listened to by an Auphonic employee or any person contracted by Auphonic to work on our audio processing algorithms.
  • To connect your Auphonic account to an External service according to your instructions.
  • To develop, improve and optimize the contents, screen layouts and features of our Services.
  • To follow up on any question and request for assistance or information.

When using our Service, you fully retain any rights that you have with regards to your Content, including copyright.

How long we store your Information

Your Productions and any associated audio or video files will be permanently deleted from our servers including all its metadata and possible data from external services after 21 days (7 days for video productions).
We will, however, keep billing metadata associated with your Productions in an internal database (how many hours of audio you processed).

Also, we might store selected audio and/or video files (or excerpts thereof) from your Content in an internal storage space for the purpose of improving our audio processing algorithms.

Other information like Presets, connected External services, Account settings etc. will be stored until you delete them or when your account is deleted.

Where we store your Data

All data that we collect from you is stored on secure servers in the European Economic Area (in Germany).

More Information and Contact

For more information please read our full Privacy Policy.

Please do not hesitate to contact us regarding any matter relating to our privacy policy and GDPR compliance!







iva

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

iva

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

iva

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

iva

Scientists Warn Crashing Insect Population Puts ‘Planet’s Ecosystems and Survival of Mankind’ at Risk

By Jon Queally Common Dreams “This is the stuff that worries me most. We don’t know what we’re doing, not trying to stop it, [and] with big consequences we don’t really understand.” The first global scientific review of its kind … Continue reading




iva

Scientists Warn Crashing Insect Population Puts ‘Planet’s Ecosystems and Survival of Mankind’ at Risk

By Jon Queally Common Dreams “This is the stuff that worries me most. We don’t know what we’re doing, not trying to stop it, [and] with big consequences we don’t really understand.” The first global scientific review of its kind … Continue reading




iva

Ben Moon: Surf, Survival, and Life on the Road

Since we’re home, I’m working to bring more LIVE conversations to you from our living rooms. ???? Join me + adventure photographer / filmmaker Ben Moon at 12:30PM PST tomorrow. There will be a live chat, so please ask us some questions as well. See you there. You might know Ben from his adventure and lifestyle photography or his beautiful films. Surviving cancer in his 20s gradually shifted his artistic focus from capturing the pursuit of adventure to telling nuanced human stories that have inspired and impacted millions. Most notably, his personal story battling colorectal cancer and his special relationship with his dog Denali, which he shares in his beautiful viral short film, now turned book, Denali. ABOUT BEN Ben Moon is an adventure, lifestyle, and portrait photographer whose vibrant images have graced the pages of Patagonia catalogues for the past 18 years.  In recent years, he has shifted his focus to filmmaking. In 2015, he founded his production company, Moonhouse as a platform for collaboration with friends and creatives to bring a wide range of thought-provoking, impactful and cinematically beautiful stories to life on-screen. As a director, Ben’s unique ability to connect with his subjects paired with the talent […]

The post Ben Moon: Surf, Survival, and Life on the Road appeared first on Chase Jarvis Photography.




iva

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

iva

Equivalence of classical and quantum completeness for real principal type operators on the circle. (arXiv:2004.07547v3 [math.AP] UPDATED)

In this article, we prove that the completeness of the Hamilton flow and essential self-dajointness are equivalent for real principal type operators on the circle. Moreover, we study spectral properties of these operators.




iva

Locally equivalent Floer complexes and unoriented link cobordisms. (arXiv:1911.03659v4 [math.GT] UPDATED)

We show that the local equivalence class of the collapsed link Floer complex $cCFL^infty(L)$, together with many $Upsilon$-type invariants extracted from this group, is a concordance invariant of links. In particular, we define a version of the invariants $Upsilon_L(t)$ and $ u^+(L)$ when $L$ is a link and we prove that they give a lower bound for the slice genus $g_4(L)$. Furthermore, in the last section of the paper we study the homology group $HFL'(L)$ and its behaviour under unoriented cobordisms. We obtain that a normalized version of the $upsilon$-set, introduced by Ozsv'ath, Stipsicz and Szab'o, produces a lower bound for the 4-dimensional smooth crosscap number $gamma_4(L)$.