Viewing profile — exagolo

I believe Karma solely comes from upvotes for comments minus downvotes. Submissions don't count.

In case you have a single table with time-series data, then Clickhouse will perform typically better. It's very much optimized for this type of use cases. Once you are joining tabl…

I think the issue in the tests was the lack of a proper resource management of Clickhouse that led to queries failing under pressure. Although I have to admit that the level of pre…

You mean the "execution plan" for your queries? Ideally, those types of decisions are automatically done by the database.

Traditional database benchmarks focus on throughput and latency – how many queries per second can be processed, how execution time changes as hardware resources increase. This benc…

The tool is very flexible and you can create your own benchmarks with your own data. This is always the best benchmark, as any public benchmark will have a certain bias.

Another alternative is Exasol that is factors (>10x) faster than Clickhouse and scales much better for complex analytics workloads that joins data. There is a free edition for pers…

For the bigger tasks, Exasol might also be a very neat option for you. We have a free personal edition that can scale regarding data volumes, #servers (MPP architecture) and comple…

If not having to adjust queries is a major driver for your considerations, then I would highly recommend looking at SQLGlot ( https://github.com/tobymao/sqlglot ), a transpiler tha…

Are you using a transpiler technology such as SQLGlot for the multi-vendor SQL generation?

I do agree. I still think that the article articulates a very interesting thought... the better the input for a problem, the better the output. This applies both to LLMs but also f…

When people complain about large language models, I often feel like they're complaining about their coworkers without realizing it...

Agreed, and it's an amazingly well-maintained GitHub repo: https://github.com/tobymao/sqlglot Big kudos to Toby and the team.

I do agree. SQL is simply an access API for so many systems, and nice as it's a declarative language rather than a normal programming language. LLMs are super powerful to express q…

For translation between dialects, you could use projects such as SQLGlot. The advantage of SQL is the standardization over many decades (yes, I know that it's still a mess with the…

MariaDB Exa is engineered for extreme scale, complex queries and high performance on multi-terabyte datasets. This approach ensures every MariaDB customer has the right analytical …