#sql

Articles tagged with #sql

How To Drop A Postgres Role/User With privileges
Issue: Cannot drop PostgreSQL role. Error: cannot be dropped because some objects depend on it mydatabase=# drop user jack; ERROR: role "jack" cannot be dropped because some objects depend on it DETAIL: owner of view jacktest_view owner of table ja...
Dec 27, 20203 min read155
Connect Postgres Database Using Lambda Function
Use slackbot to send SQS message which trigger lambda function for executing SQL command on database This post focuses on creating SQS queue and lambda function (not how to create a slackbot) ###1. Create SQS queue using CDK (Cloud Development Toolk...
Dec 27, 20203 min read18
SQLPad - Quick Start With Docker
#SQLpad A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Presto, Pinot, Drill, SAP HANA, Snowflake, BigQuery, SQLite, and many others via ODBC. ##Quick st...
Dec 27, 20202 min read141

#sql - Vu Dao