P5-dbix-admin-createtable

Jul 20, 2023

Create and drop tables, primary indexes, and sequences

DBIxAdminCreateTable is a pure Perl module.

Database vendors supported MySQL, Oracle, Postgres, SQLite.

Assumptions

  • Every table has a primary key
  • The primary key is a unique, non-null, integer
  • The primary key is a single column
  • The primary key column is called ‘id’
  • If a primary key has a corresponding auto-created index, the index is called ‘t_pkey’ This is true for Postgres, where declaring a column as a primary key automatically results in the creation of an associated index for that column. The index is named after the table, not after the column.
  • If a table ‘t’ with primary key ‘id’ has an associated sequence, the sequence is called ‘t_id_seq’ This is true for both Oracle and Postgres, which use sequences to populate primary key columns. The sequences are named after both the table and the column.


Checkout these related ports:
  • Zodb3 - Z - Object Database for python
  • Zodb - Python object-oriented database
  • Zabbix22-libzbxpgsql - Zabbix agent module for comprehensive monitoring of PostgreSQL servers
  • Xtrabackup8 - Open-source backup tool for InnoDB and XtraDB
  • Xtrabackup - OpenSource version of InnoDB backup with support of Percona extensions
  • Xrootd - Framework for fast, low latency, scalable data access
  • Xls2txt - Utilities to convert spreadsheet files to text and csv formats
  • Xapian-core12 - Probabilistic text search database engine
  • Xapian-core10 - Probabilistic text search database engine
  • Xapian-core - Probabilistic text search database engine
  • Xapian-bindings12 - Bindings allowing Xapian to be used from various programming languages
  • Xapian-bindings - Bindings allowing Xapian to be used from various programming languages
  • Wfb2sql - CIA World Fact Book to SQL Conversion Utility
  • Webdis - HTTP interface for Redis
  • Vsqlite - Well designed and portable SQLite3 Wrapper for C++