Sequence | BestHub

Aikesheng Open Source Community

Oct 11, 2023 · Databases

Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle

This article demonstrates two practical approaches for handling MySQL auto‑increment columns during migration to OB Oracle—creating custom sequences with DBCAT and using the GENERATED BY DEFAULT AS IDENTITY attribute—provides step‑by‑step commands, scripts, and validation results to help DBA engineers achieve seamless primary‑key migration.

DataXDatabaseMigration

0 likes · 16 min read

Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle

JD Retail Technology

Sep 26, 2023 · Databases

How Vitess Generates Global Unique IDs Using Sequence Tables and a Comparison with VtDriver

The article explains Vitess's approach to generating globally unique identifiers by using dedicated sequence tables, details the underlying MySQL schema and Go implementation, and compares it with VtDriver's CAS‑based method, highlighting trade‑offs between transaction locks and lock‑free updates.

CASDistributed DatabaseGlobal ID

0 likes · 10 min read

How Vitess Generates Global Unique IDs Using Sequence Tables and a Comparison with VtDriver

Aikesheng Open Source Community

Jun 5, 2023 · Databases

Creating Auto‑Increment Columns in OceanBase Oracle Tenant (OBOracle) – Four Methods

This article explains why AUTO_INCREMENT is unsupported in OceanBase Oracle tenants, introduces four practical ways to implement auto‑increment columns using sequences, DML, DDL, triggers, and the GENERATED BY DEFAULT AS IDENTITY syntax, and provides step‑by‑step SQL examples for each method.

OceanBaseOracleSQL

0 likes · 11 min read

Creating Auto‑Increment Columns in OceanBase Oracle Tenant (OBOracle) – Four Methods

Qunar Tech Salon

Sep 6, 2021 · Databases

Comparison of Sequence Usage Across Oracle, PostgreSQL, and MySQL

This article examines how Oracle, PostgreSQL, and MySQL implement and use database sequences for primary keys, covering explicit calls, trigger‑based, DEFAULT, and AUTO_INCREMENT methods, version support, and the effects of INSERT, UPDATE, DELETE, and TRUNCATE operations, concluding with a comparative summary.

DatabaseMySQLOracle

0 likes · 30 min read

Comparison of Sequence Usage Across Oracle, PostgreSQL, and MySQL

Full-Stack Internet Architecture

Aug 17, 2020 · Databases

Understanding MySQL AUTO_INCREMENT Sequences and Their Behavior

This article explains how MySQL's AUTO_INCREMENT generates unique identifiers, the constraints on its use, how deletions affect the sequence, the role of LAST_INSERT_ID in concurrent environments, and best practices for managing auto‑increment columns in InnoDB tables.

DatabaseMySQLSQL

0 likes · 8 min read

Understanding MySQL AUTO_INCREMENT Sequences and Their Behavior

JD Retail Technology

Aug 15, 2019 · Backend Development

Simple and Advanced Approaches to Order Number Generation Using Database Sequences

This article explains how to implement order number generation services by first using a simple auto‑increment‑based database table and then a more sophisticated segment‑allocation method that reduces database load, with detailed SQL and Java code examples and transaction‑handling advice.

BackendDatabaseDistributed

0 likes · 8 min read

Simple and Advanced Approaches to Order Number Generation Using Database Sequences

Sohu Tech Products

Jul 17, 2019 · Fundamentals

Understanding Swift Sequence and Collection Protocols: From Basics to Advanced Types

This article explains Swift's protocol‑oriented collection system, covering the Sequence and IteratorProtocol basics, demonstrating custom infinite sequences, exploring type‑erasing wrappers like AnySequence and AnyIterator, and detailing the Collection hierarchy including Collection, BidirectionalCollection, RandomAccessCollection, MutableCollection and RangeReplaceableCollection.

AnySequenceBidirectionalCollectionCollection

0 likes · 12 min read

Understanding Swift Sequence and Collection Protocols: From Basics to Advanced Types