Daten · GitHub

Supplementary Materials for the The Complete dbt (Data Build Tool) Bootcamp Udemy course

Low-level Go interface to SQLite 3

• Full SQLite functionality via modernc.org/sqlite, an automatically generated translation of the original C source code of SQLite into Go
• Builds with CGO_ENABLED=0, allowing cross-compiling and data race detection

Data processing and modelling framework for automating tasks (incl. Python & SQL transformations).

• YAML based DAG (Direct Acyclic Graph) creation. This means all analysts, including non Python proficient ones, can easily add tasks to ETL processes with SAYN.
• Automated SQL transformations: write your SELECT statement. SAYN turns it into a table/view and manages everything for you.

Lightweight analytics reporting and publishing tool for Digital Analytics Program's Google Analytics 360 data.

The US federal government's web traffic.

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

Use the Google Analytics API from R

sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.

Learning resources, blogs, news, SQL, PowerShell, SQL, Linux, Revers Engineering, Malware

AI Tool for querying natural language on tabular data.

• Supports detection from multiple csvs (csvs can also be read from Amazon s3)
• Supports FuzzyString implementation. i.e, incomplete column values in query can be automatically detected and filled in the query.

Create an example replicated + distributed dataset using Clickhouse

Interview coding questions and experiences for several companies merged into one repository

Real Intelligence Threat Analytics (RITA) is a framework for detecting command and control communication through network traffic analysis.

Curated resources to learn Data Science, including SQL, Python, Machine Learning, MLOps, and more. Features playlists, case studies, and guides to help you master core concepts and algorithms.