followSPL

10 ms·

1.
HP misses first-quarter revenue estimates on sluggish demand in PC market(reuters.com)
2 points by followSPL 3y ago|0 comments
2.
Toyota recalling 381,000 Tacoma pickups because parts can fall off rear axles(apnews.com)
8 points by followSPL 3y ago|0 comments
3.
Google steps up Microsoft criticism, warns of rival's monopoly in cloud(reuters.com)
1 points by followSPL 3y ago|1 comments
4.
by followSPL 3y ago
Replacing SQL and stored procedure to develop business logic in Java in the microservices system can indeed gain framework advantages, but the development complexity is not “micro” at all. Java lacks the computational capability of structur
5.
by followSPL 3y ago
For example, there are three statements in the stored procedure, which are roughly like this, and execute very slowly: select a,b,sum(x) from T group by a,b where …; select c,d,max(y) from T group by c,d where …; select a,c,avg(y),min(z) fr
6.
by followSPL 3y ago
Many big data calculations are implemented in SQL. When running slowly, we have to optimize SQL, but we often encounter situations that we can do nothing about it.
7.
Show HN: The impasse of SQL performance optimizing(medium.com)
2 points by followSPL 3y ago|2 comments
8.
by followSPL 3y ago
Thank you for your reply,It's a pleasure to discuss it with you.We are not only discussing the query side of SQL (DML), it is the essence of SQL, relational algebra, and the examples in the post are just for a more intuitive representa
9.
by followSPL 3y ago
Thanks for your reply, SQL is really good,but nothing in the world is perfect, technology is even more so, society is developing, always need the emergence of new technology, since dare to say so, must have done research to study, and SPL h
10.
by followSPL 3y ago
Let’s start with an example to explain why it’s difficult to write in SQL: calculate the maximum consecutive days that a stock keeps rising. SELECT MAX(ContinuousDays) FROM (SELECT COUNT(*) ContinuousDays FROM (SELECT SUM(UpDownTag) OVE
11.
by followSPL 3y ago
No, it's the open source SPL above This is where SPL comes from. Its theoretical basis is no longer the relational algebra, but something called discrete dataset. The formal language designed based on this new algebra is named SPL (str
12.
by followSPL 3y ago
Maybe you think it's bad, that's okay, give some good advice
13.
by followSPL 3y ago
New technology will always face various controversies, I hope to see more suggestions
14.
Show HN: A new programming language stronger than SQL, Java, and Python?(github.com)
2 points by followSPL 3y ago|6 comments
15.
by followSPL 3y ago
Thank you for your reply,It's a pleasure to discuss it with you.We are not only discussing the query side of SQL (DML), it is the essence of SQL, relational algebra, and the examples in the post are just for a more intuitive representa
16.
by followSPL 3y ago
esProc SPL is a data analysis engine with four main characteristics: low code, high performance, lightweight and versatility. To be specific, SPL allows you to write simply, and makes the running speed faster; SPL can be used either indepen
17.
by followSPL 3y ago
Only new technology can promote the development of human society
18.
by followSPL 3y ago
Thank you for your attention, there are many more examples like this 》example 1:List the last login interval for each user SQL: WITH TT AS (SELECT RANK() OVER(PARTITION BY uid ORDER BY logtime DESC) rk, T.* FROM t_loginT) SELECT uid,(SELEC
19.
by followSPL 3y ago
Yes, you are right. everything belongs to its appropriate scenario. SQL is not good at some complex situation.There are many examples to prove this. Check out this article if you are interested. https://blog.scudata.com/spl-
20.
by followSPL 3y ago
Ships are safe when they're docked, but that's not what they're built for
21.
by followSPL 3y ago
Only new technology can promote the development of human society
22.
by followSPL 3y ago
esProc SPL is a data analysis engine with four main characteristics: low code, high performance, lightweight and versatility. To be specific, SPL allows you to write simply, and makes the running speed faster; SPL can be used either indepen
23.
Show HN: It's been nearly 50 years. Is SQL outdated?(github.com)
5 points by followSPL 3y ago|12 comments
24.
by followSPL 3y ago
we conduct a comparative test on ClickHouse (CH for short) and Oracle database (ORA for short) under the same hardware and software environment, and use the internationally recognized TPC-H as the test benchmark. The test is to execute the