search

taosdata / TDengine

High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios
https://tdengine.com
GNU Affero General Public License v3.0
23.39k stars 4.86k forks source link

PL/SQL support by TDengine #28520

Closed wgong closed 17 hours ago

wgong commented 2 weeks ago

As someone with extensive Oracle background, I believe PL/SQL support would be a significant enhancement to TDengine's capabilities, particularly due to its superior performance compared to language-specific UDFs. I'd like to present a specific use case from financial services to illustrate the value:

Currently, we use the Python TA-Lib library for End-of-Day stock analysis. While this works well for daily data, we see an opportunity to leverage TDengine for high-performance intraday trading analysis across hundreds or thousands of stocks in near real-time. The C implementation of TA-Lib would be ideal for this purpose.

I have two specific questions:

1) In the absence of full PL/SQL support, what would be the recommended approach to integrate C-library functions (like TA-Lib) as custom SQL functions in TDengine? 2) Has similar integration work been done before? If so, could you share the architectural approach and implementation examples?

As TDengine is open-source, the community could potentially contribute to this implementation, given proper technical guidance from your team.

yu285 commented 5 days ago

hi sorry for delay response . May I know this first :

what is the relationship between PL/SQL and TA-Lib ?

can you share the most typical business application scenario that they work together?

yu285 commented 17 hours ago

close this issue temporarily ， until get response from you.