Viewing profile — julien040

I haven't seen it mentioned yet, but it reminds me of PQL (not PRQL): https://pql.dev It's inspired by Kusto and available as an open-source CLI. I've made it compatible with SQLit…

I'm trying to push the boundaries of SQL by building Anyquery[1]. It's a SQL query engine that allows you to run queries on anything (GitHub, Todoist, Parquet, Google Sheets, logs,…

Hey HN, I’m Julien, a CS student, and I built anyquery, a SQL query engine for pretty much anything. Anyquery can run SQL queries on local/remote files (CSV, JSON, Parquet, HTML, e…

Hey Breck, I'm not sure you understood properly what Anyquery is. It's a CLI to run SQL queries on "anything" (APIs mostly and files). Therefore, it's hard to provide a version wit…

Thanks! For querying CSV, it's quite similar to DuckDB (just a little bit slower). It's almost the same syntax (read_csv table, same parameter name, etc.) I think anyquery strength…

Hey HN, I’m Julien, and after finishing my CS sophomore year, I wanted a project to keep me busy during the summer. So I built anyquery for fun, a SQL query engine for pretty much …

France did something like that last month. To support the "Centre national de la musique", a new 1.2% tax was added on digital music streaming services. But rather than absorbing t…

Hey, sorry. I didn't see the answer. You have a valid point. Using a versioning field would be nicer for mods. Thank you!

I was searching for solutions to create a public collaborative tool, similar to Wikipedia, when I came across this database. I need version control and easy rollback for the modera…

Location: Europe Remote: Office / Hybrid / Remote Willing to relocate: I'm willing to relocate in Europe or North America Technologies: I'm fluent with TypeScript, React, Python, S…

Long time ago, I saw this project: https://github.com/everypolitician/everypolitician-data I haven't used it, so I don't know about the quality of the data

It's fixed now. Thank you for reporting it.

This is awesome! I have always wanted to learn about D3.js, but I've never really started. I hope these well-made examples will help. Thank you for creating this.

It's pure speculation, but articles embeddings are computed using 512 tokens, which is roughly equivalent to 400 words. I think that using only one word does not allow the model to…

It's very interesting. I may try it in the future.

Oops, on the API side, there is a check to ensure the text is long enough (5 characters), but I forgot to add this check client-side. Thank you for pointing out the issue. Try this…

Thank you for reading it. The hit rate is low. I've only tried to get embeddings for stories with a score greater than 100. SQL Query "SELECT count(*) FROM story WHERE score > 100;…

Hi, are you talking about a problem like this one? https://cln.sh/MFG3DPZn+

Yes it's an issue. Sadly, I can't fix it. I'm using the closed source "text-embedding-ada-002" model from OpenAI. As I can see, the longer the input, the more accurate the results.…

Here is the v1 of the shortcut: https://www.icloud.com/shortcuts/a7e9d236b35342c5aed1d022801... For now, it only pushes the shared URL to the recommendation engine. If I have more …