sqlpad vs odbc2parquet

sqlpad

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

Suggest topics

Source Code

getsqlpad.com

Suggest alternative

Edit details

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

SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App

With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

surveyjs.io

featured

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

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

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

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

What are some alternatives?

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

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

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

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

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

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

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

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

duckdb_fdw - DuckDB Foreign Data Wrapper for PostgreSQL

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

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.

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

postgres_vectorization_test - Vectorized executor to speed up PostgreSQL