Advanced Relational Database | MySQL ထက် powerful, production-grade
PostgreSQL vs MySQL, install, psql CLI, pgAdmin
CREATE TABLE, PG types, constraints, sequences
SELECT, WHERE, JOINs, LIMIT, OFFSET, ORDER BY
Built-in functions, GROUP BY, HAVING, subqueries
CREATE INDEX, EXPLAIN, BEGIN/COMMIT/ROLLBACK
node-postgres, pool, queries, prepared statements
PL/pgSQL, CREATE FUNCTION, CREATE PROCEDURE, loops, exception handling
BEFORE/AFTER triggers, auto-timestamps, audit log table, data validation
Feature PostgreSQL MySQL ----------- --------------- --------------- License Open Source (BSD) Open Source + Oracle JSON support JSONB (fast, indexed) JSON (basic) Full text Built-in tsvector Requires config Arrays Native ARRAY type Not native Window functions Yes (advanced analytics) Limited Sequences SERIAL / BIGSERIAL AUTO_INCREMENT Case sensitive "TableName" matters tablename = TABLENAME Default port 5432 3306 -- PostgreSQL syntax sample SELECT u.name, COUNT(o.id) AS orders FROM users u LEFT JOIN orders o ON o.user_id = u.id GROUP BY u.name HAVING COUNT(o.id) > 5 ORDER BY orders DESC LIMIT 10;