julien040

11 ms·

1.
by julien040 2y ago
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 SQLite in one of my tools, and it&#x27
2.
by julien040 2y ago
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, emails, etc.) It's mental gymnastics to tran
3.
Teach Yourself Computer Science(teachyourselfcs.com)
3 points by julien040 2y ago|0 comments
4.
by julien040 2y ago
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, etc.) and SaaS (GitHub, Notion, TodoIst, Shopify, etc.).
5.
Show HN: I made an open source SQL engine for anything (APIs, file) using SQLite(github.com)
2 points by julien040 2y ago|1 comments
6.
by julien040 2y ago
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 without downloading anything. But I gu
7.
by julien040 2y ago
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 rather comes from querying things other than file
8.
Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)(anyquery.dev)
12 points by julien040 2y ago|6 comments
9.
by julien040 2y ago
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 the cost, Spotify just raised its subscription cost
10.
Open Policy Agent(openpolicyagent.org)
109 points by julien040 3y ago|44 comments
11.
by julien040 3y ago
Hey, sorry. I didn't see the answer. You have a valid point. Using a versioning field would be nicer for mods. Thank you!
12.
by julien040 3y ago
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 moderation team. Dolt seems to be a great fit for this purpose.
13.
Dolt: A version-controlled SQL database(github.com)
5 points by julien040 3y ago|3 comments
14.
by julien040 3y ago
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, SQL and Golang Résumé/C
15.
by julien040 3y ago
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
16.
by julien040 3y ago
It's fixed now. Thank you for reporting it.
17.
by julien040 3y ago
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.
18.
by julien040 3y ago
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 fully understand the context.
19.
by julien040 3y ago
It's very interesting. I may try it in the future.
20.
by julien040 3y ago
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 https://hn-recommend.julienc.me/?q=Golang
21.
by julien040 3y ago
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;" gives me 155,228 stories and the corpus
22.
by julien040 3y ago
Hi, are you talking about a problem like this one? https://cln.sh/MFG3DPZn+
23.
by julien040 3y ago
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. Perhaps you can try something long
24.
by julien040 3y ago
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 time, I'll try to find a way to
25.
by julien040 3y ago
Are iOS share widgets using Apple Shortcuts? I wish to learn more about this technology, so it would be a pleasure to try building it.
26.
by julien040 3y ago
Thank you for suggesting this. The API is already made and can be found at https://github.com/julien040/hn-recommendation-api . I don't think it would be too difficult to build a Chrome extension that fetches it.
27.
by julien040 3y ago
I thought about an algorithm with weight adjustable by the user. Now, the API returns a field with the distance between the post and the query (the square of the Euclidean distance). It's used by the interface to rank results by relev
28.
by julien040 3y ago
The website features only stories with a score greater than 100 but I don't think that is the problem. Unlike HN Algolia, it doesn't match words; it uses embeddings so stories are matched by their similar meaning rather than simil
29.
by julien040 3y ago
I didn't try Doc2Vec. I wanted a hosted solution because I wouldn't have been able to compute all this locally (more than 100,000 posts). If you tried it, did you have great results with? I may use it in future projects.
30.
by julien040 3y ago
I'm a bit divided on this feature. On one hand, I would like to have this feature; it would be awesome to see the recommendation of people from different jobs. On the other hand, I'm a bit concerned about privacy. The system must

More ›