ltabb

4 ms·

1.
DuckDB: Prefix aliases make SQL more readable(duckdb.org)
2 points by ltabb 2y ago|0 comments
2.
Malloy 4.0 aims to make a better analytical SQL(malloydata.github.io)
5 points by ltabb 3y ago|2 comments
3.
by ltabb 3y ago
We're on the fourth major revision of Malloy, a data language aiming to replace analytical SQL. Making something that is simple, complete and understandable is really hard. 'Experimental' is no longer in our description.
4.
Data is Rectangular and other Limiting Misconceptions(lloydtabb.substack.com)
2 points by ltabb 4y ago|1 comments
5.
by ltabb 4y ago
In software we express our ideas through tools. In data, those tools think in rectangles. From spreadsheets to the data warehouses, to do any analytical calculation, you must first go through a rectangle. Forcing data through a rectangle
6.
by ltabb 4y ago
Curious about the Malloy Language? Want to try it out with no install? Check out our new Malloy Fiddle. Malloy Fiddle runs entirely in the browser using #DuckDB and WASM. Malloy Fiddle queries semantic data models. See results as tables
7.
Try Malloy's Fiddle: Sequel to SQL (Built with DuckDB and WASM)(looker-open-source.github.io)
2 points by ltabb 4y ago|1 comments
8.
by ltabb 4y ago
If you would like to play with Malloy... You can Fiddle using just a web browser. The Malloy Fiddle uses DuckDB and WASM. https://twitter.com/lloydtabb/status/1567671348306264064
9.
by ltabb 4y ago
Give it a shot. Malloy writes the query in the twitter thread with a single database read. It computes the query, simultaneously at 4 levels of dimensionalization but only touches the disk once. No joins.
10.
by ltabb 4y ago
Try writing this SQL. Malloy writes SQL you can't (I'm pretty sure of it). https://twitter.com/lloydtabb/status/1556287859601985536
11.
by ltabb 5y ago
We're hoping its more of a 'typescript' but yeah :)
12.
by ltabb 5y ago
Sorry, the link to the documentation is buried. https://looker-open-source.github.io/malloy/documentation/la...
13.
by ltabb 5y ago
Scroll to the bottom of the page. It shows the returned JSON https://looker-open-source.github.io/malloy/documentation/pa... Here is the SQL we generate. https://gist.github.com/lloydtabb/8c1
14.
by ltabb 5y ago
> What's nest actually doing? 1) Nesting builds nested results (like GraphQL). This is particularly hard to do in SQL but is allows very large complex data sets to be returned in a single query. https://looker-open-sourc
15.
by ltabb 5y ago
Thanks, that is reasonable feedback. We'll work on updating the documentation. Here is an example of Malloy solving today's worlde in 50 lines of Malloy https://looker-open-source.github.io/malloy/documentati
16.
by ltabb 5y ago
Here is the quick start. https://looker-open-source.github.io/malloy/documentation/la...
17.
by ltabb 5y ago
Actually joins recently landed. Arbitrary patterns and computes aggregates correctly regardless of join patterns. https://looker-open-source.github.io/malloy/documentation/la...
18.
by ltabb 14y ago
Don't waste your time reading crappy articles about crappy startup jobs. Are all startups are the same? Yah Think? In working startupland, you get one bet at a time. pick a winner, make sure you have a ride and stop whining.