Alternatives
Products that do what SQL Window Functions Explained does
Window functions are probably the most confusing part of SQL. You might think, "So what? They just added a few extra functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than anything you know about SELECTs. I've read several dozen articles explaining SQL window functions. They all suffered from one of two problems: (1) Easy read without much practical value, describing 10% of features, or (2) Difficult to comprehend (if I did not know the subject — I would not understand a thing). I wanted people to understand SQL windows…
- 1
- 2SQ
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
- 3
- 4FS
2017 · github.com
- 5
- 6TE
2019 · github.com
- 7
- 8
- 9GA
hi hn, today I'm open sourcing a new SQL-like query language that's built for the web. it has dedicated syntax for request, parsers, selectors, and javascript snippets... it was built on nodejs with the incredible moo lexer and nearley parser. if you're a fan of regular expressions, do I have some code to show you! the website is mostly just a few examples and a playground where you can write & run (& share!) your own queries. there's also an introductory blog post where i try but ultimately fail to justify why this should be its own language and not a library/framework. enjoy!
2024 · getlang.dev
- 10SBSQL Basics▲26
2021 · garden.bradwoods.io
- 11
- 12BY
Build you own query planner guide. I've been developing this guide for some time now, and I'm excited to finally share it with you. This project includes: - a SQL-like language - a fully-functional SQL planner/optimizer - a minimal query executor (for demoing purpose) GitHub: https://github.com/tuannh982/query-planner-guide
2024 · github.com
- 13FW
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:…
2015
- 14IS
Actually, the Q in SQL represents query. The original purpose of inventing SQL is to query (i.e., calculation), which is the main goal of SQL. However, it is hard to say that SQL is very competent when describing computing tasks. Here is an example that is actually not very complicated: calculate the maximum consecutive days that a stock keeps rising. Write it in SQL is like this: select max (consecutive_day) from (select count(*) (consecutive_day from (select sum(rise_mark) over(order by trade_date) days_no_gain from (select trade_date, case when closing_price>lag(closing_price) over(order…
2023 · github.com
- 15DS
I played around with GPT-3 to build this demo. Select a public BigQuery dataset and describe your query in natural English, then edit the generated SQL as needed and execute it. https://app.tabbydata.com/sql-assistant-demo
2021
- 16
- 17
- 18PA
2021 · github.com
- 19IC
2015 · thingiequery.com
- 20UE
Explain Code App works with SQL, a popular language for querying databases. You can tell Explain Code App what you want in plain language, and the app will generate the matching SQL code for you. https://www.explaincode.app
2022
- 21ST
2014 · blog.treasuredata.com
- 22AS
Hi HN, we're Eric and Dean, creators of SchemafreeSQL. Its roots go back to an on-line Web App Development Environment we developed back in 1999. It was comprised of an IDE, Web Server, Object Store, Virtual File System, Template System, and polyglot (Java, JavaScript, and Python). Of course, we named it “.OS”. Then we ended up dropping it. But that's a story for another time. It was the ease of use of the Object Store from .OS that we really missed, which brings us back to SchemafreeSQL. It provides an enhanced API to your SQL Database which allows it to function as a Schemaless…
2022 · schemafreesql.com
- 23EA
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
- 24FS
A minimalistic Fluent SQL API for Java built with one compilation unit aimed to resemble the code to your original SQL code
2013 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →