1. Major developments in the technical communitymysqlwill be supportedj**ascriptfunction andStored procedures
InDatabasesTechnical field,OracleAnnouncedmysqlDatabasesThe server will introduce the pairj**ascriptThis news has attracted a lot of attention in the technical community. This means:mysqlwill be implemented toj**ascriptWrite functions andStored proceduresfunction, and thus withpostgresqletcDatabasesPlatforms go hand in hand. mysqlThis initiative is an important milestone for the developer community.
Previously,postgresqlIt has been supported since 2012 with its PLV8 extensionj**ascript。This feature enables developers to:DatabasesImplement more advanced data processing logic within the reductionDatabasesData movement to and from applications, resulting in improved performance and efficiency. Whilemysqlsupportj**ascriptfunction andStored proceduresThe decision ismysqlCatch up in this regardpostgresqlimportant steps.
Currently,mysqlofj**ascriptSupport features are only available inmysqlEnterprise Edition andmysqlheatw**e and in preview. This means that this feature is still being optimized and improved.
mysqlofj**ascriptSupport will be based on the ECMASCRIPT 2021 standard and will include integersFloating-point numbersand charvarchartype. In addition,mysqlj**ascriptThe integration uses a custom-built oneVirtual machines(VM), designed for this use case to achieve the best end-to-end performance.
mysqlj**ascriptAt the heart of the integration is a custom build based on GraALVMVirtual machines。GraalVM is a runtime platform that includes:jdk, various language implementations (egj**ascript、r、python, Ruby and J**A), etc. It is a hostingVirtual machineswith sandbox functionality and tool support. mysqlofj**ascriptSupport for early compilation (AOT) using Graalvm, that is, the language implementation is compiled locallyBinaryrepresentation, allowing for fast processing.
It should be noted thatmysqlThe Community Edition is not available at this timej**ascriptIn the tank. Currently onlymysqlEnterprise Edition andmysqlThis feature is available in heatw**e. This also means that the free use of this new feature is somewhat limited.
For the sake of showingmysqlj**ascriptTo support practical applications, Oracle has released severalmysqlheatw**e**, which demonstrates how to take advantage of itj**ascriptThe stored program runsmustachelibraries, validating web form inputs, or processing webURLs, etc. These cases further demonstrate the usefulness and potential use of the new features.
By inDatabasesPerformed internallyj**ascriptfunction andStored procedures, developers can reduceDatabasesData movement to and from applications, reducing latency, network overhead, and egress costs. This is especially important for applications that require real-time processing of large amounts of data.
The new features enable developers to:Databasesmore advanced data processing logic. Passedj**ascriptmakes it easier for developers to process, transform, and compute data, improving the performance and flexibility of their applications.
mysqlIntroducedj**ascriptfunction andStored proceduresSupport is:DatabasesAn important development in the field of technology. The implementation of this feature will enable developers toDatabasesImplement more advanced data processing logic within the reductionDatabasesMovement of data to and from applications, thereby improving the performance and efficiency of applications. AlthoughmysqlSlightly later in this regardpostgresql, but this pace proves itmysqlInDatabasesThe strength of the technology competition and meets the needs of the developer community with the times. We can expect as this feature is further rolled out and refinedDatabasesFurther development and innovative application of technology. mysqlofj**ascriptSupport will bring more possibilities and convenience to developers, and provide strong support for business innovation and growth.