IBM et Holcim France Benelux annoncent la migration vers Windows 7 des postes de travail de 2500 utilisateurs sur 286 sites en seulement trois mois grâce au savoir-faire d’IBM Global Technology Services.

It may be tempting at the start of a new project to create the first database tables manually, or write SQL scripts that you run manually, especially when you first have to spend a significant amount of time on sifting through all the migration libraries and then some more to get it working properly.

Going through this process did slow me down at the start of the project but I was determined to use a migration tool because hunting inexplicable bugs that only happen in production just to find out there is a definition mismatch between the production and development databases is not fun. Using such a tool also motivates you to write both the setup and teardown steps for each table while the current design is still fresh in your mind.

At first I considered a standalone migration tool because I expect them to be very good at that single task. However, learning the idiosyncrasies of a new tool and trying to make it fit seamlessly into my development workflow seemed like more trouble than it is worth.

I decided to stick with a Common Lisp library and found the following seven that work with PostgreSQL and/or Postmodern:

• Postmodern-passenger-pigeon
• database-migrations
• cl-migrations
• Mito
• Crane
• Orizuru-orm
• cl-mgr

I quickly discounted Crane and Mito because they are ORM (Object Relational Mapper) libraries which are way more complex than a dedicated migration library. Development on Crane have stalled some time ago and I don't feel it is mature enough for frictionless use yet. Mito declares itself as being in Alpha state; also not mature enough yet.

I only stumbled onto cl-mgr and Orizuru-orm long after making my decision so I did not investigate them seriously. Orizuru-orm is in any case an ORM which I would have discounted because it is too complex for my needs. CL-mgr looks simple, which is a good thing. It is based on cl-dbi which makes it a good candidate if you foresee switching databases but even if I discovered it sooner I would have discounted it for the same reason as CL-migrations.

CL-migrations looks very promising. It is a simple library focusing only on migrations. It uses clsql to interface with the database which bothered me because I already committed to using Postmodern and I try to avoid adding a lot of unused code to my projects. The positive side is that it interfaces to many different databases so it is a good candidate if you are not committed to using Postmodern. It is also a stable code base with no outstanding bug reports.

The two projects I focused on was Postmodern-passenger-pigeon and Database-migrations because they both use Postmodern for a database interface.

Postmodern-passenger-pigeon was in active development at the time and it seemed safer to use than Database-migrations because it can do dry runs, which is a very nice feature when you are upgrading your production database and face the possibility of losing data when things go awry. Unfortunately I could not get it working within a reasonable amount of time.

I finally settled on Database-migrations. It is a small code base, focused on one task, it is mature and it uses Postmodern so it does not pull in a whole new database interface into my project. There are however some less positive issues.

The first issue is a hindrance during development. Every time the migrations ASDF system (or the file containing it, as ASDF prefers that all systems be defined in a single file) is recompiled it adds all the defined migrations to the migrations list. Though each one will only be applied once to the DB it is still bothersome. One can then clear the list with (setf database-migrations::*migrations* nil) but then only newly modified migration files will be added. The solution then is to touch the .asd file after clearing the migrations list.

The second negative point is quite dangerous. The downgrade function takes a target version as parameter, with a default target of 0. This means that if you execute downgrade without specifying a target version you delete your whole database.

I am currently using Database-migrations and it works well for me. If for some reason I need to switch I will use cl-migrations.

Using Database-migrations

To address the danger of unintentionally deleting my database I created a wrapper function that does both upgrade and downgrade, and it requires a target version number.

Another practical issue I discovered is that upgrades and downgrades happen in the same order as they are defined in the migration file. If you create two tables in a single file where table 2 depends on table 1 then you can not revert / downgrade because Database-migrations will attempt to delete table 1 before table 2. The solution here is to use the def-queries-migration macro (instead of def-query-migration) which defines multiple queries simultaneously . If you get overwhelmed by a single definition that defines multiple tables the other option is to stick with one migration definition per file.

As physicians who work in New York City hospitals, we are witnessing how COVID-19 is ravaging the communities we serve. The only way to slow this pandemic is to stop the transmission of the disease. Yet despite everything we know about how the virus spreads and the unprecedented sacrifices workers have made to slow the spread, Immigration and Customs Enforcement (ICE) continues to endanger the lives of over 40,000 immigrants in more than 200 jails and prisons nationally. Most people in immigration detention have committed no criminal offense and have been deemed by ICE to pose no danger, yet they are held arbitrarily pending disposition of their asylum claims or deportation orders.

