The JusDB Database Engineering Blog

PostgreSQL views historically executed with the owner's privileges, bypassing row-level security policies. PostgreSQL 15 fixed this with security_invoker views — here's why it matters and how to use it in multi-tenant schemas.

A complete guide to MySQL JSON functions — JSON column type, JSON_EXTRACT and arrow operators, JSON_SET vs JSON_INSERT vs JSON_REPLACE vs JSON_MERGE_PATCH, functional indexes, and multi-valued indexes for arrays.

Use PostgreSQL FDW to query MySQL, S3, MongoDB, and other databases from within PostgreSQL — setup and performance tips

A production guide to PostgreSQL full-text search — building tsvector generated columns, GIN indexes, multi-column search with setweight, ts_rank scoring, websearch_to_tsquery, and comparison against Elasticsearch.

A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.

Explore TiDB distributed SQL database for HTAP workloads. Learn TiKV/TiFlash architecture, MySQL compatibility, horizontal scaling, and deployment strategies.

MySQL's EXPLAIN command reveals exactly how the query optimizer plans to execute your SQL — which indexes it will use, how many rows it expects to examine, and where it may sort or create temporary tables.

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows

Optimize database performance by choosing the right data types and constraints. Learn about VARCHAR vs TEXT, INT sizes, ENUM optimization, and constraint best practices.

Navigate the complex landscape of database technologies. Compare SQL vs NoSQL, OLTP vs OLAP, and learn decision frameworks for selecting the perfect database for your use case.

MySQL 8.0 significantly improved geospatial support with SRID-aware columns, spatial reference systems, and accurate geographic distance calculations. Here's how to use it in production.

Learn the fundamental principles of database schema design for building scalable applications. This guide covers entity relationships, primary keys, foreign keys, and normalization concepts essential for high-performance databases.