From Shell to Excel – with a little bit of HTTPS
csvbase is an open-source web database that allows users to manage data via HTTP requests, supporting formats like Parquet and XLSX, and prioritizing ease of use and compatibility.
Read original article
csvbase is an open-source web database that allows users to create and manage tables via simple HTTP requests. Users can interact with the database using standard HTTP verbs: GET retrieves tables, PUT uploads CSV files, DELETE removes tables, and POST appends data. The service is designed to be straightforward, requiring no API keys for basic operations. Users can upload data using a command line tool like curl, and each table is accessible via a unique URL. csvbase supports various data formats, including Parquet and XLSX, making it compatible with popular data analysis tools like DuckDB and Microsoft Excel. Users can easily import csvbase tables into Excel, leveraging features like Power Query for data updates. While csvbase does not aim to provide advanced data analysis features, it focuses on compatibility with existing tools rather than creating new ones. The platform encourages users to run their own instances if they prefer not to use the hosted service. Overall, csvbase offers a simple and effective solution for managing data online without the complexities of more advanced databases.
- csvbase is an open-source web database that uses simple HTTP requests for data management.
- Users can upload, retrieve, and delete tables using standard HTTP verbs.
- The platform supports various data formats, including Parquet and XLSX, for compatibility with tools like DuckDB and Excel.
- csvbase prioritizes ease of use and compatibility over advanced data analysis features.
- Users can run their own instances of csvbase if they prefer not to use the hosted version.
Related
TinyBase v5: CRDTs for the rest of us
TinyBase is a versatile reactive data store for local-first apps, featuring data listening, synchronization, local storage, and schema support. It offers tools for key-value stores, tabular data, React integration, and complex queries.
Show HN: Dropbase AI – A Prompt-Based Python Web App Builder
Dropbase is a Python web app builder for fast development with AI. Features include custom logic, UI components, self-hosting, PyPI support, and demos for order search and chart usage. Setup involves Docker installation and API key addition. Visit Dropbase website for details.
I built a vector embedding database in Go for learning purposes
VecDB is a vector embedding database for educational and production use, utilizing a key-value model for vector storage, supporting raw vector and text embedding operations, with customizable server configuration.
Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Anyquery is a command-line tool for executing SQL queries across various data sources, supporting multiple operating systems and formats, with features for data integration and open-source licensing under AGPL v3.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.
2 commentsRepo for both the site and the 'database':
https://github.com/calpaterson/csvbase
And this is example client:
Related
TinyBase v5: CRDTs for the rest of us
TinyBase is a versatile reactive data store for local-first apps, featuring data listening, synchronization, local storage, and schema support. It offers tools for key-value stores, tabular data, React integration, and complex queries.
Show HN: Dropbase AI – A Prompt-Based Python Web App Builder
Dropbase is a Python web app builder for fast development with AI. Features include custom logic, UI components, self-hosting, PyPI support, and demos for order search and chart usage. Setup involves Docker installation and API key addition. Visit Dropbase website for details.
I built a vector embedding database in Go for learning purposes
VecDB is a vector embedding database for educational and production use, utilizing a key-value model for vector storage, supporting raw vector and text embedding operations, with customizable server configuration.
Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Anyquery is a command-line tool for executing SQL queries across various data sources, supporting multiple operating systems and formats, with features for data integration and open-source licensing under AGPL v3.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.