Implementing the ST_PointN GIS Function in OceanBase ActionDB

This article explains how the ActionDB team extended OceanBase by designing, registering, and implementing the ST_PointN function to extract the N‑th point from geometry objects, covering registration metadata, code integration, algorithm details, and the advantages of a custom GIS function for enterprise databases.

ActionDBDatabase FunctionsGIS

0 likes · 11 min read

Implementing the ST_PointN GIS Function in OceanBase ActionDB

Su San Talks Tech

Dec 19, 2022 · Databases

Master MySQL: 14 Essential Functions and Commands Every Developer Should Know

This article walks through a collection of practical MySQL techniques—including group_concat, char_length, locate, replace, now, insert‑select variations, pessimistic locking, on duplicate key update, show create table, explain, processlist, and mysqldump—illustrated with SQL examples and screenshots to help developers efficiently query, manipulate, and maintain their databases.

Database Functionsdata manipulationmysql

0 likes · 13 min read

Master MySQL: 14 Essential Functions and Commands Every Developer Should Know

MaGe Linux Operations

Jul 9, 2014 · Databases

SQL Server vs Oracle: 45 Essential Function Equivalents

This article presents a comprehensive side‑by‑side mapping of 45 common SQL Server functions to their Oracle equivalents, covering numeric, string, date, and miscellaneous operations with example queries and notes on usage differences.

Data MigrationDatabase FunctionsOracle

0 likes · 16 min read

SQL Server vs Oracle: 45 Essential Function Equivalents