It seems reasonable to compare these options based on several different properties: setup time (low is better), approach (serverless is better), involved resources (few is better), costs estimate (low is better) and new code possibly required (none is better).
Over the past two years I had the chance to read a bunch of data-related books on the O'Reilly learning platform: what follows is a collection of quotes from "Fluent Python, 2nd Edition" by Luciano Ramalho that captured my attention or hit hard because they were highly relatable.
Over the past two years I had the chance to read a bunch of data-related books on the O'Reilly learning platform: what follows is a collection of quotes from "Robust Python" by Patrick Viafore that captured my attention or hit hard because they were highly relatable.
Over the past two years I had the chance to read a bunch of data-related books on the O'Reilly learning platform: what follows is a collection of quotes from "Tidy First?" by Kent Beck that captured my attention or hit hard because they were highly relatable.
Se si usano window functions (es. LAG) per calcolare delta tra timestamp Unix, il risultato "ignora" eventuali switch di ora legale/solare (correttamente, dato che un timestamp Unix conta esclusivamente il tempo che scorre).
Nell'utilizzo avanzato di AWS CDK, si realizza prima o poi l'esigenza di centralizzare alcune logiche e risorse in maniera da poterle riutilizzare in maniera rapida, riducendo il codice boilerplate.
Anche se una prima analisi potrebbe suggerire che la soluzione sia l'implementazione di una "casalinga" factory - pythonica sì, ma non conforme alle best practices di CDK - la risposta probabilmente più corretta potrebbe riguardare l'implementazione di un costrutto L3, descritto come:
designed to help you complete common tasks in AWS, often involving multiple kinds of resources.
Relational: data are stored in tabular form (rows and columns), where each row represents a unique record. Tables can be put in relation with each other through joins and queried via SQL;
Key-value: non-relational database where each record stored as a unique key with its associated value, resembling a dictionary-like structure;
Document: semi-structured and hierarchical databases for catalogs and content management systems, often stored as JSON;
Graph: the way the data are stored is graph-based, with nodes and edges connecting each data source with the others;
Time-series: database optimized for records which indices are timestamps.