odbc2parquet vs sqlpad

odbc2parquet

A command line tool to query an ODBC data source and write the result into a parquet file. (by pacman82)

Odbc Parquet

Source Code

Suggest alternative

Edit details

sqlpad

Web-based SQL editor. Legacy project in maintenance mode. (by sqlpad)

Suggest topics

Source Code

getsqlpad.com

Suggest alternative

Edit details

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

odbc2parquet		sqlpad
	Project
5	Mentions	2
206	Stars	4,986
-	Growth	0.4%
9.3	Activity	7.6
1 day ago	Latest Commit	8 days ago
Rust	Language	JavaScript
MIT License	License	MIT 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.

odbc2parquet

Posts with mentions or reviews of odbc2parquet. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-05-03.

Postgres and Parquet in the Data Lke
7 projects | news.ycombinator.com | 3 May 2022
MySQL table data to direct parquet output
1 project | /r/dataengineering | 14 Apr 2022

Although, I found a GitHub page (odbc2parquet) which can export the table (also a query output) to parquet.
Parquet best practices
2 projects | /r/dataengineering | 11 Feb 2022

Is this a one-time task? Maybe check out ODBC2PARQUET https://github.com/pacman82/odbc2parquet
Thoughts on Using Airbyte to read/write to S3?
1 project | /r/dataengineering | 31 Jan 2022

I tried writing parquet to s3 with Airbyte a few months ago and gave up. It was extremely slow for small tables and would not work at all for larger tables. I wound up using this https://github.com/pacman82/odbc2parquet + aws cli
Extract data from ERP systems to Snowflake - Which tools (besides Airbyte)?
1 project | /r/dataengineering | 26 Jan 2022

Yes, I have been tinkering around with odbc2parquet (https://github.com/pacman82/odbc2parquet) and storing it in a variant column. For the dependency/workflow management maybe prefect

sqlpad

Posts with mentions or reviews of sqlpad. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-11-07.

Show HN: Slashbase – open-source collaborative IDE for databases in browser
5 projects | news.ycombinator.com | 7 Nov 2022

Hey!
Just a few weeks ago I was searching for such a solution (IDE for databases in browsers without viz) and I found a bit old but still very good and simple to use project https://github.com/sqlpad/sqlpad/
Is there any web based sql query tools to replace Hue？
1 project | /r/bigdata | 7 Dec 2021

What are some alternatives?

When comparing odbc2parquet and sqlpad you can also consider the following projects:

sql-spark-connector - Apache Spark Connector for SQL Server and Azure SQL

jitsu - Jitsu is an open-source Segment alternative. Fully-scriptable data ingestion engine for modern data teams. Set-up a real-time data pipeline in minutes, not days

roapi - Create full-fledged APIs for slowly moving datasets without writing a single line of code.

xgenecloud - XgeneCloud is now https://github.com/nocodb/nocodb

geoparquet - Specification for storing geospatial vector data (point, line, polygon) in Parquet

mlcraft - Synmetrix – open source semantic layer / Boost your LLM precision

duckdb_fdw - DuckDB Foreign Data Wrapper for PostgreSQL

Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

FreeSql - 🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.

Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

postgres_vectorization_test - Vectorized executor to speed up PostgreSQL

dekart - WebGL-powered map analytics for BigQuery and Snowflake. Lightweight alternative to CARTO and Foursquare Studio for data scientists, analysts and engineers.