I recently had to migrate a PostgreSQL Database to Google’s Cloud Data Warehouse Solution BigQuery. So, I had a bunch of PostgreSQL queries to convert using BigQuery Standard SQL. It was not as easy as I thought it would be.

Image by Florian Genal on ArtStation

SQL, or Structured Query Language, is the standard language for interacting with relational databases. But, as you probably know, many dialects of SQL are available depending on the database management system you’re using: PostgreSQL, MySQL, SQL Server, etc.

The first thing you should know is that BigQuery uses legacy SQL or standard SQL. You can set up a default dialect…


How the field has evolved from OpenCV to Neural Networks

Written by Jeremy Joslove & Emna Kamoun

Read the original article on Sicara’s blog here.

Image Registration is a fundamental step in Computer Vision. This article presents OpenCV feature-based methods before diving into Deep Learning.

What is Image Registration?

Image registration is the process of transforming different images of one scene into the same coordinate system. These images can be taken at different times (multi-temporal registration), by different sensors (multi-modal registration), and/or from different viewpoints. The spatial relationships between these images can be rigid (translations and rotations), affine (shears for example), homographies, or complex large deformations models.


10 data articles handpicked by the Sicara team, just for you

Welcome to the March edition of our best and favorite articles in AI that were published this month. We are a Paris-based company that does Agile data development. This month, we spotted articles about Neural Networks, Neural Architecture Search and more. We advise you to have a Python environment ready if you want to follow some tutorials :). Let’s kick off with the comic of the month:

Emna Kamoun

Working @Sicara_fr

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store