Frank Contrepois

Category: tech

How to create a multi-line string in JavaScript (and Observable)

Posted:   |   Categories: tech

While this post is triggered by working with Observable the solution works for Javascript ES6+. I use Observable to connect to the AWS pricing data, stored on a PostgreSQL instance on AWS. So far so good, Observable allows for easy connection to databases. When trying to write the code to query the database from Javascript data = db.query("SELECT * FROM amazonec2 LIMIT 10 ") I would get the error message “Unterminated string constant”. Read more...

How to get today and yesterday in PosgreSQL

Posted:   |   Categories: tech

Very useful dates functions for PostgreSQL. The official documentation is here. Getting the current date and time SELECT NOW() Getting the current day, no time SELECT date_trunc('day', NOW())::date; One hour later SELECT (NOW() + interval '1 hour') AS one_hour_later; One day later SELECT NOW()+1 The day before SELECT NOW()-1 For more complex calculations you can use intervals For example: SELECT (NOW() + interval '1 day') AS now_but_tomorrow; Other articles for databases geeks Using Athena from the AWS CLI on Linux Getting today in Athena Getting today in PostgreSQL How to get the metadata of AWS Athena tables Get the number of columns in an AWS Athena table Read more...

When to choose Cloud SQL and when to choose Spanner in Google Cloud

Posted:   |   Categories: tech

One of the most challenging parts of using the cloud is to choose the right product. Often, the cloud vendors, in this case, Google Cloud, will provide two or more services that seem to provide exactly the same functionalities. Cloud SQL and Cloud Spanner are in that category. Both services allow to store and interrogate data with SQL, both are fully managed, and both provide ACID transactions – no drugs involved. Read more...

learning in public - Google Cloud -Professional Cloud Architect

Posted:   |   Categories: tech

I will be learning in public, my notes - few for now but more to come - are available here Now with the following documentation Cloud resource hierarchy Steaming API Dataflow Pub/Sub Google Cloud Compute Engine - VMs Google Kubernetes Engine Google Operations Suite (formerly Stackdriver) Cloud Storage Deployment manager Cloud Shell Transfer Appliance Spinnaker Cloud Logging Cloud Monitoring Anthos [Cloud Run](https://zt.frankcontrepois.com/Left-side/Certifications/Google+-+Professional+Cloud+Architect/Anthos#Cloud Run) App Engine Cloud Functions Databases Cloud SQL - relational Cloud Spanner 30TB+ SQL Big Table - wide column Cloud Firestore - document BigQuery - analytics Read more...