[uticus]

@dang there are a lot of posts from "splware" / "esproc" for the last two months, all focused on how great "Esproc SPL" is. seems like using HN as advert space, against HN submission rules [0]?

2 months ago: "Show HN: It's been nearly 50 years. Is SQL outdated?" https://news.ycombinator.com/item?id=37995992

2 months ago: "Show HN: A new programming language stronger than SQL, Java, and Python?" https://news.ycombinator.com/item?id=38022746 (posted by same user 'followSPL')

~ 2 weeks ago: "Open-Source SPL Speeds Up Query on Detail Table of Group Insurance 2000 Times" https://news.ycombinator.com/item?id=38610476 (posted by different user 'JudyRabbit')

3 days ago: "EsProc SPL, a data analysis engine reducing application cost by N times" https://news.ycombinator.com/item?id=38759053 (posted by same user 'JudyRabbit')

...and now this from JudyRabbit.

[0] https://news.ycombinator.com/newsguidelines.html "Please don't use HN primarily for promotion. It's ok to post your own stuff part of the time, but the primary use of the site should be for curiosity."

[AndrewDucker → uticus]

You can't really @ people into things here. You need to email him.

[westurner]

Similar tools for running SQL queries over CSVs in Python:

- pandas.dataframe.read_csv(), dask.dataframe.read_csv(), dask_cudf.read_csv(); .read_parquet()

- DuckDB / DuckDB-WASM: https://news.ycombinator.com/item?id=36502107 https://github.com/duckdb/duckdb https://github.com/duckdb/duckdb-wasm

- sqlite-utils > "Running queries directly against CSV or JSON" https://sqlite-utils.datasette.io/en/stable/cli.html#running... and optionally datasette / datasette-lite ?csv= for a GUI: https://github.com/simonw/datasette-lite#loading-csv-data

[PartiallyTyped → westurner]

Also polars and datafusion!

[riku_iki → PartiallyTyped]

and chdb

[wruza]

https://news.ycombinator.com/submitted?id=Judyrabbit

There’s 9 recent identical/related links in your submissions in 20 days. While the desire to promote your work is understandable, HN recommends keeping repetitions low before a noticable timeout. If it doesn’t “take off” after a couple of times, it makes collective sense to wait for a few months.

(I’m a regular user, not a mod.)

[thunderbong]

Can't you just use SQLite for this?

https://www.sqlite.org/csv.html

[Judyrabbit → thunderbong]

SQLite is not a pure Java program, it requires JNI to be called by java, which is inefficient and somewhat complex. esProc SPL is a pure Java program and can be integrated in Java Application seemlessly. For Java application, esProc is more suitable. and for non-Java program, SQLite is the best.