Hacker News: julien040

New comment by julien040 in "Google's new pipe syntax in SQL"

julien040 — Thu, 29 Aug 2024 07:15:33 +0000

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's refreshing to use.

An example:

  StormEvents
  | where State startswith "W"
  | summarize Count=count() by State

New comment by julien040 in "Ask HN: What are you working on (August 2024)?"

julien040 — Sun, 25 Aug 2024 17:03:46 +0000

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 transform different data sources (e.g. a spreadsheet) into a SQL database with write support, but I do enjoy the journey and learn a lot from it.

[1] https://github.com/julien040/anyquery

Teach Yourself Computer Science

julien040 — Tue, 20 Aug 2024 18:34:14 +0000

Article URL: https://teachyourselfcs.com

Comments URL: https://news.ycombinator.com/item?id=41302673

Points: 3

# Comments: 0

New comment by julien040 in "Show HN: I made an open source SQL engine for anything (APIs, file) using SQLite"

julien040 — Thu, 15 Aug 2024 11:22:04 +0000

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.). Anyquery can also transform a Google Sheets or an Airtable base into a SQL database with INSERT/UPDATE/DELETE support. Additionally, it can act as a MySQL server to leverage its ecosystem (BI tools, ORMs, etc.). Finally, you can run PRQL and PQL (KQL inspired language) queries with it.

Under the hood, it uses Go and SQLite's virtual tables. Therefore, you can use the SQLite ecosystem (e.g. sqlite-vec, datasette, etc.)

I would love to hear your feedback about the project.

Website: [https://anyquery.dev/](https://anyquery.dev/docs/#installati...

Source code: https://github.com/julien040/anyquery

(I know it’s a repost. I thought that posting the previous SHOW HN during the weekend was badly timed. If you find it inappropriate, please don’t hesitate to flag the post. https://news.ycombinator.com/item?id=41203559)

Show HN: I made an open source SQL engine for anything (APIs, file) using SQLite

julien040 — Thu, 15 Aug 2024 11:21:43 +0000

Article URL: https://github.com/julien040/anyquery

Comments URL: https://news.ycombinator.com/item?id=41254778

Points: 2

# Comments: 1

New comment by julien040 in "Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)"

julien040 — Fri, 09 Aug 2024 20:57:39 +0000

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 guess it's because the landing page isn't clear enough. Thanks for the feedback, I'll try to fix that.

New comment by julien040 in "Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)"

julien040 — Fri, 09 Aug 2024 18:31:04 +0000

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 files

Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)

julien040 — Fri, 09 Aug 2024 16:59:52 +0000

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 anything.

SQL is the industry standard query language for databases. But what if it could query other services? That’s what I wanted to explore. Kinda like Yahoo! Query Language, except that I was too young to see it.

Anyquery can run queries on local/remote files (CSV, JSON, logs with Grok, Parquet, HTML tables, etc.), SaaS (GitHub, Notion, Spotify, etc.) and local apps (Apple Notes, Git, Google Chrome tabs, etc.). I’ve built 35 integrations. Anyquery can also transform a Google Sheets or an Airtable base into a SQL database with INSERT/UPDATE/DELETE support. Additionally, it can act as a MySQL server to leverage its ecosystem (BI tools, ORMs, etc.). Finally, you can run PRQL and PQL (KQL inspired language) queries with it.

Under the hood, it uses Go and SQLite's virtual tables. Therefore, you can use the SQLite ecosystem (like sqlite-vec, datasette, etc.). The project is licensed under the AGPL-v3.

Personally, I find the project useful for data migration (I’m using it to transfer my Pocket bookmarks to Raindrop) and data visualization (connecting my GitHub data to Metabase or Tableau)

I would love to hear your feedback about the project.

Website: https://anyquery.dev/docs/#installation

Source code: https://github.com/julien040/anyquery

Brief overview of the architecture: https://anyquery.dev/docs/developers/project/architecture/

Comments URL: https://news.ycombinator.com/item?id=41203559

Points: 12

# Comments: 6

New comment by julien040 in "Canada demands 5% of revenue from Netflix, Spotify, and other streamers"

julien040 — Thu, 06 Jun 2024 08:00:58 +0000

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. In the end, the government just taxes its citizens more instead of getting a bigger share of revenue from these companies.

https://newsroom.spotify.com/2024-03-07/spotify-to-adjust-it...

Open Policy Agent

julien040 — Tue, 12 Mar 2024 16:59:56 +0000

Article URL: https://www.openpolicyagent.org/

Comments URL: https://news.ycombinator.com/item?id=39681907

Points: 109

# Comments: 44

New comment by julien040 in "Dolt: A version-controlled SQL database"

julien040 — Thu, 18 Jan 2024 17:28:49 +0000

Hey, sorry. I didn't see the answer.

You have a valid point. Using a versioning field would be nicer for mods. Thank you!

New comment by julien040 in "Dolt: A version-controlled SQL database"

julien040 — Fri, 05 Jan 2024 17:10:00 +0000

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.

Dolt: A version-controlled SQL database

julien040 — Fri, 05 Jan 2024 17:04:23 +0000

Article URL: https://github.com/dolthub/dolt

Comments URL: https://news.ycombinator.com/item?id=38881425

Points: 5

# Comments: 3

New comment by julien040 in "Ask HN: Who wants to be hired? (November 2023)"

julien040 — Thu, 02 Nov 2023 19:46:47 +0000

  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é/CV: https://cdn.julienc.me/resume.pdf
  Email: contact@julienc.me

I'm a French CS student looking for an internship during the summer of 2024. I have built several projects during my freshman year:

- Gut: an alternative CLI for Git (470 stars on GitHub and made it to the HN front page)

- HN Recommend: a recommendation engine for Hacker News (also made it to the front page of HN too)

New comment by julien040 in "Ask HN: Is There a Crunchbase for Policitians?"

julien040 — Fri, 28 Jul 2023 17:56:01 +0000

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

New comment by julien040 in "Show HN: My recommendation engine for Hacker News"

julien040 — Fri, 23 Jun 2023 16:19:25 +0000

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

New comment by julien040 in "Show HN: A gallery of graphs built with React and D3.js"

julien040 — Fri, 23 Jun 2023 15:55:59 +0000

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.

New comment by julien040 in "Show HN: My recommendation engine for Hacker News"

julien040 — Thu, 22 Jun 2023 12:05:39 +0000

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.

New comment by julien040 in "Show HN: My recommendation engine for Hacker News"

julien040 — Tue, 20 Jun 2023 08:41:24 +0000

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

New comment by julien040 in "Show HN: My recommendation engine for Hacker News"

julien040 — Tue, 20 Jun 2023 08:35:38 +0000

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 if you want stories related to Go.

Edit: add link