carlineng

8 ms·

31.
by carlineng 4y ago
My hope with the post is to convince you that both the syntax and semantics of Malloy are more than just different, and indeed are actually better. In the article, the SQL example results in output that cannot be used safely by downstream q
32.
Why SQL syntax sucks, and why it matters(carlineng.com)
1 points by carlineng 4y ago|4 comments
33.
by carlineng 4y ago
This blog post looks at SQL from the lens of data analysis, and provides a concrete example where it is seriously problematic.
34.
by carlineng 4y ago
The post itself provides a very real example of a flaw with the SQL language beyond simple aesthetics. Namely, that typical SQL queries only represent data in rows and columns, yet data and queries are often multidimensional. Any query that
35.
by carlineng 4y ago
This is a follow up to my last post comparing SQL to the new Malloy query language, and a response to some of the HN commentary I received around it.
36.
Why SQL syntax sucks, and why it matters(carlineng.com)
3 points by carlineng 4y ago|7 comments
37.
by carlineng 4y ago
My last submission [0] generated some interesting discussion that motivated me to think a lot more about exactly why SQL's syntax is problematic. This post explores that idea in more depth. [0]: https://news.ycombinator.com&
38.
SQL and the Pernicious Effects of Awkward Syntax(carlineng.com)
2 points by carlineng 4y ago|1 comments
39.
by carlineng 4y ago
To help understand the results of the benchmark, I find it helpful to look at how the benchmark is constructed, and what it tests for. From the README: "The dataset is represented by one flat table. This is not representative of classi
40.
by carlineng 4y ago
> I remember Tim Cook said they are not in the Ads Business. Unfortunately I am too busy, Apple's PR has worked hard to delete those tracks of what Tim Cook said, or Google's search engine is longer showing what I am looking fo
41.
by carlineng 4y ago
<img> tags use the loading="lazy" property which doesn't actually load the image until it's displayed. Everything else is just text, which is super tiny. https://github.com/cadars/john-doe&#x2F
42.
by carlineng 4y ago
I really like the John Doe template. Everything is in one HTML file and one CSS file: https://github.com/cadars/john-doe/ From the readme: “This setup is databaseless, javascriptless, and buildshit-free, so you ca
43.
by carlineng 4y ago
I would categorize it differently. Rather than just objecting to their policy, he is describing a reason why current policies are suboptimal, and suggesting ways that current policies could be improved. Namely, that domestic central banks a
44.
by carlineng 4y ago
Just to name a few off the top of my head -- - Data type mismatches between systems - Differences in handling ambiguous or bad data (e.g., null characters) - Handling backfills - Handling table schema changes - Writing merge queries to hand
45.
by carlineng 4y ago
I wonder if the underlying technology is from their acquisition of Alooma [1] several years back. High volume change data capture from an OLTP database to a data warehouse is a problem that seems simple on its face, but has a lot of nasty e
46.
by carlineng 4y ago
I've written about this topic a fair amount; first examining some of the criticisms of SQL that have been present since the language's inception [1], then looking at a new project called Malloy that I'm quite excited about, a
47.
by carlineng 4y ago
Aesthetics are largely subjective. Even though I like Malloy syntax better than SQL syntax, the majority of the actual post is dedicated to reasons above and beyond syntax that I think Malloy has promise; specifically, its integration of a
48.
by carlineng 4y ago
Nope, those are the primary components of a semantic layer. Most other semantic layer products have three main components: input data sources -- typically SQL queries or table names, configuration -- the semantic layer describing all the th
49.
by carlineng 4y ago
PRQL is very cool, but I think Malloy is meaningfully different (and more useful) because of its inclusion of a semantic layer into the core language.
50.
by carlineng 4y ago
I think Malloy is meaningfully different from previous attempts (e.g., PRQL), and describe why in the post, namely the inclusion of a semantic layer as part of the language. Take a look at the post, and would love to hear if you agree or no
51.
by carlineng 4y ago
My musings on why SQL has been so hard to displace, and what it might take to do so. Any and all feedback appreciated!
52.
A sequel to SQL? An intro to Malloy(carlineng.com)
117 points by carlineng 4y ago|117 comments
53.
by carlineng 4y ago
Author here. Fixed the mistake. You may now proceed with reading the remainder of the post ;)
54.
Optimizing the Snowflake Query Optimizer(hoffa.medium.com)
2 points by carlineng 4y ago|0 comments
55.
A Critique of SQL, 40 Years Later(carlineng.com)
1 points by carlineng 4y ago|0 comments
56.
by carlineng 4y ago
[Disclaimer: former Snowflake employee] Snowflake is not expensive because of perverse incentives, which is the primary claim of the article. It is expensive because it is a highly differentiated and very sticky product. As others have ment
57.
by carlineng 4y ago
Clinical trials for cancer treatment rarely use placebos. Instead, the control group is the current standard of care: https://www.cancer.net/research-and-advocacy/clinical-trials...
58.
by carlineng 4y ago
For businesses where a significant percentage of customer LTV is in the expand phase, I'm surprised it's not more commonplace to have AEs take on the role of customer success. The AE usually has a lot of context about the customer
59.
by carlineng 4y ago
MIT OpenCourseware: https://www.youtube.com/c/mitocw Yale Courses: https://www.youtube.com/user/YaleCourses
60.
by carlineng 4y ago
Radiolab did an episode profiling Jure Robič [1], a former member of the Slovenian special forces who took up ultra-endurance cycling and won RAAM 5 times. It's a mind-boggling story. Tragically, Jure was killed by a car while training

More ›