Partition
Rudy DROP TABLE IF EXISTS sales CASCADE; -- Create parent table with partitioning CREATE TABLE sales ( id bigint NOT NULL GENERATED ALWAYS AS IDENTITY, sale_date DATE NOT NULL, amount NUMERIC(10,…
Rudy
Calendar Basic
-- Use or create database (adjust as needed) -- \c test; DROP TABLE IF EXISTS calendar_basic; CREATE TABLE calendar_basic ( date_id INT NOT NULL PRIMARY KEY, full_date DATE NOT NULL,…
Logical
After
Loop over PostgreSQL Tables
The following script loops over some PostgreSQL tables and grabs row counts
Attach Drive in OCI
# Mount a disk in OCI The following command mounts a disk in Oracle Cloud Infrastructure (OCI): https://docs.oracle.com/en-us/iaas/Content/Block/Tasks/connectingtoavolume_topic-Connecting_to_iSCSIAttached_Volumes.htm ## Mounting commands via iscsiadm The following commands are found in the…
Move PostgreSQL Data Directory and Config Files
The following code is used to move the PostgreSQL data directory to a new directory.
Davinci Resolve Tables
The following tables were populated by Davinci Resolve after 2 sample projects: schema_name table_name row_count public database_upgrade_log 127 public Gallery::GyMemView_Gallery::GyStillRef 78 public Gallery::GyStillRef 78 public Sm2TiItem 9 public Sm2TiItem_Sm2TiTrack 9…
Running Sysbench on MySQL
The following script is used to run sysbench on MySQL
Enable CRB and EPEL in Oracle Linux
Installing EPEL and the Code Ready Builder on Oracle Linux 8 / Oracle Linux 9 After working with Oracle Linux for a while, I had to install EPEL and the…
Jetbrains vs DBeaver
Firstly, DataGrip provides a more robust and user-friendly interface tailored specifically for SQL developers. It offers advanced code completion, on-the-fly analysis, and quick-fixes, which can significantly reduce the time spent…