stream-read-ods vs sqljs

stream-read-ods

Python function to extract data from an ODS spreadsheet on the fly - without having to store the entire file in memory or disk (by uktrade)

data-infrastructure deet

Source Code

Suggest alternative

Edit details

sqljs

Experiments with sqlite databases in javascript (by dunhamsteve)

Suggest topics

Source Code

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

stream-read-ods		sqljs
	Project
2	Mentions	1
1	Stars	0
-	Growth	-
4.4	Activity	2.1
9 months ago	Latest Commit	about 1 year ago
Python	Language	TypeScript
MIT License	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.

stream-read-ods

Posts with mentions or reviews of stream-read-ods. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-09-18.

What If OpenDocument Used SQLite?
8 projects | news.ycombinator.com | 18 Sep 2023

Shameless plug of a couple of Python libraries I’ve been involved with that work around memory issues of ODS files (for very specific use cases):
https://github.com/uktrade/stream-read-ods
Show HN: stream-read-ods – Read OpenDocument spreadsheets on the fly in Python
1 project | news.ycombinator.com | 8 Oct 2022

sqljs

Posts with mentions or reviews of sqljs. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-09-18.

What If OpenDocument Used SQLite?
8 projects | news.ycombinator.com | 18 Sep 2023

It's interesting that this is a classroom assignment, like the sibling comment, I'd curious which university / class this was. I did the read part (+ query planning) on my own as an exercise, but I haven't gotten around to implementing writing yet.
You do need to parse DDL to get the column names, they're stored as a "CREATE TABLE" string. But you don't have to if you want to dump the file without names.
https://github.com/dunhamsteve/sqljs

What are some alternatives?

When comparing stream-read-ods and sqljs you can also consider the following projects:

sqlitefs - sqlite as a filesystem for golang apps

stream-write-ods - Python function to construct an ODS spreadsheet on the fly - without having to store the entire file in memory or disk

stream-sqlite - Python function to extract rows from a SQLite file while iterating over its bytes

wuffs - Wrangling Untrusted File Formats Safely

amazon-rds-user-guide - The open source version of the Amazon RDS docs. You can submit feedback & requests for changes by submitting issues in this repo or by making proposed changes & submitting a pull request.

sqlitefs - sqlite as a filesystem

absurd-sql - sqlite3 in ur indexeddb (hopefully a better backend soon)