Creating a MySQL connector project written in pure Scala3.

[takapi327]

Implementation Details

Creating a MySQL connector project written in pure Scala3.

JVM, JS and Native platforms are all supported.

Related pull requests

• Feature/2024 01 create ldbc connector project #128
• Feature/2024 02 create statement for select query #134
• Updating Documents #146
• Enhancement/2024 03 add database login #157
• Feature/2024 03 create prepared statement #158
• Feature/2024 03 Create Server PreparedStatement #159
• Feature/2024 03 create transaction #167
• Feature/2024 03 create savepoint #173
• Refactor/2024 03 fix com init db #177
• Feature/2024 03 add com statistics utility commands #180
• Feature/2024 04 add com ping utility commands #181
• Feature/2024 04 add com reset connection utility commands #182
• Feature/2024 04 add com set option utility commands #183
• Feature/2024 04 add com change user utility commands #184
• Feature/2024 04 add batch command #186

Supported Platforms

Module / Platform	JVM	Scala Native	Scala.js
ldbc-connector	✅	✅	✅

Function Development

• Implementation of Authentication Function
  • mysql_native_password support
  • sha256_password support
  • caching_sha2_password support
• SSL/TLS support
• RSA authentication method support
• Establish connection specifying database
• Codec
  • Encoder
  • Decoder
• Execute query
  • Statement
    • Read query execution
    • Execute write query
    • Decode acquisition records
  • PreparedStatement in Client
    • Building a query
    • Encoding of sent values
    • Read query execution
    • Execute write query
    • Decode acquisition records
  • PreparedStatement in Server
    • Encoding of sent values
    • Read query execution
    • Execute write query
    • Decode acquisition records
• Transaction function implementation
  • Read Only setting function
  • Auto Commit setting function
  • Transaction isolation level setting function
  • Commit function
  • Rollback function
  • Savepoint function
• Utility Commands
  • COM_QUIT
  • COM_INIT_DB
  • COM_STATISTICS
    - [ ] COM_DEBUG
  • COM_PING
  • COM_CHANGE_USER
  • COM_RESET_CONNECTION
  • COM_SET_OPTION
• Batch commands
• Connection pooling implementation

Supported DetaType

DataType	Support
BIT	✅
TINYINT	✅
SMALLINT	✅
MEDIUMINT	✅
INT	✅
BIGINT	✅
DECIMAL	✅
FLOAT	✅
DOUBLE	✅
CHAR	✅
VARCHAR	✅
BINARY	✅
VARBINARY	✅
TINYBLOB	✅
BLOB	✅
MEDIUMBLOB	✅
LONGBLOB	✅
TINYTEXT	✅
TEXT	✅
MEDIUMTEXT	✅
LONGTEXT	✅
ENUM	✅
SET	✅
JSON	✅
DATE	✅
DATETIME	✅
TIMESTAMP	✅
TIME	✅
YEAR	✅
BOOLEAN	✅
GEOMETRY	❌
POINT	❌
LINESTRING	❌
POLYGON	❌
MULTIPOINT	❌
MULTILINESTRING	❌
MULTIPOLYGON	❌
GEOMETRYCOLLECTION	❌

Other

• Documentation Creation
• Performance Verification
  • Comparison with JDBC
  • Comparison with other MySQL Scala libraries
  • Verification of operation in AWS and other infrastructure environments

References

Porting of the following repository functions.
https://github.com/takapi327/scala-jvm-js-native-example