Alternatives
Products that do what Fun with SQL inside Excel does
I've built a plugin for Excel that lets you use SQL inside Excel. Here are two demo/tutorial videos I've made: Damo 1 -> https://www.youtube.com/watch?v=Ld-mbyAGsow Damo 2 -> https://www.youtube.com/watch?v=1vjlEd2-bJQ The website is here: http://thingiequery.com/ I've already posted about it a week ago, but kinda clumsily so this is a repost (it says in the guide that an occasional repost is fine, so here's one). This is the original post: https://news.ycombinator.com/item?id=9359128 And here is a Reddit thread on the plugin:…
- 1IC
2015 · thingiequery.com
- 2IV
The project is called QueryStorm. It uses Roslyn to offer C# (and VB.NET) support in Excel, as an alternative to VBA. I've posted about it before, but a lot has changed since then so figured I'd share an update. The current version includes a host of new features, namely a C# debugger, support for NuGet packages, and the ability to publish Excel extensions to an "AppStore" (which is essentially a NuGet repository). The AppStore can be used by anyone with the (free) runtime component. Another great addition is the community license, which is a free license for individuals and small companies…
2023 · querystorm.com
- 3IM
2023 · lost-at-sql.therobinlord.com
- 41Y
I have spent large parts of the last 10+ years building an SQL Editor. The tool is targeted at data analysts, a lot of effort has gone into charting, visualizing and excel export. If this sounds useful to you, it's Free, please give it a try and let me know any feedback.
2024 · timestored.com
- 5
- 6
- 7SP
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…
2024 · github.com
- 8UC
Paste in my prompt to Claude Code with an embedded API key for accessing my public readonly SQL+vector database, and you have a state-of-the-art research tool over Hacker News, arXiv, LessWrong, and dozens of other high-quality public commons sites. Claude whips up the monster SQL queries that safely run on my machine, to answer your most nuanced questions. There's also an Alerts functionality, where you can just ask Claude to submit a SQL query as an alert, and you'll be emailed when the ultra nuanced criteria is met (and the output changes). Like I want to know when somebody posts about…
Dec 2025 · exopriors.com
- 9
- 10ST
2014 · blog.treasuredata.com
- 11VS
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…
2022 · animatesql.com
- 12SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021
- 13
- 14QY
Hello HN! I've developed a tool named SheetSQL that allows you to query, join, export, and schedule your queries to Google Sheets through a straightforward SQL interface in the browser. This tool is a simple, first iteration of the idea, so I'm eager to receive feedback on it. You can contact me at taras [at] sheetsql.io :D. I'd love to find out if it could be useful for folks out there! As someone working in fintech, I constantly deal with sheets and often find it challenging to perform seemingly simple tasks like JOINs natively. However, I'm familiar with SQL, which inspired the creation…
2024 · sheetsql.io
- 15WW
2021 · superintendent.app
- 16
- 17EA
Hey Hacker News, Today we're launching Equals. Equals is a spreadsheet with native connections to your SQL databases and data warehouses. You can write SQL right in your spreadsheet. Equals was born out of a shared frustration of me and my co-founder. Despite the avalanche of new data tools over the last decade – nothing actually seemed better than a spreadsheet. Nothing was as flexible, malleable, and as easy to just dive in and play around with some data. In fact, you nearly always ended back in a spreadsheet regardless of what fancy set up you had: when something broke, when a chart in a…
2022
- 18
- 19SO
Inspired by a comment thread yesterday [1] I made this mini site: https://excel.secretgeek.net/ Reason: I often want to share Joel Spolsky's famous "You Suck at Excel" video tutorial with "important" business people inside the large enterprise where I work. But it would be easily misconstrued as trolling if I sent a business customer a URL that literally tells them, right in the heading, that they "suck" at excel. So, as advised by user @TuringTest (in the thread mentioned above) I created a mini site, on its own sub-domain, that is palatable to a business mindset, and…
2019
- 20
- 21
- 22ST
2018 · cirkulate.com
- 23RS
2021 · spanrr.com
- 24IS
2022 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →