Skytrax-Data-Warehouse VS dbd

Compare Skytrax-Data-Warehouse vs dbd and see what are their differences.

Skytrax-Data-Warehouse

A full data warehouse infrastructure with ETL pipelines running inside docker on Apache Airflow for data orchestration, AWS Redshift for cloud data warehouse and Metabase to serve the needs of data visualizations such as analytical dashboards. (by iam-mhaseeb)

dbd

dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases. (by zsvoboda)
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
Skytrax-Data-Warehouse dbd
1 4
131 55
- -
0.0 0.0
about 4 years ago about 2 years ago
Python Python
MIT License BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

Skytrax-Data-Warehouse

Posts with mentions or reviews of Skytrax-Data-Warehouse. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-04-16.
  • Open source contributions for a Data Engineer?
    17 projects | /r/dataengineering | 16 Apr 2021
    Always open to accept contributions to my project (Skytrax Data Warehouse). If you are into data stuff support my work at youtube as well (One Developer Pirate), I mostly make data-oriented videos. These days I'm making a SQL course from a data analysis perspective that is expected to release in next week.

dbd

Posts with mentions or reviews of dbd. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-23.
  • Easy loading Kaggle dataset to a database
    2 projects | /r/datascience | 23 Jan 2022
    I've created two examples of how to use the dbd tool to load Kaggle dataset data files (csv, json, xls, parquet) to your Postgres, MySQL, or SQLite database.Basically, you don't have to create any tables, nor run any SQL INSERT or COPY statements. Everything is automated. You just reference the datasets and files with a URL and execute a 'dbd run' command.The examples are here. Perhaps you find it useful. Let me know, what you think!
  • Easy loading dataset files to a database
    2 projects | /r/kaggle | 23 Jan 2022
    I've created two examples of how to use the [dbd](https://github.com/zsvoboda/dbd) tool to load Kaggle dataset data files (csv, json, xls, parquet) to your Postgres, MySQL, or SQLite database.
  • dbd: create your database from data files on your directory
    1 project | /r/SQL | 15 Jan 2022
    I work on the new open-sourced tool called dbd that enables you to load data from your local data files to your database and transform it using insert-from-select statements. The tool supports templating (Jinja2). It works with Postgres, MySQL, SQLite, Snowflake, Redshift, and BigQuery.
  • New opensource ELT tool
    1 project | /r/dataengineering | 9 Jan 2022
    I was looking for some declarative ELT tool for creating my analytics solutions, and DBT was the closest I've found. I liked its concept, but I came across quite a few limitations when I wanted to use it. I couldn't specify and create basic things like data types, indexes, primary/foreign keys, etc. In the end, I decided to implement my own - more straightforward and more flexible. I've published the result - dbd on GitHub. Perhaps, you can find it helpful. Your feedback is greatly appreciated!

What are some alternatives?

When comparing Skytrax-Data-Warehouse and dbd you can also consider the following projects:

sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

ethereum-etl - Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ

jaydebeapi - JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

pgsync - Postgres to Elasticsearch/OpenSearch sync

dbt-spotify-analytics - Containerized end-to-end analytics of Spotify data using Python, dbt, Postgres, and Metabase

data-toolset - Upgrade from avro-tools and parquet-tools jars to a more user-friendly Python package.

airflow-api-tests - This is a collection of Pytest for the 2.0 Stable Rest Apis for Apache Airflow. I have another repo where you could setup airflow locally and play around with these. I am used to RestAssured, but trying out pytest here.

api - Moved to https://github.com/covid19india/data/

dagster - An orchestration platform for the development, production, and observation of data assets.

sqlmesh - Efficient data transformation and modeling framework that is backwards compatible with dbt.

DataGristle - Tough and flexible tools for data analysis, transformation, validation and movement.

pydwt - Modeling tool like DBT to use SQL Alchemy core with a DataFrame interface like