1 month ago · software

create10

sql SELECT utc.table_name, xt.rows_last_45_days FROM SELECT table_name FROM user_tab_columns WHERE UPPERcolumn_name = 'INTERNTIMESTAMP' AND data_type LIKE 'TIME...

1 month ago · software

step2

!Query Filterhttps://media2.dev.to/dynamic/image/width=50,height=50,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2...

1 month ago · software

compare5

SQL Script sql -- Declare variables for schema UIDs run once DECLARE @uid1 int, @uid2 int SELECT @uid1 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_1' SEL...

1 month ago · software

compare4

sql -- First get the user IDs once optional, for readability DECLARE @uid1 int, @uid2 int SELECT @uid1 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_1' SELE...

1 month ago · software

compare3

sql SELECT 'ONLY_IN_US_1' AS location, t1.table_name FROM dba_tables t1 LEFT JOIN dba_tables t2 ON t1.table_name = t2.table_name AND t2.owner = 'GL...

1 month ago · software

compare2

sql SELECT CASE WHEN t1.table_name IS NOT NULL AND t2.table_name IS NULL THEN 'ONLY_IN_US_1' WHEN t2.table_name IS NOT NULL AND...

1 month ago · software

100k TPS over a billion rows: the unreasonable effectiveness of SQLite

Article URL: https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html Comments URL: https://news.ycombin...

1 month ago · software

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

!Cover image for Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differentlyhttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cove...