DB Tools - DBPilot to Query CSV as SQL

Easily query any CSV, JSON, and Parquet files with SQL - be it files on your machine, on S3, or available over HTTP.

PublishedMarch 16, 2023

App screenshot

DuckDB is an open-source, embeddable analytical SQL database management system designed to handle complex queries on large data sets with high performance and low latency. It is written in C++ and is designed to be lightweight, making it suitable for use in embedded systems, web applications, and data-intensive applications. DuckDB supports standard SQL and provides a range of advanced features such as columnar storage, vectorized query execution, and query optimization. It also supports various programming languages and has integrations with popular data analysis tools like Python and R.

https://www.dbpilot.io/ uses Duckdb for:

Query CSV, JSON, Parquet
Join different data formats

https://www.dbpilot.io/_app/immutable/assets/join-formats.f943a83d.mp4

Download now.
It's free!

#db-tools

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Warning: Transaction ID Wraparound Can Freeze Your PostgreSQL Server – Here's How to Prevent It

Halloween is near, but there's something scarier in your PostgreSQL server—Transaction ID wraparound.

Oct 13, 20243 min read

Better understanding of Postgres Vacuum

TLDR: I run some tests on the Vacuum command. Thought you might find it interesting. What is Vacuum in Postgres? When rows are updated or deleted in PostgreSQL, the old versions of those rows are not immediately removed from the database files. Inste...

Jun 6, 20245 min read

Monitoring PostgreSQL Activity

An SQL-Only, Agentless Solution for Tracking Database Activity

Apr 29, 20247 min read

Running SQL Commands Directly from Jupyter: The Power of %%sql

If you're a data scientist, analyst, or anyone who works with data, you've probably spent considerable time using Jupyter notebooks. These versatile tools are great for exploring, analyzing, and visualizing data, typically using Python or R. With %%s...

Apr 28, 20243 min read

Running SQL Commands Directly from Jupyter: The Power of %%sql

DB Tools - Azimutt is an Open Source DB Schema Tool

Search on tables, columns, relations and comments. Display only what is useful. Follow relations. Find paths between tables. Design. Document. Analyse. Open Source: Yes, MIT Free Edition: Yes Main Features How to keep a high quality database? Scalin...

Apr 24, 20241 min read

DB Tools - Azimutt is an Open Source DB Schema Tool

Metis

48 posts

CTO of Metis (https://www.metisdata.io/) - We built a database observability platform that developers love. From development to production, Metis covers all your database needs.

Command Palette

Comments

More from this blog