We show a causal impact of immigration on innovation and dynamism in US counties. To identify the causal impact of immigration, we use 130 years of detailed data on migrations from foreign countries to US counties to isolate quasi-random variation in the ancestry composition of US counties that results purely from the interaction of two historical forces: (i) changes over time in the relative attractiveness of different destinations within the US to the average migrant arriving at the time and (ii) the staggered timing of the arrival of migrants from different origin countries. We then use this plausibly exogenous variation in ancestry composition to predict the total number of migrants flowing into each US county in recent decades. We show four main results. First, immigration has a positive impact on innovation, measured by the patenting of local firms. Second, immigration has a positive impact on measures of local economic dynamism. Third, the positive impact of immigration on innovation percolates over space, but spatial spillovers quickly die out with distance. Fourth, the impact of immigration on innovation is stronger for more educated migrants.

Delays during migration can imperil birds’ chances of a successful breeding season.

The Trump coronavirus immigration order shows he has yet to find a crisis he can't try to exploit for his own political gain.

The Los Angeles Times has announced new guidelines for covering immigration.

Three billion trips to be made during Spring Harvest

Directed by Alex Rivera and Cristina Ibarra, "The Infiltrators" is a mix of documentary footage and staged fiction scenes to tell the story of undocumented young immigration activists taking their work inside a Florida detention facility.

FOLLOWING the Windrush scandal the NHS says that its records will no longer be used to track down illegal immigrants.

THE summer that just keeps giving had the swallows all in a flutter last week. On the south coast of the Isle of Wight hundreds streamed past me and my family as we walked over the downs, enchanted by dart-like birds racing over the white cliffs and the green sward. Yet they were flying north-east instead of south towards Africa. Some were even coming in from the sea instead of heading out over the Channel.

Our customer in New York City is looking for an engineer to migrate their entire infrastructure from Lotus Note 8.5 to Windows Office 365. The project is expected to last at least 6 months. The right candidate must have experience performing Windows Office 365 migrations at an enterprise level, m

There are Covid-19 outbreaks in supply-strapped detention centres across the US.

The native of Barbados apparently doesn't like Trump's immigration policies.

Sadly, the most recent horrors are not an aberration.

Trump has gutted the asylum system that grew in part out of our shame over our heartless refugee policies in the 1930s.

Immigration does touch on many other policy issues, though maybe not in the manner he suggests.

He just took out two birds with one proclamation.

The president and his team of unelected bureaucrats have siphoned power away from the legislature.

The administration has cracked down on all migrants, even those with the most to contribute.

America only benefits from U.S.-trained scientists.

The U.S. has deported an average of 403,500 people each year during the Obama administration. What else do the numbers say about the nation's immigration system?

Unless the Supreme Court acts fast, the window might be closed for President Obama on immigration reform.

Research Event

Ambassador Arturo Sarukhan, Associate Fellow, US and the Americas Programme, Chatham House; Mexican Ambassador to the US, 2007 - 13
Professor Anita Isaacs, Benjamin R. Collins Professor of Social Sciences, Haverford College
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

Invitation Only Research Event

Event participants

Anita Isaacs, Professor of Political Science, Haverford College; Co-Director, Migration Encounters Project
Juan Ricardo Ortega, Principal Advisor for Central America, Inter-American Development Bank
Chair: Amy Pope, Associate Fellow, Chatham House; US Deputy Homeland Security Adviser for the Obama Administration (2015-17)

Invitation Only Research Event

Event participants

Jude Webber, Mexico and Central America Correspondent, Financial Times
Michael Stott, Latin America Editor, Financial Times
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

Research Event

Ambassador Arturo Sarukhan, Associate Fellow, US and the Americas Programme, Chatham House; Mexican Ambassador to the US, 2007 - 13
Professor Anita Isaacs, Benjamin R. Collins Professor of Social Sciences, Haverford College
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

Research Event

Ambassador Arturo Sarukhan, Associate Fellow, US and the Americas Programme, Chatham House; Mexican Ambassador to the US, 2007 - 13
Professor Anita Isaacs, Benjamin R. Collins Professor of Social Sciences, Haverford College
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

The government has unveiled its new points-based immigration system, due to come into force in 2021, we break down what it means for the UK startup sector

The Immigration Department today announced that aside from its Smart Identity Card Replacement Centres (SIDCC) service and passenger immigration clearance service, it will resume full public services on May 4.

Due to the COVID-19 epidemic, the services of the nine SIDCCs had been suspended earlier.

Around 640,000 people could not replace their Hong Kong identity cards during their specified periods and about 90,000 people are waiting to collect their new identity cards.

To allow affected people to apply for and collect identity cards in an orderly manner, the SIDCCs will first provide identity card collection service and arrange applicants born in 1957 to 1961 who had made appointments before to have their cards replaced once the service resumes.

Other applicants are advised to make appointments to replace their identity cards if they have not done so before.

The department plans to revise designated replacement periods for identity card holders born in 1957 to 1963 and between 1970 and 1976.

Details will be announced later. For enquiries regarding identity cards, call 3521 6565.

Additionally, passenger immigration clearance services at immigration control points except for the Hong Kong International Airport, Shenzhen Bay and Hong Kong-Zhuhai-Macao Bridge Control Points will remain suspended until further notice.

Call 2824 6111 or send an email for enquiries.

(University of Science and Technology of China) Researchers from University of science and technology of China has shed new lights on the topic of solid-phase ion migration. Researchers demonstrated a unique in-situ strategy for visualizing the dynamic solid-phase ion migration between nanostructures with nanogap at the atomic scale. The research article entitled "Real-Time Visualization of Solid-Phase Ion Migration Kinetics on Nanowire Monolayer" was published in Journal of the American Chemical Society on April 29th.

13 April 2018

Invitation Only Research Event

Tumor cells can spread to distant sites through their ability to switch between mesenchymal and amoeboid (bleb-based) migration. Because of this difference, inhibitors of metastasis must account for each migration mode. However, the role of vimentin in amoeboid migration has not been determined. Because amoeboid leader bleb–based migration (LBBM) occurs in confined spaces and vimentin is known to strongly influence cell-mechanical properties, we hypothesized that a flexible vimentin network is required for fast amoeboid migration. To this end, here we determined the precise role of the vimentin intermediate filament system in regulating the migration of amoeboid human cancer cells. Vimentin is a classic marker of epithelial-to-mesenchymal transition and is therefore an ideal target for a metastasis inhibitor. Using a previously developed polydimethylsiloxane slab–based approach to confine cells, RNAi-based vimentin silencing, vimentin overexpression, pharmacological treatments, and measurements of cell stiffness, we found that RNAi-mediated depletion of vimentin increases LBBM by ∼50% compared with control cells and that vimentin overexpression and simvastatin-induced vimentin bundling inhibit fast amoeboid migration and proliferation. Importantly, these effects were independent of changes in actomyosin contractility. Our results indicate that a flexible vimentin intermediate filament network promotes LBBM of amoeboid cancer cells in confined environments and that vimentin bundling perturbs cell-mechanical properties and inhibits the invasive properties of cancer cells.

Invitation Only Research Event

Event participants

Anita Isaacs, Professor of Political Science, Haverford College; Co-Director, Migration Encounters Project
Juan Ricardo Ortega, Principal Advisor for Central America, Inter-American Development Bank
Chair: Amy Pope, Associate Fellow, Chatham House; US Deputy Homeland Security Adviser for the Obama Administration (2015-17)

Invitation Only Research Event

Event participants

Jude Webber, Mexico and Central America Correspondent, Financial Times
Michael Stott, Latin America Editor, Financial Times
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

Research Event

Ambassador Arturo Sarukhan, Associate Fellow, US and the Americas Programme, Chatham House; Mexican Ambassador to the US, 2007 - 13
Professor Anita Isaacs, Benjamin R. Collins Professor of Social Sciences, Haverford College
Chair: Dr Christopher Sabatini, Senior Research Fellow for Latin America, US and the Americas Programme, Chatham House

However well intentioned, working in detention centres amounts to complicity in torture, says David Berger, a district medical officer in emergency medicine at Broome Hospital in Australia. However, Steven Miles, chair in bioethics at the University of Minnesota thinks that they play an important role in telling the world about conditions in...

Worldwide, the rate of type II diabetes is estimated to be around 1 in 11 people - about 9%. For the Pima people of Arizona, 38% of the adult population have the condition - but across the border in Mexico, the rate drops down to 7%. The difference between the groups is their life experience - one side displaced, the other on their traditional...

A discussion marking the 25th anniversary of the 1990 Immigration Act, where experts examinine the history of the legislation, how it was accomplished politically, and the stakeholders and issues that were critical to its passage.

With issues of immigration policy very much at the forefront of the 2016 elections, this annual conference offers policy and legal analysis on key immigration topics facing the country and the incoming administration and Congress in 2017.

The 13th annual Immigration Law & Policy Conference offered policy and legal analysis on key immigration topics, including: the election and the future of immigration policy; refugee resettlement in the United States; immigration detention and enforcement; and the impacts of the Supreme Court opinion in the important U.S. vs Texas case

With immigration increasingly visible in the news and the political space in the United States and internationally, getting access to accurate, high-quality data is essential to understand immigration’s demographic effects and impacts on the economy, education and labor systems, and communities. This event marks the release of the Immigration Data Matters guide.

As policymakers in a number of countries, the United States among them, debate limiting family-based immigration, this issue brief explores family-migration trends and policies in the United States, Australia, Canada, the United Kingdom, and several other European countries. Family admissions play a key role, even in countries that prioritize economic or other immigration streams.

Where can you find the most accurate statistics on some of the top immigration issues—ranging from the size of immigrant and emigrant populations, to humanitarian and labor flows, naturalization rates, enforcement statistics, remittances, and more? In this brief video, Jeanne Batalova, who manages the Migration Policy Institute’s Migration Data Hub, walks you through the Immigration Data Matters guide developed by MPI and the Population Reference Bureau.